Cool shower and plain aloe vera gel for sunburn
Spent an afternoon outside without enough sunscreen and my shoulders and arms were red, hot and sore. Took a cool (not cold) shower, patted dry, and smoothed plain aloe vera gel on while the skin was still a bit damp. Kept reapplying whenever it felt uncomfortable and drank extra water. The stinging calmed down within a day and the redness mostly faded after three days. Use gel without alcohol, try a small patch first, and don't pop any blisters. Big blistered areas, fever or chills mean you should see a doctor.