IMPRESSUM

Der Zugriff auf die Seiten der Homepage und ihrer Unterseiten (Webseite) sowie deren Benutzung richtet sich nach den folgenden Vorschriften. Sie sind zum Aufruf und zur Nutzung der Webseite nur berechtigt, falls Sie sich mit den nachfolgenden Bestimmungen einverstanden erklären. Unsere Allgemeinen Liefer- und Zahlungsbedingungen werden durch den Inhalt dieser allgemeinen Nutzungsbedingungen nicht geändert, es sei denn, dass diese Änderung ausdrücklich erfolgt.

VERWEISE UND LINKS

Der Autor erklärt hiermit ausdrücklich, dass zum Zeitpunkt der Linksetzung keine illegalen Inhalte auf den zu verlinkenden Seiten erkennbar waren. Auf die aktuelle und zukünftige Gestaltung, die Inhalte oder die Urheberschaft der gelinkten / verknüpften Seiten hat der Autor keinerlei Einfluss. Deshalb distanziert er sich hiermit ausdrücklich von allen Inhalten aller gelinkten / verknüpften Seiten, die nach der Linksetzung verändert wurden.

INHALT UND DATEN

Der Autor übernimmt keinerlei Gewähr für die Aktualität, Korrektheit, Vollständigkeit oder Qualität der bereitgestellten Informationen. Haftungsansprüche gegen den Autor, welche sich auf Schäden materieller oder ideeller Art beziehen, die durch die Nutzung oder Nichtnutzung der dargebotenen Informationen bzw. durch die Nutzung fehlerhafter und unvollständiger Informationen verursacht wurden, sind grundsätzlich ausgeschlossen, sofern seitens des Autors kein nachweislich vorsätzliches oder grob fahrlässiges Verschulden vorliegt.

Alle Angebote sind freibleibend und unverbindlich. Der Autor behält es sich ausdrücklich vor, Teile der Seiten oder das gesamte Angebot ohne gesonderte Ankündigung zu verändern, zu ergänzen, zu löschen oder die Veröffentlichung zeitweise oder endgültig einzustellen.

IMPRESSUM - Hans Renggli Bau AG

© alle Rechte vorbehalten. Jegliche Verbreitung im Internet und jegliche andere Vervielfältigung, auch auszugsweise, nur mit ausdrücklicher Genehmigung des Herausgebers.

DESIGN & PROGRAMMIERUNG

Creanet Internet Service AG
Schäracher 9
CH-6232 Geuensee

Tel. +41 41 552 19 00
Fax +41 41 552 19 01


Debugging Information
ColdFusion Server Enterprise 9,0,1,274733
Template /dynasite.cfm
Time Stamp 26-Mar-19 08:03 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
219 ms 219 ms 1 top level D:\Web\Web-Aktiv10\hrbauag\dynasite.cfm
207 ms 207 ms 1 D:/Web/dynasite_codebase/_xdsinit.cfm
150 ms 150 ms 1 D:/Web/dynasite_codebase/output/_dsoutput.cfm
104 ms 52 ms 2 D:/Web/dynasite_codebase/output/_dssnippet.cfm
103 ms 52 ms 2 D:/Web/dynasite_codebase/output/_dsinclude.cfm
98 ms 49 ms 2 D:/Web/Web-Aktiv10/hrbauag/project/_default.cfm
51 ms 26 ms 2 D:/Web/dynasite_codebase/output/_dscommand.cfm
33 ms 33 ms 1 D:/Web/dynasite_codebase/init/_initialize.cfm
32 ms 16 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
29 ms 29 ms 1 D:/Web/dynasite_codebase/udf/_udf.cfm
21 ms 11 ms 2 D:/Web/Web-Aktiv10/hrbauag/cimagepool/_imagepool_action.cfm
20 ms 10 ms 2 C:/ColdFusion9/CustomTags/fm_contentcenter.cfm
11 ms 3 ms 4 D:/Web/dynasite_codebase/cached.cfm
10 ms 5 ms 2 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetSetting(view) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
10 ms 10 ms 1 D:/Web/dynasite_codebase/_xdscache.cfm
9 ms 5 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_header.cfm
8 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 | DSGetCMD(cimagepool_imagepool_imagepool_slide, 5270, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
6 ms 3 ms 2 CFC[ C:/ColdFusion9/CustomTags/cfc/menus.cfc | getMenus(DSSID = 9602, DSMID = 514450) ] from C:/ColdFusion9/CustomTags/cfc/menus.cfc
6 ms 6 ms 1 D:/Web/Web-Aktiv10/hrbauag/dsinit.cfc
6 ms 6 ms 1 D:/Web/dynasite_codebase/output/_dsmenu.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, 9602, 514452, 0, 0, 0, 0, 0, , 1, 1, , , , , , , 0, 1, 25, global, , 0, 0, , 0, , 1, 0) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
3 ms 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[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(dynasite9,9602,514452,0,global,dynasite,CV475friendly_path_info=/impressum&) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
3 ms 3 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 0, News.Row,News.Sorting, 9602, 514452, 0, 0, 0, 0, 0, , 1, 1, , , , , , , 0, 1, 25, global, , 0, 0, , 0, , 1, 0) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
3 ms 3 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(514452, 9602, 9602, 1, , none, visible, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
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 | get(true, true) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc
1 ms 1 ms 1 D:/Web/Web-Aktiv10/hrbauag/project/_init.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/udf/_udf_google_maps.cfm
0 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
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 5 D:/Web/Web-Aktiv10/hrbauag/project/_dsarticle_titletag.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_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
13 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
232 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

20:03: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:03: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=5ms, Records=0) in D:\Web\Web-Aktiv10\hrbauag\dsinit.cfc @ 20:03:08.008
	Select DsmidNeu, DsmidAlt FROM hrbauag_seo
	WHERE 1=2
	
		OR DsmidAlt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = impressum

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

