Entity_id single value index sale_consign_change table, also have entity_id and created_on composite index
In table join query, why don't you go combination index, but single value index?

CodePudding user response:

Can take a look at this https://blog.csdn.net/Abysscarry/article/details/80792876, hope to help