SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.003340s ]
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` = 5027 LIMIT 1 [ RunTime:0.005171s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 5027 [ RunTime:0.009671s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (11767,14175,8956,9242,13181,14630,3267,8706,12087,10149,95,13120,13455,589,10442,943,10178,55,665,7103,4413,4048,4094,12773,3994,8079,468,8093,2359,439,5478,2367,12684,2802,13940,3242) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.024631s ]
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` = 'AAB' AND `a`.`id` <> '5027' AND `a`.`switch` = '1' [ RunTime:0.008266s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 5027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 5027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]