[ SQL ] SELECT `post`.* FROM `ly_portal_post` `post` INNER JOIN `ly_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '9' AND `relation`.`post_id` < '8097' AND ( `post`.`published_time` < '1743997384' and `post`.`published_time` > '0' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.188342s ]
[ SQL ] SELECT `post`.* FROM `ly_portal_post` `post` INNER JOIN `ly_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = '9' AND `relation`.`post_id` > '8097' AND ( `post`.`published_time` < '1743997385' and `post`.`published_time` > '0' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.006738s ]
[ SQL ] SHOW COLUMNS FROM `ly_comment` [ RunTime:0.002068s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ly_comment` `c` LEFT JOIN `ly_user` `u` ON `c`.`user_id`=`u`.`id` LEFT JOIN `ly_user` `ut` ON `c`.`to_user_id`=`ut`.`id` WHERE ( c.delete_time=0 and c.status=1 and object_id=8097 ) LIMIT 1 [ RunTime:0.002082s ]
[ SQL ] SELECT `c`.*,u.user_nickname as username,ut.user_nickname as to_username,`u`.`avatar` FROM `ly_comment` `c` LEFT JOIN `ly_user` `u` ON `c`.`user_id`=`u`.`id` LEFT JOIN `ly_user` `ut` ON `c`.`to_user_id`=`ut`.`id` WHERE ( c.delete_time=0 and c.status=1 and object_id=8097 ) ORDER BY `c`.`create_time` DESC LIMIT 0,15 [ RunTime:0.000405s ]
全部评论0