WHERE ((( `CustomerId` = 1 ) AND ( `Status` = 'normal' )) AND (( `TaskStatus` = 1 ) OR ((( `TaskStatus` = 2 )
AND ( `LoadQueueTime` < TIMESTAMP ( '2022-12-16 06:00:05.518817' ) ))
AND ( `LoadQueueTime` > TIMESTAMP ( '2022-12-11 07:00:05.518819' ) ))))
GROUP BY
`OrderSourceId`;
建议优化:
SELECT distinct OrderSourceId FROM `Ap_AutoPublish_Mercadolibre_Queue` force index(idx_LoadQueueTime_TaskStatus_Status_CustomerId)
WHERE `CustomerId` = 1 AND `Status` = 'normal' AND TaskStatus in(1,2)
AND `LoadQueueTime` < '2022-12-16 06:00:05'
AND `LoadQueueTime` > '2022-12-11 07:00:05'
;
新建索引:idx_LoadQueueTime_TaskStatus_Status_CustomerId
添加索引后,优化前后的执行速度相近,且优化后的SQL业务与原SQL不一致,SQL暂不调整 如下: