Question

yii框架save时候 如何打印sql

$Verification = Verification::findOne($verification_id);
$Verification->result = intval($result);
$Verification->description = $description;
$Verification->updating = date('Y-m-d H:i:s',time());
$Verification->price =self::formatPrice($price);
$Verification->discount_price = self::formatPrice($discount_price);
$result=$Verification->save();
更细数据的时候

Answer 1

在config/main.php中

'components'=>array(

'db'=>array(

'enableParamLogging' => true,//增加这行
),

'log'=>array(
'class'=>'CLogRouter',
'routes'=>array(
array(
'class'=>'CFileLogRoute',
'levels'=>'trace, info error, warning', //日志标准增加trace, info
),
),
),

)

在你的application.log中可以直接查看, 另外一种方法,也是最方便的就是安装debugtoolbar扩展,开发必备.