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

Estadísticas

ASISTENCIAS
Omar El Hilali4
Edu Expósito4
Brian Oliván3
Jofre3
Keidi Bare3
Nico Melamed3
Ramon2
Javi Puado2
Víctor Ruiz2
Pere Milla2
M. Braithwaite2
Álvaro Aguado2
Gastón1
Pol Lozano1
L. Cabrera1
ENTRA
Keita Baldé18
Salvi Sánchez17
Keidi Bare13
Jofre13
Ramon10
José Gragera10
Sergi Gómez9
Óscar Gil9
J. Lazo9
Pere Milla8
Gastón7
Álvaro Aguado7
Edu Expósito6
Rubén Sánchez5
Nico Melamed4
Omar El Hilali4
L. Cabrera3
Pol Lozano3
M. Braithwaite2
F. Calero2
Víctor Ruiz2
Antoniu2
Javi Puado2
Brian Oliván2
L. Dimata2
Roger1
Kenneth1
SALE
Pere Milla20
Jofre16
Álvaro Aguado15
Nico Melamed14
Edu Expósito12
Keidi Bare11
Omar El Hilali9
Pol Lozano9
Brian Oliván8
Javi Puado8
Rubén Sánchez7
José Gragera6
Salvi Sánchez5
F. Calero5
M. Braithwaite4
Víctor Ruiz4
Sergi Gómez4
J. Lazo3
Óscar Gil3
Omar Sadik2
Keita Baldé2
L. Cabrera2
Ian Forns2
Ramon2
Gastón1

  USO DE MEMORIA  
5,678,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.0941
Total Execution Time  0.0959
  CADENA URL  
/estadisticas/Espanyol
  GET DATOS  
$_GET['/estadisticas/Espanyol']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=998 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 998 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (1312875,1312694,1311883,1311709,1310717) ORDER BY n.cover_points DESC, update_date DESC
0.0038  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 = '998' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0034  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '998' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '998' and rp.type = 4
0.0027  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '998' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '998' and rp.type = 4
0.0054  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 998 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0069  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 998 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0071  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 998 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30