SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512327 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512327 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532610,480208,439326,501499,760970,634140,256183,961021,442884,955148,921429,278123,424905,426143,796685,419101,995189,121926,688330,738151,22638,337712,178302,586908,449341,409453,301957,953455,438415,438089,295408,311503,237711,414496,495125,872113,949764,353699,919973,493246,106364,933358,437458,729920,378808,84377,724195,544332,878624,419659,509025,391148,635747,864954,1030394,155726,294735,216716,328784,688874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]