SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341085 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341085 [ RunTime:0.004128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109325,70408,129724,876737,968870,370467,78317,524955,763153,66340,168312,719724,28992,233563,716746,772990,120612,1021553,684099,979467,1036067,258338,918524,290,895634,333769,991019,391230,538817,518561,833239,905173,845919,597231,306131,365694,727171,206988,161160,877229,629581,733715,868338,1031058,284522,512913,620208,53931,568894,281417,554170,429342,697533,555784,505295,808558,764544,889971,851651,97202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]