SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014422 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014422 [ RunTime:0.002653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633082,316347,742587,79145,83322,594311,555127,775998,26831,324935,48321,320125,789618,88024,240447,237950,820689,411059,12315,960679,312417,700501,17431,730849,836898,617099,287010,101133,517461,815237,1020191,891779,794661,61001,235172,591953,74944,681875,175950,73184,396581,543225,665400,942820,806620,173083,591590,261784,968969,219237,100461,342535,613686,431116,1036606,933664,193238,868491,825640,166565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]