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

Estadísticas

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

  USO DE MEMORIA  
5,884,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0836
Total Execution Time  0.0848
  CADENA URL  
/estadisticas/betis
  GET DATOS  
$_GET['/estadisticas/betis']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=486 AND type_rel = 2
0.0048  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.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 (1312314,1312340,1312301,1312047,1312029) ORDER BY n.cover_points DESC, update_date DESC
0.0051  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.0062  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.0063  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.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 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
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 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 = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0060  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 = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0060  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 = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30