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-Jun-15 02:10 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 50.16.47.14
Host Name 50.16.47.14


Execution Time

Total Time Avg Time Count Template
141 ms 141 ms 1 E:\WEB\aao\index.cfm
141 ms 141 ms 1 E:\WEB\commonspot\master.cfm
110 ms 110 ms 1 E:\WEB\commonspot\master-render.cfm
110 ms 110 ms 1 E:\WEB\commonspot\render-page-meat.cfm
110 ms 110 ms 1 E:\WEB\commonspot\render-page.cfm
110 ms 110 ms 1 E:\WEB\commonspot\uncached-master.cfm
110 ms 110 ms 1 E:\WEB\commonspot\utilities\cached-page-render.cfm
94 ms 94 ms 1 E:\WEB\aao\templates\template-homeland.cfm
79 ms 4 ms 18 E:\WEB\commonspot\utilities\ct-render-element.cfm
79 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\generate-usage-stats.cfm
31 ms 31 ms 1 E:\WEB\commonspot\site-application.cfm
31 ms 31 ms 1 E:\WEB\commonspot\startup\site-application-meat.cfm
16 ms 5 ms 3 E:\WEB\commonspot\controls\control-setup.cfm
16 ms 1 ms 18 E:\WEB\commonspot\security\security-control.cfm
16 ms 16 ms 1 E:\WEB\commonspot\startup\core-application-meat.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/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\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 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-head.cfm
0 ms 0 ms 1 E:\WEB\commonspot\render-metatags.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 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
172 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 @ 02:10:04.004
			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-06-02
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 1

UpdateUsageRec (Datasource=commonspot-site-aao, Time=15ms, Records=1) in E:\WEB\commonspot\generate-usage-stats.cfm @ 02:10:04.004
				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) = 2015-06-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 @ 02:10:04.004
		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 @ 02:10:04.004
	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 @ 02:10:04.004
		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 @ 02:10:04.004
	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=50.16.47.14
REMOTE_HOST=50.16.47.14
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=1900428
cftoken=77287677
hitcount=3
lastvisit={ts '2015-06-02 02:10:04'}
timecreated={ts '2015-06-02 02:10:04'}
urltoken=CFID=1900428&CFTOKEN=77287677
Cookie Variables:
CFID=1900428
CFTOKEN=77287677
LASTAAOPAGE=/index.cfm
Form Fields:
VIEWTYPE=unknown
Session Variables:
authormode=0
cfid=1900428
cftoken=77287677
contributemode=read
current_page_containing_forum=
currentpageid=142049
debugmode=0
debugstate=Struct (5)
editmode=0
hasusertempfiles=0
lastupdate=Struct (1)
lastuserupdate=1433236204696
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
pendingapprovalpages=
pendingapprovals=
requestedversioncounter=
requestedversiontimestamp=
sessionid=SITE1_1900428_77287677
urltoken=CFID=1900428&CFTOKEN=77287677
usagelist=142049
user=Struct (18)
Debug Rendering Time: 15 ms