[ SQL ] SHOW COLUMNS FROM `banmo_portal_post` [ RunTime:0.002126s ]
[ SQL ] SELECT `u`.`id`,`u`.`score`,`post`.* FROM `banmo_portal_post` `post` INNER JOIN `banmo_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` LEFT JOIN `banmo_user` `u` ON `post`.`user_id`=`u`.`id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 30 AND `relation`.`post_id` = 3049 LIMIT 1 [ RunTime:0.000911s ]
[ SQL ] SELECT `post`.* FROM `banmo_portal_post` `post` INNER JOIN `banmo_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` = 30 AND `relation`.`post_id` < 3049 AND ( `post`.`published_time` < 1732589386 and `post`.`published_time` > 0 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004031s ]
[ SQL ] SELECT `post`.* FROM `banmo_portal_post` `post` INNER JOIN `banmo_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` = 30 AND `relation`.`post_id` > 3049 AND ( `post`.`published_time` < 1732589386 and `post`.`published_time` > 0 ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.002460s ]
[ SQL ] UPDATE `banmo_portal_post` SET `post_hits` = `post_hits` + 1 WHERE `id` = 3049 [ RunTime:0.001856s ]
[ SQL ] SHOW COLUMNS FROM `banmo_portal_post_teacher` [ RunTime:0.001214s ]
[ SQL ] SELECT `teacher`.*,`post`.`post_title`,`post`.`name`,`post`.`thumbnail`,`post`.`published_time`,`post`.`post_status`,`post`.`post_excerpt` FROM `banmo_portal_post_teacher` `teacher` LEFT JOIN `banmo_portal_post` `post` ON `teacher`.`post_id`=`post`.`id` WHERE `teacher`.`delete_time` = 0 ORDER BY `teacher`.`sort` DESC [ RunTime:0.009550s ]
[ SQL ] SHOW COLUMNS FROM `banmo_portal_post_honor` [ RunTime:0.001649s ]
[ SQL ] SELECT `id`,`title`,`thumbnail` FROM `banmo_portal_post_honor` WHERE `post_id` = 3049 AND `delete_time` = 0 AND `post_status` >= 1 AND `type` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.020725s ]
[ SQL ] SELECT `id`,`title`,`thumbnail` FROM `banmo_portal_post_honor` WHERE `post_id` = 3049 AND `delete_time` = 0 AND `post_status` >= 1 AND `type` = 2 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.018844s ]
[ SQL ] SELECT `id`,`title`,`thumbnail` FROM `banmo_portal_post_honor` WHERE `post_id` = 3049 AND `delete_time` = 0 AND `post_status` >= 1 AND `type` = 4 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.015163s ]