Total Time	Avg Time	Count	Template
250 ms	250 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\regions\inc_region_page.cfm
250 ms	250 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\shannon\index.cfm
188 ms	188 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\regions\inc_region_info.cfm
63 ms	63 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\Application.cfm
31 ms	31 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\inc_page_head.cfm
16 ms	16 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 117, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
16 ms	16 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 119, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
16 ms	16 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 141, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
16 ms	16 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 161, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
16 ms	16 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm
16 ms	16 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\regions\inc_queries.cfm
15 ms	15 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 113, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 100, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 106, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 112, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 114, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 115, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 116, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 118, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 120, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 145, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 156, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 170, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 173, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 99, method = link_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc
0 ms	0 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\OnRequestEnd.cfm
0 ms	0 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_banner.cfm
0 ms	0 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\sesConverter.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
313 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

		SELECT language_key, language_default, language_abbr
		FROM language
		WHERE language_default = ? 

			SELECT language_key, language_abbr
			FROM language
			WHERE language_key = ?;
		

	SELECT DISTINCT L.language_key, L.language_name, L.language_abbr
	FROM  language L

				SELECT    R.region_map_image, R.region_coords, R.region_folder, RL.region_lang_name AS region_name
				FROM region R 
					INNER JOIN region_lang RL ON R.region_key = RL.region_key
				WHERE RL.language_key = ?
				ORDER BY R.region_order ASC
			

					SELECT region_map_image, region_coords, region_name, region_folder
					FROM region
					ORDER BY region_order ASC
				

				SELECT MF.FEATURE_Content, MF.FEATURE_Name, F.FEATURE_associatedPage, F.FEATURE_Key
				FROM FEATURE F 
					INNER JOIN MAIN_FEATURE MF ON F.FEATURE_Key = MF.FEATURE_Key
				WHERE MF.LANGUAGE_Key = ?
					AND F.FEATURE_DateActivated <= getDate() 
					AND F.FEATURE_DateArchived > getDate()
					AND  F.FEATURE_Archive = ? 

		SELECT banner_image
		FROM banner
		WHERE banner_show = ? 

		SELECT * 
		FROM MAP
		WHERE region_key = ? 

		SELECT region_video_file
		FROM region_video
		WHERE region_key = ? 

		SELECT L.link_key
		FROM LINK L  
			INNER JOIN LINKVSREGION LR ON L.link_key = LR.LINK_KEY 
			INNER JOIN LINKVSDEPLOYMENT LD ON L.link_key = LD.link_key
		WHERE (LR.region_key = ?)
			AND (LD.deployment_key = ?)
	

		SELECT  E.event_key, E.event_startdate
		FROM  EVENTS E 
			INNER JOIN EVENTVSPLACE EP ON E.event_key = EP.event_key 
			INNER JOIN PLACE P ON EP.place_key = P.place_key 
			INNER JOIN EVENTVSDEPLOYMENT ED ON E.event_key = ED.event_key
		WHERE (P.region_key = ?)
			AND (ED.deployment_key = ?)
			
			AND E.event_live_date <= getdate()
			AND E.event_archive_date >= getdate()
		GROUP BY E.event_key, E.event_startdate
		ORDER BY E.event_startdate
	

		SELECT  E.event_key, E.event_startdate
		FROM  EVENTS E 
			INNER JOIN EVENTVSPLACE EP ON E.event_key = EP.event_key 
			INNER JOIN PLACE P ON EP.place_key = P.place_key 
			INNER JOIN EVENTVSDEPLOYMENT ED ON E.event_key = ED.event_key
		WHERE (P.region_key = ?)
			AND (ED.deployment_key = ?)
			AND E.event_start_month <= 8 --->
			 AND E.event_end_month >= 8 --->
			AND E.event_live_date <= getdate()
			AND E.event_archive_date >= getdate()
		GROUP BY E.event_key, E.event_startdate
		ORDER BY E.event_startdate
	

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

			SELECT     ML.link_name, L.link_key, L.link_url
			FROM  LINK L 
				INNER JOIN MAIN_LINK ML ON L.link_key = ML.link_key
			WHERE L.link_key = ?
				AND ML.language_key = ?
		

