Curd of yii2.0

In yii2.0, is there a getLastSql () method in tp to query the executed SQL statement? In yii2.0, is there a getLastSql () method in tp to query the executed SQL statement?

Reply content:

In yii2.0, is there a getLastSql () method in tp to query the executed SQL statement?

Echo (new \ yii \ db \ Query)-> from ('users')-> where (['name' => 'moca'])-> createCommand () -> rawSql; // same as getRawSql ()

Output

SELECT * FROM 'users' WHERE 'name' = 'moca'

Yii-db-command

This is not clear, but you can use debug mode to view the running status and executed SQL information.

In web/index. php

Defined ('yii _ debug') or define ('yii _ debug', true); defined ('yii _ env') or define ('yii _ env ', 'test ');