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 28-Nov-14 05:11 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.204.168.212
Host Name 54.204.168.212


Execution Time

Total Time Avg Time Count Template
125 ms 125 ms 1 E:\WEB\aao\index.cfm
125 ms 125 ms 1 E:\WEB\commonspot\master.cfm
94 ms 94 ms 1 E:\WEB\commonspot\master-render.cfm
94 ms 94 ms 1 E:\WEB\commonspot\render-page-meat.cfm
94 ms 94 ms 1 E:\WEB\commonspot\render-page.cfm
94 ms 94 ms 1 E:\WEB\commonspot\uncached-master.cfm
94 ms 94 ms 1 E:\WEB\commonspot\utilities\cached-page-render.cfm
79 ms 79 ms 1 E:\WEB\aao\templates\template-homeland.cfm
63 ms 63 ms 1 E:\WEB\aao\Application.cfm
63 ms 63 ms 1 E:\WEB\commonspot\site-application.cfm
63 ms 63 ms 1 E:\WEB\commonspot\startup\core-application-meat.cfm
63 ms 63 ms 1 E:\WEB\commonspot\startup\site-application-meat.cfm
63 ms 4 ms 18 E:\WEB\commonspot\utilities\ct-render-element.cfm
63 ms 4 ms 17 E:\WEB\commonspot\utilities\ct-render-named-element.cfm
31 ms 31 ms 1 E:\WEB\commonspot\generate-usage-stats.cfm
16 ms 5 ms 3 E:\WEB\commonspot\utilities\run-element.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 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-head.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 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
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
204 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 @ 05:11: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-11-28
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 1

UpdateUsageRec (Datasource=commonspot-site-aao, Time=0ms, Records=1) in E:\WEB\commonspot\generate-usage-stats.cfm @ 05:11: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) = 21
Parameter #2(CF_SQL_INTEGER) = 142049
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_VARCHAR) = 2014-11-28
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 @ 05:11: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 @ 05:11: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 @ 05:11: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 @ 05:11: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.204.168.212
REMOTE_HOST=54.204.168.212
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=1565818
cftoken=25162086
hitcount=3
lastvisit={ts '2014-11-28 05:11:59'}
timecreated={ts '2014-11-28 05:11:59'}
urltoken=CFID=1565818&CFTOKEN=25162086
Cookie Variables:
CFID=1565818
CFTOKEN=25162086
LASTAAOPAGE=/index.cfm
Form Fields:
VIEWTYPE=unknown
Session Variables:
authormode=0
cfid=1565818
cftoken=25162086
contributemode=read
current_page_containing_forum=
currentpageid=142049
debugmode=0
debugstate=Struct (5)
editmode=0
hasusertempfiles=0
lastupdate=Struct (1)
lastuserupdate=1417180319252
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
pendingapprovalpages=
pendingapprovals=
requestedversioncounter=
requestedversiontimestamp=
sessionid=SITE1_1565818_25162086
urltoken=CFID=1565818&CFTOKEN=25162086
usagelist=142049
user=Struct (18)
Debug Rendering Time: 15 ms