4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
20 May 18 Univ. San MartínUniv. 0 - 0 UTC CajamarcaCajamarca 19
19 May 18 Unión ComercioUnión 2 - 0 Academia CantolaoAcademia 10
20 May 18 Universitario de DeportesUniversitar 1 - 1 FBC MelgarFBC Melgar 62
20 May 18 Sport Boys AssociationSport Boys 1 - 1 Sporting CristalSporting 36
18 May 18 Ayacucho FCAyacucho 3 - 0 Comerciantes UnidosComerciante 55
20 May 18 Sport RosarioSport 3 - 2 Alianza LimaAlianza 60
19 May 18 Sport HuancayoSport 1 - 1 Cusco FCCusco FC 42
19 May 18 Deportivo BinacionalDeportivo 0 - 0 Deportivo MunicipalDeportivo 5
Ver jornada
Jornada 2
27 May 18 Sporting CristalSporting 4 - 0 Unión ComercioUnión 25
27 May 18 Deportivo MunicipalDeportivo 4 - 0 Sport RosarioSport 17
27 May 18 Alianza LimaAlianza 1 - 0 Sport Boys AssociationSport Boys 67
27 May 18 Academia CantolaoAcademia 1 - 1 Univ. San MartínUniv. 11
28 May 18 Cusco FCCusco FC 1 - 0 Deportivo BinacionalDeportivo 19
26 May 18 UTC CajamarcaCajamarca 1 - 1 Universitario de DeportesUniversitar 20
26 May 18 Comerciantes UnidosComerciante 0 - 3 Sport HuancayoSport 13
26 May 18 FBC MelgarFBC Melgar 3 - 0 Ayacucho FCAyacucho 19
Ver jornada
Jornada 3
31 May 18 Sporting CristalSporting 1 - 2 Alianza LimaAlianza 76
30 May 18 Unión ComercioUnión 0 - 0 Univ. San MartínUniv. 40
01 Jun 18 Universitario de DeportesUniversitar 2 - 2 Academia CantolaoAcademia 56
15 Jul 18 Sport Boys AssociationSport Boys 1 - 1 Deportivo MunicipalDeportivo 54
29 May 18 Ayacucho FCAyacucho 2 - 3 UTC CajamarcaCajamarca 69
14 Jun 18 Sport RosarioSport 2 - 1 Cusco FCCusco FC 82
31 May 18 Sport HuancayoSport 0 - 2 FBC MelgarFBC Melgar 31
30 May 18 Deportivo BinacionalDeportivo 1 - 0 Comerciantes UnidosComerciante 24
Ver jornada
Jornada 4
03 Jun 18 Univ. San MartínUniv. 2 - 2 Universitario de DeportesUniversitar 34
02 Jun 18 Deportivo MunicipalDeportivo 0 - 1 Sporting CristalSporting 29
03 Jun 18 Alianza LimaAlianza 2 - 0 Unión ComercioUnión 16
03 Jun 18 Academia CantolaoAcademia 3 - 2 Ayacucho FCAyacucho 7
04 Jun 18 Cusco FCCusco FC 3 - 2 Sport Boys AssociationSport Boys 46
02 Jun 18 UTC CajamarcaCajamarca 2 - 0 Sport HuancayoSport 17
02 Jun 18 Comerciantes UnidosComerciante 0 - 0 Sport RosarioSport 14
03 Jun 18 FBC MelgarFBC Melgar 2 - 1 Deportivo BinacionalDeportivo 20
Ver jornada
Jornada 5
06 Jun 18 Sporting CristalSporting 5 - 1 Cusco FCCusco FC 45
06 Jun 18 Unión ComercioUnión 2 - 0 Universitario de DeportesUniversitar 157
06 Jun 18 Alianza LimaAlianza 3 - 1 Deportivo MunicipalDeportivo 101
07 Jun 18 Sport Boys AssociationSport Boys 2 - 1 Comerciantes UnidosComerciante 21
07 Jun 18 Ayacucho FCAyacucho 1 - 1 Univ. San MartínUniv. 74
07 Jun 18 Sport RosarioSport 2 - 1 FBC MelgarFBC Melgar 79
08 Jun 18 Sport HuancayoSport 3 - 0 Academia CantolaoAcademia 58
05 Jun 18 Deportivo BinacionalDeportivo 1 - 0 UTC CajamarcaCajamarca 13
Ver jornada
Jornada 6
10 Jun 18 Univ. San MartínUniv. 0 - 0 Sport HuancayoSport 22
10 Jun 18 Deportivo MunicipalDeportivo 3 - 0 Unión ComercioUnión 4
10 Jun 18 Universitario de DeportesUniversitar 1 - 1 Ayacucho FCAyacucho 71
10 Jun 18 Academia CantolaoAcademia 3 - 1 Deportivo BinacionalDeportivo 6
10 Jun 18 Cusco FCCusco FC 2 - 0 Alianza LimaAlianza 24
09 Jun 18 UTC CajamarcaCajamarca 1 - 1 Sport RosarioSport 23
09 Jun 18 Comerciantes UnidosComerciante 1 - 1 Sporting CristalSporting 22
11 Jun 18 FBC MelgarFBC Melgar 2 - 2 Sport Boys AssociationSport Boys 69
Ver jornada
Jornada 7
22 Jul 18 Sporting CristalSporting 2 - 0 FBC MelgarFBC Melgar 37
22 Jul 18 Deportivo MunicipalDeportivo 2 - 0 Cusco FCCusco FC 19
22 Jul 18 Alianza LimaAlianza 5 - 1 Comerciantes UnidosComerciante 28
21 Jul 18 Sport Boys AssociationSport Boys 1 - 1 UTC CajamarcaCajamarca 39
21 Jul 18 Ayacucho FCAyacucho 1 - 1 Unión ComercioUnión 17
22 Jul 18 Sport RosarioSport 4 - 1 Academia CantolaoAcademia 12
22 Jul 18 Sport HuancayoSport 2 - 1 Universitario de DeportesUniversitar 69
21 Jul 18 Deportivo BinacionalDeportivo 2 - 0 Univ. San MartínUniv. 14
Ver jornada
Jornada 8
24 Jul 18 Univ. San MartínUniv. 0 - 1 Sport RosarioSport 54
25 Jul 18 Unión ComercioUnión 1 - 0 Cusco FCCusco FC 62
25 Jul 18 Universitario de DeportesUniversitar 1 - 0 Deportivo BinacionalDeportivo 84
26 Jul 18 Academia CantolaoAcademia 2 - 2 Sport Boys AssociationSport Boys 27
08 Ago 18 Ayacucho FCAyacucho 3 - 1 Sport HuancayoSport 91
26 Jul 18 UTC CajamarcaCajamarca 0 - 0 Sporting CristalSporting 81
25 Jul 18 Comerciantes UnidosComerciante 1 - 1 Deportivo MunicipalDeportivo 31
26 Jul 18 FBC MelgarFBC Melgar 2 - 0 Alianza LimaAlianza 39
Ver jornada
Jornada 9
08 Ago 18 Sporting CristalSporting 4 - 0 Academia CantolaoAcademia 38
29 Jul 18 Deportivo MunicipalDeportivo 4 - 0 FBC MelgarFBC Melgar 21
24 Ago 18 Alianza LimaAlianza 0 - 1 UTC CajamarcaCajamarca 211
29 Jul 18 Sport Boys AssociationSport Boys 3 - 2 Univ. San MartínUniv. 35
30 Jul 18 Cusco FCCusco FC 1 - 0 Comerciantes UnidosComerciante 23
29 Jul 18 Sport RosarioSport 3 - 0 Universitario de DeportesUniversitar 24
28 Jul 18 Sport HuancayoSport 0 - 0 Unión ComercioUnión 40
28 Jul 18 Deportivo BinacionalDeportivo 1 - 0 Ayacucho FCAyacucho 13
Ver jornada
Jornada 10
01 Ago 18 Univ. San MartínUniv. 0 - 3 Sporting CristalSporting 56
02 Ago 18 Unión ComercioUnión 2 - 0 Comerciantes UnidosComerciante 83
01 Ago 18 Universitario de DeportesUniversitar 2 - 1 Sport Boys AssociationSport Boys 89
02 Ago 18 Academia CantolaoAcademia 1 - 1 Alianza LimaAlianza 100
31 Jul 18 Ayacucho FCAyacucho 2 - 0 Sport RosarioSport 152
01 Ago 18 UTC CajamarcaCajamarca 1 - 0 Deportivo MunicipalDeportivo 41
01 Ago 18 Sport HuancayoSport 1 - 2 Deportivo BinacionalDeportivo 70
02 Ago 18 FBC MelgarFBC Melgar 1 - 0 Cusco FCCusco FC 64
Ver jornada
Jornada 11
05 Ago 18 Sporting CristalSporting 1 - 0 Universitario de DeportesUniversitar 51
05 Ago 18 Deportivo MunicipalDeportivo 1 - 0 Academia CantolaoAcademia 24
05 Ago 18 Alianza LimaAlianza 3 - 1 Univ. San MartínUniv. 17
04 Ago 18 Sport Boys AssociationSport Boys 1 - 0 Ayacucho FCAyacucho 52
05 Ago 18 Cusco FCCusco FC 1 - 0 UTC CajamarcaCajamarca 39
06 Ago 18 Sport RosarioSport 2 - 4 Sport HuancayoSport 46
05 Ago 18 Comerciantes UnidosComerciante 2 - 2 FBC MelgarFBC Melgar 56
06 Ago 18 Deportivo BinacionalDeportivo 1 - 1 Unión ComercioUnión 95
Ver jornada
Jornada 12
12 Ago 18 Univ. San MartínUniv. 6 - 1 Deportivo MunicipalDeportivo 28
13 Ago 18 Unión ComercioUnión 0 - 0 FBC MelgarFBC Melgar 113
12 Ago 18 Universitario de DeportesUniversitar 1 - 1 Alianza LimaAlianza 95
12 Ago 18 Academia CantolaoAcademia 1 - 2 Cusco FCCusco FC 12
11 Ago 18 Ayacucho FCAyacucho 0 - 1 Sporting CristalSporting 94
11 Ago 18 UTC CajamarcaCajamarca 2 - 1 Comerciantes UnidosComerciante 46
12 Ago 18 Sport HuancayoSport 0 - 0 Sport Boys AssociationSport Boys 60
11 Ago 18 Deportivo BinacionalDeportivo 3 - 1 Sport RosarioSport 34
Ver jornada
Jornada 13
14 Ago 18 Sporting CristalSporting 0 - 0 Sport HuancayoSport 179
16 Ago 18 Deportivo MunicipalDeportivo 0 - 2 Universitario de DeportesUniversitar 95
15 Ago 18 Alianza LimaAlianza 1 - 0 Ayacucho FCAyacucho 80
15 Ago 18 Sport Boys AssociationSport Boys 1 - 0 Deportivo BinacionalDeportivo 119
16 Ago 18 Cusco FCCusco FC 3 - 3 Univ. San MartínUniv. 109
17 Ago 18 Sport RosarioSport 0 - 2 Unión ComercioUnión 89
15 Ago 18 Comerciantes UnidosComerciante 0 - 4 Academia CantolaoAcademia 38
17 Ago 18 FBC MelgarFBC Melgar 3 - 3 UTC CajamarcaCajamarca 76
Ver jornada
Jornada 14
19 Ago 18 Univ. San MartínUniv. 2 - 0 Comerciantes UnidosComerciante 27
20 Ago 18 Unión ComercioUnión 2 - 3 UTC CajamarcaCajamarca 36
19 Ago 18 Universitario de DeportesUniversitar 0 - 1 Cusco FCCusco FC 65
19 Ago 18 Academia CantolaoAcademia 1 - 1 FBC MelgarFBC Melgar 24
18 Ago 18 Ayacucho FCAyacucho 1 - 2 Deportivo MunicipalDeportivo 15
20 Ago 18 Sport RosarioSport 1 - 1 Sport Boys AssociationSport Boys 39
19 Ago 18 Sport HuancayoSport 1 - 1 Alianza LimaAlianza 63
18 Ago 18 Deportivo BinacionalDeportivo 1 - 1 Sporting CristalSporting 46
Ver jornada
Jornada 15
26 Ago 18 Sporting CristalSporting 2 - 1 Sport RosarioSport 60
26 Ago 18 Deportivo MunicipalDeportivo 1 - 0 Sport HuancayoSport 33
26 Ago 18 Alianza LimaAlianza 2 - 1 Deportivo BinacionalDeportivo 28
26 Ago 18 Sport Boys AssociationSport Boys 2 - 4 Unión ComercioUnión 28
26 Ago 18 Cusco FCCusco FC 2 - 1 Ayacucho FCAyacucho 19
27 Ago 18 UTC CajamarcaCajamarca 1 - 2 Academia CantolaoAcademia 80
26 Ago 18 Comerciantes UnidosComerciante 3 - 4 Universitario de DeportesUniversitar 142
25 Ago 18 FBC MelgarFBC Melgar 3 - 2 Univ. San MartínUniv. 15

