我们在使用model进行查询的时候,或者其他,我们想要打印出来model赋值后,在mysql数据库中执行的sql,我们可以使用下面的方法打印sql。
$query = Salesorder::find()
->where(['order_id'=>[1,2,3,4]])
->select(['order_id'])
;
// get the AR raw sql in YII2
$commandQuery = clone $query;
echo $commandQuery->createCommand()->getRawSql();
exit;
- $query = Salesorder::find()
- ->where(['order_id'=>[1,2,3,4]])
- ->select(['order_id'])
- ;
- // get the AR raw sql in YII2
- $commandQuery = clone $query;
- echo $commandQuery->createCommand()->getRawSql();
- exit;
$query = Salesorder::find()
->where(['order_id'=>[1,2,3,4]])
->select(['order_id'])
;
// get the AR raw sql in YII2
$commandQuery = clone $query;
echo $commandQuery->createCommand()->getRawSql();
exit;
adminfather