[ SQL ] SHOW COLUMNS FROM `cmf_hook_plugin` [ RunTime:0.000745s ]
[ SQL ] SELECT `hook`,`plugin` FROM `cmf_hook_plugin` WHERE `status` = 1 AND `hook` IN ('app_begin','module_init','action_begin','view_filter','app_end','log_write','response_end','admin_init','home_init','send_mobile_verification_code','body_start','before_head_end','footer_start','before_footer','before_footer_end','before_body_end','left_sidebar_start','before_left_sidebar_end','right_sidebar_start','before_right_sidebar_end','comment','guestbook','switch_theme','after_content','before_content','log_write_done','switch_admin_theme','captcha_image','app_dispatch') ORDER BY `list_order` ASC [ RunTime:0.000318s ]
[ SQL ] SHOW COLUMNS FROM `cmf_advert` [ RunTime:0.000866s ]
[ SQL ] SELECT * FROM `cmf_advert` WHERE `status` = 1 AND `parent_id` = 0 AND ( FIND_IN_SET('2',local) ) ORDER BY `list_order` ASC [ RunTime:0.000323s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.001078s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` `a` INNER JOIN `cmf_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `cmf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `b`.`category_id`=`c`.`id` LEFT JOIN `cmf_portal_city_post` `d` ON `a`.`id`=`d`.`post_id` LEFT JOIN `cmf_portal_city` `e` ON `e`.`id`=`d`.`city_id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND `a`.`post_status` = 1 AND ( `b`.`category_id` = 2 AND `c`.`type` = 1 AND `c`.`status` = 1 AND `a`.`post_type` = 1 ) [ RunTime:0.032960s ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`published_time`,`a`.`post_city`,`a`.`post_xiehui`,`a`.`post_source`,`a`.`thumbnail`,`a`.`post_author`,c.parent_id as parent_category_id,`a`.`more`,`a`.`post_hits`,`a`.`post_like`,`b`.`category_id`,`e`.`city` FROM `cmf_portal_post` `a` INNER JOIN `cmf_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `cmf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `b`.`category_id`=`c`.`id` LEFT JOIN `cmf_portal_city_post` `d` ON `a`.`id`=`d`.`post_id` LEFT JOIN `cmf_portal_city` `e` ON `e`.`id`=`d`.`city_id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND `a`.`post_status` = 1 AND ( `b`.`category_id` = 2 AND `c`.`type` = 1 AND `c`.`status` = 1 AND `a`.`post_type` = 1 ) ORDER BY `a`.`is_top` DESC,`a`.`published_time` DESC,`a`.`update_time` DESC LIMIT 0,10 [ RunTime:0.015510s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `type` = 1 AND `delete_time` = 0 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000212s ]
[ SQL ] SELECT * FROM `cmf_advert` WHERE `status` = 1 AND `parent_id` = 0 AND ( FIND_IN_SET('2',local) ) ORDER BY `list_order` ASC [ RunTime:0.000308s ]