Estadísticas

ASISTENCIAS
Julian Brandt11
N. Füllkrug8
J. Bynoe-Gittens3
Marco Reus3
Emre Can2
Marcel Sabitzer2
Ian Maatsen2
Felix Nmecha2
Jadon Sancho1
N. Schlotterbeck1
S. Haller1
Donyell Malen1
K. Adeyemi1
Marius Wolf1
Julian Ryerson1
ENTRA
Y. Moukoko15
K. Adeyemi10
Gio Reyna10
S. Haller9
J. Bynoe-Gittens9
Niklas Süle8
Salih Özcan8
Marius Wolf8
Felix Nmecha8
Marco Reus6
R. Bensebaini6
Donyell Malen5
M. Hummels5
Julian Brandt3
Emre Can3
Samuel Bamba2
N. Füllkrug2
Jadon Sancho2
Julian Ryerson1
T. Hazard1
A. Papadopoulos1
A. Meyer1
Thomas Meunier1
J. Duranville1
Marcel Sabitzer1
O. Pohlmann1
Hendry Blank1
Mateu Morey1
SALE
N. Füllkrug16
Marco Reus14
Julian Brandt13
J. Bynoe-Gittens11
Donyell Malen9
Jadon Sancho7
Ian Maatsen6
K. Adeyemi6
Emre Can5
S. Haller5
M. Hummels5
Julian Ryerson4
Felix Nmecha4
Marcel Sabitzer4
R. Bensebaini3
Y. Moukoko3
N. Schlotterbeck3
Thomas Meunier3
Salih Özcan3
Marius Wolf2
Gregor Kobel1
Niklas Süle1
Gio Reyna1

  USO DE MEMORIA  
5,856,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1189
Total Execution Time  0.1200
  CADENA URL  
/estadisticas/Borussia-Dortmund
  GET DATOS  
$_GET['/estadisticas/Borussia-Dortmund']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=530 AND type_rel = 2
0.0068  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 530 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 (1311412,1311270,1311236,1311243,1311234) ORDER BY n.cover_points DESC, update_date DESC
0.0088  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '530' ORDER BY l.year DESC,cat.coefficient DESC
0.0039  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 = '530' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0041  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=530 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (75586,74790,72172,72031,68172) 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.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 72031 AND teamId = 530
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 74790 AND teamId = 530
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 72172 AND teamId = 530
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75586 AND teamId = 530
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 68172 AND teamId = 530
0.0057  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '530' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '530' and rp.type = 4
0.0037  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '530' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '530' and rp.type = 4
0.0050  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 = 530 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.0048  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 = 530 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 530 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0043  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 = 530 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040  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 = 530 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 72031 WHERE rp.league_id = 72031 AND rp.teamId = 530 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30