YII2打印sql語句的辦法：可以在controller里面執(zhí)行語句，代碼為【$model->find()->createCommand()->getRawSql();】，在網(wǎng)頁里點擊底部的log就可以看到sql語句。
yii2打印sql語句的辦法：
如果你是想打印本次的Sql的話，可以用?
$model->find()->createCommand()->getRawSql();
可以在網(wǎng)頁底部的debugger看到，點擊log可以看到你執(zhí)行的sql語言（也就是連貫操作的sql語句）；
比如在controller里面你執(zhí)行
?$query=?ReleaseForm::find()->where(['type'=>1])->all();
注：源代碼是這些：
$query=??ReleaseForm::find()->where(['type'=>1]); $pagination?=?new?Pagination([ ????'defaultPageSize'?=>?5, ????'totalcount'?=>?$query->count(), ]); ???????? $property_data=?$query ????->offset($pagination->offset) ????->limit($pagination->limit) ????->all();
在網(wǎng)頁里你點擊底部的log就可以看到：
10 21:01:36.667 info yiidbCommand::query select?COUNT(*)?FROM?`releases`?WHERE?`type`=1
E:webApache24htdocsbasiccontrollersPropertyController.php?(14)
11 21:01:36.667 info yiidbConnection::open Opening?DB?connection:?mysql:host=localhost;dbname=xunwu
E:webApache24htdocsbasiccontrollersPropertyController.php?(14)
12 21:01:36.669 info yiidbCommand::query SELECT?*?FROM?`releases`?WHERE?`type`=1?LIMIT?5
E:webApache24htdocsbasiccontrollersPropertyController.php?(20)
13 21:01:36.670 info yiidbCommand::query SHOW?FULL?COLUMNS?FROM?`releases`
E:webApache24htdocsbasiccontrollersPropertyController.php?(20)
14 21:01:36.674 info yiidbCommand::query SHOW?CREATE?table?`releases`
這樣就知道你執(zhí)行了什么sql語句了
?相關(guān)學習推薦：yii教程
