Hôtel Ambassadeur Québec

HÔTEL AMBASSADEUR QUÉBEC
The perfect family destination in Québec City

Hôtel Ambassadeur Québec is the ideal place for a memorable family getaway in Québec City. Nestled along the banks of the St. Lawrence River and just 10 minutes from Old Québec, the hotel features 145 comfortable rooms and suites, perfect for families, couples, friends, or business travelers.

The tropical indoor garden, with a heated pool, hot tub, and water games, offers relaxation and fun for all ages. Conveniently located near a wide range of restaurants and offering free spacious parking, Hôtel Ambassadeur Québec is the perfect starting point to explore the region.

Just minutes from Old Québec
Step into over 400 years of history in Old Québec, a UNESCO World Heritage Site. Discover charming cobblestone streets, unique shops, local gourmet restaurants, and a festive atmosphere inspired by European culture.

With quick and easy access from Hôtel Ambassadeur Québec, you’re just moments away from this iconic historical gem.

Total (ms)

Load (ms)

App (ms)

Query (ms)

Count

Average (ms)

Template

Order

10.7

0.003

1.52

9.19

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

634.4

6.89

C:\sites\passeportvacances.com\www\main.cfm$VURL2

341.8

6.83

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm$VURL2

6.58

C:\sites\passeportvacances.com\www\tops.cfm$VURL2

2.84

0.003

2.2

0.643

C:\sites\passeportvacances.com\www\inc\module\big_box_vertical.cfm

2.69

0.004

0.414

2.27

C:\sites\passeportvacances.com\www\tops.cfm

1.23

C:\sites\passeportvacances.com\www\Application.cfc$onRequestEnd

0.833

0.004

0.358

0.469

C:\sites\passeportvacances.com\www\inc\module\leaderboard.cfm

18.8

0.427

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm$REPLACESITEVARS

26.9

0.321

C:\sites\passeportvacances.com\www\main.cfm$REPLACESITEVARS

0.164

3.02

C:\sites\passeportvacances.com\www\Application.cfc

4.83

0.096

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm$PREPAREURLSTRING

8.46

0.094

C:\sites\passeportvacances.com\www\main.cfm$PREPAREURLSTRING

0.088

C:\sites\passeportvacances.com\www\Application.cfc$onRequestStart

0.077

C:\sites\passeportvacances.com\www\tops.cfm$PREPAREURLSTRING

0.027

C:\sites\passeportvacances.com\www\tops.cfm$REPLACESITEVARS

0.022

0.004

0.017

C:\sites\passeportvacances.com\www\js\includeJs.cfm

0.014

C:\sites\passeportvacances.com\www\Application.cfc$onSessionStart

0.014

0.001

1004.7

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

0.01

C:\sites\passeportvacances.com\www\partage\date1.cfc

0.008

C:\sites\passeportvacances.com\www\partage\date1.cfc$init

0.007

0.001

0.006

C:\sites\passeportvacances.com\www\inc\fonction.cfm

0.028

0.005

C:\sites\passeportvacances.com\www\main.cfm$GETINDEXATION2

0.038

0.004

C:\sites\passeportvacances.com\www\main.cfm$ISDEF

0.008

0.004

C:\lucee6\tomcat\lucee-server\context\components\org\lucee\cfml\Component.cfc

0.003

C:\sites\passeportvacances.com\www\main.cfm$ISMOBILE

0.002

C:\sites\passeportvacances.com\www\Application.cfc$init

0.002

C:\sites\passeportvacances.com\www\main.cfm$BALISESAFE

0.003

12.1

C:\sites\passeportvacances.com\www\main.cfm

C:\sites\passeportvacances.com\www\Application.cfc$onRequest

Name

Open Connections

Max Connections

passeportvacances

100

passeportvacancesLogs

100

Name

Records

Time

Usage

Datasource

Source

Line

Cached

findPage

0.492 ms

passeportvacances

C:\sites\passeportvacances.com\www\Application.cfc

513

SQL

SELECT TEXTE_ID, NoPage, Nom_fr, Nom_en, Titre_fr, Titre_en, Intro_fr, Intro_en, Texte_fr, Texte_en, PhotoActive FROM TEXTE WITH (NOLOCK) WHERE Actif = 1 and Lower(nom_en) = ''

