SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043017 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043017 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436269,930601,600160,584557,789521,891176,481727,144664,999293,726598,542520,272425,412013,162001,767045,575064,746732,544924,106407,47428,501347,892617,1029932,302266,247828,904593,1005047,600032,42955,655502,706537,1008862,829070,21835,769212,422512,810554,20687,222992,280757,1010112,137831,596879,811507,631140,378128,102562,213066,401508,268482,923264,33605,77405,926601,1009902,843889,959572,987530,474282,791460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002695s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]