The explain syntax shows that the left/right joins multiply things to about 300k 'rows' examined.

Prominent software activist says Oracle must be prevented from taking control of MySQL, urges Europe's antitrust regulator to demand divestment ...