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

Estadísticas

ASISTENCIAS
Jesús Areso4
Chimy Ávila3
J. Mojica2
A. Budimir2
A. Catena2
J. Moncayola2
Rubén García2
Rubén Peña1
Pablo Ibáñez1
Raúl García1
José Arnaiz1
Aimar Oroz1
J. Herrando1
David García1
Juan Cruz1
ENTRA
Raúl García21
Pablo Ibáñez20
José Arnaiz13
Kike Barja13
Rubén García11
J. Moncayola10
Nacho Vidal9
Chimy Ávila9
Iker Muñoz8
J. Mojica7
Jesús Areso7
Juan Cruz5
Aimar Oroz5
Lucas Torró4
Moi Gómez3
A. Budimir3
Rubén Peña3
A. Catena2
D. Brašanac2
Unai García1
J. Herrando1
Íñigo Arguibide1
Aitor Fernández1
A. Osambela1
SALE
A. Budimir18
Aimar Oroz16
Rubén Peña15
J. Moncayola12
Moi Gómez12
Rubén García12
Chimy Ávila12
Lucas Torró10
José Arnaiz8
Raúl García7
Pablo Ibáñez7
Jesús Areso6
J. Mojica6
Iker Muñoz5
Juan Cruz4
Nacho Vidal3
Kike Barja3
A. Catena2
David García2
J. Herrando1
Unai García1
Sergio Herrera1

  USO DE MEMORIA  
5,864,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0642
Total Execution Time  0.0654
  CADENA URL  
/estadisticas/Osasuna
  GET DATOS  
$_GET['/estadisticas/Osasuna']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1887 AND type_rel = 2
0.0074  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1887 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 (1312482,1312184,1311854,1311772,1311744) 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 = '1887' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 1887 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046  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 = 1887 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046  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 = 1887 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30