Say:
select id from where navid in (115) and (inputtime>='2022-02-04 01:26:48' and inputtime<='2023-02-04 01:26:48') and isdisplay=1 order by paixu asc,inputtime desc,id descSay:
select * from where navid in (115) and (inputtime>='2022-02-04 01:26:48' and inputtime<='2023-02-04 01:26:48') and isdisplay=1 order by paixu asc,inputtime desc,id desc limit 0,12