docs/%E5%B8%B8%E7%94%A8%E6%9F%A5%E8%AF%A2%20-%20ES.md

# ======================================
# 租户相关
# ======================================
#
# 说明：索引已按租户拆分为 search_products_tenant_{tenant_id}，
# 一般情况下不需要在查询中再按 tenant_id 过滤（可选保留用于排查）。
### 1. 根据 tenant_id / spu_id 查询
curl -u 'saas:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products_tenant_170/_search?pretty'   -H 'Content-Type: application/json'   -d '{
    "size": 11,
    "_source": ["title"],
    "query": {
      "bool": {
        "filter": [
          { "term": {"spu_id" : 206150} }
        ]
      }
    }
  }'
curl -u 'saas:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products_tenant_170/_search?pretty'   -H 'Content-Type: application/json'   -d '{
  "size": 100,
  "_source": ["title"],
  "query": {
    "match_all": {}
  }
}'
curl -u 'saas:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products_tenant_170/_search?pretty'   -H 'Content-Type: application/json'   -d '{
  "size": 5,
  "_source": ["title", "keywords", "tags"],
  "query": {
    "bool": {
      "filter": [
        { "term": { "spu_id": "223167" } }
      ]
    }
  }
}'
curl -u 'saas:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products_tenant_170/_search?pretty'   -H 'Content-Type: application/json'   -d '{
  "size": 1,
  "_source": ["title", "keywords", "tags"],
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "title.en": {
              "query": "Floerns Women Gothic Graphic Ribbed Strapless Tube Top Asymmetrical Ruched Bandeau Tops"
            }
          }
        }
      ],
      "filter": [
        { "terms": { "tags": ["女装", "派对"] } }
      ]
    }
  }
}'
curl -u 'saas:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products_tenant_170/_search?pretty'   -H 'Content-Type: application/json'   -d '{
    "size": 1,
    "_source": ["title"],
    "query": {
      "bool": {
        "must": [
          {
            "match": {
              "title.en": {
                "query": "Floerns Women Gothic Graphic Ribbed Strapless Tube Top Asymmetrical Ruched Bandeau Tops"
              }
            }
          }
        ],
        "filter": [
          { "term": { "tenant_id": "170" } }
        ]
      }
    }
}'
Curl -u 'saas:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products_tenant_170/_analyze'   -H 'Content-Type: application/json'   -d '{
  "analyzer": "index_ansj",
  "text": "14寸第4代-眼珠实身冰雪公仔带手动大推车,搪胶雪宝宝"
}'
curl -u 'saas:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products_tenant_170/_analyze'   -H 'Content-Type: application/json'   -d '{
  "analyzer": "query_ansj",
  "text": "14寸第4代-眼珠实身冰雪公仔带手动大推车,搪胶雪宝宝"
}'
curl -u 'saas:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products_tenant_170/_search?pretty'   -H 'Content-Type: application/json'   -d '{
  "size": 100,
  "from": 0,
  "query": {
    "bool": {
      "must": [
        {
          "multi_match": {
            "_name": "base_query",
            "fields": [
              "title.zh^3.0",
              "brief.zh^1.5",
              "description.zh",
              "vendor.zh^1.5",
              "tags",
              "category_path.zh^1.5",
              "category_name_text.zh^1.5",
              "option1_values^0.5"
            ],
            "minimum_should_match": "75%",
            "operator": "AND",
            "query": "裙",
            "tie_breaker": 0.9
          }
        }
      ],
      "filter": [
        {
          "match_all": {}
        }
      ]
    }
  }
}'
curl -u 'saas:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products_tenant_170/_search?pretty'   -H 'Content-Type: application/json'   -d '{
  "size": 1,
  "from": 0,
  "query": {
    "bool": {
      "must": [
        {
          "multi_match": {
            "_name": "base_query",
            "fields": [
              "title.zh^3.0",
              "brief.zh^1.5",
              "description.zh",
              "vendor.zh^1.5",
              "tags",
              "category_path.zh^1.5",
              "category_name_text.zh^1.5",
              "option1_values^0.5"
            ],
            "minimum_should_match": "75%",
            "operator": "AND",
            "query": "裙",
            "tie_breaker": 0.9
          }
        }
      ],
      "filter": [
        { "match_all": {} }
      ]
    }
  },
  "aggs": {
    "category1_name_facet": {
      "terms": {
        "field": "category1_name",
        "size": 15,
        "order": {
          "_count": "desc"
        }
      }
    },
    "specifications_color_facet": {
      "nested": {
        "path": "specifications"
      },
      "aggs": {
        "filter_by_name": {
          "filter": {
            "term": {
              "specifications.name": "color"
            }
          },
          "aggs": {
            "value_counts": {
              "terms": {
                "field": "specifications.value",
                "size": 20,
                "order": {
                  "_count": "desc"
                }
              }
            }
          }
        }
      }
    },
    "specifications_size_facet": {
      "nested": {
        "path": "specifications"
      },
      "aggs": {
        "filter_by_name": {
          "filter": {
            "term": {
              "specifications.name": "size"
            }
          },
          "aggs": {
            "value_counts": {
              "terms": {
                "field": "specifications.value",
                "size": 15,
                "order": {
                  "_count": "desc"
                }
              }
            }
          }
        }
      }
    },
    "specifications_material_facet": {
      "nested": {
        "path": "specifications"
      },
      "aggs": {
        "filter_by_name": {
          "filter": {
            "term": {
              "specifications.name": "material"
            }
          },
          "aggs": {
            "value_counts": {
              "terms": {
                "field": "specifications.value",
                "size": 10,
                "order": {
                  "_count": "desc"
                }
              }
            }
          }
        }
      }
    }
  }
}'
GET /search_products_tenant_2/_search
{
  "query": {
    "match_all": {}
  }
}
curl -u 'saas:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products/_search?pretty'   -H 'Content-Type: application/json'   -d '{
    "size": 5,
    "query": {
      "bool": {
        "filter": [
          { "term": { "spu_id": "74123" } }
        ]
      }
    }
  }'
