Optimized query for /all/order/hot route.