findPage

0.38 ms

passeportvacances

C:\sites\passeportvacances.com\www\Application.cfc

534

SQL

SELECT TEXTE_ID, NoPage, Nom_fr, Nom_en, Titre_fr, Titre_en, Intro_fr, Intro_en, Texte_fr, Texte_en, PhotoActive FROM TEXTE WITH (NOLOCK) WHERE Actif = 1 and Lower(nom_fr) = ''

getAR

0.615 ms

passeportvacances

C:\sites\passeportvacances.com\www\Application.cfc

919

SQL

Select ar_id, region_id, suggestioncat_id From activityRegionPages WITH (NOLOCK) Where actif = 1 and (link_fr = 'hotel-ambassadeur-quebec-city' or link_en = 'hotel-ambassadeur-quebec-city')

getTops

0.456 ms

passeportvacances

C:\sites\passeportvacances.com\www\Application.cfc

930

SQL

Select top_id From tops WITH (NOLOCK) Where actif = 1 and (link_fr = 'hotel-ambassadeur-quebec-city' or link_en = 'hotel-ambassadeur-quebec-city')

getSEO

0.364 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

256

SQL

Select RefDescription_en as RefDescription, RefMotsCles_en as RefMotsCles, RefTitre_en as refTitre From tops WITH (NOLOCK) Where top_id = 1035

getEcomBillet

7.51 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

qrNm

0.49 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

358

SQL

Select link_en as lnk From tops Where link_en = 'hotel-ambassadeur-quebec-city' or link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.62 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'hotel-ambassadeur-quebec-city'

qrNm

0.446 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

358

SQL

Select link_fr as lnk From tops Where link_en = 'hotel-ambassadeur-quebec-city' or link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.47 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechRegionMenu

0.73 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

612

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT IS NULL ORDER BY Nom_en

rechThemeMenu

0.712 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

618

SQL

SELECT SuggestionCat_ID, TitreMenu_en as ThemeNomMenu, Titre_en as ThemeNom FROM SuggestionCat WITH (NOLOCK) WHERE Actif = 1 ORDER BY Titre_en

rechLodgingMenu

0.612 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

624

SQL

SELECT SuggestionLODG_ID, TitreMenu_en as ThemeNomLogMenu, Titre_en as ThemeNomLog FROM SuggestionLodging WITH (NOLOCK) WHERE Actif = 1 ORDER BY Titre_en

getEcomBillet

6.65 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.63 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletLodg

0.283 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 4

getEcomBillet

6.47 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletLodg

0.343 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 2

getEcomBillet

6.81 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletLodg

0.274 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 1

getEcomBillet

6.56 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletLodg

0.263 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 6

getEcomBillet

6.73 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletLodg

0.311 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 5

getEcomBillet

6.79 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletLodg

0.361 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 3

getEcomBillet

7 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.299 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 39

getNM

0.358 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'1000 Islands & surroundings' or nom_fr = N'1000 Islands & surroundings'

rechSubRegionMenu

0.637 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 39 ORDER BY Nom_en

getEcomBillet

6.61 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.354 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 10

getNM

0.39 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Abitibi-Témiscamingue' or nom_fr = N'Abitibi-Témiscamingue'

rechSubRegionMenu

0.585 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 10 ORDER BY Nom_en

getEcomBillet

6.8 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.28 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 46

getNM

0.395 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'La Vallée-de-l''Or' or nom_fr = N'La Vallée-de-l''Or'

getEcomBillet

6.68 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.359 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 18

getNM

0.403 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Centre-du-Québec ' or nom_fr = N'Centre-du-Québec '

rechSubRegionMenu

0.624 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 18 ORDER BY Nom_en

getEcomBillet

6.69 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.293 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 12

getNM

0.402 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Charlevoix' or nom_fr = N'Charlevoix'

rechSubRegionMenu

0.601 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 12 ORDER BY Nom_en

getEcomBillet

6.73 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.31 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 9

getNM

0.306 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Chaudière-Appalaches' or nom_fr = N'Chaudière-Appalaches'

