SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311984 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311984 [ RunTime:0.001559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021839,338596,898496,233055,343337,587850,337523,268058,96891,199075,311374,654083,937779,344951,461314,750441,276752,546769,292388,22186,552389,849798,252508,970973,567949,447527,130853,16303,944843,42797,803728,42932,30646,817654,743464,82748,812659,161689,249410,1003735,834858,114715,857701,842579,910672,519823,1007790,608456,419024,345867,272576,740465,308007,704374,855871,291144,586561,779905,840413,810951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]