Improve query performance for Dashboard::SnippetsController#index

Closes #42877

See merge request gitlab-org/gitlab-ce!17088