雄辩在哪里堆积

Question

我的问题如下所示$data = Model::whereRaw(<condition 1>)$data1 = $data->whereRaw(<condition 2>)$data2 = $data->whereRaw(<condition 3>)每当我打印时$data2->toSql()我都会得到这个select * from table where <condition 1> and <condition 2> and <condition 3>代替select * from table where <condition 1> and <condition 2>

Answer 1

因为 $data, $data1,$data2 指针指向内存中的同一个对象...

解决这个问题：

$data = Model::whereRaw(<condition 1>);

$data1 =(clone $data)->whereRaw(<condition 2>)

$data2 = (clone $data)->whereRaw(<condition 3>)

Answer 2

尝试

$data  = Model::whereRaw(<condition 1>);

$data_cloned = $data->replicate();

$data1 = $data->whereRaw(<condition 2>);

$data2 = $data_cloned->whereRaw(<condition 3>);

return $data1->toSql();