I did the same explain and found 7 idx's used. You only have 4, ie
I don't think you have all foreign keys defined.

You are right, I have omitted one constraint on the lineitem table. Thanks.