I believe tequila shooters are much more effective
The pain might still be there, but it has to filter threw a pretty thick fog to reach the brain after a few shots.
As for the sand, I can not speak for any others, but my first encounter with the fire-y stuff, I had some nasty after effects that took quite some time to clear up. the next time I brushed across the stuff, it was: "OS! not again!" I saw some white coral sand nearby, and started rubbing, just to releave the burn, but soon I realized that the burn had disappeared completely.
Over the years since I have had a few more brushes with the painful stuff, and all have been resolved by the sand trick, except for the one time surf deposited me in the shallows on top of both fire coral and spiny sea urchins, in a very poorly planned and executed exit on the Wild side of Bonaire. No amount of rubbing was gonna help that time. Cuts, burns and spines! Oh my.
Beer was the only remedy, oh and for the wounds themselves, alcohol and antibiotics.