id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a1_ | ALL | UNIQ_PRODUCT_COUNTRY, IDX_D63F98104584665A, IDX_D63F9810F92F3E70 | 1 | 100 | Using where; Using temporary; Using filesort | ||||
1 | SIMPLE | s0_ | eq_ref | PRIMARY, UNIQ_E74256BF77153098, IDX_E74256BF77153098 | PRIMARY | 4 | open_marketplace.a1_.country_id | 1 | 25 | Using where | |
1 | SIMPLE | s2_ | eq_ref | PRIMARY | PRIMARY | 4 | open_marketplace.a1_.product_id | 1 | 10 | Using where |