HR Bau AG :: Ihr verlässlicher Parrtner im Bereich Strassenbau, Tiefbau & Wasserbau.

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
152 ms	152 ms	1	D:\Web\Web-Aktiv10\hrbauag\dynasite.cfm
138 ms	138 ms	1	D:/Web/dynasite_codebase/_xdsinit.cfm
107 ms	107 ms	1	D:/Web/dynasite_codebase/output/_dsoutput.cfm
76 ms	38 ms	2	D:/Web/dynasite_codebase/output/_dssnippet.cfm
74 ms	37 ms	2	D:/Web/dynasite_codebase/output/_dsinclude.cfm
71 ms	36 ms	2	D:/Web/Web-Aktiv10/hrbauag/project/_default.cfm
40 ms	20 ms	2	D:/Web/dynasite_codebase/output/_dscommand.cfm
26 ms	26 ms	1	D:/Web/dynasite_codebase/init/_initialize.cfm
25 ms	25 ms	1	D:/Web/dynasite_codebase/udf/_udf.cfm
12 ms	6 ms	2	D:/Web/dynasite_codebase/output/_dsarticle_css.cfm
11 ms	6 ms	2	CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc \| DSGetSetting(view) ] from D:/Web/dynasite_codebase/system/dsglobal.cfc
11 ms	11 ms	1	D:/Web/dynasite_codebase/_xdscache.cfm
11 ms	3 ms	4	D:/Web/dynasite_codebase/cached.cfm
11 ms	6 ms	2	D:/Web/dynasite_codebase/output/_dsarticle_header.cfm
10 ms	10 ms	1	D:/Web/Web-Aktiv10/hrbauag/dsinit.cfc
10 ms	10 ms	1	D:/Web/dynasite_codebase/output/_dsmenu.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
6 ms	3 ms	2	D:/Web/Web-Aktiv10/hrbauag/cimagepool/_imagepool_action.cfm
5 ms	3 ms	2	C:/ColdFusion9/CustomTags/fm_contentcenter.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(514440, 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	4 ms	1	CFC[ D:/Web/dynasite_codebase/system/dsglobal.cfc \| DSGetArticles(dsmid, 1,2,3,4,5,6, News.Row,News.Sorting, 9602, 514440, 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	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[ C:/ColdFusion9/CustomTags/memcached-v2/com/memcached.cfc \| get(dynasite9,9602,514440,0,global,dynasite,CV475friendly_path_info=/home&) ] 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, 514440, 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/project/_init.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/dynasite_codebase/init/_variable.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	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
17 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
169 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

Exceptions

19:06:10.010 - 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:10.010 - 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=8ms, Records=0) in D:\Web\Web-Aktiv10\hrbauag\dsinit.cfc @ 19:06:10.010

	Select DsmidNeu, DsmidAlt FROM hrbauag_seo
	WHERE 1=2
	
		OR DsmidAlt = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = home

GetInclude (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 19:06:10.010

		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 @ 19:06:10.010

	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:10.010

			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=4) in D:\Web\Web-Aktiv10\hrbauag\cimagepool\_imagepool_action.cfm @ 19:06:10.010

		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) = 514440

GetMenus (Datasource=dynasite9, Time=5ms, Records=16) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 19:06:10.010

				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) = 514440

DSGetArticles (Datasource=dynasite9, Time=1ms, Records=0) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 19:06:10.010

				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) = 514440

			    
			        Parameter #2(cf_sql_varchar) = global

			    
			        Parameter #3(cf_sql_integer) = 0

			    
			        Parameter #4(cf_sql_integer) = 1

DSGetArticles (Datasource=dynasite9, Time=2ms, Records=0) in D:\Web\dynasite_codebase\system\dsglobal.cfc @ 19:06:10.010

				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) = 514440

			    
			        Parameter #2(cf_sql_varchar) = global

			    
			        Parameter #3(cf_sql_integer) = 1

GetInclude (Datasource=dynasite9, Time=1ms, Records=1) in D:\Web\dynasite_codebase\output\_dsinclude.cfm @ 19:06:10.010

		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=2ms, Records=31) in C:\ColdFusion9\CustomTags\fm_contentcenter.cfm @ 19:06:10.010

	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:10.010

			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=4) in D:\Web\Web-Aktiv10\hrbauag\cimagepool\_imagepool_action.cfm @ 19:06:10.010

		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) = 514440

Stored Procedures

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

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`5270`
`IN`	`CF_SQL_INTEGER`	`0`
`IN`	`CF_SQL_INTEGER`	`514440`
`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
`name`	`resultset`

DSInit2 (Datasource=dynasite9, Time=2ms) in D:\Web\dynasite_codebase\_xdsinit.cfm @ 19:06:10.010

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`5270`
`IN`	`CF_SQL_INTEGER`	`9602`
`IN`	`CF_SQL_INTEGER`	`514440`
`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
`name`	`resultset`
`GetDSCID`	`1`
`GetDSSID`	`2`
`GetDSMID`	`3`

DSContent (Datasource=dynasite9, Time=1ms) in D:\Web\dynasite_codebase\output\_dsoutput.cfm @ 19:06:10.010

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_Integer`	`9602`
`IN`	`CF_SQL_Integer`	`514440`
`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
`name`	`resultset`
`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=/home&
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=11619835
cftoken=36438774
hitcount=1
lastvisit={ts '2019-03-26 19:06:10'}
timecreated={ts '2019-03-26 19:06:10'}
urltoken=CFID=11619835&CFTOKEN=36438774

Cookie Variables:
CFID=11619835
CFTOKEN=36438774

Form Fields:
DSSEARCH_EDITMODE=1

Session Variables:
cfid=11619835
cftoken=36438774
menuslist=514440
sessionid=DYNASITE_CREANET_5270_11619835_36438774
urltoken=CFID=11619835&CFTOKEN=36438774
vmenuid=514440

URL Parameters:
friendly_path_info=/home

Debug Rendering Time: 43 ms