{"version":3,"sources":["jsdelivr-header.js","/npm/mm_mysql@2.3.1/index.js"],"names":[],"mappings":"AAAA;AACA;AACA;AACA;AACA;AACA;AACA,ACNA,MAAM,MAAQ,QAAQ,mBAChB,KAAE,MAAS,QAAQ,cACnB,GAAE,IAAO,QAAQ,QAQvB,MAAM,cAAc,KAIlB,cAAgB,CACd,KAAM,YACN,KAAM,KACN,KAAM,OACN,SAAU,YACV,SAAU,GACV,QAAS,UACT,SAAU,SACV,gBAAiB,KAGjB,iBAAkB,IAClB,gBAAiB,IACjB,sBAAsB,EACtB,aAAc,IACd,SAAU,GACV,cAAe,IAGf,qBAAsB,GACtB,2BAA4B,IAC5B,0BAA0B,GAO5B,WAAA,CAAY,EAAS,CAAC,GACpB,MAAM,IAAK,MAAM,UAAW,IAC5B,KAAK,MAAQ,KAEb,KAAK,WAAY,EAGjB,KAAK,MAAQ,KAEb,KAAK,IAAM,GAGX,KAAK,gBAAkB,IAAI,IAC3B,KAAK,iBAAmB,KAAK,OAAO,sBAAwB,IAC5D,KAAK,YAAc,EACnB,KAAK,cAAgB,EAGrB,KAAK,mBACP,EAkOF,eAAe,sBAAsB,EAAM,GACzC,GAAK,EAEL,IACM,GAAwC,mBAAjB,EAAK,eACxB,EAAK,SAEf,CAAE,MAAO,GACP,EAAE,IAAI,MAAM,SAAU,EACxB,CACF,CA8eA,SAAS,aAAa,GAKpB,IAAI,EAJC,EAAE,KAAK,MAAM,OAAO,KACvB,EAAE,KAAK,MAAM,OAAO,GAAO,QAAQ,WAIrC,MAAM,EAAc,EAAE,KAAK,MAAM,OAAO,GAAK,MAAK,IACzC,IAAI,SAAQ,IACjB,EAAU,CAAO,MAKrB,OADA,EAAE,KAAK,MAAM,OAAO,GAAO,EACpB,EAAY,MAAK,IAAM,GAChC,CAQA,SAAS,WAAW,EAAO,GAMzB,OALK,IACH,EAAQ,OAIN,EAAE,KAAK,MAAM,IAKZ,EAAE,KAAK,MAAM,KAChB,EAAE,KAAK,MAAM,GAAS,IAAI,MAAM,IALzB,EAAE,KAAK,MAAM,EASxB,CAzvBA,MAAM,UAAU,kBAAoB,WAC9B,KAAK,mBACP,cAAc,KAAK,mBAGrB,KAAK,kBAAoB,aAAY,KACnC,KAAK,2BAA2B,GAC/B,IACL,EAMA,MAAM,UAAU,0BAA4B,WAC1C,MAAM,EAAM,KAAK,MACX,EAAU,KAAK,OAAO,4BAA8B,IAE1D,IAAK,MAAO,EAAK,KAAmB,KAAK,gBACnC,EAAM,EAAe,UAAY,IAE/B,EAAe,WAAuD,mBAAnC,EAAe,UAAU,OAC9D,EAAe,UAAU,QAAQ,OAAM,SAEzC,KAAK,gBAAgB,OAAO,GAGlC,EAQA,MAAM,UAAU,sBAAwB,SAAS,GAE/C,OAAO,EAAI,OAAO,QAAQ,OAAQ,KAAK,aACzC,EAQA,MAAM,UAAU,gBAAkB,SAAS,EAAK,GAC9C,GAAI,KAAK,gBAAgB,MAAQ,KAAK,iBAAkB,CAEtD,MAAM,EAAa,KAAK,uBACxB,GAAI,EAAY,CACd,MAAM,EAAmB,KAAK,gBAAgB,IAAI,GAC9C,EAAiB,WAAyD,mBAArC,EAAiB,UAAU,OAClE,EAAiB,UAAU,QAAQ,OAAM,SAE3C,KAAK,gBAAgB,OAAO,EAC9B,CACF,CAEA,KAAK,gBAAgB,IAAI,EAAK,CAC5B,UAAW,EACX,UAAW,KAAK,MAChB,UAAW,GAEf,EAOA,MAAM,UAAU,qBAAuB,WACrC,IAAI,EAAa,KACb,EAAc,KAAK,MAEvB,IAAK,MAAO,EAAK,KAAmB,KAAK,gBACnC,EAAe,UAAY,IAC7B,EAAc,EAAe,UAC7B,EAAa,GAIjB,OAAO,CACT,EAMA,MAAM,UAAU,kBAAoB,WAClC,MAAM,EAAQ,KAAK,YAAc,KAAK,cAChC,EAAW,EAAQ,EAAK,KAAK,YAAc,EAAS,IAAM,EAEhE,MAAO,CACL,kBAAmB,KAAK,gBAAgB,KACxC,WAAY,KAAK,YACjB,aAAc,KAAK,cACnB,eAAgB,EAAS,QAAQ,GAAK,IACtC,eAAgB,KAAK,iBAEzB,EAQA,MAAM,UAAU,gBAAkB,SAAU,GAAU,GAEpD,MAAM,EAAW,CACf,KAAQ,OACR,KAAQ,OACR,KAAQ,OACR,SAAY,WACZ,SAAY,WACZ,QAAW,UACX,SAAY,WACZ,gBAAmB,kBAIf,EAAW,CACf,iBAAoB,kBACpB,qBAAwB,qBACxB,aAAgB,cAChB,SAAY,WAGR,EAAS,CAAC,EAGhB,IAAK,MAAM,KAAO,OACS,IAArB,KAAK,OAAO,KACd,EAAO,EAAS,IAAQ,KAAK,OAAO,IAKxC,GAAI,EACF,IAAK,MAAM,KAAO,OACS,IAArB,KAAK,OAAO,KACd,EAAO,EAAS,IAAQ,KAAK,OAAO,SAOxC,IAAK,MAAM,KAAO,EACZ,EAAS,KAAQ,UACZ,EAAO,EAAS,IAK7B,OAAO,CACT,EAOE,MAAM,UAAU,KAAO,iBAErB,IAAK,KAAK,QAAiC,iBAAhB,KAAK,OAC9B,MAAM,IAAI,UAAU,yBAGtB,IAEE,MAAM,EAAe,KAAK,iBAAgB,GAC1C,KAAK,MAAQ,MAAM,WAAW,GAO9B,aAJmB,KAAK,MAAM,iBACzB,UAEL,KAAK,IAAI,OAAQ,eACV,CACT,CAAE,MAAO,GAEP,OADA,KAAK,IAAI,QAAS,aAAc,IACzB,CACT,CACF,EAMA,MAAM,UAAU,MAAQ,iBACtB,IAcE,OAZI,KAAK,cACD,KAAK,MAAM,MACjB,KAAK,MAAQ,MAIX,KAAK,iBAEP,KAAK,gBAAgB,QAGvB,KAAK,IAAI,OAAQ,cACV,CACT,CAAE,MAAO,GAEP,OADA,KAAK,IAAI,QAAS,UAAW,IACtB,CACT,CACF,EAyBA,MAAM,UAAU,QAAU,iBAEnB,KAAK,aACF,KAAK,OAGb,IAGE,aADmB,KAAK,MAAM,eAEhC,CAAE,MAAO,GAEP,MADA,KAAK,IAAI,QAAS,aAAc,GAC1B,CACR,CACF,EASF,MAAM,UAAU,IAAM,eAAgB,EAAK,EAAS,IAElD,GAAmB,iBAAR,GAAmC,KAAf,EAAI,OACjC,MAAM,IAAI,UAAU,gCAEtB,IAAK,MAAM,QAAQ,GACjB,MAAM,IAAI,UAAU,wBAGtB,KAAK,MAAQ,KACb,IAAI,EAAO,KACP,GAAe,EACf,GAAsB,EAE1B,IAME,GAJA,QAAa,KAAK,UAClB,EAAe,KAAK,YAGhB,KAAK,OAAO,0BAA4B,EAAO,OAAS,GAkDrD,CAEL,MAAO,SAAc,EAAK,MAAM,EAAK,GACrC,OAAO,CACT,CAtD+D,CAC7D,MAAM,EAAY,KAAK,sBAAsB,GAC7C,IAAI,EAAiB,KAAK,gBAAgB,IAAI,GAE9C,IAAI,IAAkB,EAAe,UAqC9B,CAEL,KAAK,gBACL,MAAM,QAAkB,EAAK,QAAQ,GACrC,KAAK,gBAAgB,EAAW,GAEhC,MAAO,SAAc,EAAU,QAAQ,GACvC,OAAO,CACT,CAtCE,GALA,KAAK,cACL,EAAe,UAAY,KAAK,MAChC,EAAe,aAGV,GAAQ,EAAK,aAAe,EAAK,QAAS,CAC7C,QAAa,KAAK,UAElB,KAAK,gBAAgB,OAAO,GAC5B,MAAM,QAAkB,EAAK,QAAQ,GACrC,KAAK,gBAAgB,EAAW,GAChC,MAAO,SAAc,EAAU,QAAQ,GACvC,OAAO,CACT,CAEA,IACE,MAAO,SAAc,EAAe,UAAU,QAAQ,GACtD,OAAO,CACT,CAAE,MAAO,GAEP,KAAK,IAAI,OAAQ,iBAAkB,GACnC,KAAK,gBAAgB,OAAO,KAGvB,GAAQ,EAAK,aAAe,EAAK,WACpC,QAAa,KAAK,WAIpB,MAAM,QAAkB,EAAK,QAAQ,GACrC,KAAK,gBAAgB,EAAW,GAEhC,MAAO,SAAc,EAAU,QAAQ,GACvC,OAAO,CACT,CAUJ,CAKF,CAAE,MAAO,GACP,KAAK,IAAM,EAAI,IACf,KAAK,MAAQ,CACX,KAAM,EAAI,MACV,QAAS,EAAI,YAGf,UACQ,sBAAsB,EAAM,EACpC,CAAE,MAAO,GACP,KAAK,IAAI,QAAS,SAAU,EAC9B,CAIA,MAHA,GAAsB,EAGhB,CACR,CAAE,QAEA,IAAK,EACH,UACQ,sBAAsB,EAAM,EACpC,CAAE,MAAO,GACP,KAAK,IAAI,QAAS,SAAU,EAC9B,CAEJ,CACA,MAAO,EACT,EASA,MAAM,UAAU,KAAO,eAAgB,EAAK,EAAS,IAEnD,GAAmB,iBAAR,GAAmC,KAAf,EAAI,OACjC,MAAM,IAAI,UAAU,gCAEtB,IAAK,MAAM,QAAQ,GACjB,MAAM,IAAI,UAAU,wBAEtB,KAAK,MAAQ,KACb,IAAI,EAAO,KACP,GAAe,EACf,GAAsB,EAE1B,IAME,GAJA,QAAa,KAAK,UAClB,EAAe,KAAK,YAGhB,KAAK,OAAO,0BAA4B,EAAO,OAAS,GAkDrD,CAEH,MAAO,SAAgB,EAAK,QAAQ,EAAK,GACzC,OAAO,EAAO,UAAY,EAAO,cAAgB,EAAO,aAAe,CACzE,CAtD6D,CAC7D,MAAM,EAAY,KAAK,sBAAsB,GAC7C,IAAI,EAAiB,KAAK,gBAAgB,IAAI,GAE9C,IAAI,IAAkB,EAAe,UAqC9B,CAEL,KAAK,gBACL,MAAM,QAAkB,EAAK,QAAQ,GACrC,KAAK,gBAAgB,EAAW,GAEhC,MAAO,SAAgB,EAAU,QAAQ,GACzC,OAAO,EAAO,UAAY,EAAO,cAAgB,EAAO,aAAe,CACzE,CAtCE,GALA,KAAK,cACL,EAAe,UAAY,KAAK,MAChC,EAAe,aAGV,GAAQ,EAAK,aAAe,EAAK,QAAS,CAC7C,QAAa,KAAK,UAElB,KAAK,gBAAgB,OAAO,GAC5B,MAAM,QAAkB,EAAK,QAAQ,GACrC,KAAK,gBAAgB,EAAW,GAChC,MAAO,SAAgB,EAAU,QAAQ,GACzC,OAAO,EAAO,UAAY,EAAO,cAAgB,EAAO,aAAe,CACzE,CAEA,IACE,MAAO,SAAgB,EAAe,UAAU,QAAQ,GACxD,OAAO,EAAO,UAAY,EAAO,cAAgB,EAAO,aAAe,CACzE,CAAE,MAAO,GAEP,KAAK,IAAI,OAAQ,iBAAkB,GACnC,KAAK,gBAAgB,OAAO,KAGvB,GAAQ,EAAK,aAAe,EAAK,WACpC,QAAa,KAAK,WAIpB,MAAM,QAAkB,EAAK,QAAQ,GACrC,KAAK,gBAAgB,EAAW,GAEhC,MAAO,SAAgB,EAAU,QAAQ,GACzC,OAAO,EAAO,UAAY,EAAO,cAAgB,EAAO,aAAe,CACzE,CAUJ,CAKF,CAAE,MAAO,GACP,KAAK,IAAI,QAAS,UAAW,GAC7B,KAAK,IAAM,EAAM,IACjB,KAAK,MAAQ,CACX,KAAM,EAAM,MACZ,QAAS,EAAM,YAGjB,UACQ,sBAAsB,EAAM,EACpC,CAAE,MAAO,GACP,KAAK,IAAI,QAAS,SAAU,EAC9B,CAIA,MAHA,GAAsB,EAGhB,CACR,CAAE,QAEA,IAAK,EACH,UACQ,sBAAsB,EAAM,EACpC,CAAE,MAAO,GACP,KAAK,IAAI,QAAS,SAAU,EAC9B,CAEJ,CACA,OAAO,CACT,EAMA,MAAM,UAAU,iBAAmB,iBACjC,IAAI,EAAO,KACP,GAAwB,EACxB,GAA0B,EAE9B,IAIE,OAHA,QAAa,KAAK,gBACZ,EAAK,mBAEJ,CACL,WAAY,EACZ,OAAQ,UACN,GAAI,GAAyB,EAC3B,KAAK,IAAI,OAAQ,oBADnB,OAIM,EAAK,SACX,GAAwB,EACxB,UACQ,sBAAsB,EAAM,KAAK,SACzC,CAAE,MAAO,GACP,KAAK,IAAI,QAAS,YAAa,EACjC,CAPA,CAOA,EAEF,SAAU,UACR,GAAI,GAAyB,EAC3B,KAAK,IAAI,OAAQ,oBADnB,OAIM,EAAK,WACX,GAA0B,EAC1B,UACQ,sBAAsB,EAAM,KAAK,SACzC,CAAE,MAAO,GACP,KAAK,IAAI,QAAS,YAAa,EACjC,CAPA,CAOA,EAEF,UAAW,IAAM,GAAyB,EAE9C,CAAE,MAAO,GAEP,UACQ,sBAAsB,EAAM,KAAK,SACzC,CAAE,MAAO,GACP,KAAK,IAAI,QAAS,SAAU,EAC9B,CAEA,MADA,KAAK,IAAI,QAAS,SAAU,GACtB,CACR,CACF,EAQA,MAAM,UAAU,YAAc,eAAgB,GAE5C,GAAwB,mBAAb,EACT,MAAM,IAAI,UAAU,6BAGtB,IAAI,EAAc,KACd,GAAuB,EAE3B,IACE,QAAoB,KAAK,mBACzB,MAAM,QAAe,EAAS,GAQ9B,OALI,EAAY,YAAc,EAAY,mBAClC,EAAY,SAGpB,GAAuB,EAChB,CACT,CAAE,MAAO,GAWP,MAVI,IAAgB,GAEd,EAAY,YAAc,EAAY,mBAClC,EAAY,WAAW,OAAM,IACjC,KAAK,IAAI,QAAS,SAAU,EAAI,IAKtC,KAAK,IAAI,QAAS,SAAU,GACtB,CACR,CACF,EAUA,MAAM,UAAU,KAAO,eAAgB,EAAO,EAAY,CAAC,EAAG,EAAU,CAAC,GAEvE,GAAqB,iBAAV,GAAuC,KAAjB,EAAM,OACrC,MAAM,IAAI,UAAU,kCAEtB,GAAI,GAAkC,iBAAd,EACtB,MAAM,IAAI,UAAU,4BAEtB,GAAI,GAA8B,iBAAZ,EACpB,MAAM,IAAI,UAAU,0BAGtB,IACE,IAAI,EAAM,iBAAiB,IAC3B,MAAM,EAAS,GAGf,GAAI,OAAO,KAAK,GAAW,OAAS,EAAG,CACrC,MAAM,EAAe,GACrB,IAAK,MAAO,EAAO,KAAU,OAAO,QAAQ,GAC1C,EAAa,KAAK,GAAG,SACrB,EAAO,KAAK,GAEd,GAAO,UAAU,EAAa,KAAK,UACrC,CAiBA,OAdI,EAAQ,UACV,GAAO,aAAa,EAAQ,WAI1B,EAAQ,QACV,GAAO,UAAU,EAAQ,SAGvB,EAAQ,SACV,GAAO,WAAW,EAAQ,gBAIf,KAAK,IAAI,EAAK,EAC7B,CAAE,MAAO,GAEP,MADA,KAAK,IAAI,QAAS,OAAQ,GACpB,CACR,CACF,EAMA,MAAM,UAAU,aAAe,WAC7B,OAAK,KAAK,MAOH,CACL,OAAQ,WAPD,CACL,OAAQ,kBACR,QAAS,UAOf,EAMA,MAAM,UAAU,YAAc,iBAC5B,IACE,IAAK,KAAK,QAAU,KAAK,YACvB,MAAO,CACL,OAAQ,QACR,QAAS,aAKb,MAAM,QAAe,KAAK,IAAI,4BAE9B,OAAI,GAAU,EAAO,OAAS,GAAgC,IAA3B,EAAO,GAAG,aACpC,CACL,OAAQ,UACR,QAAS,aACN,KAAK,gBAGH,CACL,OAAQ,QACR,QAAS,WAGf,CAAE,MAAO,GAEP,OADA,KAAK,IAAI,QAAS,SAAU,GACrB,CACL,OAAQ,QACR,QAAS,WAAW,EAAM,UAE9B,CACF,EAMA,MAAM,UAAU,GAAK,WACnB,OAAO,IAAI,GAAG,KAChB,EAMA,MAAM,UAAU,KAAO,uBACf,KAAK,MACb,EAKA,QAAQ,MAAQ,MAKX,EAAE,OACL,EAAE,KAAO,CAAC,GAEP,EAAE,KAAK,QACV,EAAE,KAAK,MAAQ,CAAC,GAMb,EAAE,KAAK,MAAM,SAChB,EAAE,KAAK,MAAM,OAAS,CAAC,GAmDzB,QAAQ,WAAa","file":"/npm/mm_mysql@2.3.1/index.js","sourceRoot":"","sourcesContent":["/**\n * Minified by jsDelivr using Terser v5.39.0.\n * Original file: /npm/mm_mysql@2.3.1/index.js\n *\n * Do NOT use SRI with dynamically generated files! More information: https://www.jsdelivr.com/using-sri-with-dynamic-files\n */\n","const mysql = require('mysql2/promise');\r\nconst { Base } = require('mm_expand');\r\nconst { DB } = require('./db');\r\n\r\n/**\r\n * 优化版MySQL数据库操作类\r\n * 保持必要功能，简化过度封装，直接使用mysql2模块\r\n * @class Mysql\r\n * @augments Base\r\n */\r\nclass Mysql extends Base {\r\n  /**\r\n   * 默认配置（优化版，统一使用连接池）\r\n   */\r\n  static config = {\r\n    host: '127.0.0.1',\r\n    port: 3306,\r\n    user: 'root',\r\n    password: 'Asd159357',\r\n    database: '',\r\n    charset: 'utf8mb4',\r\n    timezone: '+08:00',\r\n    connect_timeout: 15000,\r\n    \r\n    // 连接池优化配置（针对高并发写入场景）\r\n    connection_limit: 100,           // 减少连接数，避免资源竞争\r\n    acquire_timeout: 30000,          // 延长获取连接超时时间\r\n    wait_for_connections: true,      // 保持连接等待机制\r\n    idle_timeout: 300000,            // 延长空闲连接超时时间(5分钟)\r\n    max_idle: 30,                    // 减少最大空闲连接数\r\n    queue_timeout: 60000,            // 队列超时时间\r\n    \r\n    // 预处理语句缓存优化配置\r\n    statement_cache_size: 50,        // 减少缓存大小，避免内存泄漏\r\n    max_prepared_statement_age: 300000, // 延长过期时间(5分钟)\r\n    enable_statement_pooling: true   // 启用预处理语句缓存\r\n  };\r\n\r\n  /**\r\n   * 构造函数（统一使用连接池）\r\n   * @param {object} config - 配置对象\r\n   */\r\n  constructor(config = {}) {\r\n    super({ ...Mysql.config, ...config});\r\n    this._pool = null;\r\n    // 移除单连接支持，统一使用连接池\r\n    this._use_pool = true; // 强制使用连接池模式\r\n    \r\n    // 错误信息\r\n    this.error = null;\r\n    // 最近执行的SQL语句\r\n    this.sql = '';\r\n    \r\n    // 预处理语句缓存\r\n    this._prepared_stmts = new Map();\r\n    this._stmt_cache_size = this.config.statement_cache_size || 100;\r\n    this._cache_hits = 0;\r\n    this._cache_misses = 0;\r\n    \r\n    // 启动定期清理任务\r\n    this._startCleanupTask();\r\n  }\r\n}\r\n\r\n/**\r\n * 启动预处理语句清理任务\r\n * @private\r\n */\r\nMysql.prototype._startCleanupTask = function() {\r\n  if (this._cleanup_interval) {\r\n    clearInterval(this._cleanup_interval);\r\n  }\r\n  \r\n  this._cleanup_interval = setInterval(() => {\r\n    this._cleanupExpiredStatements();\r\n  }, 60000); // 每分钟清理一次\r\n};\r\n\r\n/**\r\n * 清理过期预处理语句\r\n * @private\r\n */\r\nMysql.prototype._cleanupExpiredStatements = function() {\r\n  const now = Date.now();\r\n  const max_age = this.config.max_prepared_statement_age || 300000;\r\n  \r\n  for (const [key, statement_info] of this._prepared_stmts) {\r\n    if (now - statement_info.last_used > max_age) {\r\n      // 异步关闭语句，不阻塞主线程\r\n      if (statement_info.statement && typeof statement_info.statement.close === 'function') {\r\n        statement_info.statement.close().catch(() => {});\r\n      }\r\n      this._prepared_stmts.delete(key);\r\n    }\r\n  }\r\n};\r\n\r\n/**\r\n * 生成预处理语句缓存键\r\n * @private\r\n * @param {string} sql - SQL语句\r\n * @returns {string} 缓存键\r\n */\r\nMysql.prototype._getStatementCacheKey = function(sql) {\r\n  // 简化SQL语句，移除多余空格和换行，提高缓存命中率\r\n  return sql.trim().replace(/\\s+/g, ' ').toLowerCase();\r\n};\r\n\r\n/**\r\n * 缓存预处理语句\r\n * @private\r\n * @param {string} key - 缓存键\r\n * @param {object} statement - 预处理语句对象\r\n */\r\nMysql.prototype._cacheStatement = function(key, statement) {\r\n  if (this._prepared_stmts.size >= this._stmt_cache_size) {\r\n    // 移除最久未使用的语句\r\n    const oldest_key = this._findOldestStatement();\r\n    if (oldest_key) {\r\n      const oldest_statement = this._prepared_stmts.get(oldest_key);\r\n      if (oldest_statement.statement && typeof oldest_statement.statement.close === 'function') {\r\n        oldest_statement.statement.close().catch(() => {});\r\n      }\r\n      this._prepared_stmts.delete(oldest_key);\r\n    }\r\n  }\r\n  \r\n  this._prepared_stmts.set(key, {\r\n    statement: statement,\r\n    last_used: Date.now(),\r\n    use_count: 0\r\n  });\r\n};\r\n\r\n/**\r\n * 查找最久未使用的预处理语句\r\n * @private\r\n * @returns {string} 缓存键\r\n */\r\nMysql.prototype._findOldestStatement = function() {\r\n  let oldest_key = null;\r\n  let oldest_time = Date.now();\r\n  \r\n  for (const [key, statement_info] of this._prepared_stmts) {\r\n    if (statement_info.last_used < oldest_time) {\r\n      oldest_time = statement_info.last_used;\r\n      oldest_key = key;\r\n    }\r\n  }\r\n  \r\n  return oldest_key;\r\n};\r\n\r\n/**\r\n * 获取预处理语句缓存统计信息\r\n * @returns {object} 统计信息\r\n */\r\nMysql.prototype.getStatementStats = function() {\r\n  const total = this._cache_hits + this._cache_misses;\r\n  const hit_rate = total > 0 ? (this._cache_hits / total) * 100 : 0;\r\n  \r\n  return {\r\n    cached_statements: this._prepared_stmts.size,\r\n    cache_hits: this._cache_hits,\r\n    cache_misses: this._cache_misses,\r\n    cache_hit_rate: hit_rate.toFixed(2) + '%',\r\n    max_cache_size: this._stmt_cache_size\r\n  };\r\n};\r\n\r\n/**\r\n * 获取MySQL2支持的配置参数\r\n * 根据连接类型（连接池或单连接）过滤参数，避免警告\r\n * @param {boolean} is_pool - 是否为连接池配置\r\n * @returns {object} 过滤后的配置对象\r\n */\r\nMysql.prototype._getValidConfig = function (is_pool = false) {\r\n  // 基础连接参数（适用于所有连接类型）\r\n  const base_map = {\r\n    'host': 'host',\r\n    'port': 'port',\r\n    'user': 'user',\r\n    'password': 'password',\r\n    'database': 'database',\r\n    'charset': 'charset',\r\n    'timezone': 'timezone',\r\n    'connect_timeout': 'connectTimeout'\r\n  };\r\n\r\n  // 连接池专用参数\r\n  const pool_map = {\r\n    'connection_limit': 'connectionLimit',\r\n    'wait_for_connections': 'waitForConnections',\r\n    'idle_timeout': 'idleTimeout',\r\n    'max_idle': 'maxIdle'\r\n  };\r\n\r\n  const config = {};\r\n\r\n  // 添加基础参数\r\n  for (const key in base_map) {\r\n    if (this.config[key] !== undefined) {\r\n      config[base_map[key]] = this.config[key];\r\n    }\r\n  }\r\n\r\n  // 如果是连接池，添加连接池专用参数\r\n  if (is_pool) {\r\n    for (const key in pool_map) {\r\n      if (this.config[key] !== undefined) {\r\n        config[pool_map[key]] = this.config[key];\r\n      }\r\n    }\r\n  }\r\n  // 如果是单连接，确保不包含任何连接池专用参数\r\n  else {\r\n    // 移除所有连接池专用参数，避免mysql2内部警告\r\n    for (const key in pool_map) {\r\n      if (pool_map[key] in config) {\r\n        delete config[pool_map[key]];\r\n      }\r\n    }\r\n  }\r\n\r\n  return config;\r\n};\r\n\r\n/**\r\n   * 打开数据库连接（统一使用连接池）\r\n   * @returns {Promise<boolean>}\r\n   * @throws {TypeError} 当配置参数无效时\r\n   */\r\n  Mysql.prototype.open = async function () {\r\n    // 参数校验\r\n    if (!this.config || typeof this.config !== 'object') {\r\n      throw new TypeError('config must be object');\r\n    }\r\n\r\n    try {\r\n      // 统一使用连接池模式\r\n      const valid_config = this._getValidConfig(true);\r\n      this._pool = mysql.createPool(valid_config);\r\n      \r\n      // 测试连接池连接\r\n      const conn = await this._pool.getConnection();\r\n      conn.release();\r\n\r\n      this.log('info', '数据库连接池创建成功');\r\n      return true;\r\n    } catch (error) {\r\n      this.log('error', '数据库连接池创建失败', error);\r\n      return false;\r\n    }\r\n  };\r\n\r\n/**\r\n   * 关闭数据库连接（统一使用连接池）\r\n   * @returns {Promise<boolean>}\r\n   */\r\n  Mysql.prototype.close = async function () {\r\n    try {\r\n      // 先关闭连接池，再清理预处理语句（避免连接状态问题）\r\n      if (this._pool) {\r\n        await this._pool.end();\r\n        this._pool = null;\r\n      }\r\n      \r\n      // 连接池关闭后，预处理语句会自动失效，只需清理缓存\r\n      if (this._prepared_stmts) {\r\n        // 不再尝试关闭预处理语句，直接清空缓存\r\n        this._prepared_stmts.clear();\r\n      }\r\n\r\n      this.log('info', '数据库连接池已关闭');\r\n      return true;\r\n    } catch (error) {\r\n      this.log('error', '关闭连接池失败', error);\r\n      return false;\r\n    }\r\n  };\r\n\r\n/**\r\n * 安全释放数据库连接\r\n * @param {object} conn - 数据库连接对象\r\n * @param {boolean} is_pool_conn - 是否为连接池连接\r\n * @returns {Promise<void>}\r\n */\r\nasync function safeReleaseConnection(conn, is_pool_conn) {\r\n  if (!conn) return;\r\n\r\n  try {\r\n    if (is_pool_conn && typeof conn.release === 'function') {\r\n      await conn.release();\r\n    }\r\n  } catch (release_err) {\r\n    $.log.error('释放连接失败', release_err);\r\n  }\r\n};\r\n\r\n/**\r\n   * 获取数据库连接（统一使用连接池）\r\n   * @returns {Promise<object>}\r\n   * @throws {TypeError} 当连接池不存在时\r\n   */\r\n  Mysql.prototype.getConn = async function () {\r\n    // 参数校验\r\n    if (!this._pool) {\r\n      await this.open();\r\n    }\r\n\r\n    try {\r\n      // 统一从连接池获取连接\r\n      const conn = await this._pool.getConnection();\r\n      return conn;\r\n    } catch (error) {\r\n      this.log('error', '从连接池获取连接失败', error);\r\n      throw error; // 重新抛出错误，让调用方处理\r\n    }\r\n  };\r\n\r\n/**\r\n * 执行SQL查询（优化版，支持预处理语句缓存）\r\n * @param {string} sql - SQL语句\r\n * @param {Array} params - 参数数组\r\n * @returns {Promise<object>}\r\n * @throws {TypeError} 当sql参数无效时\r\n */\r\nMysql.prototype.run = async function (sql, params = []) {\r\n  // 参数校验\r\n  if (typeof sql !== 'string' || sql.trim() === '') {\r\n    throw new TypeError('sql must be non-empty string');\r\n  }\r\n  if (!Array.isArray(params)) {\r\n    throw new TypeError('params must be array');\r\n  }\r\n\r\n  this.error = null;\r\n  let conn = null;\r\n  let is_pool_conn = false;\r\n  let connection_released = false;\r\n\r\n  try {\r\n    // 获取连接\r\n    conn = await this.getConn();\r\n    is_pool_conn = this._use_pool;\r\n\r\n    // 检查是否启用预处理语句缓存\r\n    if (this.config.enable_statement_pooling && params.length > 0) {\r\n      const cache_key = this._getStatementCacheKey(sql);\r\n      let statement_info = this._prepared_stmts.get(cache_key);\r\n      \r\n      if (statement_info && statement_info.statement) {\r\n        // 使用缓存的预处理语句\r\n        this._cache_hits++;\r\n        statement_info.last_used = Date.now();\r\n        statement_info.use_count++;\r\n        \r\n        // 预先检查连接状态，避免不必要的错误\r\n        if (!conn || conn._fatalError || conn._closed) {\r\n          conn = await this.getConn();\r\n          // 连接已更新，需要重新创建预处理语句\r\n          this._prepared_stmts.delete(cache_key);\r\n          const statement = await conn.prepare(sql);\r\n          this._cacheStatement(cache_key, statement);\r\n          const [rows] = await statement.execute(params);\r\n          return rows;\r\n        }\r\n        \r\n        try {\r\n          const [rows] = await statement_info.statement.execute(params);\r\n          return rows;\r\n        } catch (stmt_err) {\r\n          // 预处理语句可能已失效（连接关闭等），重新创建\r\n          this.log('warn', '预处理语句执行失败，重新创建', stmt_err);\r\n          this._prepared_stmts.delete(cache_key);\r\n          \r\n          // 检查连接是否有效，如果无效则重新获取连接\r\n          if (!conn || conn._fatalError || conn._closed) {\r\n            conn = await this.getConn();\r\n          }\r\n          \r\n          // 重新创建预处理语句\r\n          const statement = await conn.prepare(sql);\r\n          this._cacheStatement(cache_key, statement);\r\n          \r\n          const [rows] = await statement.execute(params);\r\n          return rows;\r\n        }\r\n      } else {\r\n        // 创建新的预处理语句并缓存\r\n        this._cache_misses++;\r\n        const statement = await conn.prepare(sql);\r\n        this._cacheStatement(cache_key, statement);\r\n        \r\n        const [rows] = await statement.execute(params);\r\n        return rows;\r\n      }\r\n    } else {\r\n      // 不使用预处理语句缓存，直接查询\r\n      const [rows] = await conn.query(sql, params);\r\n      return rows;\r\n    }\r\n  } catch (err) {\r\n    this.sql = err.sql;\r\n    this.error = {\r\n      code: err.errno,\r\n      message: err.sqlMessage\r\n    };\r\n    // 在错误情况下也要确保连接释放\r\n    try {\r\n      await safeReleaseConnection(conn, is_pool_conn);\r\n    } catch (release_err) {\r\n      this.log('error', '释放连接失败', release_err);\r\n    }\r\n    connection_released = true;\r\n    \r\n    // 重新抛出错误，让调用方处理\r\n    throw err;\r\n  } finally {\r\n    // 确保连接被释放，避免资源泄漏\r\n    if (!connection_released) {\r\n      try {\r\n        await safeReleaseConnection(conn, is_pool_conn);\r\n      } catch (release_err) {\r\n        this.log('error', '释放连接失败', release_err);\r\n      }\r\n    }\r\n  }\r\n  return [];\r\n};\r\n\r\n/**\r\n * 执行SQL语句（优化版，支持预处理语句缓存）\r\n * @param {string} sql - SQL语句\r\n * @param {Array} params - 参数数组\r\n * @returns {Promise<object>}\r\n * @throws {TypeError} 当sql参数无效时\r\n */\r\nMysql.prototype.exec = async function (sql, params = []) {\r\n  // 参数校验\r\n  if (typeof sql !== 'string' || sql.trim() === '') {\r\n    throw new TypeError('sql must be non-empty string');\r\n  }\r\n  if (!Array.isArray(params)) {\r\n    throw new TypeError('params must be array');\r\n  }\r\n  this.error = null;\r\n  let conn = null;\r\n  let is_pool_conn = false;\r\n  let connection_released = false;\r\n\r\n  try {\r\n    // 获取连接\r\n    conn = await this.getConn();\r\n    is_pool_conn = this._use_pool;\r\n\r\n    // 检查是否启用预处理语句缓存\r\n    if (this.config.enable_statement_pooling && params.length > 0) {\r\n      const cache_key = this._getStatementCacheKey(sql);\r\n      let statement_info = this._prepared_stmts.get(cache_key);\r\n      \r\n      if (statement_info && statement_info.statement) {\r\n        // 使用缓存的预处理语句\r\n        this._cache_hits++;\r\n        statement_info.last_used = Date.now();\r\n        statement_info.use_count++;\r\n        \r\n        // 预先检查连接状态，避免不必要的错误\r\n        if (!conn || conn._fatalError || conn._closed) {\r\n          conn = await this.getConn();\r\n          // 连接已更新，需要重新创建预处理语句\r\n          this._prepared_stmts.delete(cache_key);\r\n          const statement = await conn.prepare(sql);\r\n          this._cacheStatement(cache_key, statement);\r\n          const [result] = await statement.execute(params);\r\n          return result.insertId || result.affectedRows || result.changedRows || 1;\r\n        }\r\n        \r\n        try {\r\n          const [result] = await statement_info.statement.execute(params);\r\n          return result.insertId || result.affectedRows || result.changedRows || 1;\r\n        } catch (stmt_err) {\r\n          // 预处理语句可能已失效（连接关闭等），重新创建\r\n          this.log('warn', '预处理语句执行失败，重新创建', stmt_err);\r\n          this._prepared_stmts.delete(cache_key);\r\n          \r\n          // 检查连接是否有效，如果无效则重新获取连接\r\n          if (!conn || conn._fatalError || conn._closed) {\r\n            conn = await this.getConn();\r\n          }\r\n          \r\n          // 重新创建预处理语句\r\n          const statement = await conn.prepare(sql);\r\n          this._cacheStatement(cache_key, statement);\r\n          \r\n          const [result] = await statement.execute(params);\r\n          return result.insertId || result.affectedRows || result.changedRows || 1;\r\n        }\r\n      } else {\r\n        // 创建新的预处理语句并缓存\r\n        this._cache_misses++;\r\n        const statement = await conn.prepare(sql);\r\n        this._cacheStatement(cache_key, statement);\r\n        \r\n        const [result] = await statement.execute(params);\r\n        return result.insertId || result.affectedRows || result.changedRows || 1;\r\n      }\r\n    } else {\r\n        // 对于写入语句，直接执行（不使用预处理语句缓存）\r\n        const [result] = await conn.execute(sql, params);\r\n        return result.insertId || result.affectedRows || result.changedRows || 1;\r\n      }\r\n  } catch (error) {\r\n    this.log('error', 'SQL执行失败', error);\r\n    this.sql = error.sql;\r\n    this.error = {\r\n      code: error.errno,\r\n      message: error.sqlMessage\r\n    };\r\n    // 在错误情况下也要确保连接释放\r\n    try {\r\n      await safeReleaseConnection(conn, is_pool_conn);\r\n    } catch (release_err) {\r\n      this.log('error', '释放连接失败', release_err);\r\n    }\r\n    connection_released = true;\r\n    \r\n    // 重新抛出错误，让调用方处理\r\n    throw error;\r\n  } finally {\r\n    // 确保连接被释放，避免资源泄漏\r\n    if (!connection_released) {\r\n      try {\r\n        await safeReleaseConnection(conn, is_pool_conn);\r\n      } catch (release_err) {\r\n        this.log('error', '释放连接失败', release_err);\r\n      }\r\n    }\r\n  }\r\n  return 0;\r\n};\r\n\r\n/**\r\n * 开始事务（改进版）\r\n * @returns {Promise<object>} 事务连接对象\r\n */\r\nMysql.prototype.beginTransaction = async function () {\r\n  let conn = null;\r\n  let transaction_committed = false;\r\n  let transaction_rolled_back = false;\r\n\r\n  try {\r\n    conn = await this.getConn();\r\n    await conn.beginTransaction();\r\n\r\n    return {\r\n      connection: conn,\r\n      commit: async () => {\r\n        if (transaction_committed || transaction_rolled_back) {\r\n          this.log('warn', '事务已结束，无需重复提交');\r\n          return;\r\n        }\r\n        await conn.commit();\r\n        transaction_committed = true;\r\n        try {\r\n          await safeReleaseConnection(conn, this._usePool);\r\n        } catch (release_err) {\r\n          this.log('error', '提交时释放连接失败', release_err);\r\n        }\r\n      },\r\n      rollback: async () => {\r\n        if (transaction_committed || transaction_rolled_back) {\r\n          this.log('warn', '事务已结束，无需重复回滚');\r\n          return;\r\n        }\r\n        await conn.rollback();\r\n        transaction_rolled_back = true;\r\n        try {\r\n          await safeReleaseConnection(conn, this._usePool);\r\n        } catch (release_err) {\r\n          this.log('error', '回滚时释放连接失败', release_err);\r\n        }\r\n      },\r\n      _is_ended: () => transaction_committed || transaction_rolled_back\r\n    };\r\n  } catch (error) {\r\n    // 如果事务开始失败，确保连接被释放\r\n    try {\r\n      await safeReleaseConnection(conn, this._usePool);\r\n    } catch (release_err) {\r\n      this.log('error', '释放连接失败', release_err);\r\n    }\r\n    this.log('error', '事务开始失败', error);\r\n    throw error;\r\n  }\r\n};\r\n\r\n/**\r\n * 在事务中执行多个操作（改进版）\r\n * @param {Function} callback - 包含事务操作的回调函数\r\n * @returns {Promise<*>} 回调函数的返回值\r\n * @throws {TypeError} 当callback参数无效时\r\n */\r\nMysql.prototype.transaction = async function (callback) {\r\n  // 参数校验\r\n  if (typeof callback !== 'function') {\r\n    throw new TypeError('callback must be function');\r\n  }\r\n\r\n  let transaction = null;\r\n  let transaction_executed = false;\r\n\r\n  try {\r\n    transaction = await this.beginTransaction();\r\n    const result = await callback(transaction);\r\n\r\n    // 检查事务是否已由用户手动提交/回滚\r\n    if (transaction._is_ended && !transaction._is_ended()) {\r\n      await transaction.commit();\r\n    }\r\n\r\n    transaction_executed = true;\r\n    return result;\r\n  } catch (error) {\r\n    if (transaction && !transaction_executed) {\r\n      // 只有在事务未成功执行的情况下才回滚\r\n      if (transaction._is_ended && !transaction._is_ended()) {\r\n        await transaction.rollback().catch(err => {\r\n          this.log('error', '事务回滚失败', err);\r\n        });\r\n      }\r\n    }\r\n\r\n    this.log('error', '事务执行失败', error);\r\n    throw error; // 重新抛出错误，让调用方知道事务失败\r\n  }\r\n};\r\n\r\n/**\r\n * 读取整张表的数据（改进版）\r\n * @param {string} table - 表名\r\n * @param {object} condition - 查询条件\r\n * @param {object} options - 选项（orderBy, limit, offset等）\r\n * @returns {Promise<Array>}\r\n * @throws {TypeError} 当table参数无效时\r\n */\r\nMysql.prototype.read = async function (table, condition = {}, options = {}) {\r\n  // 参数校验\r\n  if (typeof table !== 'string' || table.trim() === '') {\r\n    throw new TypeError('table must be non-empty string');\r\n  }\r\n  if (condition && typeof condition !== 'object') {\r\n    throw new TypeError('condition must be object');\r\n  }\r\n  if (options && typeof options !== 'object') {\r\n    throw new TypeError('options must be object');\r\n  }\r\n\r\n  try {\r\n    let sql = `SELECT * FROM ${table}`;\r\n    const params = [];\r\n\r\n    // 处理条件\r\n    if (Object.keys(condition).length > 0) {\r\n      const whereClauses = [];\r\n      for (const [field, value] of Object.entries(condition)) {\r\n        whereClauses.push(`${field} = ?`);\r\n        params.push(value);\r\n      }\r\n      sql += ` WHERE ${whereClauses.join(' AND ')}`;\r\n    }\r\n\r\n    // 处理排序\r\n    if (options.orderBy) {\r\n      sql += ` ORDER BY ${options.orderBy}`;\r\n    }\r\n\r\n    // 处理分页\r\n    if (options.limit) {\r\n      sql += ` LIMIT ${options.limit}`;\r\n    }\r\n\r\n    if (options.offset) {\r\n      sql += ` OFFSET ${options.offset}`;\r\n    }\r\n\r\n    // 执行查询\r\n    return await this.run(sql, params);\r\n  } catch (error) {\r\n    this.log('error', '查询失败', error);\r\n    throw error; // 重新抛出错误，让调用方知道查询失败\r\n  }\r\n};\r\n\r\n/**\r\n * 获取连接池状态信息\r\n * @returns {object} 连接池状态对象\r\n */\r\nMysql.prototype.getPoolStats = function () {\r\n  if (!this._pool) {\r\n    return {\r\n      status: 'not_initialized',\r\n      message: '连接池未初始化'\r\n    };\r\n  }\r\n\r\n  return {\r\n    status: 'healthy'\r\n  };\r\n};\r\n\r\n/**\r\n * 健康检查\r\n * @returns {Promise<object>} 健康检查结果\r\n */\r\nMysql.prototype.healthCheck = async function () {\r\n  try {\r\n    if (!this._pool && !this._connection) {\r\n      return {\r\n        status: 'error',\r\n        message: '数据库连接未初始化'\r\n      };\r\n    }\r\n\r\n    // 执行简单的查询来检查连接状态\r\n    const result = await this.run('SELECT 1 as health_check');\r\n\r\n    if (result && result.length > 0 && result[0].health_check === 1) {\r\n      return {\r\n        status: 'healthy',\r\n        message: '数据库连接正常',\r\n        ...this.getPoolStats()\r\n      };\r\n    } else {\r\n      return {\r\n        status: 'error',\r\n        message: '健康检查查询失败'\r\n      };\r\n    }\r\n  } catch (error) {\r\n    this.log('error', '健康检查失败', error);\r\n    return {\r\n      status: 'error',\r\n      message: `健康检查失败: ${error.message}`\r\n    };\r\n  }\r\n};\r\n\r\n/**\r\n * 获取数据库管理器（保持兼容性）\r\n * @returns {object} DB实例\r\n */\r\nMysql.prototype.db = function () {\r\n  return new DB(this);\r\n};\r\n\r\n/**\r\n * 初始化MySQL服务（保持兼容性）\r\n * @returns {Promise<void>}\r\n */\r\nMysql.prototype.init = async function () {\r\n  await this.open();\r\n};\r\n\r\n/**\r\n * 导出模块\r\n */\r\nexports.Mysql = Mysql;\r\n\r\n/**\r\n * 确保连接池对象存在\r\n */\r\nif (!$.pool) {\r\n  $.pool = {};\r\n}\r\nif (!$.pool.mysql) {\r\n  $.pool.mysql = {};\r\n}\r\n\r\n/**\r\n * 全局锁对象，用于线程安全\r\n */\r\nif (!$.pool.mysql._locks) {\r\n  $.pool.mysql._locks = {};\r\n}\r\n\r\n/**\r\n * 获取锁\r\n * @param {string} key - 锁的键名\r\n * @returns {Promise<Function>} 释放锁的函数\r\n */\r\nfunction _acquireLock(key) {\r\n  if (!$.pool.mysql._locks[key]) {\r\n    $.pool.mysql._locks[key] = Promise.resolve();\r\n  }\r\n\r\n  let release;\r\n  const lockPromise = $.pool.mysql._locks[key].then(() => {\r\n    return new Promise(resolve => {\r\n      release = resolve;\r\n    });\r\n  });\r\n\r\n  $.pool.mysql._locks[key] = lockPromise;\r\n  return lockPromise.then(() => release);\r\n}\r\n\r\n/**\r\n * @description Mysql管理器，用于创建缓存（线程安全版）\r\n * @param {string} scope 作用域\r\n * @param {object} config 配置参数\r\n * @returns {object} 返回一个Mysql类实例\r\n */\r\nfunction mysqlAdmin(scope, config) {\r\n  if (!scope) {\r\n    scope = 'sys';\r\n  }\r\n\r\n  // 检查是否已存在实例\r\n  if ($.pool.mysql[scope]) {\r\n    return $.pool.mysql[scope];\r\n  }\r\n\r\n  // 同步方式创建实例（无需锁，因为Node.js是单线程的）\r\n  if (!$.pool.mysql[scope]) {\r\n    $.pool.mysql[scope] = new Mysql(config);\r\n  }\r\n\r\n  return $.pool.mysql[scope];\r\n}\r\n\r\n/**\r\n * @module 导出Mysql管理器\r\n */\r\nexports.mysqlAdmin = mysqlAdmin;"]}