Page d'inscription et Incrivez-vous Redirect to 6811-sheet-roussillon-archeology-museum.html

Inscrivez-vous par courriel ou Facebook

(*) Mandatory

Pr�nom* Votre adresse courriel* Cr�ez un mot de passe*

Nom* Cellulaire Pour recevoir vos rabais par SMS Confirmez votre mot de passe*

R�gion*

J'accepte les conditions d'utilisation et la politique de confidentialit�. Se souvenir de moi Abonnez-vous � notre infolettre et doublez vos chances de gagner notre concours - vous serez automatiquement inscrit!

En vous inscrivant, vous approuvez les termes et conditions de Passeport Vacances et acceptez de recevoir nos courriels sur les offres et promotions Passeport Vacances. Vous pouvez vous d�sinscrire ou changer vos pr�f�rences courriel en tout temps.

Total (ms)

Load (ms)

App (ms)

Query (ms)

Count

Average (ms)

Template

Order

55.6

0.004

45.3

10.2

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

15.7

0.004

14.5

1.12

C:\sites\passeportvacances.com\www\10_100.cfm

531.1

10.6

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

10.1

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

921.7

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

37.2

9.31

C:\sites\passeportvacances.com\www\10_100.cfm$VURL2

8.21

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

7.43

0.005

6.85

0.578

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

144.9

1.59

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

1.59

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

0.709

0.003

0.706

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

0.207

17.8

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

0.194

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

0.126

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

5.95

0.119

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

9.91

0.107

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

0.308

0.102

C:\sites\passeportvacances.com\www\10_100.cfm$PREPAREURLSTRING

0.388

0.077

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

0.047

0.006

0.041

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

0.107

0.035

C:\sites\passeportvacances.com\www\10_100.cfm$REPLACESITEVARS

0.034

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

0.021

0.001

1417.4

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

0.017

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

0.019

0.002

0.016

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

0.015

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

0.011

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

0.075

0.009

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

0.006

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

0.006

C:\sites\passeportvacances.com\www\10_100.cfm$ANTISPAMINIT

0.012

0.006

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

0.004

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

0.009

0.004

C:\sites\passeportvacances.com\www\10_100.cfm$ANTISPAMMONTRERCHAMPS

0.002

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

0.005

20.9

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

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

Template

Line

Scope

Var

Count

C:\sites\passeportvacances.com\www\10_100.cfm

variables

ERREURFORMINSCRIPTION

C:\sites\passeportvacances.com\www\10_100.cfm

variables

ERREURFORMCONNEXION

C:\sites\passeportvacances.com\www\10_100.cfm

397

variables

GetConcours

C:\sites\passeportvacances.com\www\10_100.cfm

397

variables

cfquery

C:\sites\passeportvacances.com\www\10_100.cfm

403

variables

GETCONCOURS

C:\sites\passeportvacances.com\www\10_100.cfm

406

variables

GETCONCOURS

C:\sites\passeportvacances.com\www\10_100.cfm

408

variables

GETCONCOURS

C:\sites\passeportvacances.com\www\10_100.cfm

410

variables

GETCONCOURS

C:\sites\passeportvacances.com\www\10_100.cfm

412

variables

GETCONCOURS

C:\sites\passeportvacances.com\www\10_100.cfm

415

variables

GETCONCOURS

C:\sites\passeportvacances.com\www\10_100.cfm

418

variables

GETCONCOURS

C:\sites\passeportvacances.com\www\10_100.cfm

423

variables

ERREURFORMINSCRIPTION

C:\sites\passeportvacances.com\www\10_100.cfm

462

variables

cfquery

C:\sites\passeportvacances.com\www\10_100.cfm

462

variables

getR

C:\sites\passeportvacances.com\www\10_100.cfm

502

variables

ERREURFORMINSCRIPTION

C:\sites\passeportvacances.com\www\10_100.cfm

505

variables

ERREURFORMINSCRIPTION

C:\sites\passeportvacances.com\www\10_100.cfm

509

variables

ERREURFORMINSCRIPTION

