{
"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": 30,
"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 (12731,12725,12727,12724,10923,10920,10922,12730,10918,10916,10919,10833,10837,10835,10836,10834,10819,10827,10829,10830,10832,10828,12726,12732,12598,12599,12601,12603,12600,12602)"
}
}
}
product_id | amount |
---|---|
10819 | 27 |
10827 | 0 |
10828 | 3 |
10829 | 19 |
10830 | 2 |
10832 | 10 |
10833 | 1 |
10834 | 9 |
10835 | 0 |
10836 | 0 |
10837 | 1 |
10916 | 12 |
10918 | 149 |
10919 | 243 |
10920 | 543 |
10922 | 91 |
10923 | 36 |
12724 | 18 |
12725 | 9 |
12726 | 32 |
12727 | 0 |
12730 | 90 |
12731 | 17 |
12732 | 56 |