Try to improve speed of body_request_events in the api

First thoughts, is it because of the lack of an index on `event_type`? This
PR adds one, and it seems to speed things up on my dev DB, although I'm not
100% sure that's not going to be wrong in some subtle way, because of the
small amount of data that's in it.

Closes #1709