rechSubRegionMenu

0.57 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 9 ORDER BY Nom_en

getEcomBillet

6.31 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.367 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 5

getNM

0.401 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Côte-Nord' or nom_fr = N'Côte-Nord'

rechSubRegionMenu

0.569 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 5 ORDER BY Nom_en

getEcomBillet

7.07 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.361 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 19

getNM

0.375 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Eastern Townships' or nom_fr = N'Eastern Townships'

rechSubRegionMenu

0.623 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 19 ORDER BY Nom_en

getEcomBillet

6.62 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.371 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 43

getNM

0.396 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Magog - Sherbrooke' or nom_fr = N'Magog - Sherbrooke'

getEcomBillet

6.62 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.362 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 17

getNM

0.416 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Lanaudière' or nom_fr = N'Lanaudière'

rechSubRegionMenu

0.591 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 17 ORDER BY Nom_en

getEcomBillet

6.61 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.302 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 16

getNM

0.394 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Laurentians' or nom_fr = N'Laurentians'

rechSubRegionMenu

0.622 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 16 ORDER BY Nom_en

getEcomBillet

6.56 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.265 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 23

getNM

0.39 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Tremblant' or nom_fr = N'Tremblant'

getEcomBillet

6.44 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.354 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 21

getNM

0.332 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Laval' or nom_fr = N'Laval'

rechSubRegionMenu

0.569 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 21 ORDER BY Nom_en

getEcomBillet

6.54 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.366 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 11

getNM

0.399 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Mauricie' or nom_fr = N'Mauricie'

rechSubRegionMenu

0.609 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 11 ORDER BY Nom_en

getEcomBillet

6.58 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.267 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 20

getNM

0.396 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Montérégie' or nom_fr = N'Montérégie'

rechSubRegionMenu

0.576 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 20 ORDER BY Nom_en

getEcomBillet

6.55 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.293 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 45

getNM

0.357 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Haut-Richelieu' or nom_fr = N'Haut-Richelieu'

getEcomBillet

6.64 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.303 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 28

getNM

0.409 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Montérégie-West' or nom_fr = N'Montérégie-West'

getEcomBillet

7.11 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.296 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 22

getNM

0.405 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Montreal' or nom_fr = N'Montreal'

rechSubRegionMenu

0.554 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 22 ORDER BY Nom_en

getEcomBillet

7.03 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.366 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 32

getNM

0.402 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Old Montreal & The Old Port of Montreal' or nom_fr = N'Old Montreal & The Old Port of Montreal'

getEcomBillet

6.75 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.366 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 15

getNM

0.401 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Outaouais - Ottawa' or nom_fr = N'Outaouais - Ottawa'

rechSubRegionMenu

0.614 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 15 ORDER BY Nom_en

getEcomBillet

6.94 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.366 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 13

getNM

0.419 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Quebec - Quebec' or nom_fr = N'Quebec - Quebec'

rechSubRegionMenu

0.662 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 13 ORDER BY Nom_en

getEcomBillet

7.28 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.266 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 41

getNM

0.372 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Île d''Orléans' or nom_fr = N'Île d''Orléans'

getEcomBillet

6.83 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.323 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 44

getNM

0.407 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'The Jacques-Cartier' or nom_fr = N'The Jacques-Cartier'

getEcomBillet

6.61 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.294 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 4

getNM

0.391 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Saguenay - Lac-Saint-Jean' or nom_fr = N'Saguenay - Lac-Saint-Jean'

rechSubRegionMenu

0.701 ms

passeportvacances

C:\sites\passeportvacances.com\www\main.cfm

709

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 4 ORDER BY Nom_en

getEcomBillet

6.6 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.413 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 35

getNM

0.5 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Lac St-Jean - Alma - Roberval - St-Félicien' or nom_fr = N'Lac St-Jean - Alma - Roberval - St-Félicien'

getEcomBillet

6.62 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.301 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 42

getNM

0.398 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Saguenay - The Fjord' or nom_fr = N'Saguenay - The Fjord'

getEcomBillet

6.75 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.379 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Agrotourism in Quebec' or titre_fr = N'Agrotourism in Quebec'

