Laravel single query different output

I have a query like this

$query = MyModel::query()->where('status', 1);

and I want to get a different output

$result1 = $query->where('type', 1)->count();
$result2 = $query->where('type', 2)->count();
$result3 = $query->where('type', 3)->count();

result for $result2 and $result3 is wrong. So I try to get the raw queries from this

$result1 = $query->where('type', 1)->toSql();
$result2 = $query->where('type', 2)->toSql();
$result3 = $query->where('type', 3)->toSql();

the raw query shows

select * from `my_table` where `status` = ? and `type` = ?
select * from `my_table` where `status` = ? and `type` = ? and `type` = ?
select * from `my_table` where `status` = ? and `type` = ? and `type` = ? and type = ?

why Laravel added the where condition to $result2 and $result3?

click

2 years ago

Level 35

Because that is what you wrote.

You made a query that looks somewhat similar to this:

MyModel::query()
   ->where('status', 1)
   ->where('type', 1)
   ->where('type', 2)
   ->where('type', 3)
   ->count()

What you want is to start a new query everytime

MyModel::query()->where('status', 1)->where('type', 1)->count();
MyModel::query()->where('status', 1)->where('type', 2)->count();
MyModel::query()->where('status', 1)->where('type', 3)->count();

or shorter:

MyModel::where(['status' => 1, 'type' => 1])->count();
MyModel::where(['status' => 1, 'type' => 2])->count();
MyModel::where(['status' => 1, 'type' => 3])->count();

Please or to participate in this conversation.