Return Return     Main page Main page      Update Update     PDF PDF     Choice of period :  Day Day  Week Week  All All  Customized Customized


           (m/d/yy)     



Request Mean time (ms)Max time (ms) Standard deviationMean cpu time (ms) % of system error
sql  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.problemId = 770631 and ( SubmittedBy=2048 or Owner=2048 or ApprovalManager=2048 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=2048) or ProxySubmittedBy=2048 ) order by ProblemID DESC
1 1 0   0.00
Find usages Find usages
Powered by JavaMelody