idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEalbumNULLindex_mergeconfirmStatus,FK_album_websiteconfirmStatus,FK_album_website2,5NULL1100.00Using intersect(confirmStatus,FK_album_website); Using where; Using index