SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530618 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530618 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484582,754073,439180,953252,356951,4247,983902,836546,477322,913415,203871,519557,1001635,292730,734314,447408,960213,432046,950283,607276,739947,1001414,676543,888228,618336,177859,795729,38070,139994,592304,286471,417626,777799,484995,942092,318659,401315,583600,968547,676688,921680,131478,173272,787832,175964,664072,595804,421065,106946,411839,826137,760646,758628,917765,697433,822990,907839,108802,582278,777703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]