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

Estadísticas

ASISTENCIAS
H. Mkhitaryan8
Marcus Thuram7
F. Dimarco6
D. Dumfries4
Alexis Sánchez4
M. Arnautović3
Carlos Augusto3
Nicoló Barella3
H. Çalhanoğlu3
A. Bastoni3
Juan Cuadrado2
Kristjan Asllani2
B. Pavard2
Lautaro Martínez2
Davide Frattesi1
F. Acerbi1
M. Darmian1
ENTRA
Davide Frattesi25
Carlos Augusto22
M. Arnautović21
Kristjan Asllani16
Alexis Sánchez15
D. Dumfries11
Davy Klaassen10
S. De Vrij8
Yann Bisseck7
Juan Cuadrado7
M. Darmian6
T. Buchanan6
F. Acerbi3
Stefano Sensi3
Nicoló Barella2
B. Pavard2
Lautaro Martínez1
E. Akinsanmiro1
F. Dimarco1
Marcus Thuram1
H. Mkhitaryan1
L. Agoumé1
SALE
F. Dimarco25
Marcus Thuram21
H. Mkhitaryan19
H. Çalhanoğlu19
Nicoló Barella15
Lautaro Martínez13
D. Dumfries12
A. Bastoni12
M. Darmian11
B. Pavard8
Alexis Sánchez3
Davide Frattesi3
Carlos Augusto3
Yann Bisseck1
M. Arnautović1
S. De Vrij1
Kristjan Asllani1
Davy Klaassen1
F. Acerbi1

  USO DE MEMORIA  
5,982,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1820
Total Execution Time  0.1841
  CADENA URL  
/estadisticas/Internazionale
  GET DATOS  
$_GET['/estadisticas/Internazionale']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1381 AND type_rel = 2
0.0055  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1381 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 (1312701,1312187,1312178,1312172,1312167) ORDER BY n.cover_points DESC, update_date DESC
0.0058  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 = '1381' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0047  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=1381 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0029  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 (74790,73270,72044,72038,71432) 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.0050  SELECT count(id) as num_players from rel_players WHERE league_id = 72044 AND teamId = 1381
0.0082  SELECT count(id) as num_players from rel_players WHERE league_id = 74790 AND teamId = 1381
0.0078  SELECT count(id) as num_players from rel_players WHERE league_id = 73270 AND teamId = 1381
0.0066  SELECT count(id) as num_players from rel_players WHERE league_id = 72038 AND teamId = 1381
0.0398  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1381
0.0076  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 = 1381 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.0043  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 = 1381 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  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 = 1381 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0065  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 = 1381 AND (e.action = 22) 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 = 1381 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0067  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 = 1381 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30