Created
August 17, 2016 17:01
-
-
Save coder-liyang/4c31788ed89344e16fdc0cc997db4203 to your computer and use it in GitHub Desktop.
如何获取 YII2 AR 执行的 SQL 语句，直接用程序输出，而不是通过日志去查看
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $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(); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment