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

Estadísticas

ENTRA
Armengol3
A. De Rueda2
Iván Navarro2
I. Acosta2
Joselito2
Beli2
Migue García1
M. Reina1
Juan Mari1
Alex Del Rio1
Diego Domínguez1
SALE
Perotti2
A. De Rueda2
I. Acosta2
Diego Domínguez2
Iván Navarro1
Ramon1
A. Jesús1
Beli1
Juan Delgado1
Joselito1
Juan Mari1
Alex Del Rio1
Migue García1
M. Reina1

  USO DE MEMORIA  
5,125,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  1.9454
Total Execution Time  1.9466
  CADENA URL  
/estadisticas/Xerez
  GET DATOS  
$_GET['/estadisticas/Xerez']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.8636  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 = '2767' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.1060  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 = 72571 WHERE rp.league_id = 72571 AND rp.teamId = 2767 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.4564  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 = 72571 WHERE rp.league_id = 72571 AND rp.teamId = 2767 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.4444  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 = 72571 WHERE rp.league_id = 72571 AND rp.teamId = 2767 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30