[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000530s ]
[ 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` = 3 AND `status` = 1 [ RunTime:0.003189s ]
[ 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` = 3 AND `status` = 1 ORDER BY `is_top` DESC,`portal_post`.`published_time` DESC LIMIT 0,30 [ RunTime:0.008692s ]
[ SQL ] SHOW COLUMNS FROM `cmf_slide_item` [ RunTime:0.000620s ]
[ SQL ] SELECT `slide_item`.`id`,`slide_item`.`slide_id`,`slide_item`.`status`,`slide_item`.`list_order`,`slide_item`.`title`,`slide_item`.`image`,`slide_item`.`url`,`slide_item`.`target`,`slide_item`.`description`,`slide_item`.`content`,`slide_item`.`more`,`slide`.`name`,`slide`.`remark` FROM `cmf_slide_item` `slide_item` LEFT JOIN `cmf_slide` `slide` ON `slide`.`id`=`slide_item`.`slide_id` WHERE `slide`.`delete_time` = 0 AND `name` = '本埠消息' ORDER BY `slide_item`.`list_order` ASC,`slide_item`.`id` ASC LIMIT 4 [ RunTime:0.000632s ]
[ 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.009870s ]
[ 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.010729s ]
[ 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.014581s ]
