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

Clasificación

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

  USO DE MEMORIA  
5,980,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3100
Total Execution Time  0.3121
  CADENA URL  
/primera_b_nacional2024/grupo1/minutoaminuto
  GET DATOS  
$_GET['/primera_b_nacional2024/grupo1/minutoaminuto']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0105  SELECT type FROM routes WHERE alias = 'primera_b_nacional2024'
0.0214  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.0283  SELECT 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.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 75057 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 100
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 04:10:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 04:10:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 04:10:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 04:10:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0448  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.0271  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.0116  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.0124  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 = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC