4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
16 Jul 22 Young BoysYoung Boys 4 - 0 ZurichZurich 113
16 Jul 22 WinterthurWinterthur 1 - 1 BaselBasel 49
17 Jul 22 FC LuganoFC Lugano 2 - 3 SionSion 14
17 Jul 22 ServetteServette 1 - 0 St. GallenSt. Gallen 18
10 Ago 22 LuzernLuzern 1 - 1 GrasshopperGrasshopper 65
Ver jornada
Jornada 2
23 Jul 22 ZurichZurich 0 - 0 LuzernLuzern 84
23 Jul 22 St. GallenSt. Gallen 2 - 0 WinterthurWinterthur 28
24 Jul 22 BaselBasel 1 - 1 ServetteServette 28
24 Jul 22 GrasshopperGrasshopper 2 - 1 FC LuganoFC Lugano 15
24 Jul 22 SionSion 0 - 3 Young BoysYoung Boys 35
Ver jornada
Jornada 3
30 Jul 22 St. GallenSt. Gallen 2 - 0 ZurichZurich 8
30 Jul 22 SionSion 0 - 0 ServetteServette 14
31 Jul 22 WinterthurWinterthur 1 - 4 FC LuganoFC Lugano 6
31 Jul 22 Young BoysYoung Boys 1 - 1 GrasshopperGrasshopper 29
09 Nov 22 LuzernLuzern 0 - 2 BaselBasel 2
Ver jornada
Jornada 4
06 Ago 22 ServetteServette 1 - 0 WinterthurWinterthur 30
06 Ago 22 GrasshopperGrasshopper 3 - 2 St. GallenSt. Gallen 5
07 Ago 22 ZurichZurich 0 - 3 SionSion 19
07 Ago 22 BaselBasel 0 - 0 Young BoysYoung Boys 47
07 Ago 22 FC LuganoFC Lugano 1 - 2 LuzernLuzern 11
Ver jornada
Jornada 5
13 Ago 22 SionSion 2 - 2 GrasshopperGrasshopper 2
14 Ago 22 WinterthurWinterthur 1 - 1 ZurichZurich 22
13 Ago 22 St. GallenSt. Gallen 4 - 1 LuzernLuzern 4
14 Ago 22 BaselBasel 0 - 2 FC LuganoFC Lugano 96
14 Ago 22 Young BoysYoung Boys 3 - 0 ServetteServette 24
Ver jornada
Jornada 6
27 Ago 22 LuzernLuzern 2 - 0 SionSion 5
27 Ago 22 ServetteServette 3 - 1 GrasshopperGrasshopper 2
28 Ago 22 FC LuganoFC Lugano 2 - 3 St. GallenSt. Gallen 12
28 Ago 22 WinterthurWinterthur 1 - 5 Young BoysYoung Boys 25
28 Ago 22 ZurichZurich 2 - 4 BaselBasel 10
Ver jornada
Jornada 7
03 Sep 22 SionSion 2 - 1 BaselBasel 5
03 Sep 22 ZurichZurich 1 - 2 FC LuganoFC Lugano 32
04 Sep 22 LuzernLuzern 0 - 2 ServetteServette 10
04 Sep 22 GrasshopperGrasshopper 3 - 0 WinterthurWinterthur 4
04 Sep 22 St. GallenSt. Gallen 2 - 1 Young BoysYoung Boys 53
Ver jornada
Jornada 8
10 Sep 22 St. GallenSt. Gallen 1 - 2 SionSion 10
11 Sep 22 ServetteServette 3 - 2 ZurichZurich 5
10 Sep 22 WinterthurWinterthur 0 - 6 LuzernLuzern ...
11 Sep 22 BaselBasel 5 - 1 GrasshopperGrasshopper 5
11 Sep 22 Young BoysYoung Boys 3 - 0 FC LuganoFC Lugano 15
Ver jornada
Jornada 9
01 Oct 22 BaselBasel 3 - 2 St. GallenSt. Gallen 8
01 Oct 22 GrasshopperGrasshopper 1 - 1 ZurichZurich 13
02 Oct 22 SionSion 1 - 3 WinterthurWinterthur 22
02 Oct 22 FC LuganoFC Lugano 1 - 0 ServetteServette 33
02 Oct 22 LuzernLuzern 1 - 2 Young BoysYoung Boys 29
Ver jornada
Jornada 10
08 Oct 22 GrasshopperGrasshopper 4 - 4 SionSion 7
09 Oct 22 FC LuganoFC Lugano 1 - 0 BaselBasel 15
09 Oct 22 ServetteServette 1 - 1 LuzernLuzern 3
08 Oct 22 Young BoysYoung Boys 2 - 1 St. GallenSt. Gallen 21
09 Oct 22 ZurichZurich 0 - 0 WinterthurWinterthur 13
Ver jornada
Jornada 11
16 Oct 22 ServetteServette 0 - 0 BaselBasel 6
15 Oct 22 SionSion 2 - 0 LuzernLuzern 20
16 Oct 22 St. GallenSt. Gallen 1 - 1 FC LuganoFC Lugano 11
15 Oct 22 WinterthurWinterthur 1 - 0 GrasshopperGrasshopper 2
16 Oct 22 ZurichZurich 0 - 0 Young BoysYoung Boys 55
Ver jornada
Jornada 12
20 Oct 22 BaselBasel 0 - 0 ZurichZurich 205
20 Oct 22 GrasshopperGrasshopper 2 - 3 ServetteServette 18
19 Oct 22 FC LuganoFC Lugano 1 - 4 Young BoysYoung Boys 17
19 Oct 22 LuzernLuzern 3 - 3 St. GallenSt. Gallen 5
18 Oct 22 WinterthurWinterthur 1 - 0 SionSion 22
Ver jornada
Jornada 13
23 Oct 22 BaselBasel 3 - 1 WinterthurWinterthur 5
22 Oct 22 LuzernLuzern 3 - 1 FC LuganoFC Lugano 24
23 Oct 22 St. GallenSt. Gallen 1 - 1 ServetteServette 3
22 Oct 22 Young BoysYoung Boys 1 - 1 SionSion 102
23 Oct 22 ZurichZurich 1 - 4 GrasshopperGrasshopper 11
Ver jornada
Jornada 14
29 Oct 22 GrasshopperGrasshopper 1 - 3 LuzernLuzern 3
29 Oct 22 ServetteServette 2 - 2 FC LuganoFC Lugano 20
30 Oct 22 SionSion 0 - 1 ZurichZurich 50
30 Oct 22 WinterthurWinterthur 1 - 0 St. GallenSt. Gallen 9
30 Oct 22 Young BoysYoung Boys 3 - 1 BaselBasel 18
Ver jornada
Jornada 15
06 Nov 22 BaselBasel 0 - 0 SionSion 18
06 Nov 22 FC LuganoFC Lugano 2 - 0 ZurichZurich 4
05 Nov 22 LuzernLuzern 1 - 1 WinterthurWinterthur 41
06 Nov 22 ServetteServette 0 - 0 Young BoysYoung Boys 21
05 Nov 22 St. GallenSt. Gallen 2 - 1 GrasshopperGrasshopper 7
Ver jornada
Jornada 16
12 Nov 22 GrasshopperGrasshopper 1 - 0 BaselBasel 55
12 Nov 22 SionSion 2 - 7 St. GallenSt. Gallen 29
13 Nov 22 FC LuganoFC Lugano 3 - 1 WinterthurWinterthur 4
13 Nov 22 Young BoysYoung Boys 3 - 0 LuzernLuzern 19
13 Nov 22 ZurichZurich 4 - 1 ServetteServette 17
Ver jornada
Jornada 17
21 Ene 23 GrasshopperGrasshopper 1 - 2 Young BoysYoung Boys 56
21 Ene 23 LuzernLuzern 2 - 2 ZurichZurich 9
22 Ene 23 SionSion 2 - 3 FC LuganoFC Lugano 5
22 Ene 23 St. GallenSt. Gallen 1 - 1 BaselBasel 33
15 Feb 23 WinterthurWinterthur 1 - 2 ServetteServette 120
Ver jornada
Jornada 18
28 Ene 23 BaselBasel 2 - 3 LuzernLuzern 34
28 Ene 23 FC LuganoFC Lugano 1 - 1 GrasshopperGrasshopper 33
29 Ene 23 ServetteServette 2 - 2 SionSion 12
29 Ene 23 Young BoysYoung Boys 5 - 1 WinterthurWinterthur 20
29 Ene 23 ZurichZurich 1 - 0 St. GallenSt. Gallen 55
Ver jornada
Jornada 19
04 Feb 23 GrasshopperGrasshopper 1 - 0 BaselBasel 31
05 Feb 23 LuzernLuzern 1 - 1 Young BoysYoung Boys 81
05 Feb 23 SionSion 0 - 1 ZurichZurich 7
04 Feb 23 St. GallenSt. Gallen 3 - 0 ServetteServette 12
05 Feb 23 WinterthurWinterthur 1 - 0 FC LuganoFC Lugano 5
Ver jornada
Jornada 20
11 Feb 23 BaselBasel 3 - 1 SionSion 28
12 Feb 23 FC LuganoFC Lugano 1 - 1 LuzernLuzern 8
11 Feb 23 ServetteServette 2 - 1 GrasshopperGrasshopper 1
12 Feb 23 Young BoysYoung Boys 5 - 1 St. GallenSt. Gallen 19
12 Feb 23 ZurichZurich 1 - 1 WinterthurWinterthur 35
Ver jornada
Jornada 21
19 Feb 23 BaselBasel 2 - 2 ServetteServette 11
19 Feb 23 GrasshopperGrasshopper 1 - 2 ZurichZurich 12
19 Feb 23 St. GallenSt. Gallen 2 - 2 LuzernLuzern 13
18 Feb 23 WinterthurWinterthur 1 - 1 SionSion 6
18 Feb 23 Young BoysYoung Boys 1 - 1 FC LuganoFC Lugano 170
Ver jornada
Jornada 22
26 Feb 23 FC LuganoFC Lugano 2 - 2 BaselBasel 17
26 Feb 23 LuzernLuzern 1 - 0 GrasshopperGrasshopper 2
26 Feb 23 ServetteServette 1 - 1 WinterthurWinterthur 51
25 Feb 23 SionSion 0 - 4 St. GallenSt. Gallen 15
25 Feb 23 ZurichZurich 2 - 2 Young BoysYoung Boys 53
Ver jornada
Jornada 23
04 Mar 23 LuzernLuzern 0 - 1 BaselBasel 23
05 Mar 23 SionSion 1 - 1 FC LuganoFC Lugano 13
05 Mar 23 St. GallenSt. Gallen 1 - 1 GrasshopperGrasshopper 16
04 Mar 23 WinterthurWinterthur 1 - 1 Young BoysYoung Boys 89
05 Mar 23 ZurichZurich 1 - 1 ServetteServette 34
Ver jornada
Jornada 24
12 Mar 23 BaselBasel 1 - 1 St. GallenSt. Gallen 38
12 Mar 23 GrasshopperGrasshopper 2 - 1 WinterthurWinterthur ...
11 Mar 23 FC LuganoFC Lugano 2 - 0 ZurichZurich 18
12 Mar 23 ServetteServette 0 - 3 LuzernLuzern 29
11 Mar 23 Young BoysYoung Boys 4 - 0 SionSion 23
Ver jornada
Jornada 25
19 Mar 23 FC LuganoFC Lugano 1 - 1 ServetteServette 10
18 Mar 23 SionSion 1 - 2 GrasshopperGrasshopper 17
19 Mar 23 WinterthurWinterthur 1 - 0 St. GallenSt. Gallen 10
19 Mar 23 Young BoysYoung Boys 3 - 0 BaselBasel 60
18 Mar 23 ZurichZurich 2 - 1 LuzernLuzern 8
Ver jornada
Jornada 26
01 Abr 23 BaselBasel 2 - 0 WinterthurWinterthur 19
02 Abr 23 GrasshopperGrasshopper 2 - 1 FC LuganoFC Lugano 3
02 Abr 23 LuzernLuzern 1 - 2 SionSion 10
01 Abr 23 ServetteServette 2 - 1 Young BoysYoung Boys 12
02 Abr 23 St. GallenSt. Gallen 2 - 2 ZurichZurich 9
Ver jornada
Jornada 27
10 Abr 23 FC LuganoFC Lugano 1 - 1 St. GallenSt. Gallen 37
08 Abr 23 SionSion 2 - 2 ServetteServette 12
10 Abr 23 WinterthurWinterthur 1 - 2 LuzernLuzern 4
10 Abr 23 Young BoysYoung Boys 2 - 0 GrasshopperGrasshopper 129
08 Abr 23 ZurichZurich 1 - 1 BaselBasel 51
Ver jornada
Jornada 28
16 Abr 23 BaselBasel 1 - 1 Young BoysYoung Boys 40
16 Abr 23 GrasshopperGrasshopper 1 - 3 SionSion 11
15 Abr 23 LuzernLuzern 4 - 1 ZurichZurich 6
15 Abr 23 ServetteServette 0 - 0 FC LuganoFC Lugano 36
16 Abr 23 St. GallenSt. Gallen 2 - 3 WinterthurWinterthur 30
Ver jornada
Jornada 29
23 Abr 23 BaselBasel 0 - 2 LuzernLuzern 72
23 Abr 23 FC LuganoFC Lugano 2 - 0 SionSion 18
22 Abr 23 WinterthurWinterthur 1 - 2 GrasshopperGrasshopper 17
22 Abr 23 Young BoysYoung Boys 6 - 1 ServetteServette 25
23 Abr 23 ZurichZurich 1 - 0 St. GallenSt. Gallen 7
Ver jornada
Jornada 30
25 Abr 23 GrasshopperGrasshopper 4 - 1 Young BoysYoung Boys 54
27 Abr 23 LuzernLuzern 3 - 1 WinterthurWinterthur 100
26 Abr 23 ServetteServette 4 - 0 ZurichZurich 29
27 Abr 23 SionSion 1 - 2 BaselBasel 31
26 Abr 23 St. GallenSt. Gallen 1 - 2 FC LuganoFC Lugano 67
Ver jornada
Jornada 31
29 Abr 23 FC LuganoFC Lugano 5 - 1 GrasshopperGrasshopper 68
29 Abr 23 ServetteServette 1 - 1 St. GallenSt. Gallen 60
30 Abr 23 WinterthurWinterthur 1 - 4 BaselBasel 16
30 Abr 23 Young BoysYoung Boys 5 - 1 LuzernLuzern 30
30 Abr 23 ZurichZurich 2 - 2 SionSion 14
Ver jornada
Jornada 32
07 May 23 BaselBasel 0 - 2 ZurichZurich 59
07 May 23 GrasshopperGrasshopper 2 - 3 ServetteServette 18
07 May 23 LuzernLuzern 2 - 2 FC LuganoFC Lugano 12
06 May 23 SionSion 0 - 1 WinterthurWinterthur 44
06 May 23 St. GallenSt. Gallen 0 - 2 Young BoysYoung Boys 159
Ver jornada
Jornada 33
13 May 23 GrasshopperGrasshopper 2 - 0 LuzernLuzern 54
14 May 23 FC LuganoFC Lugano 2 - 1 WinterthurWinterthur 6
13 May 23 ServetteServette 5 - 0 SionSion 19
14 May 23 St. GallenSt. Gallen 6 - 1 BaselBasel 33
14 May 23 Young BoysYoung Boys 1 - 1 ZurichZurich 66
Ver jornada
Jornada 34
21 May 23 BaselBasel 1 - 1 FC LuganoFC Lugano 33
20 May 23 LuzernLuzern 1 - 1 St. GallenSt. Gallen 28
21 May 23 SionSion 0 - 2 Young BoysYoung Boys 11
20 May 23 WinterthurWinterthur 0 - 1 ServetteServette 44
21 May 23 ZurichZurich 2 - 1 GrasshopperGrasshopper 8
Ver jornada
Jornada 35
25 May 23 GrasshopperGrasshopper 2 - 2 St. GallenSt. Gallen 20
25 May 23 FC LuganoFC Lugano 2 - 0 Young BoysYoung Boys 110
25 May 23 ServetteServette 3 - 3 BaselBasel 36
25 May 23 SionSion 1 - 2 LuzernLuzern 20
25 May 23 WinterthurWinterthur 0 - 2 ZurichZurich 29
Ver jornada
Jornada 36
29 May 23 BaselBasel 3 - 1 GrasshopperGrasshopper 130
29 May 23 LuzernLuzern 0 - 1 ServetteServette 84
29 May 23 St. GallenSt. Gallen 4 - 0 SionSion 32
29 May 23 Young BoysYoung Boys 2 - 1 WinterthurWinterthur 100
29 May 23 ZurichZurich 2 - 3 FC LuganoFC Lugano 46

