Sqlite Order By分页查询语句优化

SELECT
    *
FROM
    LOG
WHERE
    OccurredTime BETWEEN '2021-02-22 00:00:01'
AND '2021-02-22 23:59:59.354'
ORDER BY
    OccurredTime DESC

res.OrderByDescending(o => o.OccurredTime).Skip(0).Take(100).ToList();

　

--优化后：
SELECT
    *
FROM
    LOG
WHERE
    OccurredTime BETWEEN '2021-02-22 00:00:01'
AND '2021-02-22 23:59:59.354'
ORDER BY
    OccurredTime DESC
LIMIT 100 OFFSET 0