SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001206s ]
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` = 1214 LIMIT 1 [ RunTime:0.001192s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 1214 [ RunTime:0.003033s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (12201,2553,3191,7851,4983,7229,14441,4507,6121,5775,1725,1711,15663,12839,15249,15722,1366,3271,8550,408,13404,5501,7348,8865,11701,6738,7692,9941,5493,2854,4640,10560,7754,5472,14215,15351) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.001784s ]
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` = 'BME' AND `a`.`id` <> '1214' AND `a`.`switch` = '1' [ RunTime:0.002400s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 1214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 1214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]