Clasificación

Equipo PJ GF GC Puntos
1 Young Boys Young Boys 36 82 30 74
2 Servette Servette 36 53 48 58
3 FC Lugano FC Lugano 36 59 47 57
4 Luzern Luzern 36 56 52 50
5 Basel Basel 36 51 50 47
6 St. Gallen St. Gallen 36 66 52 45
7 Grasshopper Grasshopper 36 56 64 44
8 Zurich Zurich 36 41 55 44
9 Winterthur Winterthur 36 32 66 32
10 Sion Sion 36 41 73 31

  USO DE MEMORIA  
6,072,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3566
Total Execution Time  0.3585
  CADENA URL  
/suiza2023/grupo1/calendario
  GET DATOS  
$_GET['/suiza2023/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0106  SELECT type FROM routes WHERE alias = 'suiza2023'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'suiza' 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.0108  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=36 AND type_rel = 3
0.0118  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 36 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0113  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 (1295393,1287617,1287396,1279364,1277727) ORDER BY n.cover_points DESC, update_date DESC
0.0108  SELECT id,name,alias,stepParent FROM categories WHERE parentId=36 ORDER BY order_id ASC
0.0107  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 = 67779 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0118  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 calendars2023 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 67779 ORDER BY round ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-23 13:09:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-23 13:09:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-23 13:09:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-23 13:09:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'suiza' 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.0271  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 = 67779 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67779 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.0312  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 = 67779 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67779 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0125  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 = 67779 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67779 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0115  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 = 67779 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC