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

Real Madrid

Entrenador: Carlo Ancelotti

Presidente: Florentino Pérez

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Toni Kroos7
F. Valverde7
Vinícius Júnior5
Rodrygo5
Fran García4
Lucas Vázquez4
Luka Modrić4
J. Bellingham4
Brahim Díaz3
Joselu2
Dani Carvajal2
Dani Ceballos1
E. Camavinga1
A. Tchouaméni1
David Alaba1
ENTRA
Joselu19
Dani Ceballos13
Lucas Vázquez13
Brahim Díaz13
Luka Modrić13
Fran García10
Nacho9
E. Camavinga8
Toni Kroos8
Arda Güler5
A. Tchouaméni5
Rodrygo5
Nico Paz4
Dani Carvajal3
Éder Militão3
Á. Odriozola2
Gonzalo García2
Vinícius Júnior2
Ferland Mendy2
F. Valverde2
A. Rüdiger1
Álvaro1
SALE
Rodrygo18
Vinícius Júnior15
Brahim Díaz14
E. Camavinga13
Toni Kroos12
Luka Modrić11
Ferland Mendy9
F. Valverde9
J. Bellingham9
Dani Carvajal6
Joselu5
Fran García5
A. Tchouaméni4
Lucas Vázquez4
Á. Odriozola3
Nacho2
David Alaba2
Éder Militão1
Dani Ceballos1
A. Rüdiger1

  USO DE MEMORIA  
6,062,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0584
Total Execution Time  0.0596
  CADENA URL  
/estadisticas/real-madrid
  GET DATOS  
$_GET['/estadisticas/real-madrid']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (5)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2107 AND type_rel = 2
0.0068  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 = '2107' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0056  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 2107 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0053  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 2107 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0043  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 2107 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30