SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001990s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341953 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341953 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799963,169808,202744,527546,468620,296356,63010,1024916,644870,458264,902861,138756,935311,213342,226153,169057,748702,527422,38986,553052,490870,686487,32021,995672,871358,218014,634512,358287,603981,197848,792248,1031455,943210,638735,494439,764954,918143,602742,357901,771112,711261,576407,914800,371493,38376,256501,301643,484394,552401,427942,777794,901518,556095,794502,856239,759099,690128,468484,84516,363328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]