AUTO-381 stop pulling index when listing (ready for review)

Part of the speed up querying task.  This does not use the `deleted` index for any of the listing functions.  Will change the other functions in a separate pull request, but currently the other single selects don't seem to time out, so it's less high priority.

Current cloudcafe functional tests pass.