tidb sql查询数据不正确,条件不过滤。

select count() from (select id,next_check_time,request_status From temp_order_job WHERE request_status = 1 AND next_check_time<1664360160 order by id limit 50);
select count(
) from (select id,next_check_time,request_status From temp_order_job WHERE request_status = 1 AND next_check_time<1664360160);
select count(*) from (select id,next_check_time,request_status From temp_order_job WHERE request_status = 1 AND next_check_time<1664360160 order by id );
看看查询结果,哪个有问题?