[ 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.000883s ]
[ 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.000389s ]
[ 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` = 0 AND `lang`.`lang` = 'zh-cn' AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000334s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000911s ]
[ 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.140901s ]
[ 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.161242s ]
[ 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` = 2 OR `pcat`.`parent_id` = 2 ) LIMIT 1 [ RunTime:0.141161s ]
[ 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` = 2 OR `pcat`.`parent_id` = 2 ) ORDER BY `post`.`is_top` DESC,`post`.`update_time` DESC,`post`.`id` DESC LIMIT 0,5 [ RunTime:0.163971s ]
[ 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`.`thumbnail` <> '' AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND ( `cat`.`category_id` = 2 OR `pcat`.`parent_id` = 2 ) LIMIT 1 [ RunTime:0.113424s ]
[ 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`.`thumbnail` <> '' AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND ( `cat`.`category_id` = 2 OR `pcat`.`parent_id` = 2 ) ORDER BY `post`.`is_top` DESC,`post`.`update_time` DESC,`post`.`id` DESC LIMIT 0,1 [ RunTime:0.132484s ]
[ 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` = 7 OR `pcat`.`parent_id` = 7 ) LIMIT 1 [ RunTime:0.140661s ]
[ 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` = 7 OR `pcat`.`parent_id` = 7 ) ORDER BY `post`.`is_top` DESC,`post`.`update_time` DESC,`post`.`id` DESC LIMIT 0,5 [ RunTime:0.161128s ]
[ 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`.`thumbnail` <> '' AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND ( `cat`.`category_id` = 7 OR `pcat`.`parent_id` = 7 ) LIMIT 1 [ RunTime:0.115096s ]
[ 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`.`thumbnail` <> '' AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND ( `cat`.`category_id` = 7 OR `pcat`.`parent_id` = 7 ) ORDER BY `post`.`is_top` DESC,`post`.`update_time` DESC,`post`.`id` DESC LIMIT 0,1 [ RunTime:0.132063s ]
[ 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` = 8 OR `pcat`.`parent_id` = 8 ) LIMIT 1 [ RunTime:0.140857s ]
[ 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` = 8 OR `pcat`.`parent_id` = 8 ) ORDER BY `post`.`is_top` DESC,`post`.`update_time` DESC,`post`.`id` DESC LIMIT 0,5 [ RunTime:0.187743s ]
[ 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`.`thumbnail` <> '' AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND ( `cat`.`category_id` = 8 OR `pcat`.`parent_id` = 8 ) LIMIT 1 [ RunTime:0.131598s ]
[ 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`.`thumbnail` <> '' AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND ( `cat`.`category_id` = 8 OR `pcat`.`parent_id` = 8 ) ORDER BY `post`.`is_top` DESC,`post`.`update_time` DESC,`post`.`id` DESC LIMIT 0,1 [ RunTime:0.130074s ]
[ 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` = 9 OR `pcat`.`parent_id` = 9 ) LIMIT 1 [ RunTime:0.140591s ]
[ 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` = 9 OR `pcat`.`parent_id` = 9 ) ORDER BY `post`.`is_top` DESC,`post`.`update_time` DESC,`post`.`id` DESC LIMIT 0,5 [ RunTime:0.158803s ]
[ 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`.`thumbnail` <> '' 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.115445s ]
[ 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`.`thumbnail` <> '' 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,1 [ RunTime:0.130186s ]
[ 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.140726s ]
[ 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,5 [ RunTime:0.161316s ]
[ 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`.`thumbnail` <> '' AND `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.113547s ]
[ 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`.`thumbnail` <> '' AND `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,1 [ RunTime:0.179908s ]
[ 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` = 11 OR `pcat`.`parent_id` = 11 ) LIMIT 1 [ RunTime:0.187426s ]
[ 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` = 11 OR `pcat`.`parent_id` = 11 ) ORDER BY `post`.`is_top` DESC,`post`.`update_time` DESC,`post`.`id` DESC LIMIT 0,5 [ RunTime:0.159291s ]
[ 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`.`thumbnail` <> '' AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND ( `cat`.`category_id` = 11 OR `pcat`.`parent_id` = 11 ) LIMIT 1 [ RunTime:0.116628s ]
[ 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`.`thumbnail` <> '' AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`lang` = 'zh-cn' AND ( `cat`.`category_id` = 11 OR `pcat`.`parent_id` = 11 ) ORDER BY `post`.`is_top` DESC,`post`.`update_time` DESC,`post`.`id` DESC LIMIT 0,1 [ RunTime:0.128637s ]