What version of Neo4j are you running? I am only guessing at your schema based on what's in the query.
Query Pattern
A couple of thoughts:
I see there's index seek in the explain, which is good, assuming it's on add.add and tr.id. If not, add.
As...
I am assuming that you're looking for the combination of the nodes above that would be the union of properties based on a common name property into one node with a distinct name. Always an interesting question on how to combine things in a graph when...