如何获取 YII2 AR 执行的 SQL 语句,直接用程序输出,而不是通过日志去查看

$query = User::find()
  ->where(['id'=>[1,2,3,4])
  ->select(['username'])
// get the AR raw sql in YII2
$commandQuery = clone $query;
echo $commandQuery->createCommand()->getRawSql();
$users = $query->all();

转自:https://gist.github.com/dcb9/e5fd296ba4bca16bf98c

2 comments:

评论已关闭。