ANALYZE
{
  "query_block": {
    "select_id": 1,
    "r_loops": 1,
    "r_total_time_ms": 0.4946,
    "filesort": {
      "r_loops": 1,
      "r_total_time_ms": 0.0055,
      "r_limit": 30,
      "r_used_priority_queue": false,
      "r_output_rows": 7,
      "r_buffer_size": "340",
      "temporary_table": {
        "table": {
          "table_name": "p",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "r_loops": 1,
          "rows": 69,
          "r_rows": 70,
          "r_total_time_ms": 0.054,
          "filtered": 100,
          "r_filtered": 10,
          "attached_condition": "((p.date_effective <= 2018-03-08) and (p.date_expiry >= 2018-03-08) and (p.position_essential > 0))"
        },
        "table": {
          "table_name": "<subquery2>",
          "access_type": "eq_ref",
          "possible_keys": ["distinct_key"],
          "key": "distinct_key",
          "key_length": "4",
          "used_key_parts": ["id_promo"],
          "ref": ["func"],
          "r_loops": 7,
          "rows": 1,
          "r_rows": 1,
          "r_total_time_ms": 0.0827,
          "filtered": 100,
          "r_filtered": 100,
          "materialized": {
            "unique": 1,
            "query_block": {
              "select_id": 2,
              "table": {
                "table_name": "cg",
                "access_type": "ref",
                "possible_keys": ["PRIMARY", "customer_login", "id_customer"],
                "key": "PRIMARY",
                "key_length": "4",
                "used_key_parts": ["id_customer"],
                "ref": ["const"],
                "r_loops": 1,
                "rows": 1,
                "r_rows": 1,
                "r_total_time_ms": 0.0046,
                "filtered": 100,
                "r_filtered": 100,
                "using_index": true
              },
              "block-nl-join": {
                "table": {
                  "table_name": "pg",
                  "access_type": "ALL",
                  "r_loops": 1,
                  "rows": 541,
                  "r_rows": 541,
                  "r_total_time_ms": 0.1778,
                  "filtered": 100,
                  "r_filtered": 100
                },
                "buffer_type": "flat",
                "buffer_size": "256Kb",
                "join_type": "BNL",
                "r_filtered": 100
              }
            }
          }
        }
      }
    }
  }
}