Geschichte

  • 1929 – 1954 Baugeschäft Josef Renggli
    In Schüpfheim gründete 1929 der damalige Maurer und spätere Baumeister Josef Renggli - Brunner sein eigenes Baugeschäft und bot Maurer- und Ofnerarbeiten an. Die nachfolgenden Bilder illustrieren die hohe Qualität und Zuverlässigkeit, die alsbald in der Region bekannt wurde. Das junge Bauunternehmen wuchs schnell, beschäftigte immer mehr Mitarbeiter und baute seinen funktionellen Fahrzeug- und Maschinenpark aus. Schon damals waren der Unterhalt und das Instandhalten der Fahrzeuge und Maschinen wichtig.

  • 1954 – 1974 Josef Renggli's Söhne
    Ab 1954 übernahmen die beiden Söhne Josef und Hans Renggli von ihrem Vater das inzwischen in Malters domizilierte Baugeschäft. Damals schaffte man sich einen hervorragenden Namen durch die Anwendung innovativer Technik. Insbesondere im Meliorations- und Strassenbau wurden neue und verbesserte Verfahren entwickelt. Dies bedingte auch eine stetige Modernisierung des Fahrzeug- und Maschinenparks. Der Familienbetrieb erhielt die Rechtsform einer Aktiengesellschaft und spezialisierte sich vermehrt auf den Bereich Tiefbau.
  • 1974 – 2002 Hans Renggli Bau AG
    1974 trennten sich die Wege der Brüder Hans und Josef. Unter dem Namen «Hans Renggli Bau AG» verwirklichte der ausgewiesene Baufachmann und Unternehmer Hans Renggli seine Vorstellungen einer modernen und innovativen Bauunternehmung. Dass auch in der Baubranche Ideen und Kreativität für den Geschäftserfolg eine wichtige Rolle spielen, hatte Hans Renggli schon früh erkannt. Vermehrt machte er sich auch Gedanken, wie zur Natur und Umwelt Sorge getragen werden kann. Die Hans Renggli Bau AG kann sich deshalb heute im Recyclieren von Baustoffen zu den Pionieren zählen.
  • 2002-2015
    2002 trat Hans-Ueli Renggli aus dem operativen Geschäft zurück. Die Unternehmung wurde in eine Holding integriert, die Geschäftsführung übernahm Jörg Lütolf. Vom Unwetter im Jahre 2005 wurde auch die Hans Renggli Bau AG nicht verschont. So wurde das komplette Bürogebäude, die Werkstatt, das Archiv sowie das Magazin völlig lahmgelegt. Alles war voller Wasser, Schutt und Dreck. Hier konnte sich die Geschäftsleitung einmal mehr auf ihre Belegschaft verlassen. Hand in Hand wurden der überschwemmte Werkhof, die verdreckten Möbel, defekten PCs und die schlammigen Werkzeuge gereinigt oder entsorgt. Während diesen intensiven Monaten stand die Hans Renggli Bau AG im Dienste der Allgemeinheit und behob viele Schäden, welche die kleine Emme und andere Fliessgewässer hinterlassen hatten. Erstmals seit 2002 wuchs der Personalbestand auf über 50 Mitarbeiterinnen und Mitarbeiter.
    2006 übernahm Theo Baumeler das Ruder von Jörg Lütolf und nahm den Schwung aus der ereignisreichen Zeit mit. Der Maschinenpark wuchs weiter und die Optik des Bürogebäudes und der Werkstatt wurde dem Corporate Designs angepasst.
    2009 stand erneut ein Geschäftsführerwechsel an. Ruedi Hüsler führte die Arbeit von Theo Baumeler fort.
  • 2015- Heute
    Ruedi Hüsler stellte sich neuen Herausforderungen und übergab die Führung an Michael Hauser weiter. Die Hans Renggli bietet heute rund 60 Mitarbeiterinnen und Mitarbeiter einen Arbeitsplatz.


