"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": "<derived2>",
          "access_type": "ALL",
          "r_loops": 1,
          "rows": 13,
          "r_rows": 13,
          "r_table_time_ms": 0,
          "r_other_time_ms": 0,
          "filtered": 0,
          "r_filtered": 100,
          "attached_condition": "subq.internal_amount_2 > 0 and subq.internal_amount_2 is not null",
          "materialized": {
            "query_block": {
              "select_id": 2,
              "r_loops": 1,
              "r_total_time_ms": 0,
              "having_condition": "internal_amount_2 > 0",
              "filesort": {
                "sort_key": "d0_.root_id",
                "r_loops": 1,
                "r_total_time_ms": 0,
                "r_used_priority_queue": false,
                "r_output_rows": 13,
                "r_buffer_size": "760",
                "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": "IDX_25A6FEBF89B658FE",
                    "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"
                  },
                  "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": "d4_",
          "access_type": "ref",
          "possible_keys": [
            "PRIMARY",
            "IDX_9E5EF6FD4584665A",
            "IDX_9E5EF6FD9DAFEFE6"
          ],
          "key": "IDX_9E5EF6FD9DAFEFE6",
          "key_length": "4",
          "used_key_parts": ["structure_node_id"],
          "ref": ["const"],
          "r_loops": 13,
          "rows": 71488,
          "r_rows": 34266,
          "r_table_time_ms": 0,
          "r_other_time_ms": 0,
          "filtered": 100,
          "r_filtered": 100,
          "using_index": true
        },
        "table": {
          "table_name": "d1_",
          "access_type": "ref",
          "possible_keys": ["PRIMARY", "IDX_internalAmount"],
          "key": "IDX_internalAmount",
          "key_length": "4",
          "used_key_parts": ["internal_amount"],
          "ref": ["subq.internal_amount_2"],
          "r_loops": 445458,
          "rows": 566,
          "r_rows": 37.923,
          "r_table_time_ms": 0,
          "r_other_time_ms": 0,
          "filtered": 100,
          "r_filtered": 100
        },
        "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": 16893138,
          "rows": 13,
          "r_rows": 3.8e-4,
          "r_table_time_ms": 0,
          "r_other_time_ms": 0,
          "filtered": 100,
          "r_filtered": 0.2028,
          "index_condition": "d0_.producer_id = 0x90e7ac1f6bf1f375 and d0_.`id` = d4_.product_id",
          "attached_condition": "d0_.visible = 1 and d0_.root_id = subq.root_id and d0_.stock_id = d1_.`id`"
        }
      }
    }
  }