SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.009295s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 4001 [ RunTime:0.005730s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (15725,15457,11468,8214,2450,11444,3698,6720,6291,2977,8037,10177,12982,947,11936,12894,7148,9258,15019,10025,10805,1593,5506,15399,2519,14920,11731,6763,4283,6741,10743,294,470,10213,7360,4668) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.048650s ]
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' AND `a`.`id` <> '4001' AND `a`.`switch` = '1' [ RunTime:0.010508s ]