{"id":10021332,"date":"2026-04-02T20:45:54","date_gmt":"2026-04-02T12:45:54","guid":{"rendered":"https:\/\/itmax.cn\/?p=10021332"},"modified":"2026-04-02T20:45:54","modified_gmt":"2026-04-02T12:45:54","slug":"%e6%97%a5%e5%bf%97%e8%af%8a%e6%96%ad-skill%ef%bc%9a%e7%94%a8-ai-mcp-%e4%b8%80%e9%94%ae%e8%a7%a3%e5%86%b3bug%ef%bd%9c%e5%be%97%e7%89%a9%e6%8a%80%e6%9c%af","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10021332","title":{"rendered":"\u65e5\u5fd7\u8bca\u65ad Skill\uff1a\u7528 AI + MCP \u4e00\u952e\u89e3\u51b3BUG\uff5c\u5f97\u7269\u6280\u672f"},"content":{"rendered":"

\u4e00\u3001\u6982\u8ff0<\/h3>\n

\u505a\u540e\u7aef\u5f00\u53d1\uff0c\u8c03 BUG \u6709\u4e00\u4e2a\u8ba9\u4eba\u5934\u75bc\u7684\u56fa\u5b9a\u6d41\u7a0b\uff1a\u6253\u5f00\u65e5\u5fd7\u5e73\u53f0\uff0c\u8f93\u5165 traceId \u6216\u5173\u952e\u8bcd\uff0c\u641c\u65e5\u5fd7\uff1b\u4ece\u51e0\u5341\u4e0a\u767e\u6761\u65e5\u5fd7\u91cc\uff0c\u627e\u5230\u5173\u952e\u7684\u90a3\u51e0\u6761\uff1b\u628a\u65e5\u5fd7\u91cc\u7684\u7c7b\u540d\u3001\u65b9\u6cd5\u540d\u590d\u5236\u51fa\u6765\uff0c\u53bb IDE \u91cc\u627e\u5bf9\u5e94\u4ee3\u7801\uff1b\u7ed3\u5408\u4ee3\u7801\u903b\u8f91\uff0c\u5224\u65ad\u54ea\u91cc\u51fa\u4e86\u95ee\u9898\uff1b\u5982\u679c\u4e00\u6b21\u627e\u4e0d\u51c6\uff0c\u56de\u53bb\u518d\u641c\u65e5\u5fd7\uff0c\u518d\u7ffb\u4ee3\u7801\u2026\u2026<\/p>\n

\u8fd9\u4e2a\u8fc7\u7a0b\u76f8\u5bf9\u56fa\u5b9a\uff0c\u4f46\u975e\u5e38\u8017\u65f6\u95f4\u3002\u6bcf\u6b21 BUG \u5b9a\u4f4d\uff0c\u5149\u5728\u65e5\u5fd7\u5e73\u53f0\u548c IDE \u4e4b\u95f4\u6765\u56de\u5207\u6362\uff0c\u5c31\u80fd\u6d88\u8017\u6389\u5927\u534a\u7684\u65f6\u95f4\u3002<\/p>\n

\u6700\u5f00\u59cb\u5728\u53bb\u5e74 Q3 \u60f3\u5230\u8fd9\u4e2a\u95ee\u9898\u7684\u65f6\u5019\uff0c\u8111\u5b50\u91cc\u6d6e\u73b0\u7684\u7b2c\u4e00\u4e2a\u65b9\u6848\u662f\uff1a\u7528 Cursor + MCP\uff0c\u628a\u65e5\u5fd7\u5e73\u53f0\u63a5\u8fdb\u6765\uff0c\u518d\u6302\u4e00\u4e2a\u4ee3\u7801\u77e5\u8bc6\u5e93\uff0c\u8ba9 AI \u5e2e\u6211\u67e5\u65e5\u5fd7\u3002\u4f46\u8fd9\u4e2a\u65b9\u6848\u6709\u7f3a\u9677 \u2014\u2014 \u65e5\u5fd7\u67e5\u8be2\u662f\u300c\u52a8\u6001\u7684\u300d\uff0c\u5b83\u4f9d\u8d56\u73af\u5883\u3001\u5e94\u7528\u3001\u65f6\u95f4\u8303\u56f4\uff0c\u6ca1\u529e\u6cd5\u9759\u6001\u9884\u7f6e\u3002\u6b64\u5916\uff0c\u8fd9\u6837\u5904\u7406\u6ca1\u6709\u529e\u6cd5\u505a\u5230\u6bd4\u8f83\u4e1d\u6ed1\u5730\u8bfb\u4ee3\u7801\u3001\u6539\u4ee3\u7801\u3002<\/p>\n

\u540e\u6765\u5f00\u59cb\u7528 Claude Code\uff0c\u63a5\u89e6\u5230\u4e86 Skill \u7684\u6982\u5ff5\uff1a\u53ef\u4ee5\u5728\u9879\u76ee\u91cc\u5b9a\u4e49\u4e00\u5957\u81ea\u5b9a\u4e49\u547d\u4ee4\uff0c\u63cf\u8ff0 AI \u5e94\u8be5\u600e\u4e48\u6267\u884c\u8fd9\u4e2a\u547d\u4ee4\u7684\u6bcf\u4e2a\u6b65\u9aa4\uff0c\u4e8e\u662f\u6574\u4e2a\u601d\u8def\u53d8\u5f97\u6e05\u6670\u4e86\u3002<\/p>\n

\u65e5\u5fd7\u5e73\u53f0\u6709 MCP\uff0cClaude Code \u6709 Skill\uff0c\u4e24\u8005\u7ed3\u5408\uff0c\u5c31\u80fd\u8ba9 AI \u81ea\u52a8\u5b8c\u6210\u300c\u67e5\u65e5\u5fd7 \u2192 \u627e\u5173\u952e\u4fe1\u606f \u2192 \u626b\u63cf\u4ee3\u7801 \u2192 \u5b9a\u4f4d\u95ee\u9898\u300d\u8fd9\u6574\u4e2a\u95ed\u73af\u3002\u7136\u540e\u5728 PM \u7684\u5e2e\u52a9\u4e0b\uff0c\u624d\u6709\u4e86 \/log-diagnosis \u8fd9\u4e2a Skill\u3002<\/p>\n

\u4e8c\u3001\u65e5\u5fd7\u5e73\u53f0 MCP \u662f\u4ec0\u4e48<\/h3>\n

MCP \u539f\u7406<\/h4>\n

\u65e5\u5fd7\u5e73\u53f0\u63a8\u51fa\u4e86\u57fa\u4e8e MCP\uff08Model Context Protocol\uff09\u534f\u8bae\u7684\u65e5\u5fd7\u67e5\u8be2\u670d\u52a1\uff0c\u8ba9 Claude \u53ef\u4ee5\u76f4\u63a5\u8c03\u7528\u65e5\u5fd7\u5e73\u53f0\u7684\u80fd\u529b\uff0c\u65e0\u9700\u4eba\u5de5\u5728\u65e5\u5fd7\u5e73\u53f0\u4e0a\u624b\u52a8\u67e5\u8be2\u3002<\/p>\n

MCP \u672c\u8d28\u4e0a\u662f\u4e00\u79cd\u6807\u51c6\u5316\u7684\u300c\u5de5\u5177\u8c03\u7528\u534f\u8bae\u300d\uff0cClaude Code \u901a\u8fc7 SSE\uff08Server-Sent Events\uff09\u957f\u8fde\u63a5\u4e0e MCP Server \u901a\u4fe1\uff0c\u5b9e\u65f6\u83b7\u53d6\u65e5\u5fd7\u6570\u636e\u3002<\/p>\n

MCP \u73af\u5883\u5bf9\u7167<\/h4>\n

\"\"<\/p>\n

\u6838\u5fc3 MCP \u5de5\u5177<\/h4>\n

\"\"<\/p>\n

\u9274\u6743\u6d41\u7a0b<\/h4>\n
secretKey\uff08\u65e5\u5fd7\u5e73\u53f0\u540e\u7ba1\u7533\u8bf7\uff09\n    \u2193 acquireTokenTool\naccessToken\uff081\u5c0f\u65f6\u6709\u6548\uff0c\u6700\u591a\u540c\u65f6\u5b58\u57285\u4e2a\uff09\n    \u2193 \u643a\u5e26 accessToken\nlogsQuery \/ logSqlQuery \/ countLogTool ...<\/code><\/pre>\n
secretKey \u7533\u8bf7\u5730\u5740\uff1a\u8fdb\u5165\u65e5\u5fd7\u7ba1\u7406\u540e\u53f0 \u2192 \u65e5\u5fd7\u6743\u9650 \u2192 \u6211\u7684\u5e94\u7528 \u2192 \u751f\u6210\u5bc6\u94a5\u3002<\/p>\n
\u4e09\u3001\/log-diagnosis Skill \u662f\u4ec0\u4e48<\/h3>\n
Skill \u5de5\u4f5c\u539f\u7406<\/h4>\n
log-diagnosis \u662f\u4e00\u4e2a\u8fd0\u884c\u5728 Claude Code \u91cc\u7684\u81ea\u5b9a\u4e49\u8bca\u65ad\u547d\u4ee4\u3002Claude Code \u652f\u6301\u901a\u8fc7 .claude\/skills\/ \u76ee\u5f55\u5b9a\u4e49\u81ea\u5b9a\u4e49\u6280\u80fd\uff08Skill\uff09\uff0c\u4ee5 Markdown \u6587\u4ef6\u63cf\u8ff0\u884c\u4e3a\u89c4\u8303\uff0cClaude \u5728\u6536\u5230\u5bf9\u5e94\u547d\u4ee4\u65f6\u4f1a\u81ea\u52a8\u52a0\u8f7d\u5e76\u6267\u884c\u3002\u4f60\u53ea\u9700\u8981\u628a traceId \u6216\u544a\u8b66\u4fe1\u606f\u544a\u8bc9\u5b83\uff0c\u5269\u4e0b\u7684\u5168\u90e8\u4ea4\u7ed9 AI\u3002\u5b8c\u6574\u6267\u884c\u94fe\u8def\u5982\u4e0b\uff1a<\/p>\n
\u7528\u6237\u8f93\u5165 \/log-diagnosis {\u73af\u5883} {\u4ee3\u7801\u5206\u652f} {\u8bc9\u6c42}\n    \u2193\nClaude \u52a0\u8f7d .claude\/skills\/log-diagnosis\/SKILL.md\n    \u2193\n\u8bfb\u53d6 .diagnosis\/config.json \u83b7\u53d6\u5f53\u524d\u73af\u5883\u914d\u7f6e\n    \u2193\n\u68c0\u67e5 accessToken \u662f\u5426\u8fc7\u671f\uff0c\u8fc7\u671f\u5219\u81ea\u52a8\u5237\u65b0\n    \u2193\n\u4ece traceId \u8ba1\u7b97\u65e5\u5fd7\u65f6\u95f4\u8303\u56f4\uff08\u53d6\u7b2c9-16\u4f4d16\u8fdb\u5236\u65f6\u95f4\u6233\uff09\n    \u2193\n\u8c03\u7528\u65e5\u5fd7\u5e73\u53f0 MCP \u5206\u9875\u62c9\u53d6\u5168\u91cf\u65e5\u5fd7\uff08\u6700\u591a20\u9875\uff0c\u4e0d\u9057\u6f0f\uff09\n    \u2193\n\u5207\u6362\u5230\u6307\u5b9a\u4ee3\u7801\u5206\u652f\uff0c\u7ed3\u5408\u65e5\u5fd7\u5173\u952e\u8bcd\u68c0\u7d22\u4ee3\u7801\n    \u2193\n\u7efc\u5408\u5206\u6790\uff1a\u4e0a\u6e38\u65e5\u5fd7 + \u5f53\u524d\u670d\u52a1\u65e5\u5fd7 + \u4ee3\u7801\u903b\u8f91 \u2192 \u6839\u56e0\n    \u2193\n\u751f\u6210\u8bca\u65ad\u62a5\u544a\uff08\u98de\u4e66\u6587\u6863 or \u672c\u5730 Markdown\uff09\n    \u2193\n\u6062\u590d\u539f\u59cb\u4ee3\u7801\u5206\u652f<\/code><\/pre>\n
\u4e24\u79cd\u8bca\u65ad\u5165\u53e3<\/h4>\n
\"\"<\/p>\n
\u6838\u5fc3\u80fd\u529b<\/h4>\n
    \n
  • Token \u81ea\u52a8\u7ba1\u7406\uff1aaccessToken \u8fc7\u671f\u81ea\u52a8\u5237\u65b0\uff0c\u65e0\u9700\u624b\u52a8\u7ef4\u62a4\uff1b<\/li>\n
  • \u5206\u9875\u5168\u91cf\u62c9\u53d6\uff1a\u81ea\u52a8\u5206\u9875\u62c9\u5b8c\u6240\u6709\u65e5\u5fd7\uff0c\u7981\u6b62\u53ea\u67e5\u7b2c\u4e00\u9875\u5c31\u4e0b\u7ed3\u8bba\uff08\u6700\u591a 20 \u9875\uff09\uff1b<\/li>\n
  • \u8de8\u670d\u52a1\u5206\u6790\uff1a\u81ea\u52a8\u8bc6\u522b\u4e0a\u4e0b\u6e38\u670d\u52a1\uff0c\u62c9\u53d6\u5173\u8054\u670d\u52a1\u65e5\u5fd7\u4ea4\u53c9\u9a8c\u8bc1\uff1b<\/li>\n
  • \u4ee3\u7801\u8054\u52a8\uff1a\u65e5\u5fd7\u91cc\u51fa\u73b0\u7684\u7c7b\u540d\/\u65b9\u6cd5\u540d\uff0c\u76f4\u63a5\u5728\u4ee3\u7801\u91cc\u7cbe\u786e\u5b9a\u4f4d\u3002<\/li>\n<\/ul>\n
    queryString \u8bed\u6cd5\u89c4\u5219<\/h4>\n
    # \u683c\u5f0f\n{field} {\u64cd\u4f5c\u7b26} "{\u503c}" {\u8fde\u63a5\u7b26} {field} {\u64cd\u4f5c\u7b26} "{\u503c}"\n# \u64cd\u4f5c\u7b26\n=  : \u7cbe\u786e\u5339\u914d\n\u2248  : \u6a21\u7cca\u5339\u914d\uff08like\uff09\n# \u8fde\u63a5\u7b26\nAND \/ OR \/ NOT\n# \u793a\u4f8b\ntrace_id = "a1b2c3d4e5f6789012345678abcdef01"\ntrace_id = "xxx" AND log_level = "ERROR"\nendpoint \u2248 "\/api\/your-endpoint" AND log_level = "ERROR"\nmessage \u2248 "timeout"<\/code><\/pre>\n
    \u6ce8\u610f\uff1a\u65f6\u95f4\u8303\u56f4\u53ea\u901a\u8fc7 start\/end \u53c2\u6570\u63a7\u5236\uff0c\u4e0d\u8981\u5199\u5728 queryString \u4e2d\u3002<\/p>\n
    \u56db\u3001\u5b89\u88c5\u4e0e\u914d\u7f6e<\/h3>\n
    \u5b89\u88c5\u65e5\u5fd7\u5e73\u53f0 MCP<\/h4>\n
    Claude Code<\/h5>\n
    \u5728 Claude Code \u547d\u4ee4\u884c\u4e2d\u6267\u884c\uff0c\u6309\u9700\u5b89\u88c5\u5bf9\u5e94\u73af\u5883\uff1a<\/p>\n
    # \u6d4b\u8bd5\u73af\u5883\nclaude mcp add --transport sse dw-log-mcp-t1 https:\/\/{your-t1-aigw-domain}\/api\/v1\/mcp\/log-mcp\/sse\n# \u9884\u53d1\u73af\u5883\nclaude mcp add --transport sse dw-log-mcp-pre https:\/\/{your-pre-aigw-domain}\/api\/v1\/mcp\/log-mcp\/sse\n# \u751f\u4ea7\u73af\u5883\nclaude mcp add --transport sse dw-log-mcp-prd https:\/\/{your-prd-aigw-domain}\/api\/v1\/mcp\/log-mcp\/sse<\/code><\/pre>\n
    \u5b89\u88c5\u540e\u91cd\u542f Claude Code\uff0c\u6267\u884c \/mcp \u786e\u8ba4\u8fde\u63a5\u72b6\u6001\u6b63\u5e38\u3002<\/p>\n
    Cursor<\/h5>\n
      \n
    1. \u6253\u5f00 Cursor Setting\uff1b<\/li>\n
    2. \u70b9\u51fb Tools & MCP\uff0c\u6dfb\u52a0 MCP Server\uff1b<\/li>\n
    3. \u6dfb\u52a0 URL\uff0cMCP Server \u540d\u79f0\u4efb\u610f\u3002<\/li>\n<\/ol>\n
      \u5efa\u8bae\u6309\u9700\u5b89\u88c5 MCP Server\uff0c\u907f\u514d\u989d\u5916\u6d88\u8017 token\uff0c\u793a\u4f8b\u914d\u7f6e\uff1a<\/p>\n
      {\n  "mcpServers": {\n    "dw-log-mcp-t1": {\n      "url": "https:\/\/{your-t1-aigw-domain}\/api\/v1\/mcp\/log-mcp\/sse"\n    },\n    "dw-log-mcp-pre": {\n      "url": "https:\/\/{your-pre-aigw-domain}\/api\/v1\/mcp\/log-mcp\/sse"\n    },\n    "dw-log-mcp-prd": {\n      "url": "https:\/\/{your-prd-aigw-domain}\/api\/v1\/mcp\/log-mcp\/sse"\n    },\n    "dw-log-mcp-oversea-prd": {\n      "url": "https:\/\/{your-oversea-aigw-domain}\/api\/v1\/mcp\/log-mcp\/sse"\n    }\n  }\n}<\/code><\/pre>\n
        \n
      1. \u8fd4\u56de\u8bbe\u7f6e\uff0c\u5c31\u53ef\u4ee5\u770b\u5230\u5df2\u7ecf\u8fde\u63a5\u4e0a\u3002<\/li>\n<\/ol>\n
        \u5b89\u88c5 \/log-diagnosis Skill<\/h4>\n
        \u5c06 log-diagnosis \u76ee\u5f55\u653e\u5230\u9879\u76ee\u7684\u5bf9\u5e94\u76ee\u5f55\u4e0b\uff1a<\/p>\n
        Claude Code<\/h5>\n
        your-project\/\n\u2514\u2500\u2500 .claude\/\n    \u2514\u2500\u2500 skills\/\n        \u2514\u2500\u2500 log-diagnosis\/\n            \u251c\u2500\u2500 SKILL.md        # \u6280\u80fd\u884c\u4e3a\u89c4\u8303\uff08\u6838\u5fc3\uff09\n            \u251c\u2500\u2500 README.md       # \u4f7f\u7528\u8bf4\u660e\n            \u2514\u2500\u2500 reference.md   # \u9644\u5f55\uff1a\u65f6\u95f4\u811a\u672c\u3001queryString \u793a\u4f8b\u7b49<\/code><\/pre>\n
        Cursor<\/h5>\n
        your-project\/\n\u2514\u2500\u2500 .cursor\/\n    \u2514\u2500\u2500 skills\/\n        \u2514\u2500\u2500 log-diagnosis\/\n            \u251c\u2500\u2500 SKILL.md        # \u6280\u80fd\u884c\u4e3a\u89c4\u8303\uff08\u6838\u5fc3\uff09\n            \u251c\u2500\u2500 README.md       # \u4f7f\u7528\u8bf4\u660e\n            \u2514\u2500\u2500 reference.md   # \u9644\u5f55\uff1a\u65f6\u95f4\u811a\u672c\u3001queryString \u793a\u4f8b\u7b49<\/code><\/pre>\n
        \u914d\u7f6e .diagnosis\/config.json<\/h5>\n
        \u9996\u6b21\u8fd0\u884c\u4f1a\u81ea\u52a8\u5f15\u5bfc\u521b\u5efa \uff08\u76f4\u63a5\u8c03\u7528 \/log-diagnosis\uff0cSkill \u4f1a\u4e00\u6b65\u6b65\u6307\u793a\u4f60\u7ed9\u51fa secret key\uff09<\/strong> \uff0c\u4e5f\u53ef\u624b\u52a8\u5728\u9879\u76ee\u6839\u76ee\u5f55\u521b\u5efa .diagnosis\/config.json\uff1a<\/p>\n
        your-project\/\n\u2514\u2500\u2500 .cursor\/\n    \u2514\u2500\u2500 skills\/\n        \u2514\u2500\u2500 log-diagnosis\/\n            \u251c\u2500\u2500 SKILL.md        # \u6280\u80fd\u884c\u4e3a\u89c4\u8303\uff08\u6838\u5fc3\uff09\n            \u251c\u2500\u2500 README.md       # \u4f7f\u7528\u8bf4\u660e\n            \u2514\u2500\u2500 reference.md   # \u9644\u5f55\uff1a\u65f6\u95f4\u811a\u672c\u3001queryString \u793a\u4f8b\u7b49<\/code><\/pre>\n
        \u5b57\u6bb5\u8bf4\u660e\uff1a<\/p>\n
        secretKey\uff1a\u552f\u4e00\u9700\u8981\u4eba\u5de5\u586b\u5199\u7684\u5b57\u6bb5<\/strong>\uff0c\u5728\u65e5\u5fd7\u5e73\u53f0\u540e\u7ba1\u7533\u8bf7\uff1b<\/p>\n
        accessToken\uff1a\u9996\u6b21\u4f7f\u7528\u65f6\u7531 AI \u81ea\u52a8\u8c03\u7528 acquireTokenTool \u83b7\u53d6\uff0c\u8fc7\u671f\u81ea\u52a8\u5237\u65b0\uff1b<\/p>\n
        accessTokenExpireAt\uff1a\u4ece acquireTokenTool \u8fd4\u56de\u503c\u81ea\u52a8\u586b\u5145\uff1b<\/p>\n
        fields\uff1a\u8c03\u7528 logFields \u5de5\u5177\u81ea\u52a8\u83b7\u53d6\u3002<\/p>\n
        \u4e94\u3001\u4f7f\u7528\u65b9\u5f0f<\/h3>\n
        \u547d\u4ee4\u683c\u5f0f\uff1a<\/p>\n
        \/log-diagnosis {\u73af\u5883} {\u4ee3\u7801\u5206\u652f\uff08\u53ef\u9009\uff09} {\u8bc9\u6c42\u63cf\u8ff0}<\/code><\/pre>\n
        \u53c2\u6570\u8bf4\u660e\uff1a<\/p>\n
        {\u73af\u5883}\uff1aT1 \/ PRE \/ PRD\uff08\u6309\u5b9e\u9645\u73af\u5883\u6807\u8bc6\u586b\u5199\uff09\uff1b<\/p>\n
        {\u4ee3\u7801\u5206\u652f}\uff1a\u53ef\u9009\uff0c\u7559\u7a7a\u5219\u4f7f\u7528\u5f53\u524d\u5206\u652f\uff1b<\/p>\n
        {\u8bc9\u6c42\u63cf\u8ff0}\uff1a\u5305\u542b traceId \u6216\u544a\u8b66\u4fe1\u606f\u7684\u95ee\u9898\u63cf\u8ff0\uff0c\u7528\u81ea\u7136\u8bed\u8a00\u4e66\u5199\u5373\u53ef\u3002<\/p>\n
        \u793a\u4f8b\uff1a<\/p>\n
        # \u7528 traceId \u5b9a\u4f4d\u63a5\u53e3\u5f02\u5e38\n\/log-diagnosis T1 feature\/your-branch trace_id: "your-trace" \u4e3a\u4ec0\u4e48\u6700\u7ec8\u6ca1\u6709\u8fd4\u56de\u6570\u636e\n# \u7528\u544a\u8b66\u4fe1\u606f\u5206\u6790\u9519\u8bef\u539f\u56e0\n\/log-diagnosis PRD master \u544a\u8b66\u8be6\u60c5\uff1a\u3010\u63a5\u53e3\uff1aYourService\/yourMethod\u3011\u3010\u4e1a\u52a1\u7801\uff1a10002000\u3011\u3010\u4e1a\u52a1\u7801\u6d88\u606f\uff1a\u7cfb\u7edf\u5f02\u5e38\uff0c\u8bf7\u7a0d\u540e\u91cd\u8bd5\u3011\u5e2e\u6211\u5206\u6790\u95ee\u9898\u53ef\u80fd\u6027<\/code><\/pre>\n
        \u4e00\u884c\u547d\u4ee4\uff0cAI \u5168\u7a0b\u63a5\u7ba1\uff0c\u51e0\u5206\u949f\u5185\u7ed9\u51fa\u6839\u56e0\u5206\u6790\u3002<\/p>\n
        \u516d\u3001\u5b9e\u6218\u6848\u4f8b\uff1a\u4e00\u4e2a\u9690\u853d\u7684 SQL BUG<\/h3>\n
        \u80cc\u666f<\/h4>\n
        \u67d0\u641c\u7d22\u63a5\u53e3\u5728\u6d4b\u8bd5\u73af\u5883\u53cd\u9988\u6ca1\u6709\u8fd4\u56de\u6570\u636e\u3002\u62ff\u5230 traceId\uff0c\u76f4\u63a5\u6267\u884c\uff1a<\/p>\n
        \/log-diagnosis T1 feature\/your-branch trace_id: "your-trace" \u4e3a\u4ec0\u4e48\u6700\u7ec8\u6ca1\u6709\u8fd4\u56de\u6570\u636e<\/code><\/pre>\n
        \u2190 \u5c31\u8fd9\u4e00\u53e5\u8bdd\uff0c\u63a5\u4e0b\u6765\u5168\u90e8\u4ea4\u7ed9 AI\u3002<\/p>\n
        AI \u81ea\u52a8\u62c9\u53d6\u65e5\u5fd7<\/h4>\n
        Skill \u89e6\u53d1\u540e\uff0cAI \u81ea\u52a8\u5b8c\u6210\uff1a<\/p>\n
          \n
        • \u4ece traceId \u63a8\u7b97\u51fa\u65e5\u5fd7\u65f6\u95f4\u8303\u56f4\uff082026-02-27 \u5168\u5929\uff09\uff1b<\/li>\n
        • \u68c0\u67e5 accessToken \u5df2\u8fc7\u671f\uff0c\u81ea\u52a8\u5237\u65b0\uff1b<\/li>\n
        • \u8c03\u7528\u65e5\u5fd7\u5e73\u53f0 MCP\uff0c\u5206 2 \u9875\u62c9\u53d6\u5b8c\u6574\u65e5\u5fd7\uff0c\u5171 73 \u6761\u3002<\/li>\n<\/ul>\n
          \u8bf7\u6c42\u5165\u53c2\uff08\u4ece\u65e5\u5fd7\u81ea\u52a8\u63d0\u53d6\uff09\uff1a<\/p>\n
          {\n  "assembleByOrg": true,\n  "channelType": "MANUAL",\n  "orderNo": "your-order-no",\n  "status": 1,\n  "ticketNo": "your-ticket-no"\n}<\/code><\/pre>\n
          AI \u8fd8\u539f\u5b8c\u6574\u8c03\u7528\u94fe\u8def<\/h4>\n
          \"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n
          AI \u81ea\u52a8\u8bc6\u522b\u51fa\u5173\u952e\u8282\u70b9\uff1aresultList is empty\uff0cSQL \u67e5\u8be2\u8fd4\u56de\u4e86\u7a7a\u7ed3\u679c\u3002\u95ee\u9898\u5728 DB \u5c42\uff0c\u800c\u4e0d\u5728\u4e1a\u52a1\u903b\u8f91\u5c42\u3002<\/p>\n
          AI \u63d0\u53d6\u7ec4\u88c5\u540e\u7684\u67e5\u8be2 DTO<\/h4>\n
          \u4ece\u65e5\u5fd7\u4e2d\u63d0\u53d6\u5230 toSearchDTO \u7ec4\u88c5\u7ed3\u679c\uff1a<\/p>\n
          {\n  "channelType": "MANUAL",\n  "customerTag": 1,\n  "deliveryMode": "\u67d0\u914d\u9001\u65b9\u5f0f",\n  "orderStatus": "8010",\n  "orderType": "0",\n  "productCategoryIds": [29],\n  "status": 1,\n  "ticketSource": 67,\n  "ticketTypeId": 5802\n}<\/code><\/pre>\n
          AI \u4ece\u65e5\u5fd7\u4e2d\u63d0\u53d6\u5b9e\u9645\u6267\u884c\u7684 SQL \u53d1\u73b0\u6839\u56e0<\/h4>\n
          ORM \u6846\u67b6\u5728\u65e5\u5fd7\u4e2d\u6253\u5370\u4e86\u5b9e\u9645\u6267\u884c\u7684 SQL\uff0cAI \u76f4\u63a5\u8bfb\u53d6\u5e76\u5206\u6790\uff1a<\/p>\n
          SELECT a.id, a.pid, a.name, a.mode, a.status, a.org_id, a.org_ids,\n       a.ticket_group_id, a.tenant_id, a.is_del, a.channel_types\nFROM your_type_table a\nLEFT JOIN your_relation_table b\n    ON b.tenant_id = 1 AND a.id = b.type_id AND b.type = 3 AND b.is_del = 0\nWHERE a.tenant_id = 1 AND a.mode = 2 AND a.is_del = 0\n  AND a.status = 1\n  AND (a.channel_types IS NULL OR a.channel_types = '' OR FIND_IN_SET('MANUAL', a.channel_types) > 0)\n  AND (b.root_id is null or b.root_id in (29))\n  AND (a.order_types IS NULL OR a.order_types = '' OR FIND_IN_SET('0', a.order_types) > 0)\n  AND (a.order_statuses IS NULL OR a.order_statuses = '' OR FIND_IN_SET('8010', a.order_statuses) > 0)\n  AND (a.delivery_modes IS NULL OR a.delivery_modes = '' OR FIND_IN_SET('\u67d0\u914d\u9001\u65b9\u5f0f', a.delivery_modes) > 0)\n  AND (a.ticket_sources IS NULL OR a.ticket_sources = '' OR FIND_IN_SET(67, a.ticket_sources) > 0)\n  AND (a.customer_tag IS NULL OR a.customer_tag = 1)   \u2190 BUG \u5728\u6b64<\/code><\/pre>\n
          AI \u53d1\u73b0\uff1a\u5176\u4ed6\u5b57\u6bb5\u90fd\u5904\u7406\u4e86 IS NULL \u548c = ”\uff08\u7a7a\u5b57\u7b26\u4e32\u4ee3\u8868 \u201c\u4e0d\u9650\u5236\u201d\uff09\u4e24\u79cd\u60c5\u51b5\uff0c\u552f\u72ec customer_tag \u53ea\u5224\u65ad\u4e86 IS NULL\uff0c\u9057\u6f0f\u4e86\u7a7a\u5b57\u7b26\u4e32 ” \u7684\u60c5\u51b5\u3002<\/p>\n
          SQL \u8bed\u4e49\u5bf9\u6bd4\uff1a<\/p>\n
          -- \u5176\u4ed6\u5b57\u6bb5\uff08\u6b63\u786e\uff09\uff1aIS NULL \u548c '' \u90fd\u5904\u7406\u4e86\nAND (a.order_types IS NULL OR a.order_types = '' OR FIND_IN_SET('0', a.order_types) > 0)\nAND (a.delivery_modes IS NULL OR a.delivery_modes = '' OR FIND_IN_SET('\u67d0\u914d\u9001\u65b9\u5f0f', a.delivery_modes) > 0)\nAND (a.ticket_sources IS NULL OR a.ticket_sources = '' OR FIND_IN_SET(67, a.ticket_sources) > 0)\n-- customer_tag\uff08\u9057\u6f0f\u4e86 = '' \u7684\u5224\u65ad\uff09\u2190 BUG\nAND (a.customer_tag IS NULL OR a.customer_tag = 1)<\/code><\/pre>\n
          DB \u4e2d\u73b0\u6709\u7684\u6570\u636e\uff0ccustomer_tag \u5b57\u6bb5\u90fd\u5b58\u7684\u662f\u7a7a\u5b57\u7b26\u4e32\uff08\u672a\u914d\u7f6e\uff09\uff0c\u6309\u4e1a\u52a1\u8bed\u4e49\u672c\u5e94\u5339\u914d\u6240\u6709\u8bf7\u6c42\uff0c\u5374\u56e0\u4e3a\u8fd9\u4e2a\u9057\u6f0f\u88ab\u5168\u90e8\u8fc7\u6ee4\u6389\u4e86\u3002<\/p>\n
          AI \u5b9a\u4f4d\u4ee3\u7801\uff0c\u7ed9\u51fa\u4fee\u590d\u65b9\u6848<\/h4>\n
          AI \u5728\u4ee3\u7801\u4e2d\u76f4\u63a5\u627e\u5230\u5bf9\u5e94\u7684 MyBatis Mapper XML\uff1a<\/p>\n
          <!-- \u95ee\u9898\u4ee3\u7801 -->\n<if test="customerTag != null">\n    and (a.customer_tag IS NULL OR a.customer_tag = #{customerTag})\n<\/if>\n<!-- \u4fee\u590d\u540e -->\n<if test="customerTag != null">\n    and (a.customer_tag IS NULL OR a.customer_tag = '' OR a.customer_tag = #{customerTag})\n<\/if><\/code><\/pre>\n
          \u6548\u7387\u5bf9\u6bd4<\/h4>\n
          \"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n
          \u8fd9\u4e2a BUG \u7684\u9690\u853d\u6027\u5728\u4e8e\uff1aSQL \u8bed\u6cd5\u6b63\u786e\uff0c\u903b\u8f91\u4e0a\u4e5f\u300c\u770b\u8d77\u6765\u300d\u6ca1\u95ee\u9898\u2014\u2014\u53ea\u6709\u5bf9\u6bd4\u4e86\u5176\u4ed6\u5b57\u6bb5\u7684\u5199\u6cd5\uff0c\u624d\u80fd\u53d1\u73b0 customer_tag \u72ec\u81ea\u9057\u6f0f\u4e86\u7a7a\u5b57\u7b26\u4e32\u7684\u5904\u7406\u3002\u8fd9\u7c7b\u7ec6\u8282\u5dee\u5f02\uff0c\u4eba\u5de5\u6392\u67e5\u5f88\u5bb9\u6613\u5ffd\u7565\uff0cAI \u53cd\u800c\u5f88\u64c5\u957f\u3002<\/p>\n
          \u4e03\u3001\u8bca\u65ad\u6548\u7387\u5173\u952e\u70b9<\/h2>\n