mysql创建视图后查询还是很慢

Question

SELECT
    vaccination_id,
    vaccination_num,
    vaccination_file_num,
    vaccination_name,
    vaccination_sex,
    date_of_birth,
    vaccination_phone,
    vaccination_id_num,
    category,
    vaccination_person_type,
    place_of_abode,
    vaccination_work_unit,
    vaccination_fill_countyside,
    vaccination_personnel_type,
    vaccination_administrative_village,
    vaccination_person_status,
    uninoculation_reasons,
    ( substring( now(), 1, 4 )- substring( vaccination_id_num, 7, 4 ))-( substring( vaccination_id_num, 11, 4 )- date_format( now(), '%m%d' )> 0 ) AS age,
    GROUP_CONCAT( CASE WHEN vaccination_outpatient_service = "" THEN '-' WHEN vaccination_outpatient_service IS NULL THEN '-' ELSE vaccination_outpatient_service END ) vaccination_site,
    GROUP_CONCAT( CASE WHEN vaccination_manufacturers = "" THEN '-' WHEN vaccination_manufacturers IS NULL THEN '-' ELSE vaccination_manufacturers END ) manufacturer,
    GROUP_CONCAT( CASE WHEN different_inoculation_flg = "" THEN '-' WHEN different_inoculation_flg IS NULL THEN '-' ELSE different_inoculation_flg END ) different_vaccination_flg,
    GROUP_CONCAT( CASE WHEN vaccination_time = "" THEN '-' WHEN vaccination_time IS NULL THEN '-' ELSE vaccination_time END ) vaccination_dates,
    GROUP_CONCAT( CASE WHEN vaccination_remark = "" THEN '-' WHEN vaccination_remark IS NULL THEN '-' ELSE vaccination_remark END ) vaccination_times,
    GROUP_CONCAT( CASE WHEN not_vaccinated = "" THEN '-' WHEN not_vaccinated IS NULL THEN '-' ELSE not_vaccinated END ) not_vaccinated,
    GROUP_CONCAT( CASE WHEN  uninoculation_reasons ="" THEN ''  WHEN uninoculation_reasons IS NULL THEN '' ELSE uninoculation_reasons  END ) uninoculation_reasons, 
    GROUP_CONCAT( CASE WHEN native_flg = "" THEN '-' WHEN native_flg IS NULL THEN '-' ELSE native_flg END ) native_flg,
    GROUP_CONCAT( CASE WHEN diagnose_hospital = "" THEN '-' WHEN diagnose_hospital IS NULL THEN '-' ELSE diagnose_hospital END ) diagnose_hospital 
FROM
    yinet_vaccination yv
    GROUP BY vaccination_id_num

建立视图，查询的速度跟 直接sql查的速度差不多， 而且速度都很慢

vaccination_id_num 已经加上了索引

Answer 1

explain 分析