Monitoring JavaMelody on /SapphireIMS_PRODCIMSAPP1

Return

Return

Main page

Main page

Update

Update

PDF

PDF Choice of period : Day

Day

Week

Request	Hits by parent request	Mean time (ms)	Max time (ms)	Standard deviation	Mean cpu time (ms)	Mean allocated Kb	% of system error	Mean hits sql	Mean time sql (ms)
/SDWorkGroupAddEdit.jsp GET		387	492	148	116	25,064	0.00	90	208
SELECT UserID FROM userdetails where UserName=?	2.00	0	38	3			0.00
select userId from assetusers where AssetRoleID in (select AssetRoleID from assetroles where InheritedFrom='3' or InheritedFrom='1' or InheritedFrom='2') and UserId=1	1.00	2	37	5			0.00
SELECT UserID FROM userdetails where UserName = ?	2.00	1	86	3			0.00
SELECT GROUP_CONCAT(GroupID) FROM groupdetail where UserID=1	2.00	1	108	3			0.00
SELECT AccessType FROM usermgmt_details where AccessID in (1,5)	2.00	1	49	9			0.00
/SD_TabImport.jsp	2.00	13	787	85	3	785	0.00
select modulename from asset_module_master where moduleid=?	21.00	1	256	4			0.00
SELECT PRIVILEGEID FROM privilege_master where PRIVILEGE_NAME='My Asset'	1.00	1	19	3			0.00
SELECT * FROM privilege_details where GroupID in (select GroupID from groupdetail where UserID=1) and PrivilegeID=4	1.00	1	14	1			0.00
SELECT ProjectID, ProjectName FROM sd_project_master where Status=0 and ProjectID in (SELECT distinct(ProjectID) FROM sd_project_roles where ProjectRoleID in (SELECT ProjectRoleID FROM sd_project_roles_details where UserID=1))	1.00	1	28	2			0.00
Select SettingValue from sd_configsettings where SettingKEY=? and ProjectID=? and (ServiceID=? or ServiceID=0)	2.00	1	4,109	31			0.00
Select distinct(rm.ProjectRoleID) from sd_project_roles rm,sd_project_roles_details rd where rd.UserID=1 and rd.ProjectRoleID = rm.ProjectRoleID	2.00	0	1	0			0.00
/SDProjectSettingsLeftPanelMenu.jsp	1.00	31	130	39	15	2,670	0.00	3	7

Powered by JavaMelody