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

Estadísticas

ASISTENCIAS
A. Griezmann6
R. Riquelme5
Saúl4
R. De Paul4
Koke3
João Félix3
Nahuel Molina3
M. Llorente3
Ángel Correa2
Samuel Lino2
C. Azpilicueta2
Á. Morata2
Y. Carrasco1
M. Hermoso1
Memphis1
Pablo Barrios1
Javi Galán1
Reinildo1
ENTRA
Ángel Correa18
Saúl17
R. Riquelme13
Memphis11
Nahuel Molina10
C. Azpilicueta9
Samuel Lino9
J. Giménez8
M. Llorente8
R. De Paul7
João Félix7
Á. Morata7
Javi Galán6
C. Söyüncü5
Axel Witsel5
Pablo Barrios5
Reinildo4
Stefan Savić3
Koke3
A. Vermeeren2
Gabriel Paulista2
A. Griezmann2
Abde Raihani1
Salim El Jebari1
M. Hermoso1
SALE
R. De Paul18
João Félix15
Á. Morata15
Samuel Lino14
Koke13
R. Riquelme12
M. Llorente10
A. Griezmann10
Nahuel Molina9
Saúl9
Memphis8
Pablo Barrios8
C. Azpilicueta5
Ángel Correa4
J. Giménez4
Thomas Lemar3
Axel Witsel3
Gabriel Paulista3
Javi Galán2
M. Hermoso2
Y. Carrasco2
Stefan Savić2
A. Vermeeren1
Reinildo1
C. Söyüncü1

  USO DE MEMORIA  
6,097,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1007
Total Execution Time  0.1019
  CADENA URL  
/estadisticas/Atletico-Madrid
  GET DATOS  
$_GET['/estadisticas/Atletico-Madrid']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0097  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 = '369' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0090  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '369' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '369' and rp.type = 4
0.0099  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 = 369 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0096  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 = 369 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0067  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 = 369 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0060  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 = 369 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0068  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 = 369 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0054  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 = 369 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30