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

Estadísticas

ASISTENCIAS
Raúl Dacosta6
Andoni López3
Pablo Clavería2
Markel Lozano2
Yuri2
Josep Cerdà2
Borja Valle2
Ernesto Gómez2
Thomas Carrique1
Ale Díez1
ENTRA
David Soto15
Yuri14
Brais Abelenda13
Ale Díez12
Josep Cerdà11
Nil Jiménez11
Pablo Clavería11
Andoni López7
Álvaro Vázquez6
Mangel6
Pol Llonch6
Álex Costa4
Yeray Cabanzón4
Raúl Dacosta4
Jesús4
Antonio Leal4
J. Igbekeme3
Javier Lancho2
Ernesto Gómez2
Thomas Carrique1
Pol Bassa1
Borja Valle1
Markel Lozano1
Palanca1
S. Longo1
Raúl Arias1
SALE
Ernesto Gómez14
Raúl Dacosta14
Yuri9
Pol Llonch9
Pablo Clavería9
S. Longo8
David Soto8
Brais Abelenda7
Josep Cerdà7
Andoni López7
J. Igbekeme6
Borja Valle6
Ale Díez6
Nil Jiménez6
Javier Lancho5
Thomas Carrique4
Kevin Sibille3
Yeray Cabanzón3
Markel Lozano2
Antonio Leal2
Mangel1
Álvaro Vázquez1

  USO DE MEMORIA  
5,509,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1693
Total Execution Time  0.1709
  CADENA URL  
/estadisticas/ponferradina-sd
  GET DATOS  
$_GET['/estadisticas/ponferradina-sd']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3287 AND type_rel = 2
0.0122  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3287 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108  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 (1194,1427,2575,3226,3254) ORDER BY n.cover_points DESC, update_date DESC
0.0122  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 = '3287' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 3287 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 3287 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 3287 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30