SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001182s ]
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` = 8696 LIMIT 1 [ RunTime:0.003135s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 8696 [ RunTime:0.001840s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (789,13356,2889,4749,10632,1069,12396,5009,2488,310,2242,9590,12437,1251,9551,11643,2210,3330,14272,15,15604,14955,3217,4802,8821,5487,13086,10447,7715,2535,10114,12702,7985,596,12793,4603) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.012721s ]
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` = 'TE' AND `a`.`id` <> '8696' AND `a`.`switch` = '1' [ RunTime:0.002025s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 8696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 8696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002177s ]