Total Time	Avg Time	Count	Template
813 ms	271 ms	3	C:\web\commonspot\cache\cached-render.cfm
516 ms	516 ms	1	C:\web\aao\news\eyenet\archive.cfm
516 ms	516 ms	1	C:\web\commonspot\master.cfm
500 ms	500 ms	1	C:\web\commonspot\master-render.cfm
390 ms	390 ms	1	C:\web\aao\cache\s109-p6030-c0-t0-mr-bIE.cache
374 ms	187 ms	2	C:\web\commonspot\utilities\ct-render-element.cfm
203 ms	102 ms	2	C:\web\commonspot\controls\customcf\cpe-customcf.cfm
48 ms	24 ms	2	C:\web\commonspot\utilities\cp-cffile.cfm
47 ms	47 ms	1	C:\web\aao\customcf\eyenet\mast.cfm
31 ms	16 ms	2	C:\web\commonspot\security\security-control.cfm
31 ms	31 ms	1	C:\web\commonspot\security\security-detail-queries.cfm
31 ms	6 ms	5	C:\web\commonspot\utilities\handle-cache-flags.cfm
15 ms	15 ms	1	C:\web\aao\news\eyenet\Application.cfm
15 ms	8 ms	2	C:\web\commonspot\controls\control-setup.cfm
15 ms	15 ms	1	C:\web\commonspot\controls\upfront-generic.cfm
0 ms	0 ms	1	C:\web\aao\customcf\eyenet\eyenet_style.cfm
0 ms	0 ms	1	C:\web\aao\customcf\eyenet\footer.cfm
0 ms	0 ms	1	C:\web\aao\customcf\style.cfm
0 ms	0 ms	2	C:\web\commonspot\admin\admin-get-charset.cfm
0 ms	0 ms	1	C:\web\commonspot\controls\dhtmlmenu\menu-output-display.cfm
0 ms	0 ms	7	C:\web\commonspot\controls\set-caller-vars.cfm
0 ms	0 ms	1	C:\web\commonspot\core-application.cfm
0 ms	0 ms	1	C:\web\commonspot\generate-usage-stats.cfm
0 ms	0 ms	1	C:\web\commonspot\menu\core-js.cfm
0 ms	0 ms	1	C:\web\commonspot\metadata\init-cache.cfm
0 ms	0 ms	1	C:\web\commonspot\pagemode\newpagemodeui.cfm
0 ms	0 ms	1	C:\web\commonspot\pagemode\newpmstyle.cfm
0 ms	0 ms	1	C:\web\commonspot\security\security-page.cfm
0 ms	0 ms	1	C:\web\commonspot\set-page-vars.cfm
0 ms	0 ms	1	C:\web\commonspot\site-application.cfm
0 ms	0 ms	2	C:\web\commonspot\static\get-feature-enabled.cfm
0 ms	0 ms	1	C:\web\commonspot\utilities\build-pagedata.cfm
0 ms	0 ms	2	C:\web\commonspot\utilities\cp-cfwddx.cfm
0 ms	0 ms	1	C:\web\commonspot\utilities\cp-setencoding.cfm
0 ms	0 ms	1	C:\web\commonspot\utilities\define-upfront-vars.cfm
0 ms	0 ms	2	C:\web\commonspot\utilities\get-class-names.cfm
0 ms	0 ms	5	C:\web\commonspot\utilities\validate-date-string.cfm
172 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
703 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

			SELECT *
			  FROM UsageData
			 WHERE PageID = ?
				AND UserID = ?
				AND DateAccessed = '2005-02-25'
				AND SiteID = ?
				AND ServerID = ? 

				INSERT INTO UsageData
					(ServerID,SiteID,PageID,UserID,DateAccessed,HitCount)
				VALUES
					(?,
					 ?,
					 ?,
					 ?,'2005-02-25',1)
			

			SELECT ControlID,ControlName
			  FROM ControlInstance
			 WHERE PageID IN (?,?,?,?)
		 ORDER BY PageID DESC
		

			SELECT *
			  FROM RestrictedSecurity
			 WHERE PageID IN (5471,3065,465) 

		SELECT DISTINCT ControlID
		  FROM ItemSecurity
		 WHERE
			(
				((ApplyTo=?)
					AND (PageID=?))
				OR
				((ApplyTo=?)
					AND (PageID IN (5471,3065,465)))
			)
			AND ControlID<>0
	

			SELECT ControlID,
					 Max(pRead) AS maxRead,
					 Max(pAuthor) AS maxAuthor,
					 Max(pEdit) AS maxEdit,
					 Max(pDesign) AS maxDesign,
					 Max(pStyle) AS maxStyle,
					 Max(pAdmin) AS maxAdmin,
					 Max(pApprove) AS maxApprove
			  FROM ItemSecurity
			 WHERE (UserGroupID IN (?))
		      AND
				(
					((ApplyTo=?)
						AND (PageID=?))
					OR
					((ApplyTo=?)
						AND (PageID IN (5471,3065,465)))
				)
				AND ControlID<>0
		 GROUP BY ControlID
		

	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=6030 OR (PageID IN (5471,3065,465) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?
				 WHERE PageID=?
					AND ControlID=? 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?
				 WHERE PageID=?
					AND ControlID=? 

Application Variables:
activesubsites=1,3,8,9,16,25,32,33,34,36,37,38,39,40,41,44,45,46,47,48,49,50,52,53,54,55,56,57,58,59,60,61,63,64,65,66,67,68,70,71,72,73,74,75,76,82,83,85,87,88,89,91,100,101,102,103,104,109,110,112,113,114,115,116,117,118,119,120,121,122,123,126,128,129,130,131,132,133,134,135,136,137,138,139,140,142,143,144,145,146,151,152,153,154,155,157,158,159,162,167,169,170,171,172,173,174,175,176,178,180,181,182,183,184,185,186,187,188,190,191,192,193,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,222,223,224,225,226,228,229,230,231,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,272,276,277,278,279,280,281,282,283
anonitemsecurity=Struct (8)
anonrights=Struct (7)
anonsubsiteperms=Struct (203)
anonsubsitesecurity=Struct (203)
applicationname=site1
authorok=Complex type
cacheinfo=Struct (2981)
cachevalid=1
confidentiality=Array (5)
controlinstance_toplevel=Struct (2)
cs_element_cache=Struct (0)
defaultconfidentiality=5
defaultstructs=Struct (3)
docsdump=Complex type
dodump=Complex type
dolog=Complex type
escapestringforjs=Complex type
html_checkbox=Complex type
html_option=Complex type
html_radio_button=Complex type
languages=Struct (11)
lastknownchange=Struct (18)
lastupdate=Struct (15)
masterrendersequence=3
nextcheck=Struct (1)
site=Struct (46)
styleids=Struct (192)
stylenames=Struct (192)
subsitecache=Struct (203)
templaterenderoptions=Struct (78)
translations=Struct (4)
win1252_to_entities=Complex type
win1252_to_unicode=Complex type

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:\web\aao\news\eyenet\archive.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*
HTTP_ACCEPT_ENCODING=gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFID=2708; CFTOKEN=54317655; JSESSIONID=70301749721109343005078
HTTP_HOST=testaao.sf.aao.org
HTTP_REFERER=
HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 2.8)
PATH_INFO=
PATH_TRANSLATED=C:\web\aao\news\eyenet\archive.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/aao/news/eyenet/archive.cfm
SERVER_NAME=testaao.sf.aao.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/2.0.50 (Win32) PHP/4.3.3 JRun/4.0
WEB_SERVER_API=

