Yii - 回显上一个查询

2021-12-23 00:00:00 orm frameworks php yii activerecord

我以前使用过 Codeigniter，它有一个功能可以回显上一个数据库查询 - 对于调试非常有用.

I have used Codeigniter before and it has a feature that will echo the last database query - really useful for debugging.

例如...

$this->getSomeData->findAll();
Yii command to output this single query e.g SELECT * FROM TABLE...

Yii 是否有类似的功能来简单地显示最后执行的查询?

Does Yii have a similar feature to simply show the very last query executed?

推荐答案

在您的配置文件中试试这个.您可以在页面底部查看查询和其他详细信息.

Try this in your config file. You can see the query and other details at the bottom of the page.

'db'=>array(
        'enableProfiling'=>true,
        'enableParamLogging' => true,
),
'log'=>array(
    'class'=>'CLogRouter',
    'routes'=>array(
        …
        array(
            'class'=>'CProfileLogRoute',
            'levels'=>'profile',
            'enabled'=>true,
        ),
    ),
),

相关文章