Debugging Information
| ColdFusion Server Standard |
7,0,2,142559 |
| Template |
/index.cfm |
| Time Stamp |
03-Dec-08 03:05 AM |
| Locale |
English (UK) |
| User Agent |
ColdFusion |
| Remote IP |
84.23.9.163 |
| Host Name |
84.23.9.163 |
Execution Time
| Total Time |
Avg Time |
Count |
Template |
| 125 ms |
125 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\inc_page_head.cfm |
| 125 ms |
125 ms |
1 |
 D:\waterwaysireland\1.waterways.biznetservers.com\www_root\index.cfm |
| 94 ms |
94 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm |
| 31 ms |
31 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_banner.cfm |
| 16 ms |
16 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc | page_info(exten = 2005PressRelease, 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 = 2005PressRelease) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc |
| 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-44422F7A-C41F-60B0-6C21EC9C268CB687) ] 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-44422F7A-C41F-60B0-6C21EC9C268CB687) ] 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\cleanup.cfm |
| 0 ms |
0 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_content.cfm |
| 0 ms |
0 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_getArticle.cfm |
| 0 ms |
0 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\sesConverter.cfm |
| 16 ms | |
STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN |
| 156 ms | |
TOTAL EXECUTION TIME |
red = over 250 ms average execution time
SQL Queries
qGetLangsDef (Datasource=WaterWays, Time=15ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\Application.cfm @ 03:05:17.017
SELECT language_key, language_default, language_abbr
FROM language
WHERE language_default = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_BIT) = YES
qGetLangs (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\inc_page_head.cfm @ 03:05:17.017
SELECT language_key, language_abbr
FROM language
WHERE language_key = ?;
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
qGetLangs (Datasource=WaterWays, Time=0ms, Records=8) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm @ 03:05:17.017
SELECT DISTINCT L.language_key, L.language_name, L.language_abbr
FROM language L
qGetLangs (Datasource=WaterWays, Time=16ms, Records=2) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc @ 03:05:17.017
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 = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2005PressRelease
Parameter #2(CF_SQL_BIT) = NO
Parameter #3(CF_SQL_BIT) = NO
Parameter #4(CF_SQL_INTEGER) = 1
gget_page_info (Datasource=WaterWays, Time=16ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc @ 03:05:17.017
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)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_BIT) = NO
Parameter #4(CF_SQL_BIT) = NO
Parameter #5(CF_SQL_VARCHAR) = 2005PressRelease
Parameter #6(CF_SQL_INTEGER) = 1
Parameter #7(CF_SQL_DATE) = {ts '2008-12-03 00:00:00'}
qGetContacts (Datasource=WaterWays, Time=0ms, Records=0) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm @ 03:05:17.017
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 = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_VARCHAR) = WatWayIre-CMS-44422F7A-C41F-60B0-6C21EC9C268CB687
qGetlinks (Datasource=WaterWays, Time=0ms, Records=0) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc @ 03:05:17.017
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 = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_VARCHAR) = WatWayIre-CMS-44422F7A-C41F-60B0-6C21EC9C268CB687
qGetPubs (Datasource=WaterWays, Time=0ms, Records=0) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc @ 03:05:17.017
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))
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_VARCHAR) = WatWayIre-CMS-44422F7A-C41F-60B0-6C21EC9C268CB687
qCheckIfVersion (Datasource=WaterWays, Time=16ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm @ 03:05:17.017
SELECT *
FROM Versions
WHERE Versions.Version_Page_Key = 1197
qGetOriginal (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm @ 03:05:17.017
SELECT Pages.Page_DateCreated
FROM Pages
WHERE Pages.Page_Key = 896
qGetAllVersions (Datasource=WaterWays, Time=0ms, Records=2) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm @ 03:05:17.017
SELECT *
FROM Versions
WHERE Page_Key = 896
ORDER BY Version_Key Desc
qGetbanners (Datasource=WaterWays, Time=0ms, Records=9) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_banner.cfm @ 03:05:17.017
SELECT banner_image
FROM banner
WHERE banner_show = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_BIT) = YES
Scope Variables
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/2005PressRelease/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=13642343
CFTOKEN=cf8524832fafb755-FACE8310-BA41-282B-1F62C065CB9F71B0
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/2005PressRelease/printfriendly/true/lang/1/content/none
title=2005 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=banner4.jpg
cfid=13642343
cftoken=cf8524832fafb755-FACE8310-BA41-282B-1F62C065CB9F71B0
content=none
language_abbr=EN
language_key=1
sessionid=WATERWAYS_FRONTEND_LIVE_13642343_cf8524832fafb755-FACE8310-BA41-282B-1F62C065CB9F71B0
suffix=
surveys=Struct (0)
urltoken=CFID=13642343&CFTOKEN=cf8524832fafb755-FACE8310-BA41-282B-1F62C065CB9F71B0
user=Struct (0)
user_id=0
user_ip=84.23.9.163
user_loggedin=0
URL Parameters:
ARTICLE=0
CONTENT=none
LANG=1
PAGE=2005PressRelease
PRINTFRIENDLY=true
REGION=0
SECTION=article
STARTROW=1
Debug Rendering Time: 125 ms
|
