(Most probably my experience will be milder compared to others so...)
Mine would be that time when I was a kid. A 3 inch glass shard (yeah, I remembered the size) went through in the bottom of my foot, right where the arch is. The shard went in deep enough for the shard to be barely visible outside. Weirdly enough, it wasn't the pain that made me panic but the fast-flowing blood that came out of the wound.
I was so scared that for some reason I went into the bathroom to wash it with water and tried to flick my foot in attempt to discard the shard. The shard didn't budge but the walls of the bathroom were splattered with blood.
A few minutes later, my mother, who was in the other side of the house, noticed what happened and that's when I finally felt the pain, which was the "uncomfortable" type of pain. Since the shard suddenly became too painful, I pleaded my parents to take the shard out first before they bring me to the hospital and so my father restrained me in his arms while my mother took out the shard using a plier. The shard was yank out, I screamed and writhed in pain, and even more blood gushed out.
Afterward, I got treated in the hospital, my mother cleaned the blood-stained bathroom, and I couldn't walk or move my foot without feeling an intense sharp pain the wound for several weeks. That's pretty much it, it's admittedly not that much but it was a pretty harrowing experience for a young child.
Messages