SHOW FULL COLUMNS FROM `tool_prescription` [ RunTime:0.001252s ]
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` = 42 AND `switch` = 1 LIMIT 1 [ RunTime:0.001786s ]
UPDATE `tool_prescription` SET `views` = `views` + 1 WHERE `id` = 42 [ RunTime:0.001927s ]
SELECT `id`,`title` FROM `tool_prescription` WHERE `id` < 42 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001102s ]
SELECT `id`,`title` FROM `tool_prescription` WHERE `id` > 42 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001865s ]