Application Variables:
applicationname=WaterWays_FrontEnd_LIVE
lang=Struct (4)
language_list=EN,IR,FR,ES,NO,SC,IT,DE

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=D:\waterwaysireland\1.waterways.biznetservers.com\www_root\shannon\index.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=
HTTP_ACCEPT_ENCODING=deflate, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.waterwaysireland.org
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/calendarDate/19-Aug-2008/printfriendly/true/lang/1/content/none
PATH_TRANSLATED=D:\waterwaysireland\1.waterways.biznetservers.com\www_root\shannon\index.cfm
QUERY_STRING=
REMOTE_ADDR=84.23.9.163
REMOTE_HOST=84.23.9.163
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/shannon/index.cfm
SERVER_NAME=www.waterwaysireland.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=

Cookie Variables:
CFID=14275612
CFTOKEN=880bb70eda29e992-B46B4A88-BF78-74B4-883096D06503F367

Request Parameters:
adminpriv=1
application=Struct (1)
banner_default=banner1
banner_url=/images
bar_color=#537595
basehref=http://www.waterwaysireland.org/
breadcrumb=true
color_list=#E84D4D,#E8BB4D,#4D77D6,#B1D64D,#9F68B1,#BC549D,#65ABAA,#3FD15B,#E8E34C
compname=Waterways Ireland
component_path=components
contactaddress=info@waterwaysireland.org
contacts_url=/index.cfm/section/contacts
customer_feedback=/index.cfm?section=customer
customerfrom=info@waterwaysireland.org
deployment_key=1
dsn=WaterWays
encrypt_key=124789547
event_url=/index.cfm/section/events
expire_days=7
faq_submit_url=/index.cfm?section=faqsubmit
faq_url=/index.cfm/section/faq
faqfrom=info@waterwaysireland.org
formformat=flash
formskin=haloBlue
icon_path=/icon
image_path=/uploads/images/
language_abbr=EN
language_key=1
mailport=25
mailserver=jim.biztechnet.com
map_events_no=5
map_url=/map
mappath=wiroot
masterdsn=WaterWaysMaster
mastersite=1
mastersiteurl=http://www.waterwaysireland.org
notsafeurllist=postcard,faqsubmit,customer
onrequest_path=
pagetitle=Waterways Ireland ePortal
parentkeylist=
printformat=PDF
printsize=A4
pub_path=/uploads/docs/pubs
publications_url=/index.cfm/section/publications
replaceand=/
replaceequal=/
replacequestion=/
resource_path=\resource_bundles\
session=Struct (10)
site_path=D:\waterwaysireland\1.waterways.biznetservers.com\www_root
site_url=http://www.waterwaysireland.org
siteemail=info@waterwaysireland.org
survey_menu_url=/index.cfm/section/surveys
survey_url=/index.cfm
thispage=/shannon/index.cfm/calendarDate/19-Aug-2008/printfriendly/true/lang/1/content/none
title=Waterways Ireland ePortal
type_check=1
type_drop=4
type_radio=2
type_text=3
ultraseek=http://search.biznetservers.com
ultraseek_menu=/common
ultraseek_path=\verity
userlang=request.application.lang.EN.
videoclip_url=/video_clips
website_key=1

Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)

Session Variables:
banner=banner5.jpg
cfid=14275612
cftoken=880bb70eda29e992-B46B4A88-BF78-74B4-883096D06503F367
content=none
language_abbr=EN
language_key=1
sessionid=WATERWAYS_FRONTEND_LIVE_14275612_880bb70eda29e992-B46B4A88-BF78-74B4-883096D06503F367
suffix=
surveys=Struct (0)
urltoken=CFID=14275612&CFTOKEN=880bb70eda29e992-B46B4A88-BF78-74B4-883096D06503F367
user=Struct (0)
user_id=0
user_ip=84.23.9.163
user_loggedin=0

URL Parameters:
ARTICLE=0
CALENDARDATE=19-Aug-2008
CONTENT=none
LANG=1
PAGE=none
PRINTFRIENDLY=true
REGION=0
SECTION=Home
STARTROW=1