Total Time	Avg Time	Count	Template
50 ms	50 ms	1	C:\home\woodplanet.com\wwwroot\devtest_release_new\main\buying\itemsforsale.cfm
45 ms	45 ms	1	C:/home/woodplanet.com/wwwroot/devtest_release_new/Application.cfm
43 ms	43 ms	1	C:/home/woodplanet.com/wwwroot/devtest_release_new/include/ad_track.cfm
43 ms	43 ms	1	C:/home/woodplanet.com/wwwroot/devtest_release_new/mainvar/global_var.cfm
16 ms	16 ms	1	C:/home/woodplanet.com/wwwroot/devtest_release_new/include/woodplanet_header.cfm
14 ms	14 ms	1	C:/home/woodplanet.com/wwwroot/devtest_release_new/include/woodplanet_left_new.cfm
2 ms	2 ms	1	C:/home/woodplanet.com/wwwroot/devtest_release_new/include/woodplanet_top.cfm
0 ms	0 ms	1	C:/home/woodplanet.com/wwwroot/devtest_release_new/include/cookietest.cfm
0 ms	0 ms	1	C:/home/woodplanet.com/wwwroot/devtest_release_new/include/googleanalytics.cfm
0 ms	0 ms	1	C:/home/woodplanet.com/wwwroot/devtest_release_new/include/loginboxregbuy.cfm
0 ms	0 ms	1	C:/home/woodplanet.com/wwwroot/devtest_release_new/include/woodplanet_footer.cfm
0 ms	0 ms	1	C:/home/woodplanet.com/wwwroot/devtest_release_new/mainvar/key.cfm
2 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
97 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SELECT prod_descr
	FROM ref_prod ref
	WHERE prod_id in (0)

select ad_id, g_weight from ad_ads where ad_id != 10 and ssite_id = 1 and ad_type = 0 
        	and g_weight <> 0 
        	and (requires_service = 0 or (requires_service = 11 and company_id in (select company_id from company_service where service_id = 11)))

select * from ad_ads
		where ad_id = '1'

select top 1 msg_id from wp_newsletter_include where msg_id is not null and date_sent is not null order by date_sent desc

select msg_id from wp_newsletter_include where msg_id = 30931 and date_sent between dateadd(d,-1,getdate()) and getdate()

SELECT ph.prod_id, prod_descr
	FROM prod_hier ph, ref_prod ref
	WHERE ph.prod_id = ref.prod_id and ph.parent_id is NULL and ph.ssite_id = 1
		order by ref.list_order asc

select distinct its.item_id from items_for_sale its, company_service cs
	where its.company_id = cs.company_id and 
	cs.service_id in (7,24,25,26) and isnull(cs.suspended_date,dateadd(d,1,getdate())) < getdate()
	and its.datesubmitted > {ts '2026-09-19 19:03:41'}

SELECT ph.prod_id, prod_descr
					FROM prod_hier ph, ref_prod ref
					WHERE ph.prod_id = ref.prod_id and ph.parent_id is NULL and ph.ssite_id = 1
					and prod_descr not like 'Wild Card'

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 121 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 118 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 115 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 59 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 58 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 57 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 56 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 55 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 54 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 53 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 66 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 128 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 137 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

select distinct ifs.item_id, ifs.item_title, ifs.datesubmitted,
									ifss.cat_id, ifs.updated
								from items_for_sale ifs, items_for_sale_ssite ifss
								where  ifss.ssite_id = 1 and ifss.cat_id = 73 and ifss.item_id = ifs.item_id
								and ifs.date_validated is not null
	and ifs.datesubmitted > {ts '2026-09-19 19:03:41'} 
								ORDER BY datesubmitted desc

ads_updatetracktable (Datasource=testwest, Time=43ms) in C:\home\woodplanet.com\wwwroot\devtest_release_new\include\ad_track.cfm @ 19:03:41.041

	parameters type CFSQLType value variable dbVarName  IN  cf_sql_integer  33      IN  cf_sql_timestamp  2026-10-19 19:03:41.893      IN  cf_sql_varchar  216.73.216.254      IN  cf_sql_varchar  imp      IN  cf_sql_varchar  newuser      IN  cf_sql_varchar  /main/buying/itemsforsale.cfm      IN  cf_sql_varchar        IN  cf_sql_varchar
	resultsets name resultset

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=C:\home\woodplanet.com\wwwroot\devtest_release_new\main\buying\itemsforsale.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=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=AD=33; AD_DTSTAMP=%7Bts%20%272026%2D10%2D19%2019%3A03%3A40%27%7D
HTTP_HOST=dev.woodplanet.com
HTTP_REFERER=
HTTP_URL=/main/buying/itemsforsale.cfm
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=45.86.37.204
PATH_INFO=
PATH_TRANSLATED=C:\home\woodplanet.com\wwwroot\devtest_release_new\main\buying\itemsforsale.cfm
QUERY_STRING=
REMOTE_ADDR=216.73.216.254
REMOTE_HOST=216.73.216.254
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/main/buying/itemsforsale.cfm
SERVER_NAME=dev.woodplanet.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
AD=1
AD_DTSTAMP={ts '2026-10-19 19:03:41'}