| 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-MO08255160%' or sd.Title like '%CIMS-MO08255160%' or sd.ProbDescription like '%CIMS-MO08255160%')) and (SubmittedBy=1688 or Owner=1688 or ApprovalManager=1688 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=1688) or ProxySubmittedBy=1688)) or ((((sd.RequestID like '%CIMS-MO08255160%' or sd.Title like '%CIMS-MO08255160%' or sd.ProbDescription like '%CIMS-MO08255160%'))))) order by ProblemID DESC | 5,054 | 5,054 | 0 | 0.00 |
Return
Main page
Update
PDF
Day
Week
All
Find usages