SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601543 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601543 [ RunTime:0.002225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149428,752034,1027685,321635,183025,973614,345632,107390,201695,2998,499964,673146,649505,761962,116572,574304,375715,92428,320468,738325,467367,163616,678364,747471,1012691,858160,945202,468765,833444,556287,595952,711529,328015,1038018,395052,436000,286348,173790,920056,1040686,4048,110869,211660,114236,205059,114657,57090,592602,378194,568751,571371,34007,369724,937085,535563,586887,208265,826184,322609,746601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]