{"id":1939,"date":"2025-10-24T08:44:28","date_gmt":"2025-10-24T00:44:28","guid":{"rendered":"http:\/\/www.applicationsofllm.com\/?p=1939"},"modified":"2025-10-24T14:23:20","modified_gmt":"2025-10-24T06:23:20","slug":"%e5%9b%be%e7%ba%b8%e6%a3%80%e7%b4%a2%e9%a2%86%e5%9f%9f%e5%a4%a7%e6%a8%a1%e5%9e%8b%e7%ab%af%e4%be%a7%e6%80%a7%e8%83%bdpk%ef%bc%9a%e8%b0%81%e6%9b%b4%e8%83%9c%e4%b8%80%e7%ad%b9%ef%bc%9f%e8%bf%99%e4%bb%bd","status":"publish","type":"post","link":"http:\/\/www.applicationsofllm.com\/index.php\/2025\/10\/24\/%e5%9b%be%e7%ba%b8%e6%a3%80%e7%b4%a2%e9%a2%86%e5%9f%9f%e5%a4%a7%e6%a8%a1%e5%9e%8b%e7%ab%af%e4%be%a7%e6%80%a7%e8%83%bdpk%ef%bc%9a%e8%b0%81%e6%9b%b4%e8%83%9c%e4%b8%80%e7%ad%b9%ef%bc%9f%e8%bf%99%e4%bb%bd\/","title":{"rendered":"\u56fe\u7eb8\u68c0\u7d22\u5927\u6a21\u578b\u7aef\u4fa7\u6027\u80fd\u8bc4\u6d4b\uff1a\u60e0\u666eZ8 Fury G5\u5b9e\u6d4b\u544a\u8bc9\u4f60\u7b54\u6848"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\"><a><\/a><a>1. <\/a>\u75db\u70b9\u4e0e\u6311\u6218<\/h1>\n\n\n\n<p>       \u8fc7\u53bb\u4e24\u5e74\uff0c\u5927\u6a21\u578b\u6280\u672f\u5728\u6587\u672c\u751f\u6210\u3001\u56fe\u50cf\u7406\u89e3\u3001\u4ee3\u7801\u5f00\u53d1\u7b49\u901a\u7528\u9886\u57df\u5b9e\u73b0\u8de8\u8d8a\u5f0f\u7a81\u7834\uff0c\u6280\u672f\u6210\u719f\u5ea6\u4e0e\u843d\u5730\u80fd\u529b\u5df2\u5f97\u5230\u5e02\u573a\u5e7f\u6cdb\u9a8c\u8bc1\u3002\u7136\u800c\uff0c\u5728\u5236\u9020\u4e1a\u8fd9\u4e00\u5f3a\u8c03<strong>\u4e13\u4e1a\u77e5\u8bc6\u58c1\u5792\u3001\u573a\u666f\u590d\u6742\u5ea6\u9ad8\u3001\u6570\u636e\u683c\u5f0f\u7279\u6b8a<\/strong>\u7684\u5782\u76f4\u9886\u57df\uff0c\u5927\u6a21\u578b\u80fd\u5426\u7a81\u7834 \u201c\u901a\u7528\u80fd\u529b\u201d \u4e0e \u201c\u884c\u4e1a\u9700\u6c42\u201d \u7684\u9002\u914d\u74f6\u9888\uff0c\u771f\u6b63\u5d4c\u5165\u5de5\u7a0b\u94fe\u8def\u5e76\u63d0\u5347\u6838\u5fc3\u6548\u7387\uff0c\u59cb\u7ec8\u662f\u4ea7\u4e1a\u754c\u4e0e\u6280\u672f\u754c\u5171\u540c\u5173\u6ce8\u7684\u6838\u5fc3\u8bae\u9898\u3002<\/p>\n\n\n\n<p>        \u5728\u5236\u9020\u4e1a\u6838\u5fc3\u7684\u56fe\u7eb8\u68c0\u7d22\u573a\u666f\u4e2d\uff0c\u8bbe\u8ba1\u5de5\u7a0b\u5e08\u9762\u4e34\u7740\u66f4\u4e3a\u5177\u4f53\u7684\u6548\u7387\u75db\u70b9\uff1a\u4e3a\u5b8c\u6210\u4ea7\u54c1\u8fed\u4ee3\u3001\u5de5\u827a\u4f18\u5316\u6216\u6545\u969c\u6392\u67e5\uff0c\u5f80\u5f80\u9700\u8981\u4ece\u6210\u767e\u4e0a\u5343\u4efd\u5305\u542b\u96f6\u4ef6\u56fe\u3001\u88c5\u914d\u56fe\u7684\u5386\u53f2\u56fe\u7eb8\u4e2d\uff0c\u7cbe\u51c6\u5b9a\u4f4d\u542b\u7279\u5b9a\u96f6\u90e8\u4ef6\u89c4\u683c\u3001\u6750\u6599\u724c\u53f7\u6216\u6280\u672f\u8981\u6c42\uff08\u5982\u516c\u5dee\u3001\u70ed\u5904\u7406\u6807\u51c6\uff09\u7684\u6587\u4ef6\u3002\u4f20\u7edf\u6a21\u5f0f\u4e0b\uff0c\u8fd9\u4e00\u8fc7\u7a0b\u4f9d\u8d56\u4eba\u5de5\u6309\u76ee\u5f55\u7ffb\u9605\u3001\u51ed\u7ecf\u9a8c\u7b5b\u9009\uff0c\u6216\u4ec5\u901a\u8fc7\u5355\u4e00\u5173\u952e\u8bcd\u5339\u914d\u68c0\u7d22\uff0c\u4e0d\u4ec5\u8017\u65f6\u8017\u529b\uff08\u5355\u6b21\u68c0\u7d22\u5e38\u9700\u6570\u5c0f\u65f6\u751a\u81f3\u6570\u5929\uff09\uff0c\u66f4\u6613\u56e0\u4fe1\u606f\u9057\u6f0f\u5bfc\u81f4\u5236\u9020\u504f\u5dee\uff1b\u800c\u591a\u6a21\u6001\u5927\u6a21\u578b\u4e0e\u667a\u80fd\u4f53\u6280\u672f\u7684\u534f\u540c\u53d1\u5c55\uff0c\u6b63\u6253\u7834\u8fd9\u4e00\u50f5\u5c40 \u2014\u2014 \u901a\u8fc7<strong>\u56fe\u7eb8\u81ea\u52a8\u77e2\u91cf\u5316\u89e3\u6790\u3001\u4e13\u4e1a\u672f\u8bed\u8bed\u4e49\u6620\u5c04\u3001\u8de8\u6a21\u6001\u68c0\u7d22\u5339\u914d<\/strong>\u7b49\u6280\u672f\uff0c\u8ba9 \u201c\u4ee5\u81ea\u7136\u8bed\u8a00\u63cf\u8ff0\u76f4\u63a5\u5b9a\u4f4d\u76ee\u6807\u56fe\u7eb8\u201d \u4ece\u6280\u672f\u6784\u60f3\u9010\u6b65\u8d70\u5411\u5de5\u7a0b\u5b9e\u8df5\u3002<\/p>\n\n\n\n<p>        \u9762\u5bf9\u4e0d\u540c\u5382\u5546\u63a8\u51fa\u7684\u5927\u6a21\u578b\uff0c\u8c01\u80fd\u5728\u56fe\u7eb8\u89e3\u6790\u4e0e\u68c0\u7d22\u7684\u590d\u6742\u4efb\u52a1\u4e2d\u8131\u9896\u800c\u51fa\uff1f<\/p>\n\n\n\n<p>        <strong>\u9996\u5148\u6211\u4eec\u9009\u62e9\u4e86\u6d4b\u8bd5\u5e73\u53f0\u90e8\u7f72\u5728\u60e0\u666eZ8 Fury G5<\/strong><strong>\u53f0\u5f0f\u5de5\u4f5c\u7ad9\u4e0a\uff0c Z8 Fury G5<\/strong><strong>\u80fd\u591f\u9ad8\u6548\u5904\u7406\u6bcf\u5c0f\u65f6\u6570TB<\/strong><strong>\u7ea7\u522b\u7684\u6570\u636e\u3002\u8fd9\u79cd\u5f3a\u5927\u7684\u8ba1\u7b97\u80fd\u529b\u652f\u6301\u590d\u6742\u7684\u751f\u6210\u5f0fAI<\/strong><strong>\u6a21\u578b\u8fd0\u884c\uff0c\u80fd\u591f\u663e\u8457\u63d0\u5347\u5de5\u7a0b\u7684\u6548\u7387\u548c\u51b3\u7b56\u51c6\u786e\u6027\u3002<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"753\" height=\"515\" src=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-66.jpeg\" alt=\"\" class=\"wp-image-1940\" srcset=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-66.jpeg 753w, http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-66-300x205.jpeg 300w\" sizes=\"auto, (max-width: 753px) 100vw, 753px\" \/><\/figure>\n\n\n\n<p>        <strong>\u6d4b\u8bd5\u5e73\u53f0\u90e8\u7f72\u5176\u4ed6\u5efa\u8bae\uff0c\u9488\u5bf9\u4e2d\u5c0f\u53c2\u6570\u89c4\u6a21\u5f00\u6e90\u6a21\u578b\u7684\u8bc4\u6d4b\uff0c\u5728\u60e0\u666eZBook X<\/strong><strong>\u4e0a\u4e5f\u53ef\u4ee5\u5b9e\u73b0\uff0c\u60e0\u666eZBook X<\/strong><strong>\u642d\u8f7d\u82f1\u7279\u5c14\u9177\u777fUltra9<\/strong><strong>\u7684\u82f1\u7279\u5c14vPro<\/strong><strong>\uff0c\u9177\u777fUltra 200H<\/strong><strong>\uff0c\u5168\u80fdAI PC <\/strong><strong>\u5546\u52a1\u786c\u5b9e\u529b\u3002<\/strong><\/p>\n\n\n\n<p>        <strong>\u6d4b\u8bd5\u5e73\u53f0\u53ef\u4ee5\u5b9e\u73b0\u7aef\u4fa7\u6a21\u578b\u5bf9 \u201c<\/strong><strong>\u6027\u80fd\u3001\u7a33\u5b9a\u6027\u3001\u6269\u5c55\u6027\u201d <\/strong><strong>\u7684\u4e09\u91cd\u5e73\u8861\u8981\u6c42\uff0c\u4e3a\u4e0d\u540c\u67b6\u6784\u5f00\u6e90\u6a21\u578b\u7684\u80fd\u6548\u6bd4\u3001\u63a8\u7406\u7cbe\u5ea6\u3001\u5e76\u53d1\u5904\u7406\u80fd\u529b\u7b49\u6838\u5fc3\u6307\u6807\u63d0\u4f9b\u4e86\u53ef\u9760\u7684\u786c\u4ef6\u652f\u6491\u3002<\/strong><\/p>\n\n\n\n<p>        <strong>\u5c24\u5176\u642d\u8f7d\u82f1\u7279\u5c14\u9177\u777f Ultra9 vPro <\/strong><strong>\u5904\u7406\u5668\uff0c\u51ed\u501f\u4e13\u4e3a AI <\/strong><strong>\u8d1f\u8f7d\u4f18\u5316\u7684\u5f02\u6784\u8ba1\u7b97\u67b6\u6784\u4e0e\u7aef\u4fa7\u8bc4\u6d4b\u573a\u666f\u6df1\u5ea6\u9002\u914d\u7684\u786c\u4ef6\u8bbe\u8ba1\uff0cUltra9 vPro <\/strong><strong>\u7684\u591a\u6838\u6027\u80fd24 <\/strong><strong>\u6838 24 <\/strong><strong>\u7ebf\u7a0b +<\/strong><strong>\u4e0e 13 TOPS NPU <\/strong><strong>\u7b97\u529b\u5f62\u6210\u534f\u540c\uff0c\u53ef\u9ad8\u6548\u652f\u6491\u4ece 7B <\/strong><strong>\u5230 12B <\/strong><strong>\u53c2\u6570\u89c4\u6a21\u5f00\u6e90\u6a21\u578b\u7684\u672c\u5730\u63a8\u7406\u3002<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"749\" height=\"335\" src=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-4.jpg\" alt=\"\" class=\"wp-image-1941\" srcset=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-4.jpg 749w, http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-4-300x134.jpg 300w\" sizes=\"auto, (max-width: 749px) 100vw, 749px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"748\" height=\"561\" src=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-68.jpeg\" alt=\"\" class=\"wp-image-1944\" srcset=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-68.jpeg 748w, http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-68-300x225.jpeg 300w\" sizes=\"auto, (max-width: 748px) 100vw, 748px\" \/><\/figure>\n\n\n\n<p>        \u5176\u6b21\u6211\u4eec\u9009\u62e9\u4e86\u4ee5\u4e0b\u4e94\u6b3e\u5f00\u6e90\u5927\u6a21\u578b\uff0c\u5728\u771f\u5b9e\u5e73\u53f0\u4e2d\u5c55\u5f00\u4e86\u4e00\u573a\u201c\u56fe\u7eb8\u667a\u80fd\u52a9\u624b\u201d\u7684\u5927\u6bd4\u62fc\uff1ameta-llama\/Llama-3.1-8B-Instruct\uff0cGoogle\/gemma-3-12b\uff0cdeepseek-ai\/DeepSeek-R1-Distill-Qwen-7B\uff0cQwen\/Qwen2.5-7B-Instruct\uff0copenbmb\/MiniCPM4.1-8B\u3002\u5404\u4e2a\u6a21\u578b\u7684\u5173\u6ce8\u5ea6\u548c\u4e0b\u8f7d\u91cf\u5982\u88681\u6240\u793a\u3002<\/p>\n\n\n\n<p>\u88681 \u4e0d\u540c\u5f00\u6e90\u5927\u6a21\u578b\u5728Huggingface\u548cModelScope\u4e0a\u7684\u5173\u6ce8\u5ea6\u548c\u4e0b\u8f7d\u91cf\uff08\u7edf\u8ba1\u4e8e2025.9.23\uff09<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u6a21\u578b\u540d\u79f0<\/td><td>Huggingface \u661f\u6807\u6570<\/td><td>Hugging face \u4e0b\u8f7d\u91cf<\/td><td>ModelScope \u4e0b\u8f7d\u91cf<\/td><\/tr><tr><td>Llama-3.1-8B-Instruct<\/td><td>62.2k<\/td><td>7.09M<\/td><td>219.6k<\/td><\/tr><tr><td>gemma-3-12b-it<\/td><td>30.4k<\/td><td>504k<\/td><td>14.3k<\/td><\/tr><tr><td>DeepSeek-R1-Distill-Qwen-7B<\/td><td>96.5k<\/td><td>814k<\/td><td>574.3k<\/td><\/tr><tr><td>Qwen2.5-7B-Instruct<\/td><td>50.6k<\/td><td>6.89M<\/td><td>3.8M<\/td><\/tr><tr><td>MiniCPM4.1-8B<\/td><td>2.05k<\/td><td>4.02k<\/td><td>2.4k<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>        \u4ece\u6570\u636e\u4e2d\u53ef\u4ee5\u770b\u51fa\uff0c\u5f53\u524d\u5927\u8bed\u8a00\u6a21\u578b\u5e02\u573a\u683c\u5c40\u4e3b\u8981\u7531 Llama-3.1-8B-Instruct \u548c Qwen2.5-7B-Instruct \u4e24\u6b3e\u6a21\u578b\u4e3b\u5bfc\uff0c\u5b83\u4eec\u51ed\u501f\u6570\u767e\u4e07\u7ea7\u522b\u7684\u4e0b\u8f7d\u91cf\uff0c\u786e\u7acb\u4e86\u663e\u8457\u7684\u5e02\u573a\u9886\u5148\u5730\u4f4d\u3002Llama-3.1 \u5728\u4ee5Hugging Face\u4e3a\u4ee3\u8868\u7684\u56fd\u9645\u5f00\u53d1\u8005\u793e\u533a\u4e2d\u8868\u73b0\u51fa\u5f3a\u5927\u7684\u5f71\u54cd\u529b\uff0c\u800c Qwen2.5 \u5219\u901a\u8fc7\u5728Hugging Face\u548cModelScope\u4e24\u5927\u4e3b\u6d41\u5e73\u53f0\u4e0a\u7684\u5747\u8861\u4e14\u5353\u8d8a\u7684\u8868\u73b0\uff0c\u5b9e\u73b0\u4e86\u8de8\u5e02\u573a\u7684\u5e7f\u6cdb\u8986\u76d6\u3002\u6b64\u5916\uff0cDeepSeek-R1-Distill-Qwen-7B \u4ee5\u6700\u9ad8\u7684\u793e\u533a\u5173\u6ce8\u5ea6\u6307\u6807\u8131\u9896\u800c\u51fa\uff0c\u8fd9\u8868\u660e\u5e02\u573a\u7ade\u4e89\u7684\u7ef4\u5ea6\u5df2\u8d85\u8d8a\u5355\u7eaf\u7684\u4e0b\u8f7d\u91cf\uff0c\u6a21\u578b\u7684\u5f00\u53d1\u8005\u751f\u6001\u4e0e\u793e\u533a\u5438\u5f15\u529b\u540c\u6837\u6784\u6210\u4e86\u5176\u6838\u5fc3\u7ade\u4e89\u529b\u7684\u5173\u952e\u90e8\u5206\u3002<\/p>\n\n\n\n<p>        \u5728\u672c\u6b21\u6bd4\u62fc\u7684\u5e73\u53f0\u201c\u56fe\u7eb8\u667a\u80fd\u52a9\u624b\u201d\u662f\u4e00\u4e2a\u80fd\u591f\u57fa\u4e8e\u5927\u8bed\u8a00\u6a21\u578b\u7684\u5c06\u81ea\u7136\u8bed\u8a00\u8f6c\u6362\u6210SQL\u8bed\u53e5\uff0c\u5b9e\u73b0\u7aef\u5230\u7aef\u7684\u667a\u80fd\u68c0\u7d22\u52a9\u624b\uff0c\u7528\u6237\u4ec5\u9700\u8f93\u5165\u81ea\u7136\u8bed\u8a00\u5373\u53ef\u7cbe\u786e\u5b9a\u4f4d\u76ee\u6807\u56fe\u7eb8\u3002\u5927\u6a21\u578b\u5728\u8fd9\u4e2a\u52a9\u624b\u4e2d\u8d77\u5230\u4e24\u4e2a\u4f5c\u7528\uff1a<\/p>\n\n\n\n<p>1.\u67e5\u8be2\u7528\u6237\u610f\u56fe\uff0c\u89e3\u6790\u7528\u6237\u8f93\u5165\u7684\u81ea\u7136\u8bed\u8a00\uff0c\u5c06\u5176\u8f6c\u5316\u4e3a\u952e\u503c\u5bf9\u7684\u5f62\u5f0f\uff1b<\/p>\n\n\n\n<p>2.\u5c06\u89e3\u6784\u5b8c\u6210\u7684\u952e\u503c\u5bf9\u8f6c\u5316\u6210SQL\u8bed\u53e5\u8fdb\u884c\u68c0\u7d22\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><a>2. <\/a>\u5b9e\u9a8c\u5e73\u53f0\u4e0e\u65b9\u6cd5<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">2.1 \u5b9e\u9a8c\u5e73\u53f0\u67b6\u6784<\/h2>\n\n\n\n<p>        \u672c\u6b21\u8bc4\u6d4b\u56f4\u7ed5\u4e00\u4e2a\u56fe\u7eb8\u68c0\u7d22\u5e73\u53f0\uff0c\u5e73\u53f0\u4e3b\u8981\u5305\u542b\u4e24\u4e2a\u529f\u80fd\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u56fe\u7eb8\u5904\u7406\uff1a<ul><li>1.\u4f7f\u7528\u76ee\u6807\u68c0\u6d4b\u6a21\u578b\uff08\u5982 YOLO\uff09\u5bf9\u56fe\u7eb8\u8fdb\u884c\u533a\u57df\u5206\u5272\uff08\u5982\u4e09\u89c6\u56fe\u3001BOM\u660e\u7ec6\u680f\u3001\u6280\u672f\u8981\u6c42\uff09\u3002<\/li><\/ul><ul><li>2.\u501f\u52a9 OCR \u6216\u591a\u6a21\u6001\u5927\u6a21\u578b\u63d0\u53d6\u6587\u672c\u4fe1\u606f\u3002<\/li><\/ul>\n<ul class=\"wp-block-list\">\n<li>3.\u5c06\u7ed3\u679c\u7ed3\u6784\u5316\u4e3a\u952e\u503c\u5bf9\uff08\u5982\u201c\u96f6\u4ef6\u540d\u79f0-\u8f74\u627f\u201d\u201c\u6750\u6599-Q235\u94a2\u201d\uff09\u7684\u5f62\u5f0f\u5b58\u50a8\u503c\u6570\u636e\u5e93\u4e2d\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"831\" height=\"442\" src=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-6.jpg\" alt=\"\" class=\"wp-image-1945\" srcset=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-6.jpg 831w, http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-6-300x160.jpg 300w, http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-6-768x408.jpg 768w\" sizes=\"auto, (max-width: 831px) 100vw, 831px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u56fe\u7eb8\u68c0\u7d22\uff1a<ul><li>1.\u6784\u5efa\u4e00\u4e2a\u57fa\u4e8e\u5927\u6a21\u578b\u7684 text2sql \u667a\u80fd\u4f53\u3002<\/li><\/ul><ul><li>2.\u7528\u6237\u901a\u8fc7\u81ea\u7136\u8bed\u8a00\u8f93\u5165\uff08\u5982\u201c\u627e\u51fa\u6240\u6709\u4f7f\u7528Q235\u94a2\u7684\u96f6\u4ef6\u56fe\u7eb8\u201d\uff09\u3002<\/li><\/ul>\n<ul class=\"wp-block-list\">\n<li>3.\u667a\u80fd\u4f53\u5c06\u95ee\u9898\u89e3\u6784\u4e3a\u952e\u503c\u5bf9\u7684\u5f62\u5f0f\uff08\u5982\u201c\u6750\u6599-Q235\u94a2\u201d\uff09\uff0c\u7136\u540e\u8f6c\u5316\u4e3a SQL\u8bed\u53e5\u67e5\u8be2\uff0c\u4ece\u6570\u636e\u5e93\u68c0\u7d22\u76f8\u5173\u56fe\u7eb8\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"442\" src=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-5.jpg\" alt=\"\" class=\"wp-image-1942\" srcset=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-5.jpg 830w, http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-5-300x160.jpg 300w, http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-5-768x409.jpg 768w\" sizes=\"auto, (max-width: 830px) 100vw, 830px\" \/><\/figure>\n\n\n\n<p>\u672c\u6b21\u8bc4\u6d4b\u76ee\u6807\u4e3b\u8981\u805a\u7126\u4e8e\u56fe\u7eb8\u68c0\u7d22\u90e8\u5206\uff0c\u8003\u5bdf\u4e0d\u540c\u5927\u6a21\u578b\u5728\u89e3\u6784\u81ea\u7136\u8bed\u8a00\u4e0e\u751f\u6210sql\u8bed\u53e5\u8fdb\u884c\u68c0\u7d22\u4e24\u5927\u4efb\u52a1\u4e2d\u7684\u8868\u73b0\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2.2\u8bc4\u6d4b\u7ef4\u5ea6\u4e0e\u6307\u6807\u4f53\u7cfb<\/h2>\n\n\n\n<p>        \u4e3a\u5168\u9762\u8861\u91cf\u6a21\u578b\u8868\u73b0\uff0c\u672c\u6b21\u8bc4\u6d4b\u8bbe\u7f6e\u4e86\u4e09\u4e2a\u6838\u5fc3\u7ef4\u5ea6\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u56fe\u7eb8\u6587\u672c\u89e3\u6790\u51c6\u786e\u7387\uff1a<\/strong>\u8861\u91cf\u6a21\u578b\u5728\u63d0\u53d6 BOM\u3001\u6280\u672f\u8981\u6c42\u7b49\u5173\u952e\u4fe1\u606f\u65f6\u7684\u6b63\u786e\u7387\u3002\u6307\u6807\u4e3aPrecision\u3001Recall\u3001F1\u3002\u5176\u4e2dPrecision\u662f\u7cbe\u786e\u7387\uff0c\u8861\u91cf\u6a21\u578b\u5728\u63d0\u53d6\u7684\u6240\u6709\u5173\u952e\u4fe1\u606f\u4e2d\u63d0\u53d6\u6b63\u786e\u7684\u4fe1\u606f\u7684\u6570\u91cf\uff0cPrecision\u8d8a\u9ad8\uff0c\u6a21\u578b\u51c6\u786e\u7387\u8d8a\u9ad8\uff1bRecall\u4ee3\u8868\u53ec\u56de\u7387\uff0c\u8861\u91cf\u6a21\u578b\u63d0\u53d6\u7684\u4fe1\u606f\u5728\u6240\u6709\u6b63\u786e\u4fe1\u606f\u4e2d\u7684\u5360\u6bd4\uff0c\u540c\u6837\u4e5f\u662fRecall\u8d8a\u9ad8\uff0c\u6a21\u578b\u51c6\u786e\u7387\u8d8a\u9ad8\u3002\u6700\u540e\u7684\u7efc\u5408\u6307\u6807\u7528F1\u6765\u8bc4\u6d4b\uff0cF1\u4f5c\u4e3aPrecision\u4e0eRecall\u7684\u8c03\u548c\u5e73\u5747\u6570\uff0c\u8ba1\u7b97\u516c\u5f0f\u4e3aF1 = 2 \u00d7 (Precision \u00d7 Recall) \/ (Precision + Recall)\uff0c\u540c\u6837\u7684F1\u8d8a\u9ad8\uff0c\u7cbe\u786e\u7387\u8d8a\u9ad8\u3002<\/li>\n\n\n\n<li><strong>\u68c0\u7d22\u4e00\u81f4\u6027\uff08text2sql <\/strong><strong>\u51c6\u786e\u7387\uff09\uff1a<\/strong>\u8861\u91cf\u81ea\u7136\u8bed\u8a00\u63cf\u8ff0\u8f6c\u5316\u4e3a SQL \u67e5\u8be2\u7684\u6b63\u786e\u6027\u3002\u6307\u6807\u4e3a\u6267\u884c\u7ed3\u679c Top-1 \u547d\u4e2d\u7387\u3002Top-1 \u547d\u4e2d\u7387\u4e3a\u5927\u6a21\u578b\u5728\u591a\u6b21\u751f\u6210SQL\u8bed\u53e5\u662f\uff0c\u7b2c\u4e00\u6b21\u751f\u6210\u7684\u7b54\u6848\u5c31\u662f\u6b63\u786e\u7684\u6982\u7387\u3002<\/li>\n\n\n\n<li><strong>\u5e73\u53f0\u6574\u4f53\u4f53\u9a8c\uff08\u6548\u7387\u4e0e\u7a33\u5b9a\u6027\uff09\uff1a<\/strong>\u8003\u5bdf\u6a21\u578b\u5728\u771f\u5b9e\u573a\u666f\u4e2d\u5904\u7406\u901f\u5ea6\u3001\u8f93\u51fa\u7a33\u5b9a\u6027\u3002\u6307\u6807\u4e3a\u5e73\u5747\u54cd\u5e94\u65f6\u5ef6\uff08Latency\uff09\u3001\u663e\u5b58\u5360\u7528\uff08VRAM\uff09\u3001GPU\u5229\u7528\u7387\u3002<\/li>\n<\/ol>\n\n\n\n<p>        \u6d4b\u8bd5\u7528\u4f8b\u793a\u4f8b\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u8f93\u5165\uff1a\u300c\u627e\u51fa\u6750\u6599\u4e3a\u94dd\u5408\u91d16061\u3001\u8868\u9762\u5904\u7406\u4e3a\u9633\u6781\u6c27\u5316\u3001\u539a\u5ea6\u57282-5mm\u4e4b\u95f4\u7684\u677f\u4ef6\u56fe\u7eb8\u300d\u3002<\/li>\n\n\n\n<li>\u6807\u51c6\u7b54\u6848\uff1a{\u00a0 &#8220;\u6750\u6599&#8221;: &#8220;\u94dd\u5408\u91d16061&#8221;,\u00a0 &#8220;\u8868\u9762\u5904\u7406&#8221;: &#8220;\u9633\u6781\u6c27\u5316&#8221;,\u00a0\u00a0 &#8220;\u539a\u5ea6&#8221;: &#8220;2-5mm&#8221;,\u00a0 &#8220;\u96f6\u4ef6\u7c7b\u578b&#8221;: &#8220;\u677f\u4ef6&#8221;}<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\"><a>3. <\/a>\u5b9e\u9a8c\u7ed3\u679c\u4e0e\u5206\u6790<\/h1>\n\n\n\n<p>        <strong>\u5e73\u53f0\u90e8\u7f72\u5728\u60e0\u666eZ8 Fury G5<\/strong><strong>\u53f0\u5f0f\u5de5\u4f5c\u7ad9\u4e0a\u786e\u4fdd\u4e86\u8bc4\u6d4b\u7ed3\u679c\u7684\u7a33\u5b9a\u6027\u548c\u53ef\u6bd4\u6027\u3002<\/strong><\/p>\n\n\n\n<p>        \u914d\u7f6e\u8868\uff1a\u751f\u4ea7\u529b\u5de5\u5177HP Z8 Fury G5 \u53f0\u5f0f\u5de5\u4f5c\u7ad9\u914d\u7f6e\u4fe1\u606f<\/p>\n\n\n\n<p>        HP Z8 FURY G5 \u53f0\u5f0f\u5de5\u4f5c\u7ad9\u914d\u7f6e<\/p>\n\n\n\n<p>        \u5904\u7406\u5668\u00a0\u00a0\u00a0 \u82f1\u7279\u5c14\u00ae\u5fd7\u5f3a\u00aeW7-3465X 28C 300W<\/p>\n\n\n\n<p>        \u5185\u5b58\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 512GB (8x64GB) DDR5 4800 ECC PR<\/p>\n\n\n\n<p>        \u786c\u76d8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2TB 2280 PCIe4x4 TLC<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"592\" height=\"789\" src=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-67.jpeg\" alt=\"\" class=\"wp-image-1943\" srcset=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-67.jpeg 592w, http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-67-225x300.jpeg 225w\" sizes=\"auto, (max-width: 592px) 100vw, 592px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">3.1 \u5404\u6307\u6807\u8bc4\u6d4b\u7ed3\u679c<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"829\" height=\"259\" src=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image.gif\" alt=\"\" class=\"wp-image-1946\"\/><\/figure>\n\n\n\n<p>\u56fe2 \u7efc\u5408\u8bc4\u6d4b\u7ed3\u679c<\/p>\n\n\n\n<p>        <strong>\u6280\u672f\u56e2\u961f\u5728Z8 Fury G5<\/strong><strong>\u53f0\u5f0f\u5de5\u4f5c\u7ad9\u5f3a\u52b2\u7684\u82f1\u7279\u5c14\u00ae<\/strong><strong>\u81f3\u5f3a\u00aeW<\/strong><strong>\u5904\u7406\u5668\u7684\u52a9\u529b\u4e0b\uff0c\u53ef\u4ee5\u63d0\u4f9b\u5f3a\u5927\u7684\u56fe\u5f62\u5904\u7406\u80fd\u529b\u548c\u5e76\u884c\u8ba1\u7b97\u80fd\u529b\uff0c\u5b9e\u73b0\u5bf9\u672c\u6b21\u6d4b\u8bd5\u7684\u9ad8\u6548\u5904\u7406\u548c\u5206\u6790\u3002\u00a0\u00a0<\/strong><\/p>\n\n\n\n<p>        \u5728\u7efc\u5408\u8868\u73b0\u4e0a\uff0c\u56fd\u4ea7\u5927\u6a21\u578b Qwen2.5-7B-Instruct \u4e0e DeepSeek-R1-Distill-Qwen-7B \u8868\u73b0\u9886\u5148\uff0c\u5176\u4e2dDeepSeek-R1-Distill-Qwen-7B \u5728 SQL \u8f6c\u6362\u7684\u51c6\u786e\u7387\u548c\u547d\u4e2d\u7387\u4e0a\u7a81\u51fa\uff0c\u800c Llama-3.1-8B \u4e0e MiniCPM4.1-8B \u5728\u590d\u6742\u67e5\u8be2\u4e2d\u7a0d\u663e\u4e0d\u8db3\u3002\u4f46\u662f\u4ece\u6548\u7387\u7ef4\u5ea6\u6765\u770b\uff0cMiniCPM4.1 \u7684\u54cd\u5e94\u65f6\u5ef6\u6700\u4f4e\uff0c\u9002\u5408\u5927\u89c4\u6a21\u5e76\u53d1\u573a\u666f\uff0c\u66f4\u9002\u5408\u5728\u5f00\u53d1\u9636\u6bb5\u4f7f\u7528\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3.2 \u56fe\u7eb8\u68c0\u7d22\u51c6\u786e\u7387<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"547\" height=\"448\" src=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-1.gif\" alt=\"\" class=\"wp-image-1947\"\/><\/figure>\n\n\n\n<p class=\"has-text-align-left\">\u56fe3 \u56fe\u7eb8\u89e3\u6790\u68c0\u7d22\u51c6\u786e\u7387<\/p>\n\n\n\n<p>        \u4ece\u56fe3\u53ef\u4ee5\u770b\u51faDeepsee-R1\u5728\u4e09\u4e2a\u7ef4\u5ea6\u4e0a\u90fd\u8868\u73b0\u4f18\u5f02\uff0c\u5f62\u6210\u7684\u591a\u8fb9\u5f62\u9762\u79ef\u8f83\u5927\u4e14\u76f8\u5bf9\u5747\u8861\uff0c\u663e\u793a\u51fa\u5168\u9762\u800c\u7a33\u5b9a\u7684\u6027\u80fd\uff0cQwen2.5\u5728\u5404\u7ef4\u5ea6\u76f8\u5bf9\u7a33\u5b9a\uff0c\u5f62\u6210\u7684\u56fe\u5f62\u8f83\u4e3a\u89c4\u6574\uff0c\u662f\u53ef\u9760\u7684\u66ff\u4ee3\u9009\u62e9\uff0cLlama \u548c MiniCPM4.1 \u5728SQL\u751f\u6210\u65b9\u9762\u76f8\u5bf9\u8f83\u5f31.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3.3\u6a21\u578b\u7684\u6548\u7387\u4e0e\u7a33\u5b9a\u6027<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"372\" src=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-2.gif\" alt=\"\" class=\"wp-image-1948\"\/><\/figure>\n\n\n\n<p>\u56fe4 \u663e\u5b58\u5360\u7528\u5bf9\u6bd4<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"373\" src=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/image-3.gif\" alt=\"\" class=\"wp-image-1949\"\/><\/figure>\n\n\n\n<p>\u56fe5 \u63a8\u7406\u6027\u80fd\u5bf9\u6bd4<\/p>\n\n\n\n<p>        \u4ece\u56fe4\u56fe5\u53ef\u4ee5\u770b\u51fa<strong>Qwen2.5-7B-Instruct<\/strong>\u5728\u51c6\u786e\u6027\u3001\u63a8\u7406\u901f\u5ea6\u3001\u8d44\u6e90\u5360\u7528\u4e09\u65b9\u9762\u90fd\u8868\u73b0\u4f18\u5f02\uff0c\u63a8\u7406\u901f\u5ea6\u6700\u5feb(140 tok\/s)\uff0c\u663e\u5b58\u5360\u7528\u5408\u7406(14GB\/5GB)\uff0c\u662f\u56fe\u7eb8\u68c0\u7d22\u5e94\u7528\u7684\u6700\u4f73\u9009\u62e9\uff0cdeepseek\u7684\u6027\u80fd\u867d\u52a3\u4e8eQwen\uff0c\u4f46\u662f\u5728\u67e5\u8be2\u56fe\u7eb8\u7684\u51c6\u786e\u7387\u4e0a\u76f8\u5bf9\u7a33\u5b9a\uff0c\u662f\u4e2a\u66ff\u6362\u9009\u62e9\uff0c\u8fd9\u4e00\u7efc\u5408\u5206\u6790\u8868\u660e\uff0c<strong>\u56fd\u4ea7\u5927\u6a21\u578b\u4e0d\u4ec5\u5728\u4e13\u4e1a\u80fd\u529b\u4e0a\u5177\u5907\u7ade\u4e89\u4f18\u52bf\uff0c\u5728\u5de5\u7a0b\u5316\u90e8\u7f72\u65b9\u9762\u4e5f\u66f4\u52a0\u5b9e\u7528<\/strong><strong>\uff0c<\/strong>\u4e3a\u5236\u9020\u4e1aAI\u5e94\u7528\u7684\u89c4\u6a21\u5316\u843d\u5730\u63d0\u4f9b\u4e86\u6709\u529b\u652f\u6491\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3.4 \u8bc4\u6d4b\u6848\u4f8b<\/h2>\n\n\n\n<p>(1) \u6848\u4f8b\u4e00\uff1a\u5355\u4e00\u6761\u4ef6\u67e5\u8be2<strong><\/strong><\/p>\n\n\n\n<p>1.\u6d4b\u8bd5\u8f93\u5165\uff1a\u300c\u67e5\u627e\u6240\u6709\u4f7f\u752845\u94a2\u7684\u96f6\u4ef6\u56fe\u7eb8\u300d<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><td>\u6a21\u578b<\/td><td>\u751f\u6210SQL<\/td><td>\u6267\u884c\u7ed3\u679c<\/td><td>\u547d\u4e2d\u7387<\/td><\/tr><\/thead><tbody><tr><td><strong>Qwen2.5<\/strong><strong><\/strong><\/td><td><code>SELECT * FROM drawings WHERE material = '45<\/code><code>\u94a2<\/code><code>'<\/code><\/td><td>\u5b8c\u5168\u6b63\u786e<\/td><td>96%<\/td><\/tr><tr><td><strong>DeepSeek-R1<\/strong><strong><\/strong><\/td><td><code>SELECT * FROM drawings WHERE material LIKE '%45%'<\/code><\/td><td>\u5b8c\u5168\u6b63\u786e<\/td><td>94%<\/td><\/tr><tr><td><strong>Gemma-3-12B<\/strong><strong><\/strong><\/td><td><code>SELECT * FROM drawings WHERE material = '45 Steel'<\/code><\/td><td>\u90e8\u5206\u6b63\u786e<\/td><td>78%<\/td><\/tr><tr><td><strong>Llama-3.1<\/strong><strong><\/strong><\/td><td><code>SELECT * FROM drawings WHERE material_type = 'steel' AND material_grade = '45'<\/code><\/td><td>\u90e8\u5206\u6b63\u786e<\/td><td>82%<\/td><\/tr><tr><td><strong>MiniCPM4.1<\/strong><strong><\/strong><\/td><td><code>SELECT * FROM drawings WHERE material = '45<\/code><code>\u94a2<\/code><code>'<\/code><\/td><td>\u5b8c\u5168\u6b63\u786e<\/td><td>89%<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"568\" height=\"320\" src=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/\u67e5\u627e\u6240\u6709\u4f7f\u752845\u94a2\u7684\u96f6\u4ef6\u56fe\u7eb8.gif\" alt=\"\" class=\"wp-image-1953\"\/><\/figure>\n\n\n\n<p>\u52a8\u753b\u5185\u5bb9\uff1a\u67e5\u627e\u6240\u6709\u4f7f\u752845\u94a2\u7684\u96f6\u4ef6\u56fe\u7eb8<\/p>\n\n\n\n<p>2.\u6d4b\u8bd5\u8f93\u5165\uff1a\u300c\u67e5\u627e\u6240\u6709\u8868\u9762\u5904\u7406\u4e3a\u9633\u6781\u6c27\u5316\u7684\u96f6\u4ef6\u56fe\u7eb8\u300d<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><td>\u6a21\u578b<\/td><td>\u751f\u6210SQL<\/td><td>\u6267\u884c\u7ed3\u679c<\/td><td>\u547d\u4e2d\u7387<\/td><\/tr><\/thead><tbody><tr><td><strong>Qwen2.5<\/strong><strong><\/strong><\/td><td>SELECT * FROM drawings WHERE surface_treatment = &#8216;\u9633\u6781\u6c27\u5316&#8217;<\/td><td>\u5b8c\u5168\u6b63\u786e<\/td><td>93%<\/td><\/tr><tr><td><strong>DeepSeek-R1<\/strong><strong><\/strong><\/td><td>SELECT * FROM drawings WHERE surface_treatment LIKE &#8216;%\u9633\u6781\u6c27\u5316%&#8217; OR surface_treatment LIKE &#8216;%anodizing%&#8217;`<\/td><td>\u5b8c\u5168\u6b63\u786e<\/td><td>98%<\/td><\/tr><tr><td><strong>Gemma-3-12B<\/strong><strong><\/strong><\/td><td>SELECT * FROM drawings WHERE treatment_type = &#8216;anodizing<\/td><td>\u90e8\u5206\u6b63\u786e<\/td><td>72%<\/td><\/tr><tr><td><strong>Llama-3.1<\/strong><strong><\/strong><\/td><td>SELECT * FROM drawings WHERE surface_finish = &#8216;anodized&#8217;<\/td><td>\u90e8\u5206\u6b63\u786e<\/td><td>75%<\/td><\/tr><tr><td><strong>MiniCPM4.1<\/strong><strong><\/strong><\/td><td>SELECT * FROM drawings WHERE surface_treatment = &#8216;\u9633\u6781\u6c27\u5316&#8217;<\/td><td>\u5b8c\u5168\u6b63\u786e<\/td><td>86%<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>(2) \u6848\u4f8b\u4e8c\uff1a\u590d\u5408\u903b\u8f91\u67e5\u8be2<strong><\/strong><\/p>\n\n\n\n<p>1.\u6d4b\u8bd5\u8f93\u5165\uff1a\u300c\u627e\u51fa\u4f7f\u7528HT200\u4e14\u70ed\u5904\u7406\u786c\u5ea6\u5c0f\u4e8eHRC60\u7684\u96f6\u4ef6\u56fe\u7eb8\u300d<\/p>\n\n\n\n<p>\u5404\u6a21\u578b\u8868\u73b0\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><td>\u6a21\u578b<\/td><td>\u751f\u6210SQL<\/td><td>\u5173\u952e\u95ee\u9898<\/td><td>\u6267\u884c\u7ed3\u679c<\/td><\/tr><\/thead><tbody><tr><td>Qwen2.5<\/td><td>SELECT * FROM drawings WHERE material LIKE &#8216;%HT200%&#8217; AND heat_treatment_hardness \uff1c 60<\/td><td>\u5b57\u6bb5\u6620\u5c04\u548c\u6570\u503c\u63d0\u53d6\u51c6\u786e<\/td><td>92%\u6b63\u786e<\/td><\/tr><tr><td>DeepSeek-R1<\/td><td>SELECT * FROM drawings WHERE material = &#8216;HT200&#8217; AND hardness \uff1c &#8216;HRC60&#8217;<\/td><td>\u786c\u5ea6\u5b57\u6bb5\u7c7b\u578b\u5904\u7406\u9700\u8981\u4f18\u5316<\/td><td>85%\u6b63\u786e<\/td><\/tr><tr><td>Gemma-3-12B<\/td><td>SELECT * FROM drawings WHERE material = \u2018HT200&#8242; AND hardness_hrc \uff1c 60<\/td><td>\u4e2d\u82f1\u6587\u6df7\u7528\u5f71\u54cd\u5339\u914d<\/td><td>76%\u6b63\u786e<\/td><\/tr><tr><td>Llama-3.1<\/td><td>SELECT * FROM drawings WHERE material = &#8216;HT200&#8217; AND hardness \uff1c 60<\/td><td>\u9057\u6f0f\u786c\u5ea6\u5355\u4f4d\u4fe1\u606f<\/td><td>81%\u6b63\u786e<\/td><\/tr><tr><td>MiniCPM4.1<\/td><td>SELECT * FROM drawings WHERE material = &#8216;HT200&#8217;<\/td><td>\u9057\u6f0f\u70ed\u5904\u7406\u786c\u5ea6\u6761\u4ef6<\/td><td>45%\u6b63\u786e<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"568\" height=\"320\" src=\"http:\/\/www.applicationsofllm.com\/wp-content\/uploads\/2025\/10\/\u627e\u51fa\u4f7f\u7528HT200\u4e14\u70ed\u5904\u7406\u786c\u5ea6\u5c0f\u4e8eHRC60\u7684\u96f6\u4ef6\u56fe\u7eb8.gif\" alt=\"\" class=\"wp-image-1954\"\/><\/figure>\n\n\n\n<p>\u52a8\u753b\u5185\u5bb9\uff1a\u627e\u51fa\u4f7f\u7528HT200\u4e14\u70ed\u5904\u7406\u786c\u5ea6\u5c0f\u4e8eHRC60\u7684\u96f6\u4ef6\u56fe\u7eb8\u3001<\/p>\n\n\n\n<p>2.\u6d4b\u8bd5\u8f93\u5165\uff1a\u300c\u67e5\u627e\u6750\u6599\u4e3a45\u94a2\uff0c\u4e14\u7ecf\u8fc7\u8c03\u8d28\u5904\u7406\uff0c\u76f4\u5f84\u5927\u4e8e30mm\u7684\u8f74\u7c7b\u96f6\u4ef6\u300d<\/p>\n\n\n\n<p>\u5404\u6a21\u578b\u8868\u73b0\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><td>\u6a21\u578b<\/td><td>\u751f\u6210SQL<\/td><td>\u5173\u952e\u95ee\u9898<\/td><td>\u6267\u884c\u7ed3\u679c<\/td><\/tr><\/thead><tbody><tr><td>Qwen2.5<\/td><td>SELECT * FROM drawings WHERE material = &#8217;45\u94a2&#8217; AND heat_treatment = &#8216;\u8c03\u8d28\u5904\u7406&#8217; AND diameter &gt; 30 AND component_type = &#8216;\u8f74\u7c7b&#8217;<\/td><td>\u672f\u8bed\u89c4\u8303\u5316\u5904\u7406\uff0c\u5b57\u6bb5\u6620\u5c04\u6e05\u6670<\/td><td>90%\u6b63\u786e<\/td><\/tr><tr><td>DeepSeek-R1<\/td><td>SELECT * FROM drawings WHERE material = &#8217;45\u94a2&#8217; AND heat_treatment = &#8216;\u8c03\u8d28&#8217; AND diameter &gt; 30 AND part_type LIKE &#8216;%\u8f74%&#8217;<\/td><td>\u56db\u91cd\u6761\u4ef6\u5b8c\u6574\u8bc6\u522b\uff0c\u4e13\u4e1a\u672f\u8bed\u6620\u5c04\u51c6\u786e<\/td><td>96%\u6b63\u786e<\/td><\/tr><tr><td>Gemma-3-12B<\/td><td>SELECT * FROM drawings WHERE steel_grade = &#8217;45&#8217; AND treatment = &#8216;Q&amp;T&#8217; AND size &gt; 30<\/td><td>\u591a\u4e2a\u5b57\u6bb5\u6620\u5c04\u9519\u8bef\uff0c\u672f\u8bed\u7f29\u5199\u4e0d\u89c4\u8303<\/td><td>66%\u6b63\u786e<\/td><\/tr><tr><td>Llama-3.1<\/td><td>SELECT * FROM drawings WHERE material = &#8216;carbon steel 45&#8217; AND heat_treatment = &#8216;quenching and tempering&#8217; AND diameter &gt; 30<\/td><td>\u9057\u6f0f\u96f6\u4ef6\u7c7b\u578b\u6761\u4ef6\uff0c\u672f\u8bed\u82f1\u8bd1<\/td><td>75%\u6b63\u786e<\/td><\/tr><tr><td>MiniCPM4.1<\/td><td>SELECT * FROM drawings WHERE material = &#8217;45\u94a2&#8217; AND heat_treatment = &#8216;\u8c03\u8d28&#8217; AND diameter &gt; 30`<\/td><td>\u9057\u6f0f\u96f6\u4ef6\u7c7b\u578b\u6761\u4ef6<\/td><td>62%\u6b63\u786e<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">4. \u603b\u7ed3\u4e0e\u5c55\u671b<\/h1>\n\n\n\n<p>        \u672c\u6b21\u9488\u5bf9\u4e94\u6b3e\u5f00\u6e90\u5927\u6a21\u578b\u5728\u56fe\u7eb8\u68c0\u7d22\u4efb\u52a1\u4e2d\u7684\u7efc\u5408\u8bc4\u6d4b\uff0c\u63ed\u793a\u4e86\u5f53\u524d\u5927\u6a21\u578b\u5728\u5236\u9020\u4e1a\u4e13\u4e1a\u573a\u666f\u5e94\u7528\u7684\u771f\u5b9e\u6c34\u5e73\u548c\u53d1\u5c55\u6001\u52bf\u3002<strong>\u8bc4\u6d4b\u7ed3\u679c\u663e\u793a\uff0c\u56fd\u4ea7\u5927\u6a21\u578b\u5728\u5782\u76f4\u9886\u57df\u5e94\u7528\u4e0a\u5df2\u5c55\u73b0\u51fa\u660e\u663e\u7684\u7ade\u4e89\u4f18\u52bf\uff0c\u7279<\/strong><strong>\u522b\u662f\u5728\u5904\u7406\u4e2d\u6587\u5de5\u7a0b\u672f\u8bed\u548c\u590d\u6742\u67e5\u8be2\u903b\u8f91\u65b9\u9762\u8868\u73b0\u7a81\u51fa\u3002<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u672c\u6b21\u8bc4\u6d4b\u8868\u660e\uff0c\u5927\u6a21\u578b\u5728\u5236\u9020\u4e1a\u4e13\u4e1a\u5e94\u7528\u4e2d\u5df2\u7ecf\u5177\u5907\u4e86\u5b9e\u7528\u5316\u7684\u57fa\u7840\u80fd\u529b\uff0c\u7279\u522b\u662f\u56fd\u4ea7\u5927\u6a21\u578b\u5728\u4e2d\u6587\u5de5\u7a0b\u73af\u5883\u4e0b\u5c55\u73b0\u51fa\u7684\u4f18\u5f02\u8868\u73b0\uff0c\u4e3a\u6211\u56fd\u5236\u9020\u4e1a\u7684\u667a\u80fd\u5316\u8f6c\u578b\u63d0\u4f9b\u4e86\u91cd\u8981\u7684\u6280\u672f\u652f\u6491\u3002<\/li>\n\n\n\n<li>\u968f\u7740\u6280\u672f\u7684\u4e0d\u65ad\u8fdb\u6b65\u548c\u5e94\u7528\u573a\u666f\u7684\u6df1\u5ea6\u62d3\u5c55\uff0c\u6211\u4eec\u6709\u7406\u7531\u76f8\u4fe1\uff0c\u57fa\u4e8e\u5927\u6a21\u578b\u7684\u667a\u80fd\u5236\u9020\u52a9\u624b\u5c06\u6210\u4e3a\u672a\u6765\u5de5\u7a0b\u8bbe\u8ba1\u7684\u6807\u914d\u5de5\u5177\uff0c\u6781\u5927\u63d0\u5347\u8bbe\u8ba1\u6548\u7387\u3001\u964d\u4f4e\u8bbe\u8ba1\u6210\u672c\uff0c\u63a8\u52a8\u5236\u9020\u4e1a\u5411\u66f4\u9ad8\u8d28\u91cf\u3001\u66f4\u9ad8\u6548\u7387\u7684\u667a\u80fd\u5236\u9020\u65f6\u4ee3\u8fc8\u8fdb\u3002<\/li>\n\n\n\n<li>\u9762\u5411\u672a\u6765\uff0c\u6211\u4eec\u5efa\u8bae\u5236\u9020\u4f01\u4e1a\u79ef\u6781\u62e5\u62b1AI\u6280\u672f\u53d8\u9769\uff0c\u9009\u62e9\u9002\u5408\u81ea\u8eab\u9700\u6c42\u7684\u5927\u6a21\u578b\u89e3\u51b3\u65b9\u6848\uff0c\u5728\u6570\u5b57\u5316\u8f6c\u578b\u7684\u9053\u8def\u4e0a\u62a2\u5360\u5148\u673a\uff0c\u4e3a\u4f01\u4e1a\u7684\u53ef\u6301\u7eed\u53d1\u5c55\u6ce8\u5165\u5f3a\u52b2\u7684\u667a\u80fd\u5316\u52a8\u529b\u3002<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>1. \u75db\u70b9\u4e0e\u6311\u6218 \u8fc7\u53bb\u4e24\u5e74\uff0c\u5927\u6a21\u578b\u6280\u672f\u5728\u6587\u672c\u751f\u6210\u3001\u56fe\u50cf\u7406\u89e3\u3001\u4ee3\u7801\u5f00\u53d1\u7b49\u901a\u7528\u9886\u57df\u5b9e\u73b0\u8de8\u8d8a\u5f0f\u7a81\u7834\uff0c\u6280\u672f\u6210\u719f\u5ea6\u4e0e\u843d\u5730 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1940,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1939","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-10"],"_links":{"self":[{"href":"http:\/\/www.applicationsofllm.com\/index.php\/wp-json\/wp\/v2\/posts\/1939","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.applicationsofllm.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.applicationsofllm.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.applicationsofllm.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.applicationsofllm.com\/index.php\/wp-json\/wp\/v2\/comments?post=1939"}],"version-history":[{"count":2,"href":"http:\/\/www.applicationsofllm.com\/index.php\/wp-json\/wp\/v2\/posts\/1939\/revisions"}],"predecessor-version":[{"id":1958,"href":"http:\/\/www.applicationsofllm.com\/index.php\/wp-json\/wp\/v2\/posts\/1939\/revisions\/1958"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.applicationsofllm.com\/index.php\/wp-json\/wp\/v2\/media\/1940"}],"wp:attachment":[{"href":"http:\/\/www.applicationsofllm.com\/index.php\/wp-json\/wp\/v2\/media?parent=1939"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.applicationsofllm.com\/index.php\/wp-json\/wp\/v2\/categories?post=1939"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.applicationsofllm.com\/index.php\/wp-json\/wp\/v2\/tags?post=1939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}