This query should be very fast right? it's very simple and I just want to get 10 active offers.

This is a wildcard query so has to search through all the records if the filter clause matches most products.