SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018934 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018934 [ RunTime:0.003058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367668,53429,258265,797955,392578,935036,760389,519862,472565,345260,909474,29887,423633,640137,1935,899851,183540,480551,849469,1026589,555769,119659,298508,410333,711984,162996,359769,897092,93825,487670,702040,995866,463534,66090,13058,517681,853772,201124,247440,947260,707277,350118,270614,265221,231309,600701,685089,683037,972595,580833,631429,772731,876270,541976,247013,694361,181056,1020205,195049,598734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018934 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018934 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]