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

Plantilla del Elche Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
13 36 ar 191 86 - - 1
1 26 es 187 77 - - -
Defensa
23 32 es 181 69 - 1 5
35 21 es 195 - - - -
4 29 es 185 83 - - 1
12 23 es 178 69 - - 1
34 21 es 178 - - - -
5 23 es 182 77 - - 4
2 33 es 180 74 3 1 6
6 33 es 181 83 1 - 5
24 23 es 170 65 - - 1
Centrocampista
14 28 es 172 58 - - 4
8 23 es 173 - - - 1
20 29 es 184 78 - - 1
3 27 ec 180 70 - - -
26 18 es - - - - -
21 23 ar 182 76 5 1 5
29 19 es - - - - -
30 19 es 182 - 1 - 3
Delantero
32 18 es - - - - -
18 24 es 183 76 1 - 4
17 34 es 176 68 - - 5
10 26 es 183 72 4 - 1
19 25 ma 189 85 4 - 4
22 24 ar 172 71 4 - 11
7 33 es 179 68 7 - 1
37 22 do 178 58 - - -
9 26 es 170 68 - - 2
11 27 es 184 70 7 - 4

  USO DE MEMORIA  
5,385,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.0576
Total Execution Time  0.0605
  CADENA URL  
/plantilla/Elche
  GET DATOS  
$_GET['/plantilla/Elche']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=975 AND type_rel = 2
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 975 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (1312694,1311805,1310966,1309597,1308754) ORDER BY n.cover_points DESC, update_date DESC
0.0034  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 = '975' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020