SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336548 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336548 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181530,380925,75828,512884,978643,136150,513313,864241,1027147,952218,182282,287787,209773,134052,200692,30432,386108,895839,869587,355704,228568,789890,1035391,704019,955168,583172,523581,990265,977805,92771,215368,821400,858614,1047003,899155,851852,983267,911047,861928,862736,360968,559598,945463,497235,863301,518742,733585,5214,205394,22828,501687,931171,997676,10847,343117,1042124,238078,88716,1006486,542725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]