如何获取 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