4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
16 jugadores
Yokohama F. Marinos Yokohama Marinos
T. Enomoto T. Enomoto 40 años 180cm 76kg POR
T. Enomoto T. Enomoto 45 años 180cm 73kg POR
Y. Nakazawa Y. Nakazawa 46 años 187cm 78kg DEF
E. Nakanishi E. Nakanishi 50 años 174cm 73kg DEF
D. Nasu D. Nasu 42 años 180cm 75kg DEF
Dutra Dutra 50 años 169cm 75kg DEF
Y. Kurihara Y. Kurihara 40 años 184cm 80kg DEF
H. Tanaka H. Tanaka 41 años 174cm 64kg MED
Masahiro Ohashi Masahiro Ohashi 42 años 168cm 65kg MED
Akihiro Endō Akihiro Endō 48 años MED
Yoshiharu Ueno Yoshiharu Ueno 51 años MED
D. Oku D. Oku 48 años MED
Norihisa Shimizu Norihisa Shimizu 47 años MED
R. Kawai R. Kawai 45 años 183cm 75kg MED
H. Oshima H. Oshima 44 años DEL
M. Yamazaki M. Yamazaki 42 años 174cm 68kg DEL
16 jugadores
Tokyo Verdy Tokyo Verdy
Hiroki Mizuhara Hiroki Mizuhara 49 años POR
Y. Takagi Y. Takagi 44 años 187cm 86kg POR
T. Soma T. Soma 42 años 176cm 75kg DEF
Ryo Nurishi Ryo Nurishi 37 años DEF
T. Yamada T. Yamada 49 años 180cm 82kg DEF
Masayuki Yanagisawa Masayuki Yanagisawa 44 años DEF
Woo-Jin Lee Woo-Jin Lee 38 años 184cm 76kg DEF
T. Hirano T. Hirano 49 años 180cm 73kg MED
Yoshiyuki Kobayashi Yoshiyuki Kobayashi 46 años 178cm 71kg MED
D. Kobayashi D. Kobayashi 41 años 178cm 70kg MED
Kentaro Hayashi Kentaro Hayashi 51 años MED
Kazuyuki Toda Kazuyuki Toda 46 años 178cm 68kg MED
T. Morimoto T. Morimoto 35 años 180cm 71kg DEL
Tadamichi Machida Tadamichi Machida 42 años DEL
Washington Washington 49 años DEL
K. Hiramoto K. Hiramoto 42 años 180cm 75kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,328,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3911
Total Execution Time  0.3932
  CADENA URL  
/supercopa_japon2005/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_japon2005/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0144  SELECT type FROM routes WHERE alias = 'supercopa_japon2005'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_japon' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 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=1506 AND type_rel = 3
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1506 ORDER BY order_id ASC
0.0147  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 = 12180 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 12180 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0149  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 = 12180 AND dt.id IN (2778,2499) 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-28 07:34:19' 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=2 AND last_update > '2024-04-28 07:34:19' 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=4 AND last_update > '2024-04-28 07:34:19' 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-28 07:34:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1506 AND l.year = 2005
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (12180) 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.0146  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 (12180) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (360584,210476,556060) ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1506 AND l.year = 2005
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (12180) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0146  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 (12180) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (18198,18837,387076) ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1506 AND l.year = 2005
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (12180) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10