SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001053s ]
SELECT (SELECT name FROM tool_category WHERE tool_category.id = tool_abbr.category_id) AS Cname,id,abbr,full,prc,meaning,category_id FROM `tool_abbr` WHERE `switch` = 1 AND `id` = 9000 LIMIT 1 [ RunTime:0.001945s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 9000 [ RunTime:0.004631s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (10848,12689,3358,2942,3887,4565,4233,8914,7937,2728,15584,2899,7232,11494,7445,6971,14795,5636,8333,3551,2267,1166,10385,13592,3498,7920,13344,10769,8598,10539,341,6821,4936,6341,6249,1981) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.006657s ]
SELECT `a`.`id`,`a`.`abbr`,`a`.`full`,`a`.`prc`,b.id as cid,`b`.`name` FROM `tool_abbr` `a` INNER JOIN `tool_category` `b` ON `a`.`category_id`=`b`.`id` WHERE `a`.`abbr` = 'AAH' AND `a`.`id` <> '9000' AND `a`.`switch` = '1' [ RunTime:0.001051s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 9000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001141s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 9000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001511s ]