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

Estadísticas

ASISTENCIAS
Álex Baena9
A. Sørloth5
Gerard Moreno4
Dani Parejo4
Gonçalo Guedes2
A. Pedraza2
Ilias Akhomach2
Raúl Albiol1
É. Capoue1
Alberto Moreno1
Juan Foyth1
Ramón Terrats1
ENTRA
Morales15
É. Capoue13
Ilias Akhomach12
Ben Brereton12
Manu Trigueros10
Alberto Moreno9
Ramón Terrats9
Santi Comesaña7
Kiko Femenía7
Gonçalo Guedes6
Jorge Cuenca6
Carlos Romero5
Aïssa Mandi4
F. Coquelin4
A. Sørloth4
Denis Suárez3
Dani Parejo3
A. Pedraza3
Gerard Moreno2
Yerson Mosquera2
B. Traoré2
Matteo Gabbia1
Eric Bailly1
A. Altimira1
Jorge Pascual1
Álex Baena1
Raúl Albiol1
Stefan Leković1
SALE
Álex Baena18
Gerard Moreno17
Ilias Akhomach10
Alberto Moreno10
Santi Comesaña8
Morales8
F. Coquelin7
A. Altimira6
Yéremy Pino6
Dani Parejo6
Raúl Albiol6
É. Capoue6
A. Pedraza6
A. Sørloth5
Ramón Terrats4
B. Traoré4
Matteo Gabbia3
Kiko Femenía3
Ben Brereton2
Carlos Romero2
Aïssa Mandi2
Gonçalo Guedes2
Jorge Cuenca1
Eric Bailly1
Juan Foyth1
Manu Trigueros1

  USO DE MEMORIA  
5,877,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1402
Total Execution Time  0.1415
  CADENA URL  
/estadisticas/villarreal
  GET DATOS  
$_GET['/estadisticas/villarreal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0122  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 = '2716' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0122  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 = 2716 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 2716 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0125  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 = 2716 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30