{
"query_block": {
"select_id": 1,
"read_sorted_file": {
"filesort": {
"sort_key": "sl.position",
"table": {
"table_name": "sl",
"access_type": "ALL",
"possible_keys": ["PRIMARY"],
"rows": 49,
"filtered": 100
}
}
},
"table": {
"table_name": "wpa",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "6",
"used_key_parts": ["product_id", "warehouse_id"],
"ref": ["const", "admin_test.sl.store_location_id"],
"rows": 1,
"filtered": 100
}
}
}
warehouse_id | amount | store_type | position | main_destination_id | pickup_destinations_ids | shipping_destinations_ids | status |
---|---|---|---|---|---|---|---|
144 | 0 | W | 1 | 115 | 0 | 118,116,117,102,115 | A |
57 | 0 | S | 11 | 118 | 118,9,115 | 118,115,116,117,102 | A |
149 | 0 | S | 12 | 118 | 118,116,117,102,115 | 118,116,117,102,115 | A |
56 | 0 | S | 20 | 118 | 118,9,115 | 118,115,116,117,102 | A |
58 | 0 | S | 30 | 118 | 118,9,115 | 118,115,116,117,102 | A |
60 | 0 | S | 50 | 118 | 118,9,115 | 118,115,116,117,102 | A |
62 | 0 | S | 60 | 118 | 118,9,115 | 118,115,116,117,102 | A |
63 | 0 | S | 80 | 118 | 118,9,115 | 118,115,116,117,102 | A |
147 | 0 | S | 85 | 118 | 118,9,115 | 116,118,117,102,115 | A |
64 | 0 | S | 90 | 118 | 118,9,115 | 118,115,116,117,102 | A |
65 | 0 | S | 100 | 118 | 118,9,115 | 115,118,116,117,102 | A |
66 | 0 | S | 110 | 118 | 118,9,115 | 118,115,116,102,117 | A |
67 | 0 | S | 120 | 118 | 118,9,115 | 118,115,116,117,102 | A |
68 | 0 | S | 130 | 118 | 118,9,115 | 118,115,116,117,102 | A |
71 | 0 | S | 140 | 118 | 118,9,115 | 118,115,116,117,102 | A |
76 | 0 | S | 150 | 118 | 118,9,115 | 118,115,116,117,102 | A |
77 | 1 | S | 160 | 118 | 118,9,115 | 118,115,116,117,102 | A |
81 | 0 | S | 170 | 118 | 118,9,115 | 118,115,116,117,102 | A |
74 | 0 | S | 250 | 118 | 118,117,9 | 118,117,116,102,115 | A |
75 | 1 | S | 251 | 118 | 118,117,9 | 118,117,116,102,115 | A |
70 | 0 | S | 260 | 118 | 118,117,9 | 118,117,116,102,115 | A |
72 | 0 | S | 270 | 118 | 118,117,9 | 118,117,102,116,115 | A |
73 | 0 | S | 280 | 118 | 118,117,9 | 118,117,116,102,115 | A |
69 | 0 | S | 290 | 118 | 118,117,9 | 118,117,116,102,115 | A |
78 | 1 | S | 350 | 118 | 118,102,9 | 118,116,117,102,115 | A |
79 | 0 | S | 360 | 118 | 118,102,9 | 118,102,117,116,115 | A |
82 | 0 | S | 370 | 118 | 118,102,9 | 118,102,116,117,115 | A |
61 | 0 | S | 400 | 118 | 118,116,9 | 118,116,102,117,115 | A |
80 | 1 | S | 410 | 118 | 118,116,9 | 118,116,117,102,115 | A |
83 | 0 | S | 420 | 118 | 118,116,9 | 118,116,117,102,115 | A |
84 | 1 | S | 430 | 118 | 118,116,9 | 118,116,117,102,115 | A |
128 | 0 | W | 870 | 0 | A | ||
129 | 0 | W | 880 | 0 | A | ||
130 | 0 | W | 890 | 0 | A | ||
131 | 0 | W | 900 | 0 | A | ||
133 | 0 | W | 920 | 0 | A | ||
135 | 0 | W | 940 | 0 | A | ||
136 | 0 | W | 950 | 0 | A | ||
138 | 0 | W | 970 | 0 | A | ||
139 | 0 | W | 980 | 0 | A | ||
140 | 0 | W | 990 | 0 | A | ||
148 | 0 | W | 1010 | 0 | A | ||
150 | 0 | W | 1020 | 0 | A |