SHOW FULL COLUMNS FROM `tool_prescription` [ RunTime:0.001209s ]
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` = 2827 AND `switch` = 1 LIMIT 1 [ RunTime:0.000922s ]
UPDATE `tool_prescription` SET `views` = `views` + 1 WHERE `id` = 2827 [ RunTime:0.003804s ]
SELECT `id`,`title` FROM `tool_prescription` WHERE `id` < 2827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000659s ]
SELECT `id`,`title` FROM `tool_prescription` WHERE `id` > 2827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]