The American Academy of Ophthalmology

is the largest national membership association of Eye M.D.s.
Ophthalmologists are medical and osteopathic physicians who provide comprehensive eye care, including medical, surgical and optical care.


Debugging Information
ColdFusion Server Enterprise 8,0,0,176276
Template /index.cfm
Time Stamp 21-Aug-14 01:13 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.83.229.102
Host Name 54.83.229.102


Execution Time

Total Time Avg Time Count Template
250 ms 250 ms 1 E:\WEB\aao\index.cfm
250 ms 250 ms 1 E:\WEB\commonspot\master.cfm
140 ms 140 ms 1 E:\WEB\commonspot\master-render.cfm
140 ms 140 ms 1 E:\WEB\commonspot\render-page-meat.cfm
140 ms 140 ms 1 E:\WEB\commonspot\render-page.cfm
140 ms 140 ms 1 E:\WEB\commonspot\uncached-master.cfm
140 ms 140 ms 1 E:\WEB\commonspot\utilities\cached-page-render.cfm
109 ms 109 ms 1 E:\WEB\aao\templates\template-homeland.cfm
94 ms 94 ms 1 E:\WEB\commonspot\generate-usage-stats.cfm
93 ms 5 ms 18 E:\WEB\commonspot\utilities\ct-render-element.cfm
93 ms 5 ms 17 E:\WEB\commonspot\utilities\ct-render-named-element.cfm
31 ms 31 ms 1 E:\WEB\aao\Application.cfm
31 ms 31 ms 1 E:\WEB\commonspot\site-application.cfm
31 ms 31 ms 1 E:\WEB\commonspot\startup\core-application-meat.cfm
31 ms 31 ms 1 E:\WEB\commonspot\startup\site-application-meat.cfm
16 ms 16 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142017-c142030-l70-t8-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
16 ms 16 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142049-c142023-l70-t4-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
16 ms 16 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142049-c142024-l70-t4-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
16 ms 16 ms 1 E:\WEB\commonspot\utilities\newwindow-js.cfm
15 ms 15 ms 1 E:\WEB\commonspot\render-head.cfm
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\cache-status.cfc | GetPageCacheStatus(142017, 1, 142016, 0) ] from E:\WEB\commonspot\components\cache\cache-status.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\cache-status.cfc | GetPageCacheStatus(142049, 1, 142017, 0) ] from E:\WEB\commonspot\components\cache\cache-status.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\cache-status.cfc | UpdateStatus([complex value], [complex value], 1, 142049, 142017, 142018, 0, 70) ] from E:\WEB\commonspot\components\cache\cache-status.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\cache-status.cfc | UpdateStatus([complex value], [complex value], 1, 142049, 142017, 142032, 0, 70) ] from E:\WEB\commonspot\components\cache\cache-status.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\cache-status.cfc | UpdateStatus([complex value], [complex value], 1, 142049, 142017, 142033, 0, 70) ] from E:\WEB\commonspot\components\cache\cache-status.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142017-c142019-l70-t4-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142017-c142022-l70-t4-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142017-c142026-l70-t8-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142017-c142028-l70-t8-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142049-c142020-l70-t4-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142049-c142021-l70-t4-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142049-c142025-l70-t4-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142049-c142027-l70-t8-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142049-c142029-l70-t4-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\file-cache.cfc | GetFileContents(1/p142049-c142031-l70-t4-dAny.read) ] from E:\WEB\commonspot\components\cache\file-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\item-security-cache.cfc | GetEntry(142049) ] from E:\WEB\commonspot\components\cache\item-security-cache.cfc
0 ms 0 ms 5 CFC[ E:\WEB\commonspot\components\cache\template-cache.cfc | GetTemplatePageData(142017) ] from E:\WEB\commonspot\components\cache\template-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\cache\template-cache.cfc | LoadTemplateProperties(template-homeland-template.cfm, 142017, 1) ] from E:\WEB\commonspot\components\cache\template-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\custom-application-framework\handle-applications.cfc | executeFunction(handleRequestStart) ] from E:\WEB\commonspot\components\custom-application-framework\handle-applications.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\util\security-cache.cfc | getItemSecurity(0, 0, 0) ] from E:\WEB\commonspot\components\util\security-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\util\security-cache.cfc | getSubSitePerms(0, 0) ] from E:\WEB\commonspot\components\util\security-cache.cfc
0 ms 0 ms 1 CFC[ E:\WEB\commonspot\components\util\security-cache.cfc | getSubSiteSecurity(0, 0, 0) ] from E:\WEB\commonspot\components\util\security-cache.cfc
0 ms 0 ms 1 E:\WEB\aao\templates\homepage-webparts\footer.cfm
0 ms 0 ms 1 E:\WEB\aao\templates\homepage-webparts\header.cfm
0 ms 0 ms 1 E:\WEB\aao\templates\homepage-webparts\jsandtrack.cfm
0 ms 0 ms 1 E:\WEB\aao\templates\template-homeland.head
0 ms 0 ms 3 E:\WEB\commonspot\controls\control-setup.cfm
0 ms 0 ms 2 E:\WEB\commonspot\controls\ct-include-once.cfm
0 ms 0 ms 3 E:\WEB\commonspot\controls\customcf\cpe-customcf.cfm
0 ms 0 ms 3 E:\WEB\commonspot\controls\handle-styles.cfm
0 ms 0 ms 1 E:\WEB\commonspot\controls\upfront-generic.cfm
0 ms 0 ms 1 E:\WEB\commonspot\menu_ie_style.cfm
0 ms 0 ms 1 E:\WEB\commonspot\metadata\init-cache.cfm
0 ms 0 ms 2 E:\WEB\commonspot\pagemode\pagemodeui.cfm
0 ms 0 ms 1 E:\WEB\commonspot\render-body-tag.cfm
0 ms 0 ms 1 E:\WEB\commonspot\render-metatags.cfm
0 ms 0 ms 18 E:\WEB\commonspot\security\security-control.cfm
0 ms 0 ms 1 E:\WEB\commonspot\security\security-page.cfm
0 ms 0 ms 1 E:\WEB\commonspot\set-page-vars.cfm
0 ms 0 ms 1 E:\WEB\commonspot\startup\build-request-params.cfm
0 ms 0 ms 1 E:\WEB\commonspot\startup\handle-head-request.cfm
0 ms 0 ms 1 E:\WEB\commonspot\startup\handle-request-timeout.cfm
0 ms 0 ms 1 E:\WEB\commonspot\startup\init-server-scope.cfm
0 ms 0 ms 1 E:\WEB\commonspot\startup\session-first-global.cfm
0 ms 0 ms 1 E:\WEB\commonspot\startup\session-first-site.cfm
0 ms 0 ms 3 E:\WEB\commonspot\static\get-feature-enabled.cfm
0 ms 0 ms 1 E:\WEB\commonspot\utilities\build-user-struct.cfm
0 ms 0 ms 2 E:\WEB\commonspot\utilities\cp-cfcookie.cfm
0 ms 0 ms 2 E:\WEB\commonspot\utilities\define-upfront-vars.cfm
0 ms 0 ms 1 E:\WEB\commonspot\utilities\handle-in-list.cfm
0 ms 0 ms 1 E:\WEB\commonspot\utilities\logging\cs-logging-config.cfm
0 ms 0 ms 1 E:\WEB\commonspot\utilities\newwindow-js-meat.cfm
0 ms 0 ms 3 E:\WEB\commonspot\utilities\run-element.cfm
0 ms 0 ms 1 E:\WEB\commonspot\utilities\update-page-cache-status.cfm
0 ms 0 ms 1 E:\WEB\commonspot\utilities\verify-commonspot-dirs.cfm
0 ms 0 ms 1 E:\WEB\commonspot\utilities\verify-stub-data.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
281 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

