{
"query_block": {
"select_id": 1,
"filesort": {
"sort_key": "sl.position",
"temporary_table": {
"table": {
"table_name": "wpa",
"access_type": "ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 2,
"filtered": 100
},
"table": {
"table_name": "sl",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["store_location_id"],
"ref": ["ymonline_livedata.wpa.warehouse_id"],
"rows": 1,
"filtered": 100
}
}
}
}
}
warehouse_id | amount | store_type | position | main_destination_id | pickup_destinations_ids | shipping_destinations_ids | status |
---|---|---|---|---|---|---|---|
8 | 3 | W | 13 | 12 | 0 | 13,16,12,19,18,14,17,1 | A |
9 | 27 | W | 23 | 11 | 0 | 11,15,20 | A |