[ DB ] CONNECT:[ UseTime:0.000327s ] mysql:host=127.0.0.1;port=3306;dbname=ftaef;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.000432s ]
[ 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.000283s ]
[ SQL ] SHOW COLUMNS FROM `cmf_score_day` [ RunTime:0.000273s ]
[ 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.000202s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000297s ]
[ 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.000400s ]
[ SQL ] SELECT `name`,`id` FROM `cmf_portal_category` WHERE `status` = 1 AND `parent_id` = 149 AND `delete_time` = 0 ORDER BY `list_order` ASC,`id` ASC LIMIT 30 [ RunTime:0.000376s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.000263s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_category_post` `cp` INNER JOIN `cmf_portal_post` `p` ON `cp`.`post_id`=`p`.`id` WHERE `status` = 1 AND `cp`.`category_id` IN ('252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','149') LIMIT 1 [ RunTime:0.000243s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_category_post` `cp` INNER JOIN `cmf_comment` `co` ON `co`.`object_id`=`cp`.`post_id` INNER JOIN `cmf_portal_post` `p` ON `cp`.`post_id`=`p`.`id` WHERE `cp`.`status` = 1 AND `co`.`delete_time` = 0 AND `cp`.`category_id` IN ('252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','149') LIMIT 1 [ RunTime:0.000246s ]
[ SQL ] SELECT COUNT(*) AS tp_count 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` IN ('252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','149') LIMIT 1 [ RunTime:0.000290s ]
[ 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` IN ('252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','149') ORDER BY `p`.`is_top` DESC,`p`.`published_time` DESC LIMIT 0,70 [ RunTime:0.000358s ]