{
"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 (19359,19367,19532,19469,19499,19521,19500,19487,19522,19446,19372,19482,19467,19481,19509,19510,19511,19479,19444,19518,19498,19436,19425,19426)"
}
}
}
product_id | amount |
---|---|
19359 | 1 |
19367 | 1 |
19372 | 6 |
19425 | 1 |
19426 | 1 |
19436 | 1 |
19444 | 31 |
19446 | 1 |
19467 | 4 |
19469 | 1 |
19479 | 4 |
19481 | 3 |
19482 | 17 |
19487 | 2 |
19498 | 27 |
19499 | 15 |
19500 | 1 |
19509 | 4 |
19510 | 2 |
19511 | 2 |
19518 | 46 |
19521 | 9 |
19522 | 2 |
19532 | 1 |