Shopping cart to change


There are currently no items in your shopping cart



< back
This website uses cookies. More Information OK!

Debugging Information
Lucee (Gelert) Os 6.2.1.122 (CFML Version 2016,0,03,300357)
Template http://test.step-geneva.org/shop_warenkorb.cfm
I:\WWW\step-geneva.org\shop_warenkorb.cfm
Time Stamp 1 Jul 2025 18:02
Time Zone Europe/Zurich
Locale En_ch
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 216.73.216.39
Host Name test.step-geneva.org
Architecture 64bit

Execution Time

Total Time Avg Time Count Template
2.68ms 2.68ms 1 I:\WWW\step-geneva.org\cms_select.cfm
2.24ms 2.24ms 1 I:\WWW\step-geneva.org\i_header_navbar.cfm
4.71ms 4.71ms 1 I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm
4.30ms 4.30ms 1 I:\WWW\step-geneva.org\admin\common\shop_mwst_i.cfm
1.21ms 1.21ms 1 I:\WWW\step-geneva.org\admin\common\cms_sprachwahl.cfm
0.84ms 0.84ms 1 I:\WWW\step-geneva.org\admin\spam\com_user_counter.cfm
0.70ms 0.70ms 1 I:\WWW\step-geneva.org\i_bottom_text.cfm
0.55ms 0.55ms 1 I:\WWW\step-geneva.org\admin\common\shop_begin.cfm
0.06ms 0.06ms 1 I:\WWW\step-geneva.org\Application.cfc
0.05ms 0.05ms 1 I:\WWW\step-geneva.org\com_variablen.cfm
0.05ms 0.05ms 1 I:\WWW\step-geneva.org\i_headers.cfm
0.04ms 0.04ms 1 I:\WWW\step-geneva.org\shop_mwst_i.cfm
0.03ms 0.03ms 1 I:\WWW\step-geneva.org\admin\common\cms_bottom.cfm
0.01ms 0.01ms 1 I:\WWW\step-geneva.org\cms_sprachwahl.cfm
0.01ms 0.01ms 1 I:\WWW\step-geneva.org\WEB-INF\lucee\components\org\lucee\cfml\Component.cfc
0.01ms 0.01ms 1 I:\WWW\step-geneva.org\i_cookie_consent.cfm
0.00ms 0.00ms 1 I:\WWW\step-geneva.org\i_cms.cfm
0.00ms 0.00ms 1 I:\WWW\step-geneva.org\i_google_analytics.cfm
0.00ms 0.00ms 1 I:\WWW\step-geneva.org\i_javascript_funktionen.cfm
0.00ms 0.00ms 1 I:\WWW\step-geneva.org\com_redirecter.cfm
0.00ms 0.00ms 1 I:\WWW\step-geneva.org\i_javascripts.cfm
0.00ms 0.00ms 1 I:\WWW\step-geneva.org\shop_warenkorb.cfm
0.00ms 0.00ms 1 I:\WWW\step-geneva.org\shop_begin.cfm
0.00ms 0.00ms 1 I:\WWW\step-geneva.org\cms_bottom.cfm
0.00ms 0.00ms 1 I:\WWW\step-geneva.org\cms_top.cfm
0.00ms 0.00ms 1 I:\WWW\step-geneva.org\admin\common\cms_top.cfm
0.00ms 0.00ms 1 I:\WWW\step-geneva.org\Application.cfc$onrequeststart
2.41ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1.16ms  APPLICATION EXECUTION TIME
5.02ms  QUERY EXECUTION TIME
8.60ms  TOTAL EXECUTION TIME
red = over 250.00ms average execution time

Implicit variable Access

