wp_commentmeta table does not have a composite index
(comment_id,meta_key) by default? I believe it's the only useful index for that table, am I wrong?
Instead, it has two strange indexes:
(meta_key). I don't have an idea how to use them.
The same thing about