getEcomBillet

6.75 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.442 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Amusement centers' or titre_fr = N'Amusement centers'

getEcomBillet

6.71 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.327 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Cruises' or titre_fr = N'Cruises'

getEcomBillet

6.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.418 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Family activities' or titre_fr = N'Family activities'

getEcomBillet

6.72 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.316 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Festivals & Shows' or titre_fr = N'Festivals & Shows'

getEcomBillet

6.63 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.451 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Indigenous Traditions & Cultures' or titre_fr = N'Indigenous Traditions & Cultures'

getEcomBillet

6.63 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.418 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Mountain biking in Quebec' or titre_fr = N'Mountain biking in Quebec'

getEcomBillet

6.48 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.387 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Museums ' or titre_fr = N'Museums '

getEcomBillet

6.62 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.424 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'National & Regional Parks of Quebec' or titre_fr = N'National & Regional Parks of Quebec'

getEcomBillet

6.45 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.335 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Outdoor Activities' or titre_fr = N'Outdoor Activities'

getEcomBillet

6.44 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.406 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Promotions & Coupons' or titre_fr = N'Promotions & Coupons'

getEcomBillet

6.41 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.44 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Spa & Retreat' or titre_fr = N'Spa & Retreat'

getEcomBillet

6.36 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.443 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vineyards and Cideries of Quebec' or titre_fr = N'Vineyards and Cideries of Quebec'

getEcomBillet

6.35 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.341 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Water Parks & Beaches' or titre_fr = N'Water Parks & Beaches'

getEcomBillet

6.87 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.394 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Zoos & Amusement Parks - Aquariums' or titre_fr = N'Zoos & Amusement Parks - Aquariums'

getEcomBillet

6.67 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

9.49 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.58 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.84 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.79 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.76 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.69 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.6 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.81 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.65 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.8 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.62 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.79 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechLeaderboard

0.469 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\module\leaderboard.cfm

SQL

SELECT Leaderboard.Leaderboard_ID, Leaderboard.Titre_en AS TitreLeaderboard, Leaderboard.Url_en AS Url, Leaderboard.UrlExterne_en AS UrlExterne, Leaderboard.DateDebut, Leaderboard.DateFin FROM Leaderboard WHERE Leaderboard.Actif = 1 AND Leaderboard.PhotoActive2 = 1 AND Leaderboard.DateDebut <= getdate() AND Leaderboard.DateFin >= getdate() AND ISNULL(Leaderboard.RegionSeulement,0) = 0 ORDER BY NEWID()

getEcomBillet

6.74 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.429 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Agrotourism in Quebec' or titre_fr = N'Agrotourism in Quebec'

getEcomBillet

6.67 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.405 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Amusement centers' or titre_fr = N'Amusement centers'

getEcomBillet

6.61 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.316 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Cruises' or titre_fr = N'Cruises'

getEcomBillet

6.83 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.468 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Family activities' or titre_fr = N'Family activities'

getEcomBillet

6.68 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.344 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Festivals & Shows' or titre_fr = N'Festivals & Shows'

getEcomBillet

6.61 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.4 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Indigenous Traditions & Cultures' or titre_fr = N'Indigenous Traditions & Cultures'

getEcomBillet

6.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.326 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Mountain biking in Quebec' or titre_fr = N'Mountain biking in Quebec'

getEcomBillet

7.62 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.43 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Museums ' or titre_fr = N'Museums '

getEcomBillet

6.65 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.324 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'National & Regional Parks of Quebec' or titre_fr = N'National & Regional Parks of Quebec'

getEcomBillet

6.5 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.399 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Outdoor Activities' or titre_fr = N'Outdoor Activities'

getEcomBillet

6.48 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.4 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Promotions & Coupons' or titre_fr = N'Promotions & Coupons'

getEcomBillet

6.52 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.414 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Spa & Retreat' or titre_fr = N'Spa & Retreat'

getEcomBillet

6.78 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.358 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vineyards and Cideries of Quebec' or titre_fr = N'Vineyards and Cideries of Quebec'

getEcomBillet

10.5 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.489 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Water Parks & Beaches' or titre_fr = N'Water Parks & Beaches'