Scope Template Line Var Count
variables I:\WWW\step-geneva.org\Application.cfc 51 TEMPLATE 1
cgi I:\WWW\step-geneva.org\admin\common\shop_begin.cfm 19 HTTP_REFERER 1
cgi I:\WWW\step-geneva.org\admin\common\shop_begin.cfm 20 HTTP_REFERER 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 18 attributes 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 19 attributes 2
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 25 LOGFILE 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 27 ATTRIBUTES 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 29 FORM_IPADDRESS 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 35 global_whitelist 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 35 cfquery 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 36 GLOBAL_WHITELIST 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 37 GLOBAL_WHITELIST 10
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 37 FORM_IPADDRESS 10
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 50 ATTRIBUTES 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 64 ATTRIBUTES 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 65 global_blacklist 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 65 cfquery 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 68 GLOBAL_BLACKLIST 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 84 cfquery 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 84 global_request_block 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 85 global_request_block 1
variables I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm 87 GLOBAL_REQUEST_BLOCK 7
variables I:\WWW\step-geneva.org\admin\spam\com_user_counter.cfm 32 ENCODING 1
variables I:\WWW\step-geneva.org\admin\spam\com_user_counter.cfm 33 ENCODING 2
variables I:\WWW\step-geneva.org\admin\spam\com_user_counter.cfm 34 ENCODING 1
variables I:\WWW\step-geneva.org\admin\spam\com_user_counter.cfm 35 ENCODING 1
query I:\WWW\step-geneva.org\i_bottom_text.cfm 31 THEMALINK 7
query I:\WWW\step-geneva.org\i_header_navbar.cfm 42 ANZSUBKAT 8
query I:\WWW\step-geneva.org\i_header_navbar.cfm 42 THEMANAME 6
query I:\WWW\step-geneva.org\i_header_navbar.cfm 42 THEMATEMPLATE 6
query I:\WWW\step-geneva.org\i_header_navbar.cfm 47 THEMALINK 8
query I:\WWW\step-geneva.org\i_header_navbar.cfm 48 THEMAID 8
query I:\WWW\step-geneva.org\i_header_navbar.cfm 49 THEMATEXT 4
query I:\WWW\step-geneva.org\i_header_navbar.cfm 52 THEMAID 4
query I:\WWW\step-geneva.org\i_header_navbar.cfm 52 THEMALINK 4
query I:\WWW\step-geneva.org\i_header_navbar.cfm 53 THEMATEXT 4
query I:\WWW\step-geneva.org\i_header_navbar.cfm 57 ANZSUBKAT 8
query I:\WWW\step-geneva.org\i_header_navbar.cfm 57 THEMANAME 6
query I:\WWW\step-geneva.org\i_header_navbar.cfm 57 THEMATEMPLATE 6
query I:\WWW\step-geneva.org\i_header_navbar.cfm 61 THEMAID 4
query I:\WWW\step-geneva.org\i_header_navbar.cfm 65 THEMALINK 12
query I:\WWW\step-geneva.org\i_header_navbar.cfm 66 THEMALINK 4
query I:\WWW\step-geneva.org\i_header_navbar.cfm 68 THEMAID 8
query I:\WWW\step-geneva.org\i_header_navbar.cfm 70 THEMATEXT 12

SQL Queries

global_whitelist (Datasource=global_master, Time=0.00ms, Records=10) in I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm:33
the following colum(s) are never read within the request:created,text,id
SELECT * FROM global_whitelist
global_blacklist (Datasource=global_master, Time=0.00ms, Records=0) in I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm:62
the following colum(s) are never read within the request:id
SELECT id FROM global_blacklist 
				WHERE   ipaddress='216.73.216.39'
global_request_block (Datasource=global_master, Time=0.00ms, Records=7) in I:\WWW\step-geneva.org\admin\spam\com_block_check.cfm:82
the following colum(s) are never read within the request:created,field,id
SELECT * FROM global_remote_text_block
GetThema (Datasource=step-geneva, Time=6.25ms, Records=0) in I:\WWW\step-geneva.org\cms_select.cfm:24
the following colum(s) are never read within the request:ThemaContentArt,AuthObject,ThemaSubKategorie,HauptThema,ThemaLink,ThemaTemplate,ThemaText,ThemaBild,ThemaFunktion,AnzSubKat
SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE, AuthObject, AnzSubKat, Description, AuthObject, PageTitle, ThemaKeyWords, LastChangeTime, ThemaContentArt, ThemaSubkategorie, ThemaFunktion
				FROM         Themen 
				where ThemaID='de-Produkte' and Phase='online' order by ThemaPrio
GetMenu1 (Datasource=step-geneva, Time=3.42ms, Records=8) in I:\WWW\step-geneva.org\cms_select.cfm:30
the following colum(s) are never read within the request:ThemaBild
SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, ThemaLink, THEMATEMPLATE, AnzSubKat
				FROM         Themen
				where Hauptthema='enmenu1' and Phase='online' order by ThemaPrio
