did上加索引 select A.aid, A.bid, A.cid from my_list A where A.did='jay' and TO_DAYS( NOW( ) ) - TO_DAYS(paid_time)>=2 and not exists (select 1 from rewrite where A.bid=bid)
select aid, bid, cid from my_list left join rewrite on my_list.bid=rewrite.bid where did='jay' and rewrite.bid is null and paid_time <= NOW( ) -interval 2 day
not in->LEFT JOIN
TO_DAYS( NOW( ) ) - TO_DAYS(paid_time)>=2:无法用到索引,可以考虑
建立冗余字段,保存TO_DAYS( NOW( ) ) - TO_DAYS(paid_time),在此字段上建立索引
from my_list A
where A.did='jay'
and TO_DAYS( NOW( ) ) - TO_DAYS(paid_time)>=2
and not exists (select 1 from rewrite where A.bid=bid)
aid,
bid,
cid
from my_list left join rewrite on my_list.bid=rewrite.bid
where did='jay'
and rewrite.bid is null
and paid_time <= NOW( ) -interval 2 day