Cookie Variables:
CFID=2708
CFTOKEN=54317655
JSESSIONID=70301749721109343005078

Request Parameters:
applockname=appcommonspot-users
approvalneededlist=
approvedlist=
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
blupfront=
browser=Struct (8)
buildingcache=0
cacheinfo=Struct (11)
constants=Struct (166)
controlswhereuserisowner=
cp=Struct (102)
ctrl_data=Struct (15)
ctrlinstupfront=Query (15)
customcf_data=Struct (1)
customcfupfront=Query (7)
customerinfo=Struct (20)
debugmode=0
dhtmlmenuitemsprefetch=
disablehideformenus=0
element=Struct (9)
elementadminlist=
elementapprovelist=
elementauthorlist=
elementcommentlist=
elementdesignlist=
elementeditlist=
elementreadlist=
elementrestrictedadminlist=0
elementrestrictedauthorlist=0
elementrestricteddesignlist=0
elementrestrictedstylelist=0
elementstylelist=
fnsequence=2
formattedtimestamp=2005-02-25 08:51:07
getghost=
ignoreauthuser=0
imageupfront=
includedmodules=
initialsiteid=1
initialsubsiteid=109
itemsecurity=Struct (8)
jswarnmessage=
knownsecurecontrols=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
master_cfm_used=1
masterrendersequence=3
maxadmin=0
maxapprove=0
maxauthor=0
maxcomment=0
maxdesign=0
maxedit=0
maxhistory=0
maxperms=Struct (9)
maxstyle=0
minperms=Struct (9)
modeorderbyclause=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
nocacheelementtypes=
openelements=
page=Struct (93)
pagedata=Struct (8)
pagedhtmlitems=
pagedhtmlmenus=
pageid=6030
pageperms=Struct (9)
pagerestrictedadmin=0
pagerestrictedauthor=0
pagerestricteddesign=0
pagerestrictedstyle=0
previewon=1
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderfordiff=0
renderforprint=0
requestedversiontimestamp=
scheduleupfront=
securitydetailrun=1
sequenceid=4
sessionlockname=Session1_COMMONSPOT_2708_54317655
sessionstring=1_COMMONSPOT_2708_54317655
sicupfront=
sicupfrontparam=
site=Struct (46)
siteid=1
styleids=Struct (192)
stylenames=Struct (192)
subsite=Struct (56)
subsitecache=Struct (203)
subsiteid=109
subsiteperms=Struct (203)
subsiterights=Struct (14)
subsitesecurity=Struct (2)
subsitesecuritycache=Struct (203)
taiupfrontparam=
tbupfront=
tbupfrontparam=
timestamp={ts '2005-02-25 08:51:07'}
updatingschemas=0
usedelementnames=
user=Struct (17)
usersdatasource=commonspot-users
vinheritancelist=6030,5471,3065,465
wanterrorsrethrown=0
warnmessage=

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

Session Variables:
authormode=0
browser=Struct (8)
cfid=2708
cftoken=54317655
currentpageid=6030
debugmode=0
debugmode_control=0
hasusertempfiles=0
lastupdate=Struct (6)
lastuserupdate=1109343003343
lockid=0
lockobjectid=0
lockobjecttype=page
locktype=temp
logintime=
pagedata=Struct (8)
pendingapprovalpages=
pendingapprovals=
previewon=1
requestedversioncounter=
requestedversiontimestamp=
sessionid=SITE1_2708_54317655
sessiontokenstable=1
urltoken=CFID=2708&CFTOKEN=54317655
usagelist=6030,37661
user=Struct (17)