GetHauptMenu (Datasource=step-geneva, Time=3.75ms, Records=0) in I:\WWW\step-geneva.org\cms_select.cfm:36
the following colum(s) are never read within the request:ThemaID,AuthObject,ThemaName,ThemaLink,ThemaText,ThemaBild,PageTitle,AnzSubKat
SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, ThemaLink, AnzSubKat, AuthObject, PageTitle
				FROM         Themen 
				where Hauptthema='en-HauptMenu' and Phase='online' order by ThemaPrio
GetUnterNav (Datasource=step-geneva, Time=3.13ms, Records=7) in I:\WWW\step-geneva.org\cms_select.cfm:42
the following colum(s) are never read within the request:ThemaID,ThemaName,ThemaTemplate,ThemaBild
SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, ThemaLink, THEMATEMPLATE, AnzSubKat
				FROM         Themen
				where Hauptthema='enUntereNavigation' and Phase='online' order by ThemaPrio
GetArtikel (Datasource=step-geneva, Time=7.01ms, Records=0) in I:\WWW\step-geneva.org\cms_select.cfm:49
the following colum(s) are never read within the request:Link2,Bild1,Text1,Titel,AendernZeit,ErstelltUser,ErstellZeit,Link1,OnlineVon,Bild2,ArtikelID,Text2,AdminText
SELECT      
			Artikel.ArtikelID, 
			Artikel.Titel, 
			Artikel.Link1, 
			Artikel.Bild1, 
			Artikel.Text1, 
			Artikel.Text2,
			Artikel.Link2,
			Artikel.Bild2,
			Artikel.ErstellZeit,
			Artikel.AendernZeit,
			Artikel.ErstelltUser,
			Artikel.OnlineVon,
			Artikel.AdminText
			FROM Artikel RIGHT JOIN (Themen LEFT JOIN Themen_Artikel ON Themen.ThemaID = Themen_Artikel.ThemaID) ON Artikel.ArtikelID = Themen_Artikel.ArtikelID
			where Themen.ThemaID = 'de-Produkte'
			AND Artikel.Phase = 'online' 
			AND (Artikel.OnlineVon is null or Artikel.OnlineVon < {ts '2025-07-01 18:02:17'})
			AND (Artikel.OnlineBis is null or Artikel.OnlineBis > {ts '2025-07-01 18:02:17'})
			Order By Themen_Artikel.SortPos asc;
GetHauptCat (Datasource=step-geneva, Time=2.24ms, Records=0) in I:\WWW\step-geneva.org\cms_select.cfm:117
the following colum(s) are never read within the request:strHCatID,strCatID,strCatok,glbCatDesc,strCatName
SELECT strCatID, strCatName, strHCatID, strCatok, glbCatDesc
	FROM tblStCat 
	where strHCatID = 'Produkte' AND strCatok = true
	ORDER BY strCatSort ASC;
GetSubMenu (Datasource=step-geneva, Time=3.91ms, Records=4) in I:\WWW\step-geneva.org\i_header_navbar.cfm:58
the following colum(s) are never read within the request:AuthObject,ThemaName,PageTitle,AnzSubKat
SELECT ThemaID, AnzSubKat, AuthObject, PageTitle, ThemaLink, ThemaName, ThemaText
                              FROM Themen
                              where Hauptthema='611F1276-82C4-4972-B3769D1BD3E748AD' and Phase='online' order by ThemaPrio
GetSubMenu (Datasource=step-geneva, Time=3.57ms, Records=4) in I:\WWW\step-geneva.org\i_header_navbar.cfm:58
the following colum(s) are never read within the request:AuthObject,ThemaName,PageTitle,AnzSubKat
SELECT ThemaID, AnzSubKat, AuthObject, PageTitle, ThemaLink, ThemaName, ThemaText
                              FROM Themen
                              where Hauptthema='DA5B65A9-1CFF-4AF8-8FE55EFCDE09CA94' and Phase='online' order by ThemaPrio
GetSubMenu (Datasource=step-geneva, Time=3.58ms, Records=2) in I:\WWW\step-geneva.org\i_header_navbar.cfm:58
the following colum(s) are never read within the request:AuthObject,ThemaName,PageTitle,AnzSubKat
SELECT ThemaID, AnzSubKat, AuthObject, PageTitle, ThemaLink, ThemaName, ThemaText
                              FROM Themen
                              where Hauptthema='en-Sponsors1' and Phase='online' order by ThemaPrio
GetSubMenu (Datasource=step-geneva, Time=3.81ms, Records=2) in I:\WWW\step-geneva.org\i_header_navbar.cfm:58
the following colum(s) are never read within the request:ThemaID,AuthObject,ThemaName,PageTitle,AnzSubKat
SELECT ThemaID, AnzSubKat, AuthObject, PageTitle, ThemaLink, ThemaName, ThemaText
                              FROM Themen
                              where Hauptthema='2F361F09-E5E6-4791-9BCB955D055B09B4' and Phase='online' order by ThemaPrio
PurgeEmptyItems (Datasource=step-geneva, Time=1.43ms, Records=0) in I:\WWW\step-geneva.org\shop_warenkorb.cfm:17
DELETE FROM tblCtItm WHERE strCrtIDPK = 'FBFE600F-5518-409D-905360E0A55CCD64' AND intQty = 0
GetCartItems (Datasource=step-geneva, Time=4.36ms, Records=0) in I:\WWW\step-geneva.org\shop_warenkorb.cfm:22
the following colum(s) are never read within the request:dblItmCost3,strItmName,MWSTsatz,strItmID,strOptions,strWert1,strPartNum,dblItmCost4,intgewicht,strItmImg,dblItmCost2,dblItmCost,strItmIDPK,ID,intQty
SELECT id, strItmIDPK, strItmID, strPartNum, strItmName, strItmImg, tblStItm.dblItmCost as dblItmCost, tblStItm.dblItmCost2, tblStItm.dblItmCost3, tblStItm.dblItmCost4, intQty, tblCtItm.strWert1, intgewicht, mwstsatz, tblCtItm.strOptions
	  FROM tblStItm, tblCtItm
	  WHERE strItmID = strItmIDPK AND strCrtIDPK = 'FBFE600F-5518-409D-905360E0A55CCD64'
selectFromDB (Datasource=step-geneva, Time=2.89ms, Records=0) in I:\WWW\step-geneva.org\admin\common\shop_mwst_i.cfm:22
the following colum(s) are never read within the request:MWSTsatz,TotalCost
select Sum(tblStItm.dblItmCost*intQty) as TotalCost, MWSTsatz, Sum(tblStItm.dblItmCost*MWSTsatz/100*intQty) as TotalMWST
	FROM tblStItm, tblCtItm
	WHERE strItmID = strItmIDPK AND strCrtIDPK = 'FBFE600F-5518-409D-905360E0A55CCD64'
	GROUP BY MWSTsatz
TotalMWST (Datasource=, Time=0.88ms, Records=1) in I:\WWW\step-geneva.org\admin\common\shop_mwst_i.cfm:29
select sum(TotalMWST) as TotalMWST
	from selectFromDB

Scope Variables

Application Variables:
ADMINURL=Admin
ADMINVERSION=2024051601
applicationname=step-geneva.org
APPLS=Query (3)
APPLSLIST=CMSmaster,EVENTmaster,iSHOPmaster
COLLECTIONPATH=i:\www\step-geneva.org\collections
COOKIECONSENTPOPUP=true
CURRENCY2=EUR
DATASOURCE=step-geneva
DATASOURCE_ADM=step-geneva
DIRHM=i:\www\step-geneva.org\
DOCSPATH=docs
EMAIL_HEADER=step-geneva
EVENTMASTER_EMAIL=STEP Geneva <step-geneva@event-master.ch>
EVENTMASTER_REPLYTO=secretariat@step-geneva.org
FILTER_LINKS_BOTTOM_VISIBLE=n
FILTER_LINKS_TOP_VISIBLE=y
FROM=euros@trenka.net
GaleryMarginBottom=20
GaleryMarginTop=0
HM=/
LZ=200
MAXROWS=50
MENU=cms_MMenu.cfm
MWST_INOROUT=inclusiv
MYEMAIL=step-geneva@event-master.org
MYURL=http://test.step-geneva.org/
NAME=test.step-geneva.org
ORDERDOCUMENTBASEPATH=i:\www\step-geneva.org\orders
ORDERDOCUMENTBASEURL=/orders
REFCURRENCY=CHF
REFLAND=CHE
REFSPRACHE=-ch
SHOP_RECHNUNG_BILD=
SHOP_RECHNUNG_CREDITORADDRESS1=Rue du Mont-Blanc 4
SHOP_RECHNUNG_CREDITORCITY=Geneva
SHOP_RECHNUNG_CREDITORLAND=CH
SHOP_RECHNUNG_CREDITORNAME=Association STEP Geneva
SHOP_RECHNUNG_CREDITORNO=1
SHOP_RECHNUNG_CREDITORPOSTCODE=1201
SHOP_RECHNUNG_QRIBAN=CH633000524061529901H
SHOP_RECHNUNG_TEXT=
SHOP_SAFERPAY_CUSTOMERID=273932
SHOP_SAFERPAY_PASSWORD=APILogin-24[]zht
SHOP_SAFERPAY_PAYMETHODS=VISA,MASTERCARD,AMEX,POSTCARD,POSTFINANCE,TWINT
SHOP_SAFERPAY_TERMINALID=17764994
SHOP_SAFERPAY_URL=https://test.saferpay.com
SHOP_SAFERPAY_USERNAME=API_273932_25214994
SHOPAKTION=n
SHOPBCC=ap@trenka.ch
shopFaceProperties=pdf editOrder report
SHOPFROM=euros@trenka.net
SHOPTOCC=ap@trenka.ch
SORTIERUNG_OBEN_VISIBLE=y
SPAMcheckemail=Array (0)
SPAMcheckIPs=Array (0)
SPRACHEN=en
sprachen_lang_en=Struct (455)
STATUS=Open
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\step-geneva.org\shop_warenkorb.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=CF_CLIENT_STEP_GENEVA_ORG777_LV=1751385737063; cftoken=0; CF_CLIENT_STEP_GENEVA_ORG777_HC=2; CF_CLIENT_STEP_GENEVA_ORG777_TC=1751385737063; cfid=454c4fd2-3e25-4fe0-850f-615a5d7f9f89
http_host=test.step-geneva.org
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.4
local_host=Euros
path_info=
path_translated=I:\WWW\step-geneva.org\shop_warenkorb.cfm
query_string=
remote_addr=216.73.216.39
remote_host=216.73.216.39
remote_user=
request_method=GET
request_url=http://test.step-geneva.org/shop_warenkorb.cfm
script_name=/shop_warenkorb.cfm
server_name=test.step-geneva.org
server_port=80
server_port_secure=0
server_protocol=HTTP/1.1
server_software=
web_server_api=

Client Variables:
cfid=454c4fd2-3e25-4fe0-850f-615a5d7f9f89
cftoken=0
hitcount=2
lastvisit={ts '2025-07-01 18:02:17'}
timecreated={ts '2025-07-01 18:02:17'}
urltoken=CFID=454c4fd2-3e25-4fe0-850f-615a5d7f9f89&CFTOKEN=0

Cookie Variables:
cf_client_step_geneva_org777_hc=2
cf_client_step_geneva_org777_lv=1751385737063
cf_client_step_geneva_org777_tc=1751385737063
cfid=454c4fd2-3e25-4fe0-850f-615a5d7f9f89
cftoken=0

Server Variables:
CMSMASTER=Struct (2)
coldfusion=Struct (9)
counters=Struct (16)
java=Struct (9)
lucee=Struct (9)
os=Struct (8)
separator=Struct (3)
servlet=Struct (1)
system=Struct (2)

Session Variables:
ActAppl=CMSmaster
ADS=Query (0)
CartID=FBFE600F-5518-409D-905360E0A55CCD64
cfid=454c4fd2-3e25-4fe0-850f-615a5d7f9f89
cftoken=0
EditMode=fckeditor
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
IPADDR=216.73.216.39
lastvisit={ts '2025-07-01 18:02:17'}
MP_THEMAID=
MP_THEMALINK=
MP_THEMANAME=
REFERERID=
sessionid=step-geneva.org_454c4fd2-3e25-4fe0-850f-615a5d7f9f89_0
SESSSTARTTIME={ts '2025-07-01 18:02:17'}
sprache=en
strCustID=
timecreated={ts '2025-07-01 18:02:17'}
urltoken=CFID=454c4fd2-3e25-4fe0-850f-615a5d7f9f89&CFTOKEN=0
whitelisted=false
Debug Rendering Time: 0.00ms