C:\sites\passeportvacances.com\www\10_100.cfm

513

variables

ERREURFORMINSCRIPTION

C:\sites\passeportvacances.com\www\10_100.cfm

516

variables

ERREURFORMINSCRIPTION

C:\sites\passeportvacances.com\www\10_100.cfm

519

variables

ERREURFORMINSCRIPTION

C:\sites\passeportvacances.com\www\10_100.cfm

524

variables

ERREURFORMINSCRIPTION

C:\sites\passeportvacances.com\www\10_100.cfm

526

variables

getR

C:\sites\passeportvacances.com\www\10_100.cfm

527

query

REG_ID

C:\sites\passeportvacances.com\www\10_100.cfm

527

query

NOM_FR

C:\sites\passeportvacances.com\www\10_100.cfm

582

variables

ERREURFORMCONNEXION

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

401

variables

FIRST2CHARGE

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

443

variables

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

452

variables

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

453

variables

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

518

variables

cfquery

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

539

variables

cfquery

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

615

variables

OBJDATE

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

619

variables

BASEHREF

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

648

variables

cflock

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

651

variables

rewritingStruct

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

652

variables

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

652

variables

REWRITINGSTRUCT

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

654

variables

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

656

variables

REWRITINGSTRUCT

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

657

variables

REWRITINGSTRUCT

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

659

variables

REWRITINGSTRUCT

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

660

variables

REWRITINGSTRUCT

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

663

variables

REWRITINGSTRUCT

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

673

variables

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

677

variables

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

681

variables

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

925

variables

cfquery

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

936

variables

cfquery

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

947

variables

cfquery

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

962

variables

cfquery

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

1105

variables

action

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

1133

variables

ACTION

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

1168

variables

ISBOT

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

1172

variables

ISBOT

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

1173

variables

cfquery

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

variables

tempRegionID

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

variables

TEMPREGIONID

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

variables

TEMPREGIONID

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

variables

rechLeaderboard

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

variables

cfquery

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

variables

SUFFIX

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

variables

RECHLEADERBOARD

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

variables

rechLeaderboard

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

query

LEADERBOARD_ID

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

variables

SUFFIX

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

variables

IMGEXT

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

query

LEADERBOARD_ID

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

query

TITRELEADERBOARD

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

variables

RECHLEADERBOARD

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

variables

IMGEXT

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

query

LEADERBOARD_ID

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

query

URLEXTERNE

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

variables

SUFFIX

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

variables

RECHLEADERBOARD

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

variables

SECTION

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

variables

SECTION

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

variables

LINKACTIFF

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

variables

LINKACTIFF

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

variables

rechThemeMenu

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

query

SUGGESTIONCAT_ID

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

query

THEMENOMMENU

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

query

THEMENOMMENU

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

query

SUGGESTIONCAT_ID

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

variables

RECHLODGINGMENU

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

variables

rechLodgingMenu

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

query

THEMENOMLOGMENU

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

query

SUGGESTIONLODG_ID

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

variables

LINKACTIFF

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

variables

LINKACTIFF

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

variables

rechRegionMenu

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

101

query

REGIONNOM

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

101

query

REGION_ID

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

107

variables

RECHREGIONMENU

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

109

variables

rechSubRegionMenu

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

109

variables

cfquery

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

111

variables

rechSubRegionMenu

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

114

variables

RECHSUBREGIONMENU

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

323

variables

ADDPAGE

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

326

variables

ADDPAGE

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

340

variables

EXTRASTRMETA

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

346

variables

EXTRASTRMETA2

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

357

variables

EXTRASTRMETA

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

371

variables

EXTRASTRMETA2

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

371

variables

EXTRASTRMETA

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

371

variables

ADDPAGE

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

399

variables

EXTRASTRMETA

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

399

variables

ADDPAGE

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

406

variables

BASEHREF

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

408

variables

CURRENTPAGEEN

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

409

variables

CURRENTPAGEFR

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

414

variables

CURRENTPAGELANG

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

414

variables

