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

Plantilla del RC Deportivo Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
24 23 es 182 - - - -
1 21 es 182 - - - -
13 31 es 191 78 - - 2
Defensa
42 21 es 190 - - - -
5 21 es 186 77 - - 2
2 25 gw 179 - - - -
19 29 es 185 77 1 - 5
36 22 es 182 - - - -
18 36 es 177 77 1 - 6
40 22 es 184 73 - - -
4 35 fr 182 77 3 1 6
15 29 es 189 83 4 - 6
22 34 es 172 70 - - 1
23 34 es 176 75 - - 4
Centrocampista
38 22 es - - - - -
8 27 es 180 75 4 - 4
17 27 es 177 75 2 - 1
26 20 es 182 - - - -
20 31 es 183 65 1 1 12
35 19 es 175 - 1 - 3
6 40 es 178 70 - - 1
Delantero
14 27 es 170 63 - - 1
3 18 es 169 - 5 - 1
11 29 es 178 71 7 1 3
31 19 es 177 - - - -
9 25 es 186 80 10 - 3
32 19 es 169 - - - -
7 35 es 180 78 10 1 4
16 19 co 178 - - - -
29 19 es 178 - 1 - -
39 22 es 169 65 - - -
21 31 es 172 70 2 - 2
12 23 es 181 77 2 - 2
10 21 es 169 61 4 - 5

  USO DE MEMORIA  
5,549,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1796
Total Execution Time  0.1809
  CADENA URL  
/plantilla/Deportivo
  GET DATOS  
$_GET['/plantilla/Deportivo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0242  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 = 'Deportivo' 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.0107  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=901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0199  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 = '901' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020