Wasserbau

Der Sicherung von Uferzonen und Böschungen sowie der Renaturierung von Flüssen und Bächen ist eine hohe Aufmerksamkeit zu schenken. Wir sind spezialisiert auf Bachverbauungen und Spezialtiefbauten die den Kräften der Natur standhalten. Damit sich die Gewässer  harmonisch in die Umwelt einpassen können, wird der Natur der nötige Raum wieder zur Verfügung gestellt. Wo nötig werden die Fliessgeschwindigkeiten baulich angepasst.

Unsere Kompetenten Mitarbeiter wissen genau wie sie mit dieser verantwortungsvollen Aufgabe umgehen müssen und zeigen den nötigen Respekt vor den Kräften der Natur.

Klicken Sie auf den unten aufgeführten Link und sehen Sie einen Auszug unserer Arbeiten.
Haben wir Ihr Interesse geweckt? Dann zögern Sie nicht und nehmen Sie mit uns Kontakt auf. Mit dem unten aufgeführten Link gelangen Sie direkt zu unserem Kontaktformular. Wir werden uns dann so schnell wie möglich bei Ihnen melden.

Aktuelle Referenzbeispiele

Sanierung Haselholzbrücke

Malters

Hochwasserschutz kleine Emme

Emmenbrücke

Neubau Rümligbrücke

Schachen


Debugging Information
ColdFusion Server Enterprise 9,0,1,274733
Template /dynasite.cfm
Time Stamp 26-Mar-19 08:12 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
230 ms 230 ms 1 top level D:\Web\Web-Aktiv10\hrbauag\dynasite.cfm
217 ms 217 ms 1 D:/Web/dynasite_codebase/_xdsinit.cfm
162 ms 162 ms 1 D:/Web/dynasite_codebase/output/_dsoutput.cfm
124 ms 41 ms 3 D:/Web/dynasite_codebase/output/_dsinclude.cfm
78 ms 39 ms 2 D:/Web/dynasite_codebase/output/_dssnippet.cfm
74 ms 37 ms 2 D:/Web/Web-Aktiv10/hrbauag/project/_default.cfm
73 ms 24 ms 3 D:/Web/dynasite_codebase/output/_dscommand.cfm
70 ms 35 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
31 ms 31 ms 1 D:/Web/dynasite_codebase/init/_initialize.cfm
29 ms 29 ms 1 D:/Web/dynasite_codebase/udf/_udf.cfm
22 ms 4 ms 6 D:/Web/dynasite_codebase/cached.cfm
16 ms 16 ms 1 D:/Web/Web-Aktiv10/hrbauag/creferenzen/_referenzen.cfm
15 ms 5 ms 3 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetLACMD() ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
13 ms 4 ms 3 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetSetting(view) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
12 ms 12 ms 1 D:/Web/dynasite_codebase/_xdscache.cfm
9 ms 9 ms 1 D:/Web/Web-Aktiv10/hrbauag/creferenzen/_referenzen_action.cfm
8 ms 3 ms 3 C:/ColdFusion9/CustomTags/fm_contentcenter.cfm
7 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 D:/Web/dynasite_codebase/output/_dsarticle_header.cfm
7 ms 7 ms 1 D:/Web/dynasite_codebase/output/_dsmenu.cfm
5 ms 3 ms 2 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(E309F54BA001F4B33D79B9FA2B9F2CC8) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
5 ms 5 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(519614, 9602, 9602, 1, , none, visible, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
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
4 ms 2 ms 2 D:/Web/Web-Aktiv10/hrbauag/cimagepool/_imagepool_action.cfm
3 ms 0 ms 7 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc | get(true, true) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc
3 ms 0 ms 7 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc | init([complex value]) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc
3 ms 3 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(03BF608BB2D6F0092D94630573A64C3C) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.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, 9602, 519614, 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 | removeHTML(str = <p><strong>Arbeitsgemeinschaft mit Gebr. BRUN AG<br /></strong></p> <p><strong><br /></strong></p> <p><strong>Bauherr:  Kanton Luzern</strong></p> <p> </p> <p><strong>Ingenieur / Bauleitung:  Basler & Hofmann <br /></strong></p> <p><strong>Bauzeit: 2018 / 2019<br /></strong></p> <p><strong>Mitarbeitende <br /></strong><strong>Polier: Neziri Fekri, Achermann Peter</strong><br /><strong>Bauführer:  Theo Baumeler<br /></strong></p> <div class="dslinklist_title_0"> </div>) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
2 ms 2 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 0, News.Row,News.Sorting, 9602, 519614, 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 | DSGetCMD(81370, 5270, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
1 ms 1 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = Neubau Rümligbrücke ) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
1 ms 1 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(0061DC44FAD1FB17688B6FAB9F48F808) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
1 ms 1 ms 1 D:/Web/Web-Aktiv10/hrbauag/dsinit.cfc
1 ms 0 ms 4 D:/Web/Web-Aktiv10/hrbauag/project/_dsarticle_titletag.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/init/_variable.cfm
0 ms 0 ms 1 C:/ColdFusion9/CustomTags/Includs/_ajaxpaging.cfm
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeHTML(str = <strong>Bauherr: Kanton Luzern</strong><br /> <p> </p> <p><strong>Ingenieur / Bauleitung: </strong></p> <p><strong>Bauzeit: 2018/2019</strong></p> <strong>Mitarbeitende <br /></strong><strong>Polier: Christoph Purtschert</strong><br /><strong>Bauführer: Theo Baumeler<br /></strong>) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeHTML(str = <strong>Bauherr:  Gemeinde Malters</strong><br /> <p> </p> <p><strong>Ingenieur / Bauleitung: Felder + Partner<br /></strong></p> <p><strong>Bauzeit: 2018</strong></p> <strong>Mitarbeitende <br /></strong><strong>Polier: Michael Bachmann, Peter Achermann</strong><br /><strong>Bauführer: Andi Duss<br /></strong>) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = Hochwasserschutz kleine Emme) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = Sanierung Haselholzbrücke) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(dynasite9,9602,519614,0,global,dynasite,CV475friendly_path_info=/wasserbau&) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
0 ms 0 ms 7 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/creferenzen/_functions.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_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
11 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
241 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

