4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
23 jugadores
Bayern München Bayern München
Christian Früchtl Christian Früchtl 24 años 193cm 71kg POR
M. Neuer M. Neuer 38 años 193cm 92kg POR
R. Hoffmann R. Hoffmann 25 años 192cm 84kg POR
Sven Ulreich Sven Ulreich 35 años 192cm 84kg POR
J. Boateng J. Boateng 35 años 192cm 90kg DEF
Niklas Süle Niklas Süle 28 años 195cm 99kg DEF
B. Pavard B. Pavard 28 años 186cm 81kg DEF
A. Davies A. Davies 23 años 183cm 72kg DEF
David Alaba David Alaba 31 años 180cm 75kg DEF
Lucas Hernández Lucas Hernández 28 años 184cm 76kg DEF
C. Tolisso C. Tolisso 29 años 181cm 78kg MED
Renato Sanches Renato Sanches 26 años 176cm 70kg MED
J. Kimmich J. Kimmich 29 años 177cm 82kg MED
Thomas Müller Thomas Müller 34 años 185cm 74kg MED
S. Singh S. Singh 25 años 175cm 70kg MED
Thiago Thiago 33 años 174cm 71kg MED
J. Martínez J. Martínez 35 años 189cm 81kg MED
L. Goretzka L. Goretzka 29 años 189cm 79kg MED
R. Johansson R. Johansson 23 años 186cm 73kg DEL
R. Lewandowski R. Lewandowski 35 años 185cm 78kg DEL
S. Gnabry S. Gnabry 28 años 176cm 77kg DEL
K. Coman K. Coman 27 años 181cm 71kg DEL
Fiete Arp Fiete Arp 24 años 186cm 78kg DEL
33 jugadores
B. Dortmund B. Dortmund
L. Unbehaun L. Unbehaun 23 años 185cm 85kg POR
M. Hitz M. Hitz 36 años 194cm 89kg POR
E. Oelschlagel E. Oelschlagel 28 años 193cm 85kg POR
Roman Bürki Roman Bürki 33 años 187cm 85kg POR
Sergio Gómez Sergio Gómez 23 años 171cm 62kg DEF
R. Guerreiro R. Guerreiro 30 años 170cm 71kg DEF
M. Akanji M. Akanji 28 años 188cm 91kg DEF
Marius Wolf Marius Wolf 28 años 187cm 81kg DEF
Mateu Morey Mateu Morey 24 años 173cm 67kg DEF
O. Toprak O. Toprak 34 años 187cm 81kg DEF
L. Piszczek L. Piszczek 38 años 184cm 73kg DEF
Axel Witsel Axel Witsel 35 años 186cm 81kg DEF
M. Hummels M. Hummels 35 años 191cm 94kg DEF
N. Schulz N. Schulz 31 años 180cm 83kg DEF
D. Zagadou D. Zagadou 24 años 196cm 90kg DEF
M. Schmelzer M. Schmelzer 36 años 180cm 74kg DEF
A. Hakimi A. Hakimi 25 años 181cm 68kg DEF
L. Balerdi L. Balerdi 25 años 187cm 85kg DEF
P. Osterhage P. Osterhage 24 años 186cm 75kg MED
Tobias Raschl Tobias Raschl 24 años 177cm 75kg MED
T. Delaney T. Delaney 32 años 182cm 71kg MED
Mario Götze Mario Götze 31 años 176cm 64kg MED
M. Dahoud M. Dahoud 28 años 178cm 68kg MED
M. Philipp M. Philipp 30 años 183cm 74kg MED
S. Kagawa S. Kagawa 35 años 175cm 68kg MED
Julian Weigl Julian Weigl 28 años 186cm 71kg MED
Marco Reus Marco Reus 34 años 180cm 71kg MED
Julian Brandt Julian Brandt 27 años 185cm 83kg MED
T. Hazard T. Hazard 31 años 175cm 71kg DEL
Jadon Sancho Jadon Sancho 24 años 180cm 74kg DEL
P. Alcácer P. Alcácer 30 años 175cm 70kg DEL
Bruun Larsen Bruun Larsen 25 años 183cm 72kg DEL
A. Schürrle A. Schürrle 33 años 175cm 63kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,443,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.3349
Total Execution Time  0.3373
  CADENA URL  
/bundesliga_supercup2020/grupo0/jugadores
  GET DATOS  
$_GET['/bundesliga_supercup2020/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0105  SELECT type FROM routes WHERE alias = 'bundesliga_supercup2020'
0.0217  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_supercup' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=180 AND type_rel = 3
0.0111  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 180 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0112  SELECT /*53 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 (1273114,1273106,1273130,1273072,1091185) ORDER BY n.cover_points DESC, update_date DESC
0.0106  SELECT id,name,alias,stepParent FROM categories WHERE parentId=180 ORDER BY order_id ASC
0.0110  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 180 GROUP BY l.categoryId
0.0109  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=180 GROUP BY l.year ORDER BY l.year DESC
0.0108  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 49824 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 49824 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0118  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 49824 AND dt.id IN (449,530) ORDER BY dt.relations DESC,dp.role ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 11:20:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 11:20:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 11:20:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 11:20:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 180 AND l.year = 2020
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (49824) AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0111  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (49824) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (39979,341319) ORDER BY rp.in_squad = 1 DESC
0.0107  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 180 AND l.year = 2020
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (49824) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0107  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (49824) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (53536,186172) ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 180 AND l.year = 2020
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (49824) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10