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

Clasificación

Equipo PJ GF GC Puntos
1 San Martín Tucumán Martín 13 14 5 24
2 Quilmes Quilmes 13 16 6 23
3 San Martín San Juan Martín Juan 13 12 10 21
4 CA Estudiantes Estudiantes 13 9 7 21
5 Chacarita Juniors Chacarita 13 14 12 19
6 All Boys All Boys 13 9 7 19
7 Gimnasia Jujuy Gimnasia 13 11 10 18
8 Argentino Agropecuario Argentino 13 18 14 17
9 Ferro Carril Oeste Ferro Carril 13 19 17 17
10 Arsenal de Sarandí Arsenal 13 10 11 17
11 Racing Córdoba Racing 13 10 11 17
12 CA San Miguel Miguel 12 10 8 16
13 Alvarado Alvarado 13 9 12 16
14 Guillermo Brown Guillermo 13 11 14 14
15 Talleres R. Escalada Talleres 13 9 14 14
16 Dep. Maipú Dep. Maipú 13 10 18 14
17 Patronato Patronato 12 9 15 12
18 Club Atlético Güemes Club 13 8 13 11
19 Tristán Suárez Tristán 13 13 19 10
20 Colón Colón 13 22 9 28
21 San Telmo San Telmo 13 19 7 28
22 Def. Belgrano Def. 13 20 11 23
23 Nueva Chicago Nueva 13 11 5 21
24 Aldosivi Aldosivi 13 14 9 21
25 Estudiantes Río Cuarto Estudiantes 13 13 8 20
26 Gimnasia y Tiro Gimnasia 13 10 6 20
27 Deportivo Morón Deportivo 13 15 17 17
28 Gimnasia Mendoza Gimnasia 13 14 16 17
29 Temperley Temperley 13 12 12 16
30 Def. Unidos Def. Unidos 13 12 15 16
31 Atlanta Atlanta 13 11 15 16
32 Chaco For Ever Chaco Ever 13 13 12 15
33 Deportivo Madryn Deportivo 13 9 11 15
34 Atlético Mitre SdE Atlético 13 6 8 14
35 Almagro Almagro 13 8 17 14
36 Atletico Rafaela Atletico 13 9 15 9
37 Almirante Brown Almirante 13 7 14 8
38 Brown Adrogue Brown 13 7 23 8

  USO DE MEMORIA  
5,990,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.1356
Total Execution Time  0.1387
  CADENA URL  
/primera_b_nacional2024/grupo1/resumen/7
  GET DATOS  
$_GET['/primera_b_nacional2024/grupo1/resumen/7']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0020  SELECT type FROM routes WHERE alias = 'primera_b_nacional2024'
0.0046  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_nacional' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0074  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` = 75057 AND c.`round` = 7 ORDER BY shedule ASC LIMIT 200
0.0085  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 = 14 AND e.real_date IS NOT NULL AND e.league_id = 75057 ORDER BY total DESC LIMIT 100
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 09:32:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 09:32:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 09:32:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 09:32:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0362  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 = 75057 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75057 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.0228  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 = 75057 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75057 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031  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 = 75057 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75057 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0051  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 75057 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC