[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000777s ]
[ SQL ] SELECT `cate`.`id`,`lang`.`name`,`cate`.`parent_id` FROM `cmf_portal_category` `cate` LEFT JOIN `cmf_portal_category_lang` `lang` ON `cate`.`id`=`lang`.`cate_id` WHERE `cate`.`id` = 9 AND `lang`.`lang` = 'zh-cn' AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000326s ]
[ SQL ] SELECT `cate`.`id`,`lang`.`name`,`cate`.`parent_id` FROM `cmf_portal_category` `cate` LEFT JOIN `cmf_portal_category_lang` `lang` ON `cate`.`id`=`lang`.`cate_id` WHERE `cate`.`id` = 1 AND `lang`.`lang` = 'zh-cn' AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000278s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000863s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` `post` LEFT JOIN `cmf_portal_category_post` `cat` ON `cat`.`post_id`=`post`.`id` LEFT JOIN `cmf_portal_category` `pcat` ON `cat`.`category_id`=`pcat`.`id` LEFT JOIN `cmf_area` `area` ON `area`.`id`=`post`.`area_id` WHERE `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND ( `cat`.`category_id` = 28 OR `pcat`.`parent_id` = 28 ) LIMIT 1 [ RunTime:0.153379s ]
[ SQL ] SELECT `post`.*,`cat`.`category_id`,area.name area_name FROM `cmf_portal_post` `post` LEFT JOIN `cmf_portal_category_post` `cat` ON `cat`.`post_id`=`post`.`id` LEFT JOIN `cmf_portal_category` `pcat` ON `cat`.`category_id`=`pcat`.`id` LEFT JOIN `cmf_area` `area` ON `area`.`id`=`post`.`area_id` WHERE `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND ( `cat`.`category_id` = 28 OR `pcat`.`parent_id` = 28 ) ORDER BY `post`.`is_top` DESC,`post`.`update_time` DESC,`post`.`id` DESC LIMIT 0,3 [ RunTime:0.153609s ]
[ SQL ] UPDATE `cmf_portal_post` `post` SET `post_hits`=`post_hits`+1 WHERE `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND `post`.`id` = '748' [ RunTime:0.009210s ]
[ SQL ] SELECT `post`.*,area.name area_name,`cate`.`category_id` FROM `cmf_portal_post` `post` LEFT JOIN `cmf_area` `area` ON `area`.`id`=`post`.`area_id` LEFT JOIN `cmf_portal_category_post` `cate` ON `cate`.`post_id`=`post`.`id` WHERE `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND `post`.`id` = '748' LIMIT 1 [ RunTime:0.000731s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` `post` LEFT JOIN `cmf_portal_category_post` `cat` ON `cat`.`post_id`=`post`.`id` LEFT JOIN `cmf_portal_category` `pcat` ON `cat`.`category_id`=`pcat`.`id` LEFT JOIN `cmf_area` `area` ON `area`.`id`=`post`.`area_id` WHERE `post`.`id` <> 748 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND ( `cat`.`category_id` = 9 OR `pcat`.`parent_id` = 9 ) LIMIT 1 [ RunTime:0.154030s ]
[ SQL ] SELECT `post`.*,`cat`.`category_id`,area.name area_name FROM `cmf_portal_post` `post` LEFT JOIN `cmf_portal_category_post` `cat` ON `cat`.`post_id`=`post`.`id` LEFT JOIN `cmf_portal_category` `pcat` ON `cat`.`category_id`=`pcat`.`id` LEFT JOIN `cmf_area` `area` ON `area`.`id`=`post`.`area_id` WHERE `post`.`id` <> 748 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND ( `cat`.`category_id` = 9 OR `pcat`.`parent_id` = 9 ) ORDER BY `post`.`is_top` DESC,`post`.`update_time` DESC,`post`.`id` DESC LIMIT 0,5 [ RunTime:0.182017s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` `post` LEFT JOIN `cmf_portal_category_post` `cat` ON `cat`.`post_id`=`post`.`id` LEFT JOIN `cmf_portal_category` `pcat` ON `cat`.`category_id`=`pcat`.`id` LEFT JOIN `cmf_area` `area` ON `area`.`id`=`post`.`area_id` WHERE `post`.`id` <> 748 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' LIMIT 1 [ RunTime:0.248507s ]
[ SQL ] SELECT `post`.*,`cat`.`category_id`,area.name area_name FROM `cmf_portal_post` `post` LEFT JOIN `cmf_portal_category_post` `cat` ON `cat`.`post_id`=`post`.`id` LEFT JOIN `cmf_portal_category` `pcat` ON `cat`.`category_id`=`pcat`.`id` LEFT JOIN `cmf_area` `area` ON `area`.`id`=`post`.`area_id` WHERE `post`.`id` <> 748 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' ORDER BY `post_hits` DESC LIMIT 0,5 [ RunTime:0.299449s ]