mysql 加了orderby 查询速度超级慢怎么办
SELECT
DISTINCT c.uniqueid,
r.`name`,
r.CustomerPhone,
r.TocallerPhone,
r.bound,
r.Elapsed,
r.LastTime,
s.sourceName,
c.uniqueid,
c.recordingfile,
c.calldate
FROM
cdr c
JOIN recordInfo r ON c.uniqueid = r.niqueid
LEFT JOIN Source s ON r.callerIdNum = s.MobileNum
WHERE
1 = 1
AND c.disposition != 'NO ANSWER'
LIMIT 0, 10
SELECT
count(DISTINCT uniqueid)
FROM
cdr c
JOIN recordInfo r ON c.uniqueid = r.niqueid
LEFT JOIN Source s ON r.callerIdNum = s.MobileNum
WHERE
1 = 1
AND c.disposition != 'NO ANSWER'