| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | promotion | ALL | PRIMARY, code, individual_code_pattern | 25 | 4.00 | Using where; Using temporary; Using filesort | ||||
| 1 | SIMPLE | promotion.salesChannels | ref | idx.promotion_sales_channel.sales_channel_id, idx.promotion_sales_channel.promotion_id | idx.promotion_sales_channel.promotion_id | 16 | db-2.promotion.id | 1 | 100.00 | Using where | |
| 1 | SIMPLE | promotion.acrisPromotionDisplay | ALL | 29 | 90.00 | Using where; Using join buffer (hash join) |