# Time: 110420 8:52:13
# User@Host: ipn03_boki[ipn03_boki] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 622227
SELECT SUM( x.billsec) AS log_c, SUM(x.billsec) AS c_s
FROM `log_call` x
JOIN user u ON u.user_id = x.fk_user
WHERE x.fk_user != '0'
AND x.calldisp = 'SUCCESS'
AND (x.calltime BETWEEN '2011-03-21%' AND
DATE_ADD('2011-04-19', INTERVAL 1 DAY));
# Time: 110420 9:10:30
# User@Host: ipn03_boki[ipn03_boki] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 626641
SELECT rtd.status, u.user_id, u.sip, u.realname, u.lastname, COUNT( d.name ) AS numb,we.*
FROM rt_dialer rtd
JOIN user u ON u.user_id = rtd.id
JOIN week_expecation we ON we.user_id = u.user_id
JOIN disposition d ON rtd.id = d.fk_user
WHERE d.date_s LIKE '2011-04-20%'
AND u.fk_call_center = '1'
GROUP BY d.fk_user
ORDER BY u.sip ASC;
# Time: 110420 9:10:30
# User@Host: ipn03_boki[ipn03_boki] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 626641
SELECT rtd.status, u.user_id, u.sip, u.realname, u.lastname, COUNT( d.name ) AS numb,we.*
FROM rt_dialer rtd
JOIN user u ON u.user_id = rtd.id
JOIN week_expecation we ON we.user_id = u.user_id
JOIN disposition d ON rtd.id = d.fk_user
WHERE d.date_s LIKE '2011-04-20%'
AND u.fk_call_center = '1'
GROUP BY d.fk_user
ORDER BY u.sip ASC;
# Time: 110420 9:27:35
# User@Host: ipn03_boki[ipn03_boki] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 626641
SELECT rtd.status, u.user_id, u.sip, u.realname, u.lastname, COUNT( d.name ) AS numb,we.*
FROM rt_dialer rtd
JOIN user u ON u.user_id = rtd.id
JOIN week_expecation we ON we.user_id = u.user_id
JOIN disposition d ON rtd.id = d.fk_user
WHERE d.date_s LIKE '2011-04-20%'
AND u.fk_call_center = '1'
GROUP BY d.fk_user
ORDER BY u.sip ASC;