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

Estadísticas

ASISTENCIAS
Roger4
Samu Vázquez4
César Moreno3
C. Mangada2
Ketu2
José Artiles2
Richie1
Nico1
Míchel1
Alvarito1
A. Candelas1
Jean Paul1
ENTRA
Richie18
A. Coscia15
Alvarito14
Jean Paul11
Nico11
César Moreno10
Jorge Galvañ9
C. Mangada9
Marcos Mendes8
D. Lorenzo7
Ketu7
Míchel6
José Artiles5
Javi Moreno4
Retu4
C. De La Nava4
Juanmi García1
Roger1
Miguel Marí1
J. Cendón1
A. Candelas1
Hugo Sanz1
R. Nolan1
SALE
Marcos Mendes16
Alvarito15
C. De La Nava15
Ketu12
C. Mangada11
Roger11
Richie10
César Moreno10
Javi Moreno9
José Artiles8
Jean Paul8
Nico7
A. Coscia6
A. Candelas6
Míchel5
Miguel Marí5
Samu Vázquez4
D. Lorenzo2
Juanmi García1
Carlos Abad1
R. Nolan1

  USO DE MEMORIA  
5,582,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2323
Total Execution Time  0.2342
  CADENA URL  
/estadisticas/Hercules
  GET DATOS  
$_GET['/estadisticas/Hercules']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (5)  
0.0234  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 = '1311' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0311  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72364 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0184  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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 1311 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0183  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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 1311 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0197  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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 1311 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30