Aktuell

Renggli Fest 2018

Mitarbeiteranlässe

Wir sind stolz auf unseren Nachwuchs

Mitarbeiter

Qualifikationsverfahren 2018

Mitarbeiter

Volvo ECR 235

Investitionen


Debugging Information
ColdFusion Server Enterprise 9,0,1,274733
Template /dynasite.cfm
Time Stamp 26-Mar-19 07:29 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
161 ms 161 ms 1 top level D:\Web\Web-Aktiv10\hrbauag\dynasite.cfm
150 ms 150 ms 1 D:/Web/dynasite_codebase/_xdsinit.cfm
111 ms 111 ms 1 D:/Web/dynasite_codebase/output/_dsoutput.cfm
80 ms 27 ms 3 D:/Web/dynasite_codebase/output/_dsinclude.cfm
69 ms 35 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
41 ms 41 ms 1 D:/Web/dynasite_codebase/output/_dscommand.cfm
33 ms 33 ms 1 D:/Web/dynasite_codebase/init/_initialize.cfm
30 ms 30 ms 1 D:/Web/dynasite_codebase/udf/_udf.cfm
28 ms 14 ms 2 D:/Web/dynasite_codebase/output/_dssnippet.cfm
21 ms 21 ms 1 D:/Web/Web-Aktiv10/hrbauag/cnews/_news.cfm
10 ms 5 ms 2 D:/Web/Web-Aktiv10/hrbauag/project/_default.cfm
9 ms 9 ms 1 D:/Web/dynasite_codebase/_xdscache.cfm
8 ms 4 ms 2 D:/Web/dynasite_codebase/output/_dsarticle_header.cfm
7 ms 4 ms 2 D:/Web/dynasite_codebase/cached.cfm
6 ms 6 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetSetting(view) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
6 ms 6 ms 1 D:/Web/dynasite_codebase/output/_dsmenu.cfm
5 ms 2 ms 3 C:/ColdFusion9/CustomTags/fm_contentcenter.cfm
5 ms 5 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetArticles(dsmid, 1,2,3,4,5,6, News.Row,News.Sorting, 9602, 514447, 0, 0, 0, 0, 0, , 1, 1, , , , , , , 0, 1, 25, global, , 0, 0, , 0, , 1, 0) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
5 ms 5 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetCMD(80526, 5270, cmd) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
4 ms 4 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetLACMD() ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
4 ms 4 ms 1 D:/Web/Web-Aktiv10/hrbauag/cnews/_news_action.cfm
3 ms 3 ms 1 CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc | DSGetMenus(514447, 9602, 9602, 1, , none, visible, 0, 0, explorer, 0, global, 1) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeHTML(str = <p>Manchmal geht es schnell!!!</p> <p>Innert kürzester Zeit haben wir die Ersatzinvestition eines Volvo ECR 235EL für unseren Volvo Bagger EC 240 erhalten.</p> <p>Die Auslieferung fand am 2. Mai statt. Stolz nahm Baumaschinenführer Thomas Amrein die neue Maschine in Empfang.</p>) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeHTML(str = <p>Sichtlich erleichtert und voller Stolz präsentieren unsere Absolventen Kilian Bölsterli, Lukas Vogel und Yanik Zemp ihre Prüfungsarbeiten.</p> <p>Wir vom Lehrbetrieb wünschen den Lernenden eine kurze Wartezeit bis zur Resultatverkündung.</p>) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(56E84FDD6FCEF1ACBCC36BC3FD4E3838) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
2 ms 2 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(F728F37AB074B38360EB01563F773B29) ] 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, 9602, 514447, 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/Web-Aktiv10/hrbauag/dsinit.cfc
1 ms 1 ms 1 C:/ColdFusion9/CustomTags/Includs/_ajaxpaging.cfm
1 ms 1 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeHTML(str = Bei herrlichstem Wetter konnten wir einen gemeinsamen Tag, Abseits der alltäglichen Hektik verbringen. Mit Familien und angehörigen erlebten wir Spiel und Spass nach einem üppigen Brunch bei der Familie Seeholzer in Sigigen) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
1 ms 1 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeHTML(str = Wir gratulieren <strong>Kilian Bölsterli, Yanik Zemp</strong> und <strong>Lukas Vogel</strong> zu ihren erfolgreich<br />bestandenen Lehrabschlüssen als Strassenbauer EFZ und bedanken uns für den grossartigen Einsatz.<br /><strong>Yanik Zemp hat die Lehre mit der hervorragenden Note 5.8 abgeschlossen.</strong><br />Zu dieser tollen Leistung gratuliert das ganze Team.<br />Besonders freut uns, dass alle drei der Hans Renggli Bau AG treu bleiben.<br />Für die Zukunft wünschen wir den jungen Berufsleuten alles Gute und weiterhin viel Erfolg.) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
1 ms 1 ms 1 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc | get(dynasite9,9602,514447,0,global,dynasite,CV475friendly_path_info=/aktuelles&) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc
1 ms 1 ms 1 D:/Web/Web-Aktiv10/hrbauag/project/_init.cfm
1 ms 1 ms 1 D:/Web/dynasite_codebase/init/_variable.cfm
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = Qualifikationsverfahren 2018) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = Renggli Fest 2018) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = Volvo ECR 235) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion9/CustomTags/cfc/functions.cfc | removeUmlaute(str = Wir sind stolz auf unseren Nachwuchs) ] from C:/ColdFusion9/CustomTags/cfc/functions.cfc
0 ms 0 ms 3 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc | get(true, true) ] from C:/ColdFusion9/CustomTags/memcached-v2/com/futuretask.cfc
0 ms 0 ms 3 CFC[ C:/ColdFusion9/CustomTags/memcached-v2/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-Aktiv10/hrbauag/cnews/_functions.cfm
0 ms 0 ms 1 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_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
8 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
169 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

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


SQL Queries

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

GetInclude (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 19:29:44.044
		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 @ 19:29:44.044
	SELECT Placeholder, Content
	FROM hrbauag
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
GetMenus (Datasource=dynasite9, Time=2ms, Records=16) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 19:29:44.044
				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) = 514447

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

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

getxmlColumnData (Datasource=dynasite9, Time=2ms, Records=0) in D:\Web\dynasite_codebase\output\_dsarticle_css.cfm @ 19:29:44.044
				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) = 514447

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

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

