SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481953 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481953 [ RunTime:0.002784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410792,571064,150552,555487,367940,1010365,372920,308552,497869,917454,680956,1012840,876718,821046,252959,701385,71100,503801,1016133,751963,532940,428620,1033114,16030,848762,313859,461360,121219,535703,532538,388843,894041,6151,91083,318419,548689,739920,697755,183709,658778,196636,368355,218399,702631,33300,830805,858816,301467,762552,719881,736918,898537,601314,442589,624962,636554,847296,957800,594800,22888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]