| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s0_ | ALL | PRIMARY, IDX_CFD811CAA977936C | 8 | 100 | Using where; Using temporary; Using filesort | ||||
| 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_ | ALL | IDX_CFD811CA727ACA70 | 8 | 100 | Using where; Using join buffer (Block Nested Loop) |