API performance boost

Query and cache optimization

Before: Average response 900ms

After: Average response 240ms

Details