SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80410 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80410 [ RunTime:0.004157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490711,872622,939316,565580,459329,495143,996333,365858,181427,419039,1047853,644001,934494,969444,403474,227946,694263,323270,549753,514933,931760,759819,518665,440099,427831,29174,362185,230643,210595,846009,750852,742085,669366,960744,936376,837729,357378,940167,67559,594560,260179,150216,898241,343630,636137,483541,518836,733191,622493,972348,147729,221201,572718,469895,621471,362836,473105,364314,1007011,100323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]