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

Estadísticas

ASISTENCIAS
Luis Rioja4
Jon Guridi4
Javi López3
Carlos Vicente2
Álex Sola2
S. Omorodion1
C. Benavidez1
Antonio Blanco1
Ianis Hagi1
ENTRA
C. Benavidez19
Kike García18
A. Rebbach15
Álex Sola14
N. Tenaglia13
Ianis Hagi12
S. Omorodion9
Giuliano8
Javi López7
Xeber Alkain6
Rubén Duarte6
Carlos Vicente5
Rafa Marín4
Antonio Blanco4
J. Panichelli2
J. Karrikaburu2
M. De La Fuente2
Mamadou Sylla2
V. Parada2
Tomás Mendes1
A. Gorosabel1
Luis Rioja1
Unai Ropero1
Jon Guridi1
SALE
Luis Rioja26
Jon Guridi20
S. Omorodion18
Antonio Blanco11
Álex Sola9
A. Gorosabel9
Ander Guevara9
Kike García9
Ianis Hagi6
A. Rebbach6
Carlos Vicente6
Rubén Duarte5
Javi López3
Xeber Alkain3
C. Benavidez3
A. Sedlar3
A. Abqar3
N. Tenaglia2
J. Panichelli1
Rafa Marín1
M. De La Fuente1

  USO DE MEMORIA  
5,526,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1080
Total Execution Time  0.1095
  CADENA URL  
/estadisticas/alaves
  GET DATOS  
$_GET['/estadisticas/alaves']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=137 AND type_rel = 2
0.0121  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 137 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0034  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 (1311560,1311461,1311454,1257644,1278031) ORDER BY n.cover_points DESC, update_date DESC
0.0080  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 = '137' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0297  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '137' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '137' and rp.type = 4
0.0056  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '137' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '137' and rp.type = 4
0.0039  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 = 137 AND (e.action = 22) 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 = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 137 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 = 137 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30