{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "<derived2>",
      "access_type": "ALL",
      "rows": 691552,
      "filtered": 100,
      "attached_condition": "od.city_id = 25",
      "materialized": {
        "query_block": {
          "select_id": 2,
          "having_condition": "city_id = 25",
          "table": {
            "table_name": "b",
            "access_type": "index",
            "possible_keys": ["PRIMARY", "city_id"],
            "key": "PRIMARY",
            "key_length": "8",
            "used_key_parts": ["id"],
            "rows": 172886,
            "filtered": 50.001,
            "attached_condition": "b.alive = 1 and b.main_id > 0 and b.city_id <> 0"
          },
          "table": {
            "table_name": "bt",
            "access_type": "ref",
            "possible_keys": ["alias_id"],
            "key": "alias_id",
            "key_length": "4",
            "used_key_parts": ["alias_id"],
            "ref": ["outdoor.b.type_id"],
            "rows": 1,
            "filtered": 100,
            "index_condition": "bt.alias_id = b.type_id"
          },
          "table": {
            "table_name": "build_property",
            "access_type": "ref",
            "possible_keys": ["name", "build_id"],
            "key": "build_id",
            "key_length": "8",
            "used_key_parts": ["build_id"],
            "ref": ["outdoor.b.id"],
            "rows": 8,
            "filtered": 100,
            "index_condition": "build_property.build_id = b.`id`",
            "attached_condition": "build_property.`name` in ('location','side','price') and build_property.`value` is not null and build_property.`value` <> ''"
          }
        }
      }
    }
  }
}