Councils

Total Time	Avg Time	Count	Template
21 ms	21 ms	1	E:\www\aauapweb\aucd\template\page.cfm
17 ms	17 ms	1	E:/www/aauapweb/aucd/Application.cfm
15 ms	15 ms	1	E:/www/aauapweb/aucd/template/header_2column.cfm
12 ms	12 ms	1	E:/www/aauapweb/aucd/template/qry_menu.cfm
6 ms	6 ms	1	E:/www/aauapweb/aucd/template/inc_header.cfm
5 ms	5 ms	1	E:/www/aauapweb/aucd/include/body.cfm
4 ms	4 ms	1	E:/www/aauapweb/aucd/template/common.cfm
3 ms	3 ms	1	E:/www/aauapweb/aucd/template/footer_2column.cfm
2 ms	2 ms	1	E:/www/aauapweb/aucd/template/inc_fourth.cfm
1 ms	1 ms	1	E:/www/aauapweb/aucd/template/ct_blurb_text.cfm
1 ms	1 ms	1	E:/www/aauapweb/aucd/template/inc_leftnav.cfm
1 ms	1 ms	1	E:/www/aauapweb/aucd/template/inc_nav.cfm
0 ms	0 ms	1	E:/www/aauapweb/aucd/include/cmsview.cfm
0 ms	0 ms	1	E:/www/aauapweb/aucd/template/ct_breadcrumbs.cfm
0 ms	0 ms	1	E:/www/aauapweb/aucd/template/ct_session.cfm
0 ms	0 ms	1	E:/www/aauapweb/aucd/template/inc_footer.cfm
0 ms	0 ms	1	E:/www/aauapweb/aucd/template/udf.cfm
1 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
39 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

	SELECT name, value FROM config
	WHERE
		
		host = 'remote' OR host = '' OR host is null
		

SELECT id, description FROM code WHERE name = 'content_language' ORDER BY orderby

		Select IsTraineeSitePage
		From page
		Where page.page_id = ? 

SELECT page.page_id, page.page_section, page.page_title, page.hide_search, page.hide_navigation,
	page.owner, page.template, page.browser_title, page.meta_description, page.page_filename,
	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_title
		WHEN gparent.page_id IS NOT NULL THEN gparent.page_title
		WHEN parent.page_id IS NOT NULL THEN parent.page_title
		ELSE page.page_title END AS section_name,
	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_id
		WHEN gparent.page_id IS NOT NULL THEN gparent.page_id
		WHEN parent.page_id IS NOT NULL THEN parent.page_id
		ELSE page.page_id END AS section_id,
	CASE WHEN ggparent.page_id IS NOT NULL THEN URL('',ggparent.page_filename,ggparent.page_id)
		WHEN gparent.page_id IS NOT NULL THEN URL('',gparent.page_filename,gparent.page_id)
		WHEN parent.page_id IS NOT NULL THEN URL('',parent.page_filename,parent.page_id)
		ELSE URL('',page.page_filename,page.page_id) END AS section_filename,
	CASE WHEN page.header_image IS NOT NULL THEN page.header_image
		WHEN parent.header_image IS NOT NULL THEN parent.header_image
		WHEN gparent.header_image IS NOT NULL THEN gparent.header_image
		ELSE ggparent.header_image END AS header_image,
	gparent.page_title AS gparent_name, gparent.page_id AS gparent_id,
	gparent.page_filename AS gparent_filename,
	parent.page_title AS parent_name, parent.page_id AS parent_id,
	parent.page_filename AS parent_filename
FROM page LEFT JOIN page AS parent ON page.page_section = parent.page_id
	LEFT JOIN page AS gparent ON parent.page_section = gparent.page_id
	LEFT JOIN page AS ggparent ON gparent.page_section = ggparent.page_id
WHERE
	
	page.page_id = 28 /* 1 */
	
	AND page.template NOT IN ('ITAC','NGSD','ECP')
	
		AND (page.IsTraineeSitePage = 0 or page.IsTraineeSitePage is null)
	
ORDER BY page_id

	SELECT code.code
	FROM link_page_role INNER JOIN code ON link_page_role.code_id = code.id
	WHERE fk_id = 28 

