SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407589 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407589 [ RunTime:0.002959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574021,556387,663488,459425,346736,618987,835304,1002122,200750,536573,361246,325144,208203,744503,162511,508072,108076,448664,972626,654280,575929,476557,823891,133959,198550,474864,601718,478994,908801,735662,265987,562407,54041,966080,252424,339684,113663,998804,614117,200869,900767,933710,899810,1005533,982406,837418,1045831,746812,714240,129858,914233,591700,895677,624413,272301,406551,730347,318475,623220,896368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]