SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001278s ]
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` = 12047 LIMIT 1 [ RunTime:0.000959s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 12047 [ RunTime:0.003352s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (15393,13175,9240,6121,6181,10298,9339,9826,5213,13311,6444,11469,2557,1906,13138,15327,7540,601,229,3249,7219,5307,2794,14852,911,6556,5206,7195,8164,4406,6435,4439,11149,9934,4665,13116) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.003922s ]
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` = 'A.F.' AND `a`.`id` <> '12047' AND `a`.`switch` = '1' [ RunTime:0.001307s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 12047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 12047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]