--表里有140多万条记录
CREATE TABLE `t_toll_universal` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `invokeId` varchar(50) DEFAULT NULL,
  `customName` varchar(200) DEFAULT NULL,
  `customID` varchar(200) DEFAULT NULL,
  `callDirection` int(11) DEFAULT NULL,
  `agentID` varchar(50) DEFAULT NULL,
  `corpName` varchar(50) DEFAULT NULL,
  `firstNo` varchar(50) DEFAULT NULL,
  `firstTrunkDn` varchar(50) DEFAULT NULL,
  `secondNo` varchar(50) DEFAULT NULL,
  `secondTrunkDn` varchar(50) DEFAULT NULL,
  `wanIp` varchar(50) DEFAULT NULL,
  `lanIp` varchar(50) DEFAULT NULL,
  `tollType1` int(11) DEFAULT NULL,
  `beginTime` datetime DEFAULT NULL,
  `endTime` datetime DEFAULT NULL,
  `Exmoney` float(8,2) DEFAULT NULL,
  `PresideTrunkDn` varchar(50) DEFAULT NULL,
  `HashAccountid` varchar(50) DEFAULT NULL,
  `tollType2` int(11) DEFAULT NULL,
  `managerId` varchar(50) DEFAULT NULL,
  `presidePhoneNo` varchar(50) DEFAULT NULL,
  `ComputerSymbol` varchar(10) DEFAULT NULL,
  `GatewayName` varchar(50) DEFAULT NULL,
  `Exmoney_6s` float(8,2) DEFAULT NULL,
  `Costmoney` float(8,2) DEFAULT NULL,
  `Costmoney_6s` float(8,2) DEFAULT NULL,
  `Charge_CurPerAmount` float(8,2) DEFAULT NULL,
  `Cost_CurPerAmount` float(8,2) DEFAULT NULL,
  `WorkingPloyName` varchar(50) DEFAULT NULL,
  `ExMinute` float(8,2) DEFAULT NULL,
  `LeftMinute` float(8,2) DEFAULT NULL,
  `ServerSymbol` varchar(100) DEFAULT NULL,
  `Charge_IpPerAmount` float(8,0) DEFAULT NULL,
  `Cost_IpPerAmount` float(8,0) DEFAULT NULL,
  `AnswerCallTime` datetime DEFAULT NULL,
  `IsLocalCall` int(4) DEFAULT NULL,
  `IsRealNoCall` int(4) DEFAULT NULL,
  `TransInvokeId` varchar(50) DEFAULT NULL,
  `TransCallTime` datetime DEFAULT NULL,
  `IsTransferred` int(4) DEFAULT NULL,
  `SessionID` varchar(50) DEFAULT NULL,
  `ServerSymbol2` varchar(50) DEFAULT NULL,
  `SubsidiariesSignNo` varchar(50) DEFAULT NULL,
  `IsWebCall` int(4) DEFAULT NULL,
  `IsMasterPhone` int(4) DEFAULT NULL,
  `IVRBottonNum` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `agentID` (`agentID`),
  KEY `123` (`firstNo`,`secondNo`),
  KEY `invokeId` (`invokeId`) USING BTREE,
  KEY `idx_managerId_TransCallTime` (`managerId`,`TransCallTime`) USING BTREE,
  KEY `idx_managerId_endTime` (`managerId`,`endTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2849809 DEFAULT CHARSET=utf8;

-- 表里有3条记录
CREATE TABLE `t_manager` (
  `managerid` varchar(50) NOT NULL,
  `Corpname` varchar(50) NOT NULL,
  PRIMARY KEY (`managerid`),
  KEY `idx_managerid` (`managerid`),
  KEY `idx_corpname` (`Corpname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

mysql> EXPLAIN SELECT a.corpname,b.exmoney,b.minute,b.gatewayname from t_manager as a right join (select sum(exmoney) as exmoney,managerid,SUM(ceil(timestampdiff(second, beginTime, endTime)/60)) AS minute ,gatewayname from t_toll_universal where begintime >= '2012-04-01' and begintime < '2012-05-01' and calldirection = 1 and islocalcall=0 group by managerid,gatewayname) as b on b.managerid=a.managerid;

+----+-------------+------------------+--------+-----------------------+---------+---------+-------------+---------+----------------------------------------------+
| id | select_type | table            | type   | possible_keys         | key     | key_len | ref         | rows    | Extra                                        |
+----+-------------+------------------+--------+-----------------------+---------+---------+-------------+---------+----------------------------------------------+
|  1 |