[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `cmf_portal_post` `a` LEFT JOIN `cmf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND ( `b`.`category_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24) AND `a`.`post_type` = 1 ) GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000936s ]
[ SQL ] SELECT `a`.* FROM `cmf_portal_post` `a` LEFT JOIN `cmf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND ( `b`.`category_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24) AND `a`.`post_type` = 1 ) GROUP BY `a`.`id` ORDER BY `is_top` DESC,`update_time` DESC LIMIT 45,9 [ RunTime:0.007785s ]