Alcohol ruins my workout, just kills all my energy. I've lifted drunk a few times and it's never gone well.
Working out while stoned is great though. The painkiller effect lets me push further, but it doesn't drain my energy like the booze.
The best pre-workout supplement is a strong energy drink and a few puffs of Cali Chronic.