CheckUsage (Datasource=commonspot-site-aao, Time=16ms, Records=1) in E:\WEB\commonspot\generate-usage-stats.cfm @ 01:13:59.059
			SELECT HitCount
			  FROM UsageData
			 WHERE PageID = ?
				AND UserID = ?
				AND DateAccessed = ?
				AND SiteID = ?
				AND ServerID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 142049
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_VARCHAR) = 2014-08-21
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 1

UpdateUsageRec (Datasource=commonspot-site-aao, Time=78ms, Records=1) in E:\WEB\commonspot\generate-usage-stats.cfm @ 01:13:59.059
				UPDATE UsageData
					SET HitCount = ?
				 WHERE PageID=?
					AND UserID=?
					AND DateAccessed=?
					AND SiteID = ?
					AND ServerID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 6
Parameter #2(CF_SQL_INTEGER) = 142049
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_VARCHAR) = 2014-08-21
Parameter #5(CF_SQL_INTEGER) = 1
Parameter #6(CF_SQL_INTEGER) = 1

Request.PageData.PageParams (Datasource=commonspot-site-aao, Time=0ms, Records=0) in E:\WEB\commonspot\render-page-meat.cfm @ 01:13:59.059
		SELECT *
		  FROM Param_Page
		 WHERE (PageID=142049 OR (PageID IN (142017,142016) AND (VersionState = 2)))
		   AND VersionState=2
		 ORDER BY PageID DESC
	
