Debugging Information
ColdFusion Server Enterprise 8,0,1,195765
Template /error404.cfm
Time Stamp 20-May-12 09:50 PM
Locale English (US)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 38.107.179.243
Host Name 38.107.179.243

Execution Time

Total Time Avg Time Count Template
313 ms 313 ms 1 \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\Application.cfm
63 ms 63 ms 1 top level \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\lordAndTaylor\error404.cfm
32 ms 8 ms 4 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteSpecificFunctions.cfc | getStoreObj(26) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteSpecificFunctions.cfc
31 ms 16 ms 2 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc | changeScopeString() ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc
31 ms 16 ms 2 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc | crossScriptCheck() ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc
31 ms 10 ms 3 \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\frontEndComponents\specificComponents\b2c\init\userAuthentication\b2cUserAuthenticationSettings.cfm
16 ms 16 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | DBColumnCheck(b2c_store_user_filters) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
16 ms 16 ms 1 \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\frontEndComponents\specificComponents\b2c\init\userAuthentication\userNavigation.cfm
15 ms 15 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | GetActualLanguage() ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
15 ms 15 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | queryToStruct([complex value], banner_placeholder_id) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
15 ms 15 ms 1 \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\frontEndComponents\specificComponents\b2c\init\userAuthentication\createB2CCookie.cfm
15 ms 15 ms 1 \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\frontEndComponents\specificComponents\b2c\init\userAuthentication\userAuthentication.cfm
15 ms 15 ms 1 \\172.16.11.20\ltdev_websites\websites\websiteTags\getXMLDocument.cfm
0 ms 0 ms 2 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\fusionlink\Portcullis.cfc | init([complex value]) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\fusionlink\Portcullis.cfc
0 ms 0 ms 6 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\fusionlink\Portcullis.cfc | isDetected() ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\fusionlink\Portcullis.cfc
0 ms 0 ms 2 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\fusionlink\Portcullis.cfc | scan([complex value], cookie, 38.107.179.243) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\fusionlink\Portcullis.cfc
0 ms 0 ms 2 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\fusionlink\Portcullis.cfc | scan([complex value], form, 38.107.179.243) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\fusionlink\Portcullis.cfc
0 ms 0 ms 2 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\fusionlink\Portcullis.cfc | scan([complex value], url, 38.107.179.243) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\fusionlink\Portcullis.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\b2cV7\shoppingCart.cfc | b2cShoppingCart() ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\b2cV7\shoppingCart.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\error.cfc | disableErrorHandling(true) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\error.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\error.cfc | getError() ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\error.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\error.cfc | setBrowserList(ScanAlert,ia_archiver,Googlebot) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\error.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\error.cfc | setSendFrom(lordandtaylor.icongodev.com@error.com) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\error.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\error.cfc | setSendTo(schan@icongo.com, rvergara@icongo.com) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\error.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\error.cfc | setTemplate(/lordandtaylor/lordandtaylor/cm_template_repository/template_control_files/ErrorTemplate.cfm) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\error.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc | allowScopeChanges() ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc
0 ms 0 ms 2 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc | changeFormString() ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc
0 ms 0 ms 2 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc | changeUrlString() ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc | setAvoidList(/error404.cfm, instore.cfc, false) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc | setAvoidList(/error404.cfm, moneris, false) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc | setAvoidList(/error404.cfm, submitOrder, false) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc | setAvoidList(b2c/shoppingCart/shoppingFinalReview.cfm, false) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc | setAvoidList(userLogin, false) ] from \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\hackerSafe.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | ConvertBrandUrlStringsToIds() ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | ConvertCategoryUrlStringsToIds() ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | DBColumnCheck(banner_placeholders, front_end_variable_name) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | DBColumnCheck(banners, model_id) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 2 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | DBColumnCheck(banners, referrer_id) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | DBColumnCheck(banners, sequence) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | DBColumnCheck(banners, site_key) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | DBColumnCheck(table = banner_item, dsn = lordandtaylor) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | DBColumnCheck(table = banner_store_location, dsn = lordandtaylor) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | b2cXMLParser(eng, global, 26, default, fieldNames/general) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | checkStoreIDUrl(26, lordandtaylor.icongodev.com) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 6 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | distinctArray([complex value]) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 2 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | getEncryptionKey() ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | getHttpString() ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | getHttpString(true) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | queryToStruct([complex value], banner_id) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | saveSessionOnExternalServer() ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | setCookie(VALUE = 26, NAME = lordandtaylor_CookiestoreID, EXPIRES = never) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | setCookie(VALUE = 3391AC6B7746CB564ADFD24A2608A6AD, NAME = lordandtaylor_Cookieukey, EXPIRES = never) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | setCookie(VALUE = eng, NAME = lordandtaylor_CookielanguageID, EXPIRES = never) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | setSiteActualLocale(US, eng) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | urlOrForm(itemCategoryLevel1) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | urlOrForm(itemid) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 2 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc | urlOrForm(url.sectionID, string) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\siteFunctions.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc | Is2TopNavSections() ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc | getCkeyByStoreId(26) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc | getGroupInvironment() ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc | getstoresByGroup(1) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc | getsubscriptionId(1, eng) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\com\b2c\banners\banners.cfc | bulkTrackBannerDb() ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\com\b2c\banners\banners.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\com\b2c\banners\banners.cfc | displayBanners() ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\com\b2c\banners\banners.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\com\b2c\ebay\ebayGateway.cfc | getStoreDetails(3) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\com\b2c\ebay\ebayGateway.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\com\b2c\ebay\ebayGateway.cfc | setDSN(lordandtaylor) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\com\b2c\ebay\ebayGateway.cfc
0 ms 0 ms 1 CFC[ \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\com\b2c\ebay\ebayGateway.cfc | setEbayDSN(icongoEbay) ] from \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\com\b2c\ebay\ebayGateway.cfc
0 ms 0 ms 1 \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\OnRequestEnd.cfm
0 ms 0 ms 1 \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfLib\general.cfm
0 ms 0 ms 1 \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\storeRequestInit.cfm
0 ms 0 ms 1 \\172.16.11.20\ltdev_websites\websites\websiteTags\XmlListToStruct.cfm
31 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
407 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

