yii2.0一些重要但不常用知识点

1，原生sql语句写法；

$query = new \yii\db\Query();
$query->select(['el.id','el.member_id','el.be_member_id','el.time'])
    ->from('tp_each_like as el')
    ->where($condition)->orderBy('time desc');

//分页
$pages = new Pagination([
    'totalCount' => $query->count(),
    'pageSize' => '10'
]);

//数据
$elData = $query->offset($pages->offset)
    ->limit($pages->limit)
    ->all();

//$a = $query->createCommand()->getRawSql();(可以打印sql语句)
//var_dump(
$a);

//总个数
$total = $pages->totalCount;