The shortest path possible to the information is all that is required.
This normally means just a primary ID, with a sequential sequence in it.
MySql indexing is not for storing information; it is for reaching the line that exists in a table.
By storing lots of information in MySQL Indexing you make it top heavy and so a slower site……This is as it can’t reach the information, without first checking each index for if the information exists…….
Reach the line through primary index first, so it sees all information in one go….If you add a second index it also has to check this then, before reaching information, so then slower.