{
"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 (2764,12676,12655,2831,2832,15312,13836,2844,2679,2669,2683,2680,2675,2674,4357,11901,11902,11919,11906,11662,11903,11661,11907,11908)"
}
}
}
product_id | amount |
---|---|
2669 | 70 |
2674 | 15 |
2675 | 33 |
2679 | 19 |
2680 | 11 |
2683 | 2 |
2764 | 6 |
2831 | 53 |
2832 | 59 |
2844 | 0 |
4357 | 4 |
11661 | 7138 |
11662 | 4002 |
11901 | 3951 |
11902 | 3938 |
11903 | 4002 |
11906 | 3588 |
11907 | 7151 |
11908 | 1109 |
11919 | 48 |
12655 | 0 |
12676 | 11 |