SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418864 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418864 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317099,712786,375746,301616,514316,895517,152865,309739,163979,746939,498920,976050,384952,932397,657078,729257,104589,993481,518058,511999,77480,637438,151607,680164,1048489,8689,301413,77034,810149,526175,582128,372049,140225,721304,560652,195134,165031,835875,358202,907870,174314,793163,693905,455556,426633,1023290,801137,119110,527969,429394,20098,775360,643261,325212,569494,266766,952057,251985,641598,212946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000833s ]