[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000725s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` `p` LEFT JOIN `cmf_portal_category` `c` ON `c`.`id`=`p`.`category_id` WHERE `category_id` = 8 AND `p`.`delete_time` = '0' AND `post_status` = 1 AND `published_time` = 0 LIMIT 1 [ RunTime:0.018842s ]
[ SQL ] SELECT `p`.*,c.name as cname,c.id as cid FROM `cmf_portal_post` `p` LEFT JOIN `cmf_portal_category` `c` ON `c`.`id`=`p`.`category_id` WHERE `category_id` = 8 AND `p`.`delete_time` = '0' AND `post_status` = 1 AND `published_time` = 0 LIMIT 30,10 [ RunTime:0.003857s ]