Clasificación

Equipo PJ GF GC Puntos
1 Sporting Cristal Sporting 15 27 7 32
2 Alianza Lima Alianza Lima 15 24 16 27
3 Cusco FC Cusco FC 15 19 19 26
4 Deportivo Municipal Deportivo 15 21 16 24
5 UTC Cajamarca Cajamarca 15 19 15 24
6 FBC Melgar FBC Melgar 15 23 20 24
7 Unión Comercio Unión 15 17 16 23
8 Deportivo Binacional Deportivo 15 15 14 21
9 Sport Boys Association Sport Boys. 15 20 21 19
10 Sport Huancayo Sport 15 16 15 18
11 Universitario de Deportes Universitari 15 18 21 18
12 Sport Rosario Sport 15 21 24 17
13 Academia Cantolao Academia 15 21 27 17
14 Univ. San Martín Univ. 15 20 23 13
15 Ayacucho FC Ayacucho FC 15 17 21 12
16 Comerciantes Unidos Comerciantes 15 10 33 4

  USO DE MEMORIA  
5,889,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.1237
Total Execution Time  0.1260
  CADENA URL  
/apertura_peru2018/grupo1/calendario
  GET DATOS  
$_GET['/apertura_peru2018/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_peru2018'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_peru' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  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 = 42467 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 calendars2018 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 42467 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 22:58:23' 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-05-04 22:58:23' 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-05-04 22:58:23' 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-05-04 22:58:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_peru' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0086  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 events2018 e ON e.player_id = p.id AND e.league_id = 42467 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 42467 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.0148  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 events2018 e ON e.player_id = p.id AND e.league_id = 42467 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 42467 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031  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 events2018 e ON e.player_id = p.id AND e.league_id = 42467 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 42467 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0059  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 42467 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC