A multi-ingredient medication called Fioricet combines caffeine with non-aspirin pain treatment, barbiturate sedation, and other analgesic effects. This non-narcotic pain reliever and relaxant is typically prescribed to those who have tension headaches or migraines, both of which can be brought on by muscular spasms in the shoulders and neck.