SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.003283s ]
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` = 9640 LIMIT 1 [ RunTime:0.002388s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 9640 [ RunTime:0.002345s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (12982,8697,5309,4187,6931,7916,4191,136,5743,5339,15789,11143,267,10575,10043,1222,10767,10631,13167,6896,1168,1887,11010,4909,2556,3765,14997,5649,12048,8571,6865,6325,5007,7439,12512,13079) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.003765s ]
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` = 'KP' AND `a`.`id` <> '9640' AND `a`.`switch` = '1' [ RunTime:0.001114s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 9640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 9640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]