问具有多个左连接的mysql查询需要花费大量时间来获取数据

EN

    SELECT 
        ds.disease_type as disease, 
        SUM(CASE WHEN (DATE_FORMAT(pdm.visited_date, '%m-%Y'))='10-2019' THEN 1 ELSE 0 END) as patient_count, 
        SUM(CASE WHEN ((DATE_FORMAT(pdm.visited_date, '%Y-%m-%d')) BETWEEN '2019-04-01' AND '2020-03-01') THEN 1 else 0 end) as disease_morbidity_cumulative_no,
        SUM(case when ic.age BETWEEN 0 AND 15 AND ic.gender ='male' AND (DATE_FORMAT(pdm.visited_date, '%m-%Y'))='10-2019' then 1 else 0 end) as patient_age_count1_male, 
        SUM(case when ic.age BETWEEN 0 AND 15 AND ic.gender ='female' AND (DATE_FORMAT(pdm.visited_date, '%m-%Y'))='10-2019' then 1 else 0 end) as patient_age_count1_female, 
        SUM(case when ic.age BETWEEN 16 AND 45 AND ic.gender ='male' AND (DATE_FORMAT(pdm.visited_date, '%m-%Y'))='10-2019' then 1 else 0 end) as patient_age_count2_male, 
        SUM(case when ic.age BETWEEN 16 AND 45 AND ic.gender ='female' AND (DATE_FORMAT(pdm.visited_date, '%m-%Y'))='10-2019' then 1 else 0 end) as patient_age_count2_female, 
        SUM(case when ic.age >45 AND ic.gender='male' AND (DATE_FORMAT(pdm.visited_date, '%m-%Y'))='10-2019' then 1 else 0 end) as patient_age_count3_male, 
        SUM(case when ic.age >45 AND ic.gender='female' AND (DATE_FORMAT(pdm.visited_date, '%m-%Y'))='10-2019' then 1 else 0 end) as patient_age_count3_female 
    FROM (p_d_m pdm) 
        LEFT JOIN i_card ic ON ic.i_card_id = pdm.i_card_id
        LEFT JOIN disease ds ON ds.disease_id = pdm.disease_id 
        LEFT JOIN village v ON v.village_id = ic.village_id 
        LEFT JOIN phc p ON p.phc_id = v.phc_id 
        LEFT JOIN ind_card indc ON indc.ind_card_id = pdm.ind_card_id 
        LEFT JOIN block b ON b.block_id = p.block_id 
        LEFT JOIN sub_district s ON s.sub_district_id =b.sub_district_id 
        LEFT JOIN district d ON d.district_id = s.district_id 
    GROUP BY ds.disease_id