SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470914 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470914 [ RunTime:0.003430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806791,280240,591107,1020655,616646,908405,858465,770220,788768,549012,260856,573670,824988,67228,926413,864750,296891,566070,316734,708876,74741,676457,286290,518775,491878,688272,831168,79176,596981,654069,331314,989624,288967,1040475,909026,977140,645028,97966,630194,964801,462501,67814,103443,163295,189504,57152,281890,198285,530518,790822,83862,377040,366296,723288,161461,114039,222513,932260,393646,515532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]