1. 如果有inner join考虑换成单表查询
select mo.id, bounty, confirm_time, deal_time, gathering_amount, currency, gathering_channel_code, gathering_code_storage_id, merchant_id, note, mo.order_no, order_state, platform_confirm_time, submit_time, settle_rate, mo.pay_Type
from merchant_order mo
-- inner join merchant_order_pay_info mopi
-- on mo.id = mopi.merchant_order_id
order by submit_time desc
加了submit_time索引之后。