SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.003334s ]
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` = 7888 LIMIT 1 [ RunTime:0.009676s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 7888 [ RunTime:0.003877s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (1072,12050,14735,12692,6991,4209,6309,8553,4106,8854,13108,15417,6887,15619,8114,10303,611,14690,5836,2179,12977,5662,6396,6035,4279,8666,1162,8929,10315,15131,10690,5609,12794,10339,13765,2186) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.082782s ]
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` = 'AFG' AND `a`.`id` <> '7888' AND `a`.`switch` = '1' [ RunTime:0.032718s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 7888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 7888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000837s ]