Aktuelles

Filter ausblenden Filter einblenden


Debugging Information
ColdFusion Server Enterprise 9,0,1,274733
Template /dynasite.cfm
Time Stamp 26-Mar-19 05:14 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
322 ms 322 ms 1 D:/Web/Web-Aktiv10/blueblabla/dynasite.cfm
313 ms 313 ms 1 D:/Web/dynasite_codebase/_xdsinit.cfm
265 ms 265 ms 1 D:/Web/dynasite_codebase/output/_dsoutput.cfm
231 ms 77 ms 3 D:/Web/dynasite_codebase/output/_dsinclude.cfm
194 ms 97 ms 2 D:/Web/dynasite_codebase/output/_dssnippet.cfm
190 ms 95 ms 2 D:/Web/Web-Aktiv10/blueblabla/project/_default.cfm
157 ms 31 ms 5 D:/Web/dynasite_codebase/output/_dscommand.cfm
52 ms 26 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
43 ms 22 ms 2 D:/Web/Web-Aktiv10/blueblabla/cshop/_shop_action.cfm
41 ms 41 ms 1 D:/Web/dynasite_codebase/init/_initialize.cfm
36 ms 36 ms 1 D:/Web/dynasite_codebase/udf/_udf.cfm
35 ms 5 ms 7 C:/ColdFusion9/CustomTags/fm_contentcenter.cfm
35 ms 4 ms 10 D:/Web/dynasite_codebase/cached.cfm
23 ms 5 ms 5 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetSetting(view) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
20 ms 4 ms 5 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetLACMD() ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
16 ms 8 ms 2 D:/Web/Web-Aktiv10/blueblabla/cshop/_warenkorb.cfm
13 ms 13 ms 1 D:/Web/Web-Aktiv10/blueblabla/cnews/_news.cfm
11 ms 6 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
11 ms 6 ms 2 D:/Web/Web-Aktiv10/blueblabla/cshop/_shop.cfm
11 ms 11 ms 1 D:/Web/dynasite_codebase/output/_dsmenu.cfm
10 ms 5 ms 2 D:/Web/Web-Aktiv10/blueblabla/cshop/_warenkorb_action.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 8 ms 1 D:/Web/dynasite_codebase/_xdscache.cfm
8 ms 4 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_header.cfm
6 ms 3 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(392833F3AC87CB7AF60BA7B9363DC98A) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
6 ms 6 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(513198, 9535, 9535, 1, , none, visible, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.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 0 ms 11 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc | get(true, true) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc
5 ms 3 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(B12C5B0E1EADBED72B2CA0548BC788A2) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
4 ms 2 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(4AE9BE86CB7DE317856DE4690FDD92D4) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.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
4 ms 4 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetCMD(76745, 5238, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
4 ms 4 ms 1 D:/Web/Web-Aktiv10/blueblabla/dsinit.cfc
3 ms 3 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 0, News.Row,News.Sorting, 9535, 513198, 0, 0, 0, 0, 0, , 1, 1, , , , , , , 0, 1, 25, global, , 0, 0, , 0, , 1, 0) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
3 ms 3 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 1,2,3,4,5,6, News.Row,News.Sorting, 9535, 513198, 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[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = Paula nähen in der Stoffkiste) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
2 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
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(57B7470536F888C4308ED4D3CE95E40A) ] 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,513198,0,global,dynasite,CV9445friendly_path_info=/aktuelles/dynasite.cfm) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
2 ms 2 ms 1 D:/Web/dynasite_codebase/init/_variable.cfm
1 ms 1 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
1 ms 1 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(3F6110C0887CF01D985722DDCA711E5E) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
1 ms 1 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSIsEditable(dsaid) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
1 ms 1 ms 1 D:/Web/Web-Aktiv10/blueblabla/project/_init.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/customer/creanet/_dscustinit.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/udf/_udf_finance.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/udf/_udf_paging.cfm
0 ms 0 ms 1 C:/ColdFusion9/CustomTags/Includs/_ajaxpaging.cfm
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = Metallisierte Reissverschlüsse) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = Wachstuch Reststücke) ] from C:/ColdFusion9/CustomTags/cfc/functions.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 1 D:/Web/Web-Aktiv10/blueblabla/cnews/_functions.cfm
0 ms 0 ms 1 D:/Web/Web-Aktiv10/blueblabla/cnews/_news_action.cfm
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/output/_dslayout_footeroutside.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_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_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
13 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
335 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

17:14:22.022 - 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:14:22.022 - 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:14:22.022 - MissingInclude Exception - in D:/Web/dynasite_codebase/output/_dscommand.cfm : line 51
	    Could not find the included template /dsfront1/Web-Aktiv10/blueblabla/cnews/_udf.cfm.
	    
17:14:22.022 - 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:14:22.022 - 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=3ms, Records=0) in D:\Web\Web-Aktiv10\blueblabla\dsinit.cfc @ 17:14:22.022
	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=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 17:14:22.022
		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=3ms, Records=35) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:14:22.022
	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 @ 17:14:22.022
			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:14:22.022
		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) = 4BCF6A26-D102-06E7-5FE239CD094E139B

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=6ms, Records=178) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:14:22.022
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
					OR
				
				modul = 'form'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
