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

Cruce de partidos Primera Nacional - Todos los partidos de la temporada

IdaVuelta
 Ferro Carril Oeste Chacarita Juniors Colón Atlanta Quilmes Arsenal de Sarandí CA Estudiantes Racing Córdoba Gimnasia Jujuy San Martín Tucumán Almagro Temperley Atletico Rafaela San Martín San Juan All Boys Nueva Chicago Talleres R. Escalada Aldosivi Deportivo Morón Gimnasia y Tiro Patronato Def. Belgrano Estudiantes Río Cuarto Almirante Brown Chaco For Ever Gimnasia Mendoza Brown Adrogue Dep. Maipú Tristán Suárez Alvarado San Telmo CA San Miguel Def. Unidos Deportivo Madryn Guillermo Brown Argentino Agropecuario Atlético Mitre SdE Club Atlético Güemes
Ferro Carril Oeste Ferro Carril Oeste
Chacarita Juniors Chacarita Juniors
Colón Colón
Atlanta Atlanta
Quilmes Quilmes
Arsenal de Sarandí Arsenal de Sarandí
CA Estudiantes CA Estudiantes
Racing Córdoba Racing Córdoba
Gimnasia Jujuy Gimnasia Jujuy
San Martín Tucumán San Martín Tucumán
Almagro Almagro
Temperley Temperley
Atletico Rafaela Atletico Rafaela
San Martín San Juan San Martín San Juan
All Boys All Boys
Nueva Chicago Nueva Chicago
Talleres R. Escalada Talleres R. Escalada
Aldosivi Aldosivi
Deportivo Morón Deportivo Morón
Gimnasia y Tiro Gimnasia y Tiro
Patronato Patronato
Def. Belgrano Def. Belgrano
Estudiantes Río Cuarto Estudiantes Río Cuarto
Almirante Brown Almirante Brown
Chaco For Ever Chaco For Ever
Gimnasia Mendoza Gimnasia Mendoza
Brown Adrogue Brown Adrogue
Dep. Maipú Dep. Maipú
Tristán Suárez Tristán Suárez
Alvarado Alvarado
San Telmo San Telmo
CA San Miguel CA San Miguel
Def. Unidos Def. Unidos
Deportivo Madryn Deportivo Madryn
Guillermo Brown Guillermo Brown
Argentino Agropecuario Argentino Agropecuario
Atlético Mitre SdE Atlético Mitre SdE
Club Atlético Güemes Club Atlético Güemes

  USO DE MEMORIA  
10,128,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3905
Total Execution Time  0.3925
  CADENA URL  
/primera_b_nacional2024/grupo1/cruces
  GET DATOS  
$_GET['/primera_b_nacional2024/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0105  SELECT type FROM routes WHERE alias = 'primera_b_nacional2024'
0.0213  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.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=192 AND type_rel = 3
0.0114  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 192 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0112  SELECT /*53 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 (1300740,1300585,1297543,1297675,1290706) ORDER BY n.cover_points DESC, update_date DESC
0.0225  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2024 AS c WHERE c.league_id='75057' ORDER BY c.id ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 11:44:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 11:44:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 11:44:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 11:44:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0200  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.0326  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.0117  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.0127  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