Welcome at HCM.
I have read complete details of your question.
It looks from your details that you are having prolapse disc in your lower spine which is irritating your nerves supplying to leg.
You should do following to have relief in this-
-Confirm your diagnosis by having a MRI on prescription from a orthopedic doctor.
-At initial stage with mild prolapse the treatment is complete bed rest
followed by exercises under supervision of an expert-
-If your pain is severe then it may need surgery to prevent death of nerve.
-You may take a good analgesic
-Avoid forward bending & lifting heavy weights.
Hope this all will help you.
With best wishes.