SELECT * FROM `dai_forum_board` `fb` WHERE `fb`.`id` = '904' AND `fb`.`status` = '1' LIMIT 1 [ RunTime:0.000599s ]
SELECT fp.id AS id,ptb.board_id AS board_id,fp.title AS title,`fp`.`content`,fp.post_type AS post_type,fp.post_status AS post_status,fp.is_essence AS is_essence,fp.is_top AS is_top,fp.view_num AS view_num,fp.reply_num AS reply_num,fp.last_reply_time AS last_reply_time,fp.create_time AS create_time,pu.username AS author_name,fbd.name AS board_name 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 `ptb`.`board_id` = '904' AND `fp`.`status` = '1' ORDER BY `fp`.`is_top` DESC,`fp`.`last_reply_time` DESC LIMIT 0,20 [ RunTime:0.000989s ]
SELECT COUNT(*) AS think_count FROM `dai_forum_post` `fp` INNER JOIN `dai_forum_post_to_board` `ptb` ON `fp`.`id`=`ptb`.`post_id` WHERE `ptb`.`board_id` = '904' AND `fp`.`status` = '1' LIMIT 1 [ RunTime:0.000469s ]
