4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
25 jugadores
Barcelona Barcelona
M. Ter Stegen M. Ter Stegen 31 años 187cm 85kg POR
Jordi Masip Jordi Masip 35 años 180cm 76kg POR
Claudio Bravo Claudio Bravo 41 años 184cm 84kg POR
G. Piqué G. Piqué 37 años 194cm 85kg DEF
Douglas Douglas 33 años 171cm 63kg DEF
Aleix Vidal Aleix Vidal 34 años 176cm 70kg DEF
J. Mathieu J. Mathieu 40 años 190cm 82kg DEF
Lucas Digne Lucas Digne 30 años 178cm 74kg DEF
Jordi Alba Jordi Alba 35 años 170cm 68kg DEF
Samuel Umtiti Samuel Umtiti 30 años 182cm 75kg DEF
Sergi Roberto Sergi Roberto 32 años 178cm 70kg MED
André Gomes André Gomes 30 años 188cm 83kg MED
Sergio Busquets Sergio Busquets 35 años 189cm 76kg MED
Ivan Rakitić Ivan Rakitić 36 años 184cm 79kg MED
Sergi Samper Sergi Samper 29 años 181cm 73kg MED
Rafinha Rafinha 31 años 174cm 67kg MED
Denis Suárez Denis Suárez 30 años 176cm 66kg MED
J. Mascherano J. Mascherano 39 años 174cm 72kg MED
Andres Iniesta Andres Iniesta 39 años 171cm 65kg MED
Luis Suárez Luis Suárez 37 años 182cm 81kg DEL
Munir Munir 28 años 177cm 69kg DEL
Cristian Tello Cristian Tello 32 años 178cm 72kg DEL
A. Turan A. Turan 37 años 176cm 72kg DEL
L. Messi L. Messi 36 años 170cm 72kg DEL
Neymar Neymar 32 años 175cm 64kg DEL
28 jugadores
Sevilla Sevilla
Sergio Rico Sergio Rico 30 años 196cm 90kg POR
J. A. Caro J. A. Caro 29 años 184cm 88kg POR
David Soria David Soria 31 años 192cm 83kg POR
B. Trémoulinas B. Trémoulinas 38 años 173cm 64kg DEF
Mariano Mariano 37 años 177cm 69kg DEF
David Carmona David Carmona 27 años 176cm 72kg DEF
A. Rami A. Rami 38 años 190cm 90kg DEF
D. Carriço D. Carriço 35 años 182cm 79kg DEF
S. Escudero S. Escudero 34 años 176cm 65kg DEF
G. Mercado G. Mercado 37 años 180cm 81kg DEF
T. Kolodziejczak T. Kolodziejczak 32 años 183cm 73kg DEF
Diego González Diego González 29 años 185cm 83kg DEF
N. Pareja N. Pareja 40 años 183cm 75kg DEF
M. Kranevitter M. Kranevitter 30 años 178cm 76kg MED
Ganso Ganso 34 años 184cm 73kg MED
M. Krohn-Dehli M. Krohn-Dehli 40 años 170cm 71kg MED
H. Kiyotake H. Kiyotake 34 años 172cm 66kg MED
S. N'zonzi S. N'zonzi 35 años 196cm 75kg MED
F. Vázquez F. Vázquez 35 años 187cm 87kg MED
V. Iborra V. Iborra 36 años 190cm 76kg MED
S. Cristóforo S. Cristóforo 30 años 175cm 69kg MED
L. Vietto L. Vietto 30 años 173cm 69kg DEL
Pablo Sarabia Pablo Sarabia 31 años 174cm 70kg DEL
J. Correa J. Correa 29 años 188cm 75kg DEL
Vitolo Vitolo 34 años 184cm 79kg DEL
Juan Muñoz Juan Muñoz 28 años 180cm 80kg DEL
W. Ben Yedder W. Ben Yedder 33 años 170cm 68kg DEL
Y. Konoplyanka Y. Konoplyanka 34 años 176cm 70kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,444,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4147
Total Execution Time  0.4166
  CADENA URL  
/supercopa2017/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa2017/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0145  SELECT type FROM routes WHERE alias = 'supercopa2017'
0.0291  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=132 AND type_rel = 3
0.0173  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 132 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0149  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 (801142,1286949,1244521,905062,976970) ORDER BY n.cover_points DESC, update_date DESC
0.0145  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 = 28004 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 28004 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0155  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 = 28004 AND dt.id IN (429,1102) ORDER BY dt.relations DESC,dp.role ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 14:51:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 14:51:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 14:51:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 14:51:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 132 AND l.year = 2017
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2017 e WHERE e.league_id IN (28004) 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.0147  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 (28004) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (14381,23569,29685,174484) ORDER BY rp.in_squad = 1 DESC
0.0161  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 132 AND l.year = 2017
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2017 e WHERE e.league_id IN (28004) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0147  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 (28004) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (27059,29685,32019,42921,71895,109637,127121,147482) ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 132 AND l.year = 2017
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2017 e WHERE e.league_id IN (28004) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10