yii用法

yii输出sql 1.0和2.0都可以用

$query = User::find()->where(['id'=>[1,2,3,4])->select(['username'])
echo $query->createCommand()->getRawSql();

between写法

      $criteria = new CDbCriteria(array('order' => 'day desc'));
      $criteria->addBetweenCondition('day', $startDate, $endDate);
        $query = TotalData::model()->findAllByAttributes([], $criteria);
        $data = [];
        foreach ($query as $v) {
            $data[] = $v->getAttributes();
        }