Database

[{"collection":"collection","count":100,"content":{"updated_at":{"type":"date","startDate":"2022-01-01T00:00:00+00:00","endDate":"2022-07-01T00:00:00+00:00"},"ctu":{"type":"enum","values":["product","service","other"]},"pe":{"type":"enum","values":["1234567890","1","0"]},"pl":{"type":"enum","values":["ru-ru","ru","ur"]},"ps":{"type":"boolean"},"bl":{"type":"array","arrayContent":{"type":"object","objectContent":{"b":{"type":"enum","values":["main","secondary","tertiary"]},"l":{"type":"enum","values":["ru-ru","ru","ur"]}}}}},"indexes":[{"name":"original_compound_index","key":{"ctu":1,"pe":1,"pl":1,"bl":1,"ps":1,"updated_at":-1}},{"name":"single_field_index","key":{"updated_at":1}}]}]

Query

db.collection.aggregate([{$match:{ctu:"product",pe:"1234567890",pl:"ru-ru",bl:{$elemMatch:{b:"main",l:"ru-ru"}},ps:false}},{$sort:{updated_at:-1}},{$skip:0},{$limit:50},{$project:{uid:1,pd:1,v:1,l:1,mi:1}}]).explain("allPlansExecution")

Result