FROM `Apx_BasicPlan_LogDetail`
WHERE ( `CustomerId` = 1 ) AND `Id` IN
( SELECT `Id` FROM `Apx_BasicPlan_LogDetail` WHERE (((( 1 = `CustomerId` )
AND ( `LastModificationTime` >= '2023-12-17 02:08:30.630000' ))
AND ( `LastModificationTime` <= '2023-12-17 03:07:55.077000' ))
AND ( `Status` = 5 )
)
ORDER BY CreationTime ASC
);
建议优化：
SELECT Count(id)
FROM `Apx_BasicPlan_LogDetail`
WHERE `CustomerId` = 1
and LastModificationTime >='2023-12-17 02:08:30.630000' and LastModificationTime<='2023-12-17 03:07:55.077000'
and `Status` = 5;
原始查询为分页和总条数一起查询，但分页带有排序导致查询总条数速度很慢，因此将查询总条数进行拆分单独查询