Beschichtete Stoffe von "Chic Antique"


Filter ausblenden Filter einblenden


Debugging Information
ColdFusion Server Enterprise 9,0,1,274733
Template /dynasite.cfm
Time Stamp 26-Mar-19 05:39 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
423 ms 423 ms 1 D:/Web/Web-Aktiv10/blueblabla/dynasite.cfm
409 ms 409 ms 1 D:/Web/dynasite_codebase/_xdsinit.cfm
331 ms 331 ms 1 D:/Web/dynasite_codebase/output/_dsoutput.cfm
289 ms 96 ms 3 D:/Web/dynasite_codebase/output/_dsinclude.cfm
239 ms 120 ms 2 D:/Web/dynasite_codebase/output/_dssnippet.cfm
233 ms 117 ms 2 D:/Web/Web-Aktiv10/blueblabla/project/_default.cfm
176 ms 35 ms 5 D:/Web/dynasite_codebase/output/_dscommand.cfm
69 ms 35 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
67 ms 7 ms 10 D:/Web/dynasite_codebase/cached.cfm
50 ms 7 ms 7 C:/ColdFusion9/CustomTags/fm_contentcenter.cfm
49 ms 16 ms 3 D:/Web/Web-Aktiv10/blueblabla/cshop/_shop_action.cfm
41 ms 21 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
35 ms 12 ms 3 D:/Web/Web-Aktiv10/blueblabla/cshop/_shop.cfm
34 ms 34 ms 1 D:/Web/dynasite_codebase/init/_initialize.cfm
31 ms 6 ms 5 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetSetting(view) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
30 ms 30 ms 1 D:/Web/dynasite_codebase/udf/_udf.cfm
20 ms 4 ms 5 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetLACMD() ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
16 ms 16 ms 1 D:/Web/dynasite_codebase/output/_dsmenu.cfm
12 ms 12 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(513209, 9535, 9535, 1, , none, visible, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
12 ms 6 ms 2 D:/Web/Web-Aktiv10/blueblabla/cshop/_warenkorb.cfm
11 ms 11 ms 1 D:/Web/dynasite_codebase/_xdscache.cfm
9 ms 5 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
9 ms 5 ms 2 D:/Web/Web-Aktiv10/blueblabla/cshop/_warenkorb_action.cfm
9 ms 5 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_header.cfm
7 ms 7 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetCMD(76872, 5238, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
6 ms 3 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(B12C5B0E1EADBED72B2CA0548BC788A2) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
5 ms 3 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/menus.cfc | getMenu(language = de, dsmid = 513200) ] from C:/ColdFusion9/CustomTags/cfc/menus.cfc
5 ms 3 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(4AE9BE86CB7DE317856DE4690FDD92D4) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
5 ms 5 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 0, News.Row,News.Sorting, 9535, 513209, 0, 0, 0, 0, 0, , 1, 1, , , , , , , 0, 1, 25, global, , 0, 0, , 0, , 1, 0) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
4 ms 2 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(AD3B7A9B0A2E34879A620D92FD9E09BA) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
3 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
3 ms 3 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(0C78C3B3F9061F234F21BB15ACE70557) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
3 ms 2 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(392833F3AC87CB7AF60BA7B9363DC98A) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(B6BC1856FF759E6922DFA0435B632C24) ] 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,513209,0,global,dynasite,CV9445friendly_path_info=/beschichtete-baumwolle&) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.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, 513209, 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 | get(true, true) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc
1 ms 1 ms 1 D:/Web/Web-Aktiv10/blueblabla/dsinit.cfc
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
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = dots red ) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = star green) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = star light blue) ] 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 11 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/memcachedfactory.cfc | getMemcached() ] from C:/ColdFusion9/CustomTags/memcached-v2/memcachedfactory.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 1 D:/Web/Web-Aktiv10/blueblabla/project/_init.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_tagging.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
60 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
483 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

17:39:33.033 - 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:39:33.033 - 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:39:33.033 - 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:39:33.033 - 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:39:33.033 - 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=1ms, Records=0) in D:\Web\Web-Aktiv10\blueblabla\dsinit.cfc @ 17:39:33.033
	Select DsmidNeu, DsmidAlt FROM blueblabla_seo
	WHERE 1=2
	
		OR DsmidAlt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = beschichtete-baumwolle

GetInclude (Datasource=dynasite9, Time=3ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 17:39:33.033
		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=4ms, Records=35) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:39:33.033
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
getsetting (Datasource=dynasite9, Time=6ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:39:33.033
			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=3ms, Records=0) in D:\Web\Web-Aktiv10\blueblabla\cshop\_warenkorb_action.cfm @ 17:39:33.033
		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) = 4CB6084F-C6B7-C378-311832A41B3618E2

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=6ms, Records=178) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:39:33.033
	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=3ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:39:33.033
			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=2ms, Records=1) in C:\ColdFusion9\CustomTags\cfc\menus.cfc @ 17:39:33.033
			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=15ms, Records=15) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 17:39:33.033
		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=8ms, Records=157) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:39:33.033
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
GetMenus (Datasource=dynasite9, Time=9ms, Records=48) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:39:33.033
				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) = 513209

DSGetArticles (Datasource=dynasite9, Time=5ms, Records=0) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:39:33.033
				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) = 513209
Parameter #2(cf_sql_varchar) = global
Parameter #3(cf_sql_integer) = 0
Parameter #4(cf_sql_integer) = 1

DSGetArticles (Datasource=dynasite9, Time=2ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:39:33.033
				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) = 513209
Parameter #2(cf_sql_varchar) = global
Parameter #3(cf_sql_integer) = 1

getxmlColumnData (Datasource=dynasite9, Time=6ms, Records=0) in D:\Web\dynasite_codebase\output\_dsarticle_css.cfm @ 17:39:33.033
				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) = 513209

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

getsetting (Datasource=dynasite9, Time=4ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:39:33.033
			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:39:33.033
		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=3ms, Records=3) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 17:39:33.033
		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) = 513209

QKategorien (Datasource=dynasite9_modules, Time=1ms, Records=0) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 17:39:33.033
			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:39:33.033
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
GetInclude (Datasource=dynasite9, Time=2ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 17:39:33.033
		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=3ms, Records=35) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:39:33.033
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
getsetting (Datasource=dynasite9, Time=4ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:39:33.033
			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=5ms, Records=0) in D:\Web\Web-Aktiv10\blueblabla\cshop\_warenkorb_action.cfm @ 17:39:33.033
		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) = 4CB6084F-C6B7-C378-311832A41B3618E2

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=5ms, Records=178) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:39:33.033
	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=2ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:39:33.033
			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=3ms, Records=1) in C:\ColdFusion9\CustomTags\cfc\menus.cfc @ 17:39:33.033
			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:39:33.033
		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=9ms, Records=157) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:39:33.033
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder


Stored Procedures

DSVariableInit2 (Datasource=dynasite9, Time=4ms) in D:\Web\dynasite_codebase\_xdscache.cfm @ 17:39:33.033

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  513209    
 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=38ms) in D:\Web\dynasite_codebase\_xdsinit.cfm @ 17:39:33.033
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_INTEGER  9535    
 IN  CF_SQL_INTEGER  513209    
 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=2ms) in D:\Web\dynasite_codebase\output\_dsoutput.cfm @ 17:39:33.033
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_Integer  9535    
 IN  CF_SQL_Integer  513209    
 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=/beschichtete-baumwolle&
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=11618961
cftoken=16517777
hitcount=1
lastvisit={ts '2019-03-26 17:39:33'}
timecreated={ts '2019-03-26 17:39:33'}
urltoken=CFID=11618961&CFTOKEN=16517777
Cookie Variables:
CFID=11618961
CFTOKEN=16517777
Form Fields:
CSHOP_AKTION=
CSHOP_BEREICH=Bereich
CSHOP_KATEGORIE=
CSHOP_NEUHEITEN=
CSHOP_SEARCH=
CSHOP_SEO=0
CSHOP_SUBMENU=
DSSEARCH_EDITMODE=1
Session Variables:
cfid=11618961
cftoken=16517777
kunde=4CB6084F-C6B7-C378-311832A41B3618E2
menuslist=513200,513209
secure=4CB60850-C973-2E80-0D21C7FFE7A1B858
sessioncheck_5238=true
sessionid=DYNASITE_CREANET_5238_11618961_16517777
urltoken=CFID=11618961&CFTOKEN=16517777
URL Parameters:
friendly_path_info=/beschichtete-baumwolle
Debug Rendering Time: 37 ms