Crimson AV

Crimson AV - VW4600-Video Wall Mount
Video posted on 09-May-12
Save to Project
Crimson Video Wall Mount
Related Products


Debugging Information
ColdFusion Server Enterprise 10,0,16,293499
Template /AVCat/CTL1642/index.cfm
Time Stamp 04-Aug-15 11:54 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 69.31.20.37
Host Name 69.31.20.37


Execution Time

Total Time Avg Time Count Template
169 ms 169 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/AVCat/CTL1642/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
140 ms 140 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
57 ms 57 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/Showroom.cfm
46 ms 46 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-header.cfm
43 ms 43 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav.cfm
37 ms 37 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
24 ms 24 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfm
20 ms 20 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/AVCat/CTL1642/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
12 ms 12 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomMenu.cfm
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSession(1642, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
8 ms 8 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/ShowroomVideo.cfm
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | qIDFind(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogLevel(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getShowroomOptions(1642, 11413) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getCatalog(11413) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSessionRRC(1642, RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getManufacturer(crimson-av, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | checkIsNomad(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleOldURLs(crimson-av, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogDetailPIN(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203198) ] 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
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203122) ] 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(203130) ] 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(203450) ] 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
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(207407) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contactus/contactus.cfm
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getTreatmentOptions([complex value], 1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.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(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.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/topnav/products.cfm
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getCatalogType(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getPINOptions(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateUserCookie(RRC) ] 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 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-css-caller.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav-region-selector.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products-content.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/search.cfm
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getIsLoggedIn(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getMarketID(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getUserID(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/udf_library.cfc | makeMetaDescription(Crimson AV - Crimson AV - VW4600-Video Wall Mount - AV-iQ) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/udf_library.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/udf_library.cfc | makeMetaTitle(Crimson AV - Crimson AV - VW4600-Video Wall Mount - AV-iQ) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/udf_library.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getCatalogID(/AVCat/CTL1642/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(1642) ] 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(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | deleteListArray(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | getCatalogType(1642) ] 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(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestEnd(/AVCat/CTL1642/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/list/list.cfc | makeListButton(videos, 2380) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/list/list.cfc
0 ms 0 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/prodcomp/prodcomp.cfc | checkLiveSession() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/prodcomp/prodcomp.cfc
0 ms 0 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/prodcomp/prodcomp.cfc | getCatalogType(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/prodcomp/prodcomp.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | clearSessionVars() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setArticle(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setCatID(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setCategoryTree(1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setCompanyID(308533) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setFAS(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setIsDistributor() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setKeyword(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setNewProds(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setNewProdsMonth(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setNewProdsYear(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setNews(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setPageURL(index.cfm?manufacturer=crimson-av) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setProduct(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setProductEmail(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setProductEmailConf(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setProducts(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setRFI(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setSubCatID(0) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setVarLink() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.cfc | setVideo(2380) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/showroom/showroom.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/nomad/base-bad-css.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-bottom-nav.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.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/contactus/countries.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contactus/states.cfm
8 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
198 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

LOCAL.Q (Datasource=Catalog_Sessions, Time=0ms, Records=47, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application.cfc @ 11:54:02.002
			SELECT		*
			FROM		SESSION_BROWSER_EXCLUDE
		
MasterQ (Datasource=Ava_Fenster, Time=1ms, Records=735, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:54:02.002
			SELECT	CATALOG_ID,
					Catalog_Option_Int
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'Design_Style'
		
LOCAL.CHECKNOMAD (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:54:02.002
			SELECT	CATALOG_ID
			FROM	MasterQ
			WHERE	CATALOG_ID = ?
					AND Catalog_Option_Int = 2
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

Q (Datasource=Ava_Fenster, Time=3ms, Records=8851, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:54:02.002
			SELECT	Catalog.Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Catalog
		
R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:54:02.002
			SELECT	Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Q
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=1, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:54:02.002
			{ CALL ctlGetPINOptions(
				?
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

qmlcFind (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 11:54:02.002
			SELECT	Catalog.catalog_id,
					Catalog_type_id
			FROM	Catalog
			WHERE	Catalog_url_id = ?
					AND (Catalog_type_id = 'mcs' OR catalog_type_id = 'mlc')
					AND Market_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = crimson-av
Parameter #2(cf_sql_integer) = 1

Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-go.cfc @ 11:54:02.002
			SELECT	Catalog.catalog_id,
					Catalog_type_id
	        FROM	Catalog
	        WHERE	Catalog_url_id = ?
					AND (Catalog_type_id = 'mcs' OR Catalog_type_id = 'mlc')
					AND Market_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = crimson-av
Parameter #2(cf_sql_integer) = 1

Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:54:02.002
			SELECT	CATALOG.Catalog_ID,
					Catalog.Catalog_Type_ID,
					CATALOG_OPTIONS.Catalog_Option_Char,
					CASE WHEN catalog.catalog_Type_ID = 'MCS' THEN ctlOptionPrem.RFI ELSE ctlOptionBasic.RFI END as RFI,
					CASE WHEN catalog.catalog_Type_ID = 'MCS' THEN ctlOptionPrem.Dealer_Locator ELSE ctlOptionBasic.Dealer_Locator END as Dealer_Locator,
					CASE WHEN catalog.catalog_Type_ID = 'MCS' THEN ctlOptionPrem.Show_MSRP ELSE ctlOptionBasic.Show_MSRP END as Show_MSRP
			FROM	Catalog
					JOIN CATALOG_OPTIONS
						ON CATALOG_OPTIONS.Catalog_ID = CATALOG.Catalog_ID
					LEFT OUTER JOIN ctlOption_MCS ctlOptionPrem
						ON ctlOptionPrem.ctlOwner_ID = CATALOG.Catalog_ID
					LEFT OUTER JOIN ctlOption_MLC ctlOptionBasic
						ON ctlOptionBasic.ctlOwner_ID = CATALOG.Catalog_ID
			WHERE	Catalog.catalog_id = ?
					AND CATALOG_OPTIONS.Option_ID = 'level'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 11413

QMRC (Datasource=Ava_Fenster, Time=2ms, Records=0) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:54:02.002
			SELECT	CATALOG.Catalog_ID,
					ctlOption.RFI,
					ctlOption.Show_MSRP
			FROM	catalog
					JOIN ctlOption_MRC ctlOption
						ON ctlOption.ctlOwner_ID = CATALOG.Catalog_ID
			WHERE	Catalog.catalog_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

Q (Datasource=Ava_Fenster, Time=3ms, Records=8744, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:54:02.002
			SELECT	Catalog_ID,
					Catalog_Option_Char
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'level'
		
R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:54:02.002
				SELECT	Catalog_Option_Char
				FROM	VARIABLES.Q
				WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

MasterGetCatalogDetailPIN (Datasource=Ava_Fenster, Time=0ms, Records=4, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:54:02.002
			{ CALL GetCatalogDetailALL_PIN }
		
LOCAL.R (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 11:54:02.002
	     	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	MasterGetCatalogDetailPIN
			WHERE	CATALOG_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=8, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:54:02.002
			{ CALL GETAds (
				? ,
				'groupK' ,
				'0' ,
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

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

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 11:54:02.002
			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) = 203450

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

Preview_Company_Video (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\ShowroomVideo.cfm @ 11:54:02.002
		select Video_ID, video_type_id, video_start_Date, video_source, video_title, video_description
		from video
		where dbo.VIDEO.Video_ID = ?
		order by Modify_Date desc
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2380

Related_Press_Releases (Datasource=Ava_Fenster, Time=1ms, Records=0) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\ShowroomVideo.cfm @ 11:54:02.002
		SELECT DISTINCT dbo.VIDEO.Video_ID, dbo.PRESS_RELEASE.Press_Release_ID, dbo.PRESS_RELEASE.Title, dbo.VIDEO_COMPANY.Video_Mapping_ID, dbo.VIDEO.Video_Title,
		dbo.PRESS_RELEASE.Company_ID,dbo.PRESS_RELEASE.Press_Release_Date
		FROM  dbo.Press_Release_Market
		INNER JOIN dbo.PRESS_RELEASE ON dbo.Press_Release_Market.Press_Release_ID = dbo.PRESS_RELEASE.Press_Release_ID
		LEFT OUTER JOIN dbo.VIDEO
		INNER JOIN dbo.VIDEO_COMPANY ON dbo.VIDEO.Video_ID = dbo.VIDEO_COMPANY.Video_ID
		INNER JOIN dbo.VIDEO_COMPANY AS VIDEO_COMPANY_1 ON dbo.VIDEO.Video_ID = VIDEO_COMPANY_1.Video_ID ON
		dbo.PRESS_RELEASE.Press_Release_ID = dbo.VIDEO_COMPANY.Video_Mapping_Value
		WHERE dbo.VIDEO_COMPANY.Video_Mapping_ID = 'press_release' AND dbo.VIDEO.Video_ID = ?
		AND VIDEO_COMPANY_1.Video_Mapping_ID = 'marketid'
		AND VIDEO_COMPANY_1.Video_Mapping_Value = ?
		AND dbo.Press_Release_Market.Market_ID = ?
		ORDER BY dbo.PRESS_RELEASE.Press_Release_Date DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2380
Parameter #2(cf_sql_integer) = 1
Parameter #3(cf_sql_integer) = 1

Related_products (Datasource=Ava_Fenster, Time=1ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\showroom\ShowroomVideo.cfm @ 11:54:02.002
		SELECT	DISTINCT VIDEO_COMPANY.Video_ID,
				VIDEO_COMPANY.Video_Mapping_ID,
				VIDEO_COMPANY.Video_Mapping_Value,
				PRODUCT.Model_Number,
				PRODUCT.Product_Display_Name,
				PRODUCT.Manufacturer_ID,
				PRODUCT.Accessory,
				PRODUCT.Product_URL_ID,
				CATALOG.Catalog_URL_ID
		FROM	VIDEO_COMPANY
				INNER JOIN dbo.PRODUCT
					ON  VIDEO_COMPANY.Video_Mapping_Value = dbo.PRODUCT.Product_ID
						AND VIDEO_COMPANY.Video_Mapping_ID = 'product'
						AND PRODUCT.Discontinued_Date IS NULL
				INNER JOIN MANUFACTURER_LINE_MEMBERS
					ON VIDEO_COMPANY.Video_Mapping_Value = MANUFACTURER_LINE_MEMBERS.Product_ID
				INNER JOIN MANUFACTURER_LINE
					ON MANUFACTURER_LINE_MEMBERS.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID
						AND MANUFACTURER_LINE.Market_ID = ?
				INNER JOIN CATALOG
					ON PRODUCT.Manufacturer_ID = CATALOG.Catalog_Company_ID
						AND CATALOG.Market_ID = ?
		WHERE	VIDEO_COMPANY.Video_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
Parameter #2(cf_sql_integer) = 1
Parameter #3(CF_SQL_INTEGER) = 2380


Stored Procedures

GetCatalogDetail (Datasource=Ava_Fenster, Time=4ms) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-go.cfc @ 11:54:02.002

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  11413    
    
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\CTL1642\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=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=TE, keep-alive
HTTP_COOKIE=
HTTP_HOST=www.av-iq.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=E:\inetpub\wwwroot\avcatalogs\avcat\CTL1642\index.cfm
QUERY_STRING=manufacturer=crimson-av&video=2380
REMOTE_ADDR=69.31.20.37
REMOTE_HOST=69.31.20.37
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/AVCat/CTL1642/index.cfm
SERVER_NAME=www.av-iq.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=
Cookie Variables:
CFID=42380957
CFTOKEN=d30812c6c3ca9fee-BE35C967-5056-A129-769BF460ACC236AA
USERINFO=0,0
Session Variables:
opts=Struct (38)
sessionid=01C5A854F0E4F382E35BF1BC56483AFB.cfusion
showroom=Struct (20)
urltoken=CFID=42380957&CFTOKEN=d30812c6c3ca9fee-BE35C967-5056-A129-769BF460ACC236AA&jsessionid=01C5A854F0E4F382E35BF1BC56483AFB.cfusion
userinfo=Struct (17)
userinfomrc=Struct (3)
URL Parameters:
manufacturer=crimson-av
video=2380
Debug Rendering Time: 65 ms