SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 353840 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 353840 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342661,581662,821018,87758,436008,904928,440109,487842,294267,164355,283227,673859,124967,997365,671908,340687,364582,1035803,664109,463866,235641,610366,286566,903128,323656,138178,982627,913442,1026118,405254,548035,902092,185141,522279,419039,72146,604270,217212,650924,861418,136806,533727,569822,310326,657752,442215,282349,923520,228411,68553,19177,21090,68378,338708,603946,674597,37850,734668,378702,208121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 353840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 353840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]