SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305151 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305151 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47627,926315,161402,522285,610105,313567,286860,529006,758583,546406,491850,93704,711272,972050,169208,23304,1036905,362020,408099,722457,54398,798275,332251,122634,459620,181549,124520,296669,479294,454998,27132,811374,582629,608188,679316,160219,168340,60115,659372,342781,70737,206898,198099,957246,1004878,988435,423506,983195,732625,432018,68622,705491,540898,594023,70882,399609,989505,122981,582148,870282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]