SHOW FULL COLUMNS FROM `topics` [ RunTime:0.000542s ]
SELECT * FROM `topics` WHERE ( `slug` = 't-2340c76046' ) AND `topics`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000375s ]
SELECT * FROM `topics` WHERE ( `id` = 1927 ) AND `topics`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000290s ]
SELECT `id` FROM `topics` WHERE ( ( `id` = 1927 OR `path` LIKE '/1927/%' ) AND `sub_status` = 1 AND `audit_status` = 1 AND `is_sensitive` = 0 ) AND `topics`.`delete_time` IS NULL [ RunTime:0.000317s ]
SHOW FULL COLUMNS FROM `posts` [ RunTime:0.000528s ]
SELECT `p`.* FROM `posts` `p` INNER JOIN `topics` `t` ON `t`.`id`=`p`.`topic_id` WHERE `p`.`audit_status` = '1' AND `p`.`is_sensitive` = '0' AND `t`.`sub_status` = '1' AND `t`.`audit_status` = '1' AND `t`.`is_sensitive` = '0' AND `t`.`delete_time` IS NULL AND `p`.`topic_id` IN ('1928','1927') ORDER BY `p`.`is_pinned` DESC,`p`.`create_time` DESC,`p`.`id` DESC LIMIT 30 [ RunTime:0.000687s ]