`GET /api/:version/projects/:id/hooks` can be slow

Summary

The GET /api/:version/projects/:id/hooks endpoint can be slow, which has a negative impact on error-budgets.

See: https://log.gprd.gitlab.net/app/visualize#/create?type=table&indexPattern=7092c4e2-4eb5-46f2-8305-a7da2edad090&_a=h@9d62f06&_g=h@2e32c89

Possible fixes

TBD