SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480729 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480729 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411690,806013,545630,825969,480366,641224,156038,404615,47671,114371,94851,355448,751184,660587,247761,875616,1008134,463940,667012,244906,646432,100930,995395,526297,947631,485823,330955,133099,95204,494889,756932,318453,553065,846050,983037,859519,146284,434001,641454,561113,752764,1017078,296669,383148,736843,93636,230203,21338,810433,393390,986183,954491,725571,104494,57353,45655,545234,463766,1037114,993590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480729 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480729 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]