{
"query_block": {
"select_id": 1,
"table": {
"table_name": "destination_links",
"access_type": "ref",
"possible_keys": ["idx_store_location_destination"],
"key": "idx_store_location_destination",
"key_length": "3",
"used_key_parts": ["store_location_id"],
"ref": ["const"],
"rows": 8,
"filtered": 100
},
"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": [
"const",
"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 |