[SQL] SHOW COLUMNS FROM ' cmf_portal_post ' [RunTime:0 . 0.000815s ]
[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` = '12' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1728599053 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.001077s ]
[ SQL ] SELECT post.*,min(category_post.从' 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` = '12' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1728599053 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,5 [ RunTime:0.001203s ]
