{
  "query_block": {
    "select_id": 1,
    "filesort": {
      "sort_key": "p.`ID`, tr.object_id, t.term_id, t.`name`",
      "temporary_table": {
        "table": {
          "table_name": "xt",
          "access_type": "ref",
          "possible_keys": ["PRIMARY", "term_id_taxonomy", "taxonomy"],
          "key": "taxonomy",
          "key_length": "130",
          "used_key_parts": ["taxonomy"],
          "ref": ["const"],
          "rows": 254,
          "filtered": 100,
          "index_condition": "xt.taxonomy = 'pa_brand_master'"
        },
        "table": {
          "table_name": "t",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "8",
          "used_key_parts": ["term_id"],
          "ref": ["local.xt.term_id"],
          "rows": 1,
          "filtered": 100
        },
        "table": {
          "table_name": "tr",
          "access_type": "ref",
          "possible_keys": ["PRIMARY", "term_taxonomy_id"],
          "key": "term_taxonomy_id",
          "key_length": "8",
          "used_key_parts": ["term_taxonomy_id"],
          "ref": ["local.xt.term_taxonomy_id"],
          "rows": 6,
          "filtered": 100,
          "using_index": true
        },
        "block-nl-join": {
          "table": {
            "table_name": "p",
            "access_type": "index",
            "possible_keys": ["PRIMARY", "post_parent"],
            "key": "post_parent",
            "key_length": "172",
            "used_key_parts": ["post_parent", "post_type", "post_status"],
            "rows": 41478,
            "filtered": 100,
            "attached_condition": "p.post_type like '%product%' and p.post_status = 'publish'",
            "using_index": true
          },
          "buffer_type": "flat",
          "buffer_size": "1560Kb",
          "join_type": "BNL",
          "attached_condition": "p.`ID` = tr.object_id or p.post_parent = tr.object_id"
        },
        "table": {
          "table_name": "trs",
          "access_type": "ref",
          "possible_keys": ["PRIMARY", "term_taxonomy_id"],
          "key": "PRIMARY",
          "key_length": "8",
          "used_key_parts": ["object_id"],
          "ref": ["local.p.ID"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(trs.term_taxonomy_id is not null)",
          "using_index": true
        },
        "table": {
          "table_name": "xs",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY", "term_id_taxonomy", "taxonomy"],
          "key": "PRIMARY",
          "key_length": "8",
          "used_key_parts": ["term_taxonomy_id"],
          "ref": ["local.trs.term_taxonomy_id"],
          "rows": 1,
          "filtered": 0.0415,
          "attached_condition": "trigcond(xs.taxonomy in ('pa_size','pa_megethos','pa_noumero') and xs.term_id is not null)"
        },
        "table": {
          "table_name": "ts",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "8",
          "used_key_parts": ["term_id"],
          "ref": ["local.xs.term_id"],
          "rows": 1,
          "filtered": 100
        },
        "table": {
          "table_name": "trc",
          "access_type": "ref",
          "possible_keys": ["PRIMARY", "term_taxonomy_id"],
          "key": "PRIMARY",
          "key_length": "8",
          "used_key_parts": ["object_id"],
          "ref": ["local.p.ID"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(trc.term_taxonomy_id is not null)",
          "using_index": true
        },
        "table": {
          "table_name": "xc",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY", "term_id_taxonomy", "taxonomy"],
          "key": "PRIMARY",
          "key_length": "8",
          "used_key_parts": ["term_taxonomy_id"],
          "ref": ["local.trc.term_taxonomy_id"],
          "rows": 1,
          "filtered": 0.332,
          "attached_condition": "trigcond(xc.taxonomy in ('pa_color','pa_chroma','pa_colour') and xc.term_id is not null)"
        },
        "table": {
          "table_name": "tc",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "8",
          "used_key_parts": ["term_id"],
          "ref": ["local.xc.term_id"],
          "rows": 1,
          "filtered": 100
        }
      }
    }
  }
}