求大佬帮忙优化一下
SELECT DISTINCT
`t`.`order_code`
FROM
kn_order t
LEFT JOIN kn_o_business b ON b.id = t.buyer_bid
LEFT JOIN kn_o_warehouse w ON w.id = t.wh_id
INNER JOIN `kn_order_line` AS `l` ON `l`.`order_id` = `t`.`id`
INNER JOIN `kn_o_sub_product` AS `p` ON `p`.`id` = `l`.sub_common_id
INNER JOIN `kn_o_main_product` AS `m` ON `m`.`id` = `p`.main_product_id
WHERE
t.buyer_bid != 1537354910479403145
AND t.IS_DEL = 0
AND t.BID = 1537354910479403145
ORDER BY
t.id DESC
LIMIT 0,
10