20:12:08.008 - 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.
	    
20:12:08.008 - MissingInclude Exception - in D:/Web/dynasite_codebase/output/_dscommand.cfm : line 51
	    Could not find the included template /dsfront1/Web-Aktiv10/hrbauag/creferenzen/_udf.cfm.
	    
20:12:08.008 - 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 @ 20:12:08.008
	Select DsmidNeu, DsmidAlt FROM hrbauag_seo
	WHERE 1=2
	
		OR DsmidAlt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = wasserbau

GetInclude (Datasource=dynasite9, Time=0ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 20:12:08.008
		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=2ms, Records=31) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 20:12:08.008
	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 @ 20:12:08.008
			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=3ms, Records=6) in D:\Web\Web-Aktiv10\hrbauag\cimagepool\_imagepool_action.cfm @ 20:12:08.008
		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) = 519614

GetMenus (Datasource=dynasite9, Time=5ms, Records=16) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 20:12:08.008
				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) = 519614

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

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

getxmlColumnData (Datasource=dynasite9, Time=0ms, Records=0) in D:\Web\dynasite_codebase\output\_dsarticle_css.cfm @ 20:12:08.008
				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) = 519614

getncid2 (Datasource=dynasite9, Time=0ms, Records=1) in D:\Web\dynasite_codebase\output\_dsarticle_css.cfm @ 20:12:08.008
				SELECT TOP (1) News.NCID, Sites.DSURL, Sites.DSCID
				FROM News INNER JOIN Sites ON News.DSSID = Sites.ID
				WHERE News.ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5043647

getncid2 (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsarticle_css.cfm @ 20:12:08.008
				SELECT TOP (1) News.NCID, Sites.DSURL, Sites.DSCID
				FROM News INNER JOIN Sites ON News.DSSID = Sites.ID
				WHERE News.ID=? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5031878

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

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

QView (Datasource=dynasite9_modules, Time=4ms, Records=3) in D:\Web\Web-Aktiv10\hrbauag\creferenzen\_referenzen_action.cfm @ 20:12:08.008
		SELECT
			
				Top 3 
			referenzen.ID, referenzen.Ortschaft, referenzen.Category,
			ISNULL(NULLIF(Titel_de,''), Titel_de) AS Titel,
			ISNULL(NULLIF(Besch_de,''), Besch_de) AS Besch,
			referenzen.Aktiv,
			(SELECT TOP 1 Photo FROM hrbauag_referenzen_photo WHERE ReferenzID = referenzen.ID ORDER BY Sort ASC) AS Photo
		FROM
			hrbauag_referenzen AS referenzen
		WHERE
			Bereich = ? AND referenzen.Aktiv = 1 
				AND Category LIKE ? 
		ORDER BY
			referenzen.Sort ASC;
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 519615
Parameter #2(cf_sql_varchar) = %,8,%

QCategory (Datasource=dynasite9_modules, Time=2ms, Records=4) in D:\Web\Web-Aktiv10\hrbauag\creferenzen\_referenzen_action.cfm @ 20:12:08.008
		SELECT DISTINCT
			category.ID, ISNULL(NULLIF(Category_de,''), Category_de) AS Category, category.Sort
		FROM
			hrbauag_referenzen_category AS category
		WHERE
			category.Bereich = ? 
		ORDER BY
			category.Sort ASC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 519615

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=2ms, Records=31) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 20:12:08.008
	SELECT Placeholder, Content
	FROM hrbauag
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'referenzen'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
GetInclude (Datasource=dynasite9, Time=2ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 20:12:08.008
		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=3ms, Records=31) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 20:12:08.008
	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 @ 20:12:08.008
			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=6) in D:\Web\Web-Aktiv10\hrbauag\cimagepool\_imagepool_action.cfm @ 20:12:08.008
		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) = 519614


Stored Procedures

DSVariableInit2 (Datasource=dynasite9, Time=2ms) in D:\Web\dynasite_codebase\_xdscache.cfm @ 20:12:08.008

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5270    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  519614    
 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=21ms) in D:\Web\dynasite_codebase\_xdsinit.cfm @ 20:12:08.008
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5270    
 IN  CF_SQL_INTEGER  9602    
 IN  CF_SQL_INTEGER  519614    
 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 @ 20:12:08.008
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_Integer  9602    
 IN  CF_SQL_Integer  519614    
 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=/wasserbau&
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=11621538
cftoken=81945040
hitcount=1
lastvisit={ts '2019-03-26 20:12:08'}
timecreated={ts '2019-03-26 20:12:08'}
urltoken=CFID=11621538&CFTOKEN=81945040
Cookie Variables:
CFID=11621538
CFTOKEN=81945040
Form Fields:
CREFERENZEN_CATEGORY=8
CREFERENZEN_SEARCH=
DSSEARCH_EDITMODE=1
Session Variables:
cfid=11621538
cftoken=81945040
menuslist=514448,519614
sessionid=DYNASITE_CREANET_5270_11621538_81945040
urltoken=CFID=11621538&CFTOKEN=81945040
vmenuid=514448
URL Parameters:
friendly_path_info=/wasserbau
Debug Rendering Time: 44 ms