[ DB ] CONNECT:[ UseTime:0.000424s ] mysql:host=127.0.0.1;port=3306;dbname=www_zhuwaizhijia;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000886s ]
[ 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` = '10' AND `lang`.`lang` = 'zh-cn' AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000632s ]
[ 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.000276s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000955s ]
[ 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.135049s ]
[ 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.153130s ]
[ 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` = '10' OR `pcat`.`parent_id` = '10' ) LIMIT 1 [ RunTime:0.134509s ]
[ 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` = '10' OR `pcat`.`parent_id` = '10' ) ORDER BY `post`.`is_top` DESC,`post`.`update_time` DESC,`post`.`id` DESC LIMIT 0,10 [ RunTime:0.151683s ]