Stellenangebot

Kontakt

Haben wir Ihr Interesse geweckt? Dann zögern Sie nicht und nehmen Sie gleich mit uns Kontakt auf. Klicken Sie auf den unten aufgeführten Link und füllen Sie das Formular aus. Wir werden uns dann so schnell wie möglich bei Ihnen melden.

direkt zum Formular

Haslimann Aufzüge AG
Grasweg 24
CH-6222 Gunzwil 

+41 41 932 14 40
Störungsnummer:
0848 003 003


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


Execution Time

Total Time Avg Time Count Template
152 ms 152 ms 1 top level D:\Web\Web-Aktiv3\haslimann\dynasite.cfm
145 ms 145 ms 1 D:/Web/dynasite_codebase/_xdsinit.cfm
111 ms 111 ms 1 D:/Web/dynasite_codebase/output/_dsoutput.cfm
84 ms 28 ms 3 D:/Web/dynasite_codebase/output/_dsinclude.cfm
53 ms 27 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
46 ms 23 ms 2 D:/Web/dynasite_codebase/output/_dssnippet.cfm
38 ms 19 ms 2 D:/Web/Web-Aktiv3/haslimann/project/_default.cfm
28 ms 28 ms 1 D:/Web/dynasite_codebase/init/_initialize.cfm
26 ms 26 ms 1 D:/Web/dynasite_codebase/udf/_udf.cfm
24 ms 24 ms 1 D:/Web/dynasite_codebase/output/_dscommand.cfm
20 ms 10 ms 2 D:/Web/Web-Aktiv3/haslimann/project/_script.cfm
8 ms 3 ms 3 C:/ColdFusion9/CustomTags/fm_contentcenter.cfm
8 ms 8 ms 1 D:/Web/Web-Aktiv3/haslimann/cnews/_news.cfm
8 ms 4 ms 2 D:/Web/Web-Aktiv3/haslimann/project/_navigation.cfm
8 ms 4 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_header.cfm
7 ms 4 ms 2 D:/Web/dynasite_codebase/cached.cfm
7 ms 7 ms 1 D:/Web/dynasite_codebase/output/_dsmenu.cfm
6 ms 6 ms 1 D:/Web/Web-Aktiv3/haslimann/cnews/_news_action.cfm
6 ms 6 ms 1 D:/Web/dynasite_codebase/_xdscache.cfm
5 ms 5 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetCMD(55333, 5051, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
5 ms 3 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(0, 9090, 9090, 1, , active, full, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
5 ms 5 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(504586, 9090, 9090, 1, , none, visible, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
4 ms 4 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetLACMD() ] 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, 9090, 504586, 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 1 ms 2 C:/ColdFusion9/CustomTags/fm_html2plain.cfm
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(1D37CD44AFABFC4EE03645221A7BFFB8) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(70FF3FDB01844A8199230D32EBF7317F) ] 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, 9090, 504586, 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 | DSGetSetting(view) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
1 ms 0 ms 3 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,9090,504586,0,global,dynasite,CV2650) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
1 ms 1 ms 1 D:/Web/Web-Aktiv3/haslimann/dsinit.cfc
1 ms 1 ms 1 D:/Web/dynasite_codebase/init/_variable.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/output/_dslayout_footeroutside.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/udf/_udf_buttonbar.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/udf/_udf_localisation.cfm
0 ms 0 ms 1 C:/ColdFusion9/CustomTags/Includs/_ajaxpaging.cfm
0 ms 0 ms 3 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc | get(true, true) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc
0 ms 0 ms 3 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-Aktiv3/haslimann/cnews/_functions.cfm
0 ms 0 ms 1 D:/Web/Web-Aktiv3/haslimann/project/_init.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_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_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
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
155 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

18:15:01.001 - MissingInclude Exception - in D:/Web/dynasite_codebase/output/_dscommand.cfm : line 51
	    Could not find the included template /dsfront1/Web-Aktiv3/haslimann/cnews/_udf.cfm.
	    


SQL Queries

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

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=1ms, Records=62) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 18:15:01.001
	SELECT Placeholder, Content
	FROM haslimann
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
			)AND SiteLanguage like 'de-CH%'
	ORDER BY placeholder
Qcheckbilder (Datasource=dynasite9, Time=5ms, Records=3) in D:\Web\Web-Aktiv3\haslimann\project\_script.cfm @ 18:15:01.001
        SELECT ID, filename, tags, description, subfolder FROM Asset WHERE dscid = 5051 AND category_ID = 101326 
QBackground (Datasource=dynasite9, Time=4ms, Records=3) in D:\Web\Web-Aktiv3\haslimann\project\_script.cfm @ 18:15:01.001
        SELECT ID, filename, tags, description, subfolder  FROM Asset
        WHERE dscid = 5051 AND category_ID = 101326
        ORDER BY newid()
    
GetMenus (Datasource=dynasite9, Time=2ms, Records=16) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 18:15:01.001
				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 TempLive=1 AND TempHidden=0 
						AND (SCHEDULE=0 OR (SCHEDULE=1 AND (PubDate <= GetDate() AND ExpDate >= GetDate())))
									
				ORDER BY 
					Lft
			
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9090
Parameter #2(cf_sql_varchar) = global

GetMenus (Datasource=dynasite9, Time=3ms, Records=18) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 18:15:01.001
				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) = 9090
Parameter #2(cf_sql_varchar) = global
Parameter #3(cf_sql_integer) = 9090
Parameter #4(cf_sql_integer) = 504586

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

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

getxmlColumnData (Datasource=dynasite9, Time=2ms, Records=0) in D:\Web\dynasite_codebase\output\_dsarticle_css.cfm @ 18:15:01.001
				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) = 504586

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

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

