run a show command and you'll see what it's up to.

Joins aren't usually the problem - table scans are. Joins are simple (particularly when the indexes are properly used), because with a good optimizer, the indexes are joined before the entire row is gotten.