SELECT page.page_id, page.page_section, page.template, page.page_title,
	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_title
		WHEN gparent.page_id IS NOT NULL THEN gparent.page_title
		WHEN parent.page_id IS NOT NULL THEN parent.page_title
		ELSE page.page_title END AS section_name,
	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_id
		WHEN gparent.page_id IS NOT NULL THEN gparent.page_id
		WHEN parent.page_id IS NOT NULL THEN parent.page_id
		ELSE page.page_id END AS section_id,
	CASE WHEN ggparent.page_id IS NOT NULL THEN URL('',ggparent.page_filename,ggparent.page_id)
		WHEN gparent.page_id IS NOT NULL THEN URL('',gparent.page_filename,gparent.page_id)
		WHEN parent.page_id IS NOT NULL THEN URL('',parent.page_filename,parent.page_id)
		ELSE URL('',page.page_filename,page.page_id) END AS section_filename,
	gparent.page_title AS gparent_name, gparent.page_id AS gparent_id,
	gparent.page_filename AS gparent_filename,
	parent.page_title AS parent_name, parent.page_id AS parent_id,
	parent.page_filename AS parent_filename
FROM page LEFT JOIN page AS parent ON page.page_section = parent.page_id
	LEFT JOIN page AS gparent ON parent.page_section = gparent.page_id
	LEFT JOIN page AS ggparent ON gparent.page_section = ggparent.page_id
WHERE
	
	1=2
	

	SELECT page.page_id, page.page_title, page.page_section, page.orderby, page.meta_description,
		ifnull(parent.page_title,page.page_title) AS section_name,
		URL('',page.page_filename,page.page_id) AS page_filename
	FROM page LEFT JOIN page AS parent ON page.page_section = parent.page_id
	WHERE ifnull(page.hide_navigation,0) = 0 AND page.live = 1 AND
		parent.page_section is null
		
		AND page.orderby <= 70000
		AND (parent.page_id in (2,3,25,26,27,28,1,507,489) or
			(parent.page_id is null and page.page_id <> 514))
		AND (SELECT COUNT(*) FROM link_page_role WHERE fk_id = page.page_id AND code_id = 113) > 0
		
			AND (page.IsTraineeSitePage = 0 or page.IsTraineeSitePage is null)
		
		 
	ORDER BY page.orderby

SELECT page.page_id, page.page_title, page.orderby, 0 AS sub,
	URL('',page.page_filename,page.page_id) AS page_filename
FROM page
WHERE page.live = 1 AND ifnull(page.hide_navigation,0)=0 
	
		AND ifnull(page.page_section,0) = 28 
ORDER BY 3,2

SELECT * FROM qry_menutop
WHERE section_name = 'Network Resources' AND page_section > 0 AND page_filename not like '%nirs%'
ORDER BY orderby

SELECT * FROM qry_menutop
WHERE section_name = 'Home' AND page_section > 0
ORDER BY orderby

	SELECT sub FROM submenu
	WHERE page_id = 28 

	SELECT page.page_id, page.page_title, page.orderby,
		CASE WHEN ifnull(page.page_filename,'') <> '' AND locate('?',page.page_filename) > 0
		THEN concat(page.page_filename,'&parent=',page.page_section)
		WHEN ifnull(page.page_filename,'') <> '' AND locate('?',page.page_filename) = 0
		THEN concat(page.page_filename,'?parent=',page.page_section)
		ELSE concat('template/page.cfm?id=',page.page_id,'&parent=',page.page_section) 
		END AS page_filename
	FROM page
	WHERE
		
		1=2
		
	ORDER BY orderby
	

SELECT page_module.link_id, page_type, page_module.title, page_module.orderby,
	page_subtype, page_topic, page_layout, page_criteria, replace(module.type,' ','') AS type,
	module.subtype, rssaddress, topic.topic_title, replace(page_module.custom,',',' ') as custom,
	'' AS rss,
	
	concat_ws(',',page_module.detail1_id,page_module.detail2_id,page_module.detail3_id) AS detail_id
	
FROM page_module INNER JOIN module ON page_module.page_type = module.type AND (module.sidebar = 0 OR module.sidebar is null)
	LEFT JOIN topic ON page_module.page_topic = topic.topic_id
WHERE
	
		page_id = 28 
ORDER BY page_module.orderby

	SELECT title, content
	FROM page_module
	WHERE link_id = 32 

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=COMODO CA Limited, CN=COMODO RSA Domain Validation Secure Server CA
CERT_SERVER_SUBJECT=OU=Domain Control Validated, OU=EssentialSSL, CN=www.aucd.org
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\www\aauapweb\aucd\template\page.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=COMODO CA Limited, CN=COMODO RSA Domain Validation Secure Server CA
HTTPS_SERVER_SUBJECT=OU=Domain Control Validated, OU=EssentialSSL, CN=www.aucd.org
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=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.aucd.org
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=/template/page.cfm
PATH_TRANSLATED=E:\www\aauapweb\aucd\template\page.cfm
QUERY_STRING=id=28
REMOTE_ADDR=54.161.40.41
REMOTE_HOST=54.161.40.41
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/template/page.cfm
SERVER_NAME=www.aucd.org
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=

