Torrente, el brazo tonto de la ley (1998) on Netflix

Torrente is a lazy, rude, drunkard, sexist, racist, extreme-right-wing Madrid cop; a despicable character who only cares about himself. He lives in a decrepit slum with his wheelchair-bound father, whom he treats quite badly. One day, a new family of neighbours move in, and the sexy younger daughter, Amparito, catches his eye, so he becomes a friend of Rafi, her nerdy brother, to get closer to her. At the same time, he discovers that a band of drug traffickers are operating in a nearby chinese restaurant; he knows that if he cracks this case, it could make him regain the status he lost within the police department; but the only people he can count on to help him are Rafi and his equally nerdy friends.