Similarly to fucked silly, this saying is used after sexual intercourse describing how hard he or she was fucked
Girl 1: "last night I was fucked stupid, omg" Girl 2: "I'm dating your boyfriend."Girl 1: "what?"