| Scope Arguments | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| exception | 1 |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| onApplicationStart | 2 |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Debugging Information
Execution Time
Exceptions
Implicit variable Access
SQL Queries GetThema (Datasource=handwerk_cms, Time=4.18ms, Records=1) in I:\WWW\handwerk.ch\cms_select.cfm:11the following colum(s) are never read within the request:ThemaID,AuthObject,HauptThema,ThemaLink,ThemaTemplate,ThemaBild,Description,AnzSubKat SELECT ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE, AuthObject, AnzSubKat, Description AuthObject FROM Themen where ThemaID='Suche' and Phase='online' GetTopMenu (Datasource=handwerk_cms, Time=2.82ms, Records=7) in I:\WWW\handwerk.ch\cms_select.cfm:17the following colum(s) are never read within the request:ThemaLink,ThemaText,ThemaBild SELECT ThemaID, ThemaBild, ThemaName, ThemaText, ThemaLink, AnzSubKat, AuthObject FROM Themen where Hauptthema='TopMenu' and Phase='online' order by ThemaPrio GetArtikel (Datasource=handwerk_cms, Time=5.02ms, Records=0) in I:\WWW\handwerk.ch\cms_select.cfm:22the following colum(s) are never read within the request:Bild1,Link2,Text1,Titel,Link1,BIld2,ArtikelID,Text2 SELECT
Artikel.ArtikelID,
Artikel.Titel,
Artikel.Link1,
Artikel.Link2,
Artikel.Bild1,
Artikel.Bild2,
Artikel.Text1,
Artikel.Text2
FROM Artikel RIGHT JOIN (Themen LEFT JOIN Themen_Artikel ON Themen.ThemaID = Themen_Artikel.ThemaID) ON Artikel.ArtikelID = Themen_Artikel.ArtikelID
where Themen.ThemaID = 'Suche'
AND Artikel.Phase = 'online'
AND (Artikel.OnlineVon is null or Artikel.OnlineVon < {ts '2026-04-12 23:46:20'})
AND (Artikel.OnlineBis is null or Artikel.OnlineBis > {ts '2026-04-12 23:46:20'})
Order By Themen_Artikel.SortPos asc;
GetAds (Datasource=handwerk_cms, Time=2.19ms, Records=0) in I:\WWW\handwerk.ch\cms_select.cfm:67the following colum(s) are never read within the request:Bild1,Text1,Link1 select Bild1, Text1, Link1 from Artikel a inner join Themen_Artikel ta on (a.ArtikelID = ta.ArtikelID) where (ThemaID = 'ads') and (Phase = 'Online') order by SortPos asc GetSubKat (Datasource=handwerk_cms, Time=4.41ms, Records=6) in I:\WWW\handwerk.ch\cms_top.cfm:264the following colum(s) are never read within the request:AuthObject,ThemaLink,ThemaTemplate,ThemaText,ThemaBild,AnzSubKat SELECT ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE , AuthObject , AnzSubKat
FROM Themen
Where Themen.HauptThema = 'Angebot' and Themen.Phase='online'
order by ThemaPrio
GetSubKat (Datasource=handwerk_cms, Time=4.70ms, Records=2) in I:\WWW\handwerk.ch\cms_top.cfm:264the following colum(s) are never read within the request:AuthObject,ThemaLink,ThemaTemplate,ThemaText,ThemaBild,AnzSubKat SELECT ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE , AuthObject , AnzSubKat
FROM Themen
Where Themen.HauptThema = 'Ausschreibungen' and Themen.Phase='online'
order by ThemaPrio
GetSubKat (Datasource=handwerk_cms, Time=4.51ms, Records=6) in I:\WWW\handwerk.ch\cms_top.cfm:264the following colum(s) are never read within the request:AuthObject,ThemaLink,ThemaTemplate,ThemaText,ThemaBild,AnzSubKat SELECT ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE , AuthObject , AnzSubKat
FROM Themen
Where Themen.HauptThema = 'Ratgeber' and Themen.Phase='online'
order by ThemaPrio
GetEigenesFirmenprofil (Datasource=handwerk, Time=9.24ms, Records=1) in I:\WWW\handwerk.ch\h_seldata.cfm:1the following colum(s) are never read within the request:firma_homepage2,firma_titelzusatz_en,firma_titelzusatz_it,firma_titelzusatz_ru,firma_crm_ru,firma_adresse2,firma_eintritt,firma_titel_en,firma_titel_ru,firma_pager,firma_titel_de,firma_mod_user,firma_austritt,firma_FaxG,firma_titel_fr,firma_crm_it,firma_plz2,firma_crm_fr,firma_titelzusatz_de,firma_refid,firma_telD,firma_modifiziert,firma_titelzusatz_fr,firma_adresse_privat,firma_ort2,firma_titel_it,firma_kanton2,firma_land2,firma_adresszusatz2,firma_telG SELECT * FROM firmen WHERE firma_id = 18265 GetPortrait (Datasource=handwerk, Time=2.92ms, Records=1) in I:\WWW\handwerk.ch\h_seldata.cfm:52the following colum(s) are never read within the request:firma_status,firma_crm_de,firma_Feld2,firma_Feld1,firma_crm_en,firma_id,firma_mitglied,firma_Feld3 select firma_id, firma_crm_de, firma_crm_en, firma_portrait, firma_Feld1, firma_Feld2, firma_Feld3, firma_status, firma_mitglied from firmen where firmen.firma_id = 18265 GetPortraitLogo (Datasource=handwerk, Time=1.60ms, Records=0) in I:\WWW\handwerk.ch\h_seldata.cfm:56the following colum(s) are never read within the request:doc_DateiName,doc_PathName select doc_dateiname, doc_pathname from _Docs where Doc_name = '' Scope Variables Application Variables: ADMINURL=Admin ADMINVERSION=2024051601 applicationname=Handwerk AUFTRAGURL=http://test.handwerk.ch//docs/A/ COLLECTIONPATH=I:\WWW\handwerk.ch\verity COOKIECONSENTPOPUP=true CURRENCY2=EUR DATASOURCE=handwerk_cms DATASOURCE2=handwerk DATASOURCE_ADM=handwerk_cms DIRHM=I:\WWW\handwerk.ch\ DocsPath=docs FIRMAURL=http://test.handwerk.ch//docs/H/ FROM=handwerk.ch <news@handwerk.ch> HM=/ LZ=999 MaxRows=50 MENU=cms_MMenu.cfm MWST_INOROUT=Inklusive MYEMAIL=info@handwerk.ch MYPOS_URL=https://www.mypos.eu/vmp/checkout-test MYPOSSID=000000000000010 MYPOSURLCANCEL=http://test.handwerk.ch/shop_myPos_response.cfm?Cancel MYPOSURLNOTIFY=https://test.handwerk.ch/shop_myPos_response.cfm?Notify MYPOSURLOK=http://test.handwerk.ch/shop_myPos_response.cfm?OK MYPOSWALLETNUMBER=61938166610 MYURL=http://test.handwerk.ch/ NAME=Handwerk NMPATH=nm ORDERDOCUMENTBASEPATH=I:\WWW\handwerk.ch\orders ORDERDOCUMENTBASEURL=/orders PortoCH=0 PortoEU=0 RABATTBEZEICHNUNG=SuperDuper RABATTSATZ=0.33 REFCURRENCY=CHF REFLAND=CHE REFSPRACHE=-ch SHOP_MYPOS_KEYINDEX=1 SHOP_MYPOS_PRIVATECERT_PATH=converted_handwerk_mypos_private_key.pem SHOP_MYPOS_PUBLICCERT_PATH=converted_handwerk_mypos_public_key.pem SHOP_MYPOS_STOREID=114219 SHOP_MYPOS_URL=https://www.mypos.com/vmp/checkout SHOP_MYPOS_WALLETID=40071437194 SHOP_PAYPAL_MERCHID=AcXYX6RW241B2O0UbCVPtjx5j7zIy6yiRTV1T8-Royaw3trDYE4EaA6m4weD9_3MGR-ilTG8FJe655C2 SHOP_PAYPAL_SECRET=EG-UQGcYPJp8JfG6F6qXD9BL7qDrwpC2q2-FLdAsVYwDiaQCZfQIW8CQLXCBT11Q_lbPQKZBm-6_tUrO SHOP_PAYPAL_URL=https://api-m.paypal.com SHOP_RECHNUNG_BILD=docs/Angebot.png SHOP_RECHNUNG_CREDITORADDRESS1=Seefeldstrasse 94 SHOP_RECHNUNG_CREDITORCITY=Zurich SHOP_RECHNUNG_CREDITORLAND=CH SHOP_RECHNUNG_CREDITORNAME=Handwerk.ch GmbH SHOP_RECHNUNG_CREDITORNO= SHOP_RECHNUNG_CREDITORPOSTCODE=8008 SHOP_RECHNUNG_QRIBAN=CH0530000001607931348 SHOP_RECHNUNG_TEXT=PHN0eWxlPg0KLnN1YnRpdGxlMSB7DQoJZm9udC13ZWlnaHQ6MTAwOw0KCWZvbnQtc2l6ZToxM3B4CTsNCgljb2xvcjpibGFjazsNCgl0ZXh0LWFsaWduOiByaWdodDsNCgljbGVhcjpyaWdodDsNCn0NCi5zdWJ0aXRsZTIgew0KCWZvbnQtd2VpZ2h0OjEwMDsNCglmb250LXNpemU6MTNweAk7DQoJY29sb3I6IzgwODA4MDsNCgl0ZXh0LWFsaWduOiByaWdodDsNCgljbGVhcjpyaWdodDsNCn0NCjwvc3R5bGU+DQo8ZGl2Pg0KCQkJPGltZyBzcmM9Ii9kb2NzL0xvZ28tZGlyZWN0b3J5LXJnYi5qcGciIHN0eWxlPSJ3aWR0aDogMjAwLjAwcHg7IGhlaWdodDogNTAuMDBweDsgZmxvYXQ6bGVmdCIgdGl0bGU9IiI+DQoJCQk8cCBjbGFzcz0ic3VidGl0bGUxIj5IYW5kd2Vyay5jaCBHbWJIPC9wPg0KCQkJPHAgY2xhc3M9InN1YnRpdGxlMiI+U2VlZmVsZHN0cmFzc2UgOTQsIDgwMDggWsO8cmljaDwvcD4NCgkJCTxwIGNsYXNzPSJzdWJ0aXRsZTIiPlRlbC4gMDQ0IDM4MyAwMSAwMzwvcD4NCgkJCTxwIGNsYXNzPSJzdWJ0aXRsZTIiPmluZm9AaGFuZHdlcmsuY2ggPC9wPg0KCQkJPGJyPjxicj48YnI+DQoJCQkNCiAgICAgICAgPC9kaXY+ SHOPAKTION=n SHOPBCC=ap@trenka.ch shopFaceProperties=pdf editOrder report SHOPFROM=ap@trenka.ch SHOPPATH=shop SHOPTOCC=ap@trenka.ch SPAMcheckemail=Array (0) SPAMcheckIPs=Array (0) SPRACHEN=DE sprachen_lang_DE=Struct (382) STATUS=Open SURVEYACCOUNT=www.handwerk.ch SURVEYDB=handwerk_Survey SURVEYEMAIL=info@handwerk.ch SURVEYVIEW=survey.cfm TaxRate=0 TimeoutcheckIPs=Array (0) 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=I:\WWW\handwerk.ch\cms_default.cfm content_length= content_type= context_path= gateway_interface=CGI/1.1 http_accept=*/* http_accept_encoding=gzip, br, zstd, deflate http_accept_language= http_connection=keep-alive http_cookie= http_host=test.handwerk.ch http_referer= http_user_agent=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) https=off https_keysize= https_secretkeysize= https_server_issuer= https_server_subject= local_addr=193.16.211.5 local_host=Notos path_info= path_translated=I:\WWW\handwerk.ch\cms_default.cfm query_string=404;http://test.handwerk.ch:80/de/Suche/H/18265 remote_addr=216.73.216.223 remote_host=216.73.216.223 remote_user= request_method=GET request_url=http://test.handwerk.ch/cms_default.cfm?404;http://test.handwerk.ch:80/de/Suche/H/18265 script_name=/cms_default.cfm server_name=test.handwerk.ch server_port=80 server_port_secure=0 server_protocol=HTTP/1.1 server_software= web_server_api= Client Variables:
cfid=00b08245-f62d-46f5-90fe-db46a400eacd
cftoken=0
hitcount=1
lastvisit={ts '2026-04-12 23:46:20'}
timecreated={ts '2026-04-12 23:46:20'}
urltoken=CFID=00b08245-f62d-46f5-90fe-db46a400eacd&CFTOKEN=0
Cookie Variables: cfid=00b08245-f62d-46f5-90fe-db46a400eacd cftoken=0 Server Variables: CMSMASTER=Struct (2) coldfusion=Struct (9) counters=Struct (34) form_ipaddress= form_value= java=Struct (9) lucee=Struct (9) os=Struct (8) separator=Struct (3) servlet=Struct (1) SPAM_App_Blacklist_Query=Query (0) SPAM_Blacklist_Query=Query (1598) SPAM_RequestBlock_Query=Query (8) SPAM_Sync=Struct (4) SPAM_Whitelist_Query=Query (13) system=Struct (2) Session Variables:
ActAppl=CMSmaster
Address1=
Address2=
ADS=Query (0)
Bemerkungen=
CardName=
CardNum=0000 0000 0000 1234
CardNum2=000
CardTyp=
CartID=ACD83FBC-6CF5-4302-B8443F5A3097A2A8
cfid=00b08245-f62d-46f5-90fe-db46a400eacd
cftoken=0
City=
CompanyName=
DocsPath=I:\WWW\handwerk.ch\docs\H\18265\
DOCSURL=http://test.handwerk.ch/docs/H/18265/
dollarkurs=1
dtOrdDate=
EditMode=fckeditor
Email=
Eurokurs=1
Expires={ts '2026-04-12 23:46:20'}
Fax=
firma_adresse=
firma_adresszusatz=
firma_anrede=
FIRMA_BRIEFANREDE=
firma_crm_de=
firma_crm_en=
firma_email=
FIRMA_EMAIL2=
firma_fax=027 939 22 31
firma_faxG=
firma_feld1=
firma_feld2=
firma_feld3=
firma_feld4=46.4022173,7.782755599999973
firma_feld5=
firma_homepage=
firma_homepage2=
firma_id=18265
firma_kanton=VS
firma_land=
firma_mitglied=false
firma_mob=
firma_nachname=
firma_name=Rieder & Ritler AG
firma_ort=Wiler (Lötschen)
firma_passwort=
firma_plz=3918
firma_portrait=
firma_portrait_id=
firma_sprache=
FIRMA_SPRACHEN=
firma_status=H1S06
firma_tel=027 939 11 36
firma_telD=
firma_telG=
firma_userid=
firma_vorname=
FirstName=
h_logton_Attribute=
h_logton_userid=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
IPADDR=216.73.216.223
JumpBack2=shop_payment.cfm
LAddress1=
LAddress2=
Land=
LastName=
lastvisit={ts '2026-04-12 23:46:20'}
LCity=
LCompanyName=
LFirstName=
LLand=
LLastName=
logton=
LPostCode=
Password=
payart=Rechnung
Phone=
PostCode=
Profil=true
Profilfound=true
PswdConfirm=
RabattSatz=20
SaveKkA=0
SearchPremium=
sessionid=Handwerk_00b08245-f62d-46f5-90fe-db46a400eacd_0
SESSSTARTTIME={ts '2026-04-12 23:46:20'}
SPRACHE=de
strCustID=
THEMAID=Suche
timecreated={ts '2026-04-12 23:46:20'}
urltoken=CFID=00b08245-f62d-46f5-90fe-db46a400eacd&CFTOKEN=0
UserName=---
whitelisted=true
URL Variables: 404;http://test=Struct (1) 404;http://test.handwerk.ch:80/de/Suche/H/18265=Debug Rendering Time: 0.00ms |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||