Debugging Information
ColdFusion Server Enterprise 9,0,1,274733
Template /dynasite.cfm
Time Stamp 26-Mar-19 07:06 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
165 ms 165 ms 1 top level D:\Web\Web-Aktiv10\hrbauag\dynasite.cfm
149 ms 149 ms 1 D:/Web/dynasite_codebase/_xdsinit.cfm
87 ms 87 ms 1 D:/Web/dynasite_codebase/output/_dsoutput.cfm
62 ms 31 ms 2 D:/Web/dynasite_codebase/output/_dssnippet.cfm
61 ms 31 ms 2 D:/Web/dynasite_codebase/output/_dsinclude.cfm
53 ms 27 ms 2 D:/Web/Web-Aktiv10/hrbauag/project/_default.cfm
37 ms 37 ms 1 D:/Web/dynasite_codebase/init/_initialize.cfm
30 ms 30 ms 1 D:/Web/dynasite_codebase/udf/_udf.cfm
26 ms 13 ms 2 D:/Web/dynasite_codebase/output/_dscommand.cfm
16 ms 16 ms 1 D:/Web/dynasite_codebase/_xdscache.cfm
15 ms 8 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
12 ms 3 ms 4 D:/Web/dynasite_codebase/cached.cfm
8 ms 4 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetCMD(cimagepool_imagepool_imagepool_slide, 5270, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
7 ms 4 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetLACMD() ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
7 ms 4 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetSetting(view) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
7 ms 4 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_header.cfm
6 ms 6 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(dynasite9,9602,514445,0,global,dynasite,CV475friendly_path_info=/geschichte&) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
5 ms 5 ms 1 D:/Web/dynasite_codebase/output/_dsmenu.cfm
4 ms 2 ms 2 C:/ColdFusion9/CustomTags/fm_contentcenter.cfm
4 ms 2 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(731C63B14B55F3B2DCAC18AE66ED2C86) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
3 ms 2 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(E309F54BA001F4B33D79B9FA2B9F2CC8) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
3 ms 3 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(514445, 9602, 9602, 1, , none, visible, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
2 ms 0 ms 5 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc | get(true, true) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc
2 ms 2 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 0, News.Row,News.Sorting, 9602, 514445, 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, 9602, 514445, 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 D:/Web/Web-Aktiv10/hrbauag/cimagepool/_imagepool_action.cfm
2 ms 2 ms 1 D:/Web/dynasite_codebase/init/_variable.cfm
1 ms 0 ms 5 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 D:/Web/Web-Aktiv10/hrbauag/dsinit.cfc
1 ms 1 ms 1 D:/Web/dynasite_codebase/udf/_udf_login.cfm
0 ms 0 ms 5 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/hrbauag/cimagepool/_imagepool.cfm
0 ms 0 ms 1 D:/Web/Web-Aktiv10/hrbauag/project/_dsarticle_titletag.cfm
0 ms 0 ms 1 D:/Web/Web-Aktiv10/hrbauag/project/_init.cfm
0 ms 0 ms 2 D:/Web/Web-Aktiv10/hrbauag/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/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_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_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
10 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
175 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

19:06:20.020 - MissingInclude Exception - in D:/Web/dynasite_codebase/output/_dscommand.cfm : line 51
	    Could not find the included template /dsfront1/Web-Aktiv10/hrbauag/cimagepool/_udf.cfm.
	    
19:06:20.020 - MissingInclude Exception - in D:/Web/dynasite_codebase/output/_dscommand.cfm : line 51
	    Could not find the included template /dsfront1/Web-Aktiv10/hrbauag/cimagepool/_udf.cfm.
	    


SQL Queries

QSeo (Datasource=dynasite9_modules, Time=1ms, Records=0) in D:\Web\Web-Aktiv10\hrbauag\dsinit.cfc @ 19:06:20.020
	Select DsmidNeu, DsmidAlt FROM hrbauag_seo
	WHERE 1=2
	
		OR DsmidAlt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = geschichte

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

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=0ms, Records=31) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 19:06:20.020
	SELECT Placeholder, Content
	FROM hrbauag
	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 @ 19:06:20.020
			SELECT ID, XMLSetting.query('/DSXMLRoot/view') AS XMLSetting		
			FROM Customers WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5270

QSlide (Datasource=dynasite9_modules, Time=1ms, Records=5) in D:\Web\Web-Aktiv10\hrbauag\cimagepool\_imagepool_action.cfm @ 19:06:20.020
		SELECT
			imagepool.Label, imagepool.Bildname
		FROM
			hrbauag_imagepool AS imagepool
			INNER JOIN hrbauag_imagepool_bereich AS imagepool_bereich ON imagepool.ID = imagepool_bereich.ImagePoolID
		WHERE
			imagepool_bereich.Bereich = ?
		ORDER BY
			imagepool_bereich.Sort, newid()
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 514445

GetMenus (Datasource=dynasite9, Time=3ms, Records=16) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 19:06:20.020
				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) = 9602
