SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037131 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037131 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481895,544252,83128,209644,677953,184778,411810,830600,624398,159336,922402,745906,888392,164933,348550,599261,409968,595114,405532,676317,217127,522947,445716,227100,641406,998471,862609,995268,18888,728486,481046,651834,441149,220875,730415,286946,807135,428848,420518,55762,158051,921371,133027,767281,693139,243702,196824,266769,640750,724083,628135,598979,883607,837644,337063,1043859,1000786,3901,582733,771313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]