SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430019 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430019 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939899,351251,750884,231313,878590,105398,542849,497984,455752,961360,401683,632640,348122,744061,831642,96294,279733,937400,996937,545012,365627,762325,125810,196942,177303,563005,1035345,608865,259174,1026197,521649,105329,311224,716493,468429,840981,169398,9968,428700,392662,996228,126203,679742,648528,702451,963368,156700,919554,648644,915414,954706,901456,415757,710667,128301,457844,357859,322940,634631,307789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]