byReal Store       byReal Store

Debugging Information
ColdFusion Server Enterprise 9,0,1,274733
Template /index.cfm
Time Stamp 20-Jun-13 12:02 PM
Locale English (US)
User Agent CCBot/2.0
Remote IP 184.73.7.143
Host Name 184.73.7.143

Execution Time

Total Time Avg Time Count Template
611 ms 611 ms 1 J:/diskF/Projects/buyvarious.com/www/index.cfm
312 ms 312 ms 1 J:/diskF/Projects/buyvarious.com/www/_layouts/shp4/_default.cfm
311 ms 311 ms 1 J:/diskF/Projects/buyvarious.com/www/amazon/categoriesEShop.cfm
309 ms 309 ms 1 CFC[ J:/diskF/Projects/buyvarious.com/www/com/amazon/amazon.cfc | BrowseNodeLookup(BrowseNodeId = 2350149011) ] from J:/diskF/Projects/buyvarious.com/www/com/amazon/amazon.cfc
309 ms 309 ms 1 J:/diskF/Projects/buyvarious.com/www/amazon/subMenu.cfm
292 ms 292 ms 1 J:/diskF/Projects/buyvarious.com/www/_manager.cfm
292 ms 292 ms 1 J:/diskF/Projects/buyvarious.com/www/amazon/_manager.cfm
291 ms 291 ms 1 CFC[ J:/diskF/Projects/buyvarious.com/www/com/amazon/amazon.cfc | itemSearch(ItemPage = 1, BrowseNode = 2350149011, ResponseGroup = Medium, SearchIndex = MobileApps) ] from J:/diskF/Projects/buyvarious.com/www/com/amazon/amazon.cfc
5 ms 5 ms 1 J:/diskF/Projects/buyvarious.com/www/trackNoBots.cfm
0 ms 0 ms 1 CFC[ J:/diskF/Projects/buyvarious.com/www/Application.cfc | onRequestEnd(/index.cfm) ] from J:/diskF/Projects/buyvarious.com/www/Application.cfc
0 ms 0 ms 1 CFC[ J:/diskF/Projects/buyvarious.com/www/Application.cfc | onRequestStart(/index.cfm) ] from J:/diskF/Projects/buyvarious.com/www/Application.cfc
0 ms 0 ms 1 CFC[ J:/diskF/Projects/buyvarious.com/www/com/general/functions.cfc | isIndex() ] from J:/diskF/Projects/buyvarious.com/www/com/general/functions.cfc
0 ms 0 ms 1 CFC[ J:/diskF/Projects/buyvarious.com/www/com/general/functions.cfc | trackIt(amazon, , ) ] from J:/diskF/Projects/buyvarious.com/www/com/general/functions.cfc
0 ms 0 ms 1 J:/diskF/Projects/buyvarious.com/www/_main.cfm
0 ms 0 ms 1 J:/diskF/Projects/buyvarious.com/www/_settings.cfm
0 ms 0 ms 1 J:/diskF/Projects/buyvarious.com/www/amazon/getContent.cfm
0 ms 0 ms 1 J:/diskF/Projects/buyvarious.com/www/decryptURL.cfm
0 ms 0 ms 1 J:/diskF/Projects/buyvarious.com/www/endPageAddons.cfm
0 ms 0 ms 1 J:/diskF/Projects/buyvarious.com/www/refreshCache.cfm
0 ms 0 ms 1 J:/diskF/Projects/buyvarious.com/www/transformSESURLs.cfm
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
614 ms  TOTAL EXECUTION TIME
red = over 500 ms average execution time

SQL Queries

isBot (Datasource=1SmartSolution, Time=4ms, Records=0) in J:\diskF\Projects\buyvarious.com\www\trackNoBots.cfm @ 12:02:31.031
		Select *
		From robots WITH (NOLOCK)
		Where  ('CCBot/2.0' like '%'+robot_name_new+'%'
			or 'CCBot/2.0' like '%'+keyword_new+'%'
			or robot_useragent_new = 'CCBot/2.0')
			and active = 1
getPromotions (Datasource=myAmazon, Time=0ms, Records=0, Cached Query) in J:\diskF\Projects\buyvarious.com\www\_layouts\shp4\_default.cfm @ 12:02:31.031
		Select promotionFile
		From promotions WITH (NOLOCK)
		Where promotionStart <= GetDate()
			and promotionEnd >= GetDate()
			and isActive = 1
Debug Rendering Time: 13 ms