深圳智汇创想科技有限公司

SELECT `OrderSourceId` FROM `Ap_AutoPublish_Mercadolibre_Queue`
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