I had one done a few years ago too and it definitely didn't hurt me at all. I have no memory of the procedure - apparently you're not properly unconcious, but enough that you are totally unaware. And afterwards the worst thing was that I was very flatulent. I ate a sandwich within minutes of waking up and was fine - and usually I'm a mess after anaesthetics.

Since then my MIL and a friend have had them and neither had any pain either.

You will be fine, please try not to worry.