SHOW FULL COLUMNS FROM `tool_prescription` [ RunTime:0.018091s ]
SELECT id,title,content,category_id,(select name FROM tool_category where tool_category.id=tool_prescription.category_id)as Cname FROM `tool_prescription` WHERE `id` = 652 AND `switch` = 1 LIMIT 1 [ RunTime:0.015822s ]
UPDATE `tool_prescription` SET `views` = `views` + 1 WHERE `id` = 652 [ RunTime:0.015624s ]
SELECT `id`,`title` FROM `tool_prescription` WHERE `switch` = 1 ORDER BY `views` DESC LIMIT 24 [ RunTime:0.144341s ]
SELECT `id`,`title` FROM `tool_prescription` WHERE `id` < 652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`title` FROM `tool_prescription` WHERE `id` > 652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]