Что покажет такой запрос? explain SELECT cdrs.id, cdrs.direction, cdrs.calldate, cdrs.did, cdrs.src, cdrs.dst, cdrs.disposition, cdrs.dispositionid, cdrs.mood, cdrs.duration, cdrs.status, agents.firstname, agents.lastname, cdrs.clid, cdrs.contactid, IFNULL(dispositions.color, ''), IFNULL(contacts.firstname, ''), IFNULL(contacts.lastname, ''), IFNULL(contacts.address, ''), IFNULL(contacts.city,

Question

Что покажет такой запрос? explain SELECT cdrs.id, cdrs.direction, cdrs.calldate, cdrs.did, cdrs.src, cdrs.dst, cdrs.disposition, cdrs.dispositionid, cdrs.mood, cdrs.duration, cdrs.status, agents.firstname, agents.lastname, cdrs.clid, cdrs.contactid, IFNULL(dispositions.color, ''), IFNULL(contacts.firstname, ''), IFNULL(contacts.lastname, ''), IFNULL(contacts.address, ''), IFNULL(contacts.city,

''),
IFNULL(contacts.state, ''),
IFNULL(contacts.postalcode, ''),
IFNULL(campaigns.name, ''),
IFNULL(contacts.status, ''),
cdrs.clientid,
clients.name,
cdrs.callid,
cdrs.voicemailid
FROM cdrs USE INDEX (cdrs_answerdate)
straight_join clients ON clients.id = cdrs.clientid
JOIN dids ON dids.id = cdrs.didid
LEFT JOIN users AS agents ON agents.id = cdrs.agentid
LEFT JOIN dispositions ON dispositions.id = cdrs.dispositionid
LEFT JOIN contacts ON contacts.id = cdrs.contactid
LEFT JOIN campaigns ON campaigns.id = cdrs.campaignid
WHERE 1=1
AND clients.resellerid = 2
AND (cdrs.calldate >= '2021-08-24 15:59:59.999')
AND (cdrs.calldate <= '2021-08-31 15:59:59.999')
order by id desc
limit 25;