[ DB ] CONNECT:[ UseTime:0.000315s ] mysql:host=127.0.0.1;port=3306;dbname=ftaef_snmykj_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.000426s ]
[ 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.000285s ]
[ SQL ] SHOW COLUMNS FROM `cmf_score_day` [ RunTime:0.000256s ]
[ 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` = 1765900800 ORDER BY `s`.`score` DESC LIMIT 11 [ RunTime:0.000203s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000307s ]
[ 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.000450s ]
[ SQL ] SELECT `name`,`id` FROM `cmf_portal_category` WHERE `status` = 1 AND `parent_id` = 1 AND `delete_time` = 0 ORDER BY `list_order` ASC,`id` ASC LIMIT 30 [ RunTime:0.000387s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.000248s ]
[ 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 ('6','7','8','9','20','21','24','26','65','130','138','141','142','947','948','949','950','1013','1') LIMIT 1 [ RunTime:0.000539s ]
[ 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 ('6','7','8','9','20','21','24','26','65','130','138','141','142','947','948','949','950','1013','1') LIMIT 1 [ RunTime:0.000589s ]
[ 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 ('6','7','8','9','20','21','24','26','65','130','138','141','142','947','948','949','950','1013','1') LIMIT 1 [ RunTime:0.001273s ]
[ 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 ('6','7','8','9','20','21','24','26','65','130','138','141','142','947','948','949','950','1013','1') ORDER BY `p`.`is_top` DESC,`p`.`published_time` DESC LIMIT 70,70 [ RunTime:0.001663s ]
