# ======================================
  # 租户相关
  # ======================================
  
  ### 1. 根据 tenant_id / spu_id 查询

  curl -u 'essa: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} },
            { "term": { "tenant_id": "170" } }
          ]
        }
      }
    }'
  
  

  curl -u 'essa:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products/_search?pretty'   -H 'Content-Type: application/json'   -d '{

      "size": 100,

      "_source": ["title"],

      "query": {
        "bool": {
          "filter": [

            { "term": { "tenant_id": "170" } }

          ]
        }
      }

    }'
  

  
  curl -u 'essa:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products_tenant_170/_search?pretty'   -H 'Content-Type: application/json'   -d '{
      "size": 5,
      "_source": ["title", "keyword", "keyword.zh", "tags"],
      "query": {
        "bool": {
          "filter": [
            { "term": { "spu_id": "223167" } }
          ]
        }
      }
    }'
  
  
  curl -u 'essa:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products_tenant_170/_search?pretty'   -H 'Content-Type: application/json'   -d '{
      "size": 1,
      "_source": ["title", "keyword", "keyword.zh", "tags"],
      "query": {
        "bool": {
          "must": [
            {
              "match": {
                "title.en": {
                  "query": "Floerns Women Gothic Graphic Ribbed Strapless Tube Top Asymmetrical Ruched Bandeau Tops"
                }
              }
            }
          ],
          "filter": [
            { "term": { "tenant_id": "170" } },
            { "terms": { "tags": ["女装", "派对"] } }
          ]
        }
      }
  }'
  
  
  curl -u 'essa: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 'essa:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products/_analyze'   -H 'Content-Type: application/json'   -d '{

    "analyzer": "icu_analyzer",

    "text": "14寸第4代-眼珠实身冰雪公仔带手动大推车,搪胶雪宝宝"
  }'
  
  curl -u 'essa:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products/_analyze'   -H 'Content-Type: application/json'   -d '{
    "analyzer": "hanlp_standard",
    "text": "14寸第4代-眼珠实身冰雪公仔带手动大推车,搪胶雪宝宝"
  }'
  
  curl -u 'essa:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products/_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": [
          {
            "term": {
              "tenant_id": "170"
            }
          }
        ]
      }
    }
  }'
  
  curl -u 'essa:4hOaLaf41y2VuI8y'   -X GET 'http://localhost:9200/search_products/_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": [
          {
            "term": {
              "tenant_id": "170"
            }
          }
        ]
      }
    },
    "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/_search
  {
    "query": {
      "term": {
        "tenant_id": "2"
      }
    }
  }

  
  
  curl -u 'essa: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 'essa:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products/_count?pretty' -H 'Content-Type: application/json' -d '{
    "query": {
      "term": {

        "tenant_id": "170"

      }
    }
  }'
  
  

  # ======================================
  # 分面数据诊断相关查询
  # ======================================
  
  ## 1. 检查ES文档的分面字段数据
  
  ### 1.1 查询特定租户的商品，显示分面相关字段
  curl -u 'essa:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products/_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 'essa: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": "category1_name" } }
        ]
      }
    },
    "size": 0
  }'
  
  ### 1.3 验证specifications字段是否有数据
  curl -u 'essa: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": 0
  }'
  
  ## 2. 分面聚合查询（Facet Aggregations）
  
  ### 2.1 category1_name 分面聚合
  curl -u 'essa:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products/_search?pretty' -H 'Content-Type: application/json' -d '{
    "query": {
      "term": {
        "tenant_id": "162"
      }
    },
    "size": 0,
    "aggs": {
      "category1_name_facet": {
        "terms": {
          "field": "category1_name.keyword",
          "size": 50
        }
      }
    }
  }'
  
  ### 2.2 specifications.color 分面聚合
  curl -u 'essa: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_color_facet": {
        "nested": {
          "path": "specifications"
        },
        "aggs": {
          "filtered": {
            "filter": {
              "term": {
                "specifications.name": "color"
              }
            },
            "aggs": {
              "values": {
                "terms": {
                  "field": "specifications.value.keyword",
                  "size": 50
                }
              }
            }
          }
        }
      }
    }
  }'
  
  ### 2.3 specifications.size 分面聚合
  curl -u 'essa: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_size_facet": {
        "nested": {
          "path": "specifications"
        },
        "aggs": {
          "filtered": {
            "filter": {
              "term": {
                "specifications.name": "size"
              }
            },
            "aggs": {
              "values": {
                "terms": {
                  "field": "specifications.value.keyword",
                  "size": 50
                }
              }
            }
          }
        }
      }
    }
  }'
  
  ### 2.4 specifications.material 分面聚合
  curl -u 'essa: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_material_facet": {
        "nested": {
          "path": "specifications"
        },
        "aggs": {
          "filtered": {
            "filter": {
              "term": {
                "specifications.name": "material"
              }
            },
            "aggs": {
              "values": {
                "terms": {
                  "field": "specifications.value.keyword",
                  "size": 50
                }
              }
            }
          }
        }
      }
    }
  }'
  
  ### 2.5 综合分面聚合（category + color + size + material）
  curl -u 'essa:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products/_search?pretty' -H 'Content-Type: application/json' -d '{
    "query": {
      "term": {
        "tenant_id": "162"
      }
    },
    "size": 0,
    "aggs": {
      "category1_name_facet": {
        "terms": {
          "field": "category1_name.keyword",
          "size": 50
        }
      },
      "specifications_color_facet": {
        "nested": {
          "path": "specifications"
        },
        "aggs": {
          "filtered": {
            "filter": {
              "term": {
                "specifications.name": "color"
              }
            },
            "aggs": {
              "values": {
                "terms": {
                  "field": "specifications.value.keyword",
                  "size": 50
                }
              }
            }
          }
        }
      },
      "specifications_size_facet": {
        "nested": {
          "path": "specifications"
        },
        "aggs": {
          "filtered": {
            "filter": {
              "term": {
                "specifications.name": "size"
              }
            },
            "aggs": {
              "values": {
                "terms": {
                  "field": "specifications.value.keyword",
                  "size": 50
                }
              }
            }
          }
        }
      },
      "specifications_material_facet": {
        "nested": {
          "path": "specifications"
        },
        "aggs": {
          "filtered": {
            "filter": {
              "term": {
                "specifications.name": "material"
              }
            },
            "aggs": {
              "values": {
                "terms": {
                  "field": "specifications.value.keyword",
                  "size": 50
                }
              }
            }
          }
        }
      }
    }
  }'
  
  ## 3. 检查specifications嵌套字段的详细结构
  
  ### 3.1 查看specifications的name字段有哪些值
  curl -u 'essa: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 'essa: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 'essa:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products/_count?pretty' -H 'Content-Type: application/json' -d '{
    "query": {
      "bool": {
        "filter": [
          { "term": { "tenant_id": "162" } },
          { "exists": { "field": "category1_name" } }
        ]
      }
    }
  }'
  
  ### 4.2 统计有specifications的文档数量
  curl -u 'essa:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products/_count?pretty' -H 'Content-Type: application/json' -d '{
    "query": {
      "bool": {
        "filter": [
          { "term": { "tenant_id": "162" } },
          { "exists": { "field": "specifications" } }
        ]
      }
    }
  }'
  

  
  ## 5. 诊断问题场景
  
  ### 5.1 查找没有category1_name但有category的文档（MySQL有数据但ES没有）
  curl -u 'essa:4hOaLaf41y2VuI8y' -X GET 'http://localhost:9200/search_products/_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 'essa: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": "option1_name" } }
        ],
        "must_not": [
          { "exists": { "field": "specifications" } }
        ]
      }
    },
    "size": 10,

    "_source": ["spu_id", "title", "option1_name", "option2_name", "option3_name", "specifications"]

  }'
  
  

  重排序：
  GET /search_products/_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
                      }
                  }
              }
          }
      }
  }