{
"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": 75,
"index_condition": "cscart_warehouses_destination_products_amount.destination_id = 115 and cscart_warehouses_destination_products_amount.storefront_id = 0 and cscart_warehouses_destination_products_amount.product_id in (20249,20250,20252,20248,20251,20243,20245,20244,20247,20246,20262,20263,20264,20235,20260,20259,20261,20331,20333,20335,20332,20391,20334,20390)"
}
}
}
product_id | amount |
---|---|
20235 | 6 |
20243 | 16 |
20244 | 10 |
20245 | 1 |
20246 | 2 |
20247 | 3 |
20248 | 3 |
20249 | 22 |
20250 | 2 |
20251 | 3 |
20252 | 8 |
20259 | 1 |
20260 | 2 |
20261 | 7 |
20262 | 9 |
20263 | 2 |
20264 | 4 |
20331 | 67 |
20332 | 31 |
20333 | 5 |
20334 | 36 |
20335 | 2 |
20390 | 4 |
20391 | 4 |