Total Time	Avg Time	Count	Template
38 ms	38 ms	1	C:\ColdFusion10\cfusion\wwwroot\SunFish\sunfish5\ehrm\default.cfm
38 ms	38 ms	1	CFC[ C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/Application.cfc | onRequest(/sunfish5/ehrm/default.cfm) ] from C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/Application.cfc
35 ms	9 ms	4	C:/ColdFusion10/cfusion/wwwroot/SunFish/customtags/sunfish36/DO_SF_V32_MULTILANGUAGE.cfm
20 ms	20 ms	1	C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5upload/ehrm/template/ehrmlogin/template1/index.cfm
16 ms	16 ms	1	C:/ColdFusion10/cfusion/wwwroot/SunFish/customtags/sunfish36/DO_SF_V32_LOGIN.cfm
11 ms	11 ms	1	C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/initial.cfm
4 ms	4 ms	1	C:/ColdFusion10/cfusion/wwwroot/SunFish/customtags/sunfish36/DO_SF_V32_FORGOTPOPUP.cfm
4 ms	4 ms	1	CFC[ C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/Application.cfc | onRequestStart(/sunfish5/ehrm/default.cfm) ] from C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/Application.cfc
1 ms	1 ms	1	C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/include/appcss.cfm
0 ms	0 ms	1	C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/Application.cfc
0 ms	0 ms	1	C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/include/libfunction.cfm
0 ms	0 ms	8	C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/include/appvars.cfm
0 ms	0 ms	1	C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/utility/_global.cfm
0 ms	0 ms	1	C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5upload/css/ehrm/csseHRM1s0.css
0 ms	0 ms	1	CFC[ C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/Application.cfc | onRequestEnd(/sunfish5/ehrm/default.cfm) ] from C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/Application.cfc
2 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
44 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

	    Error Executing Database Query.
	    

					SET CONCAT_NULL_YIELDS_NULL  OFF
				

			select type_name_en SQLColumn from thrmmastertype where UPPER(type_code) = 'MSSQL'
		

				SELECT Date_Format, Time_Format FROM THRMSetting
			

	SELECT TLanguageText.*
	FROM TLanguageText	
	WHERE 
		UPPER(TLanguageText.Text_ID) IN ('NOACTIVETEMPLATE','SESSIONEXPIRED') 

	SELECT TAppTemplate.*, TAppTemplateActive.AppTemplateActive_Name, TAppTemplateActive.AppTemplateActive_File,
			TApplication.App_ID, TApplication.App_Name
	FROM TApplication,TAppTemplateActive,TAppTemplate
	WHERE 
	TApplication.App_ID=TAppTemplateActive.App_ID
	AND TAppTemplateActive.AppTemplateActive_ID=TAppTemplate.AppTemplateActive_ID
	AND TAppTemplateActive.AppTemplateActive_Name = 
	
	'ehrmlogin'
	
		AND TAppTemplate.AppTemplate_Status=1
	
	ORDER BY UPPER(TApplication.App_Name), UPPER(TAppTemplateActive.AppTemplateActive_Name), UPPER(TAppTemplate.AppTemplate_Name)

	SELECT TLanguageText.*
	FROM TLanguageText	
	WHERE 
		UPPER(TLanguageText.Text_ID) IN ('LANGUAGE','ACTIVEREQUEST','APPRAISALNEEDRR','APPRAISALNEEDCN','OFFICE') 

	SELECT TLanguageText.*
	FROM TLanguageText	
	WHERE 
		UPPER(TLanguageText.Text_ID) IN ('USERNAME','PASSWORD','INPUTVALIDUSERNAME','INPUTVALIDPASSWORD','CLICKHERETOLOGIN','LOGIN','LOGOUT','LOGOUTMESSAGE') 

	SELECT	UseEntryForm,DISPLAY_ATT_LOGON
	FROM	THRMSetting

	SELECT TLanguageText.*
	FROM TLanguageText	
	WHERE 
		UPPER(TLanguageText.Text_ID) IN ('FORGOTYOURPASSWORD') 

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=C:\ColdFusion10\cfusion\wwwroot\SunFish\sunfish5\ehrm\default.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=*/*
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=CFGLOBALS=urltoken%3DCFID%23%3D74459218%26CFTOKEN%23%3D7309278a9ac61dbc%2D78DAC88D%2DCA96%2D3A9E%2D4EC3CA40A80D8ED3%23lastvisit%3D%7Bts%20%272026%2D07%2D23%2007%3A07%3A52%27%7D%23timecreated%3D%7Bts%20%272026%2D07%2D23%2007%3A07%3A51%27%7D%23hitcount%3D5%23cftoken%3Dd72f47f3f89b53bd%2D78DABEF9%2DF154%2D1B04%2D72AF3527BD3CAE38%23cfid%3D74459216%23; CFID=74459219; CFTOKEN=caa80322d78c1b42-78DACAFE-DE56-FABB-FB3A0A0D1FA8A3B8; LANG_ID=1; MODE=pc
HTTP_HOST=hr.mais.gov.my
HTTP_REFERER=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
PATH_INFO=
PATH_TRANSLATED=C:\ColdFusion10\cfusion\wwwroot\SunFish\sunfish5\ehrm\default.cfm
QUERY_STRING=changemode=pc&refresh=%7Bts+%272026-07-22+04%3A43%3A36%27%7D
REMOTE_ADDR=172.16.251.135
REMOTE_HOST=172.16.251.135
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/sunfish5/ehrm/default.cfm
SERVER_NAME=hr.mais.gov.my
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=

Client Variables:
cfid=74459216
cftoken=d72f47f3f89b53bd-78DABEF9-F154-1B04-72AF3527BD3CAE38
hitcount=9
lastvisit={ts '2026-07-23 07:07:53'}
timecreated={ts '2026-07-23 07:07:51'}
urltoken=CFID=74459219&CFTOKEN=caa80322d78c1b42-78DACAFE-DE56-FABB-FB3A0A0D1FA8A3B8

Cookie Variables:
CFGLOBALS=urltoken=CFID#=74459218&CFTOKEN#=7309278a9ac61dbc-78DAC88D-CA96-3A9E-4EC3CA40A80D8ED3#lastvisit={ts '2026-07-23 07:07:52'}#timecreated={ts '2026-07-23 07:07:51'}#hitcount=5#cftoken=d72f47f3f89b53bd-78DABEF9-F154-1B04-72AF3527BD3CAE38#cfid=74459216#
CFID=74459219
CFTOKEN=caa80322d78c1b42-78DACAFE-DE56-FABB-FB3A0A0D1FA8A3B8
LANG_ID=1
MODE=pc

Session Variables:
cfid=74459219
cftoken=caa80322d78c1b42-78DACAFE-DE56-FABB-FB3A0A0D1FA8A3B8
sessionid=SUNFISH_HR53_CF10_HR_MAIS_GOV_MY_LIVE20120724_74459219_caa80322d78c1b42-78DACAFE-DE56-FABB-FB3A0A0D1FA8A3B8
urltoken=CFID=74459219&CFTOKEN=caa80322d78c1b42-78DACAFE-DE56-FABB-FB3A0A0D1FA8A3B8

URL Parameters:
changemode=pc
refresh={ts '2026-07-22 04:43:36'}