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 02-Mar-15 03:05 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.167.175.107
Host Name 54.167.175.107


Execution Time

Total Time Avg Time Count Template
313 ms 313 ms 1 E:\WEB\aao\index.cfm
297 ms 297 ms 1 E:\WEB\commonspot\master.cfm
250 ms 250 ms 1 E:\WEB\commonspot\master-render.cfm
250 ms 250 ms 1 E:\WEB\commonspot\render-page.cfm
250 ms 250 ms 1 E:\WEB\commonspot\uncached-master.cfm
250 ms 250 ms 1 E:\WEB\commonspot\utilities\cached-page-render.cfm
218 ms 218 ms 1 E:\WEB\commonspot\render-page-meat.cfm
187 ms 187 ms 1 E:\WEB\aao\templates\template-homeland.cfm
173 ms 10 ms 18 E:\WEB\commonspot\utilities\ct-render-element.cfm
157 ms 9 ms 17 E:\WEB\commonspot\utilities\ct-render-named-element.cfm
94 ms 94 ms 1 E:\WEB\aao\Application.cfm
94 ms 94 ms 1 E:\WEB\commonspot\site-application.cfm
94 ms 94 ms 1 E:\WEB\commonspot\startup\site-application-meat.cfm
47 ms 47 ms 1 E:\WEB\commonspot\generate-usage-stats.cfm
30 ms 10 ms 3 E:\WEB\commonspot\utilities\run-element.cfm
16 ms 16 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
16 ms 16 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
16 ms 5 ms 3 E:\WEB\commonspot\controls\control-setup.cfm
16 ms 16 ms 1 E:\WEB\commonspot\startup\core-application-meat.cfm
15 ms 15 ms 1 E:\WEB\commonspot\render-head.cfm
15 ms 15 ms 1 E:\WEB\commonspot\render-metatags.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-c142030-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-c142023-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-c142024-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\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 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 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 1 E:\WEB\commonspot\utilities\newwindow-js.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
407 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

CheckUsage (Datasource=commonspot-site-aao, Time=31ms, Records=1) in E:\WEB\commonspot\generate-usage-stats.cfm @ 15:05:44.044
			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) = 2015-03-02
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 1

UpdateUsageRec (Datasource=commonspot-site-aao, Time=16ms, Records=1) in E:\WEB\commonspot\generate-usage-stats.cfm @ 15:05:44.044
				UPDATE UsageData
					SET HitCount = ?
				 WHERE PageID=?
					AND UserID=?
					AND DateAccessed=?
					AND SiteID = ?
					AND ServerID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 57
Parameter #2(CF_SQL_INTEGER) = 142049
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_VARCHAR) = 2015-03-02
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 @ 15:05:44.044
		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 @ 15:05:44.044
	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=16ms, Records=34) in E:\WEB\commonspot\controls\control-setup.cfm @ 15:05:44.044
		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 @ 15:05:44.044
	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.167.175.107
REMOTE_HOST=54.167.175.107
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.63 (Win32) JRun/4.0
WEB_SERVER_API=
Client Variables:
cfid=1777382
cftoken=15410033
hitcount=3
lastvisit={ts '2015-03-02 15:05:44'}
timecreated={ts '2015-03-02 15:05:44'}
urltoken=CFID=1777382&CFTOKEN=15410033
Cookie Variables:
CFID=1777382
CFTOKEN=15410033
LASTAAOPAGE=/index.cfm
Form Fields:
VIEWTYPE=unknown
Session Variables:
authormode=0
cfid=1777382
cftoken=15410033
contributemode=read
current_page_containing_forum=
currentpageid=142049
debugmode=0
debugstate=Struct (5)
editmode=0
hasusertempfiles=0
lastupdate=Struct (1)
lastuserupdate=1425337544039
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
pendingapprovalpages=
pendingapprovals=
requestedversioncounter=
requestedversiontimestamp=
sessionid=SITE1_1777382_15410033
urltoken=CFID=1777382&CFTOKEN=15410033
usagelist=142049
user=Struct (18)
Debug Rendering Time: 47 ms