SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801609 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801609 [ RunTime:0.002547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481474,153098,251534,760171,981346,438370,19972,466959,423595,898644,174188,496980,66611,585871,439605,811694,164077,279539,813160,870156,85837,832314,506975,541223,359825,832814,549804,799737,581796,812419,530162,702345,352870,844651,249300,594602,660076,780502,598798,77049,386897,208734,350377,879813,38625,826279,569842,915180,261101,431758,952933,426885,25687,14935,814327,923425,912708,802132,715647,140760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]