[ DB ] CONNECT:[ UseTime:0.000324s ] mysql:host=127.0.0.1;port=3306;dbname=ftaef;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.000480s ]
[ SQL ] SELECT `goods_img`,`goods_name`,`shop_price`,`goods_id` FROM `cmf_goods` WHERE `is_recommend` = 1 AND `is_on_sale` = 1 AND `is_delete` = 0 ORDER BY `goods_id` DESC LIMIT 7 [ RunTime:0.000309s ]
[ SQL ] SHOW COLUMNS FROM `cmf_score_day` [ RunTime:0.000359s ]
[ SQL ] SELECT `s`.*,`u`.`user_nickname` FROM `cmf_score_day` `s` LEFT JOIN `cmf_user` `u` ON `u`.`id`=`s`.`user_id` WHERE `s`.`add_time` = 1762876800 ORDER BY `s`.`score` DESC LIMIT 11 [ RunTime:0.000230s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000423s ]
[ SQL ] SELECT `name`,`id`,`isindex`,`is_top` FROM `cmf_portal_category` WHERE `parent_id` = 0 AND `delete_time` = 0 ORDER BY `list_order` ASC [ RunTime:0.000568s ]
[ SQL ] SELECT `name`,`id` FROM `cmf_portal_category` WHERE `status` = 1 AND `parent_id` = 155 AND `delete_time` = 0 ORDER BY `list_order` ASC,`id` ASC LIMIT 30 [ RunTime:0.000578s ]
[ SQL ] SELECT `cp`.`post_id`,u.user_nickname as username,p.published_time as addtime,p.post_title as article_name,p.post_hits as post_hits,p.comment_count as comment_count,c.name as cate_name,`p`.`icon`,`p`.`more`,`p`.`post_excerpt`,`p`.`author` FROM `cmf_portal_category_post` `cp` INNER JOIN `cmf_portal_category` `c` ON `cp`.`category_id`=`c`.`id` INNER JOIN `cmf_portal_post` `p` ON `cp`.`post_id`=`p`.`id` INNER JOIN `cmf_user` `u` ON `u`.`id`=`p`.`user_id` WHERE `p`.`delete_time` = 0 AND `cp`.`status` = 1 AND `p`.`post_status` = 1 AND `cp`.`category_id` = '195' ORDER BY `p`.`is_top` DESC,`p`.`published_time` DESC LIMIT 0,70 [ RunTime:0.000495s ]