{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "97.00"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "num",
          "access_type": "ALL",
          "rows_examined_per_scan": 60,
          "rows_produced_per_join": 60,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "13.00",
            "eval_cost": "12.00",
            "prefix_cost": "25.00",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "lot_id",
            "participants_count"
          ],
          "materialized_from_subquery": {
            "using_temporary_table": true,
            "dependent": false,
            "cacheable": true,
            "query_block": {
              "select_id": 2,
              "cost_info": {
                "query_cost": "257.00"
              },
              "grouping_operation": {
                "using_temporary_table": true,
                "using_filesort": true,
                "nested_loop": [
                  {
                    "table": {
                      "table_name": "ab",
                      "access_type": "ALL",
                      "possible_keys": [
                        "PRIMARY",
                        "lot_id"
                      ],
                      "rows_examined_per_scan": 600,
                      "rows_produced_per_join": 60,
                      "filtered": "10.00",
                      "cost_info": {
                        "read_cost": "113.00",
                        "eval_cost": "12.00",
                        "prefix_cost": "125.00",
                        "data_read_per_join": "50K"
                      },
                      "used_columns": [
                        "id",
                        "lot_id",
                        "status"
                      ],
                      "attached_condition": "(`test`.`ab`.`status` = 1)"
                    }
                  },
                  {
                    "table": {
                      "table_name": "temp",
                      "access_type": "eq_ref",
                      "possible_keys": [
                        "PRIMARY"
                      ],
                      "key": "PRIMARY",
                      "used_key_parts": [
                        "ab_id"
                      ],
                      "key_length": "4",
                      "ref": [
                        "test.ab.id"
                      ],
                      "rows_examined_per_scan": 1,
                      "rows_produced_per_join": 60,
                      "filtered": "100.00",
                      "using_index": true,
                      "cost_info": {
                        "read_cost": "60.00",
                        "eval_cost": "12.00",
                        "prefix_cost": "197.00",
                        "data_read_per_join": "480"
                      },
                      "used_columns": [
                        "ab_id"
                      ]
                    }
                  }
                ]
              }
            }
          }
        }
      },
      {
        "table": {
          "update": true,
          "table_name": "filter",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "lot_id",
            "lot_type"
          ],
          "key_length": "8",
          "ref": [
            "num.lot_id",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 60,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "60.00",
            "eval_cost": "12.00",
            "prefix_cost": "97.00",
            "data_read_per_join": "960"
          },
          "used_columns": [
            "lot_id",
            "lot_type",
            "participants_count"
          ]
        }
      }
    ]
  }
}