SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383018 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383018 [ RunTime:0.004659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933859,854717,274167,997866,695330,165254,121231,728245,289890,101053,9192,431262,616060,11341,967813,46500,29667,438309,909085,665313,159621,695808,406574,552844,322440,21058,614656,392366,332488,1005515,979114,291656,330921,931468,1010191,178160,245374,446651,500518,47859,285785,567788,620316,530634,275944,819191,820943,271384,213692,86803,302097,130626,28649,798981,423746,206474,307342,878602,435502,458419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]