Making one query is faster than making 2,600

Originally posted on mastodon.technology.

Today's lesson in MariaDB query optimization: making one query is faster than making 2,600+:

https://gitlab.com/mailman/mailman/-/merge_requests/857

https://phabricator.wikimedia.org/T282348