4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 FC Basel Sub 18 Basel 23 78 37 58
2 FC Luzern-SC Kriens Sub 18 Luzern-SC 23 55 28 51
3 Servette FC Sub 18 Servette 23 63 38 49
4 FC Zürich Sub 18 Zürich 24 59 35 47
5 FC St. Gallen Sub 18 Gallen 23 57 38 41
6 BSC Young Boys Sub 18 Young Boys 23 43 38 36
7 FC Sion Sub 18 Sion 23 48 47 32
8 Team Vaud Sub 18 Team Vaud 23 30 32 31
9 Grasshopper Zürich Sub 18 Grasshopper 23 36 52 21
10 Team Ticino Sub 18 Team Ticino 23 28 44 19
11 Aarau Sub 18 Aarau 23 33 64 18
12 Winterthur Sub 18 Winterthur 23 20 44 16
13 Team BEJUNE Sub 18 Team BEJUNE 23 15 68 8
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 FC Basel Sub 18 Basel 24 77 34 54
2 BSC Young Boys Sub 18 Young Boys 24 58 41 43
3 FC Luzern-SC Kriens Sub 18 Luzern-SC 24 65 47 41
4 FC Zürich Sub 18 Zürich 24 39 38 37
5 Team Vaud Sub 18 Team Vaud 24 35 37 32
6 FC Sion Sub 18 Sion 24 40 39 31
7 Aarau Sub 18 Aarau 24 37 52 31
8 Grasshopper Zürich Sub 18 Grasshopper 24 51 57 30
9 FC St. Gallen Sub 18 Gallen 24 32 42 30
10 Winterthur Sub 18 Winterthur 24 39 42 29
11 Servette FC Sub 18 Servette 24 36 51 29
12 Team BEJUNE Sub 18 Team BEJUNE 24 27 36 25
13 Team Ticino Sub 18 Team Ticino 24 23 43 19
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 BSC Young Boys Sub 18 Young Boys 24 52 25 57
2 Team Vaud Sub 18 Team Vaud 24 42 33 43
3 FC Basel Sub 18 Basel 24 60 30 41
4 FC Zürich Sub 18 Zürich 24 56 43 41
5 Winterthur Sub 18 Winterthur 24 45 44 39
6 Servette FC Sub 18 Servette 24 34 37 32
7 FC Thun Sub 18 Thun 24 47 63 30
8 Grasshopper Zürich Sub 18 Grasshopper 24 45 44 29
9 FC Luzern-SC Kriens Sub 18 Luzern-SC 24 41 34 28
10 Team Ticino Sub 18 Team Ticino 24 35 44 27
11 FC Sion Sub 18 Sion 24 38 52 26
12 FC St. Gallen Sub 18 Gallen 24 38 55 26
13 Team Aargau Sub 18 Team Aargau 24 31 60 16

  USO DE MEMORIA  
4,709,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3916
Total Execution Time  0.3937
  CADENA URL  
/liga_suiza_elite_sub_182014/grupo1/historico
  GET DATOS  
$_GET['/liga_suiza_elite_sub_182014/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0126  SELECT type FROM routes WHERE alias = 'liga_suiza_elite_sub_182014'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_suiza_elite_sub_18' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2067 AND type_rel = 3
0.0126  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2067 ORDER BY order_id ASC
0.0129  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 = 44124 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2067 AND group_code = 1 and tables = 1 AND year <= 2014 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0135  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 = 44124 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 `tables2013` 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 = 44125 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 49576 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2008` 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 = 63183 AND t.round = 26 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-02 11:52:02' 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-02 11:52:02' 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-02 11:52:02' 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=3 AND last_update > '2024-05-02 11:52:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0133  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_suiza_elite_sub_18' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0226  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 events2014 e ON e.player_id = p.id AND e.league_id = 44124 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44124 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.0398  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 events2014 e ON e.player_id = p.id AND e.league_id = 44124 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44124 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0149  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 events2014 e ON e.player_id = p.id AND e.league_id = 44124 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44124 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0144  SELECT *,(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 = 44124 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC