{
"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": 30,
"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 (2721,2202,2625,2678,2824,2776,2826,2775,2777,2823,13441,13762,11667,11666,11668,11665,13106,15112,13839,13838,13140,13828,12505,13829,13830,15426,2567,2557,2569,2556)"
}
}
}
product_id | amount |
---|---|
2202 | 26 |
2556 | 35 |
2557 | 27 |
2567 | 18 |
2569 | 26 |
2625 | 25 |
2678 | 42 |
2721 | 72 |
2775 | 32 |
2776 | 124 |
2777 | 12 |
2823 | 36 |
2824 | 18 |
2826 | 35 |
11665 | 16 |
11666 | 7 |
11667 | 8 |
11668 | 25 |
12505 | 18 |
13106 | 5 |
13140 | 6 |
13762 | 2 |
13828 | 9 |