智能刊登gaussdb 慢sql top 10
2.解决方案
1.select * 改为具体的列
2.使用`IS NULL`或`IS NOT NULL`将可能导致引擎放弃使用索引而进行全表扫描改造优化
3.原sql
SELECT *
FROM `M_Allegro_Listing`
WHERE `CustomerId` = 1
AND NOT (`Sku` = ''
OR `Sku` IS NULL)
AND `OrderSourceId` IN (14450)
AND `PublishTime` >= '2022-03-26 00:00:00'
AND `PublishTime` <= '2022-03-31 00:00:00'
AND `OnlineStatus` IN (1)
AND CASE WHEN `IsAutoPublish` = 1 THEN 1 ELSE 0 END IN (1, 0)
ORDER BY `Id` DESC
LIMIT 0, 100