4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Cruce de partidos Copa Perú - Todos los partidos de la temporada

IdaVuelta
 Univ. César Vallejo Nacional FBC Ecosem Maristas Unión Tarapoto Deportivo Vianney Miguel Grau Sport Cáceres Unión Santo Domingo Centro Estudiantil Defensor Cubillas Deportiva Agropecuaria Diablos Rojos Juliaca FBC Club Aurora FC San Marcos Juan Pablo II College Juventud Palmeiras Renovación Pacifico Tacna Heroica Alianza Pisco Atletico Juventud Inclan CD Juventud La Joya Defensor Porvenir Deportiva Tahuishco Deportivo Huracán Diablos Rojos Escuela Municipal Independiente Huachog Olimpia FC Real Atlético Nueva Sociedad de Tiro 28 Star Ancash VRAEM Alfonso Ugarte Chiclín Altiplano y del Pacífico Ángeles Vizcachani Atlético Chancahamayo Atlético Hospital Boca Junior de La Choza Calidad Porteña Castle Cristo Rey de Negritos Defensor Tacna FC Cajamarca Inter Manantay La Masía Nace Lolo Fernandez Municipal Challhuahuacho Municipal Jazán Pedro del Castillo Ríos
Univ. César Vallejo Univ. César Vallejo
Nacional FBC Nacional FBC
Ecosem Ecosem
Maristas Maristas
Unión Tarapoto Unión Tarapoto
Deportivo Vianney Deportivo Vianney
Miguel Grau Miguel Grau
Sport Cáceres Sport Cáceres
Unión Santo Domingo Unión Santo Domingo
Centro Estudiantil Centro Estudiantil
Defensor Cubillas Defensor Cubillas
Deportiva Agropecuaria Deportiva Agropecuaria
Diablos Rojos Juliaca Diablos Rojos Juliaca
FBC Club Aurora FBC Club Aurora
FC San Marcos FC San Marcos
Juan Pablo II College Juan Pablo II College
Juventud Palmeiras Juventud Palmeiras
Renovación Pacifico Renovación Pacifico
Tacna Heroica Tacna Heroica
Alianza Pisco Alianza Pisco
Atletico Juventud Inclan Atletico Juventud Inclan
CD Juventud La Joya CD Juventud La Joya
Defensor Porvenir Defensor Porvenir
Deportiva Tahuishco Deportiva Tahuishco
Deportivo Huracán Deportivo Huracán
Diablos Rojos Diablos Rojos
Escuela Municipal Escuela Municipal
Independiente Huachog Independiente Huachog
Olimpia FC Olimpia FC
Real Atlético Nueva Real Atlético Nueva
Sociedad de Tiro 28 Sociedad de Tiro 28
Star Ancash Star Ancash
VRAEM VRAEM
Alfonso Ugarte Chiclín Alfonso Ugarte Chiclín
Altiplano y del Pacífico Altiplano y del Pacífico
Ángeles Vizcachani Ángeles Vizcachani
Atlético Chancahamayo Atlético Chancahamayo
Atlético Hospital Atlético Hospital
Boca Junior de La Choza Boca Junior de La Choza
Calidad Porteña Calidad Porteña
Castle Castle
Cristo Rey de Negritos Cristo Rey de Negritos
Defensor Tacna Defensor Tacna
FC Cajamarca FC Cajamarca
Inter Manantay Inter Manantay
La Masía Nace La Masía Nace
Lolo Fernandez Lolo Fernandez
Municipal Challhuahuacho Municipal Challhuahuacho
Municipal Jazán Municipal Jazán
Pedro del Castillo Ríos Pedro del Castillo Ríos

  USO DE MEMORIA  
8,184,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.4300
Total Execution Time  0.4324
  CADENA URL  
/copa_peru2023/grupo1/cruces
  GET DATOS  
$_GET['/copa_peru2023/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0124  SELECT type FROM routes WHERE alias = 'copa_peru2023'
0.0252  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.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=547 AND type_rel = 3
0.0127  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.0129  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.0126  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 547 GROUP BY l.categoryId
0.0127  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=547 GROUP BY l.year ORDER BY l.year DESC
0.0130  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.0131  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2023 AS c WHERE c.league_id='74010' ORDER BY c.id ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 19:42:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 19:42:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 19:42:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 19:42:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  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.0128  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 547 AND l.year = 2023
0.0128  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.0134  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.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 = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0169  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