Yep. Shooting pain is EXACTLY what it is. Perfect description. It's intense!
I have done this to compensate. Sometimes i'll take 20-30 seconds. It helps but the underlying problem/pain is still present.
Well I believe you have found the solution..get away from the barbell work. Not forcing my wrists into that position pretty much alieviated the problem for me