Total Time	Avg Time	Count	Template
63 ms	63 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
46 ms	46 ms	1	C:\inetpub\wwwroot\release_new\main\form\supplierprofile.cfm
16 ms	16 ms	1	C:/inetpub/wwwroot/release_new/include/woodplanet_header.cfm
16 ms	16 ms	1	C:/inetpub/wwwroot/release_new/include/woodplanet_left_new.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/loginboxregbuy.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
109 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

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

	select * from company_service where company_id = 4045246 and service_id = 5 and suspended_date is NULL

		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 = 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 round(rating/0.5,0)*0.5 as rating from rating_calc where supplier_compid = 4045246 

					select * from stock_main where company_id = 4045246 and main_list = 1
				

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

	parameters type CFSQLType value variable dbVarName  IN  cf_sql_integer  99      IN  cf_sql_timestamp  2019-10-11 11:11:22.765      IN  cf_sql_varchar  74.115.231.227      IN  cf_sql_varchar  imp      IN  cf_sql_varchar  newuser      IN  cf_sql_varchar  /main/form/supplierprofile.cfm      IN  cf_sql_varchar  frm=0&compid=4045246&featured=1      IN  cf_sql_varchar
	resultsets name resultset

prof_get1pp (Datasource=westmain, Time=15ms) in C:\inetpub\wwwroot\release_new\main\form\supplierprofile.cfm @ 11:11:22.022

	parameters type CFSQLType value variable dbVarName  IN  CF_SQL_NUMERIC  4045246      IN  CF_SQL_TINYINT  1
	resultsets name resultset  set1  1  set2  2  set3  3  set4  4  set5  5  set6  6  set7  7

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\main\form\supplierprofile.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\main\form\supplierprofile.cfm
QUERY_STRING=frm=0&compid=4045246&featured=1
REMOTE_ADDR=74.115.231.227
REMOTE_HOST=74.115.231.227
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/main/form/supplierprofile.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=1
AD_DTSTAMP={ts '2019-10-11 11:11:22'}

URL Parameters:
compid=4045246
featured=1
frm=0