[ sql ] show columns from `cmf_portal_post` [ runtime:0.000505s ]
[ sql ] select count(*) as tp_count from ( select count(*) as think_count from `cmf_portal_post` `post` inner join `cmf_portal_category_post` `category_post` on `post`.`id`=`category_post`.`post_id` where `post`.`post_status` = 1 and `post`.`post_type` = 1 and `post`.`delete_time` = 0 and ( `category_post`.`category_id` = '3' ) and ( `post`.`published_time` > 0 and `post`.`published_time` < 1638359438 ) group by `post`.`id` ) `_group_count_` [ runtime:0.000563s ]
[ sql ] select post.*,min(category_post.category_id) as category_id from `cmf_portal_post` `post` inner join `cmf_portal_category_post` `category_post` on `post`.`id`=`category_post`.`post_id` where `post`.`post_status` = 1 and `post`.`post_type` = 1 and `post`.`delete_time` = 0 and ( `category_post`.`category_id` = '3' ) and ( `post`.`published_time` > 0 and `post`.`published_time` < 1638359438 ) group by `post`.`id` order by `post`.`published_time` desc limit 0,5 [ runtime:0.000771s ]