| 0.0018 | SELECT type FROM routes WHERE alias = 'copa_suiza2009' |
| 0.0040 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_suiza' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0018 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=643 AND type_rel = 3 |
| 0.0030 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 643 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5 |
| 0.0035 | 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 (1259372,1232041,880363,708445,637041) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0018 | SELECT id,name,alias,stepParent FROM categories WHERE parentId=643 ORDER BY order_id ASC |
| 0.0029 | 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 = 20659 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0027 | 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 calendars2009 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 20659 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-05-05 16:27:34' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0019 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 16:27:34' 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-05-05 16:27:34' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0020 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 16:27:34' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0047 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 2009 |
| 0.0043 | SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (20659) 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, e.player_id ASC LIMIT 10 |
| 0.0036 | SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (20659) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (18540,110902,3256,505696,541334,8521,37660,50773,50791,50860) ORDER BY rp.in_squad = 1 DESC |
| 0.0042 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 2009 |
| 0.0048 | SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (20659) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0034 | SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (20659) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (8578,32807,32808,50791,50860,50895,67507,70187,111046,208333) ORDER BY rp.in_squad = 1 DESC |
| 0.0054 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 2009 |
| 0.0040 | SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (20659) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0039 | SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (20659) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (32807,50829,110913,249675,485238,540983,541511,646281,646357,646487) ORDER BY rp.in_squad = 1 DESC |
Ibach
FC Baulmes
Bazenheid
SC Bruhl
Chênois
FC Sursee
Racing Club
Windisch
Locle
Binningen
Allmendinge
Amriswil
Oerlikon
Winterthur
FC Thalwil
Vallemaggia
Plan-les-Ou
Sarraz-Ecl
Biaschesi
Widnau
Etoile
Biel-Bienne
Saxon
Tavannes
Schotz
Stade
Bassersdorf
Liestal
Kreuzlingen
Wacker
Lancy FC
Alle
Young Boys
Locarno
FC Lugano
Bavois
Thun
Le Mont LS
Sion
Schaffhause
Zurich
Grenchen
Luzern
FC Malley
Echallens
St. Gallen
Aarau
Yverdon
Chaux-de-Fo
Concordia
Servette
Wohlen
Grasshopper
Lausanne
Neuchâtel
Zofingen
Bellinzona
Seefeld
FC Gossau
Hongg
FC Wil
Bulle
Basel
Basel
Young Boys
Grasshopper
Zurich
Servette
Sion
Neuchâtel Xamax
Lausanne Sports
Luzern
St. Gallen
Aarau
FC Lugano
Thun
AC Bellinzona
Winterthur
FC Wil
Yverdon
Schaffhausen
Etoile Carouge
Wohlen
Stade Nyonnais
La Chaux-de-Fonds
Locarno
Biel-Bienne
Bulle
Meyrin
CS Chênois
SC Bruhl
Schotz
Bavois
Echallens
FC Gossau
Concordia Basel
FC Grenchen
FC Thalwil
Lancy FC
Kreuzlingen
Hongg
Le Mont LS
SC Zofingen
FC Sursee
Widnau
La Sarraz-Eclépens
Ibach
Liestal
Binningen
Bazenheid
FC Malley
Amriswil
FC Baulmes