Client Variables:
cfid=22762788
cftoken=22113964
hitcount=1
lastvisit={ts '2018-07-20 12:28:58'}
timecreated={ts '2018-07-20 12:28:58'}
urltoken=CFID=22762788&CFTOKEN=22113964

Cookie Variables:
CFID=22762788
CFTOKEN=22113964

Session Variables:
cfg_admin_directory=/aucd_admin/
cfg_article_url=../resources/digest/issue.cfm?article_id=
cfg_authentication=HTML
cfg_client_full_name=AUCD
cfg_client_id=247
cfg_client_short_name=AUCD
cfg_database_type=mysql
cfg_dateformat=m/d/yyyy
cfg_doc_extension=doc,pdf,xls,txt,wpd,rtf,jpg,jpeg,gif,bmp,png,ppt,pps,mp3
cfg_doc_path=/docs/
cfg_ecp_feedback=bkaufman@AUCD.ORG
cfg_ecp_share=bkaufman@AUCD.ORG
cfg_editor_path=/tiny_mce/
cfg_email_actearlynews_submission=agriffen@AUCD.ORG, oklimova@aucd.org
cfg_email_council_cis=
cfg_email_council_coca=
cfg_email_council_core=
cfg_email_council_mcc=oklimova@aucd.org
cfg_email_council_ncedc=
cfg_email_council_ntdc=
cfg_email_developments_submission=lvaldez@aucd.org
cfg_email_digest_submission=acostalas@AUCD.ORG
cfg_email_hdd_submission=jminor@aucd.org
cfg_email_lend_application_submission=jperry@AUCD.ORG
cfg_email_pmu_submission=ynikola-lisa@aucd.org
cfg_email_spotlight_submission=cpariseau@aucd.org
cfg_email_stimulus=oklimova@aucd.org
cfg_email_website_feedback=oklimova@aucd.org
cfg_encoding=ISO-8859-1
cfg_evaluation_review=agriffen@AUCD.ORG
cfg_has_article_dept=Yes
cfg_has_article_issue=Yes
cfg_has_article_issuedept=Yes
cfg_has_article_type=0
cfg_has_crm=No
cfg_has_document=0
cfg_has_event_topic=Yes
cfg_has_feature_home_page=0
cfg_has_friendly_urls=No
cfg_has_issue_number=Yes
cfg_has_issue_summary=Yes
cfg_has_issue_volume=Yes
cfg_has_module_heading=Yes
cfg_has_new_topic=Yes
cfg_has_news_author=1
cfg_has_news_topic=Yes
cfg_has_person_address=0
cfg_has_person_board=Yes
cfg_has_person_country=0
cfg_has_person_custom=Yes
cfg_has_person_department=1
cfg_has_person_fax=Yes
cfg_has_person_photo=Yes
cfg_has_photo_expiration=0
cfg_has_sidebar=0
cfg_has_topic_parent_id=0
cfg_has_xml_import=0
cfg_live_default=No
cfg_log_number_of_months=4
cfg_mail_from=aucdinfo@aucd.org
cfg_mail_server=
cfg_module_detail_options=3
cfg_ngsd_about=681
cfg_ngsd_email_notification=oklimova@aucd.org,drudolph@aucd.org,beckmanncc@umkc.edu,spalmer@ku.edu,walkerla@umkc.edu,ericecook@sbcglobal.net,gottog@umkc.edu
cfg_ngsd_events=685
cfg_ngsd_join_listserve=687
cfg_ngsd_links=686
cfg_ngsd_news=684
cfg_ngsd_resources=683
cfg_ngsd_topics=682
cfg_ngsd_training=680
cfg_paging_count_landing=3
cfg_paging_count_list=15
cfg_path=
cfg_path_include=
cfg_paths_relative_to=root
cfg_person_notes_label=Notes
cfg_photo_album_view=JavaScript:openNewWindow('../template/slideshow.cfm?album_id={{id}}',800,750);
cfg_photo_path=/images2/
cfg_remember_login=1
cfg_rtoi_year=2012
cfg_search_resilience=per session
cfg_show_error_details=0
cfg_sidebar_positions=Left,Right
cfg_specific_items_days=730
cfg_specific_items_sort=Name
cfg_title=Content Management System
cfg_type_link_to=code
cfid=22762788
cftoken=22113964
sessionid=AUCDWEBSITE_22762788_22113964
urltoken=CFID=22762788&CFTOKEN=22113964

URL Parameters:
id=28