代码部分
G("run");
$page = intval($_REQUEST['pageNum']) ? intval($_REQUEST['pageNum']) : 0; //当前页
$pageSize = intval($_REQUEST['pageSize']) ? intval($_REQUEST['pageSize']) : 6; //每页显示数
//初始化查询条件
$map['recommended'] = 1;
$map['status'] = 1;
// $map['_string']='FIND_IN_SET("'.$tag.'", tags)';
$mod_cook=D('cook');
$mod_cook_topic=M('cook_topic');
$total = $mod_cook_topic->where($map)->count();
$totalPage = ceil($total / $pageSize); //总页数
$startPage = $page * $pageSize; //开始记录
$cook_topic=$mod_cook_topic->limit($startPage, $pageSize)->order('id desc')->field("id,title,cover,topic_desc,cook_ids,hits,likes,add_time")->where($map)->order('add_time desc,ordid asc')->select();
$cook = array();日志部分[ SQL ] SHOW COLUMNS FROM `ck_cook_topic` [ RunTime:0.004506s ]
[ SQL ] SHOW COLUMNS FROM `ck_cook_topic` [ RunTime:0.003431s ]
[ SQL ] SHOW COLUMNS FROM `ck_cook_topic` [ RunTime:0.003259s ]
[ SQL ] SHOW COLUMNS FROM `ck_cook_topic` [ RunTime:0.003362s ]
[ SQL ] SHOW COLUMNS FROM `ck_cook_topic` [ RunTime:0.003596s ]
[ EXPLAIN : array ( 'id' => '1', 'select_type' => 'SIMPLE', 'table' => 'ck_cook_topic', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => '102', 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ck_cook_topic` WHERE `recommended` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.001349s ]
[ SQL ] SHOW COLUMNS FROM `ck_cook_topic` [ RunTime:0.003157s ]
[ SQL ] SHOW COLUMNS FROM `ck_cook_topic` [ RunTime:0.003215s ]
[ SQL ] SHOW COLUMNS FROM `ck_cook_topic` [ RunTime:0.003115s ]
[ SQL ] SHOW COLUMNS FROM `ck_cook_topic` [ RunTime:0.003518s ]
[ EXPLAIN : array ( 'id' => '1', 'select_type' => 'SIMPLE', 'table' => 'ck_cook_topic', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => '102', 'extra' => 'Using where; Using filesort', ) ] 最佳答案
