as an experiment, i'd be curious whether removing the negations would meaningfully change the performance. i know it's required for the detachment in your business logic, but if we can isolate the performance problem to a single part of your schema, we know exactly what we have to work around.