SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526022 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526022 [ RunTime:0.002223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889675,79054,955164,689874,974252,279456,910529,381314,683171,1033455,886764,958214,301421,945001,167250,859276,707568,733553,978039,76577,603148,974772,564857,1023109,392676,871371,745079,194474,772416,995177,41779,719286,533487,72955,858407,806172,993954,761448,764340,582637,1014760,496991,723915,270158,950940,1001786,149800,190292,270481,442286,62003,326883,221915,494669,932725,430639,142188,247843,837879,188087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]