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

Estadísticas

ASISTENCIAS
R. Calafiori4
Joshua Zirkzee4
V. Kristiansen3
Lewis Ferguson3
Stefan Posch2
R. Orsolini2
G. Fabbian2
A. Saelemaekers2
O. El Azzouzi2
Dan Ndoye1
M. Aebischer1
C. Lykogiannis1
Sam Beukema1
Remo Freuler1
ENTRA
G. Fabbian13
K. Urbanski12
Dan Ndoye12
Nikola Moro12
C. Lykogiannis11
M. Aebischer10
O. El Azzouzi10
R. Orsolini10
L. De Silvestri8
S. Van Hooijdonk7
A. Saelemaekers7
V. Kristiansen6
Jhon Lucumí6
T. Corazza6
S. Castro4
R. Calafiori4
Jens Odgaard3
Remo Freuler2
Kevin Bonifazi2
J. Karlsson2
Stefan Posch2
Joshua Zirkzee2
N. Domínguez1
SALE
Joshua Zirkzee14
Dan Ndoye13
A. Saelemaekers12
R. Orsolini12
M. Aebischer12
V. Kristiansen10
Stefan Posch10
Nikola Moro9
Remo Freuler8
C. Lykogiannis7
G. Fabbian7
L. De Silvestri6
Lewis Ferguson6
K. Urbanski5
J. Karlsson4
Jens Odgaard3
O. El Azzouzi3
S. Van Hooijdonk2
Sam Beukema2
R. Calafiori2
Jhon Lucumí1
T. Corazza1
N. Domínguez1

  USO DE MEMORIA  
5,428,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.0586
Total Execution Time  0.0603
  CADENA URL  
/estadisticas/Bologna
  GET DATOS  
$_GET['/estadisticas/Bologna']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=522 AND type_rel = 2
0.0033  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 522 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (7747,7925,8579,9191,9345) ORDER BY n.cover_points DESC, update_date DESC
0.0044  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 = '522' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0055  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 = 72044 WHERE rp.league_id = 72044 AND rp.teamId = 522 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0053  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 = 72044 WHERE rp.league_id = 72044 AND rp.teamId = 522 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0052  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 = 72044 WHERE rp.league_id = 72044 AND rp.teamId = 522 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30