SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547014 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547014 [ RunTime:0.003560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246988,755894,438780,937065,532984,125002,842804,419071,64297,583566,469120,70916,729617,450477,65302,481062,688224,940810,820560,445889,77616,758337,728127,21878,349986,665863,916860,159372,452828,5885,222612,183738,840483,82003,700894,329616,624117,253036,93797,783403,103779,102936,873634,497991,249078,678153,785620,918229,65837,413104,550964,183870,403737,333626,69900,1008643,805699,859532,1046662,797309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]