SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001979s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 2017 LIMIT 1 [ RunTime:0.002132s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2017 [ RunTime:0.008262s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116008,61319,164334,79458,508066,891233,831083,329897,654708,228294,966465,824686,83173,133568,643794,935411,1006703,624603,711246,659164,765519,89066,93663,350958,171349,964248,773910,1001178,348662,445436,369229,355715,202071,204346,909982,976085,497541,171935,741383,1036310,58132,141316,898888,996578,954865,1025363,550745,74603,921253,361239,1020959,179661,785046,9529,800907,47491,999831,469177,772950,29312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002112s ]