SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417231 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417231 [ RunTime:0.002405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733691,145345,136311,105400,204180,259367,934166,700024,296788,698452,399504,334191,117746,290598,654360,695156,772736,232708,661886,419033,648779,807209,1009644,692075,681889,787148,151295,232559,573681,622582,660237,122507,591801,621093,1013557,942913,393526,853851,327963,292556,97530,823414,965914,539697,645489,602839,67511,367474,188321,18166,1044171,231123,29652,743696,335923,938914,120567,990072,279365,266091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]