| Request | Mean time (ms) | Max time (ms) | Standard deviation | Mean cpu time (ms) | % of system error |
|---|---|---|---|---|---|
SELECT k.sapphire_child_reqid AS attribute6, convert((Select Count(distinct kt.Kit_Number) From Kit_Details kt Where kt.Sapphire_Child_ReqID=k.Sapphire_Child_ReqID ), CHAR) AS attribute7, convert(Sum(If(ACK_Status_API=0,1,0)),CHAR) AS attribute8 FROM `kit_details` k WHERE k.`Merchant_ID` ='157998518' AND k.`Sapphire_Child_ReqID` IS NOT NULL and k.`ACK_Status_API` = 0 and k.`hotlist_Status` = '0' and k.`dispatch_status` in ('Dispatched','Delivered') Group By sapphire_child_reqid
| 15 | 15 | 0 | 0.00 |
Return
Main page
Update
PDF
Day
Week
All
Find usages