Mysql 按 create_time 排序导致的问题

                                                               Mysql 按 create_time 排序导致的问题

一、已知：总记录不超过3000行

二、下列SQL执行数据存在

SELECT * FROM `job_user` WHERE `status` IN (1,2,3,4)  AND `is_deleted` = 0 AND id = 1988 ORDER BY `create_time` DESC LIMIT 0,1000

三、但是下列3条limit记录中都没有id=1988这条数据。

SELECT * FROM `job_user` WHERE `status` IN (1,2,3,4)  AND `is_deleted` = 0 ORDER BY `create_time` DESC LIMIT 0,1000

SELECT * FROM `job_user` WHERE `status` IN (1,2,3,4)  AND `is_deleted` = 0 ORDER BY `create_time` DESC LIMIT 1000,1000

SELECT * FROM `job_user` WHERE `status` IN (1,2