Yii - 回显最后一个查询 [英] Yii - echo the last query

问题描述

我以前使用过 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,
        ),
    ),
),

这篇关于Yii - 回显最后一个查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！