SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465841 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465841 [ RunTime:0.007079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (900182,500110,924027,299906,149404,348577,271579,777956,1020608,18214,758357,670854,306486,640802,492386,76486,950580,778474,514167,706745,250163,695697,388445,256750,376185,1004329,678407,724803,692170,818871,270593,478520,637442,367743,562451,342002,620264,409548,729400,859107,45768,586081,522027,345393,290270,668073,257355,375526,55233,24166,688712,909672,669981,934884,844070,638958,399998,854619,135152,1033522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]