|
Debugging Information
Execution Time
SQL Queries qGetLangsDef (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\Application.cfm @ 05:39:40.040SELECT language_key, language_default, language_abbr FROM language WHERE language_default = ? Query Parameter Value(s) -qGetLangs (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\inc_page_head.cfm @ 05:39:40.040SELECT language_key, language_abbr FROM language WHERE language_key = ?; Query Parameter Value(s) -qGetLangs (Datasource=WaterWays, Time=0ms, Records=8) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm @ 05:39:40.040SELECT DISTINCT L.language_key, L.language_name, L.language_abbr FROM language L qGetLangs (Datasource=WaterWays, Time=16ms, Records=8) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc @ 05:39:40.040SELECT 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) -gget_page_info (Datasource=WaterWays, Time=0ms, Records=0) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc @ 05:39:40.040
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) -gget_page_info (Datasource=WaterWays, Time=0ms, Records=0) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc @ 05:39:40.040
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) -qGetContacts (Datasource=WaterWays, Time=0ms, Records=0) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm @ 05:39:40.040SELECT 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) -qGetlinks (Datasource=WaterWays, Time=0ms, Records=0) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc @ 05:39:40.040SELECT 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) -qGetPubs (Datasource=WaterWays, Time=0ms, Records=0) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc @ 05:39:40.040SELECT 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) -qGetbanners (Datasource=WaterWays, Time=0ms, Records=9) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_banner.cfm @ 05:39:40.040SELECT banner_image FROM banner WHERE banner_show = ? Query Parameter Value(s) -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/ForemanGradeI/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=14277515 CFTOKEN=bc318bca64fb628c-B4C0CC6D-BFBB-C141-83AAE85EB75FC4DA 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=/index.cfm/section/article/page/ForemanGradeI/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=banner2.jpg cfid=14277515 cftoken=bc318bca64fb628c-B4C0CC6D-BFBB-C141-83AAE85EB75FC4DA content=none language_abbr=EN language_key=1 sessionid=WATERWAYS_FRONTEND_LIVE_14277515_bc318bca64fb628c-B4C0CC6D-BFBB-C141-83AAE85EB75FC4DA suffix= surveys=Struct (0) urltoken=CFID=14277515&CFTOKEN=bc318bca64fb628c-B4C0CC6D-BFBB-C141-83AAE85EB75FC4DA user=Struct (0) user_id=0 user_ip=84.23.9.163 user_loggedin=0 URL Parameters: ARTICLE=0 CONTENT=none LANG=1 PAGE=ForemanGradeI PRINTFRIENDLY=true REGION=0 SECTION=article STARTROW=1Debug Rendering Time: 140 ms |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\index.cfm