Hi there,
That looks like a standard query WordPress makes to display a list of posts. It’s a heavy query because:
1. There’s a bunch of individual IDs specified.
2. It’s also querying a meta key/value
I wonder if it’s a specific list you’ve created?