QCategory (Datasource=dynasite9_modules, Time=2ms, Records=2) in D:\Web\Web-Aktiv3\haslimann\cnews\_news_action.cfm @ 18:15:01.001
        SELECT ID, Category_de AS Category, Category_de, 
        (
            SELECT COUNT(haslimann_news.ID) FROM haslimann_news WHERE CategoryID = haslimann_news_cat.ID
        ) AS NewsCount
        FROM haslimann_news_cat
        WHERE Bereich = ? 
        ORDER BY Sort
    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 504586

QView (Datasource=dynasite9_modules, Time=2ms, Records=2) in D:\Web\Web-Aktiv3\haslimann\cnews\_news_action.cfm @ 18:15:01.001
    	SELECT 
        	haslimann_news.ID, Datum, Urldirekt, Startseite, Titel_de AS Titel, Titel_de, 
            Besch_de AS Besch, Besch_de, Url_de AS Url, Url_de, Aktiv, 
            haslimann_news_cat.Category_de AS Category, haslimann_news_cat.Category_de, 
            (SELECT TOP(1) Photo FROM haslimann_news_photo WHERE NewsID = haslimann_news.ID ORDER BY Sort ASC) AS Photo 
        FROM 
        	haslimann_news
        	INNER JOIN haslimann_news_cat ON haslimann_news_cat.ID = haslimann_news.CategoryID 
        WHERE 
        	Bereich = ? AND Aktiv = 1 
       	ORDER BY
        	Datum DESC;
    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 504586

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=2ms, Records=68) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 18:15:01.001
	SELECT Placeholder, Content
	FROM haslimann
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
					OR
				
				modul = 'news'
				
			)AND SiteLanguage like 'de-CH%'
	ORDER BY placeholder
GetInclude (Datasource=dynasite9, Time=3ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 18:15:01.001
		SELECT Status, CFParam, CFSET, CacheThis, TemplateName FROM Includes 
		WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5148

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=2ms, Records=62) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 18:15:01.001
	SELECT Placeholder, Content
	FROM haslimann
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
			)AND SiteLanguage like 'de-CH%'
	ORDER BY placeholder
Qcheckbilder (Datasource=dynasite9, Time=4ms, Records=3) in D:\Web\Web-Aktiv3\haslimann\project\_script.cfm @ 18:15:01.001
        SELECT ID, filename, tags, description, subfolder FROM Asset WHERE dscid = 5051 AND category_ID = 101326 
QBackground (Datasource=dynasite9, Time=6ms, Records=3) in D:\Web\Web-Aktiv3\haslimann\project\_script.cfm @ 18:15:01.001
        SELECT ID, filename, tags, description, subfolder  FROM Asset
        WHERE dscid = 5051 AND category_ID = 101326
        ORDER BY newid()
    
GetMenus (Datasource=dynasite9, Time=2ms, Records=16) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 18:15:01.001
				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 TempLive=1 AND TempHidden=0 
						AND (SCHEDULE=0 OR (SCHEDULE=1 AND (PubDate <= GetDate() AND ExpDate >= GetDate())))
									
				ORDER BY 
					Lft
			
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9090
Parameter #2(cf_sql_varchar) = global


Stored Procedures

DSVariableInit2 (Datasource=dynasite9, Time=3ms) in D:\Web\dynasite_codebase\_xdscache.cfm @ 18:15:01.001

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5051    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  504586    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_BIT  NO    
 IN  CF_SQL_INTEGER  5051    
 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=2ms) in D:\Web\dynasite_codebase\_xdsinit.cfm @ 18:15:01.001
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5051    
 IN  CF_SQL_INTEGER  9090    
 IN  CF_SQL_INTEGER  504586    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_BIT  NO    
 IN  CF_SQL_INTEGER  5051    
 IN  CF_SQL_VARCHAR  global    
 OUT  CF_SQL_INTEGER    URL.DSCID = URL.DSCID  
 OUT  CF_SQL_INTEGER    URL.DSSID = URL.DSSID  
 OUT  CF_SQL_INTEGER    URL.DSMID = URL.DSMID  
 OUT  CF_SQL_INTEGER    URL.DSPAID = URL.DSPAID  
 OUT  CF_SQL_INTEGER    Request.DSDID = Request.DSDID  
 OUT  CF_SQL_BIT    Request.DSIsCSS = Request.DSIsCSS  
 OUT  CF_SQL_INTEGER    Request.DSDIDCV = Request.DSDIDCV  
    
resultsets
nameresultset
 GetDSCID  1
 GetDSSID  2
 GetDSMID  3
DSContent (Datasource=dynasite9, Time=2ms) in D:\Web\dynasite_codebase\output\_dsoutput.cfm @ 18:15:01.001
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_Integer  9090    
 IN  CF_SQL_Integer  504586    
 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=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Web\Web-Aktiv3\haslimann\dynasite.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=haslimann.ch
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=/dynasite.cfm
PATH_TRANSLATED=D:\Web\Web-Aktiv3\haslimann\dynasite.cfm
QUERY_STRING=dsmid=504586
REMOTE_ADDR=18.194.150.228
REMOTE_HOST=18.194.150.228
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/dynasite.cfm
SERVER_NAME=haslimann.ch
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Cookie Variables:
CFID=16212125
CFTOKEN=54733575
Form Fields:
DSSEARCH_EDITMODE=1
NEWS_CAT=
NEWS_SEARCH=
Session Variables:
cfid=16212125
cftoken=54733575
sessionid=DYNASITE_CREANET_5051_16212125_54733575
urltoken=CFID=16212125&CFTOKEN=54733575
URL Parameters:
dsmid=504586
Debug Rendering Time: 32 ms