CURRENTPAGEFR

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

417

variables

BASEHREF

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

418

variables

BASEHREF

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

418

variables

BASEHREFCLEAN

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

423

variables

BASEHREF

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

430

variables

BASEHREF

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

443

variables

BASEHREF

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

444

variables

BASEHREF

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

474

variables

BASEHREF

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

475

variables

CURRENTPAGEEN

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

477

variables

BASEHREF

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

478

variables

CURRENTPAGEEN

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

612

variables

rechRegionMenu

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

612

variables

cfquery

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

618

variables

cfquery

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

618

variables

rechThemeMenu

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

624

variables

cfquery

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

624

variables

rechLodgingMenu

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

638

variables

RECHLODGINGMENU

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

644

variables

rechLodgingMenu

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

646

query

SUGGESTIONLODG_ID

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

646

query

THEMENOMLOGMENU

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

674

variables

LINKACTIFF

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

678

variables

LINKACTIFF

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

703

variables

rechRegionMenu

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

706

query

REGIONNOM

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

706

query

REGION_ID

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

712

variables

RECHREGIONMENU

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

714

variables

rechSubRegionMenu

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

714

variables

cfquery

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

716

variables

rechSubRegionMenu

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

719

variables

RECHSUBREGIONMENU

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

730

variables

rechThemeMenu

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

732

query

SUGGESTIONCAT_ID

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

732

query

THEMENOM

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

798

variables

CURRENTPAGEEN

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

926

variables

CURRENTPAGEEN

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

942

variables

BASEHREF

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

1043

variables

CURRENTPAGEEN

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

1056

variables

rechThemeMenu

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

1057

query

THEMENOM

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

1057

query

SUGGESTIONCAT_ID

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

235

query

regionNom

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

255

query

REGIONNOM

104

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

256

variables

cfquery

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

269

query

themeNom

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

289

query

THEMENOM

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

290

variables

cfquery

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

349

variables

cfquery

147

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

367

arguments

146

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

374

variables

cfquery

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

419

arguments

216

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

467

variables

cfquery

Name

Open Connections

Max Connections

passeportvacances

100

passeportvacancesLogs

100

Name

Records

Time

Usage

Datasource

Source

Line

Cached

findPage

0.469 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) = 'inscription'

Query column usage
None of the columns are used

findPage

0.373 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) = 'inscription'

Query column usage
None of the columns are used

getAR

0.762 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 = 'inscription.html' or link_en = 'inscription.html')

Query column usage
None of the columns are used

getTops

0.417 ms

passeportvacances

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

930

SQL

Select top_id From tops WITH (NOLOCK) Where actif = 1 and (link_fr = 'inscription.html' or link_en = 'inscription.html')

Query column usage
None of the columns are used

getBlog

0.331 ms

passeportvacances

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

941

SQL

Select blog_id From blog WITH (NOLOCK) Where actif = 1 and (link_fr = 'inscription.html' or link_en = 'inscription.html')

Query column usage
None of the columns are used

getEcomBillet

6.91 ms

passeportvacances

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

952

SQL

Select billet_id From billet WITH (NOLOCK) Where actif = 1 and (link_fr = 'inscription.html' or link_en = 'inscription.html')

Query column usage
None of the columns are used

getEcomBillet

9.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 = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

9.86 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

8.23 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechRegionMenu

0.823 ms

100%

passeportvacances

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

612

SQL

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

Query column usage
All columns are used

rechThemeMenu

0.707 ms

100%

passeportvacances

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

618

SQL

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

Query column usage
All columns are used

rechLodgingMenu

0.678 ms

66%

passeportvacances

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

624

SQL

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

Query column usage
the following columns are NOT used:

ThemeNomLog

getEcomBillet

9.09 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

11.6 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletLodg

0.5 ms

66%

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

Query column usage
the following columns are NOT used:

Nom_en

getEcomBillet

9.87 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletLodg

0.402 ms

66%

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

Query column usage
the following columns are NOT used:

Nom_en

getEcomBillet

10.8 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletLodg

0.368 ms

66%

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

Query column usage
the following columns are NOT used:

Nom_en

getEcomBillet

9.84 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletLodg

0.368 ms

66%

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

Query column usage
the following columns are NOT used:

Nom_en

getEcomBillet

8.61 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletLodg

0.438 ms

66%

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

Query column usage
the following columns are NOT used:

Nom_en

getEcomBillet

10.7 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletLodg

0.448 ms

66%

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

Query column usage
the following columns are NOT used:

Nom_en

getEcomBillet

7.5 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.305 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.453 ms

100%

passeportvacances

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

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'1000 Îles et région' or nom_fr = N'1000 Îles et région'

Query column usage
All columns are used

rechSubRegionMenu

0.691 ms

passeportvacances

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

709

SQL

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

Query column usage
None of the columns are used

getEcomBillet

6.93 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.324 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.398 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.627 ms

100%

passeportvacances

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

709

SQL

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

Query column usage
All columns are used

getEcomBillet

5.1 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.29 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.419 ms

100%

passeportvacances

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

252

SQL

Select nom_fr 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'

Query column usage
All columns are used

getEcomBillet

6.9 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.24 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.428 ms

100%

passeportvacances

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

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Cantons-de-l''Est' or nom_fr = N'Cantons-de-l''Est'

Query column usage
All columns are used

rechSubRegionMenu

0.613 ms

100%

passeportvacances

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

709

SQL

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

Query column usage
All columns are used

getEcomBillet

6.69 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.301 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.438 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

9.02 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.352 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.434 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.675 ms

passeportvacances

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

709

SQL

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

Query column usage
None of the columns are used

getEcomBillet

9.73 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.37 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.394 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.828 ms

passeportvacances

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

709

SQL

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

Query column usage
None of the columns are used

getEcomBillet

6.61 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.376 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.499 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.593 ms

passeportvacances

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

709

SQL

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

Query column usage
None of the columns are used

getEcomBillet

10.8 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.474 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.545 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.793 ms

passeportvacances

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

709

SQL

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

Query column usage
None of the columns are used

getEcomBillet

11.1 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.383 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.48 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.769 ms

passeportvacances

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

709

SQL

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

Query column usage
None of the columns are used

getEcomBillet

10.9 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.406 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.465 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.672 ms

100%

passeportvacances

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

709

SQL

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

Query column usage
All columns are used

getEcomBillet

9.88 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.376 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.464 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

11.3 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.962 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

41.4 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

3.59 ms

passeportvacances

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

709

SQL

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

Query column usage
None of the columns are used

getEcomBillet

14 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

1.02 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.511 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.781 ms

passeportvacances

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

709

SQL

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

Query column usage
None of the columns are used

getEcomBillet

10.9 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.6 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.505 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.885 ms

100%

passeportvacances

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

709

SQL

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

Query column usage
All columns are used

getEcomBillet

10.7 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.921 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

3 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

10.9 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.51 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.452 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

9.21 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.985 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

10.7 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

5.42 ms

100%

passeportvacances

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

709

SQL

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

Query column usage
All columns are used

getEcomBillet

19.3 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.671 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.385 ms

100%

passeportvacances

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

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

Query column usage
All columns are used

getEcomBillet

4.93 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.33 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.342 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.578 ms

passeportvacances

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

709

SQL

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

Query column usage
None of the columns are used

getEcomBillet

15.2 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.264 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.342 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.608 ms

100%

passeportvacances

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

709

SQL

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

Query column usage
All columns are used

getEcomBillet

7.84 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.256 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.531 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

6.21 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.276 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.381 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

5.98 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.345 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.336 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.644 ms

100%

passeportvacances

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

709

SQL

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

Query column usage
All columns are used

getEcomBillet

4.83 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.327 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.396 ms

100%

passeportvacances

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

252

SQL

Select nom_fr 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'

Query column usage
All columns are used

getEcomBillet

5.05 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.26 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.391 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

6.35 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.416 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Activités famille' or titre_fr = N'Activités famille'