QMenus (Datasource=dynasite9_modules, Time=3ms, Records=2) in C:\ColdFusion9\CustomTags\cfc\menus.cfc @ 20:03:08.008
			SELECT
				Menu.ID AS DSMID, Menu.DSSID, Menu.Depth, Menu.DSPMID, Menu.DSDID, Menu.DSRole, Menu.Live,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID and Language = ?
				) THEN (
					SELECT Menutext FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID and Language = ?
				) ELSE Menutext END AS Menutext,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT DSNavFolder FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE DSNavFolder END AS DSNavFolder,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT LinkType FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE LinkType END AS LinkType,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT LinkDSMID FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE LinkDSMID END AS LinkDSMID,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT URLLink FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE URLLink END AS URLLink,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT URLTarget FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE URLTarget END AS URLTarget,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT Language FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE Language END AS RealLang,

				(SELECT COUNT(ID) FROM dynasite9.dbo.Menus WHERE DSPMID = Menu.ID AND Live IN (1)) AS SubCounter
			FROM 
				dynasite9.dbo.Menus AS Menu
			WHERE 
				Menu.DSSID = ?
				AND Menu.DSPMID IN (?)
				AND Menu.Live IN (?)
				AND Language = 'global'
			ORDER BY
				DSPMID, Menu.Sort ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = global
Parameter #2(cf_sql_varchar) = global
Parameter #3(cf_sql_varchar) = global
Parameter #4(cf_sql_varchar) = global
Parameter #5(cf_sql_varchar) = global
Parameter #6(cf_sql_varchar) = global
Parameter #7(cf_sql_varchar) = global
Parameter #8(cf_sql_varchar) = global
Parameter #9(cf_sql_varchar) = global
Parameter #10(cf_sql_varchar) = global
Parameter #11(cf_sql_varchar) = global
Parameter #12(cf_sql_varchar) = global
Parameter #13(cf_sql_varchar) = global
Parameter #14(cf_sql_varchar) = global
Parameter #15(cf_sql_integer) = 9602
Parameter #16(cf_sql_integer) = 514450
Parameter #17(cf_sql_integer) = 1

QSlide (Datasource=dynasite9_modules, Time=3ms, Records=0) in D:\Web\Web-Aktiv10\hrbauag\cimagepool\_imagepool_action.cfm @ 20:03: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 = 514451
			ORDER BY
				imagepool_bereich.Sort, newid()
		
QSlide (Datasource=dynasite9_modules, Time=2ms, Records=4) in D:\Web\Web-Aktiv10\hrbauag\cimagepool\_imagepool_action.cfm @ 20:03:08.008
			SELECT
				Label, Bildname
			FROM
				hrbauag_imagepool
			WHERE
				Standard = 1
			ORDER BY
				newid()	
		
GetMenus (Datasource=dynasite9, Time=3ms, Records=16) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 20:03: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) = 514452

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

