{
"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 (15123,2184,2231,2288,2754,2346,2348,2345,2344,2350,15295,2250,2223,2649,2652,2651,2650,2634,12688,2639,2637,2638,2355,2204)"
}
}
}
product_id | amount |
---|---|
2184 | 20 |
2204 | 23 |
2223 | 21 |
2231 | 0 |
2250 | 5 |
2288 | 0 |
2344 | 6 |
2345 | 3 |
2346 | 3 |
2348 | 0 |
2350 | 0 |
2355 | 0 |
2634 | 14 |
2637 | 9 |
2638 | 27 |
2639 | 16 |
2649 | 34 |
2650 | 56 |
2651 | 18 |
2652 | 29 |
2754 | 8 |
12688 | 1 |