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.