### 2. 统计租户的总文档数
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_170/_count?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "match_all": {}
  }
}'
# ======================================
# 分面数据诊断相关查询
# ======================================
## 1. 检查ES文档的分面字段数据
### 1.1 查询特定租户的商品，显示分面相关字段
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_162/_search?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "term": {
      "tenant_id": "162"
    }
  },
  "size": 1,
  "_source": [
    "spu_id", 
    "title", 
    "category1_name", 
    "category2_name",
    "category3_name",
    "specifications", 
    "option1_name",
    "option2_name",
    "option3_name"
  ]
}'
### 1.2 验证category1_name字段是否有数据
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_162/_search?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "bool": {
      "filter": [
        { "term": { "tenant_id": "162" } },
        { "exists": { "field": "category1_name" } }
      ]
    }
  },
  "size": 0
}'
### 1.3 验证specifications字段是否有数据
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_162/_search?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "bool": {
      "filter": [
        { "term": { "tenant_id": "162" } },
        { "exists": { "field": "specifications" } }
      ]
    }
  },
  "size": 0
}'
## 2. 分面聚合查询（Facet Aggregations）
### 2.1 category1_name 分面聚合
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_162/_search?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "match_all": {}
  },
  "size": 0,
  "aggs": {
    "category1_name_facet": {
      "terms": {
        "field": "category1_name",
        "size": 50
      }
    }
  }
}'
### 2.2 specifications.color 分面聚合
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_162/_search?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "match_all": {}
  },
  "size": 0,
  "aggs": {
    "specifications_color_facet": {
      "nested": {
        "path": "specifications"
      },
      "aggs": {
        "filtered": {
          "filter": {
            "term": {
              "specifications.name": "color"
            }
          },
          "aggs": {
            "values": {
              "terms": {
                "field": "specifications.value",
                "size": 50
              }
            }
          }
        }
      }
    }
  }
}'
### 2.3 specifications.size 分面聚合
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_162/_search?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "match_all": {}
  },
  "size": 0,
  "aggs": {
    "specifications_size_facet": {
      "nested": {
        "path": "specifications"
      },
      "aggs": {
        "filtered": {
          "filter": {
            "term": {
              "specifications.name": "size"
            }
          },
          "aggs": {
            "values": {
              "terms": {
                "field": "specifications.value",
                "size": 50
              }
            }
          }
        }
      }
    }
  }
}'
### 2.4 specifications.material 分面聚合
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_162/_search?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "match_all": {}
  },
  "size": 0,
  "aggs": {
    "specifications_material_facet": {
      "nested": {
        "path": "specifications"
      },
      "aggs": {
        "filtered": {
          "filter": {
            "term": {
              "specifications.name": "material"
            }
          },
          "aggs": {
            "values": {
              "terms": {
                "field": "specifications.value",
                "size": 50
              }
            }
          }
        }
      }
    }
  }
}'
### 2.5 综合分面聚合（category + color + size + material）
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_162/_search?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "match_all": {}
  },
  "size": 0,
  "aggs": {
    "category1_name_facet": {
      "terms": {
        "field": "category1_name",
        "size": 50
      }
    },
    "specifications_color_facet": {
      "nested": {
        "path": "specifications"
      },
      "aggs": {
        "filtered": {
          "filter": {
            "term": {
              "specifications.name": "color"
            }
          },
          "aggs": {
            "values": {
              "terms": {
                "field": "specifications.value",
                "size": 50
              }
            }
          }
        }
      }
    },
    "specifications_size_facet": {
      "nested": {
        "path": "specifications"
      },
      "aggs": {
        "filtered": {
          "filter": {
            "term": {
              "specifications.name": "size"
            }
          },
          "aggs": {
            "values": {
              "terms": {
                "field": "specifications.value",
                "size": 50
              }
            }
          }
        }
      }
    },
    "specifications_material_facet": {
      "nested": {
        "path": "specifications"
      },
      "aggs": {
        "filtered": {
          "filter": {
            "term": {
              "specifications.name": "material"
            }
          },
          "aggs": {
            "values": {
              "terms": {
                "field": "specifications.value",
                "size": 50
              }
            }
          }
        }
      }
    }
  }
}'
## 3. 检查specifications嵌套字段的详细结构
### 3.1 查看specifications的name字段有哪些值
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products/_search?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "term": {
      "tenant_id": "162"
    }
  },
  "size": 0,
  "aggs": {
    "specifications_names": {
      "nested": {
        "path": "specifications"
      },
      "aggs": {
        "name_values": {
          "terms": {
            "field": "specifications.name",
            "size": 20
          }
        }
      }
    }
  }
}'
### 3.2 查看某个商品的完整specifications数据
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products/_search?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "bool": {
      "filter": [
        { "term": { "tenant_id": "162" } },
        { "exists": { "field": "specifications" } }
      ]
    }
  },
  "size": 1,
  "_source": ["spu_id", "title", "specifications"]
}'
## 4. 统计查询
### 4.1 统计有category1_name的文档数量
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_162/_count?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "bool": {
      "filter": [
        { "exists": { "field": "category1_name" } }
      ]
    }
  }
}'
### 4.2 统计有specifications的文档数量
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_162/_count?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "bool": {
      "filter": [
        { "exists": { "field": "specifications" } }
      ]
    }
  }
}'
## 5. 诊断问题场景
### 5.1 查找没有category1_name但有category的文档（MySQL有数据但ES没有）
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_162/_search?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "bool": {
      "filter": [
        { "term": { "tenant_id": "162" } }
      ],
      "must_not": [
        { "exists": { "field": "category1_name" } }
      ]
    }
  },
  "size": 10,
  "_source": ["spu_id", "title", "category_name_text", "category_path"]
}'
### 5.2 查找有option但没有specifications的文档（数据转换问题）
curl -u 'saas:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products_tenant_162/_search?pretty' -H 'Content-Type: application/json' -d '{
  "query": {
    "bool": {
      "filter": [
        { "term": { "tenant_id": "162" } },
        { "exists": { "field": "option1_name" } }
      ],
      "must_not": [
        { "exists": { "field": "specifications" } }
      ]
    }
  },
  "size": 10,
  "_source": ["spu_id", "title", "option1_name", "option2_name", "option3_name", "specifications"]
}'
重排序：
GET /search_products_tenant_170/_search
{
    "query": {
        "match": {  
            "title.en": {
                "query": "quick brown fox",
                "minimum_should_match": "90%"
            }
        }
    },
    "rescore": {
        "window_size": 50, 
        "query": {         
            "rescore_query": {
                "match_phrase": {
                    "title.en": {
                        "query": "quick brown fox",
                        "slop":  50
                    }
                }
            }
        }
    }
}