Projects::PipelinesController#index.json is slow partially due to SQL queries

For this controller we spend 17% of the request time in SQL queries, producing the following timings:

• Mean: 231 ms
• 95th percentile: 306 ms
• 99th percentile: 459 ms

This controller receives about 1000 requests per 24 hours.