[ DB ] CONNECT:[ UseTime:0.001210s ] mysql:host=localhost;port=3306;dbname=hirossz_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_product_post` [ RunTime:0.011853s ]
[ SQL ] SELECT * FROM `cmf_product_post` WHERE `post_status` = 1 AND `delete_time` = 0 AND `post_type` = 2 AND `id` NOT IN (769,770,771,766,772) [ RunTime:0.000863s ]
[ SQL ] SHOW COLUMNS FROM `cmf_news_post` [ RunTime:0.010766s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_news_post` `a` INNER JOIN `cmf_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `cmf_news_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= '0' AND `a`.`delete_time` = '0' AND `a`.`post_status` = '1' AND `a`.`post_type` = '1' AND `b`.`category_id` = '11' [ RunTime:0.001301s ]
[ SQL ] SELECT `a`.*,b.id AS post_category_id,`b`.`list_order`,`b`.`category_id`,`u`.`user_login`,`u`.`user_nickname`,`u`.`user_email` FROM `cmf_news_post` `a` INNER JOIN `cmf_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `cmf_news_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= '0' AND `a`.`delete_time` = '0' AND `a`.`post_status` = '1' AND `a`.`post_type` = '1' AND `b`.`category_id` = '11' ORDER BY `a`.`id` DESC LIMIT 0,10 [ RunTime:0.001151s ]