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