"query_block": {
    "select_id": 1,
    "r_loops": 1,
    "r_total_time_ms": 0,
    "filesort": {
      "sort_key": "d0_.purchasable_variant desc, d1_.internal_amount_2 desc, d0_.`id`",
      "r_loops": 1,
      "r_total_time_ms": 0,
      "r_used_priority_queue": false,
      "r_output_rows": 13,
      "r_buffer_size": "880",
      "r_sort_mode": "sort_key,rowid",
      "temporary_table": {
        "table": {
          "table_name": "d2_",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "16",
          "used_key_parts": ["id"],
          "ref": ["const"],
          "r_loops": 0,
          "rows": 1,
          "r_rows": null,
          "filtered": 100,
          "r_filtered": null,
          "using_index": true
        },
        "table": {
          "table_name": "s3_",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "4",
          "used_key_parts": ["id"],
          "ref": ["const"],
          "r_loops": 0,
          "rows": 1,
          "r_rows": null,
          "filtered": 100,
          "r_filtered": null,
          "using_index": true
        },
        "table": {
          "table_name": "d0_",
          "access_type": "ref",
          "possible_keys": [
            "PRIMARY",
            "UNIQ_producer_code",
            "IDX_25A6FEBF89B658FE",
            "IDX_25A6FEBF79066886",
            "IDX_25A6FEBFDCD6110",
            "visible"
          ],
          "key": "UNIQ_producer_code",
          "key_length": "17",
          "used_key_parts": ["producer_id"],
          "ref": ["const"],
          "r_loops": 1,
          "rows": 13,
          "r_rows": 13,
          "r_table_time_ms": 0,
          "r_other_time_ms": 0,
          "filtered": 100,
          "r_filtered": 100,
          "index_condition": "d0_.producer_id = 0x90e7ac1f6bf1f375",
          "attached_condition": "d0_.producer_id <=> 0x90e7ac1f6bf1f375 and d0_.visible = 1 and d0_.root_id is not null"
        },
        "table": {
          "table_name": "d1_",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY", "IDX_internalAmount"],
          "key": "PRIMARY",
          "key_length": "16",
          "used_key_parts": ["id"],
          "ref": ["test.d0_.stock_id"],
          "r_loops": 13,
          "rows": 1,
          "r_rows": 1,
          "r_table_time_ms": 0,
          "r_other_time_ms": 0,
          "filtered": 1.2675,
          "r_filtered": 100,
          "attached_condition": "d1_.internal_amount > 0"
        },
        "table": {
          "table_name": "d4_",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY",
            "IDX_9E5EF6FD4584665A",
            "IDX_9E5EF6FD9DAFEFE6"
          ],
          "key": "PRIMARY",
          "key_length": "20",
          "used_key_parts": ["product_id", "structure_node_id"],
          "ref": ["test.d0_.id", "const"],
          "r_loops": 13,
          "rows": 1,
          "r_rows": 1,
          "r_table_time_ms": 0,
          "r_other_time_ms": 0,
          "filtered": 100,
          "r_filtered": 100,
          "using_index": true
        },
        "table": {
          "table_name": "<derived2>",
          "access_type": "ref",
          "possible_keys": ["key0"],
          "key": "key0",
          "key_length": "17",
          "used_key_parts": ["root_id"],
          "ref": ["test.d0_.root_id"],
          "r_loops": 13,
          "rows": 2,
          "r_rows": 1,
          "r_table_time_ms": 0,
          "r_other_time_ms": 0,
          "filtered": 100,
          "r_filtered": 100,
          "attached_condition": "subq.internal_amount_2 = d1_.internal_amount",
          "materialized": {
            "query_block": {
              "select_id": 2,
              "r_loops": 13,
              "r_total_time_ms": 0,
              "outer_ref_condition": "d0_.root_id is not null",
              "having_condition": "internal_amount_2 > 0",
              "table": {
                "table_name": "d2_",
                "access_type": "const",
                "possible_keys": ["PRIMARY"],
                "key": "PRIMARY",
                "key_length": "16",
                "used_key_parts": ["id"],
                "ref": ["const"],
                "r_loops": 0,
                "rows": 1,
                "r_rows": null,
                "filtered": 100,
                "r_filtered": null,
                "using_index": true
              },
              "table": {
                "table_name": "s3_",
                "access_type": "const",
                "possible_keys": ["PRIMARY"],
                "key": "PRIMARY",
                "key_length": "4",
                "used_key_parts": ["id"],
                "ref": ["const"],
                "r_loops": 0,
                "rows": 1,
                "r_rows": null,
                "filtered": 100,
                "r_filtered": null,
                "using_index": true
              },
              "table": {
                "table_name": "d0_",
                "access_type": "ref",
                "possible_keys": [
                  "PRIMARY",
                  "UNIQ_producer_code",
                  "IDX_25A6FEBF89B658FE",
                  "IDX_25A6FEBF79066886",
                  "IDX_25A6FEBFDCD6110",
                  "visible"
                ],
                "key": "IDX_25A6FEBF79066886",
                "key_length": "17",
                "used_key_parts": ["root_id"],
                "ref": ["test.d0_.root_id"],
                "rowid_filter": {
                  "range": {
                    "key": "IDX_25A6FEBF89B658FE",
                    "used_key_parts": ["producer_id"]
                  },
                  "rows": 13,
                  "selectivity_pct": 0.0384,
                  "r_rows": 13,
                  "r_selectivity_pct": 100,
                  "r_buffer_size": 26,
                  "r_filling_time_ms": 0
                },
                "r_loops": 13,
                "rows": 4,
                "r_rows": 1,
                "r_table_time_ms": 0,
                "r_other_time_ms": 0,
                "filtered": 50,
                "r_filtered": 100,
                "attached_condition": "d0_.visible = 1 and d0_.producer_id = 0x90e7ac1f6bf1f375"
              },
              "table": {
                "table_name": "d1_",
                "access_type": "eq_ref",
                "possible_keys": ["PRIMARY", "IDX_internalAmount"],
                "key": "PRIMARY",
                "key_length": "16",
                "used_key_parts": ["id"],
                "ref": ["test.d0_.stock_id"],
                "r_loops": 13,
                "rows": 1,
                "r_rows": 1,
                "r_table_time_ms": 0,
                "r_other_time_ms": 0,
                "filtered": 1.2675,
                "r_filtered": 100,
                "attached_condition": "d1_.internal_amount > 0"
              },
              "table": {
                "table_name": "d4_",
                "access_type": "eq_ref",
                "possible_keys": [
                  "PRIMARY",
                  "IDX_9E5EF6FD4584665A",
                  "IDX_9E5EF6FD9DAFEFE6"
                ],
                "key": "PRIMARY",
                "key_length": "20",
                "used_key_parts": ["product_id", "structure_node_id"],
                "ref": ["test.d0_.id", "const"],
                "r_loops": 13,
                "rows": 1,
                "r_rows": 1,
                "r_table_time_ms": 0,
                "r_other_time_ms": 0,
                "filtered": 100,
                "r_filtered": 100,
                "using_index": true
              }
            }
          }
        }
      }
    }
  }