Dry Oilskin

Dry Oilskin von Merchant & Mills, ist wasserabweisend, kompakt gewoben und schützt vor Nässe und Wind. Der Stoff hat ein schickes, mattes finish und eignet sich sehr gut für Taschen, Accessoires, Mäntel und Jacken.

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
304 ms 304 ms 1 D:/Web/Web-Aktiv10/blueblabla/dynasite.cfm
295 ms 295 ms 1 D:/Web/dynasite_codebase/_xdsinit.cfm
260 ms 260 ms 1 D:/Web/dynasite_codebase/output/_dsoutput.cfm
225 ms 75 ms 3 D:/Web/dynasite_codebase/output/_dsinclude.cfm
178 ms 89 ms 2 D:/Web/dynasite_codebase/output/_dssnippet.cfm
173 ms 87 ms 2 D:/Web/Web-Aktiv10/blueblabla/project/_default.cfm
156 ms 31 ms 5 D:/Web/dynasite_codebase/output/_dscommand.cfm
62 ms 31 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
52 ms 17 ms 3 D:/Web/Web-Aktiv10/blueblabla/cshop/_shop_action.cfm
29 ms 4 ms 7 C:/ColdFusion9/CustomTags/fm_contentcenter.cfm
29 ms 10 ms 3 D:/Web/Web-Aktiv10/blueblabla/cshop/_shop.cfm
29 ms 29 ms 1 D:/Web/dynasite_codebase/init/_initialize.cfm
26 ms 3 ms 10 D:/Web/dynasite_codebase/cached.cfm
26 ms 26 ms 1 D:/Web/dynasite_codebase/udf/_udf.cfm
18 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
12 ms 6 ms 2 D:/Web/Web-Aktiv10/blueblabla/cshop/_warenkorb.cfm
11 ms 11 ms 1 D:/Web/dynasite_codebase/output/_dsmenu.cfm
8 ms 4 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
8 ms 4 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
8 ms 8 ms 1 D:/Web/dynasite_codebase/_xdscache.cfm
7 ms 4 ms 2 D:/Web/Web-Aktiv10/blueblabla/cshop/_warenkorb_action.cfm
7 ms 4 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_header.cfm
6 ms 3 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/menus.cfc | getMenu(language = de, dsmid = 513200) ] from C:/ColdFusion9/CustomTags/cfc/menus.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
6 ms 6 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(519775, 9535, 9535, 1, , none, visible, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
4 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
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
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 1 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(AD3B7A9B0A2E34879A620D92FD9E09BA) ] 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[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 0, News.Row,News.Sorting, 9535, 519775, 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, 519775, 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 D:/Web/dynasite_codebase/init/_variable.cfm
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 1 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(dynasite9,9535,519775,0,global,dynasite,CV9445friendly_path_info=/dry-oilskin&) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
1 ms 1 ms 1 D:/Web/Web-Aktiv10/blueblabla/dsinit.cfc
1 ms 1 ms 1 D:/Web/Web-Aktiv10/blueblabla/project/_init.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 = dry oilskin black) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = dry oilskin bracked) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = dry oilskin cumin) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = dry oilskin fern) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = dry oilskin grass) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = dry oilskin khaki) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = dry oilskin midnightblue) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = dry oilskin navy) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = dry oilskin olive) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = dry oilskin oxblood) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = dry oilskin storm) ] 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 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
11 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
315 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

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

GetInclude (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 17:13:40.040
		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=2ms, Records=35) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:13:40.040
	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:40.040
			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:40.040
		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) = 4BC91C4E-A9CF-398C-E9B57779B1F3E663

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=7ms, Records=178) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:13:40.040
	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=0ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:13:40.040
			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:13:40.040
			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=16ms, Records=15) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 17:13:40.040
		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=3ms, Records=157) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:13:40.040
	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:41.041
				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) = 519775

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

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

getCommand (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 17:13:41.041
				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:41.041
			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=3ms, Records=0) in D:\Web\Web-Aktiv10\blueblabla\cshop\_functions.cfm @ 17:13:41.041
		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=5ms, Records=11) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 17:13:41.041
		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) = 519775

QKategorien (Datasource=dynasite9_modules, Time=2ms, Records=2) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 17:13:41.041
			SELECT DISTINCT
				ID, Sort,
				ISNULL(NULLIF(Category_de,''), Category_de) AS Category
			FROM
				blueblabla_shop_category
			WHERE
				1=2
				
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
						OR ID = ? 
			ORDER BY
				Sort ASC;
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 77
Parameter #2(cf_sql_integer) = 75
Parameter #3(cf_sql_integer) = 77
Parameter #4(cf_sql_integer) = 75
Parameter #5(cf_sql_integer) = 77
Parameter #6(cf_sql_integer) = 75
Parameter #7(cf_sql_integer) = 77
Parameter #8(cf_sql_integer) = 75
Parameter #9(cf_sql_integer) = 77
Parameter #10(cf_sql_integer) = 75
Parameter #11(cf_sql_integer) = 77
Parameter #12(cf_sql_integer) = 75
Parameter #13(cf_sql_integer) = 77
Parameter #14(cf_sql_integer) = 75
Parameter #15(cf_sql_integer) = 77
Parameter #16(cf_sql_integer) = 75
Parameter #17(cf_sql_integer) = 77
Parameter #18(cf_sql_integer) = 75

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=2ms, Records=157) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:13:41.041
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
GetInclude (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 17:13:41.041
		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:41.041
	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:41.041
			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:13:41.041
		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) = 4BC91C4E-A9CF-398C-E9B57779B1F3E663

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=3ms, Records=178) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:13:41.041
	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:13:41.041
			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:13:41.041
			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:13:41.041
		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:41.041
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  519775    
 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=3ms) in D:\Web\dynasite_codebase\_xdsinit.cfm @ 17:13:40.040
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_INTEGER  9535    
 IN  CF_SQL_INTEGER  519775    
 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=1ms) in D:\Web\dynasite_codebase\output\_dsoutput.cfm @ 17:13:40.040
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_Integer  9535    
 IN  CF_SQL_Integer  519775    
 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=/dry-oilskin&
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=11618488
cftoken=93440985
hitcount=1
lastvisit={ts '2019-03-26 17:13:40'}
timecreated={ts '2019-03-26 17:13:40'}
urltoken=CFID=11618488&CFTOKEN=93440985
Cookie Variables:
CFID=11618488
CFTOKEN=93440985
Form Fields:
CSHOP_AKTION=
CSHOP_BEREICH=Bereich
CSHOP_KATEGORIE=
CSHOP_NEUHEITEN=
CSHOP_SEARCH=
CSHOP_SEO=0
CSHOP_SUBMENU=
DSSEARCH_EDITMODE=1
Session Variables:
cfid=11618488
cftoken=93440985
kunde=4BC91C4E-A9CF-398C-E9B57779B1F3E663
menuslist=519773,519775
secure=4BC91C4F-F9FB-E4F4-3344BD46DC5012E7
sessioncheck_5238=true
sessionid=DYNASITE_CREANET_5238_11618488_93440985
urltoken=CFID=11618488&CFTOKEN=93440985
URL Parameters:
friendly_path_info=/dry-oilskin
Debug Rendering Time: 49 ms