| Request | Mean time (ms) | Max time (ms) | Standard deviation | Mean cpu time (ms) | % of system error |
|---|---|---|---|---|---|
select count(sd.problemid) FROM usermgmt_master USER, sd_statesmaster state,usermgmt_master user1 RIGHT JOIN sd_servicereqmaster sd ON user1.UserID=sd.Owner WHERE sd.projectID =1 AND
user.UserID=sd.SubmittedBy AND state.stateID=sd.currentStatus and ((((sd.RequestID like '%CIMS-MO08255109%' or sd.Title like '%CIMS-MO08255109%' or sd.ProbDescription like '%CIMS-MO08255109%')) and (SubmittedBy=1690 or Owner=1690 or ApprovalManager=1690 or ProblemID in(Select DISTINCT sm.ProblemID from sd_servicerequest_multiapproval sm,sd_multiapproval_master am where sm.StateID=am.StateID and (if((am.AppType<>0),1,(if(sm.Status<>0,1,0)))) and sm.Owner=1690) or ProxySubmittedBy=1690 or groupid in (27,622,159,721,722,723,146) ))) order by ProblemID DESC | 2,186 | 4,197 | 1,341 | 0.00 |
Return
Main page
Update
PDF
Day
Week
All
Find usages