SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001256s ]
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` = 12199 LIMIT 1 [ RunTime:0.000660s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 12199 [ RunTime:0.001912s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (15505,2600,10208,11700,2433,5922,13836,7747,12498,1204,6706,13538,11519,3038,10306,11112,4807,9486,5945,1214,12837,2343,10574,9666,8723,3022,12330,3359,15071,11695,7121,15710,1680,9285,11809,804) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.000930s ]
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` = 'B/E' AND `a`.`id` <> '12199' AND `a`.`switch` = '1' [ RunTime:0.001075s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 12199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 12199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]