{
"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 (2237,11920,2184,2231,2288,2346,2348,2345,2344,2350,2250,2223,13349,2355,2204,2273,2278,2275,2276,2277,2272,2274,4359,2326,2251,2293,2294,2295,2247,2248)"
}
}
}
product_id | amount |
---|---|
2184 | 20 |
2204 | 23 |
2223 | 21 |
2231 | 0 |
2237 | 13 |
2247 | 18 |
2248 | 19 |
2250 | 5 |
2251 | 0 |
2272 | 12 |
2273 | 1 |
2274 | 1 |
2275 | 6 |
2276 | 0 |
2277 | 1 |
2278 | 6 |
2288 | 0 |
2293 | 3 |
2294 | 4 |
2295 | 1 |
2326 | 32 |
2344 | 6 |
2345 | 3 |
2346 | 3 |
2348 | 0 |
2350 | 0 |
2355 | 0 |
4359 | 10 |
11920 | 28 |