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

Estadísticas

ASISTENCIAS
O. De Marcos6
Nico Williams4
Raúl García3
Mikel Vesga3
Iker Muniain3
I. Williams3
Oihan Sancet2
Dani García2
Iñigo Lekue1
Jon Morcillo1
Yeray1
Álex Berenguer1
Ander Herrera1
G. Guruzeta1
Yuri1
ENTRA
Raúl García29
Oier Zarraga20
G. Guruzeta13
Álex Berenguer11
Iker Muniain11
Jon Morcillo10
Unai Vencedor10
Mikel Vesga8
Ander Herrera8
Adu Ares8
Aitor Paredes7
Dani García7
Iñigo Lekue6
Ander Capa6
O. De Marcos5
Nico Williams4
Asier Villalibre4
Oihan Sancet4
Dani Vivian3
M. Balenziaga2
I. Williams2
Yuri2
J. Agirrezabala1
Yeray1
SALE
Oihan Sancet25
Nico Williams23
I. Williams19
Álex Berenguer16
G. Guruzeta15
Iker Muniain14
Dani García13
O. De Marcos10
Ander Herrera10
Mikel Vesga7
Oier Zarraga6
Iñigo Lekue6
Raúl García5
Yeray5
Yuri2
Unai Simón1
Aitor Paredes1
Ander Capa1
Íñigo Martínez1
M. Balenziaga1
Asier Villalibre1

  USO DE MEMORIA  
5,666,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1314
Total Execution Time  0.1327
  CADENA URL  
/estadisticas/Athletic-Bilbao/2023
  GET DATOS  
$_GET['/estadisticas/Athletic-Bilbao/2023']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=347 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 347 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 (1312923,1312919,1312906,1312900,1312856) ORDER BY n.cover_points DESC, update_date DESC
0.0053  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 = '347' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 67669 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0082  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=347 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0020  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72116,71759,71432,63197) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0048  SELECT count(id) as num_players from rel_players WHERE league_id = 72116 AND teamId = 347
0.0040  SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 347
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 63197 AND teamId = 347
0.0180  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 347
0.0045  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 67669 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0054  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 events2023 e ON e.player_id = p.id AND e.league_id = 67669 WHERE rp.league_id = 67669 AND rp.teamId = 347 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041  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 events2023 e ON e.player_id = p.id AND e.league_id = 67669 WHERE rp.league_id = 67669 AND rp.teamId = 347 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 events2023 e ON e.player_id = p.id AND e.league_id = 67669 WHERE rp.league_id = 67669 AND rp.teamId = 347 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 events2023 e ON e.player_id = p.id AND e.league_id = 67669 WHERE rp.league_id = 67669 AND rp.teamId = 347 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0047  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 events2023 e ON e.player_id = p.id AND e.league_id = 67669 WHERE rp.league_id = 67669 AND rp.teamId = 347 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042  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 events2023 e ON e.player_id = p.id AND e.league_id = 67669 WHERE rp.league_id = 67669 AND rp.teamId = 347 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 67669 ORDER BY nameShow LIMIT 100
0.0029  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1 AND l.year = 2023 ORDER BY l.group_code ASC