I have an endoscopy tomorrow but have a fear of needles and do not want to be knocked out. Is it really that bad and is the spray? Some people say its quick others ages?