SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50985 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50985 [ RunTime:0.002586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371259,162962,158461,795445,143723,411945,250740,262127,562194,834548,635450,59505,480450,972301,441143,356538,530766,637976,791358,309263,735526,923862,414260,129652,684365,730591,358286,529024,175855,593801,5431,167178,883500,870938,142173,399840,273953,224772,561214,920173,81118,887070,186946,342265,715837,538316,514316,483881,618722,1042560,660212,529718,734862,679633,383784,767113,627165,451636,354970,1015361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]