Ein starkes Team

Unsere Leistungen

Die persönliche Beratung steht bei uns im Vordergrund. Mit einer soliden Firmenstruktur
und einem flexiblen Team meistern wir auch grösste Herausforderungen. Sie können sich
in jeder Phase des Projekts auf eine Zusammenarbeit mit Fachleuten verlassen!

WIR BERATEN SIE GERNE PERSÖNLICH.

  1 - 10 / 91  

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
183 ms 183 ms 1 top level D:\Web\Web-Aktiv3\haslimann\dynasite.cfm
172 ms 172 ms 1 D:/Web/dynasite_codebase/_xdsinit.cfm
139 ms 139 ms 1 D:/Web/dynasite_codebase/output/_dsoutput.cfm
108 ms 36 ms 3 D:/Web/dynasite_codebase/output/_dsinclude.cfm
77 ms 39 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
50 ms 50 ms 1 D:/Web/dynasite_codebase/output/_dscommand.cfm
47 ms 24 ms 2 D:/Web/dynasite_codebase/output/_dssnippet.cfm
43 ms 22 ms 2 D:/Web/Web-Aktiv3/haslimann/project/_default.cfm
33 ms 33 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetSetting(view) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
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 11 ms 2 D:/Web/Web-Aktiv3/haslimann/project/_script.cfm
10 ms 10 ms 1 D:/Web/dynasite_codebase/_xdscache.cfm
9 ms 3 ms 3 C:/ColdFusion9/CustomTags/fm_contentcenter.cfm
9 ms 5 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 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
7 ms 7 ms 1 D:/Web/dynasite_codebase/output/_dsmenu.cfm
5 ms 5 ms 1 D:/Web/Web-Aktiv3/haslimann/cteam/_team.cfm
5 ms 5 ms 1 D:/Web/Web-Aktiv3/haslimann/cteam/_team_action.cfm
4 ms 4 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 1,2,3,4,5,6, News.Row,News.Sorting, 9090, 501975, 0, 0, 0, 0, 0, , 1, 1, , , , , , , 0, 1, 25, global, , 0, 0, , 0, , 1, 0) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
4 ms 4 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetCMD(55409, 5051, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
4 ms 4 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(501975, 9090, 9090, 1, , none, visible, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
4 ms 2 ms 2 D:/Web/dynasite_codebase/cached.cfm
3 ms 3 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetLACMD() ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(FD7352779D317B86D25110FFE9D40773) ] 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,9090,501975,0,global,dynasite,CV2650friendly_path_info=/team&) ] 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, 501975, 0, 0, 0, 0, 0, , 1, 1, , , , , , , 0, 1, 25, global, , 0, 0, , 0, , 1, 0) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
2 ms 2 ms 1 D:/Web/dynasite_codebase/init/_variable.cfm
1 ms 1 ms 2 C:/ColdFusion9/CustomTags/Includs/_ajaxpaging.cfm
1 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
1 ms 1 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(D5067C779A6F978756ED14693FA7009A) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
1 ms 1 ms 1 D:/Web/dynasite_codebase/output/_dslayout_footeroutside.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/udf/_udf_content_explorer.cfm
0 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
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/cteam/_functions.cfm
0 ms 0 ms 1 D:/Web/Web-Aktiv3/haslimann/dsinit.cfc
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_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_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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
185 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

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


SQL Queries

GetInclude (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 18:15:39.039
		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=3ms, Records=62) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 18:15:39.039
	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:39.039
        SELECT ID, filename, tags, description, subfolder FROM Asset WHERE dscid = 5051 AND category_ID = 101326 
QBackground (Datasource=dynasite9, Time=5ms, Records=3) in D:\Web\Web-Aktiv3\haslimann\project\_script.cfm @ 18:15:39.039
        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:39.039
				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=4ms, Records=18) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 18:15:39.039
				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) = 501975

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

DSGetArticles (Datasource=dynasite9, Time=2ms, Records=2) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 18:15:39.039
				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) = 501975
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 @ 18:15:39.039
				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) = 501975

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

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

QView (Datasource=dynasite9_modules, Time=3ms, Records=91) in D:\Web\Web-Aktiv3\haslimann\cteam\_team_action.cfm @ 18:15:39.039
		SELECT ID, Category, Vorname, Nachname, Email, Telefon, Funktion, Aktiv, Sort, Portrait
		FROM haslimann_team
		WHERE Bereich=? AND Aktiv=1 
		ORDER BY Sort ASC;
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 501975

QCategory (Datasource=dynasite9_modules, Time=1ms, Records=12) in D:\Web\Web-Aktiv3\haslimann\cteam\_team_action.cfm @ 18:15:39.039
		SELECT DISTINCT haslimann_team_category.ID, Category_de AS Category, Category_de, haslimann_team_category.Sort
		FROM haslimann_team_category
		WHERE Bereich = ?
		ORDER BY haslimann_team_category.Sort ASC;
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 501975

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=2ms, Records=86) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 18:15:39.039
	SELECT Placeholder, Content
	FROM haslimann
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
					OR
				
				modul = 'team'
				
					OR
				
				modul = 'form'
				
			)AND SiteLanguage like 'de-CH%'
	ORDER BY placeholder
GetInclude (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 18:15:39.039
		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=3ms, Records=62) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 18:15:39.039
	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:39.039
        SELECT ID, filename, tags, description, subfolder FROM Asset WHERE dscid = 5051 AND category_ID = 101326 
QBackground (Datasource=dynasite9, Time=5ms, Records=3) in D:\Web\Web-Aktiv3\haslimann\project\_script.cfm @ 18:15:39.039
        SELECT ID, filename, tags, description, subfolder  FROM Asset
        WHERE dscid = 5051 AND category_ID = 101326
        ORDER BY newid()
    
GetMenus (Datasource=dynasite9, Time=3ms, Records=16) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 18:15:39.039
				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=1ms) in D:\Web\dynasite_codebase\_xdscache.cfm @ 18:15:39.039

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5051    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  501975    
 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:39.039
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5051    
 IN  CF_SQL_INTEGER  9090    
 IN  CF_SQL_INTEGER  501975    
 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=1ms) in D:\Web\dynasite_codebase\output\_dsoutput.cfm @ 18:15:39.039
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_Integer  9090    
 IN  CF_SQL_Integer  501975    
 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=0
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=friendly_path_info=/team&
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=16212178
CFTOKEN=69590746
Form Fields:
DSSEARCH_EDITMODE=1
TEAM_CAT=
TEAM_SEARCH=
Session Variables:
cfid=16212178
cftoken=69590746
sessionid=DYNASITE_CREANET_5051_16212178_69590746
urltoken=CFID=16212178&CFTOKEN=69590746
URL Parameters:
friendly_path_info=/team
Debug Rendering Time: 36 ms