Index Help

[jaymc]

I have a query that is taking 2+ seconds to execute

 

So, I really need to add some indexes to speed things up

 

Attached is the query and the EXPLAIN

 

Can anyone give any suggestions on fields I should index?

 

explain
SELECT ts.id, ts.originator, ts.mobile, ts.message, DATE_FORMAT(ts.date, '%b %e at %l:%i%p') date, ts.status, tc.name, tc.numTotalMessages, tc.numSentMessages, DATE_FORMAT(tc.date, '%b %e at %l:%i%p') date, tr.report
FROM media_1.texts_sent ts
INNER JOIN media_1.text_campaign tc ON ts.campaignID = tc.id

LEFT JOIN( SELECT report, textID FROM media_1.texts_report ORDER BY date DESC ) AS tr ON ts.id = tr.textID

WHERE ts.campaignID = '6' AND ts.userID = '1'
GROUP BY ts.id
ORDER BY ts.date DESC
LIMIT 0,50

 

[attachment deleted by admin]

[fenway]

I'm not sure I understand why you have a group by with so many fields in the select list.

 

Is is faster if you drop the group by / order by?