{"id":21128,"date":"2024-07-12T10:35:22","date_gmt":"2024-07-12T02:35:22","guid":{"rendered":"https:\/\/aif.amtbbs.org\/?p=21128"},"modified":"2024-07-12T10:35:22","modified_gmt":"2024-07-12T02:35:22","slug":"%e8%b6%85%e7%ba%a7%e6%94%bb%e7%95%a5%ef%bc%9a%e5%a6%82%e4%bd%95%e5%bf%ab%e9%80%9f%e6%8e%92%e6%9f%a5%e5%92%8c%e4%bc%98%e5%8c%96%e6%85%a2sql%ef%bc%8c%e6%8f%90%e5%8d%87%e7%b3%bb%e7%bb%9f%e9%80%9f","status":"publish","type":"post","link":"https:\/\/aif.amtbbs.org\/index.php\/2024\/07\/12\/21128\/","title":{"rendered":"&#8220;\u8d85\u7ea7\u653b\u7565\uff1a\u5982\u4f55\u5feb\u901f\u6392\u67e5\u548c\u4f18\u5316\u6162SQL\uff0c\u63d0\u5347\u7cfb\u7edf\u901f\u5ea6\uff01&#8221;"},"content":{"rendered":"<div><\/div>\n<div><img data-dominant-color=\"2cb9ed\" data-has-transparency=\"false\" style=\"--dominant-color: #2cb9ed;\" loading=\"lazy\" decoding=\"async\" class=\"not-transparent alignnone size-full wp-image-21129\" src=\"https:\/\/aiforumimage.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2024\/07\/1fdc0f893412ce55f0d2811821b84d3b.jpg\" width=\"474\" height=\"354\" alt=\"https:\/\/baike.baidu.com\/item\/%E7%BB%93%E6%9E%84%E5%8C%96%E6%9F%A5%E8%AF%A2%E8%AF%AD%E8%A8%80\/10450182\" srcset=\"https:\/\/aiforumimage.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2024\/07\/1fdc0f893412ce55f0d2811821b84d3b.jpg 474w, https:\/\/aiforumimage.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2024\/07\/1fdc0f893412ce55f0d2811821b84d3b-300x224.jpg 300w, https:\/\/aiforumimage.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2024\/07\/1fdc0f893412ce55f0d2811821b84d3b-150x112.jpg 150w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/div>\n<div class=\"article-desc\">\u5b9e\u9645\u4e0a\uff0c\u6700\u5927\u7684\u6311\u6218\u4e0d\u5728\u4e8e\u89e3\u51b3\u95ee\u9898\uff0c\u800c\u5728\u4e8e\u51c6\u786e\u5b9a\u4f4d\u95ee\u9898\u3002\u56e0\u4e3a\u4e00\u65e6\u95ee\u9898\u88ab\u51c6\u786e\u5b9a\u4f4d\uff0c\u89e3\u51b3\u8d77\u6765\u5c31\u53d8\u5f97\u76f8\u5bf9\u7b80\u5355\u3002\u4f8b\u5982\uff0c\u7f3a\u5c11\u7d22\u5f15\u5c31\u6dfb\u52a0\u7d22\u5f15\uff0cJOIN \u64cd\u4f5c\u8fc7\u591a\u5c31\u8fdb\u884c\u62c6\u5206\u3002\u8fd9\u91cc\u4e0d\u518d\u8be6\u7ec6\u5c55\u5f00\u3002<\/div>\n<div id=\"postspictures\" class=\"article-content\">\n<div id=\"container\" class=\"container am-engine\" data-v-1d7a5742=\"\" data-element=\"root\">\n<p>\u6162\u67e5\u8be2\u6307\u7684\u662f\u6570\u636e\u5e93\u4e2d\u6267\u884c\u65f6\u95f4\u8d85\u8fc7\u6307\u5b9a\u9608\u503c\u7684 SQL \u8bed\u53e5\u3002\u4e0d\u540c\u4e1a\u52a1\u573a\u666f\u4e0b\uff0c\u8fd9\u4e2a\u9608\u503c\u901a\u5e38\u5404\u4e0d\u76f8\u540c\u3002\u5728\u6211\u4eec\u516c\u53f8\u5185\u90e8\uff0c\u8fd9\u4e2a\u9608\u503c\u88ab\u8bbe\u5b9a\u4e3a 1 \u79d2\u949f\u3002\u4e5f\u5c31\u662f\u8bf4\uff0c\u4efb\u4f55\u6267\u884c\u65f6\u95f4\u8d85\u8fc7 1 \u79d2\u7684 SQL \u8bed\u53e5\u90fd\u4f1a\u88ab\u89c6\u4e3a\u6162\u67e5\u8be2\u3002<\/p>\n<p>\u5bf9\u6162\u67e5\u8be2\u8fdb\u884c\u95ee\u9898\u6392\u67e5\u901a\u5e38\u5206\u4e3a\u4ee5\u4e0b\u51e0\u4e2a\u6b65\u9aa4\uff1a<\/p>\n<h2>\u53d1\u73b0\u95ee\u9898<\/h2>\n<p>\u4e00\u822c\u800c\u8a00\uff0c\u6162\u67e5\u8be2\u95ee\u9898\u76f8\u5bf9\u5bb9\u6613\u53d1\u73b0\u3002\u5982\u679c\u6709\u5b8c\u5584\u7684\u76d1\u63a7\u4f53\u7cfb\uff0c\u7cfb\u7edf\u4f1a\u5b9a\u671f\u7edf\u8ba1\u6162 SQL \u5e76\u901a\u8fc7\u62a5\u8b66\u65b9\u5f0f\u63d0\u9192\u3002<\/p>\n<p>\u6b64\u5916\uff0c\u5982\u679c\u4f7f\u7528\u4e86\u67d0\u4e9b\u6570\u636e\u5e93\u4e2d\u95f4\u4ef6\uff0c\u4f8b\u5982 TDDL\uff0c\u5b83\u4eec\u901a\u5e38\u4f1a\u8bb0\u5f55\u6162 SQL \u7684\u65e5\u5fd7\uff1a<\/p>\n<div>\n<div class=\"hljs-cto\">\n<div class=\"hljs-cto\"><button class=\"copy_btn disable\" data-clipboard-target=\"#code_id_0\">\u590d\u5236<\/button><\/p>\n<div class=\"code-toolbar\">\n<pre class=\"has-pre-numbering language-sql\" tabindex=\"0\"><code class=\"language-sql\">Cause: ERR<span class=\"token operator\">-<\/span>CODE: <span class=\"token punctuation\">[<\/span>TDDL<span class=\"token operator\">-<\/span><span class=\"token number\">4202<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span>ERR_SQL_QUERY_TIMEOUT<span class=\"token punctuation\">]<\/span> Slow query leads <span class=\"token keyword\">to<\/span> a timeout exception<span class=\"token punctuation\">,<\/span> please contact DBA <span class=\"token keyword\">to<\/span> <span class=\"token keyword\">check<\/span> slow <span class=\"token keyword\">sql<\/span><span class=\"token punctuation\">.<\/span> SocketTimout:<span class=\"token number\">12000<\/span> ms<span class=\"token punctuation\">,<\/span><\/code><\/pre>\n<ul id=\"code_id_0\" class=\"pre-numbering\">\n<li>1.<\/li>\n<\/ul>\n<div class=\"toolbar\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>\u5982\u679c\u53ea\u4f9d\u8d56 MySQL \u672c\u8eab\u7684\u8bdd<\/p>\n<ol class=\"list-paddingleft-1\" data-id=\"odd3d8fc-a6VJcLRd\">\n<li data-id=\"ld70c578-CO9P4Fc9\">\u627e\u5230 MySQL \u7684\u914d\u7f6e\u6587\u4ef6\u00a0my.cnf\uff08\u6216\u8005\u5728 Windows \u7cfb\u7edf\u4e0b\u53ef\u80fd\u662f\u00a0my.ini\uff09\uff0c\u901a\u5e38\u5b83\u4eec\u4f4d\u4e8e MySQL \u5b89\u88c5\u76ee\u5f55\u4e0b\u7684\u00a0etc\u00a0\u6216\u00a0conf\u00a0\u6587\u4ef6\u5939\u4e2d\u3002<\/li>\n<li data-id=\"ld70c578-7L0ijWmX\">\u542f\u7528\u6162\u67e5\u8be2\u65e5\u5fd7\u529f\u80fd\uff1a\u8bf7\u627e\u5230\u4ee5\u4e0b\u914d\u7f6e\u9879\uff0c\u5e76\u5c06\u5176\u53d6\u6d88\u6ce8\u91ca\uff08\u5982\u679c\u5df2\u6ce8\u91ca\uff09\uff0c\u786e\u4fdd\u4ee5\u4e0b\u884c\u5b58\u5728\u6216\u6dfb\u52a0\u5230\u914d\u7f6e\u6587\u4ef6\u4e2d\uff1a<\/li>\n<\/ol>\n<div>\n<div class=\"hljs-cto\">\n<div class=\"hljs-cto\"><button class=\"copy_btn disable\" data-clipboard-target=\"#code_id_1\">\u590d\u5236<\/button><\/p>\n<div class=\"code-toolbar\">\n<pre class=\"has-pre-numbering language-sql\" tabindex=\"0\"><code class=\"language-sql\">slow_query_log <span class=\"token operator\">=<\/span> <span class=\"token number\">1<\/span>\r\nslow_query_log_file <span class=\"token operator\">=<\/span> <span class=\"token operator\">\/<\/span>path<span class=\"token operator\">\/<\/span><span class=\"token keyword\">to<\/span><span class=\"token operator\">\/<\/span>slow<span class=\"token operator\">-<\/span>query<span class=\"token punctuation\">.<\/span>log\r\nlong_query_time <span class=\"token operator\">=<\/span> <span class=\"token number\">1<\/span><\/code><\/pre>\n<ul id=\"code_id_1\" class=\"pre-numbering\">\n<li>1.<\/li>\n<li>2.<\/li>\n<li>3.<\/li>\n<\/ul>\n<div class=\"toolbar\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<ol class=\"list-paddingleft-1\" start=\"3\" data-id=\"o292e11f-1QhNKLdk\">\n<li data-id=\"ld70c578-e33eL14O\">\u4fdd\u5b58\u914d\u7f6e\u6587\u4ef6\u540e\uff0c\u91cd\u65b0\u542f\u52a8 MySQL \u670d\u52a1\u4ee5\u4f7f\u914d\u7f6e\u751f\u6548\u3002<\/li>\n<li data-id=\"ld70c578-fcemSo1E\">\u67e5\u770b\u6162\u67e5\u8be2\u65e5\u5fd7\uff1a\u4f7f\u7528\u6587\u672c\u7f16\u8f91\u5668\u6253\u5f00\u6162\u67e5\u8be2\u65e5\u5fd7\u6587\u4ef6\u3002\u65e5\u5fd7\u6587\u4ef6\u7684\u8def\u5f84\u901a\u5e38\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6307\u5b9a\u3002\u4f8b\u5982\uff0c\u5728 Linux \u7cfb\u7edf\u4e0a\uff0c\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u6765\u67e5\u770b\u6162\u67e5\u8be2\u65e5\u5fd7\u6587\u4ef6\uff1a<\/li>\n<\/ol>\n<div>\n<div class=\"hljs-cto\">\n<div class=\"hljs-cto\"><button class=\"copy_btn disable\" data-clipboard-target=\"#code_id_2\">\u590d\u5236<\/button><\/p>\n<div class=\"code-toolbar\">\n<pre class=\"has-pre-numbering language-sql\" tabindex=\"0\"><code class=\"language-sql\">sudo vi <span class=\"token operator\">\/<\/span>var<span class=\"token operator\">\/<\/span>log<span class=\"token operator\">\/<\/span>mysql<span class=\"token operator\">\/<\/span>mysql<span class=\"token operator\">-<\/span>slow<span class=\"token punctuation\">.<\/span>log<\/code><\/pre>\n<ul id=\"code_id_2\" class=\"pre-numbering\">\n<li>1.<\/li>\n<\/ul>\n<div class=\"toolbar\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>\u8bf7\u5c06\u8def\u5f84\u00a0\/var\/log\/mysql\/mysql-slow.log\u00a0\u66ff\u6362\u4e3a\u5b9e\u9645\u914d\u7f6e\u6587\u4ef6\u4e2d\u6307\u5b9a\u7684\u6162\u67e5\u8be2\u65e5\u5fd7\u8def\u5f84\u3002\u914d\u7f6e\u5b8c\u6bd5\u540e\uff0cMySQL \u4f1a\u5c06\u6267\u884c\u65f6\u95f4\u8d85\u8fc7\u00a0long_query_time\u00a0\u8bbe\u7f6e\u7684\u65f6\u95f4\u9608\u503c\u7684 SQL \u8bed\u53e5\u8bb0\u5f55\u5230\u6162\u67e5\u8be2\u65e5\u5fd7\u4e2d\u3002<\/p>\n<p>\u5982\u679c\u6709\u6162 SQL\uff0c\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<div>\n<div class=\"hljs-cto\">\n<div class=\"hljs-cto\"><button class=\"copy_btn disable\" data-clipboard-target=\"#code_id_3\">\u590d\u5236<\/button><\/p>\n<div class=\"code-toolbar\">\n<pre class=\"has-pre-numbering language-sql\" tabindex=\"0\"><code class=\"language-sql\"><span class=\"token comment\"># Time: 2023-06-04T12:00:00.123456Z<\/span>\r\n<span class=\"token comment\"># User@Host: hollis[192.168.0.1]:3306<\/span>\r\n<span class=\"token comment\"># Query_time: 2.345678  Lock_time: 0.012345 Rows_sent: 10  Rows_examined: 100<\/span>\r\n<span class=\"token keyword\">SET<\/span> <span class=\"token keyword\">timestamp<\/span><span class=\"token operator\">=<\/span><span class=\"token number\">1650000000<\/span><span class=\"token punctuation\">;<\/span>\r\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders <span class=\"token keyword\">WHERE<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">=<\/span> <span class=\"token string\">'pending'<\/span> <span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> gmt_created <span class=\"token keyword\">DESC<\/span><span class=\"token punctuation\">;<\/span><\/code><\/pre>\n<ul id=\"code_id_3\" class=\"pre-numbering\">\n<li>1.<\/li>\n<li>2.<\/li>\n<li>3.<\/li>\n<li>4.<\/li>\n<li>5.<\/li>\n<\/ul>\n<div class=\"toolbar\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2>\u5b9a\u4f4d\u95ee\u9898<\/h2>\n<p>\u5728\u4e0a\u8ff0\u5404\u79cd\u76d1\u63a7\u3001\u62a5\u8b66\u548c\u65e5\u5fd7\u4e2d\uff0c\u6211\u4eec\u53ef\u4ee5\u5b9a\u4f4d\u5230\u5177\u4f53\u7684\u6162 SQL \u8bed\u53e5\uff0c\u7136\u540e\u53ef\u4ee5\u8fdb\u4e00\u6b65\u5206\u6790\u4e3a\u4ec0\u4e48\u8fd9\u4e2a SQL \u8bed\u53e5\u6267\u884c\u7f13\u6162\uff0c\u4e3b\u8981\u662f\u6392\u67e5\u4ee5\u4e0b\u51e0\u4e2a\u53ef\u80fd\u7684\u539f\u56e0\uff1a<\/p>\n<ol class=\"list-paddingleft-1\" data-id=\"odd3d8fc-PanIQe0k\">\n<li data-id=\"ld70c578-PpR2VeRJ\">\u7f3a\u5c11\u7d22\u5f15\uff1a\u6ca1\u6709\u4e3a\u67e5\u8be2\u6d89\u53ca\u7684\u5217\u521b\u5efa\u9002\u5f53\u7684\u7d22\u5f15\uff0c\u5bfc\u81f4\u6570\u636e\u5e93\u9700\u8981\u5168\u8868\u626b\u63cf\u6765\u627e\u5230\u5339\u914d\u7684\u884c\u3002<\/li>\n<li data-id=\"ld70c578-p0Lmck2c\">\u9519\u8bef\u4f7f\u7528\u7d22\u5f15\uff1a\u4f7f\u7528\u4e86\u7d22\u5f15\u4f46\u4e0d\u7b26\u5408\u6700\u5de6\u524d\u7f00\u539f\u5219\uff0c\u6216\u8005\u7d22\u5f15\u9009\u62e9\u5ea6\u4e0d\u9ad8\uff08\u5373\u7d22\u5f15\u5217\u7684\u552f\u4e00\u6027\u4e0d\u591f\u9ad8\uff09\uff0c\u5bfc\u81f4\u6570\u636e\u5e93\u9009\u62e9\u4e0d\u5230\u6700\u4f18\u7684\u7d22\u5f15\u6267\u884c\u67e5\u8be2\u3002<\/li>\n<li data-id=\"ld70c578-671ODBSQ\">\u67e5\u8be2\u5b57\u6bb5\u8fc7\u591a\uff1aSELECT \u8bed\u53e5\u4e2d\u6d89\u53ca\u7684\u5b57\u6bb5\u8fc7\u591a\uff0c\u589e\u52a0\u4e86\u6570\u636e\u4f20\u8f93\u548c\u5904\u7406\u7684\u5f00\u9500\u3002<\/li>\n<li data-id=\"ld70c578-EYsMNZV5\">\u591a\u6b21\u56de\u8868\uff1a\u67e5\u8be2\u6267\u884c\u8fc7\u7a0b\u4e2d\u9700\u8981\u591a\u6b21\u8bbf\u95ee\u78c1\u76d8\u4ee5\u83b7\u53d6\u989d\u5916\u7684\u6570\u636e\u884c\uff0c\u4f8b\u5982\u5bf9\u4e3b\u952e\u7684\u7d22\u5f15\u626b\u63cf\u540e\uff0c\u9700\u8981\u518d\u6b21\u6839\u636e\u4e3b\u952e\u8fdb\u884c\u67e5\u8be2\u3002<\/li>\n<li data-id=\"ld70c578-dUNuqb92\">\u591a\u8868\u8fde\u63a5\uff1a\u6d89\u53ca\u591a\u4e2a\u8868\u7684 JOIN \u64cd\u4f5c\uff0c\u82e5 JOIN \u6761\u4ef6\u4e0d\u5408\u9002\u6216\u8005 JOIN \u64cd\u4f5c\u6ca1\u6709\u5229\u7528\u5230\u7d22\u5f15\uff0c\u4f1a\u5bfc\u81f4\u6027\u80fd\u4e0b\u964d\u3002<\/li>\n<li data-id=\"ld70c578-lBNqkj4F\">\u6df1\u5ea6\u5206\u9875\uff1a\u9700\u8981\u8fd4\u56de\u5927\u91cf\u6570\u636e\u4e2d\u7684\u67d0\u4e00\u9875\uff0c\u4f46\u662f\u6ca1\u6709\u5408\u9002\u7684\u65b9\u5f0f\u6765\u5feb\u901f\u5b9a\u4f4d\u548c\u83b7\u53d6\u8fd9\u4e00\u9875\u6570\u636e\u3002<\/li>\n<li data-id=\"ld70c578-MhANm1HN\">\u5176\u4ed6\u56e0\u7d20\uff1a\u8fd8\u6709\u4e00\u4e9b\u5176\u4ed6\u53ef\u80fd\u7684\u539f\u56e0\uff0c\u4f8b\u5982\u590d\u6742\u7684\u5b50\u67e5\u8be2\u3001\u6570\u636e\u5e93\u670d\u52a1\u5668\u8d1f\u8f7d\u9ad8\u3001SQL \u8bed\u53e5\u5199\u6cd5\u4e0d\u4f73\u7b49\u3002<\/li>\n<\/ol>\n<p>\u9488\u5bf9\u8fd9\u4e9b\u95ee\u9898\uff0c\u53ef\u4ee5\u901a\u8fc7\u4f18\u5316\u6570\u636e\u5e93\u8868\u7ed3\u6784\u3001\u6dfb\u52a0\u5408\u9002\u7684\u7d22\u5f15\u3001\u4f18\u5316 SQL \u8bed\u53e5\u5199\u6cd5\u3001\u8c03\u6574\u6570\u636e\u5e93\u914d\u7f6e\u53c2\u6570\u7b49\u65b9\u5f0f\u6765\u6539\u8fdb SQL \u67e5\u8be2\u7684\u6027\u80fd\u3002<\/p>\n<p>\u5bf9\u4e8e\u5927\u591a\u6570\u60c5\u51b5\u4e0b\u7684\u6162 SQL \u95ee\u9898\uff0c\u901a\u5e38\u53ef\u4ee5\u901a\u8fc7\u6267\u884c\u8ba1\u5212\u5206\u6790\u627e\u51fa\u6839\u672c\u539f\u56e0\uff0c\u4e3b\u8981\u96c6\u4e2d\u5728\u7d22\u5f15\u548c JOIN \u64cd\u4f5c\u4e0a\u3002<\/p>\n<h2>\u89e3\u51b3\u95ee\u9898<\/h2>\n<p>\u5b9a\u4f4d\u95ee\u9898\u540e\uff0c\u89e3\u51b3\u95ee\u9898\u5c31\u4f1a\u53d8\u5f97\u5bb9\u6613\u8d77\u6765\u3002<\/p>\n<p>\u5b9e\u9645\u4e0a\uff0c\u6700\u5927\u7684\u6311\u6218\u4e0d\u5728\u4e8e\u89e3\u51b3\u95ee\u9898\uff0c\u800c\u5728\u4e8e\u51c6\u786e\u5b9a\u4f4d\u95ee\u9898\u3002\u56e0\u4e3a\u4e00\u65e6\u95ee\u9898\u88ab\u51c6\u786e\u5b9a\u4f4d\uff0c\u89e3\u51b3\u8d77\u6765\u5c31\u53d8\u5f97\u76f8\u5bf9\u7b80\u5355\u3002\u4f8b\u5982\uff0c\u7f3a\u5c11\u7d22\u5f15\u5c31\u6dfb\u52a0\u7d22\u5f15\uff0cJOIN \u64cd\u4f5c\u8fc7\u591a\u5c31\u8fdb\u884c\u62c6\u5206\u3002\u8fd9\u91cc\u4e0d\u518d\u8be6\u7ec6\u5c55\u5f00\u3002<\/p>\n<\/div>\n<\/div>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_21128\" class=\"pvc_stats total_only  \" data-element-id=\"21128\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/aif.amtbbs.org\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u5b9e\u9645\u4e0a\uff0c\u6700\u5927\u7684\u6311\u6218\u4e0d\u5728\u4e8e\u89e3\u51b3\u95ee\u9898\uff0c\u800c\u5728\u4e8e\u51c6\u786e\u5b9a\u4f4d\u95ee\u9898\u3002\u56e0\u4e3a\u4e00\u65e6\u95ee\u9898\u88ab\u51c6\u786e\u5b9a\u4f4d\uff0c\u89e3\u51b3\u8d77\u6765\u5c31\u53d8\u5f97\u76f8\u5bf9\u7b80\u5355\u3002\u4f8b\u5982\uff0c\u7f3a [&hellip;]<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_21128\" class=\"pvc_stats total_only  \" data-element-id=\"21128\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/aif.amtbbs.org\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":56,"featured_media":21129,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,17,80],"tags":[1199],"class_list":["post-21128","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-23","category-17","category-80","tag-sql--"],"_links":{"self":[{"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/posts\/21128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/users\/56"}],"replies":[{"embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/comments?post=21128"}],"version-history":[{"count":1,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/posts\/21128\/revisions"}],"predecessor-version":[{"id":21130,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/posts\/21128\/revisions\/21130"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/media\/21129"}],"wp:attachment":[{"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/media?parent=21128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/categories?post=21128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/tags?post=21128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}