4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
23 jugadores
Barcelona Barcelona
M. Ter Stegen M. Ter Stegen 32 años 187cm 85kg POR
Jasper Cillessen Jasper Cillessen 35 años 187cm 82kg POR
T. Vermaelen T. Vermaelen 38 años 183cm 80kg DEF
C. Lenglet C. Lenglet 28 años 186cm 81kg DEF
G. Piqué G. Piqué 37 años 194cm 85kg DEF
Samuel Umtiti Samuel Umtiti 30 años 182cm 75kg DEF
J. Miranda J. Miranda 24 años 185cm 76kg DEF
Nélson Semedo Nélson Semedo 30 años 177cm 65kg DEF
Jordi Alba Jordi Alba 35 años 170cm 68kg DEF
Arthur Arthur 27 años 172cm 68kg MED
Riqui Puig Riqui Puig 24 años 169cm 56kg MED
Ivan Rakitić Ivan Rakitić 36 años 184cm 79kg MED
P. Coutinho P. Coutinho 31 años 172cm 72kg MED
Sergio Busquets Sergio Busquets 35 años 189cm 76kg MED
Arturo Vidal Arturo Vidal 36 años 180cm 74kg MED
Rafinha Rafinha 31 años 174cm 67kg MED
Denis Suárez Denis Suárez 30 años 176cm 66kg MED
P. Alcácer P. Alcácer 30 años 175cm 70kg DEL
L. Messi L. Messi 36 años 170cm 72kg DEL
Luis Suárez Luis Suárez 37 años 182cm 81kg DEL
O. Dembélé O. Dembélé 26 años 178cm 67kg DEL
Munir Munir 28 años 177cm 69kg DEL
Malcom Malcom 27 años 171cm 74kg DEL
28 jugadores
Sevilla Sevilla
Juan Soriano Juan Soriano 26 años 185cm 78kg POR
Tomáš Vaclík Tomáš Vaclík 35 años 189cm 84kg POR
J. Gnagnon J. Gnagnon 27 años 182cm 89kg DEF
G. Arana G. Arana 27 años 176cm 70kg DEF
Aleix Vidal Aleix Vidal 34 años 176cm 70kg DEF
Jesús Navas Jesús Navas 38 años 170cm 60kg DEF
Sergi Gómez Sergi Gómez 32 años 185cm 80kg DEF
N. Pareja N. Pareja 40 años 183cm 75kg DEF
Juan Berrocal Juan Berrocal 25 años 187cm 72kg DEF
G. Mercado G. Mercado 37 años 180cm 81kg DEF
Simon Kjær Simon Kjær 35 años 191cm 82kg DEF
D. Carriço D. Carriço 35 años 182cm 79kg DEF
S. Corchia S. Corchia 33 años 176cm 65kg DEF
S. Escudero S. Escudero 34 años 176cm 65kg DEF
Roque Mesa Roque Mesa 34 años 172cm 72kg MED
I. Amadou I. Amadou 31 años 183cm 80kg 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
Borja Lasso Borja Lasso 30 años 186cm 75kg MED
Ganso Ganso 34 años 184cm 73kg MED
É. Banega É. Banega 35 años 174cm 71kg MED
Pejiño Pejiño 27 años 178cm 67kg DEL
W. Ben Yedder W. Ben Yedder 33 años 170cm 68kg DEL
André Silva André Silva 28 años 185cm 78kg DEL
C. Fernández C. Fernández 27 años 185cm 72kg DEL
Pablo Sarabia Pablo Sarabia 31 años 174cm 70kg DEL
Luis Muriel Luis Muriel 33 años 180cm 79kg DEL
Nolito Nolito 37 años 175cm 73kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,432,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.4166
Total Execution Time  0.4188
  CADENA URL  
/supercopa2019/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa2019/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0149  SELECT type FROM routes WHERE alias = 'supercopa2019'
0.0313  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 = 2019 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.0172  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.0148  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 (1313267,1313202,1313107,1312328,801142) 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 = 43500 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 = 43500 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 = 43500 AND dt.id IN (429,1102) ORDER BY dt.relations DESC,dp.role ASC
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 12:17:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 12:17:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 12:17:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 12:17:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 132 AND l.year = 2019
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (43500) 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.0150  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 (43500) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (23560,42921,241919) ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 132 AND l.year = 2019
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (43500) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0152  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 (43500) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (27059,39947,40552,67849,109637,200996) ORDER BY rp.in_squad = 1 DESC
0.0150  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 132 AND l.year = 2019
0.0150  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (43500) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10