Does washing an apple under the faucet actually clean it?

My mom always says to wash fruits and vegetables under the faucet, but besides from washing a few specks of dirt off, does it really do anything? If there is bacteria from people at the grocery store touching it, what will water even do to that?