getEcomBillet

9.39 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.448 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Zoos & Amusement Parks - Aquariums' or titre_fr = N'Zoos & Amusement Parks - Aquariums'

getEcomBillet

6.51 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletLodg

0.328 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 4

getEcomBillet

6.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletLodg

0.349 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 2

getEcomBillet

6.4 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletLodg

0.293 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 1

getEcomBillet

6.84 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletLodg

0.296 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 6

getEcomBillet

6.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletLodg

0.284 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 5

getEcomBillet

6.68 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletLodg

0.282 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

369

SQL

SELECT SuggestionLodg_ID, titreMenu_en as Nom_en, titreMenu_fr as Nom_fr FROM SuggestionLodging WHERE Actif = 1 and SuggestionLodg_ID = 3

getEcomBillet

6.55 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.28 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 39

getNM

0.331 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'1000 Islands & surroundings' or nom_fr = N'1000 Islands & surroundings'

rechSubRegionMenu

0.592 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 39 ORDER BY Nom_en

getEcomBillet

6.49 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.387 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 10

getNM

0.404 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Abitibi-Témiscamingue' or nom_fr = N'Abitibi-Témiscamingue'

rechSubRegionMenu

0.633 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 10 ORDER BY Nom_en

getEcomBillet

6.56 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.266 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 46

getNM

0.401 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'La Vallée-de-l''Or' or nom_fr = N'La Vallée-de-l''Or'

getEcomBillet

6.43 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.404 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 18

getNM

0.354 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Centre-du-Québec ' or nom_fr = N'Centre-du-Québec '

rechSubRegionMenu

0.586 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 18 ORDER BY Nom_en

getEcomBillet

6.83 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.277 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 12

getNM

0.335 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Charlevoix' or nom_fr = N'Charlevoix'

rechSubRegionMenu

0.575 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 12 ORDER BY Nom_en

getEcomBillet

6.25 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.268 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 9

getNM

0.383 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Chaudière-Appalaches' or nom_fr = N'Chaudière-Appalaches'

rechSubRegionMenu

0.566 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 9 ORDER BY Nom_en

getEcomBillet

5.62 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.267 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 5

getNM

0.436 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Côte-Nord' or nom_fr = N'Côte-Nord'

rechSubRegionMenu

0.484 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 5 ORDER BY Nom_en

getEcomBillet

5.61 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.283 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 19

getNM

0.335 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Eastern Townships' or nom_fr = N'Eastern Townships'

rechSubRegionMenu

0.523 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 19 ORDER BY Nom_en

getEcomBillet

5.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.339 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 43

getNM

0.437 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Magog - Sherbrooke' or nom_fr = N'Magog - Sherbrooke'

getEcomBillet

5.61 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.271 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 17

getNM

0.332 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Lanaudière' or nom_fr = N'Lanaudière'

rechSubRegionMenu

0.475 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 17 ORDER BY Nom_en

getEcomBillet

5.64 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.339 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 16

getNM

0.382 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Laurentians' or nom_fr = N'Laurentians'

rechSubRegionMenu

0.568 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 16 ORDER BY Nom_en

getEcomBillet

5.68 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.339 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 23

getNM

0.301 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Tremblant' or nom_fr = N'Tremblant'

getEcomBillet

5.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.252 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 21

getNM

0.331 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Laval' or nom_fr = N'Laval'

rechSubRegionMenu

0.47 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 21 ORDER BY Nom_en

getEcomBillet

5.64 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.279 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 11

getNM

0.381 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Mauricie' or nom_fr = N'Mauricie'

rechSubRegionMenu

0.529 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 11 ORDER BY Nom_en

getEcomBillet

5.83 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.34 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 20

getNM

0.306 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Montérégie' or nom_fr = N'Montérégie'

rechSubRegionMenu

0.582 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 20 ORDER BY Nom_en

getEcomBillet

5.76 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.265 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 45

getNM

0.331 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Haut-Richelieu' or nom_fr = N'Haut-Richelieu'

getEcomBillet

6.25 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.263 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 28

getNM

0.383 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Montérégie-West' or nom_fr = N'Montérégie-West'

