{
"query_block": {
"select_id": 1,
"table": {
"table_name": "destination_links",
"access_type": "range",
"possible_keys": ["idx_store_location_destination"],
"key": "idx_store_location_destination",
"key_length": "3",
"used_key_parts": ["store_location_id"],
"rows": 10,
"filtered": 100,
"index_condition": "destination_links.store_location_id in (8,9)"
},
"table": {
"table_name": "shipping_delays",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "12",
"used_key_parts": ["store_location_id", "destination_id", "lang_code"],
"ref": [
"ymonline_livedata.destination_links.store_location_id",
"ymonline_livedata.destination_links.destination_id",
"const"
],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(shipping_delays.lang_code = 'en')"
}
}
}
link_id | store_location_id | destination_id | warn_about_delay | position | shipping_delay | lang_code |
---|---|---|---|---|---|---|
108 | 8 | 1 | 0 | 5 | 1 - 5 Business Days | en |
88 | 8 | 12 | 0 | 5 | 1 - 5 Business Days | en |
86 | 8 | 13 | 1 | 4 | 1 - 8 Business Days | en |
92 | 8 | 14 | 1 | 4 | 1 - 8 Business Days | en |
87 | 8 | 16 | 1 | 4 | 1 - 10 Business Days | en |
93 | 8 | 17 | 0 | 4 | 1 - 5 Business Days | en |
91 | 8 | 18 | 0 | 4 | 1 - 5 Business Days | en |
89 | 8 | 19 | 0 | 4 | 1 - 5 Business Days | en |
94 | 9 | 11 | 0 | 4 | 1 - 5 Business days | en |
95 | 9 | 15 | 0 | 4 | 1 - 5 Business days | en |
96 | 9 | 20 | 0 | 4 | 1 - 5 Business days | en |