4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Japón

Japón

Entrenador: Hajime Moriyasu

Temporada 2023/2024

Plantilla del Japón Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
1 29 jp 191 86 - - -
12 24 jp 188 86 - - -
1 27 jp 183 79 - - -
12 21 jp 193 87 - - -
23 21 jp 190 93 - - -
Defensa
27 24 jp 184 75 - - -
22 23 jp 187 74 - - -
21 24 jp 188 78 - - -
15 26 jp 190 70 - - -
4 27 jp 188 75 1 - 1
16 26 jp 179 69 - - 1
24 23 jp 178 74 - - -
3 32 jp 183 70 - - -
16 25 jp 188 70 - - -
22 27 jp 181 73 - - -
2 23 jp 179 67 - - -
Centrocampista
17 25 jp 180 69 4 - -
15 25 jp 185 78 1 - -
5 28 jp 177 74 - - -
7 28 jp 178 70 - - -
6 23 jp 176 68 - - -
7 26 jp 175 66 - - -
24 26 jp 172 70 - - -
5 24 jp 183 76 1 - -
6 31 jp 178 75 - - -
Delantero
9 25 jp 182 76 1 - -
14 31 jp 176 66 3 - 1
11 29 jp 170 63 1 - -
13 23 jp 180 75 5 - 1
20 24 jp 171 61 - - -
11 22 jp 178 69 - - -
7 27 jp 166 63 - - -
8 29 jp 172 67 2 - -
20 22 jp 173 69 - - 1
18 29 jp 173 71 2 - -

  USO DE MEMORIA  
4,979,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1581
Total Execution Time  0.1593
  CADENA URL  
/plantilla/Seleccion-Japon
  GET DATOS  
$_GET['/plantilla/Seleccion-Japon']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (5)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3798 AND type_rel = 2
0.0137  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3798 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (15994,16216,21710,22136,34140) ORDER BY n.cover_points DESC, update_date DESC
0.0142  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 = '3798' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 70632 AND t.round = 73 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC