Yii - 回显上一个查询

问题描述

我以前使用过 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 - 回显上一个查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！