SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.003942s ]
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` = 15784 LIMIT 1 [ RunTime:0.002412s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 15784 [ RunTime:0.004831s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (221,13973,11935,9112,9630,14603,8885,7127,13868,15428,2064,14023,14458,15645,7816,9029,13422,9488,13001,4446,8255,13853,2981,11927,10689,13840,12135,9481,12526,12988,8959,8890,224,13356,15355,13825) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.001525s ]
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` = 'SAP' AND `a`.`id` <> '15784' AND `a`.`switch` = '1' [ RunTime:0.001500s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 15784 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 15784 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]