stoneheaded

adj.

Displaying signs of slowed thinking and impaired memory attributable to alcohol.

Quintine confidently tried to pay for their drinks with a library card, feeling incredibly stoneheaded.

Source: Wiktionary