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

Estadísticas

ASISTENCIAS
Matheus Pereira7
Stoichkov6
Álvaro Tejero6
Ager Aketxe4
Cristian4
Mario Soriano4
Arana3
José Corpas3
Unai Vencedor2
J. Ríos2
Jon Bautista2
Peru Nolaskoain1
Sergio León1
Yanis Rahmani1
ENTRA
Unai Vencedor22
Sergio León20
Yanis Rahmani15
J. Yriarte15
Konrad14
José Corpas14
Cristian11
Sergio Álvarez10
J. Ríos9
Yacine Qasmi8
Jon Bautista7
F. Venâncio7
Ager Aketxe6
Ángel Troncho6
Quique González6
Arana5
Peru Nolaskoain4
Mario Soriano3
A. Madariaga2
Álvaro Tejero2
A. Arbilla2
Matheus Pereira1
Stefan Simič1
Rober Correa1
Stoichkov1
Iker Alday1
SALE
Arana27
Mario Soriano24
Stoichkov23
Jon Bautista19
Ager Aketxe18
José Corpas14
Cristian12
Yanis Rahmani12
Unai Vencedor9
Matheus Pereira7
Quique González7
Sergio León6
J. Ríos5
Álvaro Tejero4
Peru Nolaskoain4
A. Arbilla3
F. Venâncio3
Ángel Troncho2
Sergio Álvarez2
Juan Berrocal2
J. Yriarte1
Konrad1

  USO DE MEMORIA  
5,557,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2470
Total Execution Time  0.2482
  CADENA URL  
/estadisticas/Eibar
  GET DATOS  
$_GET['/estadisticas/Eibar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=957 AND type_rel = 2
0.0197  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 957 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (213,435,497,548,583) ORDER BY n.cover_points DESC, update_date DESC
0.0141  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 = '957' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0159  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 957 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 957 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 957 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 957 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 957 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 957 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30