Query column usage
All columns are used

getEcomBillet

6.29 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.331 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Activités plein air' or titre_fr = N'Activités plein air'

Query column usage
All columns are used

getEcomBillet

4.72 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.328 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Agrotourisme au Québec' or titre_fr = N'Agrotourisme au Québec'

Query column usage
All columns are used

getEcomBillet

9.4 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.424 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

6.98 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.433 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

8.73 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.423 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

8.34 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.438 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

10.7 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.425 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Parcs aquatiques - Plages' or titre_fr = N'Parcs aquatiques - Plages'

Query column usage
All columns are used

getEcomBillet

7 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.442 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Parcs Nationaux et régionaux du Québec' or titre_fr = N'Parcs Nationaux et régionaux du Québec'

Query column usage
All columns are used

getEcomBillet

11.6 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.481 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

7.04 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.491 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

9.41 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.331 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

5.18 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.436 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vélo de montagne au Québec' or titre_fr = N'Vélo de montagne au Québec'

Query column usage
All columns are used

getEcomBillet

7.59 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.52 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vignobles & Cidreries du Québec' or titre_fr = N'Vignobles & Cidreries du Québec'

Query column usage
All columns are used

getEcomBillet

8.81 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.472 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Zoos & Parcs Thématiques - Aquariums' or titre_fr = N'Zoos & Parcs Thématiques - Aquariums'

Query column usage
All columns are used

getEcomBillet

6.13 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

10.6 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

8.64 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

9.12 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

9.05 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

9.75 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

9.43 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

8.93 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

7.24 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

6.77 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

8.6 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

6.68 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

11.2 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechLeaderboard

0.578 ms

66%

passeportvacances

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

SQL

SELECT Leaderboard.Leaderboard_ID, Leaderboard.Titre_fr AS TitreLeaderboard, Leaderboard.Url_fr AS Url, Leaderboard.UrlExterne_fr AS UrlExterne, Leaderboard.DateDebut, Leaderboard.DateFin FROM Leaderboard WHERE Leaderboard.Actif = 1 AND Leaderboard.PhotoActive1 = 1 AND Leaderboard.DateDebut <= getdate() AND Leaderboard.DateFin >= getdate() AND ISNULL(Leaderboard.RegionSeulement,0) = 0 ORDER BY NEWID()

Query column usage
the following columns are NOT used:

DateFin

DateDebut

getEcomBillet

7.48 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.508 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Activités famille' or titre_fr = N'Activités famille'

Query column usage
All columns are used

getEcomBillet

6.26 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.474 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Activités plein air' or titre_fr = N'Activités plein air'

Query column usage
All columns are used

getEcomBillet

9.63 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.484 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Agrotourisme au Québec' or titre_fr = N'Agrotourisme au Québec'

Query column usage
All columns are used

getEcomBillet

8.92 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.507 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

7.54 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.467 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

10.7 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.44 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

9.48 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.496 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

11.3 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.458 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Parcs aquatiques - Plages' or titre_fr = N'Parcs aquatiques - Plages'

Query column usage
All columns are used

getEcomBillet

8.79 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.598 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Parcs Nationaux et régionaux du Québec' or titre_fr = N'Parcs Nationaux et régionaux du Québec'

Query column usage
All columns are used

getEcomBillet

9.79 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.474 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

10 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.446 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

7.58 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.387 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

8.66 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.394 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vélo de montagne au Québec' or titre_fr = N'Vélo de montagne au Québec'

Query column usage
All columns are used

getEcomBillet

8.46 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.366 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vignobles & Cidreries du Québec' or titre_fr = N'Vignobles & Cidreries du Québec'

Query column usage
All columns are used

getEcomBillet

8.65 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.437 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Zoos & Parcs Thématiques - Aquariums' or titre_fr = N'Zoos & Parcs Thématiques - Aquariums'

Query column usage
All columns are used

getEcomBillet

9.18 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletLodg

0.358 ms

66%

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

Query column usage
the following columns are NOT used:

Nom_en

getEcomBillet

