Total Time	Avg Time	Count	Template
141 ms	141 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\index.cfm
125 ms	125 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm
125 ms	125 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\inc_page_head.cfm
47 ms	47 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | page_info(exten = PressReleases, dsn = WaterWays, lang_key = 1) ] 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 | page_langs(dsn = WaterWays, exten = PressReleases) ] 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\cleanup.cfm
16 ms	16 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_content.cfm
16 ms	16 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_getArticle.cfm
15 ms	15 ms	1	D:\waterwaysireland\1.waterways.biznetservers.com\www_root\Application.cfm
0 ms	0 ms	1	CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | page_links(deploy_key = 1, dsn = WaterWays, page_id = WatWayIre-CMS-708C0B5C-BA25-DB75-C96AEA68A399EB91) ] 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 | page_pubs(deploy_key = 1, dsn = WaterWays, page_id = WatWayIre-CMS-708C0B5C-BA25-DB75-C96AEA68A399EB91) ] 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
16 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
172 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 DISTINCT L.language_name, L.language_key, L.language_abbr
			FROM Pages P 
				INNER JOIN pagesVslanguage PL ON P.Page_Key = PL.Page_key 
				INNER JOIN language L ON PL.language_key = L.language_key
			WHERE (P.Page_Extension = ?) 
				AND (P.Page_Archived = ?) 
				AND (P.Page_Deleted = ?)
				AND (P.Page_Status = ?)
		

			SELECT P.Page_Key, P.Page_Identity, P.Page_Extension, P.Page_ContentExpires, P.Page_OrigDate, P.Page_DateCreated, P.Page_Url, P.Template_Key, 
                      P.Property_Key, P.Website_Key, P.User_Key, P.AltUser, P.ViewCount, U.UserFirstName, U.UserLastName, U.User_Key, PP.*, S.*, 
                      MP.Page_Name, MP.Page_Title, MP.Page_Description, MP.Page_Keywords, 
                      MP.Page_SubjectCategory, MP.Page_Coverage, MP.Page_Content
			FROM  Pages P 
				INNER JOIN UserPrivileges UP ON P.Page_Approval = UP.UserPrivilege_Key 
				INNER JOIN Structure S ON P.Page_Key = S.Page_Key 
				INNER JOIN Properties PP ON P.Property_Key = PP.Property_Key 
				INNER JOIN Users U ON P.User_Key = U.User_Key 
				INNER JOIN main_page MP ON P.Page_Key = MP.Page_Key
			WHERE  
				 (P.Page_Status = ?) 
				AND (UP.UserPrivilege_Order = ?) 
				AND (P.Page_Archived =  ?) 
				AND (P.Page_Deleted = ?) 
				AND (P.Page_Extension = ?) 
				AND (MP.language_key = ?)
				
				AND (P.page_contentexpires > ? OR page_contentexpires IS NULL)
			

				SELECT C.contact_key, C.contact_name, C.contact_business_name, C.contact_email_address
				FROM CONTACT C 
					INNER JOIN PagesVsContact PC ON C.contact_key = PC.contact_key
					INNER JOIN CONTACTVSDEPLOYMENT CD ON C.contact_key = CD.contact_key
				WHERE CD.deployment_key = ?
					AND PC.page_identity = ? 

			SELECT L.link_key
			FROM LINK L 
				INNER JOIN LINKVSDEPLOYMENT LD ON L.link_key = LD.link_key
				INNER JOIN pageVsLink PL ON L.link_key = PL.link_key
			WHERE LD.deployment_key = ?
				AND PL.page_identity = ?
		

			SELECT P.publication_key
			FROM  PUBLICATION P 
				INNER JOIN  PagesVsPublication PP ON P.publication_key = PP.PUBLICATION_Key 
				INNER JOIN PUBLICATIONVSDEPLOYMENT PD ON P.publication_key = PD.PUBLICATION_Key
			WHERE PD.deployment_key = ?
				AND PP.page_identity = ?
				AND (P.publication_embargodate <= getdate() AND (P.publication_killdate >=  getdate() OR publication_killdate_active = 0))
		

				SELECT 	*
				FROM	Versions
				WHERE	Versions.Version_Page_Key = 2186 

					SELECT 	Pages.Page_DateCreated
					FROM	Pages
					WHERE	Pages.Page_Key = 249 

					SELECT 	*
					FROM	Versions
					WHERE	Page_Key = 249
					ORDER	BY Version_Key Desc
					

		SELECT banner_image
		FROM banner
		WHERE banner_show = ? 

Application Variables:
applicationname=WaterWays_FrontEnd_LIVE
lang=Struct (8)
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\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=/section/article/page/PressReleases/printfriendly/true/lang/1/content/none
PATH_TRANSLATED=D:\waterwaysireland\1.waterways.biznetservers.com\www_root\index.cfm
QUERY_STRING=
REMOTE_ADDR=84.23.9.163
REMOTE_HOST=84.23.9.163
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/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=13619448
CFTOKEN=ca4327176be3600f-F5A952AF-B15F-2EB5-97E0BD75A9B52609

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
h1=Site Page
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=/index.cfm/section/article/page/PressReleases/printfriendly/true/lang/1/content/none
title=Press Releases | 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=banner2.jpg
cfid=13619448
cftoken=ca4327176be3600f-F5A952AF-B15F-2EB5-97E0BD75A9B52609
content=none
language_abbr=EN
language_key=1
sessionid=WATERWAYS_FRONTEND_LIVE_13619448_ca4327176be3600f-F5A952AF-B15F-2EB5-97E0BD75A9B52609
suffix=
surveys=Struct (0)
urltoken=CFID=13619448&CFTOKEN=ca4327176be3600f-F5A952AF-B15F-2EB5-97E0BD75A9B52609
user=Struct (0)
user_id=0
user_ip=84.23.9.163
user_loggedin=0

URL Parameters:
ARTICLE=0
CONTENT=none
LANG=1
PAGE=PressReleases
PRINTFRIENDLY=true
REGION=0
SECTION=article
STARTROW=1