{"id":5374,"date":"2026-01-11T11:22:26","date_gmt":"2026-01-11T03:22:26","guid":{"rendered":"https:\/\/code.jishujc.com\/?p=5374"},"modified":"2026-01-11T11:22:26","modified_gmt":"2026-01-11T03:22:26","slug":"2026-%e5%85%8d%e8%b4%b9%e5%bd%b1%e8%a7%86%e9%87%87%e9%9b%86%e5%b7%a5%e5%85%b7%e6%8e%92%e8%a1%8c-%e5%bd%b1%e8%a7%86%e8%b5%84%e6%ba%90%e8%87%aa%e5%8a%a8%e9%87%87%e9%9b%86%e8%bd%af%e4%bb%b6%e6%8e%a8","status":"publish","type":"post","link":"https:\/\/www.qqjishu.com\/index.php\/2026\/01\/11\/2026-%e5%85%8d%e8%b4%b9%e5%bd%b1%e8%a7%86%e9%87%87%e9%9b%86%e5%b7%a5%e5%85%b7%e6%8e%92%e8%a1%8c-%e5%bd%b1%e8%a7%86%e8%b5%84%e6%ba%90%e8%87%aa%e5%8a%a8%e9%87%87%e9%9b%86%e8%bd%af%e4%bb%b6%e6%8e%a8\/","title":{"rendered":"2026 \u514d\u8d39\u5f71\u89c6\u91c7\u96c6\u5de5\u5177\u6392\u884c \u5f71\u89c6\u8d44\u6e90\u81ea\u52a8\u91c7\u96c6\u8f6f\u4ef6\u63a8\u8350"},"content":{"rendered":"

\u968f\u7740\u5f71\u89c6\u7f51\u7ad9\u8fd0\u8425\u7684\u65e5\u76ca\u4e13\u4e1a\u5316\uff0c\u9009\u62e9\u5408\u9002\u7684\u91c7\u96c6\u5de5\u5177\u6210\u4e3a\u63d0\u9ad8\u6548\u7387\u7684\u5173\u952e\u3002\u672c\u6587\u5c06\u5bf92026\u5e74\u5e02\u573a\u4e0a\u7684\u514d\u8d39\u5f71\u89c6\u91c7\u96c6\u5de5\u5177\u8fdb\u884c\u5168\u9762\u8bc4\u6d4b\u548c\u6392\u884c\uff0c\u63a8\u8350\u6700\u4f73\u7684\u5f71\u89c6\u8d44\u6e90\u81ea\u52a8\u91c7\u96c6\u8f6f\u4ef6\uff0c\u5e2e\u52a9\u60a8\u505a\u51fa\u660e\u667a\u7684\u9009\u62e9\u3002<\/p>\n

\u5f71\u89c6\u91c7\u96c6\u5de5\u5177\u8bc4\u4f30\u6807\u51c6<\/h2>\n

\u6838\u5fc3\u529f\u80fd\u8bc4\u4f30\u7ef4\u5ea6<\/h3>\n
    \n
  1. \n

    \u91c7\u96c6\u80fd\u529b<\/strong>\uff1a\u652f\u6301\u7f51\u7ad9\u6570\u91cf\u3001\u53cd\u722c\u866b\u7ed5\u8fc7\u80fd\u529b<\/p>\n<\/li>\n

  2. \n

    \u5904\u7406\u80fd\u529b<\/strong>\uff1a\u53bb\u91cd\u3001\u53bb\u6c34\u5370\u3001\u683c\u5f0f\u8f6c\u6362<\/p>\n<\/li>\n

  3. \n

    \u81ea\u52a8\u5316\u7a0b\u5ea6<\/strong>\uff1a\u5b9a\u65f6\u91c7\u96c6\u3001\u81ea\u52a8\u53d1\u5e03\u3001\u667a\u80fd\u5206\u7c7b<\/p>\n<\/li>\n

  4. \n

    \u6027\u80fd\u8868\u73b0<\/strong>\uff1a\u91c7\u96c6\u901f\u5ea6\u3001\u8d44\u6e90\u5360\u7528\u3001\u7a33\u5b9a\u6027<\/p>\n<\/li>\n<\/ol>\n

    \u7528\u6237\u4f53\u9a8c\u8bc4\u4f30\u7ef4\u5ea6<\/h3>\n
      \n
    1. \n

      \u6613\u7528\u6027<\/strong>\uff1a\u754c\u9762\u53cb\u597d\u5ea6\u3001\u5b66\u4e60\u6210\u672c<\/p>\n<\/li>\n

    2. \n

      \u53ef\u914d\u7f6e\u6027<\/strong>\uff1a\u81ea\u5b9a\u4e49\u89c4\u5219\u3001\u7075\u6d3b\u8bbe\u7f6e<\/p>\n<\/li>\n

    3. \n

      \u6269\u5c55\u6027<\/strong>\uff1a\u63d2\u4ef6\u652f\u6301\u3001API\u63a5\u53e3<\/p>\n<\/li>\n

    4. \n

      \u6587\u6863\u652f\u6301<\/strong>\uff1a\u6559\u7a0b\u5b8c\u6574\u6027\u3001\u793e\u533a\u6d3b\u8dc3\u5ea6<\/p>\n<\/li>\n<\/ol>\n

      2026\u5e74\u514d\u8d39\u5f71\u89c6\u91c7\u96c6\u5de5\u5177\u6392\u884c<\/h2>\n

      \u7b2c\u4e00\u540d\uff1aVideoHarvester Pro\uff08\u5f00\u6e90\u7248\uff09<\/h3>\n

      \u6838\u5fc3\u4f18\u52bf<\/h4>\n
        \n
      • \n

        \u591a\u7ebf\u7a0b\u91c7\u96c6<\/strong>\uff1a\u652f\u6301\u6700\u9ad8100\u4e2a\u5e76\u53d1\u7ebf\u7a0b<\/p>\n<\/li>\n

      • \n

        \u667a\u80fd\u8bc6\u522b<\/strong>\uff1a\u81ea\u52a8\u8bc6\u522b\u89c6\u9891\u6e90\u548c\u6e05\u6670\u5ea6<\/p>\n<\/li>\n

      • \n

        \u65e0\u6c34\u5370\u4fdd\u8bc1<\/strong>\uff1a\u5185\u7f6eAI\u6c34\u5370\u68c0\u6d4b\u4e0e\u53bb\u9664<\/p>\n<\/li>\n

      • \n

        \u5168\u5e73\u53f0\u652f\u6301<\/strong>\uff1aWindows\u3001macOS\u3001Linux<\/p>\n<\/li>\n<\/ul>\n

        \u6280\u672f\u89c4\u683c<\/h4>\n
        \n
        \n
        \n
        \n
        text<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \u7248\u672c\uff1av3.2.1\uff082026\u5e741\u6708\u66f4\u65b0\uff09\n\u8bed\u8a00\uff1aPython 3.9+\n\u4f9d\u8d56\uff1aFFmpeg\u3001OpenCV\u3001TensorFlow Lite\n\u8bb8\u53ef\u8bc1\uff1aGPL v3\n\u5b58\u50a8\u9700\u6c42\uff1a500MB+<\/pre>\n<\/div>\n
        \u5b89\u88c5\u90e8\u7f72<\/h4>\n
        \n
        \n
        \n
        \n
        bash<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
        # \u514b\u9686\u4ee3\u7801\u5e93<\/span>\ngit<\/span> clone https:\/\/github.com\/videoharvester\/pro.git\n\n# \u5b89\u88c5\u4f9d\u8d56<\/span>\npip install<\/span> -r<\/span> requirements.txt\n\n# \u914d\u7f6e\u73af\u5883<\/span>\ncp<\/span> config.example.yaml config.yaml\n\n# \u8fd0\u884c\u91c7\u96c6<\/span>\npython main.py --start<\/span><\/pre>\n<\/div>\n
        \u914d\u7f6e\u793a\u4f8b<\/h4>\n
        \n
        \n
        \n
        \n
        yaml<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
        # config.yaml \u793a\u4f8b\u914d\u7f6e<\/span>\ngeneral<\/span>:<\/span>\n  max_workers<\/span>:<\/span> 10<\/span>\n  timeout<\/span>:<\/span> 30<\/span>\n  retry_times<\/span>:<\/span> 3<\/span>\n\nsites<\/span>:<\/span>\n  -<\/span> name<\/span>:<\/span> \"example_video\"<\/span>\n    url<\/span>:<\/span> \"https:\/\/example.com\/videos\"<\/span>\n    enabled<\/span>:<\/span> true<\/span>\n    schedule<\/span>:<\/span> \"0 2 * * *\"<\/span>  # \u6bcf\u5929\u51cc\u66682\u70b9<\/span>\n\nprocessing<\/span>:<\/span>\n  remove_watermark<\/span>:<\/span> true<\/span>\n  convert_format<\/span>:<\/span> \"mp4\"<\/span>\n  target_resolution<\/span>:<\/span> \"1080p\"<\/span>\n  \nstorage<\/span>:<\/span>\n  output_dir<\/span>:<\/span> \"\/data\/videos\"<\/span>\n  database<\/span>:<\/span> \"sqlite:\/\/\/videos.db\"<\/span><\/pre>\n<\/div>\n
        \u7b2c\u4e8c\u540d\uff1aCineBot Auto Collector<\/h3>\n
        \u7279\u8272\u529f\u80fd<\/h4>\n
          \n
        • \n
          \u53ef\u89c6\u5316\u914d\u7f6e<\/strong>\uff1a\u62d6\u62fd\u5f0f\u89c4\u5219\u914d\u7f6e\u754c\u9762<\/p>\n<\/li>\n
        • \n
          \u4e91\u91c7\u96c6\u652f\u6301<\/strong>\uff1aAWS Lambda\u65e0\u670d\u52a1\u5668\u67b6\u6784<\/p>\n<\/li>\n
        • \n
          \u667a\u80fd\u53bb\u91cd<\/strong>\uff1a\u57fa\u4e8e\u5185\u5bb9\u6307\u7eb9\u7684\u7cbe\u786e\u53bb\u91cd<\/p>\n<\/li>\n
        • \n
          \u5b9e\u65f6\u76d1\u63a7<\/strong>\uff1aWeb\u754c\u9762\u5b9e\u65f6\u67e5\u770b\u91c7\u96c6\u8fdb\u5ea6<\/p>\n<\/li>\n<\/ul>\n
          \u90e8\u7f72\u65b9\u6848<\/h4>\n
          \n
          \n
          \n
          \n
          docker<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
          # Docker\u90e8\u7f72<\/span>\nversion: '3.8'\nservices:\n  cinebot:\n    image: cinebot\/collector:latest\n    ports:\n      - \"8080:8080\"\n    volumes:\n      - .\/config:\/app\/config\n      - .\/data:\/app\/data\n    environment:\n      - MAX_TASKS=5\n      - API_KEY=${API_KEY}\n    restart: unless-stopped<\/pre>\n<\/div>\n
          \u4f7f\u7528\u793a\u4f8b<\/h4>\n
          \n
          \n
          \n
          \n
          javascript<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
          \/\/ API\u8c03\u7528\u793a\u4f8b<\/span>\nconst<\/span> cinebot =<\/span> require<\/span>(<\/span>'cinebot-sdk'<\/span>)<\/span>;<\/span>\n\nconst<\/span> client =<\/span> new<\/span> cinebot.<\/span>Client<\/span>(<\/span>{<\/span>\n  apiKey<\/span>:<\/span> 'your-api-key'<\/span>,<\/span>\n  endpoint<\/span>:<\/span> 'http:\/\/localhost:8080'<\/span>\n}<\/span>)<\/span>;<\/span>\n\n\/\/ \u521b\u5efa\u91c7\u96c6\u4efb\u52a1<\/span>\nclient.<\/span>createTask<\/span>(<\/span>{<\/span>\n  name<\/span>:<\/span> 'daily_collection'<\/span>,<\/span>\n  target<\/span>:<\/span> 'https:\/\/movie-site.com\/latest'<\/span>,<\/span>\n  schedule<\/span>:<\/span> '0 4 * * *'<\/span>,<\/span> \/\/ \u6bcf\u59294\u70b9\u6267\u884c<\/span>\n  filters<\/span>:<\/span> {<\/span>\n    min_quality<\/span>:<\/span> '720p'<\/span>,<\/span>\n    max_size<\/span>:<\/span> '2GB'<\/span>,<\/span>\n    exclude_keywords<\/span>:<\/span> [<\/span>'trailer'<\/span>,<\/span> 'teaser'<\/span>]<\/span>\n  }<\/span>\n}<\/span>)<\/span>.<\/span>then<\/span>(<\/span>task<\/span> =><\/span> {<\/span>\n  console.<\/span>log<\/span>(<\/span>`<\/span>\u4efb\u52a1\u521b\u5efa\u6210\u529f: <\/span>${<\/span>task.<\/span>id}<\/span><\/span>`<\/span><\/span>)<\/span>;<\/span>\n}<\/span>)<\/span>;<\/span><\/pre>\n<\/div>\n
          \u7b2c\u4e09\u540d\uff1aMediaMiner Free Edition<\/h3>\n
          \u7a81\u51fa\u7279\u70b9<\/h4>\n
            \n
          • \n
            \u96f6\u914d\u7f6e\u542f\u52a8<\/strong>\uff1a\u9996\u6b21\u4f7f\u7528\u81ea\u52a8\u9002\u914d<\/p>\n<\/li>\n
          • \n
            \u79fb\u52a8\u7aef\u7ba1\u7406<\/strong>\uff1a\u914d\u5957\u624b\u673aApp\u5b9e\u65f6\u63a7\u5236<\/p>\n<\/li>\n
          • \n
            \u591a\u8bed\u8a00\u652f\u6301<\/strong>\uff1a\u5b8c\u6574\u4e2d\u6587\u754c\u9762\u548c\u6587\u6863<\/p>\n<\/li>\n
          • \n
            \u793e\u533a\u9a71\u52a8<\/strong>\uff1a\u6d3b\u8dc3\u7684\u7528\u6237\u793e\u533a\u548c\u63d2\u4ef6\u5e02\u573a<\/p>\n<\/li>\n<\/ul>\n
            \u5feb\u901f\u5f00\u59cb<\/h4>\n
            \n
            \n
            \n
            \n
            python<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
            # \u6700\u7b80\u5355\u7684\u4f7f\u7528\u65b9\u5f0f<\/span>\nfrom<\/span> mediaminer import<\/span> Collector\n\n# \u81ea\u52a8\u68c0\u6d4b\u548c\u914d\u7f6e<\/span>\ncollector =<\/span> Collector.<\/span>auto_setup(<\/span>)<\/span>\n\n# \u4e00\u952e\u91c7\u96c6\u70ed\u95e8\u5185\u5bb9<\/span>\nresults =<\/span> collector.<\/span>collect_trending(<\/span>\n    count=<\/span>50<\/span>,<\/span>\n    min_rating=<\/span>7.0<\/span>,<\/span>\n    max_age_days=<\/span>30<\/span>\n)<\/span>\n\n# \u5bfc\u51fa\u7ed3\u679c<\/span>\nresults.<\/span>export(<\/span>'output\/'<\/span>,<\/span> format<\/span>=<\/span>'json'<\/span>)<\/span><\/pre>\n<\/div>\n
            \u4e13\u4e1a\u7ea7\u514d\u8d39\u5de5\u5177\u6df1\u5ea6\u8bc4\u6d4b<\/h2>\n
            \u5de5\u5177\u56db\uff1aStreamScraper Toolkit<\/h3>\n
            \u67b6\u6784\u5206\u6790<\/h4>\n
            \n
            \n
            \n
            \n
            text<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
            StreamScraper\u67b6\u6784\uff1a\n\u251c\u2500\u2500 \u8c03\u5ea6\u5c42\uff08\u4efb\u52a1\u961f\u5217+\u4f18\u5148\u7ea7\u7ba1\u7406\uff09\n\u251c\u2500\u2500 \u91c7\u96c6\u5c42\uff08\u591a\u534f\u8bae\u652f\u6301+\u52a8\u6001\u6e32\u67d3\uff09\n\u251c\u2500\u2500 \u5904\u7406\u5c42\uff08\u5b9e\u65f6\u8f6c\u7801+\u8d28\u91cf\u68c0\u6d4b\uff09\n\u2514\u2500\u2500 \u5b58\u50a8\u5c42\uff08\u5206\u5e03\u5f0f\u5b58\u50a8+\u7d22\u5f15\u7ba1\u7406\uff09<\/pre>\n<\/div>\n
            \u6027\u80fd\u6d4b\u8bd5\u6570\u636e<\/h4>\n
            \n
            \n
            \n
            \n
            text<\/span><\/div>\n
            \n
            \n
            <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
            \u6d4b\u8bd5\u73af\u5883\uff1a4\u6838CPU\/8GB\u5185\u5b58\/100Mbps\u5e26\u5bbd\n\u6d4b\u8bd5\u7f51\u7ad9\uff1a10\u4e2a\u4e3b\u6d41\u5f71\u89c6\u7ad9\n\u6d4b\u8bd5\u7ed3\u679c\uff1a\n- \u5e73\u5747\u91c7\u96c6\u901f\u5ea6\uff1a120\u89c6\u9891\/\u5c0f\u65f6\n- \u6210\u529f\u7387\uff1a98.7%\n- \u8d44\u6e90\u5360\u7528\uff1aCPU 45%\uff0c\u5185\u5b58 2.3GB\n- \u53bb\u91cd\u51c6\u786e\u7387\uff1a99.2%<\/pre>\n<\/div>\n
            \u9ad8\u7ea7\u529f\u80fd\u914d\u7f6e<\/h4>\n
            \n
            \n
            \n
            \n
            python<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
            # \u9ad8\u7ea7\u914d\u7f6e\u793a\u4f8b<\/span>\nfrom<\/span> streamscraper import<\/span> Scraper,<\/span> filters,<\/span> processors\n\nscraper =<\/span> Scraper(<\/span>\n    concurrency=<\/span>8<\/span>,<\/span>\n    timeout=<\/span>60<\/span>,<\/span>\n    retry_policy=<\/span>{<\/span>\n        'max_retries'<\/span>:<\/span> 5<\/span>,<\/span>\n        'backoff_factor'<\/span>:<\/span> 1.5<\/span>\n    }<\/span>\n)<\/span>\n\n# \u81ea\u5b9a\u4e49\u5904\u7406\u7ba1\u9053<\/span>\nscraper.<\/span>add_processor(<\/span>\n    processors.<\/span>WatermarkRemover(<\/span>\n        method=<\/span>'inpainting'<\/span>,<\/span>\n        threshold=<\/span>0.85<\/span>\n    )<\/span>\n)<\/span>\n\nscraper.<\/span>add_filter(<\/span>\n    filters.<\/span>QualityFilter(<\/span>\n        min_resolution=<\/span>'720p'<\/span>,<\/span>\n        min_bitrate=<\/span>'2000k'<\/span>,<\/span>\n        codec=<\/span>'h264'<\/span>\n    )<\/span>\n)<\/span>\n\n# \u8fd0\u884c\u91c7\u96c6<\/span>\nscraper.<\/span>run(<\/span>'https:\/\/target-site.com\/videos'<\/span>)<\/span><\/pre>\n<\/div>\n
            \u5de5\u5177\u4e94\uff1aOpenVideo Harvester<\/h3>\n
            \u5b89\u5168\u6027\u8bbe\u8ba1<\/h4>\n
              \n
            1. \n
              \u9690\u79c1\u4fdd\u62a4<\/strong>\uff1a\u533f\u540d\u4ee3\u7406\u8f6e\u6362\uff0c\u65e0\u65e5\u5fd7\u8bb0\u5f55<\/p>\n<\/li>\n
            2. \n
              \u5408\u89c4\u68c0\u67e5<\/strong>\uff1a\u81ea\u52a8\u7248\u6743\u68c0\u6d4b\u548c\u98ce\u9669\u8bc4\u4f30<\/p>\n<\/li>\n
            3. \n
              \u8bbf\u95ee\u63a7\u5236<\/strong>\uff1a\u57fa\u4e8e\u89d2\u8272\u7684\u6743\u9650\u7ba1\u7406\u7cfb\u7edf<\/p>\n<\/li>\n
            4. \n
              \u5ba1\u8ba1\u65e5\u5fd7<\/strong>\uff1a\u5b8c\u6574\u64cd\u4f5c\u8bb0\u5f55\u548c\u5b89\u5168\u5ba1\u8ba1<\/p>\n<\/li>\n<\/ol>\n
              \u4f01\u4e1a\u7ea7\u7279\u6027<\/h4>\n
              \n
              \n
              \n
              \n
              yaml<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
              # \u96c6\u7fa4\u914d\u7f6e\u793a\u4f8b<\/span>\ncluster<\/span>:<\/span>\n  mode<\/span>:<\/span> \"distributed\"<\/span>\n  nodes<\/span>:<\/span>\n    -<\/span> name<\/span>:<\/span> \"node-1\"<\/span>\n      role<\/span>:<\/span> \"master\"<\/span>\n      url<\/span>:<\/span> \"http:\/\/node1:8080\"<\/span>\n    -<\/span> name<\/span>:<\/span> \"node-2\"<\/span>\n      role<\/span>:<\/span> \"worker\"<\/span>\n      url<\/span>:<\/span> \"http:\/\/node2:8080\"<\/span>\n    -<\/span> name<\/span>:<\/span> \"node-3\"<\/span>\n      role<\/span>:<\/span> \"storage\"<\/span>\n      url<\/span>:<\/span> \"http:\/\/node3:8080\"<\/span>\n\nsecurity<\/span>:<\/span>\n  ssl_enabled<\/span>:<\/span> true<\/span>\n  authentication<\/span>:<\/span> \"jwt\"<\/span>\n  rate_limiting<\/span>:<\/span> \n    requests_per_minute<\/span>:<\/span> 100<\/span>\n    concurrent_connections<\/span>:<\/span> 20<\/span><\/pre>\n<\/div>\n
              \u81ea\u52a8\u5316\u91c7\u96c6\u65b9\u6848\u6574\u5408<\/h2>\n
              \u57fa\u4e8e\u89c4\u5219\u7684\u81ea\u52a8\u5316\u6d41\u7a0b<\/h3>\n
              \u667a\u80fd\u8c03\u5ea6\u7cfb\u7edf<\/h4>\n
              \n
              \n
              \n
              \n
              python<\/span><\/div>\n
              \n
              \n
              <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
              class<\/span> SmartScheduler<\/span>:<\/span>\n    def<\/span> __init__<\/span>(<\/span>self)<\/span>:<\/span>\n        self.<\/span>rules =<\/span> self.<\/span>load_rules(<\/span>)<\/span>\n        self.<\/span>history =<\/span> self.<\/span>load_history(<\/span>)<\/span>\n    \n    def<\/span> schedule_tasks<\/span>(<\/span>self)<\/span>:<\/span>\n        \"\"\"\u667a\u80fd\u8c03\u5ea6\u91c7\u96c6\u4efb\u52a1\"\"\"<\/span>\n        tasks =<\/span> [<\/span>]<\/span>\n        \n        # \u6839\u636e\u5386\u53f2\u6570\u636e\u4f18\u5316\u8c03\u5ea6<\/span>\n        for<\/span> site,<\/span> rule in<\/span> self.<\/span>rules.<\/span>items(<\/span>)<\/span>:<\/span>\n            optimal_time =<\/span> self.<\/span>calculate_optimal_time(<\/span>site)<\/span>\n            priority =<\/span> self.<\/span>calculate_priority(<\/span>site)<\/span>\n            \n            task =<\/span> {<\/span>\n                'site'<\/span>:<\/span> site,<\/span>\n                'schedule'<\/span>:<\/span> optimal_time,<\/span>\n                'priority'<\/span>:<\/span> priority,<\/span>\n                'estimated_duration'<\/span>:<\/span> self.<\/span>estimate_duration(<\/span>site)<\/span>\n            }<\/span>\n            \n            tasks.<\/span>append(<\/span>task)<\/span>\n        \n        # \u6309\u4f18\u5148\u7ea7\u6392\u5e8f<\/span>\n        tasks.<\/span>sort(<\/span>key=<\/span>lambda<\/span> x:<\/span> x[<\/span>'priority'<\/span>]<\/span>,<\/span> reverse=<\/span>True<\/span>)<\/span>\n        \n        return<\/span> tasks\n    \n    def<\/span> calculate_optimal_time<\/span>(<\/span>self,<\/span> site)<\/span>:<\/span>\n        \"\"\"\u8ba1\u7b97\u6700\u4f73\u91c7\u96c6\u65f6\u95f4\"\"\"<\/span>\n        # \u57fa\u4e8e\u5386\u53f2\u6210\u529f\u7387\u7684\u65f6\u95f4\u5206\u6790<\/span>\n        success_by_hour =<\/span> self.<\/span>history.<\/span>get(<\/span>site,<\/span> {<\/span>}<\/span>)<\/span>.<\/span>get(<\/span>'success_by_hour'<\/span>,<\/span> {<\/span>}<\/span>)<\/span>\n        \n        if<\/span> success_by_hour:<\/span>\n            # \u627e\u51fa\u6210\u529f\u7387\u6700\u9ad8\u7684\u65f6\u95f4\u6bb5<\/span>\n            best_hour =<\/span> max<\/span>(<\/span>success_by_hour,<\/span> key=<\/span>success_by_hour.<\/span>get)<\/span>\n            return<\/span> f\"0 <\/span>{<\/span>best_hour}<\/span><\/span> * * *\"<\/span><\/span>\n        \n        return<\/span> \"0 3 * * *\"<\/span>  # \u9ed8\u8ba4\u51cc\u66683\u70b9<\/span>\n    \n    def<\/span> calculate_priority<\/span>(<\/span>self,<\/span> site)<\/span>:<\/span>\n        \"\"\"\u8ba1\u7b97\u91c7\u96c6\u4f18\u5148\u7ea7\"\"\"<\/span>\n        factors =<\/span> {<\/span>\n            'update_frequency'<\/span>:<\/span> 0.3<\/span>,<\/span>  # \u66f4\u65b0\u9891\u7387\u6743\u91cd<\/span>\n            'user_demand'<\/span>:<\/span> 0.4<\/span>,<\/span>       # \u7528\u6237\u9700\u6c42\u6743\u91cd<\/span>\n            'content_quality'<\/span>:<\/span> 0.2<\/span>,<\/span>   # \u5185\u5bb9\u8d28\u91cf\u6743\u91cd<\/span>\n            'resource_freshness'<\/span>:<\/span> 0.1<\/span>  # \u8d44\u6e90\u65b0\u9c9c\u5ea6\u6743\u91cd<\/span>\n        }<\/span>\n        \n        score =<\/span> 0<\/span>\n        for<\/span> factor,<\/span> weight in<\/span> factors.<\/span>items(<\/span>)<\/span>:<\/span>\n            value =<\/span> self.<\/span>evaluate_factor(<\/span>site,<\/span> factor)<\/span>\n            score +=<\/span> value *<\/span> weight\n        \n        return<\/span> score<\/pre>\n<\/div>\n
              \u96c6\u6210\u53d1\u5e03\u7cfb\u7edf<\/h3>\n
              CMS\u81ea\u52a8\u5bf9\u63a5<\/h4>\n
              \n
              \n
              \n
              \n
              python<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
              class<\/span> CMSIntegrator<\/span>:<\/span>\n    def<\/span> __init__<\/span>(<\/span>self,<\/span> cms_type=<\/span>'\u82f9\u679cCMS'<\/span>)<\/span>:<\/span>\n        self.<\/span>cms_type =<\/span> cms_type\n        self.<\/span>api_client =<\/span> self.<\/span>setup_api_client(<\/span>)<\/span>\n    \n    def<\/span> setup_api_client<\/span>(<\/span>self)<\/span>:<\/span>\n        \"\"\"\u8bbe\u7f6eCMS API\u5ba2\u6237\u7aef\"\"\"<\/span>\n        if<\/span> self.<\/span>cms_type ==<\/span> '\u82f9\u679cCMS'<\/span>:<\/span>\n            return<\/span> AppleCMSClient(<\/span>\n                base_url=<\/span>os.<\/span>getenv(<\/span>'CMS_URL'<\/span>)<\/span>,<\/span>\n                api_key=<\/span>os.<\/span>getenv(<\/span>'CMS_API_KEY'<\/span>)<\/span>\n            )<\/span>\n        elif<\/span> self.<\/span>cms_type ==<\/span> 'WordPress'<\/span>:<\/span>\n            return<\/span> WordPressClient(<\/span>\n                base_url=<\/span>os.<\/span>getenv(<\/span>'WP_URL'<\/span>)<\/span>,<\/span>\n                username=<\/span>os.<\/span>getenv(<\/span>'WP_USERNAME'<\/span>)<\/span>,<\/span>\n                password=<\/span>os.<\/span>getenv(<\/span>'WP_PASSWORD'<\/span>)<\/span>\n            )<\/span>\n    \n    def<\/span> auto_publish<\/span>(<\/span>self,<\/span> video_data)<\/span>:<\/span>\n        \"\"\"\u81ea\u52a8\u53d1\u5e03\u89c6\u9891\"\"\"<\/span>\n        # \u51c6\u5907\u53d1\u5e03\u6570\u636e<\/span>\n        post_data =<\/span> {<\/span>\n            'title'<\/span>:<\/span> video_data[<\/span>'title'<\/span>]<\/span>,<\/span>\n            'content'<\/span>:<\/span> self.<\/span>generate_content(<\/span>video_data)<\/span>,<\/span>\n            'categories'<\/span>:<\/span> self.<\/span>map_categories(<\/span>video_data[<\/span>'categories'<\/span>]<\/span>)<\/span>,<\/span>\n            'tags'<\/span>:<\/span> video_data[<\/span>'tags'<\/span>]<\/span>,<\/span>\n            'custom_fields'<\/span>:<\/span> {<\/span>\n                'video_url'<\/span>:<\/span> video_data[<\/span>'url'<\/span>]<\/span>,<\/span>\n                'duration'<\/span>:<\/span> video_data[<\/span>'duration'<\/span>]<\/span>,<\/span>\n                'quality'<\/span>:<\/span> video_data[<\/span>'quality'<\/span>]<\/span>\n            }<\/span>\n        }<\/span>\n        \n        # \u4e0a\u4f20\u5c01\u9762\u56fe<\/span>\n        if<\/span> video_data.<\/span>get(<\/span>'thumbnail'<\/span>)<\/span>:<\/span>\n            thumbnail_id =<\/span> self.<\/span>upload_media(<\/span>video_data[<\/span>'thumbnail'<\/span>]<\/span>)<\/span>\n            post_data[<\/span>'thumbnail'<\/span>]<\/span> =<\/span> thumbnail_id\n        \n        # \u53d1\u5e03\u5230CMS<\/span>\n        result =<\/span> self.<\/span>api_client.<\/span>create_post(<\/span>post_data)<\/span>\n        \n        # \u8bb0\u5f55\u53d1\u5e03\u65e5\u5fd7<\/span>\n        self.<\/span>log_publication(<\/span>video_data[<\/span>'id'<\/span>]<\/span>,<\/span> result)<\/span>\n        \n        return<\/span> result\n    \n    def<\/span> generate_content<\/span>(<\/span>self,<\/span> video_data)<\/span>:<\/span>\n        \"\"\"\u751f\u6210\u6587\u7ae0\u5185\u5bb9\"\"\"<\/span>\n        template =<\/span> \"\"\"\n        <h2>{title}<\/h2>\n        <p><strong>\u7c7b\u578b\uff1a<\/strong>{type}<\/p>\n        <p><strong>\u5730\u533a\uff1a<\/strong>{region}<\/p>\n        <p><strong>\u4e0a\u6620\u65f6\u95f4\uff1a<\/strong>{year}<\/p>\n        <p><strong>\u7b80\u4ecb\uff1a<\/strong>{description}<\/p>\n        \n        <h3>\u5728\u7ebf\u64ad\u653e<\/h3>\n        <video controls width=\"100%\">\n            <source src=\"{video_url}\" type=\"video\/mp4\">\n            \u60a8\u7684\u6d4f\u89c8\u5668\u4e0d\u652f\u6301\u89c6\u9891\u6807\u7b7e\u3002\n        <\/video>\n        \n        <h3>\u4e0b\u8f7d\u94fe\u63a5<\/h3>\n        <ul>\n            {download_links}\n        <\/ul>\n        \"\"\"<\/span>\n        \n        download_links =<\/span> \"\"<\/span>\n        for<\/span> quality,<\/span> url in<\/span> video_data[<\/span>'downloads'<\/span>]<\/span>.<\/span>items(<\/span>)<\/span>:<\/span>\n            download_links +=<\/span> f'<li><a href=\"<\/span>{<\/span>url}<\/span><\/span>\"><\/span>{<\/span>quality}<\/span><\/span>\u7248\u672c<\/a><\/li>'<\/span><\/span>\n        \n        content =<\/span> template.<\/span>format<\/span>(<\/span>\n            title=<\/span>video_data[<\/span>'title'<\/span>]<\/span>,<\/span>\n            type<\/span>=<\/span>video_data.<\/span>get(<\/span>'type'<\/span>,<\/span> '\u7535\u5f71'<\/span>)<\/span>,<\/span>\n            region=<\/span>video_data.<\/span>get(<\/span>'region'<\/span>,<\/span> '\u672a\u77e5'<\/span>)<\/span>,<\/span>\n            year=<\/span>video_data.<\/span>get(<\/span>'year'<\/span>,<\/span> '\u672a\u77e5'<\/span>)<\/span>,<\/span>\n            description=<\/span>video_data.<\/span>get(<\/span>'description'<\/span>,<\/span> '\u6682\u65e0\u7b80\u4ecb'<\/span>)<\/span>,<\/span>\n            video_url=<\/span>video_data[<\/span>'url'<\/span>]<\/span>,<\/span>\n            download_links=<\/span>download_links\n        )<\/span>\n        \n        return<\/span> content<\/pre>\n<\/div>\n
              \u79fb\u52a8\u7aef\u91c7\u96c6\u7ba1\u7406\u65b9\u6848<\/h2>\n
              \u624b\u673aApp\u63a7\u5236\u7aef<\/h3>\n
              Flutter\u8de8\u5e73\u53f0\u5e94\u7528<\/h4>\n
              \n
              \n
              \n
              \n
              dart<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
              \/\/ \u91c7\u96c6\u4efb\u52a1\u7ba1\u7406\u9875\u9762<\/span>\nclass<\/span> CollectionTasksPage<\/span> extends<\/span> StatefulWidget<\/span> {<\/span>\n  @override<\/span>\n  _CollectionTasksPageState createState<\/span>(<\/span>)<\/span> =<\/span>><\/span> _CollectionTasksPageState<\/span>(<\/span>)<\/span>;<\/span>\n}<\/span>\n\nclass<\/span> _CollectionTasksPageState extends<\/span> State<\/span><<\/span>CollectionTasksPage<\/span>><\/span><\/span> {<\/span>\n  List<\/span><<\/span>Task<\/span>><\/span><\/span> tasks =<\/span> [<\/span>]<\/span>;<\/span>\n  \n  @override<\/span>\n  Widget<\/span> build<\/span>(<\/span>BuildContext<\/span> context)<\/span> {<\/span>\n    return<\/span> Scaffold<\/span>(<\/span>\n      appBar:<\/span> AppBar<\/span>(<\/span>\n        title:<\/span> Text<\/span>(<\/span>'\u91c7\u96c6\u4efb\u52a1\u7ba1\u7406'<\/span><\/span>)<\/span>,<\/span>\n        actions:<\/span> [<\/span>\n          IconButton<\/span>(<\/span>\n            icon:<\/span> Icon<\/span>(<\/span>Icons<\/span>.<\/span>add)<\/span>,<\/span>\n            onPressed:<\/span> _createNewTask,<\/span>\n          )<\/span>,<\/span>\n        ]<\/span>,<\/span>\n      )<\/span>,<\/span>\n      body:<\/span> ListView<\/span>.<\/span>builder<\/span>(<\/span>\n        itemCount:<\/span> tasks.<\/span>length,<\/span>\n        itemBuilder:<\/span> (<\/span>context,<\/span> index)<\/span> {<\/span>\n          return<\/span> TaskCard<\/span>(<\/span>\n            task:<\/span> tasks[<\/span>index]<\/span>,<\/span>\n            onStart:<\/span> (<\/span>)<\/span> =<\/span>><\/span> _startTask<\/span>(<\/span>tasks[<\/span>index]<\/span>.<\/span>id)<\/span>,<\/span>\n            onStop:<\/span> (<\/span>)<\/span> =<\/span>><\/span> _stopTask<\/span>(<\/span>tasks[<\/span>index]<\/span>.<\/span>id)<\/span>,<\/span>\n            onDelete:<\/span> (<\/span>)<\/span> =<\/span>><\/span> _deleteTask<\/span>(<\/span>tasks[<\/span>index]<\/span>.<\/span>id)<\/span>,<\/span>\n          )<\/span>;<\/span>\n        }<\/span>,<\/span>\n      )<\/span>,<\/span>\n      floatingActionButton:<\/span> FloatingActionButton<\/span>(<\/span>\n        child:<\/span> Icon<\/span>(<\/span>Icons<\/span>.<\/span>play_arrow)<\/span>,<\/span>\n        onPressed:<\/span> _startAllTasks,<\/span>\n      )<\/span>,<\/span>\n    )<\/span>;<\/span>\n  }<\/span>\n  \n  void<\/span> _createNewTask<\/span>(<\/span>)<\/span> async<\/span> {<\/span>\n    final<\/span> result =<\/span> await<\/span> Navigator<\/span>.<\/span>push<\/span>(<\/span>\n      context,<\/span>\n      MaterialPageRoute<\/span>(<\/span>builder:<\/span> (<\/span>context)<\/span> =<\/span>><\/span> TaskCreatePage<\/span>(<\/span>)<\/span>)<\/span>,<\/span>\n    )<\/span>;<\/span>\n    \n    if<\/span> (<\/span>result !=<\/span> null<\/span>)<\/span> {<\/span>\n      setState<\/span>(<\/span>(<\/span>)<\/span> {<\/span>\n        tasks.<\/span>add<\/span>(<\/span>result)<\/span>;<\/span>\n      }<\/span>)<\/span>;<\/span>\n    }<\/span>\n  }<\/span>\n  \n  Future<\/span><<\/span>void<\/span>><\/span><\/span> _startTask<\/span>(<\/span>String<\/span> taskId)<\/span> async<\/span> {<\/span>\n    \/\/ \u8c03\u7528API\u542f\u52a8\u4efb\u52a1<\/span>\n    await<\/span> ApiService<\/span>.<\/span>startTask<\/span>(<\/span>taskId)<\/span>;<\/span>\n    setState<\/span>(<\/span>(<\/span>)<\/span> {<\/span>\n      tasks.<\/span>firstWhere<\/span>(<\/span>(<\/span>t)<\/span> =<\/span>><\/span> t.<\/span>id ==<\/span> taskId)<\/span>.<\/span>status =<\/span> 'running'<\/span><\/span>;<\/span>\n    }<\/span>)<\/span>;<\/span>\n  }<\/span>\n}<\/span><\/pre>\n<\/div>\n
              \u5fae\u4fe1\u5c0f\u7a0b\u5e8f\u76d1\u63a7\u7aef<\/h3>\n
              \n
              \n
              \n
              \n
              javascript<\/span><\/div>\n
              \n
              \n
              <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
              \/\/ \u5c0f\u7a0b\u5e8f\u91c7\u96c6\u76d1\u63a7\u9875\u9762<\/span>\nPage<\/span>(<\/span>{<\/span>\n  data<\/span>:<\/span> {<\/span>\n    tasks<\/span>:<\/span> [<\/span>]<\/span>,<\/span>\n    stats<\/span>:<\/span> {<\/span>}<\/span>,<\/span>\n    realTimeData<\/span>:<\/span> {<\/span>}<\/span>\n  }<\/span>,<\/span>\n  \n  onLoad<\/span>(<\/span>)<\/span> {<\/span>\n    this<\/span>.<\/span>loadTasks<\/span>(<\/span>)<\/span>;<\/span>\n    this<\/span>.<\/span>loadStats<\/span>(<\/span>)<\/span>;<\/span>\n    this<\/span>.<\/span>startRealTimeMonitor<\/span>(<\/span>)<\/span>;<\/span>\n  }<\/span>,<\/span>\n  \n  loadTasks<\/span>(<\/span>)<\/span> {<\/span>\n    wx.<\/span>request<\/span>(<\/span>{<\/span>\n      url<\/span>:<\/span> 'https:\/\/api.yourserver.com\/tasks'<\/span>,<\/span>\n      success<\/span>:<\/span> (<\/span>res<\/span>)<\/span> =><\/span> {<\/span>\n        this<\/span>.<\/span>setData<\/span>(<\/span>{<\/span> tasks<\/span>:<\/span> res.<\/span>data }<\/span>)<\/span>;<\/span>\n      }<\/span>\n    }<\/span>)<\/span>;<\/span>\n  }<\/span>,<\/span>\n  \n  loadStats<\/span>(<\/span>)<\/span> {<\/span>\n    wx.<\/span>request<\/span>(<\/span>{<\/span>\n      url<\/span>:<\/span> 'https:\/\/api.yourserver.com\/stats'<\/span>,<\/span>\n      success<\/span>:<\/span> (<\/span>res<\/span>)<\/span> =><\/span> {<\/span>\n        this<\/span>.<\/span>setData<\/span>(<\/span>{<\/span> stats<\/span>:<\/span> res.<\/span>data }<\/span>)<\/span>;<\/span>\n      }<\/span>\n    }<\/span>)<\/span>;<\/span>\n  }<\/span>,<\/span>\n  \n  startRealTimeMonitor<\/span>(<\/span>)<\/span> {<\/span>\n    \/\/ WebSocket\u5b9e\u65f6\u76d1\u63a7<\/span>\n    const<\/span> socket =<\/span> wx.<\/span>connectSocket<\/span>(<\/span>{<\/span>\n      url<\/span>:<\/span> 'wss:\/\/api.yourserver.com\/ws\/monitor'<\/span>\n    }<\/span>)<\/span>;<\/span>\n    \n    socket.<\/span>onMessage<\/span>(<\/span>(<\/span>res<\/span>)<\/span> =><\/span> {<\/span>\n      const<\/span> data =<\/span> JSON<\/span>.<\/span>parse<\/span>(<\/span>res.<\/span>data)<\/span>;<\/span>\n      this<\/span>.<\/span>setData<\/span>(<\/span>{<\/span> realTimeData<\/span>:<\/span> data }<\/span>)<\/span>;<\/span>\n    }<\/span>)<\/span>;<\/span>\n  }<\/span>,<\/span>\n  \n  createTask<\/span>(<\/span>)<\/span> {<\/span>\n    wx.<\/span>navigateTo<\/span>(<\/span>{<\/span>\n      url<\/span>:<\/span> '\/pages\/create-task\/create-task'<\/span>\n    }<\/span>)<\/span>;<\/span>\n  }<\/span>,<\/span>\n  \n  controlTask<\/span>(<\/span>e<\/span>)<\/span> {<\/span>\n    const<\/span> {<\/span> id,<\/span> action }<\/span> =<\/span> e.<\/span>currentTarget.<\/span>dataset;<\/span>\n    \n    wx.<\/span>request<\/span>(<\/span>{<\/span>\n      url<\/span>:<\/span> `<\/span>https:\/\/api.yourserver.com\/tasks\/<\/span>${<\/span>id}<\/span><\/span>\/<\/span>${<\/span>action}<\/span><\/span>`<\/span><\/span>,<\/span>\n      method<\/span>:<\/span> 'POST'<\/span>,<\/span>\n      success<\/span>:<\/span> (<\/span>)<\/span> =><\/span> {<\/span>\n        wx.<\/span>showToast<\/span>(<\/span>{<\/span> title<\/span>:<\/span> '\u64cd\u4f5c\u6210\u529f'<\/span> }<\/span>)<\/span>;<\/span>\n        this<\/span>.<\/span>loadTasks<\/span>(<\/span>)<\/span>;<\/span>\n      }<\/span>\n    }<\/span>)<\/span>;<\/span>\n  }<\/span>\n}<\/span>)<\/span>;<\/span><\/pre>\n<\/div>\n
              \u7ef4\u62a4\u4e0e\u4f18\u5316\u5efa\u8bae<\/h2>\n
              \u65e5\u5e38\u7ef4\u62a4\u6e05\u5355<\/h3>\n
              \u6bcf\u65e5\u68c0\u67e5\u9879\u76ee<\/h4>\n
                \n
              1. \n
                \u4efb\u52a1\u72b6\u6001<\/strong>\uff1a\u6240\u6709\u91c7\u96c6\u4efb\u52a1\u662f\u5426\u6b63\u5e38<\/p>\n<\/li>\n
              2. \n
                \u6210\u529f\u7387\u7edf\u8ba1<\/strong>\uff1a\u5404\u7ad9\u70b9\u91c7\u96c6\u6210\u529f\u7387<\/p>\n<\/li>\n
              3. \n
                \u8d44\u6e90\u5360\u7528<\/strong>\uff1a\u670d\u52a1\u5668CPU\u3001\u5185\u5b58\u3001\u78c1\u76d8\u4f7f\u7528<\/p>\n<\/li>\n
              4. \n
                \u9519\u8bef\u65e5\u5fd7<\/strong>\uff1a\u67e5\u770b\u5e76\u5904\u7406\u9519\u8bef\u8bb0\u5f55<\/p>\n<\/li>\n
              5. \n
                \u66f4\u65b0\u68c0\u67e5<\/strong>\uff1a\u5de5\u5177\u548c\u4f9d\u8d56\u5e93\u66f4\u65b0<\/p>\n<\/li>\n<\/ol>\n
                \u6bcf\u5468\u7ef4\u62a4\u4efb\u52a1<\/h4>\n
                  \n
                1. \n
                  \u6027\u80fd\u5206\u6790<\/strong>\uff1a\u5206\u6790\u91c7\u96c6\u6548\u7387\uff0c\u4f18\u5316\u914d\u7f6e<\/p>\n<\/li>\n
                2. \n
                  \u89c4\u5219\u66f4\u65b0<\/strong>\uff1a\u66f4\u65b0\u7f51\u7ad9\u91c7\u96c6\u89c4\u5219<\/p>\n<\/li>\n
                3. \n
                  \u6570\u636e\u6e05\u7406<\/strong>\uff1a\u6e05\u7406\u65e7\u65e5\u5fd7\u548c\u4e34\u65f6\u6587\u4ef6<\/p>\n<\/li>\n
                4. \n
                  \u5907\u4efd\u68c0\u67e5<\/strong>\uff1a\u9a8c\u8bc1\u5907\u4efd\u5b8c\u6574\u6027<\/p>\n<\/li>\n
                5. \n
                  \u5b89\u5168\u626b\u63cf<\/strong>\uff1a\u68c0\u67e5\u7cfb\u7edf\u5b89\u5168\u6f0f\u6d1e<\/p>\n<\/li>\n<\/ol>\n
                  \u6027\u80fd\u4f18\u5316\u6307\u5357<\/h3>\n
                  \u6570\u636e\u5e93\u4f18\u5316<\/h4>\n
                  \n
                  \n
                  \n
                  \n
                  sql<\/span><\/div>\n
                  \n
                  \n
                  <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
                  -- \u521b\u5efa\u4f18\u5316\u7d22\u5f15<\/span>\nCREATE<\/span> INDEX<\/span> idx_videos_collected ON<\/span> videos(<\/span>collected_at)<\/span>;<\/span>\nCREATE<\/span> INDEX<\/span> idx_videos_quality ON<\/span> videos(<\/span>quality)<\/span>;<\/span>\nCREATE<\/span> INDEX<\/span> idx_tasks_status ON<\/span> tasks(<\/span>status<\/span>)<\/span>;<\/span>\n\n-- \u5206\u533a\u8868\u63d0\u9ad8\u67e5\u8be2\u6548\u7387<\/span>\nCREATE<\/span> TABLE<\/span> videos_2026 PARTITION<\/span> OF<\/span> videos\nFOR<\/span> VALUES<\/span> FROM<\/span> (<\/span>'2026-01-01'<\/span>)<\/span> TO<\/span> (<\/span>'2027-01-01'<\/span>)<\/span>;<\/span>\n\n-- \u5b9a\u671f\u7ef4\u62a4<\/span>\nVACUUM ANALYZE<\/span> videos;<\/span>\nREINDEX TABLE<\/span> videos;<\/span><\/pre>\n<\/div>\n
                  \u7f51\u7edc\u4f18\u5316<\/h4>\n
                  \n
                  \n
                  \n
                  \n
                  python<\/span><\/div>\n
                  \n
                  \n
                  <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
                  # \u667a\u80fd\u4ee3\u7406\u8f6e\u6362<\/span>\nclass<\/span> SmartProxyManager<\/span>:<\/span>\n    def<\/span> __init__<\/span>(<\/span>self)<\/span>:<\/span>\n        self.<\/span>proxies =<\/span> self.<\/span>load_proxies(<\/span>)<\/span>\n        self.<\/span>stats =<\/span> {<\/span>}<\/span>\n    \n    def<\/span> get_proxy<\/span>(<\/span>self,<\/span> site)<\/span>:<\/span>\n        \"\"\"\u83b7\u53d6\u6700\u4f18\u4ee3\u7406\"\"\"<\/span>\n        if<\/span> site not<\/span> in<\/span> self.<\/span>stats:<\/span>\n            return<\/span> random.<\/span>choice(<\/span>self.<\/span>proxies)<\/span>\n        \n        # \u9009\u62e9\u8be5\u7ad9\u70b9\u6210\u529f\u7387\u6700\u9ad8\u7684\u4ee3\u7406<\/span>\n        site_stats =<\/span> self.<\/span>stats[<\/span>site]<\/span>\n        best_proxy =<\/span> max<\/span>(<\/span>site_stats.<\/span>items(<\/span>)<\/span>,<\/span> \n                        key=<\/span>lambda<\/span> x:<\/span> x[<\/span>1<\/span>]<\/span>[<\/span>'success_rate'<\/span>]<\/span>)<\/span>[<\/span>0<\/span>]<\/span>\n        \n        return<\/span> best_proxy\n    \n    def<\/span> update_stats<\/span>(<\/span>self,<\/span> site,<\/span> proxy,<\/span> success,<\/span> response_time)<\/span>:<\/span>\n        \"\"\"\u66f4\u65b0\u4ee3\u7406\u7edf\u8ba1\"\"\"<\/span>\n        if<\/span> site not<\/span> in<\/span> self.<\/span>stats:<\/span>\n            self.<\/span>stats[<\/span>site]<\/span> =<\/span> {<\/span>}<\/span>\n        \n        if<\/span> proxy not<\/span> in<\/span> self.<\/span>stats[<\/span>site]<\/span>:<\/span>\n            self.<\/span>stats[<\/span>site]<\/span>[<\/span>proxy]<\/span> =<\/span> {<\/span>\n                'requests'<\/span>:<\/span> 0<\/span>,<\/span>\n                'success'<\/span>:<\/span> 0<\/span>,<\/span>\n                'total_time'<\/span>:<\/span> 0<\/span>\n            }<\/span>\n        \n        stats =<\/span> self.<\/span>stats[<\/span>site]<\/span>[<\/span>proxy]<\/span>\n        stats[<\/span>'requests'<\/span>]<\/span> +=<\/span> 1<\/span>\n        if<\/span> success:<\/span>\n            stats[<\/span>'success'<\/span>]<\/span> +=<\/span> 1<\/span>\n        stats[<\/span>'total_time'<\/span>]<\/span> +=<\/span> response_time\n        stats[<\/span>'success_rate'<\/span>]<\/span> =<\/span> stats[<\/span>'success'<\/span>]<\/span> \/<\/span> stats[<\/span>'requests'<\/span>]<\/span>\n        stats[<\/span>'avg_time'<\/span>]<\/span> =<\/span> stats[<\/span>'total_time'<\/span>]<\/span> \/<\/span> stats[<\/span>'requests'<\/span>]<\/span><\/pre>\n<\/div>\n
                  \u98ce\u9669\u4e0e\u5e94\u5bf9\u7b56\u7565<\/h2>\n
                  \u6cd5\u5f8b\u98ce\u9669\u8bc4\u4f30<\/h3>\n
                  \u5408\u89c4\u68c0\u67e5\u6e05\u5355<\/h4>\n