SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150073,689171,780715,65106,788859,32559,824787,756605,777822,188620,498644,259177,39442,169560,712058,61722,292481,179849,787121,327074,54676,821932,729410,670344,474985,526132,322518,143919,752982,38998,716744,309096,520567,721460,519395,889891,132580,304209,566081,906479,899555,945315,614864,848914,239850,266948,542864,373938,681831,853224,951407,25850,358290,371495,484683,123965,965478,980841,406645,1002028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]