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

Sagamihara

Entrenador: Kazuyuki Toda

Temporada 2023/2024

Plantilla del Sagamihara Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
21 36 jp 185 75 - - -
23 24 jp 188 85 - - -
1 27 jp 186 78 - - -
Defensa
2 25 jp 180 79 1 - 1
5 26 jp 171 70 1 - -
55 35 jp 182 70 - - 1
16 29 jp 171 68 - - 1
4 23 jp 180 75 - - 1
19 27 jp 181 74 - - -
3 23 jp - - - - -
3 23 jp 171 74 - - 2
Centrocampista
28 31 br 177 75 - - 1
7 27 jp 180 72 1 - 2
22 22 jp 165 - 1 - -
17 23 jp 172 66 - - -
24 23 jp 170 67 - - -
25 24 jp 167 63 1 - -
20 23 jp 173 64 - - -
13 26 jp 163 63 - - 1
8 26 jp 172 70 - - 1
27 24 jp 167 65 - - 3
40 27 jp 177 77 - 1 3
47 34 jp 170 69 1 - 1
6 30 jp 170 69 1 - -
Delantero
14 26 jp 175 68 - - -
96 27 br 185 80 1 - 1
66 22 jp 191 88 - - -
9 26 jp 171 71 - - -
15 23 jp 173 69 1 - 1
39 33 jp 185 77 1 - 2

  USO DE MEMORIA  
5,135,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0698
Total Execution Time  0.0716
  CADENA URL  
/plantilla/Sagamihara
  GET DATOS  
$_GET['/plantilla/Sagamihara']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0029  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Sagamihara' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=11633 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=11633 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=11633 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0061  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74985
0.0023  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 75185
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11633 AND type_rel = 2
0.0022  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 = '11633' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74985 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50