[ SQL ] SELECT `post`.*,`user`.`user_login`,`user`.`user_nickname`,`user`.`user_email`,`category_post`.`category_id` FROM `cmf_portal_post` `post` INNER JOIN `cmf_user` `user` ON `post`.`user_id`=`user`.`id` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1614228125 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '2' AND `post`.`create_time` >= 0 ORDER BY `post`.`create_time` DESC LIMIT 0,10 [ RunTime:0.015625s ]