mysql 批量修改优化方法

     public function test1foreach1()
    {
        $startTime = time();
        $table = M("table");
        $data =  $table->select();
        foreach ($data as $k => $v) {
            $table->where("id = {$v['id']}")->save(['type' => $v['type'] + 1,'league'=>{$v['league'].$k}]);
        }
        $endTime = time();
        echo  $endTime - $startTime;
        die;
    }
    
    
      
      
      
      
      
      
      
      
      
      
      
      
    

    public function test1()
    {
        $startTime = time();