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

Estadísticas

ASISTENCIAS
W. Mckennie7
Filip Kostić4
Dušan Vlahović4
Matías Soulé3
M. Locatelli3
A. Cambiaso3
Adrien Rabiot3
Iling Junior2
Hans Nicolussi1
Timothy Weah1
F. Chiesa1
A. Milik1
Nicolò Fagioli1
Danilo1
C. Alcaraz1
Fabio Miretti1
ENTRA
A. Milik21
Iling Junior19
Timothy Weah17
Kenan Yildiz16
Moise Kean10
Dean Huijsen10
Alex Sandro8
A. Cambiaso6
Fabio Miretti6
F. Chiesa6
Dušan Vlahović5
C. Alcaraz5
D. Rugani4
W. Mckennie4
Hans Nicolussi4
Nicolò Fagioli3
Joseph Nonge2
M. Locatelli2
Danilo2
Paul Pogba2
Filip Kostić2
F. Gatti2
N. Sekulov1
Adrien Rabiot1
L. Cerri1
SALE
A. Cambiaso22
Filip Kostić21
Matías Soulé16
F. Chiesa15
Fabio Miretti15
Dušan Vlahović14
W. Mckennie11
Timothy Weah7
Kenan Yildiz7
Moise Kean7
F. Gatti6
M. Locatelli5
Hans Nicolussi3
A. Milik3
Nicolò Fagioli3
C. Alcaraz2
Dean Huijsen2
Iling Junior2
D. Rugani2
Joseph Nonge1
M. De Sciglio1
Alex Sandro1
G. Bremer1
Adrien Rabiot1

  USO DE MEMORIA  
5,790,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0966
Total Execution Time  0.0979
  CADENA URL  
/estadisticas/juventus-fc
  GET DATOS  
$_GET['/estadisticas/juventus-fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1430 AND type_rel = 2
0.0083  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1430 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (1312701,1312542,1312313,1312198,1312187) ORDER BY n.cover_points DESC, update_date DESC
0.0111  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 = '1430' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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 = 73270 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0047  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 72044 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0100  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 = 1430 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0117  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 = 1430 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0101  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 = 1430 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30