SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001754s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541058 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541058 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340345,883325,986161,796346,355736,989825,343649,1021594,325645,600107,753964,451620,825345,116255,956150,911217,871053,727169,826717,651700,846666,247288,563514,838035,1046612,1029091,560970,202578,989865,318259,848884,578948,468003,90881,649551,596981,194656,195140,109973,21296,47531,823184,940358,1022138,182095,713544,921876,80475,741067,710083,1012042,621063,415004,792239,859747,510468,593293,553440,542521,243287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]