I'd say it refers to the speaker's exhaustion from excessive drinking.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.
EyeSeeYouYea, I guess it conveys a negative feeling, but I haven't been able to find any reference in dictionaries.I suppose it doesn't fall under any of the standard definitions of the word. Sometimes "worked" means defeated/beaten or deceived/tricked in one way or another in casual speech: