id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s3_ | const | PRIMARY, UNIQ_CFD811CA77153098 | UNIQ_CFD811CA77153098 | 767 | const | 1 | 100 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | s0_ | ref | PRIMARY, IDX_CFD811CA727ACA70 | IDX_CFD811CA727ACA70 | 5 | const | 1 | 12.5 | Using where | |
1 | SIMPLE | s1_ | eq_ref | slug_uidx, sylius_taxon_translation_uniq_trans, IDX_1487DFCF2C2AC5D3 | sylius_taxon_translation_uniq_trans | 771 | open_marketplace.s0_.id, const | 1 | 100 | ||
1 | SIMPLE | s2_ | ref | IDX_CFD811CA727ACA70 | IDX_CFD811CA727ACA70 | 5 | open_marketplace.s0_.id | 2 | 100 |