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