Maryellen Hagerty

Paul V. Sherlock Center on Disabilities
Rhode Island College
600 Mount Pleasant Avenue
Providence, RI 02908
 
Phone: 401-456-1943
Email: mhagerty@ric.edu
Login to Update Your Profile
Last Updated: January 02, 2010

 

Project/Program/Clinic Contacts: Case Manager, Educational Advocate/Surrogate Parent Program
 
AUCD Council Membership: No Council Membership



Debugging Information
ColdFusion Server Standard 9,0,0,251028
Template /directory/detailbio.cfm
Time Stamp 05-Mar-15 10:59 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 192.168.35.1
Host Name 192.168.35.1


Execution Time

Total Time Avg Time Count Template
21 ms 21 ms 1 top level E:\www\aauapweb\aucd\directory\detailbio.cfm
16 ms 16 ms 1 E:/www/aauapweb/aucd/Application.cfm
16 ms 16 ms 1 E:/www/aauapweb/aucd/directory/Application.cfm
12 ms 12 ms 1 E:/www/aauapweb/aucd/template/header_plain.cfm
11 ms 11 ms 1 E:/www/aauapweb/aucd/template/header_2column.cfm
9 ms 9 ms 1 E:/www/aauapweb/aucd/template/qry_menu.cfm
7 ms 7 ms 1 E:/www/aauapweb/aucd/template/inc_header.cfm
4 ms 4 ms 1 E:/www/aauapweb/aucd/include/dir_contact_view.cfm
3 ms 3 ms 1 E:/www/aauapweb/aucd/template/common.cfm
2 ms 2 ms 1 E:/www/aauapweb/aucd/template/footer_plain.cfm
2 ms 2 ms 1 E:/www/aauapweb/aucd/template/inc_fourth.cfm
1 ms 1 ms 1 E:/www/aauapweb/aucd/include/body.cfm
1 ms 1 ms 1 E:/www/aauapweb/aucd/template/footer_2column.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
38 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

qry_config (Datasource=aucd, Time=2ms, Records=88) in E:\www\aauapweb\aucd\template\common.cfm @ 10:59:04.004
	SELECT name, value FROM config
	WHERE
		
		host = 'remote' OR host = '' OR host is null
		
