Improve performance of GET /api/:version/projects/:id/events

This endpoint has high number of requests as we can see here. We should set a higher urgency after addressing the performance issues.

Kibana link to monitor DB duration.