In `Namespace#find_by_pages_host` we always have top level namespaces
which means we can use `find_by_path` instead of `find_by_full_path` and
avoid join on `routes`.

Related to https://gitlab.com/gitlab-org/gitlab/issues/207096.