CodePudding user response:

Scheme could comment

CodePudding user response:

It is difficult to, I feel, unless a middle table,

CodePudding user response:

Main is too slow, performed to 20 + s,,, although is the report, but is to use egg pain

CodePudding user response:

You must slow ah, the SQL statement in the following way change
1. The from the first table to tms_orders
2. Put on the back in addition to the associated conditions, other conditions in the where behind
3. The corresponding index to see if all

If you have any questions, send the corresponding table structure information to me, I'll give you a try