Total Time	Avg Time	Count	Template
78 ms	78 ms	1	C:\inetpub\wwwroot\release_new\directory\directory.cfm
47 ms	47 ms	1	C:/inetpub/wwwroot/release_new/Application.cfm
47 ms	47 ms	1	C:/inetpub/wwwroot/release_new/include/ad_track.cfm
47 ms	47 ms	1	C:/inetpub/wwwroot/release_new/mainvar/global_var.cfm
31 ms	31 ms	1	C:/inetpub/wwwroot/release_new/include/woodplanet_header.cfm
31 ms	31 ms	1	C:/inetpub/wwwroot/release_new/include/woodplanet_left_new.cfm
15 ms	15 ms	1	C:/inetpub/wwwroot/release_new/include/loginboxregbuy.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/release_new/directory/dirheader.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/release_new/include/cookietest.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/release_new/include/googleanalytics.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/release_new/include/woodplanet_footer.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/release_new/include/woodplanet_top.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/release_new/mainvar/key.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
125 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

			select ssite_id from ref_ssite where ssite_home = 'www.woodplanet.com'
		

		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 = '14'
	

 	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 = 28399 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 c.company_id, company_name from company c, comp_prod_map cpm where c.is_supplier = 1 and
		  c.removal_date is NULL and c.company_id = cpm.company_id and
		  
		  company_name like 'i%'
	        
		  order by company_name asc

ads_updatetracktable (Datasource=westmain, Time=47ms) in C:\inetpub\wwwroot\release_new\include\ad_track.cfm @ 11:12:50.050

	parameters type CFSQLType value variable dbVarName  IN  cf_sql_integer  99      IN  cf_sql_timestamp  2019-10-11 11:12:50.032      IN  cf_sql_varchar  74.115.231.227      IN  cf_sql_varchar  imp      IN  cf_sql_varchar  newuser      IN  cf_sql_varchar  /directory/directory.cfm      IN  cf_sql_varchar  page=i&count=10      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:\inetpub\wwwroot\release_new\directory\directory.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,deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.woodplanet.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=ColdFusion
LOCAL_ADDR=www.woodplanet.com
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\release_new\directory\directory.cfm
QUERY_STRING=page=i&count=10
REMOTE_ADDR=74.115.231.227
REMOTE_HOST=74.115.231.227
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/directory/directory.cfm
SERVER_NAME=www.woodplanet.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=

Cookie Variables:
AD=14
AD_DTSTAMP={ts '2019-10-11 11:12:50'}

URL Parameters:
count=10
page=i