yii2.0--打印添加/修改/删除操作sql语句

 插入数据：

$shop_info = new ShopInfo();
$sql = 'insert into lg_shop_info (shop_name,shop_type) values("zhang",1)';
        $query = ShopInfo::findBySql($sql);
        $command = clone $query;
        echo $command->createCommand()->getRawSql();


$shop_info = Yii::$app->db->createCommand()->insert('lg_shop_menu', [
            'menu_tag' => 'zam',
            'menu_name' => 'menu',
        ]);

var_dump($shop_info->getRawSql());

修改数据：

$shop_info = new ShopInfo();
$query = ShopInfo::findBySql('update lg_shop_info set shop_name="yang" where id=65');
        $command = clone $query;
        echo $command->createCommand()->getRawSql();


$update = Yii::$app->db->createCommand()->update('lg_shop_m