SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042635 LIMIT 1 [ RunTime:0.001536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042635 [ RunTime:0.007235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365538,511020,524737,882689,298760,1013986,960708,932214,607150,220911,315233,962116,393793,457820,727696,347092,368151,872673,502347,1002946,637789,39444,644092,75755,889946,259710,988007,75492,349531,355057,961249,655904,193160,238307,152100,892492,167052,288726,556331,727203,39312,767153,651530,357037,580851,937689,342589,1000883,429392,750101,539909,996596,58952,324401,458620,516353,181138,181086,108092,977419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042635 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042635 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]