Yii - 如何打印 findAll 使用的 SQL

2022-01-04 00:00:00 php yii

我有以下代码可以从数据库中获取一些记录

I have the following code to get some records from db

    $criteria = new CDbCriteria();
    $criteria->condition = 't.date BETWEEN "'.$from_date.'" AND "'.$to_date.'"';
    $criteria->with = array('order');

    $orders = ProductOrder::model()->findAll($criteria);

是否可以获取findAll使用的SQL?我知道您可以从调试控制台获取它.但是我在后台使用 yiic.php 运行脚本

Is it possible to get the SQL that is used by the findAll? I know you can get it from the debug console. But I'm running the script in the background using yiic.php

推荐答案

您可以在应用程序日志中记录已执行的查询并进行查看.在配置文件中是这样的:

You can log the executed queries in the application log and review that. Something like this in the config file:

'components' => array(
  'db'=>array(
    'enableParamLogging' => true,
  ),
  'log'=>array(
    'class'=>'CLogRouter',
    'routes'=>array( 
      array(
        'class'=>'CFileLogRoute',
        'levels'=>'trace,log',
        'categories' => 'system.db.CDbCommand',
        'logFile' => 'db.log',
      ), 
    ),
  ),
);

在某些情况下(例如运行测试时)，您还需要在流程结束时调用 Yii::app()->log->processLogs(null);使其工作.

In some cases (e.g. when running tests), you will also need to call Yii::app()->log->processLogs(null); at the end of the process for this to work.

当然，一旦你到达那里，就没有什么能阻止你编写自己的日志路由，对记录的消息做一些不同的事情，但请注意，日志是在请求结束时处理的(或者当你调用 processLogs)，而不是每次都记录一些东西.

Of course, once you're there nothing's stopping you from writing your own log route that does something different with the logged messages, but mind that the logs are processed at the end of the request (or when you call processLogs), not every time you log something.

顺便说一句，您不应该构建这样的查询，在查询中使用动态输入.改用绑定变量:

By the way, you should not build queries like that, with dynamic input right in the query. Use bind variables instead:

$criteria = new CDbCriteria();
$criteria->condition = 't.date BETWEEN :from_date AND :to_date';
$criteria->params = array(
  ':from_date' => $from_date,
  ':to_date' => $to_date,
);
$criteria->with = array('order');

$orders = ProductOrder::model()->findAll($criteria);

相关文章