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

Estadísticas

ASISTENCIAS
Curro Sánchez4
José Matos4
Álex Sancris4
Andy3
Ander Martín3
Fer Niño3
Dani Ojeda2
Joni Montiel2
E. Saveljich1
Edu Espiau1
Kévin Appin1
Àlex Bermejo1
ENTRA
Àlex Bermejo25
Ander Martín20
Edu Espiau18
Kévin Appin15
Joni Montiel14
Álex Sancris14
Mumo13
Andy13
Grego Sierra11
Borja González10
Dani Ojeda8
A. Arroyo6
Fer Niño5
Miguel Atienza5
J. López-Pinto4
S. Del Cerro2
U. Elgezabal2
Lucas Ricoy2
E. Saveljich1
J. Menor1
Curro Sánchez1
SALE
Dani Ojeda22
Miguel Atienza22
Álex Sancris20
Fer Niño18
Mumo16
Kévin Appin11
Ander Martín9
Andy8
Curro Sánchez8
Àlex Bermejo8
U. Elgezabal8
Joni Montiel6
José Matos6
Edu Espiau5
Borja González5
Raúl Navarro5
Grego Sierra4
E. Saveljich3
Aitor Córdoba2
A. Arroyo2

  USO DE MEMORIA  
5,592,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2064
Total Execution Time  0.2077
  CADENA URL  
/estadisticas/Burgos-Cf
  GET DATOS  
$_GET['/estadisticas/Burgos-Cf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=565 AND type_rel = 2
0.0133  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 565 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (2598,2826,5092,25391,37263) ORDER BY n.cover_points DESC, update_date DESC
0.0140  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 = '565' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0209  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 = 565 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0222  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 = 565 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163  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 = 565 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30