liveBookmarkList (Datasource=commonspot-site-aao, Time=0ms, Records=0) in E:\WEB\commonspot\render-head.cfm @ 01:13:59.059
	SELECT Data_SeeAlso.ID, SubSites.SubSiteURL, SitePages.filename as pagename, XMLPublications.name as feedname, XMLPublicationFormat.name as feedformat, XMLPublicationFormat.IsSyndication, XMLPublications.description
	  FROM Data_SeeAlso, XMLPublications, XMLPublicationFormat, SitePages, SubSites
	 WHERE Data_SeeAlso.PageID = ?
	 	AND Data_SeeAlso.Action = ?
	 	AND Data_SeeAlso.ItemID = XMLPublicationFormat.XMLPublicationFormatID
	 	AND Data_SeeAlso.TargetPageID = XMLPublications.XMLPublicationID
	 	AND XMLPublications.XMLPublicationFormatID = XMLPublicationFormat.XMLPublicationFormatID
	 	AND XMLPublications.PageID = SitePages.ID
	 	AND SitePages.SubSiteID = SubSites.ID
	 	AND XMLPublicationFormat.IsSyndication > ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 142049
Parameter #2(CF_SQL_INTEGER) = 11
Parameter #3(CF_SQL_INTEGER) = 0

ControlInstanceData (Datasource=commonspot-site-aao, Time=0ms, Records=34) in E:\WEB\commonspot\controls\control-setup.cfm @ 01:13:59.059
		SELECT ControlID,ControlName,ControlType,ParentControlID
		  FROM ControlInstance
		 WHERE (PageID IN (142016,142017,142049)) 
	 ORDER BY PageID
	
Request.customCFUpfront (Datasource=commonspot-site-aao, Time=0ms, Records=7) in E:\WEB\commonspot\controls\upfront-generic.cfm @ 01:13:59.059
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=142049 OR (PageID IN (142017,142016) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 


Scope Variables

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=E:\WEB\aao\index.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=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=development.aao.org
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=E:\WEB\aao\index.cfm
QUERY_STRING=
REMOTE_ADDR=54.83.229.102
REMOTE_HOST=54.83.229.102
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=development.aao.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Apache/2.0.50 (Win32) JRun/4.0
WEB_SERVER_API=
Client Variables:
cfid=1391643
cftoken=93993978
hitcount=3
lastvisit={ts '2014-08-21 01:13:58'}
timecreated={ts '2014-08-21 01:13:58'}
urltoken=CFID=1391643&CFTOKEN=93993978
Cookie Variables:
CFID=1391643
CFTOKEN=93993978
LASTAAOPAGE=/index.cfm
Form Fields:
VIEWTYPE=unknown
Session Variables:
authormode=0
cfid=1391643
cftoken=93993978
contributemode=read
current_page_containing_forum=
currentpageid=142049
debugmode=0
debugstate=Struct (5)
editmode=0
hasusertempfiles=0
lastupdate=Struct (1)
lastuserupdate=1408608838984
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
pendingapprovalpages=
pendingapprovals=
requestedversioncounter=
requestedversiontimestamp=
sessionid=SITE1_1391643_93993978
urltoken=CFID=1391643&CFTOKEN=93993978
usagelist=142049
user=Struct (18)
Debug Rendering Time: 16 ms