|id |select_type|table |type |possible_keys |key |key_len|ref |rows|Extra | |---|-----------|----------|-----------|----------------------------------------------------------------------------------------------------|----------------------------------------------------------|-------|--------------------------------------------------------------------------------------------|----|----------------------------------------------------------------------------------------| |1 |PRIMARY |cr |index_merge|fcr_ind_fsp_cat_cap_service_UK,fit_cat_rule_individual_id_IDX,fit_cat_rule_company_id_IDX,fit_cat_ru|fit_cat_rule_individual_id_IDX,fit_cat_rule_company_id_IDX|4,4 | |1 |Using intersect(fit_cat_rule_individual_id_IDX,fit_cat_rule_company_id_IDX); Using where| |1 |PRIMARY ||ref |key0 |key0 |15 |devfitan_data.cr.fit_cat_id,devfitan_data.cr.fit_capacity_id,devfitan_data.cr.fit_service_id|2 |Using where | |2 |DERIVED ||ALL | | | | |12 |Using temporary; Using filesort | |2 |DERIVED ||ref |key0 |key0 |15 |ca.individual_id,ca.company_id,ca.fit_test_id |2 | | |4 |DERIVED |cr |ref |PRIMARY,company_test_individual_uniq,fit_test_id,FK_fit_ind_exemption_company |company_test_individual_uniq |8 |const,const |6 |Using where; Using index; Using temporary; Using filesort | |4 |DERIVED |co |ref |fit_ind_extend_condition_ibfk_1 |fit_ind_extend_condition_ibfk_1 |4 |devfitan_data.cr.id |1 | | |3 |DERIVED |cr |ref |PRIMARY,company_test_individual_uniq,FK_fit_ind_exemption_company |company_test_individual_uniq |8 |const,const |6 |Using index | |3 |DERIVED |ec |ref |Index 6,FK_fit_ind_exemption_id |FK_fit_ind_exemption_id |4 |devfitan_data.cr.id |2 | |