SHOW FULL COLUMNS FROM `tool_abbr` [ RunTime:0.001364s ]
UPDATE `tool_abbr` SET `views` = `views` + 1 WHERE `id` = 8010 [ RunTime:0.002022s ]
SELECT `id`,`abbr` FROM `tool_abbr` WHERE `id` IN (12157,12547,2071,1912,9501,2912,10654,925,6056,7678,6893,490,2052,12699,13815,7821,5577,14204,3903,13389,11913,8534,12529,6204,10167,695,10971,15201,10131,5204,11632,388,9828,15676,2265,10424) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.003421s ]
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` = 'BMP' AND `a`.`id` <> '8010' AND `a`.`switch` = '1' [ RunTime:0.001893s ]