记录列表翻页（sql翻页）

$sql = "SELECT count(*) as total  FROM `sysitem_item_status` s  INNER JOIN  `sysitem_item` i ON (s.`item_id` = i.`item_id`) WHERE s.approve_status='onsale'  ";

        $row = kernel::single('base_query')->getRow($sql,'total');

        $total = $row['total'];

        ///

        $pagesize=20; //设置每一页显示的记录数

        $totalPages=ceil($total/$pagesize);

        $pages = $_GET['pages']?intval($_GET['pages']):1;

        $offset = $pagesize * ($pages - 1);

        ///

        ///

        $sql = "SELECT  * FROM `sysitem_item_status` s  INNER JOIN  `sysitem_item` i ON (s.`item_id` = i.`item_id`) WHERE s.approve_status='onsale' order by s.list_time desc  limit $offset,$pagesize  ";

        $pagedata['itemList'] = kernel::single('base_query')->getRows($sql);

        foreach($pagedata['itemList'] as $k=>&$v) {

            $sql = "SELECT buy_count FROM `sysitem_item_count` where item_id={$v['item_id']}";

            $tmp_buy_count= kernel::single('base_query')->getRow($sql);

            $v['buy_count'] = $tmp_buy_count['buy_count'];

        }

//处理翻页数据

        $filter['pages'] = time();

        $current = $totalPages < $pages ? $totalPages : $pages;

        $pagedata['pagers']  = array(

            'link'=>url::action('topc_ctl_goodseries@newgoods',$filter),

            'current'=>$current,

            'total'=>$totalPages,

         //   'use_app'=>'topshop',

            'token'=>$filter['pages'],

        );

        $pagedata['recommend_html'] = $this->recommendList();

        return $this->page('topc/nav/newgoods.html', $pagedata);记录列表翻页（sql翻页）