Estadísticas

ASISTENCIAS
Oscar Gloukh1
M. Kjaergaard1
Roko Šimič1
ENTRA
A. Forson4
Petar Ratkov4
N. Dorgeles2
Nicolás Capaldo2
Sekou Koita2
Luka Sučić2
Samson Baidoo2
Roko Šimič2
Karim Konaté2
Oumar Solet1
Fernando1
L. Morgalla1
Dijon Kameri1
K. Piatkowski1
L. Gourna-Douath1
SALE
Oscar Gloukh6
Karim Konaté3
Roko Šimič3
Mads Bidstrup3
Petar Ratkov2
M. Kjaergaard2
N. Dorgeles2
A. Ulmer2
S. Pavlović2
Oumar Solet1
L. Gourna-Douath1
Samson Baidoo1

  USO DE MEMORIA  
5,210,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1274
Total Execution Time  0.1289
  CADENA URL  
/estadisticas/Salzburgo
  GET DATOS  
$_GET['/estadisticas/Salzburgo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0140  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 = '3698' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0112  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 = 73860 WHERE rp.league_id = 73860 AND rp.teamId = 3698 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120  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 = 73860 WHERE rp.league_id = 73860 AND rp.teamId = 3698 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118  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 = 73860 WHERE rp.league_id = 73860 AND rp.teamId = 3698 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30