[ SQL ] SELECT `p`.*,c.name as cname,c.id as cid FROM `cmf_portal_post` `p` INNER JOIN `cmf_portal_category` `c` ON `c`.`id`=`p`.`category_id` WHERE `p`.`delete_time` = '0' AND `post_status` = 1 AND `published_time` = 0 AND `user_id` = 85 LIMIT 100,10 [ RunTime:0.000975s ]