[ DB ] CONNECT:[ UseTime:0.000485s ] mysql:host=127.0.0.1;port=3306;dbname=www_zhuwaizhijia;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000897s ]
[ 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.000360s ]
[ 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.000317s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000927s ]
[ 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.151586s ]
[ 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.163898s ]
[ 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.284778s ]
[ 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.278595s ]
[ 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.127965s ]
[ 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.233186s ]
[ 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.155515s ]
[ 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.220266s ]
[ 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.131621s ]
[ 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.138115s ]
[ 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.153539s ]
[ 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.175139s ]
[ 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.122179s ]
[ 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.137290s ]
[ 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.166691s ]
[ 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.173684s ]
[ 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.154451s ]
[ 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.175828s ]
[ 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.152417s ]
[ 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.166495s ]
[ 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.211939s ]
[ 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.152546s ]
[ 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.151308s ]
[ 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.171127s ]
[ 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.121187s ]
[ 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.160025s ]
