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

Cruce de partidos Copa Simón Bolívar - Todos los partidos de la temporada

IdaVuelta
 Real Potosí CA Bermejo Universitario Beni Ciclón Deportivo FATIC EM Huanuni García Ágreda Fancesa Torre Fuerte Escuela Enrique Happ San Antonio Bulo Bulo Universitario de Pando Deportivo Sur-Car Rosario Central Stormers San Lorenzo Chaco Petrolero 24 de Septiembre Ciudad Nueva Santa Cruz GV San Jose Real Oruro Deportivo Alemán Municipal de Tarija Municipalidad Yacuiba Nacional Sucre Pasión Celeste Real Mapajo Real Mizque San Lorenzo del Beni Academia del Balompie Alianza Beni Atlético Sucre Hiska Nacional Los Almendros Universidad Cruceña CM Poopo Huayna Potosi Palcoco Huracan Tupiza Independiente Recreo Israel University River 66
Real Potosí Real Potosí
CA Bermejo CA Bermejo
Universitario Beni Universitario Beni
Ciclón Ciclón
Deportivo FATIC Deportivo FATIC
EM Huanuni EM Huanuni
García Ágreda García Ágreda
Fancesa Fancesa
Torre Fuerte Torre Fuerte
Escuela Enrique Happ Escuela Enrique Happ
San Antonio Bulo Bulo San Antonio Bulo Bulo
Universitario de Pando Universitario de Pando
Deportivo Sur-Car Deportivo Sur-Car
Rosario Central Rosario Central
Stormers San Lorenzo Stormers San Lorenzo
Chaco Petrolero Chaco Petrolero
24 de Septiembre 24 de Septiembre
Ciudad Nueva Santa Cruz Ciudad Nueva Santa Cruz
GV San Jose GV San Jose
Real Oruro Real Oruro
Deportivo Alemán Deportivo Alemán
Municipal de Tarija Municipal de Tarija
Municipalidad Yacuiba Municipalidad Yacuiba
Nacional Sucre Nacional Sucre
Pasión Celeste Pasión Celeste
Real Mapajo Real Mapajo
Real Mizque Real Mizque
San Lorenzo del Beni San Lorenzo del Beni
Academia del Balompie Academia del Balompie
Alianza Beni Alianza Beni
Atlético Sucre Atlético Sucre
Hiska Nacional Hiska Nacional
Los Almendros Los Almendros
Universidad Cruceña Universidad Cruceña
CM Poopo CM Poopo
Huayna Potosi Palcoco Huayna Potosi Palcoco
Huracan Tupiza Huracan Tupiza
Independiente Recreo Independiente Recreo
Israel University Israel University
River 66 River 66

  USO DE MEMORIA  
7,247,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.5471
Total Execution Time  0.5505
  CADENA URL  
/nacional_b_bolivia_apertura2023/grupo1/cruces
  GET DATOS  
$_GET['/nacional_b_bolivia_apertura2023/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0144  SELECT type FROM routes WHERE alias = 'nacional_b_bolivia_apertura2023'
0.0292  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'nacional_b_bolivia_apertura' 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.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1598 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1598 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  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 (1159502,840595,723495,237645) ORDER BY n.cover_points DESC, update_date DESC
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1598 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 = 71938 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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='71938' ORDER BY c.id ASC
0.0157  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 11:48:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 11:48:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 11:48:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 11:48:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'nacional_b_bolivia_apertura' 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.0147  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 events2023 e ON e.player_id = p.id AND e.league_id = 71938 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 71938 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.0146  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 events2023 e ON e.player_id = p.id AND e.league_id = 71938 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 71938 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  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 events2023 e ON e.player_id = p.id AND e.league_id = 71938 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 71938 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0163  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 = 71938 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC