Taschen

Filter ausblenden Filter einblenden


Debugging Information
ColdFusion Server Enterprise 9,0,1,274733
Template /dynasite.cfm
Time Stamp 26-Mar-19 06:11 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
372 ms 372 ms 1 D:/Web/Web-Aktiv10/blueblabla/dynasite.cfm
366 ms 366 ms 1 D:/Web/dynasite_codebase/_xdsinit.cfm
332 ms 332 ms 1 D:/Web/dynasite_codebase/output/_dsoutput.cfm
300 ms 100 ms 3 D:/Web/dynasite_codebase/output/_dsinclude.cfm
230 ms 46 ms 5 D:/Web/dynasite_codebase/output/_dscommand.cfm
223 ms 112 ms 2 D:/Web/dynasite_codebase/output/_dssnippet.cfm
217 ms 109 ms 2 D:/Web/Web-Aktiv10/blueblabla/project/_default.cfm
95 ms 48 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
88 ms 29 ms 3 D:/Web/Web-Aktiv10/blueblabla/cshop/_shop.cfm
67 ms 10 ms 7 C:/ColdFusion9/CustomTags/fm_contentcenter.cfm
58 ms 19 ms 3 D:/Web/Web-Aktiv10/blueblabla/cshop/_shop_action.cfm
33 ms 3 ms 10 D:/Web/dynasite_codebase/cached.cfm
26 ms 26 ms 1 D:/Web/dynasite_codebase/init/_initialize.cfm
22 ms 22 ms 1 D:/Web/dynasite_codebase/udf/_udf.cfm
21 ms 4 ms 5 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetSetting(view) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
17 ms 3 ms 5 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetLACMD() ] 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
9 ms 5 ms 2 D:/Web/Web-Aktiv10/blueblabla/cshop/_warenkorb_action.cfm
7 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
7 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
7 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 6 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(513577, 9535, 9535, 1, , none, visible, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
6 ms 6 ms 1 D:/Web/dynasite_codebase/_xdscache.cfm
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 | DSGetCMD(76885, 5238, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.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 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 2 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/menus.cfc | getMenu(language = de, dsmid = 513200) ] from C:/ColdFusion9/CustomTags/cfc/menus.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 3 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(BA9B3189B759F22E5ABB35482531DDEB) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/menus.cfc | getMenu(language = de, dsmid = 513577) ] from C:/ColdFusion9/CustomTags/cfc/menus.cfc
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(117B85C8A5E138EFD17AEB215A8BF219) ] 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, 513577, 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, 513577, 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/Web-Aktiv10/blueblabla/dsinit.cfc
2 ms 2 ms 1 D:/Web/Web-Aktiv10/blueblabla/project/_init.cfm
1 ms 1 ms 2 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,513577,0,global,dynasite,CV9445friendly_path_info=/aktuelles/dynasite.cfm) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
1 ms 1 ms 1 D:/Web/Web-Aktiv10/blueblabla/cshop/_functions.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
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = emil (tkmn)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = emil (tkon)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = emil) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = frieda (tkmn)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = frieda (tkon)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = frieda) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = greta (tkmn)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = greta (tkon)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = greta mini) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = lotta maxi (tkmn)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = lotta maxi (tkon)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = lotta maxi) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = lotta midi (tkmn)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = lotta midi (tkon)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = lotta midi) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = lotta mini) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = max) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = paula (tkmn)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = paula (tkon)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = paula mit wachstuch) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = paula) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = stroller bag maxi (tkmn)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = stroller bag maxi (tkon)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = stroller bag maxi) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = stroller bag midi (tkmn)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = stroller bag midi (tkon)) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = stroller bag midi) ] 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 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
14 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
386 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

18:11:58.058 - 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.
	    
18:11:58.058 - 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.
	    
18:11:58.058 - 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.
	    
18:11:58.058 - 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.
	    
18:11:58.058 - 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 @ 18:11:58.058
	Select DsmidNeu, DsmidAlt FROM blueblabla_seo
	WHERE 1=2
	
		OR DsmidAlt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = aktuelles/dynasite.cfm

GetInclude (Datasource=dynasite9, Time=0ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 18:11:58.058
		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 @ 18:11:58.058
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
getsetting (Datasource=dynasite9, Time=0ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 18:11:58.058
			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 @ 18:11:58.058
		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) = 4DDECE58-E25D-B75D-AB28B5099BBE02D0

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=3ms, Records=178) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 18:11:58.058
	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 @ 18:11:58.058
			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 @ 18:11:58.058
			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 @ 18:11:58.058
		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 @ 18:11:58.058
	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 @ 18:11:58.058
				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) = 513577

DSGetArticles (Datasource=dynasite9, Time=1ms, Records=0) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 18:11:58.058
				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) = 513577
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 @ 18:11:58.058
				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) = 513577
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 @ 18:11:58.058
				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) = 513577

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

