{
"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 (8362,7504,8371,8363,11933,11932,11931,10617,10616,14647,15530,15512,18088,15799,15800,15513,15514,11907,9996,9995,10615,10614,11910,10001)"
}
}
}
product_id | amount |
---|---|
7504 | 2 |
8362 | 1 |
8363 | 3 |
8371 | 3 |
9995 | 2 |
9996 | 3 |
10001 | 4 |
10614 | 3 |
10615 | 3 |
10616 | 6 |
10617 | 6 |
11907 | 1 |
11910 | 1 |
11931 | 4 |
11932 | 3 |
11933 | 4 |
14647 | 3 |
15512 | 7 |
15513 | 4 |
15514 | 6 |
15530 | 3 |
15799 | 2 |
15800 | 1 |
18088 | 6 |