SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001162s ]
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` = 9301 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 9301 [ RunTime:0.001971s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (12167,5083,12652,15587,15236,10340,9889,6765,7045,397,15437,20,3163,5633,7698,15820,123,11397,760,8358,7988,5895,10189,4923,14426,176,8670,11036,9123,342,15549,10347,5094,9722,6047,5505) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.000855s ]
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` = 'BO' AND `a`.`id` <> '9301' AND `a`.`switch` = '1' [ RunTime:0.000620s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 9301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 9301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]