{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "lt",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "CONTENTID"
          ],
          "key_length": "8",
          "ref": [
            "const"
          ],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "rt",
          "access_type": "ref",
          "possible_keys": [
            "<auto_key0>"
          ],
          "key": "<auto_key0>",
          "used_key_parts": [
            "currentId"
          ],
          "key_length": "9",
          "ref": [
            "const"
          ],
          "rows": 10,
          "filtered": 100,
          "materialized_from_subquery": {
            "using_temporary_table": true,
            "dependent": false,
            "cacheable": true,
            "query_block": {
              "select_id": 2,
              "nested_loop": [
                {
                  "table": {
                    "table_name": "ucr",
                    "access_type": "ref",
                    "possible_keys": [
                      "u2c_relation_unique",
                      "r_u2c_lastmodifier_idx",
                      "relation_u2c_targetcontent_idx",
                      "relation_u2c_relationname_idx"
                    ],
                    "key": "r_u2c_lastmodifier_idx",
                    "used_key_parts": [
                      "LASTMODIFIER"
                    ],
                    "key_length": "767",
                    "ref": [
                      "const"
                    ],
                    "rows": 692,
                    "filtered": 100,
                    "index_condition": "(`confluenceuat`.`ucr`.`LASTMODIFIER` = '2c900c3842b8b9290142b8bbd89f20ad')",
                    "attached_condition": "((`confluenceuat`.`ucr`.`RELATIONNAME` = 'touched') and (`confluenceuat`.`ucr`.`TARGETCONTENTID` is not null))"
                  }
                },
                {
                  "table": {
                    "table_name": "c",
                    "access_type": "eq_ref",
                    "possible_keys": [
                      "PRIMARY",
                      "tmp_contenttype_idx"
                    ],
                    "key": "PRIMARY",
                    "used_key_parts": [
                      "CONTENTID"
                    ],
                    "key_length": "8",
                    "ref": [
                      "confluenceuat.ucr.TARGETCONTENTID"
                    ],
                    "rows": 1,
                    "filtered": 100,
                    "attached_condition": "((`confluenceuat`.`c`.`CONTENTTYPE` in ('PAGE','BLOGPOST')) and (`confluenceuat`.`c`.`CONTENT_STATUS` in ('current','draft')))"
                  }
                }
              ]
            }
          }
        }
      }
    ]
  }
}