原SQL执行计划:
EXPLAIN
SELECT tm.id,
tm.to_no ,
tm.source_website_id ,
tm.warehouse_name ,
tm.target_website_id ,
tm.channel_name ,
tm.sale_channel_name ,
ti.product_basic_id ,
ti.product_basic_no ,
ti.product_basic_name ,
ti.tax_rate ,
ti.sale_tax_rate ,
ti.quantity/ti.main_aux_ratio quantity ,
ti.unit_cost * ti.main_aux_ratio unit_cost,
ti.unit_cost * IFNULL(ti.quantity,0) amount,
ti.received_qty,
tm.po_no ,
tm.source_website_name,
tm.target_website_name,
createUser.user_name create_user_name,
auditUser.user_name audit_user_name,
outUser.user_name out_user_name,
DATE_FORMAT(tm.create_time, '%Y/%m/%d %H:%i:%s') create_time ,
DATE_FORMAT(tp.audit_time, '%Y/%m/%d %H:%i:%s') audit_time ,
DATE_FORMAT(tp.out