json mapped

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.77"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "2.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "TABLE_2",
            "access_type": "ALL",
            "rows_examined_per_scan": 2,
            "rows_produced_per_join": 2,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "2.52",
              "eval_cost": "0.20",
              "prefix_cost": "2.73",
              "data_read_per_join": "96"
            },
            "used_columns": [
              "COLUMN_17",
              "COLUMN_9",
              "COLUMN_11",
              "COLUMN_13",
              "COLUMN_18"
            ],
            "materialized_from_subquery": {
              "using_temporary_table": true,
              "dependent": false,
              "cacheable": true,
              "query_block": {
                "select_id": 2,
                "cost_info": {
                  "query_cost": "0.80"
                },
                "grouping_operation": {
                  "using_filesort": false,
                  "table": {
                    "table_name": "TABLE_5",
                    "access_type": "ref",
                    "possible_keys": [
                      "COLUMN_19",
                      "COLUMN_17",
                      "find_connected_organizations"
                    ],
                    "key": "COLUMN_19",
                    "used_key_parts": [
                      "COLUMN_19"
                    ],
                    "key_length": "4",
                    "ref": [
                      "const"
                    ],
                    "rows_examined_per_scan": 3,
                    "rows_produced_per_join": 0,
                    "filtered": "20.00",
                    "cost_info": {
                      "read_cost": "0.50",
                      "eval_cost": "0.06",
                      "prefix_cost": "0.80",
                      "data_read_per_join": "110"
                    },
                    "used_columns": [
                      "id",
                      "COLUMN_19",
                      "COLUMN_20",
                      "COLUMN_17",
                      "COLUMN_9",
                      "COLUMN_11"
                    ],
                    "attached_condition": "(`mollie_test_1`.`TABLE_5`.`COLUMN_20` in ('Some string value', 'Some string other value'))"
                  }
                }
              }
            }
          }
        },
        {
          "table": {
            "table_name": "TABLE_1",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "id"
            ],
            "key_length": "4",
            "ref": [
              "TABLE_2.COLUMN_17"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 2,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.50",
              "eval_cost": "0.20",
              "prefix_cost": "3.43",
              "data_read_per_join": "30K"
            },
            "used_columns": [
              "id",
              "COLUMN_3",
              "COLUMN_7",
              "COLUMN_5"
            ]
          }
        },
        {
          "table": {
            "table_name": "TABLE_1",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "id"
            ],
            "key_length": "4",
            "ref": [
              "TABLE_2.COLUMN_17"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 2,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.50",
              "eval_cost": "0.20",
              "prefix_cost": "4.12",
              "data_read_per_join": "30K"
            },
            "used_columns": [
              "id",
              "COLUMN_23"
            ]
          }
        },
        {
          "duplicates_removal": {
            "using_temporary_table": true,
            "nested_loop": [
              {
                "table": {
                  "table_name": "TABLE_9",
                  "access_type": "ref",
                  "possible_keys": [
                    "customer_hash_index",
                    "deleted_idx"
                  ],
                  "key": "deleted_idx",
                  "used_key_parts": [
                    "deleted"
                  ],
                  "key_length": "1",
                  "ref": [
                    "const"
                  ],
                  "rows_examined_per_scan": 1,
                  "rows_produced_per_join": 2,
                  "filtered": "100.00",
                  "cost_info": {
                    "read_cost": "0.50",
                    "eval_cost": "0.20",
                    "prefix_cost": "4.83",
                    "data_read_per_join": "8K"
                  },
                  "used_columns": [
                    "id",
                    "COLUMN_17",
                    "status",
                    "system_profile",
                    "deleted"
                  ],
                  "attached_condition": "<if>(is_not_null_compl(TABLE_9..TABLE_4), ((`mollie_test_1`.`TABLE_9`.`COLUMN_35` = 0) and (`mollie_test_1`.`TABLE_9`.`COLUMN_33` = 9) and (`mollie_test_1`.`TABLE_9`.`COLUMN_17` = `TABLE_2`.`COLUMN_17`)), true)"
                }
              },
              {
                "table": {
                  "table_name": "TABLE_1",
                  "access_type": "eq_ref",
                  "possible_keys": [
                    "PRIMARY",
                    "can_login"
                  ],
                  "key": "PRIMARY",
                  "used_key_parts": [
                    "id"
                  ],
                  "key_length": "4",
                  "ref": [
                    "TABLE_2.COLUMN_17"
                  ],
                  "rows_examined_per_scan": 1,
                  "rows_produced_per_join": 2,
                  "filtered": "100.00",
                  "cost_info": {
                    "read_cost": "0.25",
                    "eval_cost": "0.20",
                    "prefix_cost": "6.23",
                    "data_read_per_join": "30K"
                  },
                  "used_columns": [
                    "id",
                    "actief",
                    "set_betaalverkeer_uit"
                  ],
                  "attached_condition": "<if>(is_not_null_compl(TABLE_9..TABLE_4), ((`mollie_test_1`.`TABLE_4`.`COLUMN_32` = 0) and (`mollie_test_1`.`TABLE_4`.`COLUMN_7` = '1')), true)"
                }
              },
              {
                "table": {
                  "table_name": "TABLE_6",
                  "access_type": "eq_ref",
                  "possible_keys": [
                    "PRIMARY",
                    "setting_name_lookup"
                  ],
                  "key": "PRIMARY",
                  "used_key_parts": [
                    "COLUMN_17",
                    "name"
                  ],
                  "key_length": "771",
                  "ref": [
                    "TABLE_2.COLUMN_17",
                    "const"
                  ],
                  "rows_examined_per_scan": 1,
                  "rows_produced_per_join": 2,
                  "filtered": "100.00",
                  "cost_info": {
                    "read_cost": "0.50",
                    "eval_cost": "0.20",
                    "prefix_cost": "7.38",
                    "data_read_per_join": "3K"
                  },
                  "used_columns": [
                    "COLUMN_17",
                    "name",
                    "value"
                  ]
                }
              },
              {
                "table": {
                  "table_name": "TABLE_7",
                  "access_type": "eq_ref",
                  "possible_keys": [
                    "COLUMN_17_x_COLUMN_29",
                    "requirements_set_result"
                  ],
                  "key": "COLUMN_17_x_COLUMN_29",
                  "used_key_parts": [
                    "COLUMN_17",
                    "COLUMN_29"
                  ],
                  "key_length": "771",
                  "ref": [
                    "TABLE_2.COLUMN_17",
                    "const"
                  ],
                  "rows_examined_per_scan": 1,
                  "rows_produced_per_join": 2,
                  "filtered": "100.00",
                  "cost_info": {
                    "read_cost": "0.50",
                    "eval_cost": "0.20",
                    "prefix_cost": "8.08",
                    "data_read_per_join": "1K"
                  },
                  "used_columns": [
                    "id",
                    "COLUMN_17",
                    "COLUMN_29",
                    "last_result"
                  ]
                }
              },
              {
                "table": {
                  "table_name": "TABLE_8",
                  "access_type": "eq_ref",
                  "possible_keys": [
                    "COLUMN_17_x_COLUMN_29",
                    "requirements_set_result"
                  ],
                  "key": "COLUMN_17_x_COLUMN_29",
                  "used_key_parts": [
                    "COLUMN_17",
                    "COLUMN_29"
                  ],
                  "key_length": "771",
                  "ref": [
                    "TABLE_2.COLUMN_17",
                    "const"
                  ],
                  "rows_examined_per_scan": 1,
                  "rows_produced_per_join": 2,
                  "filtered": "100.00",
                  "cost_info": {
                    "read_cost": "0.50",
                    "eval_cost": "0.20",
                    "prefix_cost": "8.78",
                    "data_read_per_join": "1K"
                  },
                  "used_columns": [
                    "id",
                    "COLUMN_17",
                    "COLUMN_29",
                    "last_result"
                  ]
                }
              }
            ]
          }
        }
      ]
    }
  }
}