| Request | Mean time (ms) | Max time (ms) | Standard deviation | Mean cpu time (ms) | % of system error |
|---|---|---|---|---|---|
SELECT distinct AState FROM sd_workflowmaster sw inner join sd_workflowdetail s on sw.StateMovementID=s.StateMovementID and s.WORKFLOW_CATEGORYID =1 inner join sd_workflowdetail d on d.StateMovementID = s.StateMovementID and d.WORKFLOW_CATEGORYID =2 inner join sd_workflowdetail e on e.StateMovementID = d.StateMovementID and (e.WORKFLOW_CATEGORYID =3 and find_in_set(e.WORKFLOW_CATEGORY_VALUE,?)) inner join sd_workflowdetail f on d.StateMovementID = f.StateMovementID inner join sd_workflowdetail g on f.StateMovementID = g.StateMovementID inner join sd_workflowdetail h on g.StateMovementID = h.StateMovementID inner join sd_servicereqmaster sd on sd.currentstatus=sw.PState and sw.projectid=sd.projectid and sd.serviceid=s.WORKFLOW_CATEGORY_VALUE and (d.WORKFLOW_CATEGORY_VALUE=0 OR d.WORKFLOW_CATEGORY_VALUE=sd.subcategory) and (f.WORKFLOW_CATEGORYID=4 and (f.WORKFLOW_CATEGORY_VALUE=0 OR f.WORKFLOW_CATEGORY_VALUE=sd.derivedField1)) and (g.WORKFLOW_CATEGORYID=5 and (g.WORKFLOW_CATEGORY_VALUE=0 OR g.WORKFLOW_CATEGORY_VALUE =sd.derivedField2)) and (h.WORKFLOW_CATEGORYID=6 and (h.WORKFLOW_CATEGORY_VALUE=0 OR h.WORKFLOW_CATEGORY_VALUE =sd.derivedField3)) where sd.problemid = ? | 4 | 529 | 13 | 0.00 |
|
|
|
The units of the values are "m" for milli (1 / 1000), "k" for kilo/thousands, "M" for mega/millions, "G" for giga/billions and "u" for micro (1 / 1000000)
|
Return
Main page
Update
PDF
Day
Week
All
Find usages