create index on hosts.
create get_available method to host model.