getStoreCssPath (Datasource=lordandtaylor, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc @ 21:50:17.017
			SELECT 	pathCss,group_id,group_name
			FROM   	b2c_groups
			WHERE 	url like ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %lordandtaylor.icongodev.com|%

getStores (Datasource=lordandtaylor, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc @ 21:50:17.017
			SELECT store_id,url,ckey
			FROM   b2c_stores
			WHERE store_id !=0
			AND group_id =?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

checkstore (Datasource=, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\Application.cfm @ 21:50:17.017
					select 	store_id
					from	QrygetStoreByGroup
					where 	store_id = 26
getStoreByCkeyUrl (Datasource=lordandtaylor, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\functions.cfc @ 21:50:17.017
				SELECT 	store_id
				FROM   	b2c_stores
				WHERE 	store_id = ?
				AND url like ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 26
Parameter #2(CF_SQL_VARCHAR) = %lordandtaylor.icongodev.com|%

getsubscriptionId (Datasource=lordandtaylor, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc @ 21:50:17.017
			SELECT 	 newsletter_category_id
			FROM   	newsletter_categories
			WHERE 	group_id =?
			AND     language_id = ?
			and		active_ind = 'Y'
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_VARCHAR) = eng

getOpenOrders (Datasource=lordandtaylor, Time=0ms, Records=0) in \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\frontEndComponents\specificComponents\b2c\init\userAuthentication\userAuthentication.cfm @ 21:50:17.017
		select order_id from b2c_orders where ukey = 
		?
		and order_status_id = 1
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 14853219

getCkeyByStoreId (Datasource=lordandtaylor, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\lordAndTaylor\cfcLib\store.cfc @ 21:50:17.017
			SELECT 	ckey
			FROM   	b2c_stores
			WHERE 	store_id = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 26

qry_banner_campaign_thresholds (Datasource=lordandtaylor, Time=0ms, Records=0) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\bannersV9.cfc @ 21:50:17.017
			SELECT	bct.banner_placeholder_id
				,	bct.banner_campaign_id
				,	banners.banner_id
			FROM	banner_campaign_thresholds bct
					JOIN banner_placeholders ph ON ph.banner_placeholder_id = bct.banner_placeholder_id
						AND ph.archived = 'N'
					JOIN banners ON banners.banner_placeholder_id = ph.banner_placeholder_id
						AND banners.banner_campaign_id = bct.banner_campaign_id
						AND banners.active_ind = 'Y'
			WHERE	banners.converted_orders >= bct.conversion_threshold
			AND		EXISTS (
				
				SELECT	1
				FROM	banners b
				WHERE	b.banner_campaign_id = banners.banner_campaign_id
				AND		b.banner_placeholder_id = ph.banner_placeholder_id
				AND		b.banner_id <> banners.banner_id
				AND		b.active_ind = 'Y'
				AND	NOT EXISTS (
					
					SELECT	1
					FROM	banners b2
					WHERE	b2.banner_campaign_id = banners.banner_campaign_id
					AND		b2.banner_placeholder_id = ph.banner_placeholder_id
					AND		b2.active_ind = 'Y'
					AND		b2.banner_id <> b.banner_id
					
					
					AND		b.converted_orders >= b2.converted_orders
				)
			)
loc.checkColumns (Datasource=lordandtaylor, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\functions.cfc @ 21:50:17.017
				SELECT
				
					COALESCE(COL_LENGTH('banners','site_key'),0)
				
				as ckeck
loc.checkColumns (Datasource=lordandtaylor, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\functions.cfc @ 21:50:17.017
				SELECT
				
					COALESCE(COL_LENGTH('banners','referrer_id'),0)
				
				as ckeck
loc.checkColumns (Datasource=lordandtaylor, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\functions.cfc @ 21:50:17.017
				SELECT
				
					COALESCE(COL_LENGTH('banners','model_id'),0)
				
				as ckeck
loc.checkColumns (Datasource=lordandtaylor, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\functions.cfc @ 21:50:17.017
				SELECT
				
					COALESCE(COL_LENGTH('banners','sequence'),0)
				
				as ckeck
qry_banners (Datasource=lordandtaylor, Time=0ms, Records=36) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\bannersV9.cfc @ 21:50:17.017
			SELECT	b.banner_id
				,	b.banner_name
				,	b.default_banner_ind
				,	b.alt_tag_message
				,	b.onclick_url
				,	b.onclick_new_window_ind
				,	b.image_map
				,	b.ext
				,	CASE WHEN ISNULL(b.banner_weight,0) = 0 THEN 1 ELSE b.banner_weight END as banner_weight
				,	CAST(b.banner_id AS VARCHAR) + '_1.' + b.ext as source

				
				,	b.banner_placeholder_id
				,	b.language_id
				,	b.store_id
				,	b.member_company_id
				
				,	CASE WHEN ISNULL( b.site_key, '0' ) = '0' THEN 'default' ELSE b.site_key END AS site_key
				
				,	ISNULL(rt.referrer_tag, 0) AS referrer_tag
				
				
				
				,	b.categoryId
				,	b.brand_id
				,	b.keywords
				,	ISNULL( b.country_id, 0 ) as country_id
				
				
				,	isnull(b.model_id, 0) as model_id
								
				
				,	b.banner_key_1

				
				,	b.banner_key_2
				,	b.banner_type_id
				,	CASE
						WHEN b.banner_type_id IN (3,4,5) THEN 1
						ELSE 0
					END	as productDisplay

				
				,	b.banner_tracking
				,	b.track_conversion
				,	b.no_follow_ind

				,	b.banner_campaign_id
				,	b.product_tags
				
				,	isnull(b.sequence, 0) as sequence
				
				,	b.title
				
			FROM	banners b WITH (NOLOCK)
					JOIN banner_placeholders bph WITH (NOLOCK) ON bph.banner_placeholder_id = b.banner_placeholder_id
						AND b.archived = bph.archived
					
						LEFT JOIN referrer_tags rt WITH (NOLOCK) ON rt.referrer_id = b.referrer_id
					
			WHERE	b.archived = 'N'
			AND		b.active_ind = 'Y'
			AND		getdate() between b.start_date and b.end_date
loc.checkColumns (Datasource=lordandtaylor, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\functions.cfc @ 21:50:17.017
				SELECT
				
					COALESCE(COL_LENGTH('banner_placeholders','front_end_variable_name'),0)
				
				as ckeck
qry_placeholders (Datasource=lordandtaylor, Time=0ms, Records=40) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\bannersV9.cfc @ 21:50:17.017
			SELECT	banner_placeholder_id
				,	description_eng
				,	description_fre
				,	width
				,	height
				,	placeholder_tracking
				,	placeholder_type
				,	group_id
				,	CASE WHEN sequence = 0 THEN 100 ELSE sequence END as sequence
				,	has_category_ind
				
				,	ISNULL(front_end_variable_name, banner_placeholder_id) as front_end_variable_name
				
			FROM	banner_placeholders WITH (NOLOCK)
			WHERE	archived = 'N'
loc.checkColumns (Datasource=lordandtaylor, Time=16ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\functions.cfc @ 21:50:17.017
				SELECT
				
					isNull(object_id('b2c_store_user_filters'), 0)
				
				as ckeck
qry_banner_link_tracking (Datasource=lordandtaylor, Time=0ms, Records=0) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\bannersV9.cfc @ 21:50:17.017
			SELECT	banner_link_id
				,	store_id
				,	destination_url
			FROM	banners_link_tracking WITH (NOLOCK)
loc.checkColumns (Datasource=lordandtaylor, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\functions.cfc @ 21:50:17.017
				SELECT
				
					isNull(object_id('banner_item'), 0)
				
				as ckeck
qry_banner_items (Datasource=lordandtaylor, Time=0ms, Records=0) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\bannersV9.cfc @ 21:50:17.017
				SELECT	banner_id
					,	item_id
				FROM	banner_item WITH (NOLOCK)
loc.checkColumns (Datasource=lordandtaylor, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\functions.cfc @ 21:50:17.017
				SELECT
				
					isNull(object_id('banner_store_location'), 0)
				
				as ckeck
qry_banner_store_location (Datasource=lordandtaylor, Time=0ms, Records=36) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\iCongo\common\bannersV9.cfc @ 21:50:17.017
				SELECT	b.banner_id
					,	ISNULL( bsl.store_location_id, 0 ) as store_location_id
				FROM	banners b WITH (NOLOCK)
						LEFT JOIN banner_store_location bsl WITH (NOLOCK)
							ON b.banner_id = bsl.banner_id
						LEFT JOIN banner_placeholders bph WITH (NOLOCK) ON bph.banner_placeholder_id = b.banner_placeholder_id
							AND b.archived = bph.archived
				WHERE	b.archived = 'N'
				AND		b.active_ind = 'Y'
				AND		getdate() between b.start_date and b.end_date
getEbayStoreDetails (Datasource=icongoEbay, Time=0ms, Records=1) in \\172.16.11.20\ltdev_websites\websites\iCongoFramework\com\ebay\ebayGateway.cfc @ 21:50:17.017
			SELECT *
			FROM ebay_stores
			WHERE ebay_store_id = ?
			AND active_ind = 'Y'
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 3

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=\\172.16.11.20\ltdev_websites\websites\lordAndTaylor\lordAndTaylor\error404.cfm
CONTENT_LENGTH=
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,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=GS_visit=1; CFID=228416; LORDANDTAYLOR_COOKIELANGUAGEID=eng; LORDANDTAYLOR_COOKIEUKEY=3391AC6B7746CB564ADFD24A2608A6AD; CFTOKEN=a2fd244fd1b0aa9a-6D110E7F-5056-1B48-718EE3175AF81324; JSESSIONID=1430d8c4ac66bb14be5e7a727b6a684a6359; LORDANDTAYLOR_COOKIESTOREID=26
HTTP_HOST=lordandtaylor.icongodev.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/error404.cfm
PATH_TRANSLATED=\\172.16.11.20\ltdev_websites\websites\lordAndTaylor\lordAndTaylor\error404.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.179.243
REMOTE_HOST=38.107.179.243
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/error404.cfm
SERVER_NAME=lordandtaylor.icongodev.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Cookie Variables:
CFID=228416
CFTOKEN=a2fd244fd1b0aa9a-6D110E7F-5056-1B48-718EE3175AF81324
GS_visit=1
JSESSIONID=1430d8c4ac66bb14be5e7a727b6a684a6359
LORDANDTAYLOR_COOKIELANGUAGEID=eng
LORDANDTAYLOR_COOKIESTOREID=26
LORDANDTAYLOR_COOKIEUKEY=0

Session Variables:
actuallang=eng
b2corder=Struct (5)
brandselected=
currencyid=USD
ipcountry=
loggedind=N
menucount=0
remote_addr=38.107.179.240
sessionid=1430d8c4ac66bb14be5e7a727b6a684a6359
storeid=26
timersearch=Struct (1)
ukey=14853219
urltoken=CFID=228416&CFTOKEN=a2fd244fd1b0aa9a-6D110E7F-5056-1B48-718EE3175AF81324&jsessionid=1430d8c4ac66bb14be5e7a727b6a684a6359
useremail=
userfirstname=
userlastname=

URL Parameters:
CKEY=US
Debug Rendering Time: 93 ms