Query using index still taking time when using $in attribute and sorting

[Viraj_Chheda]

hi @Pavel_Duchovny , Thanks for the suggestion of ESR order for indexing, that has worked for me.
For all the columns on which range i.e $in was getting applied, I have moved it at the end in indexing order.