Vanity(1991)

Randy West is a hard-boiled private dick whose been having some hard times lately. The jobs haven't been rolling in like they used to, and it's getting harder and harder to pay the bills. Luckily, though a high-paying gig just presented itself, although something tells Randy he may live to regret taking it. It seems that there's an especially powerful aphrodisiac which has gone missing, and a mysterious somebody is willing to pay big money to get it back. So Randy heads out on the trail of the looted aphrodisiac determined to get it back. Along the way, perhaps predictably, he encounters a series of shady characters who have nothing on their minds but drawing Randy into sleazy, hyper kinky encounters.