某些表条件下MySQL / MariaDB查询速度慢的可能原因

I am having a strange issue with a slow query under certain conditions: I have made a few tests and was able to isolate the issue to one single table called I am having a strange issue with a slow query u