[ SQL ] SHOW COLUMNS FROM `cf_portal_post` [ RunTime:0.001953s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `cf_portal_post` `a` INNER JOIN `cf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`post_status` = 1 AND `a`.`delete_time` = 0 AND ( `a`.`published_time` < '1669758263' AND `a`.`published_time` > '0' ) AND `b`.`category_id` IN (2,3,6) GROUP BY `b`.`post_id` ) `_group_count_` LIMIT 1 [ RunTime:0.000728s ]
[ SQL ] SELECT `a`.`id`,`a`.`post_keywords`,`a`.`post_title`,`a`.`thumbnail`,`a`.`more`,`a`.`post_excerpt`,`a`.`post_content`,`a`.`published_time`,`b`.`category_id` FROM `cf_portal_post` `a` INNER JOIN `cf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`post_status` = 1 AND `a`.`delete_time` = 0 AND ( `a`.`published_time` < '1669758263' AND `a`.`published_time` > '0' ) AND `b`.`category_id` IN (2,3,6) GROUP BY `b`.`post_id` ORDER BY `a`.`is_top` DESC,`b`.`list_order` DESC,`a`.`published_time` DESC LIMIT 12,6 [ RunTime:0.003785s ]
