# Yii2获取执行sql语句

**URL:** <https://www.shiqidu.com/t/topic/451>\
**Category:** 开发调优\
**Tags:** Yii\
**Created:** [2018 年7 月 2 日 06:44 UTC](https://www.shiqidu.com/t/topic/451 "2018-07-02T06:44:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

作者： ![Eureka](https://www.shiqidu.com/user_avatar/www.shiqidu.com/eureka/32/5_2.png) [@Eureka](https://www.shiqidu.com/u/Eureka)\
发布日期： [2018 年7 月 2 日 06:44 UTC](https://www.shiqidu.com/t/topic/451/1 "2018-07-02T06:44:50Z")

</div>

```php
$query = User::find()->where(['LIKE', 'name', 'ad%', false]);

$commandQuery = clone $query;
echo $commandQuery->createCommand()->getRawSql(); 
// SELECT * FROM `user` WHERE `name` LIKE 'ad%'

```