SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001401s ]
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` = 3481 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 3481 [ RunTime:0.002353s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (15225,1016,11428,10432,1592,13894,3688,14982,8928,5034,11685,5878,12132,10120,15154,4840,12954,15192,13405,11811,1941,2245,9324,673,13393,2064,12372,13809,5312,11586,1726,11175,8494,91,12775,9808) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.001467s ]
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` = 'BBB' AND `a`.`id` <> '3481' AND `a`.`switch` = '1' [ RunTime:0.000928s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 3481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000894s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 3481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]