SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538692 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538692 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47484,337409,205691,271955,887533,464520,706281,386792,931543,520756,892310,600006,466293,339138,857744,3540,860198,357514,1005032,423588,342436,821625,884464,819476,464627,883332,796883,112625,823899,417818,544393,1015684,899116,41070,595328,237432,610894,219084,378981,775567,21533,334249,957421,386204,421693,942777,500283,567964,525643,505559,779155,653358,384275,961272,889030,710777,403634,566188,737933,681091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]