[ DB ] CONNECT:[ UseTime:0.001420s ] mysql:host=rm-2ze5hwa9rkj084793.mysql.rds.aliyuncs.com;port=3306;dbname=jiangrenbaike;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `banmo_user` [ RunTime:0.002518s ]
[ SQL ] SELECT c.id as cid,`u`.`id`,`birthday`,`last_login_time`,`score`,`coin`,`balance`,`create_time`,`user_status`,`user_nickname`,`avatar`,`state`,`headimgurl`,`unionid`,`name`,`works`,`jid`,`published_time`,`c`.`status` FROM `banmo_user` `u` LEFT JOIN `banmo_jiangren_id` `c` ON `u`.`id`=`c`.`uid` WHERE `u`.`id` = '64' LIMIT 1 [ RunTime:0.001005s ]
[ SQL ] SHOW COLUMNS FROM `banmo_portal_news` [ RunTime:0.001670s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `banmo_portal_news` `post` INNER JOIN `banmo_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `post`.`relation` LIKE '%|124|%' AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1732361842 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.003430s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `banmo_portal_news` `post` INNER JOIN `banmo_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `post`.`relation` LIKE '%|124|%' AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1732361842 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,10 [ RunTime:0.006124s ]
