Performance - filter order and has_child filter

Indeed, very often for such queries, the bottleneck is due to the time it takes to join parents with children. There is nothing that can really be improved besides modeling data in such a way that parent/child relations are not necessary.