4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
15 Feb 23 Boyacá Chicó Boyacá 1 - 1 Real CartagenaReal 262
23 Feb 23 Real CartagenaReal 0 - 0 Boyacá Chicó Boyacá 86
16 Feb 23 Alianza FCAlianza FC 4 - 1 Real SantanderReal 46
23 Feb 23 Real SantanderReal 1 - 0 Alianza FCAlianza FC 40
15 Feb 23 Atlético Fútbol ClubAtlético 2 - 0 EnvigadoEnvigado 149
22 Feb 23 EnvigadoEnvigado 2 - 0 Atlético Fútbol ClubAtlético 43
16 Feb 23 BarranquillaBarranquill 3 - 3 Deportivo CaliDeportivo 105
24 Feb 23 Deportivo CaliDeportivo 6 - 0 BarranquillaBarranquill 82
15 Feb 23 Real CundinamarcaReal 0 - 2 Jaguares FCJaguares 104
22 Feb 23 Jaguares FCJaguares 1 - 0 Real CundinamarcaReal 28
16 Feb 23 Boca Juniors de CaliBoca 0 - 1 Unión MagdalenaUnión 29
22 Feb 23 Unión MagdalenaUnión 3 - 0 Boca Juniors de CaliBoca 29
14 Feb 23 Orsomarso SCOrsomarso 1 - 0 Atlético HuilaAtlético 62
22 Feb 23 Atlético HuilaAtlético 0 - 0 Orsomarso SCOrsomarso 211
16 Feb 23 Cúcuta DeportivoCúcuta 3 - 1 Once CaldasOnce Caldas 68
23 Feb 23 Once CaldasOnce Caldas 1 - 0 Cúcuta DeportivoCúcuta 85
Ver jornada
Jornada 2
17 Mar 23 Deportes QuindíoDeportes 0 - 2 Cúcuta DeportivoCúcuta 85
16 Mar 23 Patriotas BoyacáPatriotas 0 - 0 Orsomarso SCOrsomarso 45
15 Mar 23 FortalezaFortaleza 2 - 1 Unión MagdalenaUnión 55
16 Mar 23 LlanerosLlaneros 1 - 1 Jaguares FCJaguares 71
16 Mar 23 LeonesLeones 0 - 0 Deportivo CaliDeportivo 124
15 Mar 23 Tigres FCTigres FC 1 - 1 EnvigadoEnvigado 39
17 Mar 23 BogotáBogotá 2 - 2 Alianza FCAlianza FC 96
15 Mar 23 Internacional de PalmiraInternacion 1 - 3 Real CartagenaReal 80
30 Mar 23 Cúcuta DeportivoCúcuta 0 - 0 Deportes QuindíoDeportes 148
28 Mar 23 Orsomarso SCOrsomarso 1 - 0 Patriotas BoyacáPatriotas 54
31 Mar 23 Unión MagdalenaUnión 4 - 2 FortalezaFortaleza 87
30 Mar 23 Jaguares FCJaguares 1 - 0 LlanerosLlaneros 73
30 Mar 23 Deportivo CaliDeportivo 2 - 0 LeonesLeones 79
29 Mar 23 EnvigadoEnvigado 0 - 0 Tigres FCTigres FC 321
29 Mar 23 Alianza FCAlianza FC 1 - 0 BogotáBogotá 133
30 Mar 23 Real CartagenaReal 2 - 1 Internacional de PalmiraInternacion 136
Ver jornada
Jornada 3
05 Abr 23 Unión MagdalenaUnión 1 - 0 Tigres FCTigres FC 27
02 May 23 Tigres FCTigres FC 1 - 0 Unión MagdalenaUnión 59
06 Abr 23 Deportivo CaliDeportivo 1 - 0 Jaguares FCJaguares 94
04 May 23 Jaguares FCJaguares 1 - 0 Deportivo CaliDeportivo 167
06 Abr 23 Orsomarso SCOrsomarso 1 - 1 Alianza FCAlianza FC 174
03 May 23 Alianza FCAlianza FC 3 - 1 Orsomarso SCOrsomarso 47
13 Abr 23 Real CartagenaReal 0 - 1 Cúcuta DeportivoCúcuta 90
03 May 23 Cúcuta DeportivoCúcuta 0 - 0 Real CartagenaReal 78
Ver jornada
Jornada 4
27 Jul 23 América de CaliAmérica 1 - 3 At. NacionalNacional 325
18 Ago 23 At. NacionalNacional 2 - 1 América de CaliAmérica 612
28 Jul 23 Deportivo CaliDeportivo 2 - 1 Santa FeSanta Fe 386
17 Ago 23 Santa FeSanta Fe 1 - 0 Deportivo CaliDeportivo 396
27 Jul 23 Cúcuta DeportivoCúcuta 4 - 3 JuniorJunior 546
17 Ago 23 JuniorJunior 2 - 1 Cúcuta DeportivoCúcuta 660
17 Ago 23 Deportivo PereiraDeportivo 1 - 0 Tigres FCTigres FC 92
26 Jul 23 Tigres FCTigres FC 0 - 1 Deportivo PereiraDeportivo 344
11 Ago 23 MillonariosMillonarios 3 - 1 Atlético BucaramangaAtlético 271
18 Ago 23 Atlético BucaramangaAtlético 0 - 0 MillonariosMillonarios 519
26 Jul 23 La EquidadLa Equidad 1 - 0 Águilas DoradasÁguilas 313
17 Ago 23 Águilas DoradasÁguilas 2 - 1 La EquidadLa Equidad 150
10 Ago 23 Independiente MedellínIndependien 3 - 1 Deportivo PastoDeportivo 160
18 Ago 23 Deportivo PastoDeportivo 3 - 1 Independiente MedellínIndependien 346
27 Jul 23 Alianza FCAlianza FC 2 - 0 Deportes TolimaDeportes 231
17 Ago 23 Deportes TolimaDeportes 2 - 0 Alianza FCAlianza FC 256
Ver jornada
Jornada 5
29 Sep 23 MillonariosMillonarios 2 - 0 Alianza FCAlianza FC 426
28 Sep 23 Águilas DoradasÁguilas 0 - 3 At. NacionalNacional 542
29 Sep 23 Cúcuta DeportivoCúcuta 0 - 1 Independiente MedellínIndependien 532
28 Sep 23 Santa FeSanta Fe 0 - 0 Deportivo PereiraDeportivo 710
06 Oct 23 Independiente MedellínIndependien 1 - 2 Cúcuta DeportivoCúcuta 802
05 Oct 23 Deportivo PereiraDeportivo 2 - 0 Santa FeSanta Fe 200
05 Oct 23 At. NacionalNacional 2 - 1 Águilas DoradasÁguilas 291
06 Oct 23 Alianza FCAlianza FC 1 - 2 MillonariosMillonarios 480
Ver jornada
Jornada 6
03 Nov 23 MillonariosMillonarios 1 - 0 Cúcuta DeportivoCúcuta 611
20 Oct 23 Deportivo PereiraDeportivo 2 - 0 At. NacionalNacional 863
05 Nov 23 Cúcuta DeportivoCúcuta 1 - 1 MillonariosMillonarios 405
02 Nov 23 At. NacionalNacional 3 - 1 Deportivo PereiraDeportivo 322
Ver jornada
Jornada 7
16 Nov 23 MillonariosMillonarios 1 - 1 At. NacionalNacional 1k
24 Nov 23 At. NacionalNacional 1 - 1 MillonariosMillonarios 1k

  USO DE MEMORIA  
4,745,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3987
Total Execution Time  0.4006
  CADENA URL  
/copa_colombia2023/grupo0/calendario
  GET DATOS  
$_GET['/copa_colombia2023/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0146  SELECT type FROM routes WHERE alias = 'copa_colombia2023'
0.0291  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_colombia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0149  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 = 70900 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157  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 calendars2023 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 70900 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-25 07:15:23' 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-25 07:15:23' 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=4 AND last_update > '2024-04-25 07:15:23' 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=3 AND last_update > '2024-04-25 07:15:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0219  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 846 AND l.year = 2023
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (70900) 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.0148  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 (70900) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (269155,133923,232393,248275,612670,857202,67271,138482,202574,213460) ORDER BY rp.in_squad = 1 DESC
0.0153  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 846 AND l.year = 2023
0.0150  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (70900) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0150  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 (70900) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3292361,836321,844646,247979,364289,67427,230943,245018,248178,248246) ORDER BY rp.in_squad = 1 DESC
0.0159  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 846 AND l.year = 2023
0.0149  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (70900) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0172  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 (70900) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (67427,142531,208159,208165,248246,249758,273062,313590,318665,364289) ORDER BY rp.in_squad = 1 DESC