SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201601 LIMIT 1 [ RunTime:0.001510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201601 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35373,927461,684189,510336,698051,342118,325373,319095,1025010,913755,304164,550672,49267,190161,340516,668788,777430,912944,436375,933567,901354,897827,951293,561248,262588,355005,601371,4831,912042,67333,859545,812908,596841,854072,402208,818723,536834,865228,41012,842315,774405,847778,327313,398648,268821,102071,217415,231447,422858,477909,783956,147635,851783,62618,576060,571703,974431,522660,692962,825907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]