getEcomBillet

6.79 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.414 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 22

getNM

0.399 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Montreal' or nom_fr = N'Montreal'

rechSubRegionMenu

0.563 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 22 ORDER BY Nom_en

getEcomBillet

6.6 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.281 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 32

getNM

0.335 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Old Montreal & The Old Port of Montreal' or nom_fr = N'Old Montreal & The Old Port of Montreal'

getEcomBillet

6.5 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.281 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 15

getNM

0.302 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Outaouais - Ottawa' or nom_fr = N'Outaouais - Ottawa'

rechSubRegionMenu

0.602 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 15 ORDER BY Nom_en

getEcomBillet

6.28 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.262 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 13

getNM

0.358 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Quebec - Quebec' or nom_fr = N'Quebec - Quebec'

rechSubRegionMenu

0.791 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 13 ORDER BY Nom_en

getEcomBillet

6.44 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.368 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 41

getNM

0.34 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Île d''Orléans' or nom_fr = N'Île d''Orléans'

getEcomBillet

6.37 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.264 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 44

getNM

0.39 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'The Jacques-Cartier' or nom_fr = N'The Jacques-Cartier'

getEcomBillet

6.29 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.407 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 4

getNM

0.379 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Saguenay - Lac-Saint-Jean' or nom_fr = N'Saguenay - Lac-Saint-Jean'

rechSubRegionMenu

0.65 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\nav\menu.cfm

104

SQL

SELECT REGION_ID, Nom_en as RegionNom FROM Region WITH (NOLOCK) WHERE Actif = 1 AND REGION_ID_PARENT = 4 ORDER BY Nom_en

getEcomBillet

6.3 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.263 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 35

getNM

0.359 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Lac St-Jean - Alma - Roberval - St-Félicien' or nom_fr = N'Lac St-Jean - Alma - Roberval - St-Félicien'

getEcomBillet

6.39 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBilletRegion2

0.292 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

462

SQL

SELECT Region_ID, Nom_fr, Nom_en FROM Region WHERE Actif = 1 and Region_ID = 42

getNM

0.46 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

252

SQL

Select nom_en as nm From region WITH (NOLOCK) Where nom_en = N'Saguenay - The Fjord' or nom_fr = N'Saguenay - The Fjord'

getEcomBillet

6.39 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.38 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.21 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getTop

0.492 ms

passeportvacances

C:\sites\passeportvacances.com\www\tops.cfm

SQL

Select *, Intro_en as BilletIntro, Descr_en as BilletDescription , titre_en as DescrTitre From tops Where top_id = 1035 and actif = 1

getTopElements

0.884 ms

passeportvacances

C:\sites\passeportvacances.com\www\tops.cfm

SQL

Select *, nom_en as DescrTitre, Descr_en as Description From topsElements Where top_id = 1035 and actif = 1 Order by Ordre asc

rechBilletRegion

0.345 ms

passeportvacances

C:\sites\passeportvacances.com\www\tops.cfm

SQL

SELECT r.Region_ID, r.Nom_en as RegionNom FROM Region r WITH (NOLOCK) Inner Join topsjctREGION t WITH(NOLOCK) On r.region_id = t.region_id WHERE t.top_id = 1035 ORDER BY Nom_en

rechBilletTheme

0.312 ms

passeportvacances

C:\sites\passeportvacances.com\www\tops.cfm

SQL

SELECT s.SUGGESTIONCAT_ID, s.Titre_en AS ThemeNom FROM SUGGESTIONCAT s WITH (NOLOCK) Inner Join topsjctSUGGESTIONCAT t WITH(NOLOCK) On s.SUGGESTIONCAT_ID = t.SUGGESTIONCAT_ID WHERE t.top_id = 1035 ORDER BY Ordre asc

rechBilletLodg

0.239 ms

passeportvacances

C:\sites\passeportvacances.com\www\tops.cfm

SQL

SELECT s.suggestionLodg_id, s.TitreMenu_en AS LodgNomMenu, s.Titre_en AS LodgNom FROM SuggestionLodging s WITH (NOLOCK) Inner Join topsjctSUGGESTIONLodging t WITH(NOLOCK) On s.suggestionLodg_id = t.suggestionLodg_id WHERE t.top_id = 1035 ORDER BY Ordre asc

