4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
23 Mar 19 TrasandinoTrasandino 0 - 0 San Luis de QuillotaLuis 3
23 Mar 19 San Antonio UnidoAntonio 1 - 2 La SerenaLa Serena 3
23 Mar 19 ColinaColina 1 - 3 Santiago MorningSantiago 2
23 Mar 19 Deportes RengoDeportes 2 - 3 BarnecheaBarnechea ...
23 Mar 19 Deportes VallenarDeportes 2 - 1 Deportes CopiapóDeportes 1
23 Mar 19 CDSC IberiaCDSC Iberia 1 - 2 ÑublenseÑublense ...
24 Mar 19 Fernández VialFernández 2 - 2 Deportes TemucoDeportes 4
24 Mar 19 San Marcos AricaMarcos 3 - 1 CobreloaCobreloa 6
24 Mar 19 RecoletaRecoleta 0 - 0 Unión San FelipeUnión ...
24 Mar 19 Lautaro de BuinLautaro 0 - 3 CD MelipillaMelipilla ...
24 Mar 19 General VelásquezGeneral 1 - 4 MagallanesMagallanes ...
24 Mar 19 ColchaguaColchagua 1 - 1 Deportes Santa CruzDeportes 2
24 Mar 19 Independiente CauquenesIndependien 2 - 2 Rangers TalcaRangers 12
24 Mar 19 ConcepciónConcepción 1 - 4 Santiago WanderersSantiago 18
24 Mar 19 PilmahuePilmahue 0 - 2 Deportes ValdiviaDeportes ...
24 Mar 19 CD Provincial OsornoProvincial 1 - 3 Puerto MonttPuerto ...
Ver jornada
Jornada 2
09 Jun 19 BarnecheaBarnechea 1 - 2 AntofagastaAntofagasta 3
08 Jun 19 TrasandinoTrasandino 0 - 1 EvertonEverton 4
08 Jun 19 Rangers TalcaRangers 0 - 2 Univ de ChileUniv Chile 6
08 Jun 19 MagallanesMagallanes 0 - 2 Unión La CaleraUnión ...
09 Jun 19 Santiago MorningSantiago 1 - 1 PalestinoPalestino 8
08 Jun 19 CD MelipillaMelipilla 0 - 0 Unión EspañolaUnión 7
08 Jun 19 Santiago WanderersSantiago 1 - 2 Audax ItalianoAudax 5
09 Jun 19 Deportes Santa CruzDeportes 3 - 2 O'HigginsO'Higgins 10
09 Jun 19 Deportes VallenarDeportes 1 - 0 CobresalCobresal 6
09 Jun 19 La SerenaLa Serena 1 - 0 U. CatólicaCatólica 18
09 Jun 19 Unión San FelipeUnión 3 - 1 Coquimbo UnidoCoquimbo 3
09 Jun 19 Puerto MonttPuerto 2 - 0 Colo-ColoColo-Colo 29
09 Jun 19 Deportes ValdiviaDeportes 0 - 0 Univ. ConcepciónUniv. 6
09 Jun 19 Deportes TemucoDeportes 2 - 1 HuachipatoHuachipato 4
09 Jun 19 ÑublenseÑublense 0 - 1 Curicó UnidoCuricó 10
31 May 19 San Marcos AricaMarcos 0 - 2 Deportes IquiqueDeportes 25
12 Jun 19 Audax ItalianoAudax 3 - 1 Santiago WanderersSantiago 50
11 Jul 19 Unión EspañolaUnión 0 - 0 CD MelipillaMelipilla 44
10 Jul 19 U. CatólicaCatólica 2 - 1 La SerenaLa Serena 51
09 Jul 19 CobresalCobresal 3 - 0 Deportes VallenarDeportes 12
05 Jun 19 PalestinoPalestino 4 - 3 Santiago MorningSantiago 94
13 Jun 19 O'HigginsO'Higgins 4 - 1 Deportes Santa CruzDeportes 12
13 Jun 19 Univ. ConcepciónUniv. 1 - 1 Deportes ValdiviaDeportes 20
07 Jul 19 EvertonEverton 1 - 0 TrasandinoTrasandino 7
13 Jun 19 Univ de ChileUniv Chile 1 - 1 Rangers TalcaRangers 111
05 Jun 19 Deportes IquiqueDeportes 2 - 0 San Marcos AricaMarcos 8
13 Jun 19 Unión La CaleraUnión 3 - 2 MagallanesMagallanes 17
13 Jun 19 AntofagastaAntofagasta 1 - 2 BarnecheaBarnechea 72
07 Jul 19 HuachipatoHuachipato 1 - 1 Deportes TemucoDeportes 26
14 Jun 19 Coquimbo UnidoCoquimbo 1 - 1 Unión San FelipeUnión 19
13 Jun 19 Curicó UnidoCuricó 1 - 2 ÑublenseÑublense 43
14 Jun 19 Colo-ColoColo-Colo 4 - 2 Puerto MonttPuerto 104
Ver jornada
Jornada 3
14 Jul 19 Audax ItalianoAudax 0 - 0 Unión San FelipeUnión 26
20 Jul 19 Unión San FelipeUnión 0 - 1 Audax ItalianoAudax 1
15 Jul 19 Colo-ColoColo-Colo 3 - 0 BarnecheaBarnechea 46
21 Jul 19 BarnecheaBarnechea 0 - 3 Colo-ColoColo-Colo 15
14 Jul 19 Unión La CaleraUnión 1 - 1 ÑublenseÑublense 6
21 Jul 19 ÑublenseÑublense 1 - 1 Unión La CaleraUnión 4
14 Jul 19 Deportes TemucoDeportes 0 - 1 Univ de ChileUniv Chile 10
20 Jul 19 Univ de ChileUniv Chile 2 - 0 Deportes TemucoDeportes 8
13 Jul 19 EvertonEverton 1 - 0 O'HigginsO'Higgins 11
20 Jul 19 O'HigginsO'Higgins 1 - 1 EvertonEverton 10
14 Jul 19 Deportes IquiqueDeportes 1 - 1 CobresalCobresal 3
20 Jul 19 CobresalCobresal 3 - 1 Deportes IquiqueDeportes 3
13 Jul 19 Unión EspañolaUnión 0 - 0 Deportes ValdiviaDeportes 16
05 Sep 19 Deportes ValdiviaDeportes 0 - 2 Unión EspañolaUnión 16
16 Jul 19 Santiago MorningSantiago 0 - 2 U. CatólicaCatólica 20
08 Ago 19 U. CatólicaCatólica 3 - 1 Santiago MorningSantiago 38
Ver jornada
Jornada 4
07 Sep 19 CobresalCobresal 3 - 1 Univ de ChileUniv Chile 8
12 Oct 19 Univ de ChileUniv Chile 4 - 1 CobresalCobresal 29
07 Sep 19 Colo-ColoColo-Colo 2 - 1 EvertonEverton 35
12 Oct 19 EvertonEverton 1 - 2 Colo-ColoColo-Colo 12
08 Sep 19 Unión La CaleraUnión 2 - 1 U. CatólicaCatólica 15
13 Oct 19 U. CatólicaCatólica 2 - 0 Unión La CaleraUnión 18
08 Sep 19 Audax ItalianoAudax 0 - 1 Unión EspañolaUnión 12
12 Oct 19 Unión EspañolaUnión 2 - 1 Audax ItalianoAudax 14
Ver jornada
Jornada 5
19 Ene 20 Univ de ChileUniv Chile 3 - 0 Unión EspañolaUnión 11
18 Ene 20 U. CatólicaCatólica 1 - 1 Colo-ColoColo-Colo 29
Ver jornada
Jornada 6
22 Ene 20 Univ de ChileUniv Chile 1 - 2 Colo-ColoColo-Colo 35

  USO DE MEMORIA  
4,779,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4188
Total Execution Time  0.4207
  CADENA URL  
/copa_chile2020/grupo0/calendario
  GET DATOS  
$_GET['/copa_chile2020/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0147  SELECT type FROM routes WHERE alias = 'copa_chile2020'
0.0302  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_chile' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=541 ORDER BY order_id ASC
0.0148  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 49336 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  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, dt1.stadium as stadium_name FROM calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 49336 ORDER BY round ASC
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 11:44:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 11:44:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 11:44:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 11:44:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0156  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 541 AND l.year = 2020
0.0165  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (49336) 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, e.player_id ASC LIMIT 10
0.0169  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (49336) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (280288,209100,232369,93428,94118,131876,150691,195996,196032,223937) ORDER BY rp.in_squad = 1 DESC
0.0149  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 541 AND l.year = 2020
0.0152  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (49336) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0152  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (49336) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (93428,61473,84087,92648,101332,132066,150690,154627,194735,195339) ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 541 AND l.year = 2020
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (49336) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0152  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (49336) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (203440,48361,84087,84115,93428,94524,101332,106214,131540,150690) ORDER BY rp.in_squad = 1 DESC