Total Time	Avg Time	Count	Template
219 ms	219 ms	1	D:\eCMWebsites\hcca\AM\Template.cfm
203 ms	203 ms	1	D:\eCMWebsites\hcca\AM\CM\ContentDisplay.cfm
203 ms	203 ms	1	D:\eCMWebsites\hcca\AM\TemplateBody.cfm
47 ms	47 ms	1	D:\eCMWebsites\hcca\AM\Application.cfm
47 ms	47 ms	1	D:\eCMWebsites\hcca\AM\LoadSessionVariables.cfm
16 ms	16 ms	1	D:\eCMWebsites\hcca\AM\DetermineHeader.cfm
16 ms	16 ms	1	D:\eCMWebsites\hcca\AM\TemplateSection.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\ApplicationCustom.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\ApplicationUDFs.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\OnRequestEnd.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\FooterInclude.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\HeaderInclude.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\TemplateFooter\TemplateFooter.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\TemplateHeader\TemplateHeader.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\TemplateSideNav.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\TemplateTopNav.cfm
0 ms	0 ms	1	D:\eCMWebsites\hcca\AM\Templates\customsource\tscPO\footer.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
266 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

  SELECT a.*
    FROM System_Variable a
   WHERE VariableTypeCode = 'E'

      SELECT MembersOnlyFlag FROM Content WHERE ContentID = ?
    

        SELECT a.Keywords,
               a.Description,
               a.ShowInTemplateFlag,
               a.OpenInNewWindowFlag,
               a.SuppressBannersFlag,
               b.ContentID AS HTMLContentID,
               b.Title,
               b.Body,
               c.TemplatePath,
               c.Name,
               c.NavContentGroupInd,
               (SELECT COUNT(*) FROM Content_File WHERE ContentID = ?) AS FileCount,
               (SELECT COUNT(*) FROM Content_Link WHERE ContentID = ?) AS LinkCount,
               d.RelatedFilesTitle,
               d.RelatedLinksTitle
         FROM Nav_Menu c LEFT OUTER JOIN Website d
           ON c.WebsiteKey = d.WebsiteKey, Content a LEFT OUTER JOIN Content_HTML b
           ON a.ContentID = b.ContentID
        WHERE a.ContentID = ?
          AND c.NavMenuID = a.NavMenuID
      

          SELECT a.*
            FROM Content_Link a, Content b 
           WHERE a.ContentID = ?
					   AND a.ContentID = b.ContentID
						 ORDER by b.UserDefinedDate1 Desc, a.SortOrder
           
        

amsp_CMGetPublishedContentID (Datasource=iMIS_HCCA, Time=0ms) in D:\eCMWebsites\hcca\AM\CM\ContentDisplay.cfm @ 11:11:57.057

	parameters type CFSQLType value variable dbVarName  IN  CF_SQL_NUMERIC  8023      OUT  CF_SQL_NUMERIC    l_PublishedContentID = l_PublishedContentID    IN  CF_SQL_NUMERIC  1
	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=D:\eCMWebsites\hcca\AM\Template.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=
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www.hcca-info.org
HTTP_REFERER=
HTTP_USER_AGENT=
PATH_INFO=/AM/Template.cfm
PATH_TRANSLATED=D:\eCMWebsites\hcca\AM\Template.cfm
QUERY_STRING=Section=TWCC_Unsubscribe&Template=/CM/ContentDisplay.cfm&ContentID=8023&FuseFlag=1
REMOTE_ADDR=192.168.110.2
REMOTE_HOST=192.168.110.2
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/AM/Template.cfm
SERVER_NAME=hcca-ww1.hcca.internal
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Client Variables:
cfid=9225513
cftoken=13650690
hitcount=1
lastvisit={ts '2010-07-20 11:11:57'}
pausetrans=0
timecreated={ts '2010-07-20 11:11:57'}
urltoken=CFID=9225513&CFTOKEN=13650690

Cookie Variables:
CFID=9225513
CFTOKEN=13650690

Session Variables:
admin=False
administrator=False
adminsectionlist=
alldynamic=N
bebroadcastemail=Array (0)
bebulkemailauditid=0
bememberid=
browser=Unknown
browserversion=0
cfid=9225513
cftoken=13650690
chapter=
cm=Struct (13)
cmbordercolor=#D1CDBB
cmcurrentfolderid=
cmeditorredirecturl=
cmfolderdisplay=
cmfoldersectiondisplay=
cmnavcontentgroupind=N
cmsavetemplatepath=
cmsectiondisplay=
cmsuperadminflag=
cmsurftoeditcontentid=0
cmsurftoeditreturnurl=
cmtextonlytemplate=False
cmwebsitekey=
committee=
companymaster=false
companymembershipnum=
companyname=
contactid=0
coregistrant=Array (0)
cpinvitegroupmembers=Array (0)
debug=False
emailaddress=
faqflag=
firstname=
fontface=verdana
fontsize=2
geformsubmitted=false
headersize=3
imismemberid=
initialized=True
interestcategorylist=
jbcompany=Struct (0)
jbpreview=Struct (0)
jbsearch=Struct (0)
lastname=
location=Struct (8)
loggedin=0
member=Struct (18)
memberid=0
membershipflag=false
membertype=
message=
ol=Struct (2)
platform=Windows
publicresultsflag=
questiondisplaylimit=
redirect=
redirectfrom=
registrationpage=
rowcolor1=ccffff
rowcolor2=ccffcc
sc=Struct (3)
scadmincomponentcodelist=
screturnmessage=Click here to continue.
securitygrouplist=
sessionid=IMIS_HCCA_9225513_13650690
shoppingcart=Array (0)
staff=Struct (13)
surveydate=
surveyid=0
surveyreporttemplate=
surveyresponse=0
surveyresponseid=0
surveyreviewquestionlist=
surveytakenlist=
surveytype=
sy=Struct (20)
templatepath=/AM/Template.cfm?Section=TWCC_Unsubscribe
title=
urltoken=CFID=9225513&CFTOKEN=13650690
username=

URL Parameters:
CONTENTID=8023
FUSEFLAG=1
SECTION=TWCC_Unsubscribe
TEMPLATE=/CM/ContentDisplay.cfm