9.91 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletLodg

0.34 ms

66%

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

Query column usage
the following columns are NOT used:

Nom_en

getEcomBillet

9.75 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletLodg

0.434 ms

66%

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

Query column usage
the following columns are NOT used:

Nom_en

getEcomBillet

19.4 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletLodg

4.35 ms

66%

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

Query column usage
the following columns are NOT used:

Nom_en

getEcomBillet

9.08 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletLodg

0.357 ms

66%

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

Query column usage
the following columns are NOT used:

Nom_en

getEcomBillet

10.4 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletLodg

0.352 ms

66%

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

Query column usage
the following columns are NOT used:

Nom_en

getEcomBillet

7.95 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.33 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.422 ms

100%

passeportvacances

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

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'1000 Îles et région' or nom_fr = N'1000 Îles et région'

Query column usage
All columns are used

rechSubRegionMenu

0.642 ms

passeportvacances

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

104

SQL

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

Query column usage
None of the columns are used

getEcomBillet

10.7 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

3.49 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.459 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.654 ms

100%

passeportvacances

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

104

SQL

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

Query column usage
All columns are used

getEcomBillet

7.41 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.363 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.397 ms

100%

passeportvacances

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

252

SQL

Select nom_fr 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'

Query column usage
All columns are used

getEcomBillet

10.8 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.481 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.435 ms

100%

passeportvacances

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

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Cantons-de-l''Est' or nom_fr = N'Cantons-de-l''Est'

Query column usage
All columns are used

rechSubRegionMenu

0.683 ms

100%

passeportvacances

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

104

SQL

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

Query column usage
All columns are used

getEcomBillet

9.75 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.376 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.445 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

10.1 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.345 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.438 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.684 ms

passeportvacances

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

104

SQL

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

Query column usage
None of the columns are used

getEcomBillet

10.4 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.408 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.402 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.636 ms

passeportvacances

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

104

SQL

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

Query column usage
None of the columns are used

getEcomBillet

10.4 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.349 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.428 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.548 ms

passeportvacances

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

104

SQL

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

Query column usage
None of the columns are used

getEcomBillet

9.28 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.338 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.438 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.638 ms

passeportvacances

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

104

SQL

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

Query column usage
None of the columns are used

getEcomBillet

6.55 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.369 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.363 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.446 ms

passeportvacances

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

104

SQL

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

Query column usage
None of the columns are used

getEcomBillet

5.51 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.246 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.273 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.418 ms

100%

passeportvacances

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

104

SQL

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

Query column usage
All columns are used

getEcomBillet

4.91 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.311 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.292 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

4.93 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.232 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.268 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.507 ms

passeportvacances

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

104

SQL

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

Query column usage
None of the columns are used

getEcomBillet

6.56 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.252 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.295 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.469 ms

passeportvacances

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

104

SQL

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

Query column usage
None of the columns are used

getEcomBillet

6.37 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.355 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.441 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.565 ms

100%

passeportvacances

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

104

SQL

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

Query column usage
All columns are used

getEcomBillet

7.93 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.357 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.579 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

12.5 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.378 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.512 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

7.49 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.382 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.506 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

1.17 ms

100%

passeportvacances

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

104

SQL

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

Query column usage
All columns are used

getEcomBillet

7.66 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.357 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.413 ms

100%

passeportvacances

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

252

SQL

Select nom_fr as nm From region WITH (NOLOCK) Where nom_en = N'Vieux Montréal & Vieux-Port ' or nom_fr = N'Vieux Montréal & Vieux-Port '

Query column usage
All columns are used

getEcomBillet

10.4 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.4 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.361 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.605 ms

passeportvacances

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

104

SQL

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

Query column usage
None of the columns are used

getEcomBillet

6.79 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.577 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.497 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.769 ms

100%

passeportvacances

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

104

SQL

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

Query column usage
All columns are used

getEcomBillet

10.6 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.362 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.504 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

8.27 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.378 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.423 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

8.58 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.378 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.531 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

rechSubRegionMenu

