Lack of indexes produces hugely slow query

In two places we were doing a join that, for lack of indexes, was hugely slow.

In one place, the query can be replaced by a call to transation_node_get_translations().

The other - in a Views filter - requires adding two indexes:

CREATE INDEX node_tnid_language ON node(tnid,language);
CREATE INDEX node_language ON node(language);