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 |