目前,这个得进入coll这个函数,修改代码打印
1.yii2打印query 的sql语法:
$query = User::find()->where(['id'=>[1,2,3,4])->select(['username'])
// 输出SQL语句
$commandQuery = clone $query;
echo $commandQuery->createCommand()->getRawSql();
$users = $query->all();
2.fecmall实例说明,譬如:https://github.com/fecshop/yii2_fecshop/blob/master/services/Customer.php#L625
public function coll($filter = [])
{
$query = $this->_customerModel->find();
$query = Yii::$service->helper->ar->getCollByFilter($query, $filter);
return [
'coll' => $query->all(),
'count'=> $query->limit(null)->offset(null)->count(),
];
}
如果进行打印,可以打断点输出。
public function coll($filter = [])
{
$query = $this->_customerModel->find();
$query = Yii::$service->helper->ar->getCollByFilter($query, $filter);
// 输出SQL语句
$commandQuery = clone $query;
echo $commandQuery->createCommand()->getRawSql();
exit;
return [
'coll' => $query->all(),
'count'=> $query->limit(null)->offset(null)->count(),
];
}