{"id":4252,"date":"2025-07-12T17:50:28","date_gmt":"2025-07-12T09:50:28","guid":{"rendered":"https:\/\/www.zhaozhao123.cn\/wpcms\/?p=4252"},"modified":"2025-07-12T17:50:28","modified_gmt":"2025-07-12T09:50:28","slug":"wordpress%e9%98%9f%e5%88%97%e4%bb%bb%e5%8a%a1%e5%88%86%e9%a1%b5%e5%a4%84%e7%90%86%e4%bb%a3%e7%a0%81","status":"publish","type":"post","link":"https:\/\/www.zhaozhao123.cn\/wpcms\/post\/4252.html","title":{"rendered":"WordPress\u961f\u5217\u4efb\u52a1\u5206\u9875\u5904\u7406\u4ee3\u7801"},"content":{"rendered":"\n

\u4ee5\u4e0b\u662f\u6839\u636e\u9700\u6c42\u5b9e\u73b0\u7684\u5206\u9875\u6e38\u6807\u5904\u7406\u961f\u5217\u4efb\u52a1\u7684\u4ee3\u7801\uff0c\u5305\u542b\u8be6\u7ec6\u7684\u6ce8\u91ca\u8bf4\u660e\uff1a<\/p>\n\n\n\n

function qian_process_queue() {\n    global $wpdb;\n    $table_name = $wpdb->prefix . QIAN_TABLE_NAME;\n    $per_page = 100; \/\/ \u6bcf\u9875\u5904\u7406\u6570\u91cf\n    $last_id = 0;    \/\/ \u521d\u59cb\u5316\u6e38\u6807\uff08\u8d77\u59cbID\uff09\n    $processed = 0;  \/\/ \u603b\u5904\u7406\u8ba1\u6570\n\n    \/\/ \u6301\u7eed\u83b7\u53d6\u6570\u636e\u76f4\u5230\u5904\u7406\u5b8c\u6bd5\n    do {\n        \/\/ \u83b7\u53d6\u5f53\u524d\u6279\u6b21\u6570\u636e\uff08\u6309ID\u5347\u5e8f\u4fdd\u8bc1\u987a\u5e8f\uff09\n        $batch = $wpdb->get_results(\n            $wpdb->prepare(\n                \"SELECT * FROM $table_name \n                WHERE id > %d AND status = 'pending' \n                ORDER BY id ASC \n                LIMIT %d\",\n                $last_id,\n                $per_page\n            )\n        );\n\n        \/\/ \u5f53\u524d\u6279\u6b21\u65e0\u6570\u636e\u5219\u7ed3\u675f\u5faa\u73af\n        if (empty($batch)) break;\n\n        \/\/ \u5904\u7406\u5f53\u524d\u6279\u6b21\n        foreach ($batch as $task) {\n            \/\/ \u6267\u884c\u4efb\u52a1\u5904\u7406\u51fd\u6570\n            $result = todo($task); \/\/ \u66ff\u6362\u4e3a\u5b9e\u9645\u4efb\u52a1\u51fd\u6570\n\n            \/\/ \u66f4\u65b0\u4efb\u52a1\u72b6\u6001\uff08\u6839\u636e\u5b9e\u9645\u9700\u6c42\uff09\n            $wpdb->update(\n                $table_name,\n                ['status' => $result ? 'completed' : 'failed'], \/\/ \u5904\u7406\u7ed3\u679c\u72b6\u6001\n                ['id' => $task->id],\n                ['%s'],  \/\/ \u72b6\u6001\u5b57\u6bb5\u683c\u5f0f\n                ['%d']   \/\/ ID\u5b57\u6bb5\u683c\u5f0f\n            );\n\n            \/\/ \u66f4\u65b0\u6e38\u6807\u4e3a\u5f53\u524d\u4efb\u52a1ID\n            $last_id = $task->id;\n            $processed++;\n        }\n\n        \/\/ \u91ca\u653e\u5185\u5b58\uff08\u5927\u6570\u636e\u91cf\u65f6\u91cd\u8981\uff09\n        unset($batch);\n\n        \/\/ \u53ef\u9009\uff1a\u6dfb\u52a0\u5ef6\u8fdf\u9632\u6b62\u670d\u52a1\u5668\u8fc7\u8f7d\n        \/\/ usleep(50000); \/\/ 50\u6beb\u79d2\u5ef6\u8fdf\n\n    } while (true); \/\/ \u901a\u8fc7\u5185\u90e8break\u9000\u51fa\u5faa\u73af\n\n    return $processed; \/\/ \u8fd4\u56de\u603b\u5904\u7406\u6570\u91cf\n}<\/code><\/pre>\n\n\n\n
\u5173\u952e\u5b9e\u73b0\u8bf4\u660e\uff1a<\/h3>\n\n\n\n
    \n
  1. \u6e38\u6807\u5206\u9875\u673a\u5236<\/strong>\uff1a<\/li>\n<\/ol>\n\n\n\n
      \n
    • \u4f7f\u7528 id > %d<\/code> \u6761\u4ef6\u5b9e\u73b0\u9ad8\u6548\u6e38\u6807\u5206\u9875<\/li>\n\n\n\n
    • \u6bcf\u6b21\u83b7\u53d6\u5927\u4e8e\u6700\u540e\u5904\u7406ID\u7684100\u6761\u8bb0\u5f55<\/li>\n\n\n\n
    • \u6309ID\u5347\u5e8f\u4fdd\u8bc1\u5904\u7406\u987a\u5e8f<\/li>\n<\/ul>\n\n\n\n
        \n
      1. \u5185\u5b58\u4f18\u5316<\/strong>\uff1a<\/li>\n<\/ol>\n\n\n\n
          \n
        • \u6bcf\u6279\u4ec5\u5904\u7406100\u6761\u8bb0\u5f55<\/li>\n\n\n\n
        • \u5904\u7406\u5b8c\u6210\u540e\u91ca\u653e\u5f53\u524d\u6279\u6b21\u5185\u5b58<\/li>\n\n\n\n
        • \u907f\u514d\u4e00\u6b21\u6027\u52a0\u8f7d\u5168\u90e8\u6570\u636e<\/li>\n<\/ul>\n\n\n\n
            \n
          1. \u4efb\u52a1\u5904\u7406\u6d41\u7a0b<\/strong>\uff1a<\/li>\n<\/ol>\n\n\n\n
              \n
            • \u53ea\u5904\u7406\u72b6\u6001\u4e3a pending<\/code> \u7684\u4efb\u52a1<\/li>\n\n\n\n
            • \u8c03\u7528 todo($task)<\/code> \u6267\u884c\u5b9e\u9645\u4efb\u52a1<\/li>\n\n\n\n
            • \u6839\u636e\u5904\u7406\u7ed3\u679c\u66f4\u65b0\u4efb\u52a1\u72b6\u6001<\/li>\n<\/ul>\n\n\n\n
                \n
              1. \u6269\u5c55\u6027\u8003\u8651<\/strong>\uff1a<\/li>\n<\/ol>\n\n\n\n
                  \n
                • \u53ef\u6dfb\u52a0 usleep()<\/code> \u63a7\u5236\u5904\u7406\u9891\u7387<\/li>\n\n\n\n
                • \u652f\u6301\u72b6\u6001\u5b57\u6bb5\u6269\u5c55\uff08\u5931\u8d25\u91cd\u8bd5\u7b49\u903b\u8f91\uff09<\/li>\n\n\n\n
                • \u8fd4\u56de\u5904\u7406\u603b\u6570\u4fbf\u4e8e\u76d1\u63a7<\/li>\n<\/ul>\n\n\n\n
                  \u4f7f\u7528\u793a\u4f8b\uff1a<\/h3>\n\n\n\n
                  \/\/ \u5728\u540e\u53f0\u4efb\u52a1\u5904\u7406\u5668\u4e2d\u8c03\u7528\nadd_action('qian_daily_processing', 'handle_queue_processing');\n\nfunction handle_queue_processing() {\n    $processed = qian_process_queue();\n    error_log(\"[QIAN] \u672c\u6b21\u5904\u7406\u5b8c\u6210\uff0c\u5171\u5904\u7406 {$processed} \u4e2a\u4efb\u52a1\");\n}\n\n\/\/ \u6dfb\u52a0\u5b9a\u65f6\u4efb\u52a1\uff08\u793a\u4f8b\uff09\nif (!wp_next_scheduled('qian_daily_processing')) {\n    wp_schedule_event(time(), 'hourly', 'qian_daily_processing');\n}<\/code><\/pre>\n\n\n\n
                  \n
                  \u91cd\u8981\u63d0\u793a<\/strong>\uff1a<\/p>\n\n\n\n
                    \n
                  1. \u5c06 todo()<\/code> \u66ff\u6362\u4e3a\u5b9e\u9645\u4efb\u52a1\u5904\u7406\u51fd\u6570<\/li>\n\n\n\n
                  2. \u5efa\u8bae\u901a\u8fc7WP-Cron\u6216\u81ea\u5b9a\u4e49\u540e\u53f0\u8fdb\u7a0b\u8c03\u7528<\/li>\n\n\n\n
                  3. \u5927\u6570\u636e\u91cf\u65f6\u8003\u8651\u6dfb\u52a0\u4efb\u52a1\u9501\u9632\u6b62\u5e76\u53d1\u51b2\u7a81<\/li>\n\n\n\n
                  4. \u6839\u636e\u4e1a\u52a1\u9700\u6c42\u5b8c\u5584\u9519\u8bef\u5904\u7406\uff08\u5982\u5931\u8d25\u91cd\u8bd5\u673a\u5236\uff09<\/li>\n<\/ol>\n<\/blockquote>\n\n\n\n
                    \u6b64\u5b9e\u73b0\u901a\u8fc7\u6e38\u6807\u5206\u9875\u6709\u6548\u907f\u514d\u4e86\u4f20\u7edf\u5206\u9875\u7684\u6df1\u5ea6\u5206\u9875\u6027\u80fd\u95ee\u9898\uff0c\u7279\u522b\u9002\u5408\u5904\u7406\u5927\u578b\u961f\u5217\u4efb\u52a1\uff0c\u540c\u65f6\u4fdd\u6301\u8f83\u4f4e\u7684\u5185\u5b58\u6d88\u8017\u3002<\/p>\n\n\n\n
                    <\/p>\n","protected":false},"excerpt":{"rendered":"
                    \u4ee5\u4e0b\u662f\u6839\u636e\u9700\u6c42\u5b9e\u73b0\u7684\u5206\u9875\u6e38\u6807\u5904\u7406\u961f\u5217\u4efb\u52a1\u7684\u4ee3\u7801\uff0c\u5305\u542b\u8be6\u7ec6\u7684\u6ce8\u91ca\u8bf4\u660e\uff1a \u5173\u952e\u5b9e\u73b0\u8bf4\u660e\uff1a \u4f7f\u7528\u793a\u4f8b\uff1a \u6b64\u5b9e\u73b0\u901a\u8fc7\u6e38\u6807\u5206\u9875\u6709\u6548\u907f\u514d\u4e86\u4f20\u7edf\u5206\u9875\u7684\u6df1\u5ea6\u5206\u9875\u6027\u80fd\u95ee\u9898\uff0c\u7279\u522b\u9002\u5408\u5904\u7406\u5927\u578b\u961f\u5217\u4efb\u52a1\uff0c\u540c\u65f6\u4fdd\u6301\u8f83\u4f4e\u7684\u5185\u5b58\u6d88\u8017\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3205],"tags":[3209],"tuisongtax":[],"class_list":["post-4252","post","type-post","status-publish","format-standard","hentry","category-kaifawenzhang","tag-kfdlsx"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/posts\/4252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/comments?post=4252"}],"version-history":[{"count":0,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/posts\/4252\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/media?parent=4252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/categories?post=4252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/tags?post=4252"},{"taxonomy":"tuisongtax","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/tuisongtax?post=4252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}