getsetting (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:14:22.022
			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:14:22.022
			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=19ms, Records=15) in D:\Web\Web-Aktiv10\blueblabla\cshop\_shop_action.cfm @ 17:14:22.022
		SELECT TOP 15
			produkt.ID, produkt.Kategorien, produkt.Aktiv, produkt.Neuheit,
			ISNULL(NULLIF(produkt.Titel_de,''), produkt.Titel_de) AS Titel,
			ISNULL(NULLIF(produkt.Beschreibung_de,''), produkt.Beschreibung_de) AS Beschreibung,
			(SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = produkt.ID ORDER BY Sort ASC) AS Photo,
			ISNULL(Preis,0) AS Preis,
			ISNULL(Aktionspreis,0) AS Aktionspreis,
			menus.Menutext
		FROM
			blueblabla_shop_produkt AS produkt
			INNER JOIN [dynasite9].[dbo].[Menus] AS menus ON menus.ID = produkt.Bereich
		WHERE
			produkt.Hauptbereich = ?
			AND produkt.Aktiv = 1
		ORDER BY
			newid()
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 513200

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=4ms, Records=157) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:14:22.022
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
GetMenus (Datasource=dynasite9, Time=4ms, Records=48) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:14:22.022
				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) = 513198

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

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

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

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

QCategory (Datasource=dynasite9_modules, Time=0ms, Records=7) in D:\Web\Web-Aktiv10\blueblabla\cnews\_news_action.cfm @ 17:14:22.022
		SELECT DISTINCT
			news_category.ID,
			ISNULL(NULLIF(news_category.Category_de,''), news_category.Category_de) AS Category,
			news_category.Sort
		FROM
			blueblabla_news_category AS news_category
			INNER JOIN blueblabla_news AS news ON news_category.ID = news.CategoryID
		WHERE
			news_category.Bereich = ?
		ORDER BY
			news_category.Sort
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 513198

QView (Datasource=dynasite9_modules, Time=0ms, Records=3) in D:\Web\Web-Aktiv10\blueblabla\cnews\_news_action.cfm @ 17:14:22.022
		SELECT
			news.ID, Startseite, Aktiv,
			ISNULL(NULLIF(Titel_de,''), Titel_de) AS Titel,
			ISNULL(NULLIF(Besch_de,''), Besch_de) AS Besch,
			news_category.Category_de AS Category, news_category.Category_de,
			(SELECT TOP(1) Photo FROM blueblabla_news_photo WHERE NewsID = news.ID ORDER BY Sort ASC) AS Photo,
			(SELECT TOP(1) Link FROM blueblabla_news_links WHERE NewsID = news.ID AND Sprache = 'de' AND LEN(Link) > 0 ORDER BY Sort ASC ) AS Link,
			(SELECT TOP(1) Fenster FROM blueblabla_news_links WHERE NewsID = news.ID AND Sprache = 'de' AND LEN(Link) > 0 ORDER BY Sort ASC ) AS Fenster,
			(SELECT TOP(1) ID FROM blueblabla_news_links WHERE NewsID = news.ID AND Sprache = 'de' AND LEN(Datei) > 0 ORDER BY Sort ASC ) AS Datei
		FROM
			blueblabla_news AS news
			INNER JOIN blueblabla_news_category AS news_category ON news_category.ID = news.CategoryID
		WHERE
			Bereich = ? AND Aktiv = 1 
		ORDER BY
			news.Sort ASC;
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 513198

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=5ms, Records=36) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:14:22.022
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'news'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
GetInclude (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 17:14:22.022
		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:14:22.022
	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:14:22.022
			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:14:22.022
		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) = 4BCF6A26-D102-06E7-5FE239CD094E139B

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=5ms, Records=178) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:14:22.022
	SELECT Placeholder, Content
	FROM blueblabla
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'shop'
				
					OR
				
				modul = 'form'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
getsetting (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 17:14:22.022
			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:14:22.022
			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:14:22.022
		SELECT TOP 15
			produkt.ID, produkt.Kategorien, produkt.Aktiv, produkt.Neuheit,
			ISNULL(NULLIF(produkt.Titel_de,''), produkt.Titel_de) AS Titel,
			ISNULL(NULLIF(produkt.Beschreibung_de,''), produkt.Beschreibung_de) AS Beschreibung,
			(SELECT TOP 1 Photo FROM blueblabla_shop_produkt_photo WHERE ProduktID = produkt.ID ORDER BY Sort ASC) AS Photo,
			ISNULL(Preis,0) AS Preis,
			ISNULL(Aktionspreis,0) AS Aktionspreis,
			menus.Menutext
		FROM
			blueblabla_shop_produkt AS produkt
			INNER JOIN [dynasite9].[dbo].[Menus] AS menus ON menus.ID = produkt.Bereich
		WHERE
			produkt.Hauptbereich = ?
			AND produkt.Aktiv = 1
		ORDER BY
			newid()
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 513200

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=4ms, Records=157) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 17:14:22.022
	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:14:22.022

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  513198    
 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=4ms) in D:\Web\dynasite_codebase\_xdsinit.cfm @ 17:14:22.022
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5238    
 IN  CF_SQL_INTEGER  9535    
 IN  CF_SQL_INTEGER  513198    
 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:14:22.022
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_Integer  9535    
 IN  CF_SQL_Integer  513198    
 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=513198
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=11618500
cftoken=21421425
hitcount=1
lastvisit={ts '2019-03-26 17:14:22'}
timecreated={ts '2019-03-26 17:14:22'}
urltoken=CFID=11618500&CFTOKEN=21421425
Cookie Variables:
CFID=11618500
CFTOKEN=21421425
Form Fields:
CNEWS_CATEGORY=
CNEWS_SEARCH=
DSSEARCH_EDITMODE=1
Session Variables:
cfid=11618500
cftoken=21421425
kunde=4BCF6A26-D102-06E7-5FE239CD094E139B
menuslist=513197,513198
secure=4BCF6A27-E6A7-1510-8F309E0505813325
sessioncheck_5238=true
sessionid=DYNASITE_CREANET_5238_11618500_21421425
urltoken=CFID=11618500&CFTOKEN=21421425
URL Parameters:
dsmid=513198
friendly_path_info=/aktuelles/dynasite.cfm
Debug Rendering Time: 34 ms