"query_block": {
    "select_id": 1,
    "r_loops": 1,
    "r_total_time_ms": 70995.375,
    "filesort": {
      "sort_key": "RMD2.`VALUE`",
      "r_loops": 1,
      "r_total_time_ms": 0.031,
      "r_limit": 50,
      "r_used_priority_queue": false,
      "r_output_rows": 50,
      "r_buffer_size": "46Kb",
      "r_sort_mode": "packed_sort_key,rowid",
      "temporary_table": {
        "table": {
          "table_name": "RM",
          "access_type": "ALL",
          "r_loops": 1,
          "rows": 67051,
          "r_rows": 67200,
          "r_table_time_ms": 86.567,
          "r_other_time_ms": 54.396,
          "r_engine_stats": {
            "pages_accessed": 540
          },
          "filtered": 100,
          "r_filtered": 100
        },
        "table": {
          "table_name": "RMD2",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "4",
          "used_key_parts": ["ID"],
          "ref": ["b_test.RM.CURRENT_STATUS"],
          "r_loops": 67200,
          "rows": 1,
          "r_rows": 1,
          "r_table_time_ms": 224.66,
          "r_other_time_ms": 64554.067,
          "r_engine_stats": {
            "pages_accessed": 135168
          },
          "filtered": 100,
          "r_filtered": 100,
          "attached_condition": "trigcond(trigcond(RM.CURRENT_STATUS is not null))"
        },
        "table": {
          "table_name": "<derived3>",
          "access_type": "ref",
          "possible_keys": ["key0"],
          "key": "key0",
          "key_length": "5",
          "used_key_parts": ["REQUEST_ID"],
          "ref": ["b_test.RM.ID"],
          "r_loops": 67200,
          "rows": 2,
          "r_rows": 1,
          "r_table_time_ms": 932.76,
          "r_other_time_ms": 508.082,
          "filtered": 100,
          "r_filtered": 100,
          "attached_condition": "trigcond(lcase(RUUD.UAR_ALL_EMAILS) like '%AbeFrazer8@example.com%' escape '!' or lcase(RUUD.STUDY_TEAM_LEADS) like '%AbeFrazer8@example.com%' escape '!' or lcase(RM.REQUEST_BY) like '%AbeFrazer8@example.com%' escape '!')",
          "materialized": {
            "lateral": 1,
            "query_block": {
              "select_id": 3,
              "r_loops": 67200,
              "r_total_time_ms": 5218.226,
              "table": {
                "table_name": "UAR",
                "access_type": "ref",
                "possible_keys": ["TEST_MAU_REQUEST_MAIN_ID"],
                "key": "TEST_MAU_REQUEST_MAIN_ID",
                "key_length": "4",
                "used_key_parts": ["REQUEST_ID"],
                "ref": ["b_test.RM.ID"],
                "r_loops": 67200,
                "rows": 1,
                "r_rows": 2,
                "r_table_time_ms": 1370.049,
                "r_other_time_ms": 685.995,
                "r_engine_stats": {
                  "pages_accessed": 537931
                },
                "filtered": 100,
                "r_filtered": 100
              },
              "table": {
                "table_name": "U",
                "access_type": "eq_ref",
                "possible_keys": ["PRIMARY"],
                "key": "PRIMARY",
                "key_length": "767",
                "used_key_parts": ["EMAIL"],
                "ref": ["b_test.UAR.USER_EMAIL"],
                "r_loops": 134400,
                "rows": 1,
                "r_rows": 0.265,
                "r_table_time_ms": 682.657,
                "r_other_time_ms": 440.131,
                "r_engine_stats": {
                  "pages_accessed": 403478
                },
                "filtered": 100,
                "r_filtered": 100
              },
              "table": {
                "table_name": "FR",
                "access_type": "eq_ref",
                "possible_keys": ["PRIMARY"],
                "key": "PRIMARY",
                "key_length": "4",
                "used_key_parts": ["ID"],
                "ref": ["b_test.UAR.FUNCTIONAL_ROLE_ID"],
                "r_loops": 134400,
                "rows": 1,
                "r_rows": 1,
                "r_table_time_ms": 205.636,
                "r_other_time_ms": 699.014,
                "r_engine_stats": {
                  "pages_accessed": 137088
                },
                "filtered": 100,
                "r_filtered": 100
              }
            }
          }
        }
      }
    }
  }