id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE payment_method range PRIMARY PRIMARY 16 12 Using where
1 SIMPLE payment_method.translation eq_ref PRIMARY, fk.payment_method_translation.language_id PRIMARY 32 showcase_sw6.payment_method.id, const 1 Using where
1 SIMPLE payment_method.appPaymentMethod eq_ref uniq.app_payment_method.payment_method_id uniq.app_payment_method.payment_method_id 16 showcase_sw6.payment_method.id 1
1 SIMPLE payment_method.media eq_ref PRIMARY PRIMARY 16 showcase_sw6.payment_method.media_id 1 Using where
1 SIMPLE payment_method.media.translation eq_ref PRIMARY, fk.media_translation.language_id PRIMARY 32 showcase_sw6.payment_method.media.id, const 1 Using where