SELECT
COUNT((pa.id)
FROM ACTIVATION_PRODUCT_FEE_LOG pa
LEFT JOIN PROJECT_NEW pj
ON pa.ProjectId = pj.ID
JOIN PROJECT_COOPERATE_NEW pc
ON pj.ID = pc.ProjectId
LEFT JOIN BUSINESS_DEVELOPER bd
ON pj.BusinessDeveloperId = bd.ID
LEFT JOIN AGENT ag
ON bd.agentid = ag.id
LEFT JOIN PROVINCE pr
ON pa.ProvinceId = pr.id
JOIN CUSTOMER cm
ON cm.ID = pj.CustomerId
WHERE pa.Date BETWEEN '2011-03-01 00:00:00.0'
AND '2011-04-01 00:00:00.0'
AND pa.Deduct = 0
AND pc.PannerId = bd.AgentId
AND pc.PannerType = 'AG'
id select_type table type possible_keys key key_len ref rows Extra
------ ----------- ------ ------ ------------------------------------------------ ------------- ------- ---------------------------------- ------ -----------
1 SIMPLE pa range Date Date 8 (NULL) 493463 Using where
1 SIMPLE pj eq_ref PRIMARY,NewIndex1,CustomerId,BusinessDeveloperId PRIMARY 4 kkfun_newhz.pa.ProjectId 1 Using where
1 SIMPLE pc ref Pcn_ProjectId Pcn_ProjectId 4 kkfun_newhz.pa.ProjectId 4 Using where
1 SIMPLE bd eq_ref PRIMARY,AgentId PRIMARY 4 kkfun_newhz.pj.BusinessDeveloperId 1 Using where
1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 kkfun_newhz.pc.PannerId 1 Using index
1 SIMPLE pr eq_ref PRIMARY PRIMARY 4 kkfun_newhz.pa.ProvinceId 1 Using index
1 SIMPLE cm eq_ref PRIMARY PRIMARY 4 kkfun_newhz.pj.CustomerId 1 Using index