Having ingested too much, or just the right amount of GHB
and/or purple hooter
so that one flails about on the ground, resembling a fish out of water.
"Tina was all fishing out in a G-hole
and when the paramedics arrived, she was face down in the river."