lang (Datasource=aucd, Time=0ms, Records=0) in E:\www\aauapweb\aucd\template\common.cfm @ 10:59:04.004
SELECT id, description FROM code WHERE name = 'content_language' ORDER BY orderby
page (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:59:04.004
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_filename like '%directory/detailbio.cfm%' /* 5 */
	
	AND page.template NOT IN ('ITAC','NGSD','ECP')
ORDER BY page_id
getrole (Datasource=aucd, Time=0ms, Records=1) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:59:04.004
	SELECT code.code
	FROM link_page_role INNER JOIN code ON link_page_role.code_id = code.id
	WHERE fk_id = 143 
parentinfo (Datasource=aucd, Time=0ms, Records=0) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:59:04.004
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
	
qry_menutop (Datasource=aucd, Time=6ms, Records=87) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:59:04.004
	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
		
		 
	ORDER BY page.orderby
detail (Datasource=aucd, Time=2ms, Records=1) in E:\www\aauapweb\aucd\directory\detailbio.cfm @ 10:59:04.004
SELECT tbl_directory_staff.*,
	tbl_directory_address.progname, tbl_directory_address.organization, tbl_directory_address.address_id,
	tbl_directory_programs.state AS program_state,
	staff_position(tbl_directory_staff.staffid,'','') AS all_position
FROM tbl_directory_staff 
	INNER JOIN tbl_directory_programs ON tbl_directory_staff.id = tbl_directory_programs.id
	LEFT JOIN tbl_directory_address ON tbl_directory_staff.id = tbl_directory_address.program_id
		 
		AND tbl_directory_address.program_type like '%UCEDD%' 
		
WHERE tbl_directory_staff.staffid = 4545 
get_desc (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\udf.cfm @ 10:59:04.004
			SELECT description AS description FROM code
			WHERE name = ? AND code = 'RI'
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = state

submenu (Datasource=aucd, Time=1ms, Records=3) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:59:04.004
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) = 2 
UNION
SELECT page_id, page_title, orderby, 1 AS sub,
	URL('',child.page_filename,child.page_id) AS page_filename
FROM page AS child
WHERE live = 1 AND ifnull(hide_navigation,0)=0 AND
	
	ifnull(page_section,0) = 5 
ORDER BY 3,2
menu_network (Datasource=, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:59:04.004
SELECT * FROM qry_menutop
WHERE section_name = 'Network Resources' AND page_section > 0 AND page_filename not like '%nirs%'
ORDER BY orderby
menu_home (Datasource=, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:59:04.004
SELECT * FROM qry_menutop
WHERE section_name = 'Home' AND page_section > 0
ORDER BY orderby
issub (Datasource=, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\inc_fourth.cfm @ 10:59:04.004
	SELECT sub FROM submenu
	WHERE page_id = 143 
fourth (Datasource=aucd, Time=0ms, Records=0) in E:\www\aauapweb\aucd\template\inc_fourth.cfm @ 10:59:04.004
	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
	
related (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\include\body.cfm @ 10:59:04.004
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 = 143 
ORDER BY page_module.orderby
disc (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\include\dir_contact_view.cfm @ 10:59:04.004
SELECT group_concat(description SEPARATOR ', ') AS discipline
FROM crm_code INNER JOIN crm_link_contact ON crm_code.id = crm_link_contact.code_id
WHERE crm_link_contact.fk_id = 4545
	AND crm_code.name = 'discipline'
	and crm_code.description not like '%other%'
ORDER BY crm_code.orderby, crm_code.description
addr (Datasource=aucd, Time=0ms, Records=1) in E:\www\aauapweb\aucd\include\dir_contact_view.cfm @ 10:59:04.004
	SELECT address1, address2, city, state, zip, department, organization, phone
	FROM tbl_directory_address AS c
	WHERE c.program_id = 63 
qry_positions (Datasource=aucd, Time=2ms, Records=1) in E:\www\aauapweb\aucd\include\dir_contact_view.cfm @ 10:59:04.004
	SELECT
			(select group_concat(position_id)
				from tbl_directory_staff_position inner join tbl_directory_positions on tbl_directory_staff_position.position_id = tbl_directory_positions.id
				where tbl_directory_staff_position.staffid = 4545 and
						tbl_directory_positions.section = "TP")
		as lead_positions,
			(select group_concat(position_id)
				from tbl_directory_staff_position inner join tbl_directory_positions on tbl_directory_staff_position.position_id = tbl_directory_positions.id
				where tbl_directory_staff_position.staffid = 4545 and
						tbl_directory_positions.section = "PA")
		as activ_coord_positions,
			(select group_concat(position_id)
				from tbl_directory_staff_position inner join tbl_directory_positions on tbl_directory_staff_position.position_id = tbl_directory_positions.id
				where tbl_directory_staff_position.staffid = 4545 and
						tbl_directory_positions.section = "DC")
		as disc_coord_positions,
			(select group_concat(code_id)
				from crm_link_contact inner join crm_code on crm_link_contact.code_id = crm_code.id
				where fk_id=4545 and
						crm_code.name = 'category' and crm_code.description like 'Trainees - %')
		as categories
	FROM tbl_directory_staff
	WHERE tbl_directory_staff.staffid = 4545 
qry_council (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\include\dir_contact_view.cfm @ 10:59:04.004
	select crm_group.description
		from crm_group inner join crm_link_contact_group as link on crm_group.group_id = link.code_id
	where link.fk_id = 4545 


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:\www\aauapweb\aucd\directory\detailbio.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
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=www.aucd.org
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=/directory/detailbio.cfm
PATH_TRANSLATED=E:\www\aauapweb\aucd\directory\detailbio.cfm
QUERY_STRING=program=UCEDD&staffid=4545
REMOTE_ADDR=192.168.35.1
REMOTE_HOST=192.168.35.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/directory/detailbio.cfm
SERVER_NAME=www.aucd.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Client Variables:
cfid=24200739
cftoken=18377005
hitcount=1
lastvisit={ts '2015-03-05 10:59:04'}
timecreated={ts '2015-03-05 10:59:04'}
urltoken=CFID=24200739&CFTOKEN=18377005
Cookie Variables:
CFID=24200739
CFTOKEN=18377005
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=rcarman@AUCD.ORG
cfg_ecp_share=rcarman@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=shaworth@AUCD.ORG
cfg_email_digest_submission=acostalas@AUCD.ORG
cfg_email_hdd_submission=tchristensen@AUCD.ORG
cfg_email_lend_application_submission=rcarman@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=dedson@aucd.org, 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=24200739
cftoken=18377005
sessionid=AUCDWEBSITE_24200739_18377005
urltoken=CFID=24200739&CFTOKEN=18377005
URL Parameters:
program=UCEDD
staffid=4545
Debug Rendering Time: 24 ms