Implement Drupal 7 style loading to reduce the number of queries and speed things up

Drupal 7 standard is to load a group of objects at once using an IN(), which reduces the number of SQL round trips.

For support_*, this involves moving some queries out of _view and into _load, and changing _load to consider the entire set of objects being loaded instead of handling them one at a time.