SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52001 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52001 [ RunTime:0.002609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164729,634402,464647,469527,879441,952994,608016,409931,565675,140839,373403,308334,408002,697460,658973,581439,916127,537901,830464,294719,795898,242458,791512,800383,520151,584542,151521,116101,673938,948237,159353,210527,957489,336525,427417,730779,649841,325106,183709,222280,96229,762133,421976,990981,659390,514647,53984,692998,373734,231551,223647,749816,352294,923054,166904,920772,981758,552172,59925,270467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]