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

Fichajes Mainz 05

No fichajes previstos

Plantilla del Mainz 05

Jugador Posición Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
33 Portero 32 de 191 86 - - -
27 Portero 28 de 195 86 - - -
1 Portero 21 de 191 88 - - -
Defensa
16 Central 31 de 192 86 - - -
21 Defensa 29 de 187 81 - - -
30 Lateral Derecho 30 ch 183 81 - - -
2 Defensa 29 at 170 68 - - -
20 Defensa 27 ch 186 77 - - -
25 Defensa 26 no 185 70 - - -
5 Defensa 24 de 189 75 - - -
19 Defensa 25 fr 184 70 - - -
3 Defensa 21 nl 192 78 - - -
47 Defensa 20 de 186 - - - -
39 Defensa 18 de - - - - -
34 Defensa 17 de 188 - - - -
Centrocampista
23 Centrocampista 32 fr 188 78 - - -
31 Medio Centro 29 de 183 75 - - -
18 Centrocampista 26 de 180 73 - - -
10 Centrocampista 25 de 176 74 - - -
8 Centrocampista 23 lu 174 65 - - -
14 Centrocampista 21 de 182 72 - - -
7 Centrocampista 30 kr 180 70 - - -
24 Centrocampista 22 de 174 65 - - -
Delantero
17 Delantero Centro 29 fr 196 82 - - -
9 Delantero 31 at 188 85 - - -
11 Delantero 22 de 184 84 - - -
29 Delantero 22 de 183 74 - - -
45 Delantero 22 de 189 75 - - -
48 Delantero 20 de - - - - -
43 Delantero 18 de 178 72 - - -
44 Delantero 18 de 192 - - - -

  USO DE MEMORIA  
4,958,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Preseason / Category )  0.0648
Total Execution Time  0.0666
  CADENA URL  
/pretemporada/Mainz-Amat
  GET DATOS  
$_GET['/pretemporada/Mainz-Amat']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT type FROM routes WHERE alias = 'Mainz-Amat'
0.0033  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='Mainz-Amat' AND ct.troncal=1 ORDER BY l.year DESC LIMIT 1
0.0033   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='2987' AND l.year='2024' AND (ct.competition_type='11' or ct.id=672)
0.0037  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.0021  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) AND (c.datateam1 IN (2987) OR c.datateam2 IN (2987)) ORDER BY c.shedule ASC
0.0051  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 (2548,2987,3040,569,1751,1135)
0.0018  SELECT active_year as year from categories where id=8 order by active_year desc limit 1
0.0023  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=8 AND l.year=2024 AND ct.troncal=1 AND dt.id='2987' GROUP BY dt.id ORDER BY dt.nameShow ASC
0.0035   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 (2987) OR rb.destination_team_id IN (2987)) AND rb.budget_date >= '2016-03-01' order by rb.budget_type!=5 desc,rb.pub_date desc
0.0068  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 = '6582169' ORDER BY p.role>0 DESC, p.role ASC
0.0020   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=8 AND l.year=2024 AND l.group_code='1' ORDER BY dt.nameShow ASC