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` = 464846 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464846 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552334,1013279,835776,678517,714920,444699,421002,542923,775887,763683,199454,17821,943254,460865,251899,479763,293379,571220,1032943,942468,150629,869339,680626,350308,612993,114494,206358,25072,865578,34109,242884,869511,989441,824225,849702,893056,196721,386386,57560,487796,426355,914022,207924,561924,817755,1009422,865740,101577,631427,964548,472357,801939,299098,271480,544879,1047687,586194,863022,594861,597121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]