create index io_index on ebay_iostore (id, ebay_user, type, io_status, io_addtime)
create index xxx on ebay_iostore(ebay_user,type,io_status,io_addtime desc); create index yyy on ebay_iostoredetail(io_ordersn);select * from ebay_iostore AS a where a.ebay_user = 'vipyrd' AND a.type = '2' AND a.io_status = '1' AND a.io_ordersn NOT LIKE '%私单%' and exists (select 1 from ebay_iostoredetail where io_ordersn=a.io_ordersn) order by io_addtime desc;
create index yyy on ebay_iostoredetail(io_ordersn);select *
from ebay_iostore AS a
where a.ebay_user = 'vipyrd'
AND a.type = '2'
AND a.io_status = '1'
AND a.io_ordersn NOT LIKE '%私单%'
and exists (select 1 from ebay_iostoredetail where io_ordersn=a.io_ordersn)
order by io_addtime desc;