SELECT fp.id AS id,ptb.board_id AS board_id,fp.user_id AS user_id,fp.title AS title,`fp`.`content`,fp.post_type AS post_type,fp.post_status AS post_status,`fp`.`extra_fields`,fp.is_essence AS is_essence,fp.is_top AS is_top,`fp`.`is_locked`,fp.view_num AS view_num,fp.reply_num AS reply_num,`fp`.`like_num`,`fp`.`accepted_reply_id`,fp.create_time AS create_time,pu.username AS author_name,fbd.name AS board_name,`fp`.`seo_meta_title`,`fp`.`seo_meta_keywords`,`fp`.`seo_meta_description`,fp.status AS status FROM `dai_forum_post` `fp` INNER JOIN `dai_forum_post_to_board` `ptb` ON `fp`.`id`=`ptb`.`post_id` LEFT JOIN `dai_portal_user` `pu` ON `fp`.`user_id`=`pu`.`id` LEFT JOIN `dai_forum_board` `fbd` ON `fp`.`board_id`=`fbd`.`id` WHERE `fp`.`id` = '911' LIMIT 1 [ RunTime:0.001027s ]
UPDATE `dai_forum_post` SET `view_num` = `view_num` + 1 WHERE `id` = 911 [ RunTime:0.001970s ]
SELECT `fr`.*,pu.username AS author_name,pu.is_official AS is_official FROM `dai_forum_reply` `fr` LEFT JOIN `dai_portal_user` `pu` ON `fr`.`user_id`=`pu`.`id` WHERE `fr`.`post_id` = '911' AND `fr`.`status` = '1' ORDER BY `fr`.`floor` ASC LIMIT 0,50 [ RunTime:0.000598s ]
