{
"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 (2673,15305,15390,2606,15132,2601,2602,2605,2607,2201,2287,2292,2291,2290,2230,2252,2555,2627,2628,2554,2603,2604,2179,13525)"
}
}
}
product_id | amount |
---|---|
2179 | 0 |
2201 | 3 |
2230 | 0 |
2252 | 8 |
2287 | 25 |
2290 | 1 |
2291 | 4 |
2292 | 4 |
2554 | 4 |
2555 | 1 |
2601 | 113 |
2602 | 116 |
2603 | 44 |
2604 | 35 |
2605 | 8 |
2606 | 6 |
2607 | 6 |
2627 | 4 |
2628 | 14 |
2673 | 6 |
15132 | 12 |