{
"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 (10613,10612,10611,15515,15516,18081,18082,18083,10002,7503,10610,10609,10608,10607,11908,18086,18087,10007,10063,10062,10064,9997,10000,9999)"
}
}
}
product_id | amount |
---|---|
7503 | 1 |
9997 | 2 |
9999 | 1 |
10000 | 3 |
10002 | 1 |
10007 | 2 |
10062 | 1 |
10063 | 2 |
10064 | 2 |
10607 | 1 |
10608 | 1 |
10609 | 2 |
10610 | 3 |
10611 | 1 |
10612 | 1 |
10613 | 3 |
11908 | 1 |
15515 | 2 |
15516 | 4 |
18081 | 4 |
18082 | 4 |
18083 | 5 |
18086 | 4 |
18087 | 5 |