$this->model=model('Page');
$total = $this->model;
$list = $this->model;
$list=$list->where('id',2);
$total=$total
->where($where)
->order($sort, $order)
->count();
$list=$list
->where($where)
->order($sort, $order)
->limit($offset, $limit)
->select();最终SQL语句[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `bc_page` WHERE `id` = 2 ORDER BY `id` desc LIMIT 1 [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT * FROM `bc_page` ORDER BY `id` desc LIMIT 0,20 [ RunTime:0.000000s ]where条件加到 count里面了?用的不对?
最佳答案
