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

Estadísticas

ASISTENCIAS
Unai López2
Raúl De Tomás2
Pacha Espino1
Randy Nteka1
Florian Lejeune1
Sergio Camello1
Pep Chavarría1
Álvaro García1
ENTRA
Jorge De Frutos20
R. Falcao17
Bebé16
Kike Pérez13
Pathé Ciss12
Óscar Trejo11
Sergio Camello11
Randy Nteka9
Pep Chavarría8
Raúl De Tomás7
Miguel Crespo6
Andrei Rațiu5
Unai López5
Pacha Espino2
José Ángel Pozo2
Diego Méndez1
Salvi Sánchez1
Abdul Mumin1
Iván Balliu1
Álvaro García1
Isi Palazón1
Óscar Valentín1
SALE
Unai López18
Isi Palazón18
Sergio Camello15
Álvaro García14
Raúl De Tomás14
Óscar Trejo14
Kike Pérez9
Pacha Espino9
Jorge De Frutos8
Óscar Valentín7
Pathé Ciss7
Pep Chavarría4
Iván Balliu3
Andrei Rațiu3
Randy Nteka3
Miguel Crespo2
Florian Lejeune1
Abdul Mumin1
Aridane1

  USO DE MEMORIA  
5,508,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0612
Total Execution Time  0.0624
  CADENA URL  
/estadisticas/rayo-vallecano
  GET DATOS  
$_GET['/estadisticas/rayo-vallecano']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2080 AND type_rel = 2
0.0081  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2080 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (1257644,1278031,1310498,1310678,1310745) ORDER BY n.cover_points DESC, update_date DESC
0.0034  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 = '2080' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0033  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 = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 2080 AND (e.action = 22) 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 = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 2080 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 2080 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30