|
Debugging Information
Execution Time
SQL Queries qGetLangsDef (Datasource=WaterWays, Time=16ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\Application.cfm @ 07:26:30.030SELECT 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 @ 07:26:30.030SELECT 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 @ 07:26:30.030SELECT DISTINCT L.language_key, L.language_name, L.language_abbr FROM language L qGetcontacts (Datasource=WaterWays, Time=0ms, Records=2) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm @ 07:26:30.030SELECT DISTINCT C.contact_key, C.contact_name, C.contact_business_name, C.contact_address_1, C.contact_address_2, C.contact_address_3, C.contact_telephone, C.contact_email_address, C.contact_additional_details, C.contact_image, C.contact_alt, C.contact_descriptimg, P.place_name, P.place_key, C.contact_postcode, C.contact_mobile, C.contact_fax FROM CONTACT C INNER JOIN CONTACTVSDEPLOYMENT CD ON C.contact_key = CD.contact_key LEFT OUTER JOIN PLACE P ON C.place_key = P.place_key LEFT OUTER JOIN CONTACTVSCONTACTTYPE CCT ON C.contact_key = CCT.contact_key WHERE CD.deployment_key = ? AND left(contact_business_name, 1) = ? AND CCT.contacttype_key = ? Query Parameter Value(s) -qGetbanners (Datasource=WaterWays, Time=0ms, Records=9) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_banner.cfm @ 07:26:30.030SELECT banner_image FROM banner WHERE banner_show = ? Query Parameter Value(s) -ggetcon_type (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\page.cfc @ 07:26:30.030SELECT MC.contacttype, C.contacttype_key, MC.language_key FROM CONTACTTYPE C INNER JOIN MAIN_CONTACTTYPE MC ON C.contacttype_key = MC.contacttype_key WHERE MC.Language_key = ? AND C.contacttype_key = ? 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/contacts/letter/O/type/9/place/0/page/none/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=14280673 CFTOKEN=b8306cb35e09d55c-B52299A8-C6D1-FB09-8A15453730912898 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/contacts/letter/O/type/9/place/0/page/none/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=14280673 cftoken=b8306cb35e09d55c-B52299A8-C6D1-FB09-8A15453730912898 content=none language_abbr=EN language_key=1 sessionid=WATERWAYS_FRONTEND_LIVE_14280673_b8306cb35e09d55c-B52299A8-C6D1-FB09-8A15453730912898 suffix= surveys=Struct (0) urltoken=CFID=14280673&CFTOKEN=b8306cb35e09d55c-B52299A8-C6D1-FB09-8A15453730912898 user=Struct (0) user_id=0 user_ip=84.23.9.163 user_loggedin=0 URL Parameters: ARTICLE=0 CONTENT=none LANG=1 LETTER=O PAGE=none PLACE=0 PRINTFRIENDLY=true REGION=0 SECTION=contacts STARTROW=1 TYPE=9Debug Rendering Time: 125 ms |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\index.cfm