SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457713 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457713 [ RunTime:0.002354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690568,653060,524534,146999,720228,902073,527508,30688,784177,381379,428433,244929,352049,665146,958335,819686,19415,408718,602057,270930,476856,848420,284149,657901,13354,793809,945377,237687,478943,96639,355234,366697,11538,39607,640447,13140,274364,223073,236937,744141,133069,168758,54870,248587,54222,681498,853913,377982,708090,737627,404650,446136,16073,728638,420568,823357,491011,313921,221129,540261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]