Query taking time even after using covering index (Couchbase 4.6.4 EE)

These are composite range predicates. In 4.x these results in lot of false positives from indexer and query need to eliminate them that is why it taking time. This has been taken care in 5.0.0

Composite Predicate Pushdown explains this in more details.