Audit and Adjustment of Profile Offers Queries

[kespinola]

Goal

Profiles offer query responds in 500ms.

Requirements

• [x] Audit the current query speed and identify causes of slow response times
• [x] Draft proposal to speed up the query
• [x] Implement the proposal

[imabdulbasit]

rebuilt invalid indexes for offers table so that should make profile offers query faster.

[kespinola]

Backport the index changes.

[kespinola]

done.