4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Miguel Grau Miguel Grau 6 13 7 15
2 Sport Cáceres Sport 6 13 7 15
3 Unión Tarapoto Unión 6 20 6 14
4 Defensor Porvenir Defensor 6 13 4 14
5 FC San Marcos Marcos 6 16 7 13
6 Deportiva Agropecuaria Deportiva 6 8 3 13
7 Atletico Juventud Inclan Atletico 6 7 4 13
8 Diablos Rojos Juliaca Diablos 6 12 4 12
9 Ecosem Ecosem 6 11 3 12
10 Deportivo Vianney Deportivo 6 13 6 12
11 Nacional FBC Nacional 6 10 7 12
12 Unión Santo Domingo Unión Santo 6 11 10 12
13 Deportiva Tahuishco Deportiva 6 10 3 11
14 Deportivo Huracán Deportivo 6 14 8 11
15 FBC Club Aurora Club Aurora 6 12 6 11
16 Diablos Rojos Diablos 6 8 6 11
17 Renovación Pacifico Renovación 6 14 9 10
18 Defensor Cubillas Defensor 6 10 6 10
19 Olimpia FC Olimpia FC 6 12 9 10
20 Alianza Pisco Alianza 6 7 4 10
21 Juan Pablo II College Juan Pablo. 6 8 6 10
22 Maristas Maristas 6 11 10 10
23 Univ. César Vallejo Univ. César 6 6 5 10
24 Escuela Municipal Escuela 6 13 9 9
25 Tacna Heroica Tacna 6 8 5 9
26 VRAEM VRAEM 6 8 8 9
27 Real Atlético Nueva Real 6 6 10 9
28 Sociedad de Tiro 28 Sociedad 6 6 2 8
29 CD Juventud La Joya Juventud 6 6 5 8
30 Castle Castle 6 5 4 8
31 Star Ancash Star Ancash 6 9 9 8
32 Juventud Palmeiras Juventud 6 10 13 8
33 Independiente Huachog Independient 6 7 11 8
34 Pedro del Castillo Ríos Pedro 6 11 8 7
35 Cristo Rey de Negritos Cristo 6 9 13 7
36 Ángeles Vizcachani Ángeles 6 9 11 6
37 Altiplano y del Pacífico Altiplano 6 7 10 5
38 Centro Estudiantil Centro 6 6 10 5
39 Defensor Tacna Defensor 6 8 14 5
40 Inter Manantay Inter 6 6 13 5
41 Atlético Hospital Atlético 6 9 20 5
42 Calidad Porteña Calidad 6 9 15 4
43 Lolo Fernandez Lolo 6 9 15 3
44 Municipal Jazán Municipal 6 6 12 3
45 Boca Junior de La Choza Boca Junior 6 6 13 3
46 FC Cajamarca Cajamarca 6 3 11 2
47 Atlético Chancahamayo Atlético 6 4 19 2
48 Municipal Challhuahuacho Municipal 6 6 14 0
49 La Masía Nace Masía Nace 6 2 16 0
50 Alfonso Ugarte Chiclín Alfonso 6 4 21 0
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Deportivo Garcilaso Deportivo 6 15 4 15
2 Social El Olivo Social Olivo 6 10 6 15
3 Los Libertadores Libertadores 6 13 4 14
4 Deportivo Ferrocarril Deportivo 6 15 6 13
5 Atlético Bruces Atlético 6 15 9 13
6 Independiente San Felipe Independient 7 10 6 13
7 Cultural Volante Cultural 6 11 4 12
8 Ecosem Ecosem 6 12 6 12
9 Universitario UNAP Universitari 6 11 6 12
10 Centro Estudiantil Centro 6 9 5 12
11 Comerciantes FC Comerciantes 6 7 3 12
12 Dep. Maldonado Dep. 6 12 15 12
13 Unión San Martín Unión 6 10 2 11
14 Rosario Celendin Rosario 6 12 6 11
15 Paz Soldan Paz Soldan 6 7 2 11
16 Nacional FBC Nacional 6 10 6 11
17 CD Estudiantil CNI Estudiantil 6 10 7 11
18 Virgen de la Natividad Virgen 6 6 3 11
19 San Andrés de Runtu Andrés 6 13 7 10
20 Defensor La Bocana Defensor 6 11 6 10
21 Atlético Porvenir Atlético 6 9 6 10
22 Bagua Grande Bagua Grande 6 7 7 10
23 Bolognesi FC Bolognesi 6 6 4 9
24 Deportivo Vianney Deportivo 6 8 8 9
25 Señor de Mayo Señor Mayo 6 8 11 9
26 Colegio Comercio Colegio 6 10 6 8
27 Atlético Verdún Atlético 6 12 12 8
28 Deportivo UNH Deportivo 6 5 5 8
29 Sport Cáceres Sport 6 7 8 8
30 Deportivo Verdecocha Deportivo 6 5 7 8
31 Cahusiños San Miguel Cahusiños 6 12 6 7
32 Deportivo La Victoria Deportivo 6 7 7 7
33 CSD Leoncio Prado Leoncio 6 5 8 7
34 Defensor Cubillas Defensor 6 10 11 6
35 Agua San Martín Agua Martín 6 6 8 6
36 Unión Santo Domingo Unión Santo 5 6 9 6
37 Club Atletico Torino Club 5 3 6 6
38 Deportiva CIMAC Deportiva 6 4 10 6
39 Credicoop San Cristóbal Credicoop 6 7 9 5
40 Los Tigres de Cayma Tigres Cayma 6 4 6 5
41 La Paz La Paz 6 5 9 5
42 Mariscal Nieto Mariscal 6 7 12 5
43 Juventud Palmeiras Juventud 7 5 14 5
44 Defensor Concepción Defensor 6 5 11 4
45 Once Caldas Huariaca Once Caldas 6 4 12 4
46 Real Sociedad Chugay Real 6 12 19 3
47 Atlético Municipal de Iñapa Atlético 6 5 22 3
48 Estrella Azul Estrella 6 5 14 1
49 Cultural Huracán Cultural 6 4 13 1
50 Deportivo La Balsa Deportivo 6 0 19 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Deportivo Llacuabamba Deportivo 3 8 3 5
2 Carlos Stein Carlos Stein 3 5 4 5
3 Sport Chavelines Juniors Sport 3 3 4 2
4 Sport Estrella Sport 3 2 7 2
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Sport Rosario Sport 3 6 4 7
2 Deportivo Hualgayo Deportivo 3 5 3 4
3 Deportivo Binacional Deportivo 3 3 4 3
4 Racing Club Huamachuco Racing Club 3 3 6 3

  USO DE MEMORIA  
6,837,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4458
Total Execution Time  0.4479
  CADENA URL  
/copa_peru2023/grupo1/historico
  GET DATOS  
$_GET['/copa_peru2023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0128  SELECT type FROM routes WHERE alias = 'copa_peru2023'
0.0262  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_peru' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=547 AND type_rel = 3
0.0136  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 547 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0137  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 (1074344,820497,756121,747221,677287) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=547 ORDER BY order_id ASC
0.0128  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 = 74010 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 547 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 74010 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 69342 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 51806 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 37495 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 09:35:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 09:35:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 09:35:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 09:35:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_peru' 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.0133  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 547 AND l.year = 2023
0.0136  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (74010,74302) 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.0145  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 (74010,74302) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (749299,542584,133256,371879,376821,571100,858250,3155224,3335532,3490753) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 547 AND l.year = 2023
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (74010,74302) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 547 AND l.year = 2023
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (74010,74302) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0155  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 74010 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC