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 25-Oct-14 05:14 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.82.80.15
Host Name 54.82.80.15


Execution Time

Total Time Avg Time Count Template
172 ms 172 ms 1 E:\WEB\aao\index.cfm
172 ms 172 ms 1 E:\WEB\commonspot\master.cfm
109 ms 109 ms 1 E:\WEB\commonspot\utilities\cached-page-render.cfm
93 ms 93 ms 1 E:\WEB\aao\templates\template-homeland.cfm
93 ms 93 ms 1 E:\WEB\commonspot\master-render.cfm
93 ms 93 ms 1 E:\WEB\commonspot\render-page-meat.cfm
93 ms 93 ms 1 E:\WEB\commonspot\render-page.cfm
93 ms 93 ms 1 E:\WEB\commonspot\uncached-master.cfm
77 ms 5 ms 17 E:\WEB\commonspot\utilities\ct-render-named-element.cfm
47 ms 3 ms 18 E:\WEB\commonspot\utilities\ct-render-element.cfm
31 ms 31 ms 1 E:\WEB\commonspot\generate-usage-stats.cfm
16 ms 16 ms 1 E:\WEB\aao\Application.cfm
16 ms 16 ms 1 E:\WEB\commonspot\site-application.cfm
16 ms 16 ms 1 E:\WEB\commonspot\startup\site-application-meat.cfm
15 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\core-application-meat.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
188 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 @ 17:14:40.040
			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-10-25
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 @ 17:14:40.040
				UPDATE UsageData
					SET HitCount = ?
				 WHERE PageID=?
					AND UserID=?
					AND DateAccessed=?
					AND SiteID = ?
					AND ServerID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 50
Parameter #2(CF_SQL_INTEGER) = 142049
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_VARCHAR) = 2014-10-25
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 @ 17:14:40.040
		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 @ 17:14:40.040
	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 @ 17:14:40.040
		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 @ 17:14:40.040
	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.82.80.15
REMOTE_HOST=54.82.80.15
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=1509008
cftoken=59387719
hitcount=3
lastvisit={ts '2014-10-25 17:14:40'}
timecreated={ts '2014-10-25 17:14:40'}
urltoken=CFID=1509008&CFTOKEN=59387719
Cookie Variables:
CFID=1509008
CFTOKEN=59387719
LASTAAOPAGE=/index.cfm
Form Fields:
VIEWTYPE=unknown
Session Variables:
authormode=0
cfid=1509008
cftoken=59387719
contributemode=read
current_page_containing_forum=
currentpageid=142049
debugmode=0
debugstate=Struct (5)
editmode=0
hasusertempfiles=0
lastupdate=Struct (1)
lastuserupdate=1414282480257
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
pendingapprovalpages=
pendingapprovals=
requestedversioncounter=
requestedversiontimestamp=
sessionid=SITE1_1509008_59387719
urltoken=CFID=1509008&CFTOKEN=59387719
usagelist=142049
user=Struct (18)
Debug Rendering Time: 15 ms