"query_optimization": {
    "r_total_time_ms": 1.035231057
  },
  "query_block": {
    "select_id": 1,
    "cost": 169.8953012,
    "r_loops": 1,
    "r_total_time_ms": 73850.53095,
    "filesort": {
      "sort_key": "RMD2.`VALUE`",
      "r_loops": 1,
      "r_total_time_ms": 0.118392462,
      "r_limit": 50,
      "r_used_priority_queue": true,
      "r_output_rows": 50,
      "r_sort_mode": "sort_key,rowid",
      "temporary_table": {
        "nested_loop": [
          {
            "table": {
              "table_name": "RM",
              "access_type": "ALL",
              "loops": 1,
              "r_loops": 1,
              "rows": 66620,
              "r_rows": 67200,
              "cost": 11.334926,
              "r_table_time_ms": 310.8222032,
              "r_other_time_ms": 57.73439303,
              "r_engine_stats": {
                "pages_accessed": 540,
                "pages_read_count": 347,
                "pages_read_time_ms": 477116.024
              },
              "filtered": 100,
              "r_total_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"],
              "loops": 66620,
              "r_loops": 67200,
              "rows": 1,
              "r_rows": 1,
              "cost": 59.5908696,
              "r_table_time_ms": 231.7162645,
              "r_other_time_ms": 65718.89469,
              "r_engine_stats": {
                "pages_accessed": 135168,
                "pages_read_count": 3,
                "pages_read_time_ms": 2719.508
              },
              "filtered": 100,
              "r_total_filtered": 100,
              "attached_condition": "trigcond(trigcond(RM.CURRENT_STATUS is not null))",
              "r_filtered": 100
            }
          },
          {
            "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"],
              "loops": 66620,
              "r_loops": 67200,
              "rows": 1,
              "r_rows": 1,
              "cost": 54.27949918,
              "r_table_time_ms": 969.6118819,
              "r_other_time_ms": 489.9111118,
              "filtered": 100,
              "r_total_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 '!')",
              "r_filtered": 100,
              "materialized": {
                "lateral": 1,
                "query_block": {
                  "select_id": 3,
                  "cost": 0.007516027,
                  "r_loops": 67200,
                  "r_total_time_ms": 6676.692465,
                  "nested_loop": [
                    {
                      "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"],
                        "loops": 1,
                        "r_loops": 67200,
                        "rows": 1,
                        "r_rows": 2,
                        "cost": 0.00345856,
                        "r_table_time_ms": 2706.394722,
                        "r_other_time_ms": 686.0953476,
                        "r_engine_stats": {
                          "pages_accessed": 537931,
                          "pages_read_count": 2191,
                          "pages_read_time_ms": 3070468.566
                        },
                        "filtered": 100,
                        "r_total_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"],
                        "loops": 1,
                        "r_loops": 134400,
                        "r_table_loops": 133728,
                        "rows": 1,
                        "r_rows": 0.265,
                        "cost": 0.00171364,
                        "r_table_time_ms": 812.8285295,
                        "r_other_time_ms": 416.6846883,
                        "r_engine_stats": {
                          "pages_accessed": 402132,
                          "pages_read_count": 357,
                          "pages_read_time_ms": 488944.236
                        },
                        "filtered": 100,
                        "r_total_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"],
                        "loops": 1,
                        "r_loops": 134400,
                        "r_table_loops": 67200,
                        "rows": 1,
                        "r_rows": 1,
                        "cost": 0.00171364,
                        "r_table_time_ms": 199.9055678,
                        "r_other_time_ms": 719.520839,
                        "r_engine_stats": {
                          "pages_accessed": 134400,
                          "pages_read_count": 1,
                          "pages_read_time_ms": 851.202
                        },
                        "filtered": 100,
                        "r_total_filtered": 100,
                        "r_filtered": 100
                      }
                    }
                  ]
                }
              }
            }
          }
        ]
      }
    }
  }