SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201615 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201615 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32726,606464,857444,1044289,609269,519215,297127,748515,337742,275387,420881,619798,191123,502077,842639,929020,730248,977310,755071,912988,111675,357924,569542,58114,955209,479220,636456,266122,612240,524522,118643,468871,296485,223638,122336,407024,218090,510188,291486,1005556,517193,6201,741898,162142,42922,338576,659013,151113,207295,236237,330545,797819,403498,399429,565597,1011693,312335,106869,345194,573633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]