Fetching details from the dictionary...

to become numb; to go to sleep (e.g. a limb)
to get an electric shock; to tingle (from an electric shock)
to be excited; to be titillated; to be mesmerized; to be enthralled
正座をしていたら足が痺れて立てなくなった。
My legs went numb from sitting seiza and I couldn't stand.
彼のギターの演奏に痺れて感動してしまった。
I was thrilled and moved by his guitar performance.
冷たい水に手を入れると痺れるような感覚がある。
Putting your hands in cold water gives a numbing sensation.