SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001673s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457063 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457063 [ RunTime:0.002454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455800,1039944,261879,1015565,904708,682456,314779,151507,929643,952197,762736,238882,19274,325214,134593,931259,469792,646493,262472,452054,357441,473774,581192,30777,396754,584949,961288,992688,33941,893716,755718,491170,797568,330469,133923,593735,517003,130744,847902,351394,921761,857239,904950,981544,1028539,155733,468550,189692,209943,105945,836353,767039,717714,877466,671319,215268,820981,263535,1028424,801929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]