4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del PEC Zwolle

PEC Zwolle

Entrenador: Johnny Jansen

Estadísticas

ENTRA
D. Chirino22
G. Kastaneer21
A. Vellios17
H. Acheffay13
Sven Zitman11
G. Caschili10
Sam Kersten10
J. Tutuarima9
A. Fontana9
Lennart Thy8
Chardi Landu8
Dean Huiberts7
R. Van Den Berg7
D. Van Den Berg6
Melayro Bogarde5
Samir Lagsir5
Jimmy Kaparos4
H. Medunjanin3
Younes Taha2
Ryan Thomas2
Thomas Beelen2
B. Van Hintum1
Bram Van Polen1
M. Hauptmeijer1
Dean Guezen1

  USO DE MEMORIA  
5,461,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1669
Total Execution Time  0.1681
  CADENA URL  
/estadisticas/Fc-Zwolle/2023
  GET DATOS  
$_GET['/estadisticas/Fc-Zwolle/2023']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1127 AND type_rel = 2
0.0108  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1127 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (3705,3773,9063,9678,17243) ORDER BY n.cover_points DESC, update_date DESC
0.0113  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 = '1127' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0123  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 events2023 e ON e.player_id = p.id AND e.league_id = 67927 WHERE rp.league_id = 67927 AND rp.teamId = 1127 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0119  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 events2023 e ON e.player_id = p.id AND e.league_id = 67927 WHERE rp.league_id = 67927 AND rp.teamId = 1127 AND (e.action = 19) 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 events2023 e ON e.player_id = p.id AND e.league_id = 67927 WHERE rp.league_id = 67927 AND rp.teamId = 1127 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30