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

Estadísticas

ASISTENCIAS
Roger Martí3
Javi Hernández2
G. Escalante2
Iván Alejo2
Sergi Guardiola1
Victor Chust1
Rubén Alcaraz1
Robert Navarro1
Rubén Sobrino1
Chris Ramos1
ENTRA
Sergi Guardiola18
Maxi Gómez14
Rubén Sobrino13
Álex Fernández12
Lucas Pires11
B. Ocampo10
Darwin Machís10
R. Kouamé7
Chris Ramos7
G. Escalante7
Á. Negredo7
Iván Alejo6
Roger Martí4
Robert Navarro4
J. Zaldua4
José Mari3
D. Samassékou3
Momo2
Iza2
Juanmi2
Jorge Meré2
Aiham Ousou1
Javi Hernández1
Etta Eyong1
Luis Hernández1
F. San Emeterio1
M. Osmajić1
David Gil1
M. Diakité1
SALE
Iván Alejo18
Robert Navarro16
Chris Ramos16
Maxi Gómez12
Roger Martí12
Rubén Sobrino11
G. Escalante9
Darwin Machís8
Rubén Alcaraz7
Álex Fernández6
R. Kouamé6
Juanmi5
Jorge Meré5
Fali5
Iza4
J. Zaldua4
F. San Emeterio3
Javi Hernández3
Victor Chust3
Conan Ledesma1
Lucas Pires1
Sergi Guardiola1

  USO DE MEMORIA  
5,765,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0718
Total Execution Time  0.0730
  CADENA URL  
/estadisticas/Cadiz
  GET DATOS  
$_GET['/estadisticas/Cadiz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0039  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73400
0.0077  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 603 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1312499,653,773,775,782) ORDER BY n.cover_points DESC, update_date DESC
0.0047  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '603' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0041  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 603 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 603 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 603 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30