Pro AV Catalog

Search our catalog

Search for a specific product quickly and easily

Sponsors
Da-Lite Screen Company, Inc. ClearOne Eiki International, Inc Sony Professional Solutions of America Crestron Electronics, Inc. Chief Audio Visual Furniture International Inc.


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


Execution Time

Total Time Avg Time Count Template
314 ms 314 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/avcat/CTL9166/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
295 ms 295 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
188 ms 188 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfm
102 ms 102 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/categories.cfm
50 ms 50 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav-treatment.cfm
49 ms 49 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/featured.cfm
44 ms 44 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
29 ms 29 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/avcat/CTL9166/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
27 ms 27 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getCategoriesJSONToQuery() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
21 ms 21 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfm
12 ms 12 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfm
10 ms 10 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogLevel(9166) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
9 ms 9 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | qIDFind(9166) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSession(9166, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
7 ms 7 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
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeatured() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | checkIsNomad(9166) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getMRCOptions(9166) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getTreatmentOptions([complex value], 9166) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
6 ms 6 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/application-session.cfc | handleSessionMRC(9166, MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogDetailMRC(9166) ] 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 | getFeaturedDetail(203177) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203198) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203202) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(203255) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getFeaturedDetail(300113) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133883) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133884) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133885) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133886) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133889) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133890) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133893) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133894) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133895) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133896) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/home/home.cfc | getTierTwos(133898) ] 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(203130) ] 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(203177) ] 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(203198) ] 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(203202) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getCatalog(9166) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.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 | 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(133888) ] 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(133891) ] 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(133892) ] 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/topnav/mans.cfc | getFeaturedDetail(203122) ] 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(203603) ] 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(207407) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | checkUserAgent() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | handleReturnToURL(9166) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | getBasicUserInfo() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeatured() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
2 ms 2 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-css-caller.cfm
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 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 - Tele-Measurements, Inc.) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.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 | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
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 | getCatalogType(9166) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getIsLoggedIn(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getMarketID(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getUserID(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | makeMetaDescription(The most complete audio visual equipment, AV service providers directory and industry resource center including AV equipment, installations, dealers, rentals, service providers, case studies, news and more!) ] 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 Visual Equipment, AV Service Providers Directory and Resource Center - Tele-Measurements, Inc.) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getCatalogID(/avcat/CTL9166/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(9166) ] 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 | createDynamicListArray(9166) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | deleteListArray(9166) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | getCatalogType(9166) ] 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/CTL9166/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/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/CTL9166/index-bottom.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/CTL9166/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-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/base-javascript-caller.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
352 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:30.030
			SELECT		*
			FROM		SESSION_BROWSER_EXCLUDE
		
MasterQ (Datasource=Ava_Fenster, Time=1ms, Records=163, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:02:30.030
			SELECT	CATALOG_ID,
					Catalog_Option_Int
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'Design_Style'
		
LOCAL.CHECKNOMAD (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:02:30.030
			SELECT	CATALOG_ID
			FROM	MasterQ
			WHERE	CATALOG_ID = ?
					AND Catalog_Option_Int = 2
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9166

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=8767, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:02:30.030
			SELECT	Catalog.Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Catalog
		
LOCAL.R (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:02:30.030
			SELECT	Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	[LOCAL].Q
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9166

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

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=8765, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:02:30.030
			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:30.030
				SELECT	Catalog_Option_Char
				FROM	VARIABLES.Q
				WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9166

LOCAL.MasterGetCatalogDetailMRC (Datasource=Ava_Fenster, Time=0ms, Records=168, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:02:30.030
			{ 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:30.030
	     	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) = 9166

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

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:30.030
			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

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:30.030
			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

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:30.030
			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:30.030
			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) = 203603

LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:30.030
			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

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:30.030
			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) = 207407

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:02:30.030
			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) = 203198

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

Q (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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) = 203198

Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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) = 300113

LOCAL.TierOnes (Datasource=Ava_Fenster, Time=5ms, Records=16) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			SELECT		DISTINCT
						TIER1_ID ,
						
						
							TIER1_NAME ,
							UPPER(TIER1_NAME) AS OrderName
						
						
			FROM		VARIABLES.GetCategories
			ORDER BY	OrderName ASC
		
LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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:30.030
			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:30.030
			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=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=4ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=4ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\home\home.cfc @ 15:02:30.030
			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:30.030
			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:30.030
			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:30.030
			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=5ms, Records=245) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base.cfc @ 15:02:30.030
			SELECT 		Country_Code_ID ,
						Country_Abbr , 
						Country
			FROM 		Country_Code
			ORDER BY 	Country
		


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  9166    
    
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\CTL9166\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=en-us,en-gb,en;q=0.7,*;q=0.3
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=www.av-iq.com
PATH_INFO=/avcat/CTL9166/index.cfm
PATH_TRANSLATED=E:\inetpub\wwwroot\avcatalogs\avcat\CTL9166\index.cfm
QUERY_STRING=
REMOTE_ADDR=54.196.223.42
REMOTE_HOST=54.196.223.42
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/avcat/CTL9166/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=39318130
CFTOKEN=db01305f8e9d60e9-0EC1965F-5056-A165-541A678DC03B0011
USERINFOMRC=0,0
Session Variables:
opts=Struct (41)
sessionid=FC10A8A59312E70EB8AB4EE5C60DC750.catalogs
urltoken=CFID=39318130&CFTOKEN=db01305f8e9d60e9-0EC1965F-5056-A165-541A678DC03B0011&jsessionid=FC10A8A59312E70EB8AB4EE5C60DC750.catalogs
userinfo=Struct (6)
userinfomrc=Struct (13)
userinforrcpvd=Struct (0)
Debug Rendering Time: 97 ms