SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008722s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568721 LIMIT 1 [ RunTime:0.002367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568721 [ RunTime:0.017292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435639,45801,449438,778477,486884,163924,818392,957584,420063,501897,751444,862085,514011,8380,370668,82017,677230,498265,76104,927907,425807,910297,447444,873816,491580,341229,571325,413852,326987,54776,839049,265363,698718,113070,67469,760706,443741,908961,531713,826995,881141,792705,900942,736607,930127,852102,1000289,677881,694621,365727,389681,149811,47231,53586,545699,346965,5351,519886,1014384,571468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002282s ]