SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 272012 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 272012 [ RunTime:0.006523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481444,985326,210334,3101,568737,890634,815651,945754,291360,814105,527756,166607,878078,443614,929465,169785,293764,921050,1013892,937545,569483,900655,55285,750981,398037,357432,228432,623306,194022,27106,459199,942021,780861,606623,836317,875092,1004187,707642,725896,901936,539665,989140,3886,784070,684346,651824,394337,945343,865575,482563,791943,96629,335476,618600,565103,509370,588968,231791,1013482,821019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 272012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 272012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]