C-section questions!

Im a ftm worrying about having to get a c section. I know they numb you from the waste down. But do they give you any other type of medicine to like make you out of it or kinda loopy?! I dont want to be all there while there cutting me open. Its freaking me out! Help me out ladies!!