Pro AV Catalog

Search our catalog

Search for a specific product quickly and easily

Sponsors
Polycom, Inc. Grass Valley, Inc. ClearOne ELMO USA Corp. Eiki International, Inc. Main JBL Professional Christie Chief Sony Professional Solutions of America Shure Incorporated Crestron Electronics, Inc. Draper, Inc.
RSS FEED
© 2015 Audio-Video Corporation. All Rights Reserved.
Web Site Design by: Spiral Design Studio


Debugging Information
ColdFusion Server Enterprise 10,0,19,298511
Template /avcat/ctl1302/index.cfm
Time Stamp 23-Jun-17 03:02 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.198.147.79
Host Name 54.198.147.79


Execution Time

Total Time Avg Time Count Template
404 ms 404 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/avcat/ctl1302/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
393 ms 393 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
265 ms 265 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfm
135 ms 135 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/featured.cfm
86 ms 86 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/categories.cfm
63 ms 63 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav-treatment.cfm
57 ms 57 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
34 ms 34 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getCategoriesJSONToQuery() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
25 ms 25 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfm
22 ms 22 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/avcat/ctl1302/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
20 ms 20 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203255) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
19 ms 19 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203061) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
15 ms 15 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203107) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
15 ms 15 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203411) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
12 ms 12 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeatured() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
11 ms 11 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203202) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
11 ms 11 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfm
10 ms 10 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | qIDFind(1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
10 ms 10 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogLevel(1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSession(1302, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203348) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | getCountryOptions(Select Country) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getMRCOptions(1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getTreatmentOptions([complex value], 1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogDetailMRC(1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierOnes() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203107) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203348) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203550) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSessionMRC(1302, MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | checkShowCaseStudies(1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203122) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203130) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203177) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133883) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133884) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133885) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133886) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133887) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133893) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133894) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133895) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133896) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133897) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133898) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203061) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203202) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203411) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | checkUserAgent() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203056) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203099) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(204646) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133888) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133889) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133890) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133891) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133892) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203056) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203099) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203177) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(204646) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | handleReturnToURL(1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
2 ms 2 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products.cfm
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | makeMetaKeywords(Audio-Video Corporation audio visual equipment AV services providers directory resource installations dealers rentals 3D cameras displays projectors screens mounts video production presentation systems content delivery digital signage test measurement signal management furniture consoles media manufacturers) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getCatalog(1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | createDynamicListArray(1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | getBotWords() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onSessionStart() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | getBasicUserInfo() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedForDealer() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-css-caller.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-javascript-caller.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products-content.cfm
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | makeMetaDescription(Audio-Video Corporation | Audio-Video Corporation has remained dedicated to its foundation of character, integrity, quality and client commitment for over half a century. These core values are the cornerstones which enable us to provide unparalleled client support and technical innovation.) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | makeMetaTitle(Audio-Video Corporation | Audio Visual Equipment | AV Services | Audio Video Installations) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | checkIsNomad(1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getCatalogID(/avcat/ctl1302/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getLanguageID(en) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleLanguage(1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleOldDomain(1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | setCurrentCatID([complex value]) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | deleteListArray(1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | getCatalogType(1302) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | startSession() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateReturnToURL(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateUserCookie(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestEnd(/avcat/ctl1302/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getExclusionKeyList() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base.cfc | createFacebookMetaData([complex value]) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | getStateOptions(Select State, ) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/CTL1302/index-bottom.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/CTL1302/index-top.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-bad-css.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-footer-nb-page.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-footer-pardot-doubleclick.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-google-analytics-code.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-header-nb-page.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/zip-modal.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/exitmessage/exitmessage.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/welcome-treatment.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/search.cfm
8 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
435 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

LOCAL.Q (Datasource=Catalog_Sessions, Time=0ms, Records=48, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application.cfc @ 15:02:08.008
			SELECT		*
			FROM		SESSION_BROWSER_EXCLUDE
		
LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=8955, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:02:08.008
			SELECT	Catalog.Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Catalog
		
LOCAL.R (Datasource=Ava_Fenster, Time=5ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:02:08.008
			SELECT	Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	[LOCAL].Q
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1302

LOCAL.GetALLMRCSAndOptions (Datasource=Ava_Fenster, Time=0ms, Records=152, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:02:08.008
			{ CALL GetALLMRCSAndOptions() }
		
LOCAL.R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:02:08.008
			SELECT	*
			FROM	[LOCAL].GetALLMRCSAndOptions
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1302

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=8953, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:02:08.008
			SELECT	Catalog_ID,
					Catalog_Option_Char
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'level'
		
R (Datasource=Ava_Fenster, Time=5ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:02:08.008
				SELECT	Catalog_Option_Char
				FROM	VARIABLES.Q
				WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1302

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:02:08.008
	
			DECLARE @Catalog_ID int = ?
			DECLARE @ShowCaseStudyLink bit = (	
		       	SELECT 
					ShowCaseStudyLink = 
						CASE
                           	WHEN CO.Catalog_Option_Bit IS NULL OR CO.Catalog_Option_Bit = 0 OR CO.Catalog_Option_Bit = '' THEN 1
                           	ELSE 0
	                    END
				FROM 
					dbo.[CATALOG] AS C
					LEFT OUTER JOIN CATALOG_OPTIONS AS CO
	                    ON CO.Catalog_ID = C.Catalog_ID
                        	AND CO.Option_ID = 'DisableCaseStudies'
				WHERE 
					EXISTS (
	                    SELECT 
	                    	*
    	                FROM 
    	                	dbo.[Profile] AS P
						WHERE 
                           P.Publish = 1 
                           AND  P.Active = 1
                           AND P.Company_ID = C.Catalog_Company_ID
					)
					AND EXISTS (
	                    SELECT 
	                    	* 
	                    FROM 
	                    	COMPANY_CLASSIFICATION AS CC
	                    WHERE 
                           CC.Company_Type_ID = 'Reseller'
                           AND CC.Company_ID = C.Catalog_Company_ID
					)
					AND C.Catalog_ID = @Catalog_ID 
			)
			SELECT 
				ShowCaseStudyLink = 
					CASE 
                    	WHEN @ShowCaseStudyLink IS NULL OR @ShowCaseStudyLink = '' OR @ShowCaseStudyLink = 0 THEN 0 
	                    ELSE 1 
					END
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1302

LOCAL.MasterGetCatalogDetailMRC (Datasource=Ava_Fenster, Time=0ms, Records=151, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:02:08.008
			{ CALL GetCatalogDetailALL_MRC }
		
LOCAL.R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:02:08.008
	     	SELECT	CATALOG_ADDRESS1 ,
					CATALOG_ADDRESS2 ,
					CATALOG_ADDRESS3 ,
					CATALOG_CITY ,
					CATALOG_COMPANY_ID ,
					CATALOG_COUNTRY ,
					CATALOG_DISPLAY_NAME ,
					CATALOG_EMAIL_ADDRESS ,
					CATALOG_ID ,
					CATALOG_PHONE ,
					CATALOG_POSTCODE ,
					CATALOG_STATE_PROVINCE ,
					CATALOG_TYPE_ID ,
					CATALOG_URL ,
					CATALOG_URL_ID ,
					CATEGORY_TREE_ID ,
					COMPANY_DESCRIPTION ,
					CURRENCY_ID	 ,
					MARKET_ID ,
					PROFILE_ID ,
					VISION_IMPORT_ID
			FROM	[LOCAL].MasterGetCatalogDetailMRC
			WHERE	CATALOG_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1302

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=12, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:08.008
			{ CALL GETAds (
				? ,
				'groupA' ,
				'0' ,
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1302

LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:08.008
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203550

LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:08.008
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203107

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:08.008
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203099

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:08.008
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 204646

LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:08.008
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203348

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:08.008
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203061

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:08.008
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203202

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:08.008
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203411

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:08.008
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203056

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:08.008
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203177

Q (Datasource=Ava_Fenster, Time=11ms, Records=12) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:08.008
			{ CALL GETAds (
				? ,
				'groupA',
				'0',
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1302

Q (Datasource=Ava_Fenster, Time=14ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:08.008
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203107

Q (Datasource=Ava_Fenster, Time=14ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:08.008
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203411

Q (Datasource=Ava_Fenster, Time=19ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203255

Q (Datasource=Ava_Fenster, Time=18ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203061

Q (Datasource=Ava_Fenster, Time=9ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203202

Q (Datasource=Ava_Fenster, Time=5ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203348

Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 204646

Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203122

Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203177

Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203056

Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203130

Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203099

LOCAL.TierOnes (Datasource=Ava_Fenster, Time=4ms, Records=16) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						TIER1_ID ,
						
						
							TIER1_NAME ,
							UPPER(TIER1_NAME) AS OrderName
						
						
			FROM		VARIABLES.GetCategories
			ORDER BY	OrderName ASC
		
LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133883

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133884

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133885

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133886

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133887

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133888

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133889

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133890

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133891

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133892

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133893

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133894

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133895

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133896

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133897

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:09.009
			SELECT		DISTINCT
						Tier2_ID ,
						
						
							TIER2_NAME ,
						
						Tier2_URL
			FROM		VARIABLES.GetCategories
			WHERE		Tier1_ID = ?
			ORDER BY	CATEGORYRANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133898

LOCAL.GetCountries (Datasource=Ava_Fenster, Time=4ms, Records=244) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base.cfc @ 15:02:09.009
			SELECT 		Country_Code_ID ,
						Country_Abbr , 
						Country
			FROM 		Country_Code
			ORDER BY 	Country
		


Stored Procedures

GetCatalogDetail (Datasource=Ava_Fenster, Time=0ms) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-go.cfc @ 15:02:08.008

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  1302    
    
resultsets
nameresultset
 LOCAL.Q  1


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\avcatalogs\avcat\CTL1302\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www.av-iq.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
LOCAL_ADDR=audiovisual.cbcitelecom.com
PATH_INFO=
PATH_TRANSLATED=E:\inetpub\wwwroot\avcatalogs\avcat\CTL1302\index.cfm
QUERY_STRING=adid=694777
REMOTE_ADDR=54.198.147.79
REMOTE_HOST=54.198.147.79
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/avcat/ctl1302/index.cfm
SERVER_NAME=www.av-iq.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=
Cookie Variables:
CFID=297527203
CFTOKEN=129e9c8b08fd77c8-5F502CB8-5056-A129-76121B47D14D407C
USERINFOMRC=0,0
Session Variables:
opts=Struct (42)
sessionid=3D9CCE1362845CFBCFC92B63F89B7ECD.cfusion
urltoken=CFID=297527203&CFTOKEN=129e9c8b08fd77c8-5F502CB8-5056-A129-76121B47D14D407C&jsessionid=3D9CCE1362845CFBCFC92B63F89B7ECD.cfusion
userinfo=Struct (6)
userinfomrc=Struct (13)
userinforrcpvd=Struct (0)
URL Parameters:
adid=694777
Debug Rendering Time: 69 ms