4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Serie A 2024
2023/2024

liga italiana, calcio,primera division italia,primera division italiana,liga de italia,serie

Serie A 2024

  • Inter
  • Milan
  • Juventus
  • Bologna
  • Roma
  • Atalanta
  • Lazio
  • Napoli
  • Fiorentina
  • Torino
  • AC Monza
  • Genoa
  • Lecce
  • Cagliari
  • Hellas Verona
  • Frosinone
  • Empoli
  • Udinese
  • Sassuolo
  • Salernitana

Clasificación

Equipo PJ GF GC Puntos
1 Inter Inter 33 79 18 86
2 Milan Milan 33 64 39 69
3 Juventus Juventus 33 47 26 64
4 Bologna Bologna 33 48 26 62
5 Roma Roma 33 59 39 58
6 Atalanta Atalanta 32 59 37 54
7 Lazio Lazio 33 42 35 52
8 Napoli Napoli 33 50 41 49
9 Fiorentina Fiorentina 32 45 36 47
10 Torino Torino 33 31 29 46
11 AC Monza AC Monza 33 35 43 43
12 Genoa Genoa 33 35 40 39
13 Lecce Lecce 33 30 48 35
14 Cagliari Cagliari 33 36 56 32
15 Hellas Verona Hellas 33 31 44 31
16 Frosinone Frosinone 34 43 63 31
17 Empoli Empoli 33 26 48 31
18 Udinese Udinese 33 31 50 28
19 Sassuolo Sassuolo 33 39 65 26
20 Salernitana Salernitana 34 26 73 15

  USO DE MEMORIA  
5,252,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1533
Total Execution Time  0.1551
  CADENA URL  
/serie_a2024/grupo1/resumen/8
  GET DATOS  
$_GET['/serie_a2024/grupo1/resumen/8']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0023  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2 FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 72044 AND c.`round` = 8 ORDER BY shedule ASC LIMIT 200
0.0045  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 34 AND e.real_date IS NOT NULL AND e.league_id = 72044 ORDER BY total DESC LIMIT 100
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 11:34:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 11:34:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 11:34:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 11:34:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0457  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72044 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0579  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72044 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0066  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72044 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10