Database

[{"collection":"things","count":100,"content":{"propA":{"type":"array","minLength":40,"maxLength":70,"arrayContent":{"type":"int","min":0,"max":50}},"propB":{"type":"array","minLength":40,"maxLength":70,"arrayContent":{"type":"int","min":0,"max":50}},"propC":{"type":"array","minLength":40,"maxLength":70,"arrayContent":{"type":"int","min":0,"max":50}}},"indexes":[{"name":"propA_1","key":{"propA":1}},{"name":"propB_1","key":{"propB":1}},{"name":"propC_1","key":{"propC":1}}]}]

Query

db.things.find({"propA":{"$all":[2,3,5],"$nin":[97,89]},"propB":{"$all":[7,11,13],"$nin":[83,79]},"propC":{"$all":[0,2,4],"$nin":[73,71]}}).explain()

Result