[ DB ] CONNECT:[ UseTime:0.000391s ] mysql:host=127.0.0.1;port=3306;dbname=www_zhuwaizhijia;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000919s ]
[ 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.000354s ]
[ 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.000314s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000881s ]
[ 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.000306s ]
[ 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.000431s ]
[ 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.140117s ]
[ 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.159122s ]
[ 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.000324s ]
[ 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.130223s ]
[ 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.000357s ]
[ 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.160867s ]
[ 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.000312s ]
[ 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.000366s ]
[ 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.000298s ]
[ 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.157193s ]
[ 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.112281s ]
[ 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.127655s ]
[ 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.000308s ]
[ 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.157872s ]
[ 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.112150s ]
[ 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.128537s ]
[ 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.000327s ]
[ 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.156559s ]
[ 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.112106s ]
[ 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.126653s ]
[ 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.140643s ]
[ 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.156809s ]
[ 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.000340s ]
[ 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.130489s ]