getEcomBillet

6.49 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

rechBigBox

0.496 ms

passeportvacances

C:\sites\passeportvacances.com\www\inc\module\big_box_vertical.cfm

SQL

Select * From ( SELECT distinct BigBox.BigBox_ID, BigBox.Titre_en AS TitreBigBox, BigBox.Url_en AS Url, BigBox.UrlExterne_en as UrlExterne, BigBox.DateDebut, BigBox.DateFin, BigBox.AutoPromo FROM BigBox WHERE BigBox.Actif = 1 AND BigBox.PhotoActive2 = 1 AND (getdate() BETWEEN BigBox.DateDebut AND BigBox.DateFin) ) as a ORDER BY AutoPromo, NewID()

rechBigBoxSorted

0.091 ms

C:\sites\passeportvacances.com\www\inc\module\big_box_vertical.cfm

SQL

SELECT * FROM rechBigBox Where AutoPromo = 0

rechBigBoxSortedAutoPromo

0.055 ms

C:\sites\passeportvacances.com\www\inc\module\big_box_vertical.cfm

SQL

SELECT * FROM rechBigBox Where AutoPromo = 1

getEcomBillet

6.6 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.48 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.55 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

7.12 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.42 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.37 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.46 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.53 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.56 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.5 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.45 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

6.49 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.275 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Agrotourism in Quebec' or titre_fr = N'Agrotourism in Quebec'

getEcomBillet

6.66 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.398 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Amusement centers' or titre_fr = N'Amusement centers'

getEcomBillet

6.59 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.374 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Cruises' or titre_fr = N'Cruises'

getEcomBillet

6.72 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.42 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Family activities' or titre_fr = N'Family activities'

getEcomBillet

6.71 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.46 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Festivals & Shows' or titre_fr = N'Festivals & Shows'

getEcomBillet

6.65 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.405 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Indigenous Traditions & Cultures' or titre_fr = N'Indigenous Traditions & Cultures'

getEcomBillet

6.71 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.396 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Mountain biking in Quebec' or titre_fr = N'Mountain biking in Quebec'

getEcomBillet

6.61 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.447 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Museums ' or titre_fr = N'Museums '

getEcomBillet

6.6 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.356 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'National & Regional Parks of Quebec' or titre_fr = N'National & Regional Parks of Quebec'

getEcomBillet

6.55 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.317 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Outdoor Activities' or titre_fr = N'Outdoor Activities'

getEcomBillet

6.49 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.313 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Promotions & Coupons' or titre_fr = N'Promotions & Coupons'

getEcomBillet

6.48 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.397 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Spa & Retreat' or titre_fr = N'Spa & Retreat'

getEcomBillet

6.43 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.291 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vineyards and Cideries of Quebec' or titre_fr = N'Vineyards and Cideries of Quebec'

getEcomBillet

6.52 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.331 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Water Parks & Beaches' or titre_fr = N'Water Parks & Beaches'

getEcomBillet

6.48 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getNM

0.387 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

286

SQL

Select titre_en as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Zoos & Amusement Parks - Aquariums' or titre_fr = N'Zoos & Amusement Parks - Aquariums'

getEcomBillet

5.68 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

getEcomBillet

5.86 ms

passeportvacances

C:\sites\passeportvacances.com\www\partage\FIRST1.cfm

340

SQL

Select billet_id, link_en as lnk From billet Where link_fr = 'hotel-ambassadeur-quebec-city'

track

1.07 ms

passeportvacancesLogs

C:\sites\passeportvacances.com\www\Application.cfc

1170

SQL

Insert Into tracking (isBot, trackDate, trackDateClean, query_string, page, http_referer, remoteIP, browser, path_info, userID, formStruct, processingTime, request_url, siteName) Values (0, GetDate(), CONVERT(varchar, GetDate(), 102), '/hotel-ambassadeur-quebec-city', '', '', '216.73.216.198', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 0, '', 1079, 'https://quebecattractions.ca:443/hotel-ambassadeur-quebec-city', 'QA')