using the fetch operator with parameter hash( 'remote_id', $some_param ) will cause very slow queries on a large system, can be 10s or more for a single query if there are 1M+ objects in the db.

creating an index on ezcontentobject_tree.remote_id stops the problem, allows the db usage to go up from overloaded to running cool once more.