for left kidney
pain you should get routine urine test & culture sensitivity test ,Plain X-ray
kidney ureter bladder
region (KUB area),sonography to find the cause .
Treatment depends on the cause .If it is infection only simply a course of antibiotics is sufficient& if due to stone line of management will change.
Kidney don't play any role in libido,forget it.Sexual behavior reflects one`s personalty.