SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45040 LIMIT 1 [ RunTime:0.001481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45040 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557666,255849,329714,567849,194864,852188,619323,119772,517903,203005,406377,454313,513895,998760,291079,234562,605381,11650,284381,442635,682476,559733,618786,120396,696164,270899,859889,235826,899269,465367,548705,902777,412121,514076,400052,52096,214069,933967,643305,58020,894909,544975,123123,460467,290048,156006,944195,56470,502051,228576,252090,201193,914360,27398,497169,567459,938912,161821,743007,17674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001132s ]