{
"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": 11,
"filtered": 100,
"index_condition": "destination_links.store_location_id in (6,7)"
},
"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 |
---|---|---|---|---|---|---|
68 | 6 | 11 | 0 | 3 | 1 - 5 Business Days | en |
67 | 6 | 15 | 0 | 3 | 1 - 5 Business days | en |
66 | 6 | 20 | 0 | 3 | 1 - 5 Business Days | en |
84 | 7 | 1 | 0 | 2 | 1 - 5 Business Days | en |
74 | 7 | 12 | 0 | 3 | 1 - 5 Business Days | en |
69 | 7 | 13 | 1 | 3 | 1 - 8 Business Days | en |
73 | 7 | 14 | 1 | 3 | 1 - 8 Business Days | en |
70 | 7 | 16 | 1 | 3 | 2 - 10 Business Days | en |
72 | 7 | 17 | 0 | 3 | 1 - 5 Business Days | en |
71 | 7 | 18 | 0 | 3 | 1 - 5 Business Days | en |
75 | 7 | 19 | 0 | 3 | 1 - 5 Business Days | en |