DSGetArticles (Datasource=dynasite9, Time=2ms, Records=5) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 20:03: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) = 514452
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 @ 20:03: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) = 514452

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

QMenus (Datasource=dynasite9_modules, Time=2ms, Records=2) in C:\ColdFusion9\CustomTags\cfc\menus.cfc @ 20:03:08.008
			SELECT
				Menu.ID AS DSMID, Menu.DSSID, Menu.Depth, Menu.DSPMID, Menu.DSDID, Menu.DSRole, Menu.Live,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID and Language = ?
				) THEN (
					SELECT Menutext FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID and Language = ?
				) ELSE Menutext END AS Menutext,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT DSNavFolder FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE DSNavFolder END AS DSNavFolder,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT LinkType FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE LinkType END AS LinkType,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT LinkDSMID FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE LinkDSMID END AS LinkDSMID,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT URLLink FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE URLLink END AS URLLink,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT URLTarget FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE URLTarget END AS URLTarget,

				CASE WHEN Menu.ID=(
					SELECT Language_DSMID FROM dynasite9.dbo.Menus AS A WHERE Language_DSMID = Menu.ID AND Language = ?
				) THEN (
					SELECT Language FROM dynasite9.dbo.Menus AS B WHERE Language_DSMID = Menu.ID AND Language = ?
				) ELSE Language END AS RealLang,

				(SELECT COUNT(ID) FROM dynasite9.dbo.Menus WHERE DSPMID = Menu.ID AND Live IN (1)) AS SubCounter
			FROM 
				dynasite9.dbo.Menus AS Menu
			WHERE 
				Menu.DSSID = ?
				AND Menu.DSPMID IN (?)
				AND Menu.Live IN (?)
				AND Language = 'global'
			ORDER BY
				DSPMID, Menu.Sort ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = global
Parameter #2(cf_sql_varchar) = global
Parameter #3(cf_sql_varchar) = global
Parameter #4(cf_sql_varchar) = global
Parameter #5(cf_sql_varchar) = global
Parameter #6(cf_sql_varchar) = global
Parameter #7(cf_sql_varchar) = global
Parameter #8(cf_sql_varchar) = global
Parameter #9(cf_sql_varchar) = global
Parameter #10(cf_sql_varchar) = global
Parameter #11(cf_sql_varchar) = global
Parameter #12(cf_sql_varchar) = global
Parameter #13(cf_sql_varchar) = global
Parameter #14(cf_sql_varchar) = global
Parameter #15(cf_sql_integer) = 9602
Parameter #16(cf_sql_integer) = 514450
Parameter #17(cf_sql_integer) = 1

QSlide (Datasource=dynasite9_modules, Time=1ms, Records=0) in D:\Web\Web-Aktiv10\hrbauag\cimagepool\_imagepool_action.cfm @ 20:03: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 = 514451
			ORDER BY
				imagepool_bereich.Sort, newid()
		
QSlide (Datasource=dynasite9_modules, Time=2ms, Records=4) in D:\Web\Web-Aktiv10\hrbauag\cimagepool\_imagepool_action.cfm @ 20:03:08.008
			SELECT
				Label, Bildname
			FROM
				hrbauag_imagepool
			WHERE
				Standard = 1
			ORDER BY
				newid()	
		


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5270    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  514452    
 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=19ms) in D:\Web\dynasite_codebase\_xdsinit.cfm @ 20:03:08.008
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5270    
 IN  CF_SQL_INTEGER  9602    
 IN  CF_SQL_INTEGER  514452    
 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=2ms) in D:\Web\dynasite_codebase\output\_dsoutput.cfm @ 20:03:08.008
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_Integer  9602    
 IN  CF_SQL_Integer  514452    
 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=/impressum&
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=11621456
cftoken=42540397
hitcount=1
lastvisit={ts '2019-03-26 20:03:08'}
timecreated={ts '2019-03-26 20:03:08'}
urltoken=CFID=11621456&CFTOKEN=42540397
Cookie Variables:
CFID=11621456
CFTOKEN=42540397
Form Fields:
DSSEARCH_EDITMODE=1
Session Variables:
cfid=11621456
cftoken=42540397
menuslist=514450,514452
sessionid=DYNASITE_CREANET_5270_11621456_42540397
urltoken=CFID=11621456&CFTOKEN=42540397
vmenuid=514451
URL Parameters:
friendly_path_info=/impressum
Debug Rendering Time: 34 ms