Hi, Sunny0537, and welcome to Psych Central! I have been catherized a number of times, and it doesn't hurt. I think they have some sort of lubricant on the tube or something like that.
Maybe you can ask the doctor when you go back to see him/her about the results, and if you can see what they found. Folks need to be lying down and still while such an ultrasound is taking place.
Of course, we all tend to think the very worst about diagnoses. But in all likelihood, it won't be anything all that serious. And if there's a problem, then the doctors will know and get you treated. Okay?