DOES IT HURT?

It is more generally considered a nuisance more than a pain.
If you want to avoid as much pain as possible, try to eat and be rested before getting a tattoo.
Assuming alcohol or drugs is highly unsuggested, as it may cause disease, more bleeding, and difficulties in the execution of the tattoo.