Improve Advanced Search browse performance

- re-enable paging
- get rid of DB access from the web skin
- look up data once, re-use
- replace some DBIx based queries with raw SQL