I have logged the sql for query like above. prisma will split

notIn

clause to 5000 per chunk and merge each result which result in the wrong total count results