| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | category.mainCategories | ref | uniq.main_category.sales_channel_product, fk.main_category.sales_channel_id, fk.main_category.category_id | fk.main_category.sales_channel_id | 16 | const | 1 | Using index condition; Using where |
| 1 | SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 32 | showcase_sw6.category.mainCategories.category_id, const | 1 | Using where |