Total Time	Avg Time	Count	Template
109 ms	109 ms	1	D:\wwwroot\sparkplug\Sites\saut\content.cfm
46 ms	46 ms	1	D:\wwwroot\sparkplug\Sites\saut\cfml\administration.cfm
16 ms	16 ms	1	D:\wwwroot\sparkplug\Sites\saut\cfml\global_breadcrumbs.cfm
15 ms	15 ms	1	D:\wwwroot\sparkplug\Sites\saut\cfml\administration_header.cfm
0 ms	0 ms	1	D:\wwwroot\sparkplug\Application.cfm
0 ms	0 ms	1	D:\wwwroot\sparkplug\Sites\saut\cfml\global_buttons.cfm
0 ms	0 ms	1	D:\wwwroot\sparkplug\Sites\saut\cfml\global_footer.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
109 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SELECT Image FROM Content 
WHERE ContentID=821  

SELECT Content.* FROM Content 
WHERE ContentID=821    

SELECT CFMFile FROM Template WHERE Sectionid = 81 AND Siteid = 7 AND ArticleTemplate='YES'

SELECT Section FROM Section WHERE SectionID=81

SELECT HTMLFile FROM Template WHERE SectionID=81 AND ArticleTemplate='No'

SELECT Section FROM Section WHERE SectionID=81

SELECT Email FROM Author WHERE Author='Valerie Wilson'

Application Variables:
applicationname=SparkPlug
db=SparkPlug
items=10
path=D:\wwwroot\sparkplug
root=D:\wwwroot\sparkplug\sites
url=http://www.sautech.edu/sparkplug

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:\wwwroot\sparkplug\Sites\saut\content.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=deflate, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.sautech.edu
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/sparkplug/sites/saut/content.cfm
PATH_TRANSLATED=D:\wwwroot\sparkplug\sites\saut\content.cfm
QUERY_STRING=id=821
REMOTE_ADDR=10.1.0.7
REMOTE_HOST=10.1.0.7
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/sparkplug/sites/saut/content.cfm
SERVER_NAME=www.sautech.edu
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=

Client Variables:
cfid=162855
cftoken=1cd4d5afb3645eca-CB3CB459-65B8-F44D-9D64BBE3EB5EB7AF
hitcount=1
lastvisit={ts '2008-06-27 13:15:30'}
timecreated={ts '2008-06-27 13:15:30'}
urltoken=CFID=162855&CFTOKEN=1cd4d5afb3645eca-CB3CB459-65B8-F44D-9D64BBE3EB5EB7AF&jsessionid=8030970911214590530649

Cookie Variables:
CFID=162855
CFTOKEN=1cd4d5afb3645eca-CB3CB459-65B8-F44D-9D64BBE3EB5EB7AF

Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)

Session Variables:
sessionid=8030970911214590530649
urltoken=CFID=162855&CFTOKEN=1cd4d5afb3645eca-CB3CB459-65B8-F44D-9D64BBE3EB5EB7AF&jsessionid=8030970911214590530649

URL Parameters:
ID=821