Отчет по направлениям. Там идет длительный селект, вот пример из mysql-slow.log:
# Time: 150717 15:46:15 # User@Host: bill[bill] @ localhost [127.0.0.1] # Query_time: 248.299473 Lock_time: 0.000026 Rows_sent: 141 Rows_examined: 625717789 use bgbilling; SET timestamp=1437133575; SELECT session.dest_id, dest.title, codes.code, COUNT(session.id) as cnt, SUM(session.round_session_time) as round_session_time, SUM(session.cost) as cost FROM log_session_1_201507 as session LEFT JOIN contract ON session.cid=contract.id LEFT JOIN phone_dest_1 as dest ON session.dest_id=dest.id LEFT JOIN phone_geographic_code_1 as codes ON codes.dest_id=dest.id WHERE 1=1 AND session.sid IN ( 14 ) GROUP BY dest_id;
|