4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
8,391,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0008
Controller Execution Time ( Popular / Index )  0.2894
Total Execution Time  0.2902
  CADENA URL  
/popular
  GET DATOS  
$_GET['/popular']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0112  SELECT COUNT(rb.id) AS total FROM rel_budgets AS rb INNER JOIN news AS n ON rb.new_id=n.id WHERE rb.year=2014 and rb.active=1 and rb.certified=1
0.0124   SELECT b.id AS budget_id, b.budget_type, b.official_budget, b.date AS date_budget, b.valor, n.id, n.title, n.teaser, n.body, n.creation_date, n.karma, n.votes_up, n.totalcomments, n.alias, n.cover, n.views, n.author_id, dp.id AS player_id, dp.nick AS player_nick, dp.alias AS player_alias, dp.CountryCode, dp.role AS player_role, dto.id AS origin_team_id, dto.nameShow AS origin_team_name, dto.basealias AS origin_team_alias, dtd.id AS destination_team_id, dtd.nameShow AS destination_team_name, dtd.basealias AS destination_team_alias, u.user_name, p.title AS picture_title, p.id AS picture_id, p.author_id AS picture_author_id, v.title AS video_title, v.id AS video_id, v.author_id AS video_author_id FROM news AS n INNER JOIN rel_budgets AS b ON n.id=b.new_id INNER JOIN dataplayers AS dp ON b.player_id=dp.id LEFT JOIN datateams AS dto ON b.origin_team_id=dto.id LEFT JOIN datateams AS dtd ON b.destination_team_id=dtd.id INNER JOIN fa_user_mini AS u ON n.author_id=u.id LEFT JOIN pictures AS p ON n.picture_content_id=p.id LEFT JOIN videos AS v ON n.video_content_id=v.id WHERE n.content_type=3 AND b.year=2014 and b.active=1 and b.certified=1 ORDER BY n.id DESC LIMIT 10
0.0128   SELECT dt.id as teamId, t.id as id, dt.nameShow as name, dt.basealias as alias, c.name as category_name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.`id`=t.`teamId` INNER JOIN `leagues` as l ON l.id=t.`league_id` INNER JOIN `categories` as c ON l.`categoryId`=c.`id` WHERE c.`alias` LIKE 'primera' AND l.`year`='2024'
0.0131   SELECT dt.id as teamId, t.id as id, dt.nameShow as name, dt.basealias as alias, c.name as category_name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.`id`=t.`teamId` INNER JOIN `leagues` as l ON l.id=t.`league_id` INNER JOIN `categories` as c ON l.`categoryId`=c.`id` WHERE c.`alias` LIKE 'segunda' AND l.`year`='2024'
0.1210  SELECT c.id, c.name, l.group_code, l.total_group, c.CountryCode, c.alias , c.transfer_market FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId WHERE l.year=c.active_year AND c.troncal=1 GROUP BY c.id ORDER BY c.coefficient DESC, c.name ASC
0.0106  SELECT * FROM topics ORDER BY priority ASC