{
"query_block": {
"select_id": 1,
"table": {
"table_name": "cscart_warehouses_destination_products_amount",
"access_type": "range",
"possible_keys": ["PRIMARY", "idx_storefront_id"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["product_id", "destination_id", "storefront_id"],
"rows": 24,
"filtered": 100,
"index_condition": "cscart_warehouses_destination_products_amount.destination_id = 12 and cscart_warehouses_destination_products_amount.storefront_id = 0 and cscart_warehouses_destination_products_amount.product_id in (12664,12667,12666,12751,2641,2642,2635,2636,12691,12690,12692,2199,2200,2237,12678,3238,3237,12656,13107,12672,12671,11136,2772,11808)"
}
}
}
product_id | amount |
---|---|
2199 | 6 |
2200 | 158 |
2237 | 13 |
2635 | 21 |
2636 | 50 |
2641 | 37 |
2642 | 23 |
2772 | 10 |
3237 | 30 |
3238 | 0 |
11136 | 3 |
11808 | 13 |
12656 | 14 |
12664 | 0 |
12666 | 0 |
12667 | 0 |
12671 | 30 |
12672 | 8 |
12678 | 3 |
12690 | 6 |
12691 | 6 |
12692 | 4 |
12751 | 2 |