4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
30 Sep 17 Team Bejune Sub 17Team Bejune 2 - 4 BSC Young Boys Sub 17Young Boys ...
30 Sep 17 FC Vaduz Sub 18Vaduz 3 - 1 FC Zürich Sub 17Zürich ...
01 Oct 17 Fc Basel 1893 Sub 17Basel 1893 3 - 4 FC St. Gallen 1879 Sub 17Gallen 1879 ...
01 Oct 17 Grasshopper Sub 17Grasshopper 1 - 2 Luzern Sub 17Luzern ...
Ver jornada
Jornada 2
14 Oct 17 FC St. Gallen 1879 Sub 17Gallen 1879 2 - 1 BSC Young Boys Sub 17Young Boys ...
14 Oct 17 Luzern Sub 17Luzern 2 - 1 FC Vaduz Sub 18Vaduz ...
15 Oct 17 FC Zürich Sub 17Zürich 1 - 3 Fc Basel 1893 Sub 17Basel 1893 ...
15 Oct 17 Grasshopper Sub 17Grasshopper 4 - 2 Team Bejune Sub 17Team Bejune ...
Ver jornada
Jornada 3
21 Oct 17 Team Bejune Sub 17Team Bejune 0 - 1 FC St. Gallen 1879 Sub 17Gallen 1879 ...
21 Oct 17 Fc Basel 1893 Sub 17Basel 1893 1 - 2 Luzern Sub 17Luzern ...
22 Oct 17 BSC Young Boys Sub 17Young Boys 3 - 2 FC Zürich Sub 17Zürich ...
21 Oct 17 FC Vaduz Sub 18Vaduz 3 - 1 Grasshopper Sub 17Grasshopper ...
Ver jornada
Jornada 4
28 Oct 17 FC Vaduz Sub 18Vaduz 3 - 3 Team Bejune Sub 17Team Bejune ...
28 Oct 17 Luzern Sub 17Luzern 2 - 1 BSC Young Boys Sub 17Young Boys ...
29 Oct 17 FC Zürich Sub 17Zürich 4 - 0 FC St. Gallen 1879 Sub 17Gallen 1879 ...
29 Oct 17 Grasshopper Sub 17Grasshopper 1 - 2 Fc Basel 1893 Sub 17Basel 1893 ...
Ver jornada
Jornada 5
04 Nov 17 Fc Basel 1893 Sub 17Basel 1893 4 - 0 FC Vaduz Sub 18Vaduz ...
04 Nov 17 Team Bejune Sub 17Team Bejune 2 - 2 FC Zürich Sub 17Zürich ...
04 Nov 17 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 2 Luzern Sub 17Luzern ...
04 Nov 17 BSC Young Boys Sub 17Young Boys 3 - 0 Grasshopper Sub 17Grasshopper ...
Ver jornada
Jornada 6
18 Nov 17 Fc Basel 1893 Sub 17Basel 1893 6 - 0 Team Bejune Sub 17Team Bejune ...
18 Nov 17 FC Vaduz Sub 18Vaduz 5 - 1 BSC Young Boys Sub 17Young Boys ...
18 Nov 17 Luzern Sub 17Luzern 1 - 1 FC Zürich Sub 17Zürich ...
19 Nov 17 Grasshopper Sub 17Grasshopper 4 - 1 FC St. Gallen 1879 Sub 17Gallen 1879 ...
Ver jornada
Jornada 7
25 Nov 17 BSC Young Boys Sub 17Young Boys 3 - 2 Fc Basel 1893 Sub 17Basel 1893 ...
25 Nov 17 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 0 FC Vaduz Sub 18Vaduz ...
25 Nov 17 Team Bejune Sub 17Team Bejune 0 - 1 Luzern Sub 17Luzern ...
25 Nov 17 FC Zürich Sub 17Zürich 2 - 1 Grasshopper Sub 17Grasshopper ...
Ver jornada
Jornada 8
03 Mar 18 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 6 Team BEJUNE Sub 18Team BEJUNE ...
03 Mar 18 Luzern Sub 17Luzern 3 - 0 Fc Basel 1893 Sub 17Basel 1893 ...
03 Mar 18 BSC Young Boys Sub 17Young Boys 1 - 2 FC Thun Sub 17Thun ...
04 Mar 18 FC Zürich Sub 17Zürich 3 - 1 Team Bejune Sub 17Team Bejune ...
04 Mar 18 Grasshopper Sub 17Grasshopper 3 - 1 FC Vaduz Sub 18Vaduz ...
Ver jornada
Jornada 9
10 Mar 18 Team Bejune Sub 17Team Bejune 4 - 1 Luzern Sub 17Luzern ...
10 Mar 18 BSC Young Boys Sub 17Young Boys 6 - 4 FC St. Gallen 1879 Sub 17Gallen 1879 ...
10 Mar 18 FC Thun Sub 17Thun 3 - 0 FC Vaduz Sub 18Vaduz ...
10 Mar 18 Team BEJUNE Sub 18Team BEJUNE 4 - 0 FC Zürich Sub 17Zürich ...
11 Mar 18 Fc Basel 1893 Sub 17Basel 1893 1 - 4 Grasshopper Sub 17Grasshopper ...
Ver jornada
Jornada 10
17 Mar 18 FC Vaduz Sub 18Vaduz 2 - 3 Fc Basel 1893 Sub 17Basel 1893 ...
17 Mar 18 Luzern Sub 17Luzern 2 - 2 Team BEJUNE Sub 18Team BEJUNE ...
17 Mar 18 FC St. Gallen 1879 Sub 17Gallen 1879 0 - 5 FC Thun Sub 17Thun ...
18 Mar 18 FC Zürich Sub 17Zürich 3 - 3 BSC Young Boys Sub 17Young Boys ...
18 Mar 18 Grasshopper Sub 17Grasshopper 4 - 4 Team Bejune Sub 17Team Bejune ...
Ver jornada
Jornada 11
24 Mar 18 Team Bejune Sub 17Team Bejune 6 - 2 FC Vaduz Sub 18Vaduz ...
24 Mar 18 BSC Young Boys Sub 17Young Boys 0 - 0 Luzern Sub 17Luzern ...
24 Mar 18 FC Thun Sub 17Thun 2 - 2 Fc Basel 1893 Sub 17Basel 1893 ...
25 Mar 18 FC St. Gallen 1879 Sub 17Gallen 1879 4 - 3 FC Zürich Sub 17Zürich ...
24 Mar 18 Team BEJUNE Sub 18Team BEJUNE 2 - 1 Grasshopper Sub 17Grasshopper ...
Ver jornada
Jornada 12
07 Abr 18 Fc Basel 1893 Sub 17Basel 1893 3 - 0 Team Bejune Sub 17Team Bejune ...
07 Abr 18 FC Vaduz Sub 18Vaduz 2 - 1 Team BEJUNE Sub 18Team BEJUNE ...
07 Abr 18 Luzern Sub 17Luzern 1 - 1 FC St. Gallen 1879 Sub 17Gallen 1879 ...
08 Abr 18 FC Zürich Sub 17Zürich 4 - 4 FC Thun Sub 17Thun ...
08 Abr 18 Grasshopper Sub 17Grasshopper 1 - 1 BSC Young Boys Sub 17Young Boys ...
Ver jornada
Jornada 13
14 Abr 18 Team BEJUNE Sub 18Team BEJUNE 3 - 3 Fc Basel 1893 Sub 17Basel 1893 ...
14 Abr 18 FC Thun Sub 17Thun 3 - 0 Team Bejune Sub 17Team Bejune ...
14 Abr 18 BSC Young Boys Sub 17Young Boys 1 - 1 FC Vaduz Sub 18Vaduz ...
15 Abr 18 FC Zürich Sub 17Zürich 3 - 2 Luzern Sub 17Luzern ...
14 Abr 18 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 3 Grasshopper Sub 17Grasshopper ...
Ver jornada
Jornada 14
20 Abr 18 Team Bejune Sub 17Team Bejune 1 - 2 Team BEJUNE Sub 18Team BEJUNE ...
21 Abr 18 Fc Basel 1893 Sub 17Basel 1893 0 - 1 BSC Young Boys Sub 17Young Boys ...
21 Abr 18 FC Vaduz Sub 18Vaduz 1 - 1 FC St. Gallen 1879 Sub 17Gallen 1879 ...
21 Abr 18 Luzern Sub 17Luzern 4 - 2 FC Thun Sub 17Thun ...
22 Abr 18 Grasshopper Sub 17Grasshopper 4 - 1 FC Zürich Sub 17Zürich ...
Ver jornada
Jornada 15
28 Abr 18 BSC Young Boys Sub 17Young Boys 1 - 1 Team Bejune Sub 17Team Bejune ...
28 Abr 18 FC St. Gallen 1879 Sub 17Gallen 1879 2 - 2 Fc Basel 1893 Sub 17Basel 1893 ...
28 Abr 18 FC Thun Sub 17Thun 3 - 1 Team BEJUNE Sub 18Team BEJUNE ...
29 Abr 18 FC Zürich Sub 17Zürich 3 - 1 FC Vaduz Sub 18Vaduz ...
28 Abr 18 Luzern Sub 17Luzern 1 - 0 Grasshopper Sub 17Grasshopper ...
Ver jornada
Jornada 16
05 May 18 Team BEJUNE Sub 18Team BEJUNE 2 - 1 BSC Young Boys Sub 17Young Boys ...
05 May 18 FC Vaduz Sub 18Vaduz 2 - 7 Luzern Sub 17Luzern ...
05 May 18 Team Bejune Sub 17Team Bejune 1 - 3 FC St. Gallen 1879 Sub 17Gallen 1879 ...
05 May 18 Fc Basel 1893 Sub 17Basel 1893 2 - 5 FC Zürich Sub 17Zürich ...
06 May 18 Grasshopper Sub 17Grasshopper 4 - 2 FC Thun Sub 17Thun ...
Ver jornada
Jornada 17
12 May 18 FC Vaduz Sub 18Vaduz 3 - 3 Team Bejune Sub 17Team Bejune ...
12 May 18 Team BEJUNE Sub 18Team BEJUNE 4 - 3 Luzern Sub 17Luzern ...
12 May 18 FC St. Gallen 1879 Sub 17Gallen 1879 0 - 6 BSC Young Boys Sub 17Young Boys ...
12 May 18 FC Zürich Sub 17Zürich 4 - 3 Grasshopper Sub 17Grasshopper ...
Ver jornada
Jornada 18
26 May 18 Grasshopper Sub 17Grasshopper 1 - 2 Team BEJUNE Sub 18Team BEJUNE ...
26 May 18 FC Vaduz Sub 18Vaduz 1 - 5 BSC Young Boys Sub 17Young Boys ...
26 May 18 FC Thun Sub 17Thun 2 - 2 FC Zürich Sub 17Zürich ...
27 May 18 Fc Basel 1893 Sub 17Basel 1893 0 - 1 FC St. Gallen 1879 Sub 17Gallen 1879 ...
Ver jornada
Jornada 19
02 Jun 18 Team Bejune Sub 17Team Bejune 1 - 1 BSC Young Boys Sub 17Young Boys ...
02 Jun 18 Team BEJUNE Sub 18Team BEJUNE 2 - 2 FC Thun Sub 17Thun ...
02 Jun 18 Luzern Sub 17Luzern 1 - 2 Grasshopper Sub 17Grasshopper ...
03 Jun 18 Fc Basel 1893 Sub 17Basel 1893 3 - 1 FC Vaduz Sub 18Vaduz ...
Ver jornada
Jornada 20
09 Jun 18 Team Bejune Sub 17Team Bejune 1 - 2 Fc Basel 1893 Sub 17Basel 1893 ...
09 Jun 18 FC Thun Sub 17Thun 2 - 1 Luzern Sub 17Luzern ...
09 Jun 18 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 4 FC Vaduz Sub 18Vaduz ...
09 Jun 18 FC Zürich Sub 17Zürich 2 - 4 Team BEJUNE Sub 18Team BEJUNE ...
Ver jornada
Jornada 21
16 Jun 18 BSC Young Boys Sub 17Young Boys 1 - 1 Fc Basel 1893 Sub 17Basel 1893 ...
16 Jun 18 Luzern Sub 17Luzern 7 - 3 FC Zürich Sub 17Zürich ...
16 Jun 18 Grasshopper Sub 17Grasshopper 1 - 1 FC Thun Sub 17Thun ...
17 Jun 18 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 2 Team Bejune Sub 17Team Bejune ...

  USO DE MEMORIA  
5,024,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.0965
Total Execution Time  0.0988
  CADENA URL  
/liga_suiza_sub172018/grupo1/calendario
  GET DATOS  
$_GET['/liga_suiza_sub172018/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2116 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2116 ORDER BY order_id ASC
0.0026  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2018 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 49059 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 16:49:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 16:49:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 16:49:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 16:49:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0078  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 events2018 e ON e.player_id = p.id AND e.league_id = 49059 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49059 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.0048  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 events2018 e ON e.player_id = p.id AND e.league_id = 49059 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49059 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0024  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 events2018 e ON e.player_id = p.id AND e.league_id = 49059 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49059 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0024  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 49059 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC