{
"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 (2788,2612,15385,2608,2609,2561,2610,2611,2571,2317,2318,12754,11610,11606,11818,11607,11608,14076,14077,11135,12977,12677,12654,2763)"
}
}
}
product_id | amount |
---|---|
2317 | 6 |
2318 | 4 |
2561 | 11 |
2571 | 9 |
2608 | 64 |
2609 | 24 |
2610 | 5 |
2611 | 24 |
2612 | 24 |
2763 | 6 |
2788 | 8 |
11135 | 46 |
11606 | 2 |
11607 | 3 |
11608 | 18 |
11610 | 176 |
11818 | 16 |
12654 | 0 |
12677 | 0 |
12754 | 0 |