SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.002767s ]
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` = 8369 LIMIT 1 [ RunTime:0.000714s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 8369 [ RunTime:0.002353s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (4365,11818,9334,5899,4865,10479,8076,2496,1926,220,12872,14725,4758,8625,7215,7710,13152,211,14015,7152,3812,8841,2796,2679,10144,5000,1401,12665,10984,12877,15433,14692,4420,853,9797,6870) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.000970s ]
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` = 'LVI' AND `a`.`id` <> '8369' AND `a`.`switch` = '1' [ RunTime:0.002646s ]