深圳智汇创想科技有限公司

修改了 解决时效，旧值为 "0"，新值为 "-1"。
修改了 Bug标题 ，区别为：

001- SP广告 企业购 产品名称搜索报错
001+ SP广告 企业购 和受众产品名称搜索报错

001- SP广告 企业购 产品名称搜索报错
001+ SP广告 企业购 和受众产品名称搜索报错

修改了 重现步骤，区别为：

003- { "success": false, "errCode": "10000500", "errMessage": "[500 ] during [POST] to [http://zhcxkj-center-adv-amazon/spAdPlacementBusiness/sum] [ISpAdCampaignOpenApi#spAdPlacementBusinessSum(SpAdPlacemenPageQry)]: [{"success":false,"errCode":"10000500","errMessage":"\\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: StarRocks planner use long time 3000 ms in memo phase, This probably becaus... (28141 bytes)]"}
003+ { "success": false, "errCode": "10000500", "errMessage": "[500 ] during [POST] to [http://zhcxkj-center-adv-amazon/spAdPlacementBusiness/sum] [ISpAdCampaignOpenApi#spAdPlacementBusinessSum(SpAdPlacemenPageQry)]: [{"success":false,"errCode":"10000500","errMessage":"\\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: StarRocks planner use long time 3000 ms in memo phase, This probably becaus... (28141 bytes)]"}
004+
005+

003- <p>{<br /> "success": false,<br /> "errCode": "10000500",<br /> "errMessage": "[500 ] during [POST] to [http://zhcxkj-center-adv-amazon/spAdPlacementBusiness/sum] [ISpAdCampaignOpenApi#spAdPlacementBusinessSum(SpAdPlacemenPageQry)]: [{"success":false,"errCode":"10000500","errMessage":"\\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: StarRocks planner use long time 3000 ms in memo phase, This probably becaus... (28141 bytes)]"<br />}<br /><img src="{583174.png}" alt="" /></p>
003+ <p>{<br /> "success": false,<br /> "errCode": "10000500",<br /> "errMessage": "[500 ] during [POST] to [http://zhcxkj-center-adv-amazon/spAdPlacementBusiness/sum] [ISpAdCampaignOpenApi#spAdPlacementBusinessSum(SpAdPlacemenPageQry)]: [{"success":false,"errCode":"10000500","errMessage":"\\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: StarRocks planner use long time 3000 ms in memo phase, This probably becaus... (28141 bytes)]"<br />}<br /><img src="{583174.png}" alt="" /></p>
004+ <p><br /></p>
005+ <p><img src="{583179.png}" alt="" /></p>

修改了 解决方案，旧值为 ""，新值为 "code"。
修改了 解决日期，旧值为 ""，新值为 "2026-10-23 18:08:29"。
修改了 指派给 ，旧值为 "wenbosen"，新值为 "xiaqiusheng"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "wenbosen"。

修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "xiaqiusheng"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "xiaqiusheng"。
修改了 关闭日期，旧值为 ""，新值为 "2026-10-23 18:09:08"。

修改了 重现步骤，旧值为 "

curl -X POST 'https://webapi.internal.zhcxkj.com/bi/spAdPlacementBusiness/sum' ^
-H 'host: webapi.internal.zhcxkj.com' ^
-H 'content-length: 862' ^
-H 'sec-ch-ua-platform: "Windows"' ^
-H 'authorization: Bearer eyJhbGciOiJIUzUxMiJ9.eyJyYW5kb21udW1iZXIiOiI1ZDVhZGEyNC00MzUzLTQxZTctYWVhOC1kNDMwYjUzOTlhZGUiLCJ1c2VyX2lkIjoyLCJ1c2VyX2tleSI6ImVlOTFiNDE5ZDYwNWIzZGFlYzk3NTIyZWM5N2E3YzQ2IiwidXNlcm5hbWUiOiJJcm9ib3Rib3jns7vnu5_nrqHnkIblkZgwNDcifQ.c7m1DxENs8Usfndtz-XmA8mrD2h9d6SeGXwWqGcKiOYIdgWEhCrGAi4WDOCJan1eJpHYStLAdSMMJyf1Jea6Lw' ^
-H 'sec-ch-ua: "Google Chrome";v="155", "Chromium";v="155", "Not(A:Brand";v="24"' ^
-H 'sec-ch-ua-mobile: ?0' ^
-H 'from-type: 1' ^
-H 'user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36' ^
-H 'accept: application/json, text/plain, */*' ^
-H 'content-type: application/json' ^
-H 'origin: https://web.internal.zhcxkj.com' ^
-H 'sec-fetch-site: same-site' ^
-H 'sec-fetch-mode: cors' ^
-H 'sec-fetch-dest: empty' ^
-H 'referer: https://web.internal.zhcxkj.com/' ^
-H 'accept-encoding: gzip, deflate, br, zstd' ^
-H 'accept-language: zh-CN,zh;q=0.9' ^
-H 'priority: u=1, i' ^
-d '{"sourceIdList":[16549],"firstBusinessPeopleIdList":[],"targetingTypeList":[],"costTypeList":[],"dateTime":["2025-10-23","2026-10-23"],"currencyType":3,"otherQueryPrecision":0,"stateList":["enabled"],"campaignStateList":["enabled"],"adType":0,"biddingStrategyList":[],"matchTypeList":[],"targetingStateList":["enabled"],"resolvedExpressionPredicateTypeList":[],"otherQueryType":5,"adSearchCondition":{"queryPrecision":0,"queryType":1,"queryList":["冲牙器新推 企业购广告"]},"productSearchCondition":{"queryPrecision":0,"queryType":4,"queryList":["COSLUS 基础款便携冲牙器（黑色）"]},"createByList":[],"portfolioIdList":[],"adKeywordStatusList":["enabled"],"servingStatusList":[],"existAdAreaCondition":false,"adAreaCondition":{},"otherQueryList":[],"campaignPlacementList":[],"startDate":"2025-10-23 00:00:00","endDate":"2026-10-23 23:59:59"}'

