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

Estadísticas

ASISTENCIAS
Pablo Maffeo4
Mikel Rico4
David Ferreiro4
Javi Galán2
Dani Escriche1
S. Okazaki1
Sandro1
Jaime Seoane1
Juan Carlos1
Sergio Gómez1
Javi Ontiveros1
Rafa Mir1
Pedro López1
ENTRA
Sergio Gómez25
Idrissa Doumbia16
Dani Escriche16
Juan Carlos12
Pedro López12
S. Okazaki11
Javi Ontiveros10
Borja García8
David Ferreiro8
Jaime Seoane6
Rafa Mir6
G. Silva6
Mikel Rico5
Sandro4
K. Nwakali4
Pablo Insua3
Javi Galán3
Luisinho3
Joaquín Muñoz3
Pedro Mosquera3
Denis Vavro2
Eugeni2
D. Siovas2
Jorge Pulido1
SALE
Mikel Rico23
David Ferreiro20
Pablo Maffeo14
Sandro13
S. Okazaki11
Borja García10
Rafa Mir8
Pedro Mosquera7
Javi Ontiveros7
Jaime Seoane7
Denis Vavro7
Dani Escriche6
Idrissa Doumbia5
Pedro López5
Javi Galán5
Pablo Insua4
G. Silva4
Juan Carlos3
D. Siovas3
Sergio Gómez3
Luisinho2
Jorge Pulido2
K. Nwakali1
Eugeni1

  USO DE MEMORIA  
5,481,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1756
Total Execution Time  0.1769
  CADENA URL  
/estadisticas/Huesca/2021
  GET DATOS  
$_GET['/estadisticas/Huesca/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0156  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 = '1339' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0159  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 events2021 e ON e.player_id = p.id AND e.league_id = 57041 WHERE rp.league_id = 57041 AND rp.teamId = 1339 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  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 events2021 e ON e.player_id = p.id AND e.league_id = 57041 WHERE rp.league_id = 57041 AND rp.teamId = 1339 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 events2021 e ON e.player_id = p.id AND e.league_id = 57041 WHERE rp.league_id = 57041 AND rp.teamId = 1339 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30