id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s2_ range PRIMARY PRIMARY 4 6 Using where; Using temporary; Using filesort
1 SIMPLE s5_ ref PRIMARY, IDX_76CDAFA13B69A9AF, IDX_76CDAFA1D957CA06 IDX_76CDAFA1D957CA06 4 ppmcdev.s2_.id 5 Using index
1 SIMPLE s0_ eq_ref PRIMARY, IDX_A29B5234584665A PRIMARY 4 ppmcdev.s5_.variant_id 1 Using where
1 SIMPLE s3_ eq_ref PRIMARY PRIMARY 4 ppmcdev.s0_.product_id 1 Using index
1 SIMPLE s1_ eq_ref product_variant_channel_idx, IDX_7801820CA80EF684 product_variant_channel_idx 771 ppmcdev.s5_.variant_id, const 1 Using index condition
1 SIMPLE s4_ eq_ref sylius_product_variant_translation_uniq_trans, IDX_8DC18EDC2C2AC5D3 sylius_product_variant_translation_uniq_trans 771 ppmcdev.s5_.variant_id, const 1 Using where; Using index