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

Pretemporada Sevilla

Presidente: José Castro

Fichajes Sevilla

No fichajes previstos

Plantilla del Sevilla

Jugador Posición Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
13 Portero 32 no 192 78 - - -
1 Portero 31 rs 189 81 - - -
32 Portero 19 es 192 - - - -
31 Portero 19 es 187 - - - -
33 Portero 20 es 184 - - - -
Defensa
4 Central 37 es 184 73 - - -
16 Lateral Derecho 37 es 170 60 - - -
6 Defensa 31 rs 187 77 - - -
19 Lateral Izquierdo 31 ar 172 72 - - -
23 Defensa 26 br 185 77 - - -
3 Defensa 24 es 172 69 - - -
22 Defensa 23 fr 191 89 - - -
14 Defensa 20 fr 191 83 - - -
26 Lateral Derecho 19 es 186 68 - - -
29 Defensa 20 es 178 - - - -
2 Defensa 21 es 188 - - - -
38 Defensa 20 es 182 - - - -
Centrocampista
21 Medio Centro 28 es 175 70 - - -
8 Centrocampista 28 es 185 74 - - -
18 Centrocampista 26 ch 184 77 - - -
24 Centrocampista 24 fr 188 82 - - -
35 Centrocampista 21 es 190 77 - - -
42 Centrocampista 21 fr 185 72 - - -
46 Centrocampista 20 tn 183 70 - - -
41 Centrocampista 17 be 171 - - - -
40 Centrocampista 22 es 175 63 - - -
39 Centrocampista 20 es 189 - - - -
28 Centrocampista 18 es 178 - - - -
Delantero
17 Extremo Derecho 31 ar 184 74 - - -
5 Delantero Centro 28 ar 187 82 - - -
12 Delantero Centro 29 do 180 75 - - -
7 Delantero 29 es 177 72 - - -
25 Extremo Derecho 28 be 186 76 - - -
9 Delantero 25 es 191 75 - - -
11 Delantero 25 be 187 60 - - -
15 Delantero Centro 25 ma 192 73 - - -
20 Delantero 22 es 184 76 - - -
10 Delantero 19 ar 186 77 - - -
30 Delantero 16 sn 184 - - - -

  USO DE MEMORIA  
5,236,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Preseason / Category )  0.2860
Total Execution Time  0.2878
  CADENA URL  
/pretemporada/Sevilla
  GET DATOS  
$_GET['/pretemporada/Sevilla']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0209  SELECT dt.*, t.id AS team_id, ct.id AS competition_id, ct.name AS competition_name, ct.alias AS competition_alias, ct.class, ct.alias, ct.type_style FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON l.categoryId=ct.id WHERE dt.basealias='Sevilla' AND ct.troncal=1 ORDER BY l.year DESC LIMIT 1
0.0164   SELECT t.id AS team_id, l.id AS league_id, ct.id as competition_id, ct.name AS competition_name FROM teams AS t INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON l.categoryId=ct.id WHERE t.teamId='1102' AND l.year='2024' AND (ct.competition_type='11' or ct.id=672)
0.0159  SELECT ct.id, ct.name, ct.alias, l.id AS league_id, l.year FROM leagues AS l INNER JOIN categories AS ct ON l.categoryId=ct.id AND ct.active_year=l.year WHERE ct.competition_type=11 or ct.id=672
0.0150  SELECT c.id, c.r1, c.r2, c.comments, c.shedule, c.extra, c.league_id, c.datateam1, c.datateam2, c.team1, c.team2 FROM calendars2024 AS c WHERE c.league_id IN (71432,70632,49360,75120,58837,75045,75697,74447,75096,75095,75079,75097,75055,75080,73659,73904,70875,65830,75099,66144,75158,65670,66585,75665,75100,71331,71585,72591,75946) AND (c.datateam1 IN (1102) OR c.datateam2 IN (1102)) ORDER BY c.shedule ASC
0.0185  SELECT dt.id, dt.nameShow, dt.basealias, s.name as stadium, s.address FROM datateams AS dt LEFT JOIN rel_stadiums rs ON rs.teamId = dt.id AND rs.active = 1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE dt.id IN (831,1102,665,1292,2905,860,486,369)
0.0144  SELECT active_year as year from categories where id=1 order by active_year desc limit 1
0.0148  SELECT t.id, dt.id AS dtid, dt.nameShow AS name, dt.basealias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id INNER JOIN datateams AS dt ON t.teamId=dt.id WHERE ct.id=1 AND l.year=2024 AND ct.troncal=1 AND dt.id='1102' GROUP BY dt.id ORDER BY dt.nameShow ASC
0.0173   SELECT rb.origin_team_id AS otid, rb.destination_team_id AS dtid, rb.official_budget, rb.new_id, rb.valor, rb.budget_type, dp.id, dp.nick AS name, dp.role, dt1.id AS odtid, dt1.nameShow AS odtname, dt2.id AS ddtid, dt2.nameShow AS ddtname, n.alias FROM rel_budgets AS rb INNER JOIN news AS n ON n.id=rb.new_id INNER JOIN dataplayers AS dp ON rb.player_id=dp.id LEFT JOIN datateams AS dt1 ON rb.origin_team_id=dt1.id LEFT JOIN datateams AS dt2 ON rb.destination_team_id=dt2.id WHERE rb.year=2024 AND (rb.origin_team_id IN (1102) OR rb.destination_team_id IN (1102)) AND rb.budget_date >= '2016-03-01' order by rb.budget_type!=5 desc,rb.pub_date desc
0.0307  SELECT p.*,rp.*, TIMESTAMPDIFF(YEAR,p.birthdate,CURDATE()) AS age FROM `rel_players` rp INNER JOIN `dataplayers` p ON rp.player_id = p.id WHERE rp.in_squad=1 AND rp.team_id = '6583649' ORDER BY p.role>0 DESC, p.role ASC
0.0146   SELECT dt.id, dt.nameShow, dt.basealias, l.id AS league_id, l.categoryId AS competition_id FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id WHERE l.categoryId=1 AND l.year=2024 AND l.group_code='1' ORDER BY dt.nameShow ASC