|
The first rule whenever such simple query gets slow, this is my huntch, is to make a key on cols in question, that is only on order,ticket_id,visible which is not current case.
Try that, and see if it helps.
If explain shows that it does not use that new key of yours, you can force use of your key via sql command, google for that, doh I'm not certain that that works.
|