SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001360s ]
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` = 12890 LIMIT 1 [ RunTime:0.000694s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 12890 [ RunTime:0.002050s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (13516,12696,7359,15462,6669,11492,9095,13251,13262,6742,10972,7020,9537,6553,7892,160,14876,14228,7808,7836,3443,12802,1305,10407,5978,8360,4323,10026,13979,2064,12552,7823,15022,11139,5882,11569) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.006311s ]
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` = 'mfrs.' AND `a`.`id` <> '12890' AND `a`.`switch` = '1' [ RunTime:0.001055s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 12890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 12890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]