getsetting (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 18:11:58.058
			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 @ 18:11:58.058
		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=27) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 18:11:58.058
		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.Hauptbereich = ? AND produkt.Aktiv = 1 
		ORDER BY
			menus.Sort, produkt.Titel_de ASC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 513577

QSubmenus (Datasource=dynasite9_modules, Time=1ms, Records=3) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 18:11:58.058
			SELECT DISTINCT
				menus.ID, menus.Menutext, menus.Sort
			FROM
				blueblabla_shop_produkt AS produkt
				INNER JOIN [dynasite9].[dbo].[Menus] AS menus ON menus.ID = produkt.Bereich
			WHERE
				DSPMID = ?
				AND menus.Live IN (1,3)	
				
				AND produkt.Aktiv = 1
			ORDER BY
				menus.Sort ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 513577

QKategorien (Datasource=dynasite9_modules, Time=5ms, Records=10) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 18:11:58.058
			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 = ? 
						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) = 40
Parameter #2(cf_sql_integer) = 4
Parameter #3(cf_sql_integer) = 37
Parameter #4(cf_sql_integer) = 6
Parameter #5(cf_sql_integer) = 37
Parameter #6(cf_sql_integer) = 5
Parameter #7(cf_sql_integer) = 37
Parameter #8(cf_sql_integer) = 4
Parameter #9(cf_sql_integer) = 41
Parameter #10(cf_sql_integer) = 6
Parameter #11(cf_sql_integer) = 38
Parameter #12(cf_sql_integer) = 36
Parameter #13(cf_sql_integer) = 6
Parameter #14(cf_sql_integer) = 36
Parameter #15(cf_sql_integer) = 5
Parameter #16(cf_sql_integer) = 42
Parameter #17(cf_sql_integer) = 42
Parameter #18(cf_sql_integer) = 42
Parameter #19(cf_sql_integer) = 42
Parameter #20(cf_sql_integer) = 42
Parameter #21(cf_sql_integer) = 42
Parameter #22(cf_sql_integer) = 42
Parameter #23(cf_sql_integer) = 42
Parameter #24(cf_sql_integer) = 47
Parameter #25(cf_sql_integer) = 47
Parameter #26(cf_sql_integer) = 47
Parameter #27(cf_sql_integer) = 47
Parameter #28(cf_sql_integer) = 47
Parameter #29(cf_sql_integer) = 47

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=5ms, Records=157) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 18:11:58.058
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
QMenu (Datasource=dynasite9_modules, Time=2ms, Records=1) in C:\ColdFusion9\CustomTags\cfc\menus.cfc @ 18:11:58.058
			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) = 513577

GetInclude (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 18:11:58.058
		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=1ms, Records=35) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 18:11:58.058
	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 @ 18:11:58.058
			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 @ 18:11:58.058
		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) = 4DDECE58-E25D-B75D-AB28B5099BBE02D0

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=4ms, Records=178) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 18:11:58.058
	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 @ 18:11:58.058
			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 @ 18:11:58.058
			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=21ms, Records=15) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 18:11:58.058
		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=40ms, Records=157) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 18:11:58.058
	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 @ 18:11:58.058

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  513577    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_BIT  NO    
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_VARCHAR  aktuelles    
 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=2ms) in D:\Web\dynasite_codebase\_xdsinit.cfm @ 18:11:58.058
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_INTEGER  9535    
 IN  CF_SQL_INTEGER  513577    
 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 @ 18:11:58.058
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_Integer  9535    
 IN  CF_SQL_Integer  513577    
 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=/aktuelles/dynasite.cfm&dsmid=513577
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=11619314
cftoken=29320145
hitcount=1
lastvisit={ts '2019-03-26 18:11:58'}
timecreated={ts '2019-03-26 18:11:58'}
urltoken=CFID=11619314&CFTOKEN=29320145
Cookie Variables:
CFID=11619314
CFTOKEN=29320145
Form Fields:
CSHOP_AKTION=
CSHOP_BEREICH=Hauptbereich
CSHOP_KATEGORIE=
CSHOP_NEUHEITEN=
CSHOP_SEARCH=
CSHOP_SEO=0
CSHOP_SUBMENU=
DSSEARCH_EDITMODE=1
Session Variables:
cfid=11619314
cftoken=29320145
kunde=4DDECE58-E25D-B75D-AB28B5099BBE02D0
menuslist=513577
secure=4DDECE59-BD50-B5EF-A528C5E7CA92ABC5
sessioncheck_5238=true
sessionid=DYNASITE_CREANET_5238_11619314_29320145
urltoken=CFID=11619314&CFTOKEN=29320145
URL Parameters:
dsmid=513577
friendly_path_info=/aktuelles/dynasite.cfm
Debug Rendering Time: 40 ms