php在统计数据的时候如何优化

Question

        $add_clues_where[0] = array("dealers_id" => $dealers_id,"time"=> $today);
        $add_clues_where[1] = array("dealers_id" => $dealers_id,"time"=> $week);
        $add_clues_where[2] = array("dealers_id" => $dealers_id,"time"=> $last_week);
        $add_clues_where[3] = array("dealers_id" => $dealers_id,"time"=> $moth);
        $add_clues_where[4] = array("dealers_id" => $dealers_id,"time"=> $last_moth);
        $add_clues_where[5] = array("dealers_id" => $dealers_id);
        foreach ($add_clues_where as $key => $value) {
            $add_clues[] = $DC -> CountClues($value);
        }

用的是thinkphp， CountClues是cure查询；
现在我能想到,就这是上面这样，依次传入不同的搜索条件，然后循环查询结果，取出结果，但是我的页面还有很多这样的查询，打开页面都2秒多了，如何优化呢

Answer 1

建议把历史数据按某一周期归档

Answer 2

如果实时性没有要求的话可以用缓存做。或者使用异步查询出来结果后放到缓存中