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

Estadísticas

ASISTENCIAS
José Matos5
Curro Sánchez4
Álex Sancris4
Andy3
Ander Martín3
Fer Niño3
Àlex Bermejo2
Dani Ojeda2
Joni Montiel2
E. Saveljich1
Edu Espiau1
Kévin Appin1
ENTRA
Àlex Bermejo25
Ander Martín21
Edu Espiau19
Kévin Appin15
Joni Montiel14
Álex Sancris14
Mumo13
Andy13
Grego Sierra11
Borja González11
Dani Ojeda9
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ño19
Mumo16
Kévin Appin12
Ander Martín9
Àlex Bermejo9
Andy8
Curro Sánchez8
U. Elgezabal8
Joni Montiel6
José Matos6
Edu Espiau5
Borja González5
Raúl Navarro5
Grego Sierra4
E. Saveljich3
A. Arroyo3
Aitor Córdoba2

  USO DE MEMORIA  
5,551,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.0599
Total Execution Time  0.0613
  CADENA URL  
/estadisticas/Burgos-Cf
  GET DATOS  
$_GET['/estadisticas/Burgos-Cf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=565 AND type_rel = 2
0.0028  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.0025  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 (1312832,1193652,2598,2826,5092) ORDER BY n.cover_points DESC, update_date DESC
0.0032  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.0038  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.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 = 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.0045  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