SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001464s ]
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` = 9675 LIMIT 1 [ RunTime:0.001533s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 9675 [ RunTime:0.001991s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (4144,2235,13536,5475,14416,13714,57,33,6936,13316,12481,8396,4362,12202,638,3581,6489,8351,4265,8235,7002,10962,4692,6411,13584,11762,3087,13730,1639,14909,9574,5362,9118,8528,15099,9478) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.002663s ]
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` = 'lieut' AND `a`.`id` <> '9675' AND `a`.`switch` = '1' [ RunTime:0.001397s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 9675 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 9675 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002856s ]