| 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-MO08255149%' or sd.Title like '%CIMS-MO08255149%' or sd.ProbDescription like '%CIMS-MO08255149%')) and (SubmittedBy=2252 or Owner=2252 or ApprovalManager=2252 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=2252) or ProxySubmittedBy=2252 or groupid in (622,159,721,722,723,150) ))) order by ProblemID DESC | 2,287 | 2,287 | 0 | 0.00 |
Return
Main page
Update
PDF
Day
Week
All
Find usages