SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34280 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34280 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104303,134257,676863,987794,881002,744365,654378,563097,235100,238827,295053,544950,1008976,170762,308991,7498,55041,307180,167867,371441,136928,560797,191908,68928,179239,401994,696385,708232,950458,998870,870320,864455,515571,879588,562287,943160,473342,819125,36166,574951,580338,441752,874994,884237,48796,57342,614702,686184,1011854,247290,439750,320972,697041,651095,559356,954702,723221,67287,90921,261565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002338s ]