Estadísticas

ASISTENCIAS
A. Grimaldo12
Florian Wirtz10
V. Boniface8
J. Frimpong7
J. Hofmann6
Amine Adli4
E. Palacios4
N. Amiri3
Robert Andrich2
Nathan Tella2
P. Hincapié1
Noah Mbamba1
E. Tapsoba1
Patrik Schick1
Jonathan Tah1
ENTRA
Adam Hložek18
Nathan Tella15
Amine Adli14
Robert Andrich10
N. Amiri7
P. Hincapié7
Patrik Schick6
J. Hofmann5
E. Tapsoba5
Josip Stanišić5
Gustavo Puerta5
Borja Iglesias4
Florian Wirtz3
E. Palacios3
J. Frimpong3
Noah Mbamba3
V. Boniface2
Arthur Augusto2
O. Kossounou1
A. Grimaldo1
SALE
J. Frimpong18
Florian Wirtz17
J. Hofmann17
V. Boniface12
E. Palacios10
Patrik Schick6
Granit Xhaka6
Amine Adli6
P. Hincapié5
Nathan Tella4
N. Amiri4
Adam Hložek4
E. Tapsoba3
A. Grimaldo3
Jonathan Tah2
O. Kossounou2
Josip Stanišić1
Borja Iglesias1
Robert Andrich1

  USO DE MEMORIA  
5,734,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0612
Total Execution Time  0.0626
  CADENA URL  
/estadisticas/Bayer-Leverkusen
  GET DATOS  
$_GET['/estadisticas/Bayer-Leverkusen']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0042  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 = 73878
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3668 AND type_rel = 2
0.0038  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3668 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (1311564,1311517,1311214,1255719,4219) ORDER BY n.cover_points DESC, update_date DESC
0.0041  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 = '3668' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0039  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 = 72031 WHERE rp.league_id = 72031 AND rp.teamId = 3668 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 72031 WHERE rp.league_id = 72031 AND rp.teamId = 3668 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 72031 WHERE rp.league_id = 72031 AND rp.teamId = 3668 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30