{
"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 (12669,12975,2299,2297,2298,2203,2566,3215,3214,11118,12685,13990,2340,11888,2339,2338,2180,2181,13661,15141,2228,2226,2227,2336,12743,2185,14298,15154,13222,15155)"
}
}
}
product_id | amount |
---|---|
2180 | 64 |
2181 | 31 |
2185 | 21 |
2203 | 10 |
2226 | 14 |
2227 | 105 |
2228 | 6 |
2297 | 0 |
2298 | 1 |
2299 | 9 |
2336 | 9 |
2338 | 1 |
2339 | 6 |
2340 | 42 |
2566 | 6 |
3214 | 2 |
3215 | 16 |
11118 | 0 |
11888 | 2 |
12669 | 0 |
12685 | 2 |
12743 | 20 |
13222 | 99 |
13661 | 10 |
15154 | 24 |
15155 | 10 |