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
  • Fiorentina
  • Napoli
  • Torino
  • AC Monza
  • Genoa
  • Lecce
  • Cagliari
  • Hellas Verona
  • Frosinone
  • Empoli
  • Udinese
  • Sassuolo
  • Salernitana

Clasificación

Equipo PJ GF GC Puntos
1 Inter Inter 35 81 19 89
2 Milan Milan 34 64 39 70
3 Juventus Juventus 34 47 26 65
4 Bologna Bologna 35 49 27 64
5 Roma Roma 34 61 41 59
6 Atalanta Atalanta 33 61 37 57
7 Lazio Lazio 35 45 37 56
8 Fiorentina Fiorentina 34 51 38 51
9 Napoli Napoli 34 52 43 50
10 Torino Torino 35 31 31 47
11 AC Monza AC Monza 35 38 46 45
12 Genoa Genoa 34 38 40 42
13 Lecce Lecce 35 32 50 37
14 Cagliari Cagliari 35 37 60 33
15 Hellas Verona Hellas 35 32 46 32
16 Frosinone Frosinone 35 43 63 32
17 Empoli Empoli 35 26 50 32
18 Udinese Udinese 34 32 51 29
19 Sassuolo Sassuolo 35 41 70 29
20 Salernitana Salernitana 34 26 73 15

  USO DE MEMORIA  
5,315,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2750
Total Execution Time  0.2769
  CADENA URL  
/serie_a2024/grupo1/resumen/5
  GET DATOS  
$_GET['/serie_a2024/grupo1/resumen/5']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0133  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` = 5 ORDER BY shedule ASC LIMIT 200
0.0150  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 = 35 AND e.real_date IS NOT NULL AND e.league_id = 72044 ORDER BY total DESC LIMIT 100
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 14:12:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 14:12:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 14:12:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 14:12:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0328  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.0538  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.0148  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