Display sql statement

Archives Yii 1.0.x Discussions
1

Can any body suggest , how to display SQL statements, executed by CActiveDataProvider / CSqlDataProvider?

2 

'db'=>array(

         …

        'enableProfiling'=>true,

        'enableParamLogging' => true,

),

'log'=>array(

    'class'=>'CLogRouter',

    'routes'=>array(

        …

        array(

            'class'=>'CProfileLogRoute',

            'levels'=>'profile',

            'enabled'=>true,

        ),

    ),

),
3

for this case we have to use FireFox. Can’t we directly access the sql statement using echo $varName; ?

4

Firefox? What for? It works in all browsers.