{
"query_block": {
"select_id": 1,
"table": {
"table_name": "a",
"access_type": "range",
"possible_keys": ["type"],
"key": "type",
"key_length": "9",
"used_key_parts": ["type"],
"rows": 1,
"filtered": 100,
"index_condition": "a.`type` in ('ips','ipr','ipb')",
"attached_condition": "(a.ip_from <= 51353376 and a.ip_to >= 51353376 or a.ip_from <= 2130706433 and a.ip_to >= 2130706433) and a.`status` = 'A'"
},
"table": {
"table_name": "b",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "18",
"used_key_parts": ["item_id", "type", "lang_code"],
"ref": [
"staging2_wesave_com.a.item_id",
"staging2_wesave_com.a.type",
"const"
],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(b.lang_code = 'en')"
}
}
}