SHOW FULL COLUMNS FROM `maoyu_problem` [ RunTime:0.002238s ]
SELECT `id`,`title`,`details`,`attention_num`,`click_num`,`publish_time` FROM `maoyu_problem` WHERE `id` = 247 AND `status` = 1 AND `audit_status` = 2 AND `publish_time` < 1750266623 LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`title` FROM `maoyu_problem` WHERE `rec` = 2 AND `status` = 1 AND `audit_status` = 2 AND `publish_time` < 1750266623 LIMIT 0,5 [ RunTime:0.000519s ]
SELECT `id`,`title` FROM `maoyu_problem` WHERE `rec` = 2 AND `status` = 1 AND `audit_status` = 2 AND `publish_time` < 1750266623 ORDER BY `click_num` DESC LIMIT 0,5 [ RunTime:0.000554s ]
SHOW FULL COLUMNS FROM `maoyu_answer` [ RunTime:0.002090s ]
SELECT COUNT(*) AS think_count FROM `maoyu_answer` `a` LEFT JOIN `maoyu_user` `b` ON `a`.`uid`=`b`.`id` WHERE `a`.`pid` = '247' AND `a`.`status` = '1' AND `a`.`audit_status` = '2' AND `a`.`audit_time` < '1750266623' [ RunTime:0.000524s ]
UPDATE `maoyu_problem` SET `click_num` = `click_num` + 1 WHERE `id` = 247 [ RunTime:0.002668s ]
我要回答
