{"id":123585,"date":"2026-11-07T18:58:15","date_gmt":"2026-11-07T10:58:15","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/123585.html"},"modified":"2026-11-07T18:58:15","modified_gmt":"2026-11-07T10:58:15","slug":"%e5%90%8c%e6%89%b9%e9%a2%98%e9%87%8d%e5%a4%8d%e9%87%87%e6%a0%b7-%e6%96%b9%e5%b7%ae%e4%bc%b0%e8%ae%a1%e4%b8%8e%e7%bd%ae%e4%bf%a1%e5%8c%ba%e9%97%b4%e7%9a%84%e9%9b%b6%e4%be%9d%e8%b5%96%e5%ae%9e%e7%8e%b0","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/123585.html","title":{"rendered":"\u540c\u6279\u9898\u91cd\u590d\u91c7\u6837 \u65b9\u5dee\u4f30\u8ba1\u4e0e\u7f6e\u4fe1\u533a\u95f4\u7684\u96f6\u4f9d\u8d56\u5b9e\u73b0\uff082026\uff09"},"content":{"rendered":"<p>        \/* MD \/ \u5bcc\u6587\u672c\u4e2d\u7684 .toc\uff08\u542b\u535a\u5ba2\u56ed\u642c\u5bb6\u7b49\u5d4c\u5957\u7ed3\u6784\uff09\uff1b.toc-box \u5728\u4fa7\u680f\uff0c\u4e0d\u53d7\u5f71\u54cd *\/<br \/>\n        #content_views .toc,<br \/>\n        \/* \u7f16\u8f91\u5668\u5e38\u5728\u76ee\u5f55\u524d\u540e\u63d2\u5165\u7a7a p\uff08:empty \u4ecd\u5360 20px\uff09\uff0c\u4e00\u5e76\u53bb\u6389\u907f\u514d\u9876\u7a7a\u9699 *\/<br \/>\n        #content_views.markdown_views &gt; p:empty:has(+ .toc),<br \/>\n        #content_views.markdown_views &gt; .toc + p:empty,<br \/>\n        \/* \u5bcc\u6587\u672c\u65e7\u7248\u76ee\u5f55\u6807\u8bb0 *\/<br \/>\n        #content_views.htmledit_views #main-toc,<br \/>\n        #content_views.htmledit_views #hr-toc,<br \/>\n        #content_views.htmledit_views p[id*=\\&#8221;-toc\\&#8221;] {<br \/>\n          display: none !important;<br \/>\n        }<br \/>\n        \/* \u76ee\u5f55\u53bb\u6389\u540e\uff0c\u7d27\u8ddf\u7684\u9996\u4e2a\u6807\u9898\u4e0d\u518d\u591a\u51fa\u4e00\u5757\u4e0a\u8fb9\u8ddd *\/<br \/>\n        #content_views.markdown_views &gt; .toc + h1,<br \/>\n        #content_views.markdown_views &gt; .toc + h2,<br \/>\n        #content_views.markdown_views &gt; .toc + h3,<br \/>\n        #content_views.markdown_views &gt; .toc + h4,<br \/>\n        #content_views.markdown_views &gt; .toc + p:empty + h1,<br \/>\n        #content_views.markdown_views &gt; .toc + p:empty + h2,<br \/>\n        #content_views.markdown_views &gt; .toc + p:empty + h3,<br \/>\n        #content_views.markdown_views &gt; .toc + p:empty + h4 {<br \/>\n          margin-top: 0 !important;<br \/>\n        }<\/p>\n<p>\u5728 AI \u641c\u7d22\u53ef\u89c1\u5ea6\u68c0\u6d4b\u91cc&#xff0c;\u6700\u5e38\u89c1\u7684\u9519\u8bef\u4e0d\u662f\u7b97\u9519&#xff0c;\u662f\u4e0d\u7b97\u65b9\u5dee\u5c31\u76f4\u63a5\u6bd4\u5927\u5c0f\u3002<\/p>\n<p>&#034;\u8fd9\u6b21\u63d0\u53ca\u7387 35%&#xff0c;\u4e0a\u6b21 30%&#xff0c;\u6da8\u4e86 5 \u4e2a\u70b9&#034;\u2014\u2014\u8fd9\u53e5\u8bdd\u5982\u679c\u6ca1\u5e26\u7f6e\u4fe1\u533a\u95f4&#xff0c;\u7b49\u4e8e\u4ec0\u4e48\u90fd\u6ca1\u8bf4\u3002\u6837\u672c\u91cf 20 \u9898\u3001\u5355\u6b21\u91c7\u6837\u7684\u60c5\u51b5\u4e0b&#xff0c;5 \u4e2a\u70b9\u7684\u5dee\u5f02\u5927\u6982\u7387\u843d\u5728\u566a\u58f0\u91cc\u3002\u672c\u6587\u7ed9\u4e00\u5957\u96f6\u4f9d\u8d56\u7684\u5b9e\u73b0&#xff1a;\u7528\u4e8c\u9879\u6bd4\u4f8b\u4f30\u8ba1\u63d0\u53ca\u7387&#xff0c;\u7528 Wilson \u533a\u95f4\u5904\u7406\u5c0f\u6837\u672c&#xff0c;\u7528\u914d\u5bf9 bootstrap \u5904\u7406\u590d\u6d4b\u5dee\u503c&#xff0c;\u5e76\u7ed9\u51fa&#034;\u591a\u5c11\u9898\u624d\u591f&#034;\u7684\u6700\u5c0f\u6837\u672c\u91cf\u4f30\u7b97\u3002<\/p>\n<h3>\u4e00\u3001\u53e3\u5f84\u5148\u884c&#xff1a;\u5206\u6bcd\u662f\u4ec0\u4e48<\/h3>\n<p>\u5148\u5b9a\u6b7b\u4e09\u4ef6\u4e8b&#xff0c;\u5426\u5219\u540e\u9762\u6240\u6709\u533a\u95f4\u90fd\u662f\u9519\u7684\u3002<\/p>\n<li>\u5206\u6bcd &#061; \u9898\u6570 \u00d7 \u91c7\u6837\u6b21\u6570\u300220 \u9898\u5404\u91c7 3 \u6b21&#xff0c;\u5206\u6bcd\u662f 60&#xff0c;\u4e0d\u662f 20\u3002\u6309 20 \u7b97\u4f1a\u628a\u533a\u95f4\u538b\u7a84\u4e09\u500d&#xff0c;\u5f97\u51fa\u8fc7\u5ea6\u81ea\u4fe1\u7684\u7ed3\u8bba\u3002<\/li>\n<li>\u5206\u5b50 &#061; \u63d0\u53ca\u6b21\u6570\u3002\u540c\u4e00\u6b21\u56de\u7b54\u91cc\u51fa\u73b0\u4e24\u6b21\u54c1\u724c\u540d&#xff0c;\u53ea\u8ba1 1 \u6b21&#xff08;\u53bb\u91cd\u952e\u4e3a query_id &#043; sample_k&#xff09;\u3002<\/li>\n<li>&#034;\u672a\u63d0\u53ca&#034;\u5206\u4e09\u79cd&#xff1a;\u771f\u7684\u6ca1\u51fa\u73b0\u3001\u56de\u7b54\u88ab\u622a\u65ad\u3001\u8c03\u7528\u5931\u8d25\u3002\u540e\u4e24\u79cd\u5fc5\u987b\u4ece\u5206\u6bcd\u91cc\u5254\u9664&#xff0c;\u5426\u5219\u662f\u5047\u9634\u6027\u3002<\/li>\n<p>\u7b2c\u4e09\u70b9\u662f\u5b9e\u9645\u9879\u76ee\u91cc\u6700\u5bb9\u6613\u88ab\u5ffd\u7565\u7684\u3002\u4e00\u6b21\u8d85\u65f6\u88ab\u8bb0\u6210&#034;\u672a\u63d0\u53ca&#034;&#xff0c;\u7b49\u4e8e\u51ed\u7a7a\u591a\u4e86\u4e00\u4e2a\u8d1f\u6837\u672c\u3002<\/p>\n<h3>\u4e8c\u3001\u70b9\u4f30\u8ba1&#xff1a;\u4e8c\u9879\u6bd4\u4f8b<\/h3>\n<p>\u63d0\u53ca\u7387\u672c\u8d28\u662f\u4e00\u4e32 0\/1 \u7684\u5747\u503c\u3002\u7528 k\/n \u4f30\u8ba1\u5373\u53ef&#xff0c;\u4e0d\u9700\u8981\u52a0\u6743\u2014\u2014\u9664\u975e\u505a\u4e86\u5206\u5c42\u62bd\u6837&#xff08;\u6bd4\u5982\u6309&#034;\u533b\u9662\u7c7b\u95ee\u6cd5&#034;\u548c&#034;\u7528\u54c1\u7c7b\u95ee\u6cd5&#034;\u5206\u5c42&#xff09;&#xff0c;\u90a3\u8981\u6309\u5c42\u6743\u91cd\u5408\u5e76\u3002<\/p>\n<p>from math import sqrt<\/p>\n<p>def rate(hits: int, total: int) -&gt; float:<br \/>\n    return hits \/ total if total else 0.0<\/p>\n<p>\u7b80\u5355\u5230\u4e0d\u7528\u89e3\u91ca&#xff0c;\u4f46\u5b83\u7684\u7f6e\u4fe1\u533a\u95f4\u4e0d\u7b80\u5355\u3002<\/p>\n<h3>\u4e09\u3001\u533a\u95f4\u4f30\u8ba1&#xff1a;\u4e3a\u4ec0\u4e48\u7528 Wilson \u800c\u4e0d\u662f\u6b63\u6001\u8fd1\u4f3c<\/h3>\n<p>\u5e38\u89c1\u7684 p \u00b1 1.96*sqrt(p(1-p)\/n) \u5728 p \u63a5\u8fd1 0 \u6216 1 \u65f6\u4f1a\u5d29&#xff1a;\u7b97\u51fa\u7684\u4e0b\u754c\u53ef\u80fd\u662f\u8d1f\u6570&#xff0c;\u6216\u8005\u533a\u95f4\u5bbd\u5ea6\u4e3a 0\u3002\u800c GEO \u68c0\u6d4b\u91cc&#034;\u63d0\u53ca\u7387 3%&#034;&#034;\u63d0\u53ca\u7387 0&#034;\u662f\u5e38\u6001\u2014\u2014\u7edd\u5927\u591a\u6570\u4e2d\u5c0f\u4f01\u4e1a\u5728\u7edd\u5927\u591a\u6570\u9898\u4e0a\u5c31\u662f\u4e0d\u88ab\u63d0\u53ca\u3002<\/p>\n<p>Wilson \u5f97\u5206\u533a\u95f4\u5728\u5c0f\u6837\u672c\u4e0e\u6781\u7aef\u6bd4\u4f8b\u4e0b\u8868\u73b0\u7a33\u5b9a&#xff0c;\u4e14\u4e0d\u9700\u8981\u5916\u90e8\u5e93&#xff1a;<\/p>\n<p>def wilson_ci(k: int, n: int, z: float &#061; 1.96) -&gt; tuple:<br \/>\n    &#034;&#034;&#034;Wilson score interval, 95% by default&#034;&#034;&#034;<br \/>\n    if n &#061;&#061; 0:<br \/>\n        return (0.0, 1.0)<br \/>\n    p &#061; k \/ n<br \/>\n    denom &#061; 1 &#043; z * z \/ n<br \/>\n    center &#061; (p &#043; z * z \/ (2 * n)) \/ denom<br \/>\n    half &#061; (z \/ denom) * sqrt(p * (1 &#8211; p) \/ n &#043; z * z \/ (4 * n * n))<br \/>\n    return (max(0.0, center &#8211; half), min(1.0, center &#043; half))<\/p>\n<p>\u8dd1\u51e0\u4e2a\u6570\u770b\u770b\u5dee\u522b&#xff1a;<\/p>\n<table>\n<tr>\u89c2\u6d4bk\/n\u6b63\u6001\u8fd1\u4f3c 95% CIWilson 95% CI<\/tr>\n<tbody>\n<tr>\n<td>0\/20<\/td>\n<td>0.0%<\/td>\n<td>(-0.0%, 0.0%)<\/td>\n<td>(0.0%, 16.1%)<\/td>\n<\/tr>\n<tr>\n<td>1\/20<\/td>\n<td>5.0%<\/td>\n<td>(-3.3%, 13.3%)<\/td>\n<td>(0.9%, 23.6%)<\/td>\n<\/tr>\n<tr>\n<td>3\/20<\/td>\n<td>15.0%<\/td>\n<td>(-0.6%, 30.6%)<\/td>\n<td>(5.2%, 36.0%)<\/td>\n<\/tr>\n<tr>\n<td>7\/20<\/td>\n<td>35.0%<\/td>\n<td>(14.1%, 55.9%)<\/td>\n<td>(18.1%, 55.9%)<\/td>\n<\/tr>\n<tr>\n<td>18\/20<\/td>\n<td>90.0%<\/td>\n<td>(76.9%, 103.1%)<\/td>\n<td>(69.9%, 97.2%)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u7b2c\u4e00\u884c\u6700\u80fd\u8bf4\u660e\u95ee\u9898&#xff1a;20 \u9898\u5168\u672a\u88ab\u63d0\u53ca&#xff0c;\u6b63\u6001\u8fd1\u4f3c\u7ed9\u51fa&#034;0%&#xff0c;\u533a\u95f4\u5bbd\u5ea6\u4e3a\u96f6&#034;\u2014\u2014\u4e00\u4e2a\u81ea\u4fe1\u5230\u8352\u8c2c\u7684\u7ed3\u8bba\u3002Wilson \u7ed9\u7684\u662f&#034;0% \u5230 16%&#034;&#xff0c;\u8fd9\u624d\u662f\u771f\u5b9e\u7684\u8ba4\u77e5\u6c34\u5e73&#xff1a;\u6ca1\u89c1\u5230&#xff0c;\u4f46\u6837\u672c\u4e0d\u8db3\u4ee5\u65ad\u8a00\u5b83\u4e0d\u5b58\u5728\u3002<\/p>\n<h3>\u56db\u3001\u590d\u6d4b\u5dee\u503c&#xff1a;\u914d\u5bf9 bootstrap<\/h3>\n<p>\u590d\u6d4b\u7684\u6b63\u786e\u6bd4\u6cd5\u662f\u914d\u5bf9&#xff1a;\u540c\u4e00\u9898\u3001\u540c\u4e00\u5e73\u53f0\u3001\u540c\u4e00\u53c2\u6570&#xff0c;\u8fd9\u6b21\u548c\u4e0a\u6b21\u5404\u662f\u4ec0\u4e48\u7ed3\u679c\u3002\u4e0d\u80fd\u62ff&#034;\u8fd9\u6b21\u7684\u603b\u63d0\u53ca\u7387&#034;\u51cf&#034;\u4e0a\u6b21\u7684\u603b\u63d0\u53ca\u7387&#034;\u2014\u2014\u4e24\u6279\u9898\u7684\u96be\u5ea6\u4e0d\u540c&#xff0c;\u603b\u4f53\u6bd4\u4f8b\u4f1a\u628a\u9898\u76ee\u5dee\u5f02\u6df7\u8fdb\u6548\u679c\u91cc\u3002<\/p>\n<p>\u914d\u5bf9\u5dee\u503c\u7684\u6700\u5c0f\u5b9e\u73b0&#xff1a;<\/p>\n<p>import random<\/p>\n<p>def paired_diff_ci(before: list, after: list, iters: int &#061; 5000, seed: int &#061; 42):<br \/>\n    &#034;&#034;&#034;<br \/>\n    before\/after: \u540c\u957f\u5ea6 0\/1 \u5217\u8868, \u6309 query_id \u5bf9\u9f50<br \/>\n    \u8fd4\u56de (\u5dee\u503c\u70b9\u4f30\u8ba1, \u4e0b\u754c, \u4e0a\u754c)<br \/>\n    &#034;&#034;&#034;<br \/>\n    assert len(before) &#061;&#061; len(after)<br \/>\n    n &#061; len(before)<br \/>\n    if n &#061;&#061; 0:<br \/>\n        return (0.0, 0.0, 0.0)<\/p>\n<p>    d &#061; [a &#8211; b for a, b in zip(after, before)]<br \/>\n    point &#061; sum(d) \/ n<\/p>\n<p>    rnd &#061; random.Random(seed)<br \/>\n    boots &#061; []<br \/>\n    for _ in range(iters):<br \/>\n        s &#061; sum(d[rnd.randrange(n)] for _ in range(n)) \/ n<br \/>\n        boots.append(s)<br \/>\n    boots.sort()<br \/>\n    lo &#061; boots[int(0.025 * iters)]<br \/>\n    hi &#061; boots[int(0.975 * iters) &#8211; 1]<br \/>\n    return (round(point, 4), round(lo, 4), round(hi, 4))<\/p>\n<p>\u5224\u8bfb\u89c4\u5219\u53ea\u6709\u4e00\u6761&#xff1a;\u533a\u95f4\u8de8\u8fc7 0&#xff0c;\u5c31\u4e0d\u80fd\u8bf4&#034;\u53d8\u597d\u4e86&#034;\u3002<\/p>\n<p>\u8fd9\u4e00\u6761\u80fd\u6321\u6389\u5927\u90e8\u5206\u8bef\u62a5\u3002\u4e3e\u4e2a\u4f8b\u5b50&#xff1a;20 \u9898\u3001\u4e0a\u6b21 6 \u6b21\u63d0\u53ca\u3001\u8fd9\u6b21 9 \u6b21&#xff0c;\u70b9\u4f30\u8ba1 &#043;15 \u4e2a\u70b9&#xff0c;\u770b\u7740\u5f88\u6f02\u4eae&#xff1b;\u914d\u5bf9 bootstrap \u51fa\u6765\u7684\u533a\u95f4\u53ef\u80fd\u662f (-2%, &#043;32%)&#xff0c;\u8de8\u96f6&#xff0c;\u53ea\u80fd\u5199&#034;\u65b9\u5411\u4e3a\u6b63\u3001\u672a\u8fbe\u53ef\u5224\u5b9a\u6c34\u5e73&#034;\u3002\u7b49\u9898\u91cf\u52a0\u5230 60&#xff0c;\u540c\u6837\u5e45\u5ea6\u624d\u53ef\u80fd\u663e\u8457\u3002<\/p>\n<h3>\u4e94\u3001\u591a\u5c11\u9898\u624d\u591f&#xff1a;\u6700\u5c0f\u6837\u672c\u91cf\u4f30\u7b97<\/h3>\n<p>\u4e0d\u7528\u516c\u5f0f\u4e5f\u80fd\u7ed9\u4e2a\u53ef\u64cd\u4f5c\u7684\u5bf9\u7167\u8868\u3002\u8bbe\u76ee\u6807\u68c0\u51fa\u5e45\u5ea6\u4e3a \u0394&#xff08;\u7edd\u5bf9\u767e\u5206\u70b9&#xff09;&#xff0c;\u03b1&#061;0.05\u3001power&#061;0.8\u3001\u53cc\u4fa7&#xff0c;\u7c97\u7565\u4f30\u7b97\u6240\u9700\u72ec\u7acb\u5355\u4f4d\u6570&#xff08;\u9898\u6570&#xff0c;\u4e0d\u662f\u8c03\u7528\u6b21\u6570&#xff09;&#xff1a;<\/p>\n<table>\n<tr>\u76ee\u6807 \u0394\u57fa\u7ebf\u63d0\u53ca\u7387 20%\u57fa\u7ebf 35%\u57fa\u7ebf 50%<\/tr>\n<tbody>\n<tr>\n<td>&#043;30pp<\/td>\n<td>\u7ea6 26 \u9898<\/td>\n<td>\u7ea6 34 \u9898<\/td>\n<td>\u7ea6 42 \u9898<\/td>\n<\/tr>\n<tr>\n<td>&#043;15pp<\/td>\n<td>\u7ea6 95 \u9898<\/td>\n<td>\u7ea6 125 \u9898<\/td>\n<td>\u7ea6 150 \u9898<\/td>\n<\/tr>\n<tr>\n<td>&#043;5pp<\/td>\n<td>\u7ea6 800 \u9898<\/td>\n<td>\u7ea6 1000 \u9898<\/td>\n<td>\u7ea6 1200 \u9898<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&#xff08;\u6309\u4e24\u6bd4\u4f8b\u68c0\u9a8c\u8fd1\u4f3c\u8ba1\u7b97&#xff0c;\u672a\u505a\u8fde\u7eed\u6027\u6821\u6b63&#xff1b;\u4ec5\u4f9b\u6392\u671f\u53c2\u8003\u3002&#xff09;<\/p>\n<p>\u8fd9\u5f20\u8868\u7684\u73b0\u5b9e\u542b\u4e49&#xff1a;20 \u9898\u80fd\u770b\u51fa&#034;\u6709\u6ca1\u6709&#034;\u548c&#034;\u5927\u6982\u65b9\u5411&#034;&#xff0c;\u770b\u4e0d\u51fa&#034;\u6da8\u4e86 5 \u4e2a\u70b9&#034;\u3002\u8c01\u62ff 20 \u9898\u7684\u68c0\u6d4b\u7ed3\u679c\u8bf4&#034;\u672c\u6708\u63d0\u5347\u4e86 5%&#034;&#xff0c;\u8fd9\u4e2a\u7ed3\u8bba\u5728\u7edf\u8ba1\u4e0a\u4e0d\u6210\u7acb\u3002<\/p>\n<p>\u4e5f\u6b63\u56e0\u4e3a\u5982\u6b64&#xff0c;\u628a\u6548\u679c\u627f\u8bfa\u5199\u8fdb\u5408\u540c\u3001\u6309&#034;\u63d0\u5347 N \u4e2a\u767e\u5206\u70b9&#034;\u9a8c\u6536&#xff0c;\u5728\u5de5\u7a0b\u4e0a\u662f\u6709\u524d\u63d0\u7684&#xff1a;\u9898\u91cf\u5fc5\u987b\u591f\u3002\u9898\u91cf\u4e0d\u591f\u800c\u627f\u8bfa\u5e45\u5ea6\u7684&#xff0c;\u53ea\u80fd\u9760\u6311\u9898\u3001\u6311\u5e73\u53f0\u3001\u6311\u91c7\u6837\u6b21\u6570\u6765\u51d1\u6570\u3002<\/p>\n<h3>\u516d\u3001\u4e24\u4e2a\u5751<\/h3>\n<p>\u5751\u4e00&#xff1a;\u91cd\u590d\u8ba1\u6570\u628a\u5206\u6bcd\u6491\u5927\u4e86\u3002<\/p>\n<p>\u65e9\u671f\u53bb\u91cd\u952e\u53ea\u7528\u4e86 query_id&#xff0c;\u6ca1\u5e26 sample_k\u3002\u7ed3\u679c\u662f\u540c\u4e00\u9898\u7684 3 \u6b21\u91c7\u6837\u88ab\u5408\u5e76\u6210 1 \u6761\u8bb0\u5f55&#xff0c;\u4f46\u5206\u6bcd\u6309 3 \u500d\u7b97&#xff0c;\u63d0\u53ca\u7387\u76f4\u63a5\u88ab\u538b\u5230\u4e09\u5206\u4e4b\u4e00\u3002\u8868\u4e0a\u770b\u662f&#034;\u4f18\u5316\u5931\u6548&#034;&#xff0c;\u5b9e\u9645\u662f\u952e\u5199\u9519\u4e86\u3002<\/p>\n<p>\u4fee\u6cd5&#xff1a;\u53bb\u91cd\u952e\u7edf\u4e00\u4e3a (query_id, sample_k, platform)&#xff0c;\u5165\u5e93\u65f6\u52a0\u552f\u4e00\u7d22\u5f15&#xff1b;\u7edf\u8ba1\u524d\u5148\u8dd1\u4e00\u904d count(distinct key) &#061;&#061; \u9884\u671f\u603b\u6570 \u7684\u65ad\u8a00&#xff0c;\u4e0d\u7b49\u5c31\u4e2d\u6b62\u3002<\/p>\n<p>\u5751\u4e8c&#xff1a;\u5e76\u53d1\u5199\u5165\u5bfc\u81f4\u6837\u672c\u4e71\u5e8f\u3001\u914d\u5bf9\u9519\u4f4d\u3002<\/p>\n<p>\u590d\u6d4b\u6570\u636e\u7528 3 \u5e76\u53d1\u5199\u5e93&#xff0c;\u5199\u5165\u5b8c\u6210\u987a\u5e8f\u4e0e sample_k \u4e0d\u4e00\u81f4\u3002\u914d\u5bf9\u811a\u672c\u6309\u884c\u53f7\u5bf9\u9f50&#xff0c;\u7ed3\u679c\u628a A \u9898\u7684&#034;\u8fd9\u6b21&#034;\u914d\u5230\u4e86 B \u9898\u7684&#034;\u4e0a\u6b21&#034;\u4e0a&#xff0c;\u5dee\u503c\u5168\u662f\u566a\u97f3\u3002<\/p>\n<p>\u4fee\u6cd5\u4e24\u6761&#xff1a;\u4e00\u662f\u914d\u5bf9\u524d\u5f3a\u5236 order by query_id, sample_k&#xff1b;\u4e8c\u662f\u52a0\u6821\u9a8c\u2014\u2014\u4e24\u4fa7\u7684 query_id \u96c6\u5408\u5fc5\u987b\u5b8c\u5168\u76f8\u540c&#xff0c;\u591a\u4e00\u6761\u5c11\u4e00\u6761\u76f4\u63a5\u629b\u5f02\u5e38&#xff0c;\u4e0d\u8bb8\u9759\u9ed8\u5bf9\u9f50\u3002<\/p>\n<h3>\u4e03\u3001\u8fd9\u5957\u65b9\u6cd5\u6d4b\u4e0d\u51fa\u4ec0\u4e48<\/h3>\n<ul>\n<li>\u6d4b\u4e0d\u51fa\u56e0\u679c\u3002 \u5dee\u503c\u663e\u8457\u53ea\u8bf4\u660e&#034;\u8fd9\u6b21\u548c\u4e0a\u6b21\u4e0d\u4e00\u6837&#034;&#xff0c;\u4e0d\u80fd\u8bc1\u660e\u662f\u67d0\u9879\u4f18\u5316\u5bfc\u81f4\u7684\u3002\u8981\u5f52\u56e0\u5f97\u505a\u5bf9\u7167&#xff08;\u540c\u57ce\u672a\u4f18\u5316\u7684\u5bf9\u7167\u7ec4&#xff09;&#xff0c;\u6210\u672c\u9ad8\u5f97\u591a\u3002<\/li>\n<li>\u6d4b\u4e0d\u51fa\u7edd\u5bf9\u6c34\u5e73\u3002 \u63d0\u53ca\u7387\u4f9d\u8d56\u9898\u76ee\u6c60&#xff0c;\u6362\u4e00\u6279\u9898\u5c31\u4e0d\u80fd\u8de8\u6279\u6bd4\u8f83\u3002<\/li>\n<li>\u6d4b\u4e0d\u51fa\u957f\u5c3e\u3002 \u533a\u95f4\u5bbd\u5ea6\u7531 n \u51b3\u5b9a&#xff0c;\u957f\u5c3e\u95ee\u6cd5\u9898\u91cf\u5c11&#xff0c;\u7ed3\u8bba\u5929\u7136\u66f4\u5f31\u3002<\/li>\n<li>\u6d4b\u4e0d\u51fa\u771f\u5b9e\u7528\u6237\u5206\u5e03\u3002 \u91c7\u6837\u662f\u7b49\u6743\u91cd\u7684&#xff0c;\u771f\u5b9e\u7528\u6237\u7684\u95ee\u6cd5\u5206\u5e03\u5e76\u4e0d\u7b49\u6743\u3002\u8981\u8d34\u8fd1\u771f\u5b9e&#xff0c;\u5f97\u6309\u641c\u7d22\u91cf\u52a0\u6743&#xff0c;\u800c\u591a\u6570\u4f01\u4e1a\u62ff\u4e0d\u5230\u8fd9\u4e2a\u6743\u91cd\u3002<\/li>\n<\/ul>\n<p>\u7ed3\u8bba\u4e00\u53e5\u8bdd&#xff1a;\u5148\u7b97\u533a\u95f4&#xff0c;\u518d\u8c08\u5dee\u503c&#xff1b;\u533a\u95f4\u8de8\u96f6&#xff0c;\u5c31\u4e0d\u8981\u5199&#034;\u63d0\u5347&#034;\u3002\u8fd9\u4e00\u6761\u4e0d\u89e3\u51b3&#034;\u6392\u540d\u80fd\u4e0d\u80fd\u4fdd\u8bc1&#034;\u7684\u95ee\u9898&#xff0c;\u4f46\u5b83\u80fd\u8ba9\u62a5\u544a\u91cc\u7684\u6bcf\u4e2a\u6570\u5b57\u90fd\u7ad9\u5f97\u4f4f\u3002<\/p>\n<p>\u4f60\u4eec\u5728\u505a\u590d\u6d4b\u6bd4\u5bf9\u65f6&#xff0c;\u662f\u6309\u603b\u4f53\u6bd4\u4f8b\u51cf&#xff0c;\u8fd8\u662f\u6309\u9898\u914d\u5bf9&#xff1f;\u8bc4\u8bba\u533a\u804a\u804a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\/* MD \/ \u5bcc\u6587\u672c\u4e2d\u7684 .toc\uff08\u542b\u535a\u5ba2\u56ed\u642c\u5bb6\u7b49\u5d4c\u5957\u7ed3\u6784\uff09\uff1b.toc-box \u5728\u4fa7\u680f\uff0c\u4e0d\u53d7\u5f71\u54cd *\/#content_views .toc,\/* \u7f16\u8f91\u5668\u5e38\u5728\u76ee\u5f55\u524d\u540e\u63d2\u5165\u7a7a p\uff08:empty \u4ecd\u5360 20px\uff09\uff0c\u4e00\u5e76\u53bb\u6389\u907f\u514d\u9876\u7a7a\u9699 *\/#content_views.markdown_views &gt; p:empty:has(+ .toc),#content_views.markdown_views &gt; .toc + p:empty,\/* \u5bcc\u6587\u672c\u65e7\u7248\u76ee\u5f55\u6807\u8bb0 *\/#content<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[4802],"topic":[],"class_list":["post-123585","post","type-post","status-publish","format-standard","hentry","category-server","tag-geo"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u540c\u6279\u9898\u91cd\u590d\u91c7\u6837 \u65b9\u5dee\u4f30\u8ba1\u4e0e\u7f6e\u4fe1\u533a\u95f4\u7684\u96f6\u4f9d\u8d56\u5b9e\u73b0\uff082026\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/123585.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u540c\u6279\u9898\u91cd\u590d\u91c7\u6837 \u65b9\u5dee\u4f30\u8ba1\u4e0e\u7f6e\u4fe1\u533a\u95f4\u7684\u96f6\u4f9d\u8d56\u5b9e\u73b0\uff082026\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\/* MD \/ \u5bcc\u6587\u672c\u4e2d\u7684 .toc\uff08\u542b\u535a\u5ba2\u56ed\u642c\u5bb6\u7b49\u5d4c\u5957\u7ed3\u6784\uff09\uff1b.toc-box \u5728\u4fa7\u680f\uff0c\u4e0d\u53d7\u5f71\u54cd *\/#content_views .toc,\/* \u7f16\u8f91\u5668\u5e38\u5728\u76ee\u5f55\u524d\u540e\u63d2\u5165\u7a7a p\uff08:empty \u4ecd\u5360 20px\uff09\uff0c\u4e00\u5e76\u53bb\u6389\u907f\u514d\u9876\u7a7a\u9699 *\/#content_views.markdown_views &gt; p:empty:has(+ .toc),#content_views.markdown_views &gt; .toc + p:empty,\/* \u5bcc\u6587\u672c\u65e7\u7248\u76ee\u5f55\u6807\u8bb0 *\/#content\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/123585.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-07T10:58:15+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/123585.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/123585.html\",\"name\":\"\u540c\u6279\u9898\u91cd\u590d\u91c7\u6837 \u65b9\u5dee\u4f30\u8ba1\u4e0e\u7f6e\u4fe1\u533a\u95f4\u7684\u96f6\u4f9d\u8d56\u5b9e\u73b0\uff082026\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-11-07T10:58:15+00:00\",\"dateModified\":\"2026-11-07T10:58:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/123585.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/123585.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/123585.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u540c\u6279\u9898\u91cd\u590d\u91c7\u6837 \u65b9\u5dee\u4f30\u8ba1\u4e0e\u7f6e\u4fe1\u533a\u95f4\u7684\u96f6\u4f9d\u8d56\u5b9e\u73b0\uff082026\uff09\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u540c\u6279\u9898\u91cd\u590d\u91c7\u6837 \u65b9\u5dee\u4f30\u8ba1\u4e0e\u7f6e\u4fe1\u533a\u95f4\u7684\u96f6\u4f9d\u8d56\u5b9e\u73b0\uff082026\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/123585.html","og_locale":"zh_CN","og_type":"article","og_title":"\u540c\u6279\u9898\u91cd\u590d\u91c7\u6837 \u65b9\u5dee\u4f30\u8ba1\u4e0e\u7f6e\u4fe1\u533a\u95f4\u7684\u96f6\u4f9d\u8d56\u5b9e\u73b0\uff082026\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\/* MD \/ \u5bcc\u6587\u672c\u4e2d\u7684 .toc\uff08\u542b\u535a\u5ba2\u56ed\u642c\u5bb6\u7b49\u5d4c\u5957\u7ed3\u6784\uff09\uff1b.toc-box \u5728\u4fa7\u680f\uff0c\u4e0d\u53d7\u5f71\u54cd *\/#content_views .toc,\/* \u7f16\u8f91\u5668\u5e38\u5728\u76ee\u5f55\u524d\u540e\u63d2\u5165\u7a7a p\uff08:empty \u4ecd\u5360 20px\uff09\uff0c\u4e00\u5e76\u53bb\u6389\u907f\u514d\u9876\u7a7a\u9699 *\/#content_views.markdown_views &gt; p:empty:has(+ .toc),#content_views.markdown_views &gt; .toc + p:empty,\/* \u5bcc\u6587\u672c\u65e7\u7248\u76ee\u5f55\u6807\u8bb0 *\/#content","og_url":"https:\/\/www.wsisp.com\/helps\/123585.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-11-07T10:58:15+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/123585.html","url":"https:\/\/www.wsisp.com\/helps\/123585.html","name":"\u540c\u6279\u9898\u91cd\u590d\u91c7\u6837 \u65b9\u5dee\u4f30\u8ba1\u4e0e\u7f6e\u4fe1\u533a\u95f4\u7684\u96f6\u4f9d\u8d56\u5b9e\u73b0\uff082026\uff09 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-11-07T10:58:15+00:00","dateModified":"2026-11-07T10:58:15+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/123585.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/123585.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/123585.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u540c\u6279\u9898\u91cd\u590d\u91c7\u6837 \u65b9\u5dee\u4f30\u8ba1\u4e0e\u7f6e\u4fe1\u533a\u95f4\u7684\u96f6\u4f9d\u8d56\u5b9e\u73b0\uff082026\uff09"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/123585","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=123585"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/123585\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=123585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=123585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=123585"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=123585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}