Snippet search is slow

On GitLab.com (and probably locally with a large-enough dataset), browing to /explore/snippets and searching for foo takes took 47 seconds to complete.

Request: GET https://gitlab.com/search?utf8=✓&search=foo&group_id=&project_id=&snippets=true&repository_ref=