QCategory (Datasource=dynasite9_modules, Time=1ms, Records=3) in D:\Web\Web-Aktiv10\hrbauag\cnews\_news_action.cfm @ 19:29:44.044
		SELECT DISTINCT
			news_category.ID,
			ISNULL(NULLIF(news_category.Category_de,''), news_category.Category_de) AS Category,
			news_category.Sort
		FROM
			hrbauag_news_category AS news_category
			INNER JOIN hrbauag_news AS news ON news_category.ID = news.CategoryID
		WHERE
			news_category.Bereich = ? AND news.Aktiv = 1
		ORDER BY
			news_category.Sort
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 514447

QView (Datasource=dynasite9_modules, Time=2ms, Records=4) in D:\Web\Web-Aktiv10\hrbauag\cnews\_news_action.cfm @ 19:29:44.044
		SELECT
			news.ID, Startseite, Aktiv,
			ISNULL(NULLIF(Titel_de,''), Titel_de) AS Titel,
			ISNULL(NULLIF(Besch_de,''), Besch_de) AS Besch,
			news_category.Category_de AS Category, news_category.Category_de,
			(SELECT TOP(1) Photo FROM hrbauag_news_photo WHERE NewsID = news.ID ORDER BY Sort ASC) AS Photo
		FROM
			hrbauag_news AS news
			INNER JOIN hrbauag_news_category AS news_category ON news_category.ID = news.CategoryID
		WHERE
			Bereich = ? AND Aktiv = 1 
		ORDER BY
			news.Sort ASC;
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 514447

qWebSiteContent (Datasource=dynasite9_contentcenter, Time=1ms, Records=31) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 19:29:44.044
	SELECT Placeholder, Content
	FROM hrbauag
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'news'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder
GetInclude (Datasource=dynasite9, Time=14ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 19:29:44.044
		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:29:44.044
	SELECT Placeholder, Content
	FROM hrbauag
	WHERE (
    		
            	modul = 'alg' OR
            
				modul = 'alg'
				
			)AND SiteLanguage like 'de%'
	ORDER BY placeholder


Stored Procedures

DSVariableInit2 (Datasource=dynasite9, Time=1ms) in D:\Web\dynasite_codebase\_xdscache.cfm @ 19:29:44.044

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5270    
 IN  CF_SQL_INTEGER  0    
 IN  CF_SQL_INTEGER  514447    
 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=2ms) in D:\Web\dynasite_codebase\_xdsinit.cfm @ 19:29:44.044
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  5270    
 IN  CF_SQL_INTEGER  9602    
 IN  CF_SQL_INTEGER  514447    
 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 @ 19:29:44.044
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_Integer  9602    
 IN  CF_SQL_Integer  514447    
 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=/aktuelles&
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=11620104
cftoken=34038381
hitcount=1
lastvisit={ts '2019-03-26 19:29:44'}
timecreated={ts '2019-03-26 19:29:44'}
urltoken=CFID=11620104&CFTOKEN=34038381
Cookie Variables:
CFID=11620104
CFTOKEN=34038381
Form Fields:
CNEWS_CATEGORY=
CNEWS_SEARCH=
DSSEARCH_EDITMODE=1
Session Variables:
cfid=11620104
cftoken=34038381
menuslist=514447
sessionid=DYNASITE_CREANET_5270_11620104_34038381
urltoken=CFID=11620104&CFTOKEN=34038381
vmenuid=514447
URL Parameters:
friendly_path_info=/aktuelles
Debug Rendering Time: 51 ms