{
"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 (12693,11795,2629,11122,2633,2655,11124,2653,2654,11123,2219,2572,2614,2613,15131,2786,2789,2790,11133,11809,2787,2784,2791,2785)"
}
}
}
product_id | amount |
---|---|
2219 | 0 |
2572 | 0 |
2613 | 36 |
2614 | 3 |
2629 | 0 |
2633 | 7 |
2653 | 6 |
2654 | 7 |
2655 | 60 |
2784 | 16 |
2785 | 93 |
2786 | 37 |
2787 | 37 |
2789 | 14 |
2790 | 6 |
2791 | 198 |
11122 | 7 |
11123 | 14 |
11124 | 12 |
11133 | 7 |
11795 | 60 |
11809 | 4 |
12693 | 3 |