0.829 ms

100%

passeportvacances

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

104

SQL

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

Query column usage
All columns are used

getEcomBillet

10.3 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.416 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.453 ms

100%

passeportvacances

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

252

SQL

Select nom_fr 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'

Query column usage
All columns are used

getEcomBillet

9.91 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

rechBilletRegion2

0.306 ms

33%

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

Query column usage
the following columns are NOT used:

Nom_en

Region_ID

getNM

0.401 ms

100%

passeportvacances

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

252

SQL

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

Query column usage
All columns are used

getEcomBillet

6.13 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

11.1 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

8.36 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

6.75 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

GetConcours

0.518 ms

33%

passeportvacances

C:\sites\passeportvacances.com\www\10_100.cfm

397

SQL

Select top 1 CONCOURS_ID, Actif, Nom, Intro_fr as ConcoursIntro, Texte_fr as ConcoursTexte, Reglements_fr as ConcoursReglements From concours Where actif = 1 Order by CONCOURS_ID desc

Query column usage
the following columns are NOT used:

ConcoursIntro

Nom

ConcoursReglements

Actif

getR

0.605 ms

66%

passeportvacances

C:\sites\passeportvacances.com\www\10_100.cfm

462

SQL

SELECT region_id as reg_id, nom_fr, nom_en FROM region WITH (NOLOCK) ORDER BY nom_fr

Query column usage
the following columns are NOT used:

nom_en

getEcomBillet

6.72 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

9.3 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

7.38 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

9.24 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

7.72 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

11 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

8.25 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

10.2 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

11.8 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

6.9 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

11.2 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

9.01 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

7.04 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

6.34 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

8.71 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

11.6 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.472 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Activités famille' or titre_fr = N'Activités famille'

Query column usage
All columns are used

getEcomBillet

7.43 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.468 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Activités plein air' or titre_fr = N'Activités plein air'

Query column usage
All columns are used

getEcomBillet

6.95 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.476 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Agrotourisme au Québec' or titre_fr = N'Agrotourisme au Québec'

Query column usage
All columns are used

getEcomBillet

8.35 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.559 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

8.47 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.428 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

7.06 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.387 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

10.8 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.544 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

9.52 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.475 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Parcs aquatiques - Plages' or titre_fr = N'Parcs aquatiques - Plages'

Query column usage
All columns are used

getEcomBillet

10.6 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.434 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Parcs Nationaux et régionaux du Québec' or titre_fr = N'Parcs Nationaux et régionaux du Québec'

Query column usage
All columns are used

getEcomBillet

7.46 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.436 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

5.97 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.411 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

7.3 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.361 ms

100%

passeportvacances

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

286

SQL

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

Query column usage
All columns are used

getEcomBillet

6.38 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.46 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vélo de montagne au Québec' or titre_fr = N'Vélo de montagne au Québec'

Query column usage
All columns are used

getEcomBillet

6.83 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.386 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Vignobles & Cidreries du Québec' or titre_fr = N'Vignobles & Cidreries du Québec'

Query column usage
All columns are used

getEcomBillet

6.52 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getNM

0.361 ms

100%

passeportvacances

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

286

SQL

Select titre_fr as nm From SUGGESTIONCAT WITH (NOLOCK) Where titre_en = N'Zoos & Parcs Thématiques - Aquariums' or titre_fr = N'Zoos & Parcs Thématiques - Aquariums'

Query column usage
All columns are used

getEcomBillet

5.79 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

getEcomBillet

6.61 ms

passeportvacances

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

340

SQL

Select billet_id, link_fr as lnk From billet Where link_en = 'inscription.html'

Query column usage
None of the columns are used

track

8.6 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), '/inscription.html?redirection=6811-sheet-roussillon-archeology-museum.html', '', '', '18.226.159.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', 0, '', 1951, 'https://www.passeportvacances.com:443/inscription.html?redirection=6811-sheet-roussillon-archeology-museum.html', 'PV')

Inscrivez-vous par courriel ou Facebook

CONNECTEZ-VOUS