idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEthematic_typologyNULLALLNULLNULLNULLNULL5461Using where
1SIMPLEthematic_typology_idNULLALLNULLNULLNULLNULL1190710Using where; Using join buffer (hash join)
1SIMPLEincidentsNULLALLNULLNULLNULLNULL132990.1Using where; Using join buffer (hash join)