1.在当sql语句过长时。
"infos_getsubscrib": {
sql: "select * from events t left join (select count(*) as sends,ecode from events_push group by ecode) b on t.ecode= b.ecode left join (select count(*) as count,ecode from events_push where status = 1 group by ecode) c on t.ecode = c.ecode where t.revent=:revent"
},"infos_getsubscrib": {
sql