Parameter #2(cf_sql_varchar) = global
Parameter #3(cf_sql_integer) = 9602
Parameter #4(cf_sql_integer) = 514445

DSGetArticles (Datasource=dynasite9, Time=1ms, Records=0) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 19:06:20.020
				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) = 514445
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 @ 19:06:20.020
				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) = 514445
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 @ 19:06:20.020
				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) = 514445

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

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=1ms, Records=31) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 19:06:20.020
	SELECT Placeholder, Content
	FROM hrbauag
	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 @ 19:06:20.020
			SELECT ID, XMLSetting.query('/DSXMLRoot/view') AS XMLSetting		
			FROM Customers WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5270

QSlide (Datasource=dynasite9_modules, Time=1ms, Records=5) in D:\Web\Web-Aktiv10\hrbauag\cimagepool\_imagepool_action.cfm @ 19:06:20.020
		SELECT
			imagepool.Label, imagepool.Bildname
		FROM
			hrbauag_imagepool AS imagepool
			INNER JOIN hrbauag_imagepool_bereich AS imagepool_bereich ON imagepool.ID = imagepool_bereich.ImagePoolID
		WHERE
			imagepool_bereich.Bereich = ?
		ORDER BY
			imagepool_bereich.Sort, newid()
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 514445


Stored Procedures

DSVariableInit2 (Datasource=dynasite9, Time=3ms) in D:\Web\dynasite_codebase\_xdscache.cfm @ 19:06:20.020

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5270    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  514445    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_BIT  NO    
 IN  CF_SQL_INTEGER  5270    
 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=20ms) in D:\Web\dynasite_codebase\_xdsinit.cfm @ 19:06:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5270    
 IN  CF_SQL_INTEGER  9602    
 IN  CF_SQL_INTEGER  514445    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_BIT  NO    
 IN  CF_SQL_INTEGER  5270    
 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 @ 19:06:20.020
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_Integer  9602    
 IN  CF_SQL_Integer  514445    
 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-Aktiv10\hrbauag\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=www.hrbauag.ch
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=/dynasite.cfm
PATH_TRANSLATED=D:\Web\Web-Aktiv10\hrbauag\dynasite.cfm
QUERY_STRING=friendly_path_info=/geschichte&
REMOTE_ADDR=18.194.150.228
REMOTE_HOST=18.194.150.228
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/dynasite.cfm
SERVER_NAME=www.hrbauag.ch
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Client Variables:
cfid=11619839
cftoken=94388763
hitcount=1
lastvisit={ts '2019-03-26 19:06:20'}
timecreated={ts '2019-03-26 19:06:20'}
urltoken=CFID=11619839&CFTOKEN=94388763
Cookie Variables:
CFID=11619839
CFTOKEN=94388763
Form Fields:
DSSEARCH_EDITMODE=1
Session Variables:
cfid=11619839
cftoken=94388763
menuslist=514443,514445
sessionid=DYNASITE_CREANET_5270_11619839_94388763
urltoken=CFID=11619839&CFTOKEN=94388763
vmenuid=514443
URL Parameters:
friendly_path_info=/geschichte
Debug Rendering Time: 39 ms