SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002923s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517089 LIMIT 1 [ RunTime:0.002255s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517089 [ RunTime:0.003729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410790,530686,514960,88236,116362,929288,57246,857383,980066,188089,578752,151993,1021694,889613,410957,106812,38470,598530,1012449,85040,303903,901030,128831,320541,420656,549574,873893,449665,726996,111793,853953,117890,733911,1032446,199451,882234,386392,556940,644458,94042,113481,285428,660408,369244,668901,885337,507150,453855,240612,505797,914435,1011510,256897,369908,856532,154580,57769,59579,282909,598099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000373s ]