SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003858s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525671 LIMIT 1 [ RunTime:0.000855s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525671 [ RunTime:0.005864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34416,274833,363518,1007620,962583,847623,322584,349428,814801,501707,616765,144310,87587,1037289,524156,992356,604407,174228,241486,108954,1036263,626466,706204,163597,201831,921366,297624,351254,91808,524249,656764,210009,543091,568858,353263,702892,582549,703449,349008,918689,1037802,124427,653307,191379,463367,118239,750113,142173,387850,805419,123594,329002,876735,307155,283063,333566,864549,653970,597800,45253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]