| Request | Mean time (ms) | Max time (ms) | Standard deviation | Mean cpu time (ms) | % of system error |
|---|---|---|---|---|---|
SELECT DISTINCT IF(COUNT(am1.AssetID)>0,ad3.Assetvalue,'--') AS attribute7, IF(COUNT(am1.AssetID)>0,ad4.Assetvalue,'--') AS attribute8,
IF(COUNT(am1.AssetID)>0,ad5.Assetvalue,'--') AS attribute6 FROM Assetmaster am INNER JOIN Assetdetails ad ON am.AssetID=ad.AssetID AND ad.ItemDetailsID=121 INNER JOIN Assetdetails ad1 ON ad.AssetID=ad1.AssetID AND ad1.ItemDetailsID =202 INNER JOIN Assetdetails ad6 ON ad.AssetID=ad6.AssetID AND ad6.ItemdetailsID=506 LEFT JOIN AssetDetails ad2 ON ad1.Assetvalue=ad2.Assetvalue AND ad2.ItemDetailsID=508 INNER JOIN AssetMaster am1 ON ad2.AssetID=am1.AssetID AND am1.Status=0 AND am1.ItemTypeID=20013 Inner JOIN AssetDetails ad7 ON am1.AssetID=ad7.assetID AND ad7.ItemdetailsID=510 AND ad6.Assetvalue=ad7.assetvalue LEFT JOIN AssetDetails ad3 ON am1.AssetID=ad3.AssetID AND ad3.ItemDetailsID=206 LEFT JOIN AssetDetails ad4 ON am1.AssetID=ad4.AssetID AND ad4.ItemDetailsID=208 LEFT JOIN AssetDetails ad5 ON am1.AssetID=ad5.AssetID AND ad5.ItemDetailsID=210 WHERE am.Status=0 AND am.ItemTypeID=20005 AND am.assetnumber= 222001 LIMIT 1 | 1,466 | 1,466 | 0 | 0.00 |
Return
Main page
Update
PDF
Day
Week
All
Find usages