4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2015
 
Primera B Chile - Apertura Fase 2 2015
2014/2015

Primera B Chile - Apertura Fase 2 2015

  • Unión San Felipe
  • San Luis de Quillota
  • Curicó Unido
  • Everton
  • Deportes Copiapó
  • Magallanes
  • Concepción
  • Deportes Temuco
  • La Serena
  • Santiago Morning
  • CDSC Iberia
  • Coquimbo Unido
  • Lota Schwager
  • Rangers Talca
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Unión San Felipe Unión 13 32 14 30
2 San Luis de Quillota Luis 13 29 14 28
3 Curicó Unido Curicó 13 23 12 25
4 Everton Everton 13 23 16 22
5 Deportes Copiapó Deportes 13 14 14 20
6 Magallanes Magallanes 13 18 16 19
7 Concepción Concepción 13 18 18 19
8 Deportes Temuco Deportes 13 19 25 18
9 La Serena La Serena 13 10 13 14
10 Santiago Morning Santiago 13 11 15 14
11 CDSC Iberia CDSC Iberia 13 13 19 12
12 Coquimbo Unido Coquimbo 13 14 21 12
13 Lota Schwager Lota 13 11 26 8
14 Rangers Talca Rangers 13 13 25 7
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Barnechea Barnechea 13 20 13 25
2 Deportes Copiapó Deportes 13 19 12 23
3 San Luis de Quillota Luis 13 19 10 22
4 Magallanes Magallanes 13 17 15 22
5 Santiago Morning Santiago 13 20 16 21
6 Naval de Talcahuano Naval 13 11 13 20
7 Unión San Felipe Unión 13 17 14 18
8 San Marcos Arica Marcos Arica 13 17 20 17
9 Deportes Temuco Deportes 13 17 22 15
10 Curicó Unido Curicó 13 15 17 14
11 Coquimbo Unido Coquimbo 13 18 22 14
12 Concepción Concepción 13 9 15 14
13 La Serena La Serena 13 14 17 13
14 Lota Schwager Lota 13 11 18 9
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Ñublense Ñublense 13 26 15 29
2 San Marcos Arica Marcos Arica 13 30 14 26
3 Unión Temuco Unión 13 17 12 20
4 Everton Everton 13 25 20 19
5 Barnechea Barnechea 13 18 18 18
6 Lota Schwager Lota 13 17 16 17
7 Magallanes Magallanes 13 15 20 17
8 Concepción Concepción 13 16 13 16
9 Coquimbo Unido Coquimbo 13 19 19 16
10 San Luis de Quillota Luis 13 17 21 16
11 Puerto Montt Puerto Montt 13 15 22 15
12 Santiago Morning Santiago 13 18 24 14
13 Naval de Talcahuano Naval 13 15 22 11
14 Curicó Unido Curicó 13 15 27 11
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Antofagasta Antofagasta 13 21 11 30
2 Rangers Talca Rangers 13 22 18 24
3 Concepción Concepción 13 19 14 20
4 Curicó Unido Curicó 13 25 20 19
5 San Marcos Arica Marcos Arica 13 22 17 19
6 Puerto Montt Puerto Montt 13 15 14 19
7 Unión Temuco Unión 13 19 15 18
8 Lota Schwager Lota 13 15 15 18
9 San Luis de Quillota Luis 13 21 21 17
10 Naval de Talcahuano Naval 13 17 18 17
11 Coquimbo Unido Coquimbo 13 15 20 15
12 Magallanes Magallanes 13 18 23 14
13 Everton Everton 13 12 22 11
14 Deportes Copiapó Deportes 13 16 29 7

  USO DE MEMORIA  
5,281,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1330
Total Execution Time  0.1349
  CADENA URL  
/primera_b_apertura_fase_2_chile2015/grupo1/historico
  GET DATOS  
$_GET['/primera_b_apertura_fase_2_chile2015/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0019  SELECT type FROM routes WHERE alias = 'primera_b_apertura_fase_2_chile2015'
0.0044  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_apertura_fase_2_chile' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=291 AND type_rel = 3
0.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 291 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0037  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 (240925,148587,61846,61224,53563) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=291 ORDER BY order_id ASC
0.0026  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 = 4914 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 291 AND group_code = 1 and tables = 1 AND year <= 2015 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0036  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 `tables2015` 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 = 4914 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 `tables2014` 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 = 3200 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 `tables2012` 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 = 1880 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 `tables2011` 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 = 24553 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 01:10:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 01:10:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 01:10:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 01:10:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0031  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_apertura_fase_2_chile' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0256  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 events2015 e ON e.player_id = p.id AND e.league_id = 4914 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4914 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.0176  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 events2015 e ON e.player_id = p.id AND e.league_id = 4914 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4914 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0036  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 events2015 e ON e.player_id = p.id AND e.league_id = 4914 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4914 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0051  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 4914 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC