Schnittmuster & Zubehör

Tolle Schnittmuster und das passende Zubehör von Merchant & Mills für die Taschen "Jack Tar Bag" und "RTR Bag". Beide Modelle können sehr gut mit den Stoffen Oilskin oder Dry Oilskin genät werden.

Filter ausblenden Filter einblenden


Debugging Information
ColdFusion Server Enterprise 9,0,1,274733
Template /dynasite.cfm
Time Stamp 26-Mar-19 05:13 PM
Locale German (Swiss)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 54.226.175.101
Host Name 54.226.175.101


Execution Time

Total Time Avg Time Count Template
330 ms 330 ms 1 D:/Web/Web-Aktiv10/blueblabla/dynasite.cfm
320 ms 320 ms 1 D:/Web/dynasite_codebase/_xdsinit.cfm
264 ms 264 ms 1 D:/Web/dynasite_codebase/output/_dsoutput.cfm
230 ms 77 ms 3 D:/Web/dynasite_codebase/output/_dsinclude.cfm
180 ms 90 ms 2 D:/Web/dynasite_codebase/output/_dssnippet.cfm
173 ms 87 ms 2 D:/Web/Web-Aktiv10/blueblabla/project/_default.cfm
155 ms 31 ms 5 D:/Web/dynasite_codebase/output/_dscommand.cfm
64 ms 32 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
56 ms 19 ms 3 D:/Web/Web-Aktiv10/blueblabla/cshop/_shop_action.cfm
34 ms 5 ms 7 C:/ColdFusion9/CustomTags/fm_contentcenter.cfm
33 ms 33 ms 1 D:/Web/dynasite_codebase/init/_initialize.cfm
30 ms 10 ms 3 D:/Web/Web-Aktiv10/blueblabla/cshop/_shop.cfm
30 ms 3 ms 10 D:/Web/dynasite_codebase/cached.cfm
29 ms 29 ms 1 D:/Web/dynasite_codebase/udf/_udf.cfm
21 ms 4 ms 5 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetLACMD() ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
18 ms 4 ms 5 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetSetting(view) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
11 ms 6 ms 2 D:/Web/Web-Aktiv10/blueblabla/cshop/_warenkorb.cfm
11 ms 11 ms 1 D:/Web/dynasite_codebase/output/_dsmenu.cfm
10 ms 5 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetCMD(cshop_warenkorb_warenkorb_viewue, 5238, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
9 ms 5 ms 2 D:/Web/Web-Aktiv10/blueblabla/cshop/_warenkorb_action.cfm
9 ms 9 ms 1 D:/Web/dynasite_codebase/_xdscache.cfm
8 ms 4 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_header.cfm
6 ms 1 ms 11 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc | get(true, true) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc
6 ms 3 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetCMD(cshop_shop_shop_footer, 5238, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
5 ms 3 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(AD3B7A9B0A2E34879A620D92FD9E09BA) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
5 ms 5 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(519776, 9535, 9535, 1, , none, visible, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
4 ms 2 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/menus.cfc | getMenu(language = de, dsmid = 513200) ] from C:/ColdFusion9/CustomTags/cfc/menus.cfc
4 ms 2 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(392833F3AC87CB7AF60BA7B9363DC98A) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
4 ms 4 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetCMD(76872, 5238, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
3 ms 2 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(4AE9BE86CB7DE317856DE4690FDD92D4) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
3 ms 2 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(B12C5B0E1EADBED72B2CA0548BC788A2) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
3 ms 3 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(B6BC1856FF759E6922DFA0435B632C24) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
3 ms 3 ms 1 D:/Web/Web-Aktiv10/blueblabla/dsinit.cfc
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(0C78C3B3F9061F234F21BB15ACE70557) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(dynasite9,9535,519776,0,global,dynasite,CV9445friendly_path_info=/schnittmuster--zubehoer&) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
2 ms 2 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 0, News.Row,News.Sorting, 9535, 519776, 0, 0, 0, 0, 0, , 1, 1, , , , , , , 0, 1, 25, global, , 0, 0, , 0, , 1, 0) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
2 ms 2 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 1,2,3,4,5,6, News.Row,News.Sorting, 9535, 519776, 0, 0, 0, 0, 0, , 1, 1, , , , , , , 0, 1, 25, global, , 0, 0, , 0, , 1, 0) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
1 ms 1 ms 1 C:/ColdFusion9/CustomTags/Includs/_ajaxpaging.cfm
1 ms 0 ms 11 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc | init([complex value]) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc
1 ms 0 ms 11 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/memcachedfactory.cfc | getMemcached() ] from C:/ColdFusion9/CustomTags/memcached-v2/memcachedfactory.cfc
1 ms 1 ms 1 D:/Web/Web-Aktiv10/blueblabla/project/_init.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/init/_variable.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/output/_dslayout_footeroutside.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/udf/_udf_tagging.cfm
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = hardware kit jack tar bag) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = hardware kit rtr rucksack) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = schnittmuster jack tar bag) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = schnittmuster rtr bag) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/plugins.cfc | cookieNotification(text = <p>Bitte erlauben Sie das Speichern von Cookies in ihren Browsereinstellungen.</p>) ] from C:/ColdFusion9/CustomTags/cfc/plugins.cfc
0 ms 0 ms 1 CFC[ D:/Web/application.cfc | onRequestEnd(/dynasite.cfm) ] from D:/Web/application.cfc
0 ms 0 ms 1 CFC[ D:/Web/application.cfc | onRequestStart(/dynasite.cfm) ] from D:/Web/application.cfc
0 ms 0 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSIsEditable(dsaid) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
0 ms 0 ms 1 D:/Web/Web-Aktiv10/blueblabla/cshop/_functions.cfm
0 ms 0 ms 2 D:/Web/Web-Aktiv10/blueblabla/project/_script.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/customer/creanet/_dscustinit.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_app.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_array.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_article.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_asset.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_buttonbar.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_calendar.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_category.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_command.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_contact.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_content.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_content_article_form.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_content_explorer.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_contextmenu.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_date.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_designer.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_distributor.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_editor.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_finance.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_form.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_form_control.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_google_maps.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_gui_navigator.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_gui_tree.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_htmlbuilder.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_item.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_list.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_localisation.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_log.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_login.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_menu.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_message.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_note.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_number.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_orm.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_paging.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_popup.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_print.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_query.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_security.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_snippet.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_sql.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_util.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_various.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_view.cfm
0 ms 0 ms 1 D:/Web/dynasite_codebase/udf/_udf_xobject.cfm
13 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
343 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

17:13:18.018 - MissingInclude Exception - in D:/Web/dynasite_codebase/output/_dscommand.cfm : line 51
	    Could not find the included template /dsfront1/Web-Aktiv10/blueblabla/cshop/_udf.cfm.
	    
17:13:18.018 - MissingInclude Exception - in D:/Web/dynasite_codebase/output/_dscommand.cfm : line 51
	    Could not find the included template /dsfront1/Web-Aktiv10/blueblabla/cshop/_udf.cfm.
	    
17:13:18.018 - MissingInclude Exception - in D:/Web/dynasite_codebase/output/_dscommand.cfm : line 51
	    Could not find the included template /dsfront1/Web-Aktiv10/blueblabla/cshop/_udf.cfm.
	    
17:13:18.018 - MissingInclude Exception - in D:/Web/dynasite_codebase/output/_dscommand.cfm : line 51
	    Could not find the included template /dsfront1/Web-Aktiv10/blueblabla/cshop/_udf.cfm.
	    
17:13:19.019 - MissingInclude Exception - in D:/Web/dynasite_codebase/output/_dscommand.cfm : line 51
	    Could not find the included template /dsfront1/Web-Aktiv10/blueblabla/cshop/_udf.cfm.
	    


SQL Queries

QSeo (Datasource=dynasite9_modules, Time=2ms, Records=0) in D:\Web\Web-Aktiv10\blueblabla\dsinit.cfc @ 17:13:18.018
	Select DsmidNeu, DsmidAlt FROM blueblabla_seo
	WHERE 1=2
	
		OR DsmidAlt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = schnittmuster--zubehoer

GetInclude (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 17:13:18.018
		SELECT Status, CFParam, CFSET, CacheThis, TemplateName FROM Includes 
		WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5841

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=1ms, Records=35) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:13:18.018
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
getsetting (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:13:18.018
			SELECT ID, XMLSetting.query('/DSXMLRoot/view') AS XMLSetting		
			FROM Customers WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5238

QCart (Datasource=dynasite9_modules, Time=4ms, Records=0) in D:\Web\Web-Aktiv10\blueblabla\cshop\_warenkorb_action.cfm @ 17:13:18.018
		SELECT
			ID, Kunde, ProduktID, ProduktTitel, Anzahl, Preis, Datum, Art,
			(SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = warenkorb.ProduktID ORDER BY Sort ASC) AS Photo,
			(SELECT Hauptbereich FROM blueblabla_shop_produkt WHERE ID = warenkorb.ProduktID) AS Hauptbereich,
			(SELECT ISNULL(Lagerbestand,10) FROM blueblabla_shop_produkt WHERE ID = warenkorb.ProduktID) AS Lagerbestand,
			AussenproduktTitel,
			InnenproduktTitel,
			BandproduktTitel,
			CASE WHEN Art = 1 THEN (SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = warenkorb.AussenproduktID) END AS AussenproduktPhoto,
			CASE WHEN Art = 1 THEN (SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = warenkorb.InnenproduktID) END AS InnenproduktPhoto,
			CASE WHEN Art = 1 THEN (SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = warenkorb.BandproduktID) END AS BandproduktPhoto
		FROM
			blueblabla_shop_warenkorb AS warenkorb
		WHERE
			Kunde = ?
		ORDER BY
			Datum ASC;
	
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 4BC5BBE8-95F6-6EB2-D68829A0FFF5BDFD

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=6ms, Records=178) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:13:18.018
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
					OR
				
				modul = 'form'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
getsetting (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:13:18.018
			SELECT ID, XMLSetting.query('/DSXMLRoot/view') AS XMLSetting		
			FROM Customers WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5238

QMenu (Datasource=dynasite9_modules, Time=1ms, Records=1) in C:\ColdFusion9\CustomTags\cfc\menus.cfc @ 17:13:18.018
			SELECT
				Menu.ID AS DSMID, Menu.DSSID, Menu.Depth, Menu.DSPMID, Menu.DSDID, Menu.DSRole, Menu.Live,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID and Language = ?
				) THEN (
					SELECT Menutext FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID and Language = ?
				) ELSE Menutext END AS Menutext,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT DSNavFolder FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE DSNavFolder END AS DSNavFolder,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT LinkType FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE LinkType END AS LinkType,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT LinkDSMID FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE LinkDSMID END AS LinkDSMID,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT URLLink FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE URLLink END AS URLLink,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT URLTarget FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE URLTarget END AS URLTarget,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT Language FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE Language END AS RealLang, 

				(SELECT COUNT(ID) FROM dynasite9.dbo.Menus WHERE DSPMID = Menu.ID AND Live IN (1)) AS SubCounter
			FROM 
				dynasite9.dbo.Menus AS Menu
			WHERE
				Menu.ID = ?
				AND Language = 'global'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = de
Parameter #2(cf_sql_varchar) = de
Parameter #3(cf_sql_varchar) = de
Parameter #4(cf_sql_varchar) = de
Parameter #5(cf_sql_varchar) = de
Parameter #6(cf_sql_varchar) = de
Parameter #7(cf_sql_varchar) = de
Parameter #8(cf_sql_varchar) = de
Parameter #9(cf_sql_varchar) = de
Parameter #10(cf_sql_varchar) = de
Parameter #11(cf_sql_varchar) = de
Parameter #12(cf_sql_varchar) = de
Parameter #13(cf_sql_varchar) = de
Parameter #14(cf_sql_varchar) = de
Parameter #15(cf_sql_integer) = 513200

QSlider (Datasource=dynasite9_modules, Time=18ms, Records=15) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 17:13:18.018
		SELECT TOP 15
			produkt.ID, produkt.Kategorien, produkt.Aktiv, produkt.Neuheit,
			ISNULL(NULLIF(produkt.Titel_de,''), produkt.Titel_de) AS Titel,
			ISNULL(NULLIF(produkt.Beschreibung_de,''), produkt.Beschreibung_de) AS Beschreibung,
			(SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = produkt.ID ORDER BY Sort ASC) AS Photo,
			ISNULL(Preis,0) AS Preis,
			ISNULL(Aktionspreis,0) AS Aktionspreis,
			menus.Menutext
		FROM
			blueblabla_shop_produkt AS produkt
			INNER JOIN [dynasite9].[dbo].[Menus] AS menus ON menus.ID = produkt.Bereich
		WHERE
			produkt.Hauptbereich = ?
			AND produkt.Aktiv = 1
		ORDER BY
			newid()
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 513200

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=5ms, Records=157) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:13:18.018
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
GetMenus (Datasource=dynasite9, Time=5ms, Records=48) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:13:18.018
				SELECT 
					ID as ItemID, DSPMID as ParentItemID, ID, LFT, RGT, Language,
					CASE WHEN id=(select language_dsmid from Menus AS A where language_dsmid=Menus.id and language='global') THEN (select language from Menus AS B where language_dsmid=Menus.id and language='global') ELSE language END as reallang,
					id as langdsmid, Menutext, Menutext AS Name, MNHTML, DSRole, 
						LinkType, LinkDSSID,LinkDSMID, LinkDSPAID,LinkTarget, URLLInk,URLTarget,
						Schedule,PubDate,ExpDate,						
						DSFrames, Image, TempLive,AImage, OverImage, DSPMID, OnOver, OnOut, Live, Depth
						
						, Sort, Linked, OpenMenu, DSInclude, DSTname, DSDID, HTMLActive
						,DSJSFrameWork,JSFramework, Command, Command_Trigger, Command_Role, Command_Element, Command_URL, Command_XHR, Command_Icon, Taglist, DSTTIDList				
					
				FROM 
					Menus
				WHERE 
					Menus.DSSID=? 
						and Menus.Language = ? 
						AND (DSPMID IN ( SELECT ID FROM dbo.DSGetTreeMenuID (?,?)))
					
						AND (SCHEDULE=0 OR (SCHEDULE=1 AND (PubDate <= GetDate() AND ExpDate >= GetDate())))
									
				ORDER BY 
					Lft
			
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9535
Parameter #2(cf_sql_varchar) = global
Parameter #3(cf_sql_integer) = 9535
Parameter #4(cf_sql_integer) = 519776

DSGetArticles (Datasource=dynasite9, Time=1ms, Records=0) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:13:18.018
				SELECT 			
			Asset.Filename as Dateiname,Asset.Subfolder,Asset.Description as AssetImageDescription,Asset.Width as ImageWidth,Asset.Height as ImageHeight,
				 
				News.id as LangDSAID,
				News.Live,News.Prefix_Option,News.Prefix_Code,
				News.Date_Created,News.Date_Modified,News.Date_Custom,
				News.LastModify_Date,News.LastModify_Role,News_Content.Status,
				News.Taglist, News.DSTTIDList, 
				News_Content.MetaName as Title_Internal,News_Content.Teaser,News_Content.SSubject as Title,News_Content.ShortBody as Body,
				News_Content.Metaname,News_Content.Schedule,News_Content.SSubject,News_Content.ShortBody,
				News_Content.Linklist_XML,News_Content.BText,News_Content.ImageDescription,News_Content.BImageOver,
				News_Content.PubDate,News_Content.ExpDate,News_Content.BImage,
				News_Content.DSRID, News_Content.ImageProps, 
				News_Content.URLS, News_Content.URLS as URLLink, News_Content.URLTarget, News_Content.LinkProps, 
				News_Content.LinkType, News_Content.LinkDSSID, News_Content.LinkDSMID, News_Content.LinkDSPAID, News_Content.LinkTarget, 
				News_Content.CFPARAM,News_Content.CFSET,

				
				News.Des, News.Row, News.DSSID, News.Sorting, News.DSPAID, News.DSMID, News.NCID, News.HasRef, 
				News.id AS NewsID, News.Row AS Col, News.Des AS Design, News.ID, News.Numberation, News.Language,
				
				
					News.Language AS RealLang,
				
								
				News_Content.FieldType, News_Content.DSAID, News_Content.BStyle, News_Content.BAlign,
				News_Content.DSInclude, News_Content.DSTName, News_Content.DSACMDID , News_Content.DSIncludePos
				
				
					,Sites.DSCID
									
				
			FROM 
				News 
			INNER JOIN 
				News_Content ON News.NCID = News_Content.DSAID
								
			LEFT OUTER JOIN 
				Asset ON News_Content.DSRID = Asset.ID 
			LEFT OUTER JOIN 
				Menus ON News.DSMID = Menus.ID 
			
				INNER JOIN 
					Sites ON News.DSSID = Sites.ID
							
			WHERE 
				
					News.DSMID IN (?)
				
				
				and News.language = ? 
					AND News.Row = ? 
					AND News.DSPAID < 2
				
					
					AND News.Live = ? 
						AND (Menus.SCHEDULE=0 OR (Menus.SCHEDULE=1 AND (Menus.PubDate <= GetDate() AND Menus.ExpDate >= GetDate())))					
						AND (News_Content.SCHEDULE=0 OR (News_Content.SCHEDULE=1 AND (News_Content.PubDate <= GetDate() AND News_Content.ExpDate >= GetDate())))
					
				ORDER BY News.Row,News.Sorting 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 519776
Parameter #2(cf_sql_varchar) = global
Parameter #3(cf_sql_integer) = 0
Parameter #4(cf_sql_integer) = 1

DSGetArticles (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:13:18.018
				SELECT 			
			Asset.Filename as Dateiname,Asset.Subfolder,Asset.Description as AssetImageDescription,Asset.Width as ImageWidth,Asset.Height as ImageHeight,
				 
				News.id as LangDSAID,
				News.Live,News.Prefix_Option,News.Prefix_Code,
				News.Date_Created,News.Date_Modified,News.Date_Custom,
				News.LastModify_Date,News.LastModify_Role,News_Content.Status,
				News.Taglist, News.DSTTIDList, 
				News_Content.MetaName as Title_Internal,News_Content.Teaser,News_Content.SSubject as Title,News_Content.ShortBody as Body,
				News_Content.Metaname,News_Content.Schedule,News_Content.SSubject,News_Content.ShortBody,
				News_Content.Linklist_XML,News_Content.BText,News_Content.ImageDescription,News_Content.BImageOver,
				News_Content.PubDate,News_Content.ExpDate,News_Content.BImage,
				News_Content.DSRID, News_Content.ImageProps, 
				News_Content.URLS, News_Content.URLS as URLLink, News_Content.URLTarget, News_Content.LinkProps, 
				News_Content.LinkType, News_Content.LinkDSSID, News_Content.LinkDSMID, News_Content.LinkDSPAID, News_Content.LinkTarget, 
				News_Content.CFPARAM,News_Content.CFSET,

				
				News.Des, News.Row, News.DSSID, News.Sorting, News.DSPAID, News.DSMID, News.NCID, News.HasRef, 
				News.id AS NewsID, News.Row AS Col, News.Des AS Design, News.ID, News.Numberation, News.Language,
				
				
					News.Language AS RealLang,
				
								
				News_Content.FieldType, News_Content.DSAID, News_Content.BStyle, News_Content.BAlign,
				News_Content.DSInclude, News_Content.DSTName, News_Content.DSACMDID , News_Content.DSIncludePos
				
				
					,Sites.DSCID
									
				
			FROM 
				News 
			INNER JOIN 
				News_Content ON News.NCID = News_Content.DSAID
								
			LEFT OUTER JOIN 
				Asset ON News_Content.DSRID = Asset.ID 
			LEFT OUTER JOIN 
				Menus ON News.DSMID = Menus.ID 
			
				INNER JOIN 
					Sites ON News.DSSID = Sites.ID
							
			WHERE 
				
					News.DSMID IN (?)
				
				
				and News.language = ? 
					AND News.Row <> 0
				
					AND News.DSPAID < 2
				
					
					AND News.Live = ? 
						AND (Menus.SCHEDULE=0 OR (Menus.SCHEDULE=1 AND (Menus.PubDate <= GetDate() AND Menus.ExpDate >= GetDate())))					
						AND (News_Content.SCHEDULE=0 OR (News_Content.SCHEDULE=1 AND (News_Content.PubDate <= GetDate() AND News_Content.ExpDate >= GetDate())))
					
				ORDER BY News.Row,News.Sorting 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 519776
Parameter #2(cf_sql_varchar) = global
Parameter #3(cf_sql_integer) = 1

getxmlColumnData (Datasource=dynasite9, Time=2ms, Records=0) in D:\Web\dynasite_codebase\output\_dsarticle_css.cfm @ 17:13:18.018
				SELECT
					columnDefault.value('@row','integer') as XMLRow, columnDefault.query('.') as ArticleColumnXML
				FROM
					Menus
				CROSS APPLY
					XMLData.nodes('/DSXMLRoot/columndefaults/columndefault') as XMLTree(COLUMNDEFAULT)
				CROSS APPLY
					COLUMNDEFAULT.nodes('./date') as XMLDateTree(DATE)
				WHERE
					ID=? AND (COLUMNDEFAULT.value('@active','int')=1 or DATE.value('@position','varchar(127)')<>'0')
			
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 519776

getCommand (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 17:13:18.018
				SELECT CMDTrigger FROM System_Command WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 76872

getsetting (Datasource=dynasite9, Time=0ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:13:18.018
			SELECT ID, XMLSetting.query('/DSXMLRoot/view') AS XMLSetting		
			FROM Customers WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5238

QOrders (Datasource=dynasite9_modules, Time=5ms, Records=0) in D:\Web\Web-Aktiv10\blueblabla\cshop\_functions.cfm @ 17:13:18.018
		SELECT
			kunde.ID, kunde.Kunde,
			warenkorb.ID AS WarenkorbID, warenkorb.ProduktID, warenkorb.Anzahl
		FROM
			blueblabla_shop_kunde AS kunde
			LEFT JOIN blueblabla_shop_warenkorb AS warenkorb ON kunde.Kunde = warenkorb.Kunde
		WHERE
			DATEDIFF(day, kunde.Datum, GETDATE()) > 30 AND kunde.Status = 0
	
QView (Datasource=dynasite9_modules, Time=6ms, Records=4) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 17:13:18.018
		SELECT
			produkt.ID, produkt.Kategorien, produkt.Aktiv, produkt.Neuheit, produkt.Bereich, produkt.Lagerbestand,
			ISNULL(NULLIF(produkt.Titel_de,''), produkt.Titel_de) AS Titel,
			ISNULL(NULLIF(produkt.Beschreibung_de,''), produkt.Beschreibung_de) AS Beschreibung,
			(SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = produkt.ID ORDER BY Sort ASC) AS Photo,
			ISNULL(Preis,0) AS Preis,
			ISNULL(Aktionspreis,0) AS Aktionspreis,
			menus.Menutext
		FROM
			blueblabla_shop_produkt AS produkt
			INNER JOIN [dynasite9].[dbo].[Menus] AS menus ON menus.ID = produkt.Bereich
		WHERE 1=1
			AND menus.Live IN (1,3)	
			
				AND produkt.Bereich = ? AND produkt.Aktiv = 1 
		ORDER BY
			menus.Sort, produkt.Titel_de ASC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 519776

QKategorien (Datasource=dynasite9_modules, Time=0ms, Records=0) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 17:13:18.018
			SELECT DISTINCT
				ID, Sort,
				ISNULL(NULLIF(Category_de,''), Category_de) AS Category
			FROM
				blueblabla_shop_category
			WHERE
				1=2
				
			ORDER BY
				Sort ASC;
		
qWebSiteContent (Datasource=dynasite9_contentcenter, Time=7ms, Records=157) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:13:18.018
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
GetInclude (Datasource=dynasite9, Time=3ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 17:13:18.018
		SELECT Status, CFParam, CFSET, CacheThis, TemplateName FROM Includes 
		WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5842

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=2ms, Records=35) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:13:18.018
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
getsetting (Datasource=dynasite9, Time=2ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:13:18.018
			SELECT ID, XMLSetting.query('/DSXMLRoot/view') AS XMLSetting		
			FROM Customers WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5238

QCart (Datasource=dynasite9_modules, Time=4ms, Records=0) in D:\Web\Web-Aktiv10\blueblabla\cshop\_warenkorb_action.cfm @ 17:13:18.018
		SELECT
			ID, Kunde, ProduktID, ProduktTitel, Anzahl, Preis, Datum, Art,
			(SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = warenkorb.ProduktID ORDER BY Sort ASC) AS Photo,
			(SELECT Hauptbereich FROM blueblabla_shop_produkt WHERE ID = warenkorb.ProduktID) AS Hauptbereich,
			(SELECT ISNULL(Lagerbestand,10) FROM blueblabla_shop_produkt WHERE ID = warenkorb.ProduktID) AS Lagerbestand,
			AussenproduktTitel,
			InnenproduktTitel,
			BandproduktTitel,
			CASE WHEN Art = 1 THEN (SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = warenkorb.AussenproduktID) END AS AussenproduktPhoto,
			CASE WHEN Art = 1 THEN (SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = warenkorb.InnenproduktID) END AS InnenproduktPhoto,
			CASE WHEN Art = 1 THEN (SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = warenkorb.BandproduktID) END AS BandproduktPhoto
		FROM
			blueblabla_shop_warenkorb AS warenkorb
		WHERE
			Kunde = ?
		ORDER BY
			Datum ASC;
	
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 4BC5BBE8-95F6-6EB2-D68829A0FFF5BDFD

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=3ms, Records=178) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:13:18.018
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
					OR
				
				modul = 'form'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
getsetting (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:13:19.019
			SELECT ID, XMLSetting.query('/DSXMLRoot/view') AS XMLSetting		
			FROM Customers WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5238

QMenu (Datasource=dynasite9_modules, Time=1ms, Records=1) in C:\ColdFusion9\CustomTags\cfc\menus.cfc @ 17:13:19.019
			SELECT
				Menu.ID AS DSMID, Menu.DSSID, Menu.Depth, Menu.DSPMID, Menu.DSDID, Menu.DSRole, Menu.Live,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID and Language = ?
				) THEN (
					SELECT Menutext FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID and Language = ?
				) ELSE Menutext END AS Menutext,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT DSNavFolder FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE DSNavFolder END AS DSNavFolder,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT LinkType FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE LinkType END AS LinkType,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT LinkDSMID FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE LinkDSMID END AS LinkDSMID,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT URLLink FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE URLLink END AS URLLink,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT URLTarget FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE URLTarget END AS URLTarget,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT Language FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE Language END AS RealLang, 

				(SELECT COUNT(ID) FROM dynasite9.dbo.Menus WHERE DSPMID = Menu.ID AND Live IN (1)) AS SubCounter
			FROM 
				dynasite9.dbo.Menus AS Menu
			WHERE
				Menu.ID = ?
				AND Language = 'global'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = de
Parameter #2(cf_sql_varchar) = de
Parameter #3(cf_sql_varchar) = de
Parameter #4(cf_sql_varchar) = de
Parameter #5(cf_sql_varchar) = de
Parameter #6(cf_sql_varchar) = de
Parameter #7(cf_sql_varchar) = de
Parameter #8(cf_sql_varchar) = de
Parameter #9(cf_sql_varchar) = de
Parameter #10(cf_sql_varchar) = de
Parameter #11(cf_sql_varchar) = de
Parameter #12(cf_sql_varchar) = de
Parameter #13(cf_sql_varchar) = de
Parameter #14(cf_sql_varchar) = de
Parameter #15(cf_sql_integer) = 513200

QSlider (Datasource=dynasite9_modules, Time=17ms, Records=15) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 17:13:19.019
		SELECT TOP 15
			produkt.ID, produkt.Kategorien, produkt.Aktiv, produkt.Neuheit,
			ISNULL(NULLIF(produkt.Titel_de,''), produkt.Titel_de) AS Titel,
			ISNULL(NULLIF(produkt.Beschreibung_de,''), produkt.Beschreibung_de) AS Beschreibung,
			(SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = produkt.ID ORDER BY Sort ASC) AS Photo,
			ISNULL(Preis,0) AS Preis,
			ISNULL(Aktionspreis,0) AS Aktionspreis,
			menus.Menutext
		FROM
			blueblabla_shop_produkt AS produkt
			INNER JOIN [dynasite9].[dbo].[Menus] AS menus ON menus.ID = produkt.Bereich
		WHERE
			produkt.Hauptbereich = ?
			AND produkt.Aktiv = 1
		ORDER BY
			newid()
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 513200

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=4ms, Records=157) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:13:19.019
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder


Stored Procedures

DSVariableInit2 (Datasource=dynasite9, Time=1ms) in D:\Web\dynasite_codebase\_xdscache.cfm @ 17:13:18.018

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  519776    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_BIT  NO    
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_VARCHAR  global    
 OUT  CF_SQL_INTEGER    URL.DSCID = URL.DSCID  
 OUT  CF_SQL_INTEGER    URL.DSSID = URL.DSSID  
 OUT  CF_SQL_INTEGER    URL.DSMID = URL.DSMID  
 OUT  CF_SQL_INTEGER    URL.DSPAID = URL.DSPAID  
 OUT  CF_SQL_VARCHAR    Request.DSSPCharset = Request.DSSPCharset  
 OUT  CF_SQL_INTEGER    Variables.SPCacheVersion = Variables.SPCacheVersion  
 OUT  CF_SQL_VARCHAR    Request.DSCLANG = Request.DSCLANG  
 OUT  CF_SQL_TINYINT    DSUnauthorized = DSUnauthorized  
 OUT  CF_SQL_TINYINT    Request.DSSecured = Request.DSSecured  
 OUT  CF_SQL_VARCHAR    Request.DSFURL = Request.DSFURL  
    
resultsets
nameresultset
DSInit2 (Datasource=dynasite9, Time=19ms) in D:\Web\dynasite_codebase\_xdsinit.cfm @ 17:13:18.018
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_INTEGER  9535    
 IN  CF_SQL_INTEGER  519776    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_BIT  NO    
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_VARCHAR  global    
 OUT  CF_SQL_INTEGER    URL.DSCID = URL.DSCID  
 OUT  CF_SQL_INTEGER    URL.DSSID = URL.DSSID  
 OUT  CF_SQL_INTEGER    URL.DSMID = URL.DSMID  
 OUT  CF_SQL_INTEGER    URL.DSPAID = URL.DSPAID  
 OUT  CF_SQL_INTEGER    Request.DSDID = Request.DSDID  
 OUT  CF_SQL_BIT    Request.DSIsCSS = Request.DSIsCSS  
 OUT  CF_SQL_INTEGER    Request.DSDIDCV = Request.DSDIDCV  
    
resultsets
nameresultset
 GetDSCID  1
 GetDSSID  2
 GetDSMID  3
DSContent (Datasource=dynasite9, Time=3ms) in D:\Web\dynasite_codebase\output\_dsoutput.cfm @ 17:13:18.018
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_Integer  9535    
 IN  CF_SQL_Integer  519776    
 IN  CF_SQL_Integer  0    
 IN  CF_SQL_Integer  0    
 IN  CF_SQL_Integer  1    
 IN  CF_SQL_Integer  1    
 OUT  CF_SQL_VarChar    DSInitLinkType = DSInitLinkType  
 OUT  CF_SQL_Integer    DSInitLinkDSSID = DSInitLinkDSSID  
 OUT  CF_SQL_Integer    DSInitLinkDSMID = DSInitLinkDSMID  
 OUT  CF_SQL_Integer    DSInitLinkDSPAID = DSInitLinkDSPAID  
 OUT  CF_SQL_VarChar    DSURL = DSURL  
 OUT  CF_SQL_Integer    ColCount = ColCount  
 OUT  CF_SQL_Integer    MaxSpa = MaxSpa  
 OUT  CF_SQL_Integer    MaxCol = MaxCol  
    
resultsets
nameresultset
 GetSnippet  1


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=4096
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
CERT_SERVER_SUBJECT=OU=Domain Control Validated, CN=www.blueblabla.ch
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Web\Web-Aktiv10\blueblabla\dynasite.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=4096
HTTPS_SERVER_ISSUER=C=US, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
HTTPS_SERVER_SUBJECT=OU=Domain Control Validated, CN=www.blueblabla.ch
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.blueblabla.ch
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=/dynasite.cfm
PATH_TRANSLATED=D:\Web\Web-Aktiv10\blueblabla\dynasite.cfm
QUERY_STRING=friendly_path_info=/schnittmuster--zubehoer&
REMOTE_ADDR=54.226.175.101
REMOTE_HOST=54.226.175.101
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/dynasite.cfm
SERVER_NAME=www.blueblabla.ch
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Client Variables:
cfid=11618477
cftoken=36940662
hitcount=1
lastvisit={ts '2019-03-26 17:13:18'}
timecreated={ts '2019-03-26 17:13:18'}
urltoken=CFID=11618477&CFTOKEN=36940662
Cookie Variables:
CFID=11618477
CFTOKEN=36940662
Form Fields:
CSHOP_AKTION=
CSHOP_BEREICH=Bereich
CSHOP_KATEGORIE=
CSHOP_NEUHEITEN=
CSHOP_SEARCH=
CSHOP_SEO=0
CSHOP_SUBMENU=
DSSEARCH_EDITMODE=1
Session Variables:
cfid=11618477
cftoken=36940662
kunde=4BC5BBE8-95F6-6EB2-D68829A0FFF5BDFD
menuslist=519773,519776
secure=4BC5BBE9-ECAA-EB89-6EEA09EEF6916CB4
sessioncheck_5238=true
sessionid=DYNASITE_CREANET_5238_11618477_36940662
urltoken=CFID=11618477&CFTOKEN=36940662
URL Parameters:
friendly_path_info=/schnittmuster--zubehoer
Debug Rendering Time: 45 ms