I have a very good pc and I was wondering why does it takes so long to make a very simple request to one of my table.

My pc:

• i9 10900kf (10 cores)
• 64 GB ram
• 2TB NVME SSD
• RTX 3090 Ventus

1: My table has 531 732 rows (this is not a lot of rows) with 39 columns

I have the following indexes to my table:

• DisplayName
• TmiSentTs
• Username
• Channel
• DisplayName_TmiSentTs
• Username_TmiSentTs

When I make the following query, it takes 66.016 seconds to get a response:

SELECT from_unixtime(TmiSentTs/1000,'%Y/%m/%d  %H:%i:%s'),
  DisplayName, message 
FROM MY_TABLE 
WHERE displayname LIKE '