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

Estadísticas

ASISTENCIAS
Javi Muñoz3
Sandro3
Jonathan Viera3
A. Moleiro3
Sergi Cardona2
Kirian2
Marvin Park2
Munir2
Mika Mármol1
S. Kaba1
Marc Cardona1
ENTRA
Benito Ramírez17
Marc Cardona16
E. Loiodice14
Marvin Park14
Pejiño10
Julián Araujo9
S. Kaba8
M. Perrone8
A. Moleiro6
C. Herrera6
Javi Muñoz5
Munir4
J. Campaña4
Saúl Coco4
Fabio González4
D. Sinkgraven4
Sandro4
Sergi Cardona4
Nuke Mfulu4
Jonathan Viera2
Álex Suárez1
Álvaro Lemos1
Iñaki González1
Kirian1
Aarón Escandell1
Juanma Herzog1
SALE
Munir26
Sandro14
M. Perrone14
Javi Muñoz13
E. Loiodice12
Jonathan Viera11
A. Moleiro11
Marvin Park9
Kirian7
Álex Suárez7
S. Kaba6
Marc Cardona6
Pejiño6
Sergi Cardona5
D. Sinkgraven4
Julián Araujo4
Saúl Coco1
Álvaro Lemos1
J. Campaña1
Mika Mármol1
Nuke Mfulu1

  USO DE MEMORIA  
5,564,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0642
Total Execution Time  0.0655
  CADENA URL  
/estadisticas/Ud-Palmas
  GET DATOS  
$_GET['/estadisticas/Ud-Palmas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0036  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 = '2563' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0045  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 = 2563 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.0036  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 = 2563 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 2563 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 2563 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 2563 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 = 2563 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30