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

Estadísticas

GOLEADORES
A. Cohen2
D. Elmalah1
R. Bruchian1
AMARILLAS
A. Jarjue Kabia1

Estadísticas

ENTRA
T. Berkovich1
M. Sheikh1
L. Malka1
D. Elmalah1
H. Goldenberg1
SALE
A. Asepa1
A. Jarjue Kabia1
T. Naim1
R. Hanzis1
A. Cohen1

  USO DE MEMORIA  
5,141,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0620
Total Execution Time  0.0639
  CADENA URL  
/estadisticas/Hapoel-Kfar-Saba
  GET DATOS  
$_GET['/estadisticas/Hapoel-Kfar-Saba']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0039  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73553
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19249 AND type_rel = 2
0.0031  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 = '19249' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73553 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  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 = 75859 WHERE rp.league_id = 75859 AND rp.teamId = 19249 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.0034  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 = 75859 WHERE rp.league_id = 75859 AND rp.teamId = 19249 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 75859 WHERE rp.league_id = 75859 AND rp.teamId = 19249 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 75859 WHERE rp.league_id = 75859 AND rp.teamId = 19249 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 75859 WHERE rp.league_id = 75859 AND rp.teamId = 19249 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0062  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 = 75859 WHERE rp.league_id = 75859 AND rp.teamId = 19249 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30