{
  "query_block": {
    "select_id": 1,
    "r_loops": 1,
    "r_total_time_ms": 115.4217044,
    "const_condition": "1",
    "window_functions_computation": {
      "sorts": {
        "filesort": {
          "sort_key": "max(stats.p.coins) desc",
          "r_loops": 1,
          "r_total_time_ms": 0.002775319,
          "r_used_priority_queue": false,
          "r_output_rows": 1,
          "r_buffer_size": "320",
          "r_sort_mode": "sort_key,rowid"
        }
      },
      "temporary_table": {
        "table": {
          "table_name": "p",
          "access_type": "index",
          "key": "unique_uuid_coins",
          "key_length": "150",
          "used_key_parts": ["uuid", "coins"],
          "r_loops": 1,
          "rows": 1772,
          "r_rows": 1772,
          "r_table_time_ms": 0.442582891,
          "r_other_time_ms": 0.190843384,
          "filtered": 100,
          "r_filtered": 100,
          "using_index": true
        },
        "block-nl-join": {
          "table": {
            "table_name": "<derived2>",
            "access_type": "ALL",
            "r_loops": 1,
            "rows": 334,
            "r_rows": 234,
            "r_table_time_ms": 0.017516686,
            "r_other_time_ms": 114.5703855,
            "filtered": 100,
            "r_filtered": 100
          },
          "buffer_type": "flat",
          "buffer_size": "256Kb",
          "join_type": "BNL",
          "attached_condition": "trigcond(stats.p.uuid = convert(b.uuid using utf8mb4))",
          "r_filtered": 0.427350427,
          "materialized": {
            "query_block": {
              "select_id": 2,
              "r_loops": 1,
              "r_total_time_ms": 0.216223472,
              "table": {
                "table_name": "bans",
                "access_type": "index",
                "key": "idx_bans_uuid",
                "key_length": "111",
                "used_key_parts": ["uuid"],
                "r_loops": 1,
                "rows": 334,
                "r_rows": 334,
                "r_table_time_ms": 0.080273077,
                "r_other_time_ms": 0.100695803,
                "filtered": 100,
                "r_filtered": 100,
                "using_index": true
              }
            }
          }
        }
      }
    }
  }
}