{
  "success": false,
  "errCode": "10000500",
  "errMessage": "[500 ] during [POST] to [http://zhcxkj-center-adv-amazon/spAdPlacementBusiness/sum] [ISpAdCampaignOpenApi#spAdPlacementBusinessSum(SpAdPlacemenPageQry)]: [{"success":false,"errCode":"10000500","errMessage":"\\n### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: StarRocks planner use long time 3000 ms in memo phase, This probably becaus... (28141 bytes)]"
}

"，新值为 "

curl -X POST 'https://webapi.internal.zhcxkj.com/bi/spAdPlacementBusiness/sum' ^
-H 'host: webapi.internal.zhcxkj.com' ^
-H 'content-length: 862' ^
-H 'sec-ch-ua-platform: "Windows"' ^
-H 'authorization: Bearer eyJhbGciOiJIUzUxMiJ9.eyJyYW5kb21udW1iZXIiOiI1ZDVhZGEyNC00MzUzLTQxZTctYWVhOC1kNDMwYjUzOTlhZGUiLCJ1c2VyX2lkIjoyLCJ1c2VyX2tleSI6ImVlOTFiNDE5ZDYwNWIzZGFlYzk3NTIyZWM5N2E3YzQ2IiwidXNlcm5hbWUiOiJJcm9ib3Rib3jns7vnu5_nrqHnkIblkZgwNDcifQ.c7m1DxENs8Usfndtz-XmA8mrD2h9d6SeGXwWqGcKiOYIdgWEhCrGAi4WDOCJan1eJpHYStLAdSMMJyf1Jea6Lw' ^
-H 'sec-ch-ua: "Google Chrome";v="155", "Chromium";v="155", "Not(A:Brand";v="24"' ^
-H 'sec-ch-ua-mobile: ?0' ^
-H 'from-type: 1' ^
-H 'user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36' ^
-H 'accept: application/json, text/plain, */*' ^
-H 'content-type: application/json' ^
-H 'origin: https://web.internal.zhcxkj.com' ^
-H 'sec-fetch-site: same-site' ^
-H 'sec-fetch-mode: cors' ^
-H 'sec-fetch-dest: empty' ^
-H 'referer: https://web.internal.zhcxkj.com/' ^
-H 'accept-encoding: gzip, deflate, br, zstd' ^
-H 'accept-language: zh-CN,zh;q=0.9' ^
-H 'priority: u=1, i' ^
-d '{"sourceIdList":[16549],"firstBusinessPeopleIdList":[],"targetingTypeList":[],"costTypeList":[],"dateTime":["2025-10-23","2026-10-23"],"currencyType":3,"otherQueryPrecision":0,"stateList":["enabled"],"campaignStateList":["enabled"],"adType":0,"biddingStrategyList":[],"matchTypeList":[],"targetingStateList":["enabled"],"resolvedExpressionPredicateTypeList":[],"otherQueryType":5,"adSearchCondition":{"queryPrecision":0,"queryType":1,"queryList":["冲牙器新推 企业购广告"]},"productSearchCondition":{"queryPrecision":0,"queryType":4,"queryList":["COSLUS 基础款便携冲牙器（黑色）"]},"createByList":[],"portfolioIdList":[],"adKeywordStatusList":["enabled"],"servingStatusList":[],"existAdAreaCondition":false,"adAreaCondition":{},"otherQueryList":[],"campaignPlacementList":[],"startDate":"2025-10-23 00:00:00","endDate":"2026-10-23 23:59:59"}'

{
  "success": false,
  "errCode": "10000500",
  "errMessage": "[500 ] during [POST] to [http://zhcxkj-center-adv-amazon/spAdPlacementBusiness/sum] [ISpAdCampaignOpenApi#spAdPlacementBusinessSum(SpAdPlacemenPageQry)]: [{"success":false,"errCode":"10000500","errMessage":"\\n### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: StarRocks planner use long time 3000 ms in memo phase, This probably becaus... (28141 bytes)]"
}

"。
修改了 Bug类型 ，旧值为 "code"，新值为 "duplicate"。
修改了 解决时效，旧值为 "0"，新值为 "0.89"。