Search | Archive | Subscribe | Advertise | About Us | AAO.org Member Login| Not a member?  
 
Contact Us | Privacy Policy
1995 - 2004, American Academy of Ophthalmology, Inc. ® All rights reserved.


Debugging Information
ColdFusion Server Enterprise 6,1,0,63958
Template /aao/news/eyenet/archive.cfm
Time Stamp 25-Feb-05 08:51 AM
Locale English (US)
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)
Remote IP 127.0.0.1
Host Name 127.0.0.1


Execution Time

Total Time Avg Time Count Template
813 ms 271 ms 3 C:\web\commonspot\cache\cached-render.cfm
516 ms 516 ms 1 top level 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


SQL Queries

CheckUsage (Datasource=commonspot-aao, Time=0ms, Records=0) in C:\web\commonspot\generate-usage-stats.cfm @ 08:51:07.007
			SELECT *
			  FROM UsageData
			 WHERE PageID = ?
				AND UserID = ?
				AND DateAccessed = '2005-02-25'
				AND SiteID = ?
				AND ServerID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 6030
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 1
Parameter #4(CF_SQL_INTEGER) = 1

InsertUsageRec (Datasource=commonspot-aao, Time=0ms, Records=0) in C:\web\commonspot\generate-usage-stats.cfm @ 08:51:07.007
				INSERT INTO UsageData
					(ServerID,SiteID,PageID,UserID,DateAccessed,HitCount)
				VALUES
					(?,
					 ?,
					 ?,
					 ?,'2005-02-25',1)
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 6030
Parameter #4(CF_SQL_INTEGER) = 0

Request.CtrlInstUpFront (Datasource=commonspot-aao, Time=15ms, Records=15) in C:\web\commonspot\controls\control-setup.cfm @ 08:51:08.008
			SELECT ControlID,ControlName
			  FROM ControlInstance
			 WHERE PageID IN (?,?,?,?)
		 ORDER BY PageID DESC
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 6030
Parameter #2(CF_SQL_INTEGER) = 5471
Parameter #3(CF_SQL_INTEGER) = 3065
Parameter #4(CF_SQL_INTEGER) = 465

Request.PageData.Restrictions (Datasource=commonspot-aao, Time=0ms, Records=0) in C:\web\commonspot\security\security-detail-queries.cfm @ 08:51:08.008
			SELECT *
			  FROM RestrictedSecurity
			 WHERE PageID IN (5471,3065,465) 
SecureElements (Datasource=commonspot-aao, Time=16ms, Records=0) in C:\web\commonspot\security\security-detail-queries.cfm @ 08:51:08.008
		SELECT DISTINCT ControlID
		  FROM ItemSecurity
		 WHERE
			(
				((ApplyTo=?)
					AND (PageID=?))
				OR
				((ApplyTo=?)
					AND (PageID IN (5471,3065,465)))
			)
			AND ControlID<>0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 6030
Parameter #3(CF_SQL_INTEGER) = 1

Request.PageData.ExplicitSecurity (Datasource=commonspot-aao, Time=15ms, Records=0) in C:\web\commonspot\security\security-detail-queries.cfm @ 08:51:08.008
			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
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 6030
Parameter #4(CF_SQL_INTEGER) = 1

Request.customCFUpfront (Datasource=commonspot-aao, Time=15ms, Records=7) in C:\web\commonspot\controls\upfront-generic.cfm @ 08:51:08.008
	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 
UpdateElementInstance (Datasource=commonspot-aao, Time=31ms, Records=0) in C:\web\commonspot\cache\cached-render.cfm @ 08:51:08.008
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?
				 WHERE PageID=?
					AND ControlID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 3
Parameter #3(CF_SQL_INTEGER) = 6030
Parameter #4(CF_SQL_INTEGER) = 5723

UpdateElementInstance (Datasource=commonspot-aao, Time=0ms, Records=0) in C:\web\commonspot\cache\cached-render.cfm @ 08:51:08.008
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?
				 WHERE PageID=?
					AND ControlID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 3
Parameter #3(CF_SQL_INTEGER) = 6030
Parameter #4(CF_SQL_INTEGER) = 5726


Scope Variables

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)
Debug Rendering Time: 109 ms