Thank you for uploading your metadata.
I think you have a lot of “orphan postmeta data”. That is, you have deleted many posts, pages, or products and their metadata — prices, vendors, etc — was not cleaned up. Try using a plugin like Advanced Database Cleaner to remove the orphan data.
Check that your persistent object cache is working correctly.
WPML isn’t fast.
It looks like you have set up your MariaDB server to use an “innodb_buffer_pool_size” of 3GiB. But you have 32GiB of physical RAM. The buffer pool is surprisingly small for a server of your size. Read this for more information. https://dba.stackexchange.com/questions/27328/how-large-should-be-mysql-innodb-buffer-pool-size
And you have a innodb_sort_buffer_size of 1MiB. Your can probably quadruple that, to 4MiB.
But these are entirely guesses on my part. I dare not give precise advice about server configuration without understanding a lot more about your setup.
It is safe to say your server needs to be examined for efficient resource allocation, and some things probably can adjusted to make it faster. And, it’s possible you don’t need such a large server.
