Estadísticas

ASISTENCIAS
Roger7
R. Zalazar6
Cristian Borja5
Simon Banza4
Álvaro Djaló3
Ricardo Horta3
Pizzi3
Joe Mendes2
Abel Ruiz2
Serdar Saatçı2
André Horta1
Paulo Oliveira1
Bruma1
Victor Gómez1
ENTRA
Rony Lopes16
Pizzi15
R. Zalazar10
André Horta9
A. Castro9
Álvaro Djaló9
Abel Ruiz9
Vitor Carvalho7
João Moutinho7
Roger7
Bruma6
Joe Mendes6
Cher Ndour6
Adrián Marín5
Victor Gómez4
S. Niakaté3
Simon Banza3
José Fonte2
M. Al Musrati2
Cristian Borja2
Nuno Matos1
Ricardo Horta1
Paulo Oliveira1
SALE
R. Zalazar16
Álvaro Djaló14
Bruma11
Vitor Carvalho11
Victor Gómez11
Pizzi10
Ricardo Horta9
Cristian Borja8
Abel Ruiz8
Joe Mendes7
André Horta5
Roger5
Simon Banza5
A. Castro4
M. Al Musrati3
João Moutinho3
José Fonte2
Paulo Oliveira2
Rony Lopes2
Serdar Saatçı1
Diogo Fonseca1
Adrián Marín1

  USO DE MEMORIA  
6,075,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1316
Total Execution Time  0.1328
  CADENA URL  
/estadisticas/Sporting-Braga
  GET DATOS  
$_GET['/estadisticas/Sporting-Braga']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
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 = 72097
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2386 AND type_rel = 2
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2386 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 (439,579,886,1200,3042) ORDER BY n.cover_points DESC, update_date DESC
0.0058  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 = '2386' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72053 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0048  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=2386 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74982,74791,73859,73560,72097,72053,71432,70410) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 72053 AND teamId = 2386
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 73859 AND teamId = 2386
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 74791 AND teamId = 2386
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 70410 AND teamId = 2386
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 73560 AND teamId = 2386
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 72097 AND teamId = 2386
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 74982 AND teamId = 2386
0.0214  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2386
0.0051  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 = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 2386 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.0071  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 = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 2386 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0057  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 = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 2386 AND (e.action = 3 or e.action = 4) 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 = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 2386 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 2386 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 2386 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30