SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001144s ]
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` = 12042 LIMIT 1 [ RunTime:0.001387s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 12042 [ RunTime:0.003189s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (8086,2994,1743,6671,6492,1485,8470,3767,15008,8648,1790,2824,12257,4469,9178,21,1138,5542,7973,4351,5203,4165,15555,1460,833,2557,6755,1603,12580,10822,12865,12013,2704,15437,15345,4917) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.001699s ]
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&T' AND `a`.`id` <> '12042' AND `a`.`switch` = '1' [ RunTime:0.000441s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` < 12042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` > 12042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]