Laravel 中的计数函数机制

Question

假设我们有这个代码count() 函数的结果是关于每个查询还是在查询执行之后 count 函数返回结果？$model=Model::query()foreach ($Entities as $entity) {               $model->orWhereBetween("id",$entity->first_id,$entity->last_id])         }$model->count()

Answer 1

Salam，

答案：这取决于您何时调用 count 方法！

在您的代码中：

$model=Model::query();

$model2 = $model;

foreach ($Entities as $entity) {

//you should save your where between in self $model varriable

    $model = $model->orWhereBetween("id",$entity->first_id,$entity->last_id])

}

//$model - object of query builder

$model->count();//After operations and filtering 

$model2->count();//Before operations and filtering (  It is equal or more than $model->count()  )

我希望这可以帮助你 ：）

Answer 2

$model=Model::query()

    foreach ($Entities as $entity) {

        $model->orWhereBetween("id",$entity->first_id,$entity->last_id])

    }

//$model - object of query builder

$model->count();

它将生成一个查询并在 db 端进行计算： SELECT COUNT(*) FROM table WHERE id BETWEEN ? AND ? OR id BETWEEN ? AND ? OR id BETWEEN ? AND ?