dcb9 · May 18, 2018 05:36 · chenyongze · Sep 19, 2016
diff --git a/get-yii2-ar-raw-sql.php b/get-yii2-ar-raw-sql.php
 <?php

 $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();
	<?php

	$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();
No results found