[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000609s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` `portal_post` LEFT JOIN `cmf_portal_category_post` `portal_category_post` ON `portal_category_post`.`post_id`=`portal_post`.`id` WHERE `portal_post`.`delete_time` = 0 AND `portal_post`.`post_status` = 1 AND `category_id` = 107 AND `status` = 1 [ RunTime:0.002652s ]
[ SQL ] SELECT `portal_post`.`id`,`portal_post`.`post_status`,`portal_post`.`post_hits`,`portal_post`.`create_time`,`portal_post`.`published_time`,`portal_post`.`post_title`,`portal_post`.`post_keywords`,`portal_post`.`post_excerpt`,`portal_post`.`post_source`,`portal_post`.`thumbnail`,`portal_post`.`post_content`,`portal_post`.`more`,`portal_post`.`sync_id`,`portal_post`.`author`,`portal_post`.`outside`,`portal_category_post`.`post_id`,`portal_category_post`.`category_id`,`portal_category_post`.`list_order`,`portal_category_post`.`status` FROM `cmf_portal_post` `portal_post` LEFT JOIN `cmf_portal_category_post` `portal_category_post` ON `portal_category_post`.`post_id`=`portal_post`.`id` WHERE `portal_post`.`delete_time` = 0 AND `portal_post`.`post_status` = 1 AND `category_id` = 107 AND `status` = 1 ORDER BY `is_top` DESC,`portal_post`.`id` DESC LIMIT 1056,32 [ RunTime:0.007295s ]
[ SQL ] SELECT `portal_post`.`id`,`portal_post`.`post_status`,`portal_post`.`post_hits`,`portal_post`.`create_time`,`portal_post`.`published_time`,`portal_post`.`post_title`,`portal_post`.`post_keywords`,`portal_post`.`post_excerpt`,`portal_post`.`post_source`,`portal_post`.`thumbnail`,`portal_post`.`post_content`,`portal_post`.`more`,`portal_post`.`sync_id`,`portal_post`.`author`,`portal_post`.`outside`,`portal_category_post`.`post_id`,`portal_category_post`.`category_id`,`portal_category_post`.`list_order`,`portal_category_post`.`status`,`portal_category`.`parent_id` FROM `cmf_portal_post` `portal_post` LEFT JOIN `cmf_portal_category_post` `portal_category_post` ON `portal_category_post`.`post_id`=`portal_post`.`id` LEFT JOIN `cmf_portal_category` `portal_category` ON `portal_category`.`id`=`portal_category_post`.`category_id` WHERE `portal_post`.`delete_time` = 0 AND `portal_post`.`post_status` = 1 AND `category_id` = 1 AND `portal_category_post`.`status` = 1 ORDER BY `is_top` DESC,`portal_post`.`published_time` DESC LIMIT 11 [ RunTime:0.010193s ]
[ SQL ] SELECT `portal_post`.`id`,`portal_post`.`post_status`,`portal_post`.`post_hits`,`portal_post`.`create_time`,`portal_post`.`published_time`,`portal_post`.`post_title`,`portal_post`.`post_keywords`,`portal_post`.`post_excerpt`,`portal_post`.`post_source`,`portal_post`.`thumbnail`,`portal_post`.`post_content`,`portal_post`.`more`,`portal_post`.`sync_id`,`portal_post`.`author`,`portal_post`.`outside`,`portal_category_post`.`post_id`,`portal_category_post`.`category_id`,`portal_category_post`.`list_order`,`portal_category_post`.`status`,`portal_category`.`parent_id` FROM `cmf_portal_post` `portal_post` LEFT JOIN `cmf_portal_category_post` `portal_category_post` ON `portal_category_post`.`post_id`=`portal_post`.`id` LEFT JOIN `cmf_portal_category` `portal_category` ON `portal_category`.`id`=`portal_category_post`.`category_id` WHERE `portal_post`.`delete_time` = 0 AND `portal_post`.`post_status` = 1 AND `category_id` = 3 AND `portal_category_post`.`status` = 1 ORDER BY `is_top` DESC,`portal_post`.`published_time` DESC LIMIT 11 [ RunTime:0.009701s ]
[ SQL ] SELECT `portal_post`.`id`,`portal_post`.`post_status`,`portal_post`.`post_hits`,`portal_post`.`create_time`,`portal_post`.`published_time`,`portal_post`.`post_title`,`portal_post`.`post_keywords`,`portal_post`.`post_excerpt`,`portal_post`.`post_source`,`portal_post`.`thumbnail`,`portal_post`.`post_content`,`portal_post`.`more`,`portal_post`.`sync_id`,`portal_post`.`author`,`portal_post`.`outside`,`portal_category_post`.`post_id`,`portal_category_post`.`category_id`,`portal_category_post`.`list_order`,`portal_category_post`.`status`,`portal_category`.`parent_id` FROM `cmf_portal_post` `portal_post` LEFT JOIN `cmf_portal_category_post` `portal_category_post` ON `portal_category_post`.`post_id`=`portal_post`.`id` LEFT JOIN `cmf_portal_category` `portal_category` ON `portal_category`.`id`=`portal_category_post`.`category_id` WHERE `portal_post`.`delete_time` = 0 AND `portal_post`.`post_status` = 1 AND `category_id` IN ('107','108','109') AND `portal_category_post`.`status` = '1' ORDER BY `is_top` DESC,`portal_post`.`published_time` DESC LIMIT 6 [ RunTime:0.014971s ]
