Yii 1是否有任何原生方法来获取带有变量的原始SQL？
我尝试使用CDbExpression和CommandBuilder在几个子查询上构建一个复杂的查询，结果如下：

SELECT * FROM `news` `t` WHERE id IN (:ycp0, :ycp1, :ycp2, :ycp3, :ycp4) LIMIT 5

标准内容的转储：

CDbCriteria Object (
  [select] => *
  [condition] => id IN (:ycp0, :ycp1, :ycp2, :ycp3, :ycp4)

  ...

  [params] => Array(
    [:ycp0] => CDbExpression Object(
      [expression] => SELECT id FROM `news` `t` WHERE (rubric=:rb1) AND (:im2 & `im`=:im2) LIMIT 1
      [params] => Array(
        [:rb1] => 1
        [:im2] => 2
      )
    )

    ...

  )
)

我期望对这样的查询字符串进行编译：

SELECT * FROM .. WHERE id IN(
    (SELECT id FROM .. WHERE .. ORDER BY .. LIMIT 1),
    (SELECT id FROM .. WHERE .. ORDER BY .. LIMIT 1)
) ORDER BY .. LIMIT 5

这就是我在代码中所做的

$criteria = new CDbCriteria( ... );
$sql = $this->commandBuilder->createFindCommand($tableName, $criteria)->getText();
$queries[] = new CDbExpression($sql, $criteria->params);

然后，我尝试将子查询组合成一个复杂查询

$criteria = new CDbCriteria( ... );
$criteria->addInCondition('id', $queries);

最后，我尝试以SQL-query的形式获取结果

$sql = $this->commandBuilder->createFindCommand($tableName, $criteria)->getText();