Cruce de partidos Preferente Aragón - Todos los partidos de la temporada

IdaVuelta
 Sabiñánigo Fraga Sariñena Casetas Jacetano CD Mequinenza CDJ Tamarite Valdefierro San Lorenzo Flumen Atlético Escalerillas Peña Ferranca Peñas Oscenses UD Montecarlo Alcolea CF Internacional Huesca Almunia San Juan Zaragoza 2014
Sabiñánigo Sabiñánigo
Fraga Fraga
Sariñena Sariñena
Casetas Casetas
Jacetano Jacetano
CD Mequinenza CD Mequinenza
CDJ Tamarite CDJ Tamarite
Valdefierro Valdefierro
San Lorenzo Flumen San Lorenzo Flumen
Atlético Escalerillas Atlético Escalerillas
Peña Ferranca Peña Ferranca
Peñas Oscenses Peñas Oscenses
UD Montecarlo UD Montecarlo
Alcolea CF Alcolea CF
Internacional Huesca Internacional Huesca
Almunia San Juan Almunia San Juan
Zaragoza 2014 Zaragoza 2014

  USO DE MEMORIA  
6,313,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1252
Total Execution Time  0.1271
  CADENA URL  
/aragon2022/grupo1/cruces
  GET DATOS  
$_GET['/aragon2022/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0040  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2022 AS c WHERE c.league_id='63838' ORDER BY c.id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 19:28:50' 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-19 19:28:50' 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-19 19:28:50' 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=3 AND last_update > '2024-04-19 19:28:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0196  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 events2022 e ON e.player_id = p.id AND e.league_id = 63838 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63838 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.0245  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 events2022 e ON e.player_id = p.id AND e.league_id = 63838 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63838 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0040  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 events2022 e ON e.player_id = p.id AND e.league_id = 63838 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63838 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0050  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 63838 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC