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

Estadísticas

ASISTENCIAS
Isco4
W. Carvalho3
Chimy Ávila3
Luiz Henrique3
Willian José3
Marc Roca2
Johnny Cardoso2
Nabil Fekir2
Pablo Fornals2
Borja Iglesias1
Héctor Bellerín1
Aitor Ruibal1
Y. Sabaly1
Ayoze1
J. Miranda1
ENTRA
Ez Abde17
Rodri15
W. Carvalho15
Chimy Ávila9
Luiz Henrique8
A. Guardado8
Borja Iglesias7
Aitor Ruibal7
Willian José7
Sergi Altimira6
Abner Vinícius6
Nabil Fekir6
Juan Cruz5
Assane Diao5
J. Miranda4
Guido Rodríguez2
R. Visus2
Chadi Riad2
Ayoze2
Paul2
Pablo Busto2
Sokratis2
Marc Roca2
C. Bakambu2
Héctor Bellerín1
Pablo Fornals1
Johnny Cardoso1
Isco1
Fran Vieites1
SALE
Ayoze15
Willian José15
Isco12
Chimy Ávila12
Assane Diao11
Marc Roca9
Rodri6
J. Miranda6
Guido Rodríguez6
Nabil Fekir5
Ez Abde5
Aitor Ruibal4
Sergi Altimira4
Héctor Bellerín4
Johnny Cardoso4
Luiz Henrique4
G. Pezzella3
A. Guardado3
Borja Iglesias3
Abner Vinícius3
Pablo Fornals3
W. Carvalho3
Chadi Riad2
Y. Sabaly1
Sokratis1
Marc Bartra1
C. Bakambu1
Rui Silva1

  USO DE MEMORIA  
5,922,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3351
Total Execution Time  0.3370
  CADENA URL  
/estadisticas/Betis
  GET DATOS  
$_GET['/estadisticas/Betis']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0256  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74792
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=486 AND type_rel = 2
0.0144  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 486 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (1312549,1312516,1312498,1312372,1312363) ORDER BY n.cover_points DESC, update_date DESC
0.0161  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 = '486' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0173  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=486 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (75879,75586,74792,73873,72116,67728) 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.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 72116 AND teamId = 486
0.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 73873 AND teamId = 486
0.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 74792 AND teamId = 486
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 75879 AND teamId = 486
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 67728 AND teamId = 486
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 75586 AND teamId = 486
0.0150  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 = 486 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.0148  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 = 486 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142  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 = 486 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30