Estadísticas

ASISTENCIAS
Matheus Pereira7
Stoichkov6
Álvaro Tejero5
Cristian4
Mario Soriano4
Ager Aketxe4
José Corpas3
Arana3
J. Ríos2
Jon Bautista2
Unai Vencedor2
Sergio León1
Yanis Rahmani1
Peru Nolaskoain1
ENTRA
Unai Vencedor21
Sergio León19
Yanis Rahmani15
José Corpas13
J. Yriarte13
Konrad13
Cristian11
Sergio Álvarez9
J. Ríos9
Yacine Qasmi8
F. Venâncio7
Jon Bautista7
Quique González6
Ager Aketxe6
Ángel Troncho6
Arana5
Peru Nolaskoain4
Mario Soriano3
Álvaro Tejero2
A. Arbilla2
A. Madariaga2
Rober Correa1
Stoichkov1
Iker Alday1
Matheus Pereira1
Stefan Simič1
SALE
Arana25
Mario Soriano23
Stoichkov22
Jon Bautista18
Ager Aketxe17
José Corpas14
Yanis Rahmani12
Cristian12
Unai Vencedor9
Matheus Pereira7
Quique González7
Sergio León6
J. Ríos5
Peru Nolaskoain4
Álvaro Tejero3
F. Venâncio3
A. Arbilla3
Juan Berrocal2
Ángel Troncho2
Sergio Álvarez2
J. Yriarte1
Konrad1

  USO DE MEMORIA  
5,595,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3106
Total Execution Time  0.3118
  CADENA URL  
/estadisticas/Eibar
  GET DATOS  
$_GET['/estadisticas/Eibar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=957 AND type_rel = 2
0.0234  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.0117  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.0163  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.0161  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=957 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0115  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (75879,72177,71842,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 72177 AND teamId = 957
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 75879 AND teamId = 957
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 71842 AND teamId = 957
0.0208  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 957
0.0129  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.0133  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.0137  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.0127  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