very bad api response times

[Highfire1]

nothing wrong with it but i think we can do at least 5x better

[Highfire1]

well no, 500 ms is unreasonable for 50 results even if there's some joins on it

i think something is wrong with how we retrieve results