Why can't I find data when mysql uses notin?

Why can't I find data when mysql uses notin. Select & nbsp; id, cid, title, keywords, hits, addtime & nbsp; from & nbsp; 'articles' & nbsp; where & nbsp; id & nbsp; not & nbsp; in (4454,4453, 4452,4451 why does mysql use not in.
Select id, cid, title, keywords, hits, addtime from 'article' where id not in (4454,4453, 4452,4451, 4450,4449, 4448,4447) order by addtime desc, id desc LIMIT 0, 18


The preceding statement removes not in and has data. This is why. The database contains more than 4000 data records ranging from 1 to 4454. It cannot be found. And it was okay before, and I suddenly couldn't find it. Very strange. Share:
------ Solution --------------------
It seems that the not in mysql has a certain bug. I have also encountered that the result of direct not in (values) query is 0.
You can try it like this:
Create a new table, such as ids, with only one id field. Insert 4454,4453, 4452,4451, 4450,4449, 4448,4447 into the table, and then query it like this:
Select id, cid, title, keywords, hits, addtime from 'article' where id not in (select id from ids) order by addtime desc, id desc LIMIT 0, 18;
I did this before, hoping to help you