Resolve remaining N+1 in Search API (Advanced) projects scope

Closes #218703

See merge request gitlab-org/gitlab!35833