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

Estadísticas

ASISTENCIAS
A. El Messaoudi3
Joel Asoro2
A. Hrustić2
D. Zeefuik2
C. Benschop2
R. Lundqvist2
Ritsu Doan1
D. Warmerdam1
Mo El Hankouri1
Sam Schreck1
K. Sierhuis1
ENTRA
Mo El Hankouri11
C. Benschop10
R. Postema9
Sam Schreck7
G. Gudmundsson7
Ritsu Doan7
A. El Messaoudi5
S. Memisevic5
Ko Itakura4
R. Lundqvist3
Kian Slor2
D. Warmerdam2
A. Hrustić2
Joel Asoro2
D. Van Kaam2
K. Sierhuis2
Daishawn Redan1
Tomáš Suslov1
Thomas Poll1
A. Absalem1
SALE
A. Hrustić14
K. Sierhuis13
R. Lundqvist9
Ritsu Doan6
Sam Schreck5
Joel Asoro5
D. Warmerdam4
G. Gudmundsson4
A. Matusiwa4
B. Van Hintum4
Daishawn Redan3
C. Benschop3
D. Van Kaam3
Mo El Hankouri2
M. Te Wierik1
R. Postema1
A. Absalem1
A. El Messaoudi1

  USO DE MEMORIA  
5,299,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0551
Total Execution Time  0.0563
  CADENA URL  
/estadisticas/Fc-Groningen/2020
  GET DATOS  
$_GET['/estadisticas/Fc-Groningen/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1068 AND type_rel = 2
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1068 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (4597,6413,6719,8738,8911) ORDER BY n.cover_points DESC, update_date DESC
0.0055  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 = '1068' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0042  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 events2020 e ON e.player_id = p.id AND e.league_id = 49848 WHERE rp.league_id = 49848 AND rp.teamId = 1068 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 events2020 e ON e.player_id = p.id AND e.league_id = 49848 WHERE rp.league_id = 49848 AND rp.teamId = 1068 AND (e.action = 19) 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 events2020 e ON e.player_id = p.id AND e.league_id = 49848 WHERE rp.league_id = 49848 AND rp.teamId = 1068 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30