主题设置
内置主题选择后自动记忆
我的主题0
在「自定义」里调好颜色后,点下方「另存为」即可存成自己的主题。
导出的 JSON 可分享给他人,导入后会出现在「我的主题」,登录后自动备份到云端。
自定义参数默认等于液态玻璃
主题色
辅色
背景色
文字配色
渐变底色
光斑颜色
角度 160°
通透度 88%
标题
正文
描述
标题
描述
正文
链接
描述
标题
描述
站点卡片
面板背景
背景
遮罩 16%
卡片 88%
登录
星际导航 高质量资源导航

媒体工具

共 121 个站点 · 8 个标签 · 按「推荐」排序

品牌固定位 ¥83.33 起 / 月 立即入驻
枫叶 小鹿 Image 小鹿 Image 是个人枫叶维护的免费在线图片工具站,41 个工具覆盖压缩、格式转换、裁剪改尺寸、水印拼接与证件… 179 Web 枫叶 莱诺鸟 用AI生成高质量转化广告,电商套图,详情页和场景图。只需一张产品图,即可立刻生成可用于投放的广告素材。 265 Web 枫叶 Watermark Remover Pixelbin旗下AI驱动的在线去水印网页工具。无需手动框选水印区域,AI自动识别图片、PDF、短视频当中的水… 270 Web 枫叶 Easy Pick 易切 Easy Pick 在线切图工具,支持从商品海报、截图和插画中提取图片,自动拆分为独立 PNG 素材并打包… 230 Web 枫叶 Magic Studio Magic Studio是一款基于人工智能的在线图像生成与编辑工具,主要面向需要快速制作视觉内容的用户。平台提供… 962 Web 枫叶 椒图AI 椒图AI 是一款面向中文用户的在线 AI 修图工具,主要通过自然语言指令完成图片编辑与设计任务。用户可以上传图片… 1.91k Web 枫叶 EditGhost EditGhost 是一款基于浏览器运行的在线照片清理工具,主要用于移除图片中的局部干扰元素,例如人物、电线、日… 810 Web 枫叶 简图AI 简图AI – 跨境电商图片处理,一步到位 1.11k Web 枫叶 玛卡巴卡 图像分辨率画质提升,简单操作,可实现4倍放大,像素优化。 754 Web 枫叶 PageCrush Pagecrush 是一款面向网页内容捕捉的工具,定位于“高质量网页截图与视觉快照服务平台”。它支持整页捕捉、区… 1.81k Web 枫叶 美图抠图 美图抠图是美图设计室推出的在线 AI 抠图服务,专为非专业用户与电商设计人群打造。平台通过自研图像识别与语义分割… 1.21k Web 枫叶 Text Behind Image Text Behind Image 是一款开源的在线图像处理工具,专注于将文字融入图片背景。平台通过 AI 自动… 1.11k Web 枫叶 拼字幕(Quote Maker) 拼字幕(Quote Maker)是一款基于 Web 的字幕拼图生成工具,定位于“轻量化图文创作”。用户无需下载安… 1.11k Web 枫叶 剪哔·biliCut 剪哔biliCut 是一款专为 B 站用户设计的在线视频截取工具。它集视频解析、下载和剪辑功能于一身,允许用户从… 2.21k Web 枫叶 壁纸样机神器 壁纸样机神器是一款网页端在线样机生成工具,专注于帮助设计师、插画师及创意工作者快速制作壁纸样机。 1.51k Web 枫叶 鸭力巨大 鸭力巨大是一个基于网页端的图片在线压缩工具,用户无需下载安装即可使用。平台支持 JPG、PNG、GIF 等常见格… 1.11k Web 枫叶 图好快 图好快是一个基于网页端的图片压缩与尺寸调整工具。它允许用户精准设定图片的长宽和目标大小(如 413×626 像素… 1.21k Web 枫叶 在线改图 在线改图是一个免费的网页端图片处理工具,专注于为用户提供简洁、高效的图片编辑与转换服务。它无需安装任何软件,也无… 1.21k Web 枫叶 MESH.Y MESH.Y 是一款基于网页的背景图生成器,重点在于简洁、易用和美观。用户无需安装任何软件,只需打开网站即可在线… 807 Web 枫叶 免费加水印小工具 图片水印是一款轻量级的在线加水印工具,专门用于保护用户图片的版权和完整性。它不仅支持单张和批量处理,还允许用户自… 1.21k Web 枫叶 Photopea Photopea 是一款免费的在线图像编辑器,被广泛视为 Photoshop 的轻量级替代方案。它完全运行在浏览… 1.91k Web 枫叶 PicsResizer PicsResizer 是一款在线图片处理工具,专注于批量图片尺寸调整。与传统在线工具不同,它的核心特点是“本地… 1.21k Web 枫叶 FliiipBook FliiipBook 是一款基于 Web 的逐帧动画应用,用户可在浏览器中绘制每一帧画面,并即时生成 GIF 动… 1.41k Web 枫叶 抠抠图 永久免费在线AI抠图、免费在线批量抠图,无需专业设计技能,只需轻点鼠标,我们的智能算法即刻为您精准识别图像边缘,… 1.11k Web 枫叶 PasteResize PasteResize 定位为一款免费在线图片编辑器,专注于基础图像处理操作。平台支持用户直接粘贴或拖拽上传图片… 1.11k Web
必备 枫叶起始页(必备)
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-11-21 16:38:32 HTTP/1.1 GET : https://dhw.wchulian.com.cn/c/mediatools?tag=mediatools-1
  2. 运行时间 : 0.688308s [ 吞吐率:1.45req/s ] 内存消耗:12,537.59kb 文件加载:190
  3. 缓存信息 : 0 reads,0 writes
  1. /www/wwwroot/daohw.cn/public/index.php ( 0.79 KB )
  2. /www/wwwroot/daohw.cn/vendor/autoload.php ( 0.73 KB )
  3. /www/wwwroot/daohw.cn/vendor/composer/autoload_real.php ( 1.63 KB )
  4. /www/wwwroot/daohw.cn/vendor/composer/platform_check.php ( 0.90 KB )
  5. /www/wwwroot/daohw.cn/vendor/composer/ClassLoader.php ( 15.99 KB )
  6. /www/wwwroot/daohw.cn/vendor/composer/autoload_static.php ( 4.73 KB )
  7. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
  8. /www/wwwroot/daohw.cn/vendor/topthink/think-validate/src/helper.php ( 2.19 KB )
  9. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/helper.php ( 1.47 KB )
  10. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
  11. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
  12. /www/wwwroot/daohw.cn/vendor/topthink/think-container/src/Facade.php ( 2.71 KB )
  13. /www/wwwroot/daohw.cn/vendor/symfony/deprecation-contracts/function.php ( 0.99 KB )
  14. /www/wwwroot/daohw.cn/vendor/symfony/polyfill-mbstring/bootstrap.php ( 0.35 KB )
  15. /www/wwwroot/daohw.cn/vendor/symfony/polyfill-mbstring/bootstrap80.php ( 9.86 KB )
  16. /www/wwwroot/daohw.cn/vendor/symfony/var-dumper/Resources/functions/dump.php ( 1.60 KB )
  17. /www/wwwroot/daohw.cn/vendor/topthink/think-dumper/src/helper.php ( 0.18 KB )
  18. /www/wwwroot/daohw.cn/vendor/symfony/var-dumper/VarDumper.php ( 4.23 KB )
  19. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/App.php ( 15.30 KB )
  20. /www/wwwroot/daohw.cn/vendor/topthink/think-container/src/Container.php ( 15.76 KB )
  21. /www/wwwroot/daohw.cn/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
  22. /www/wwwroot/daohw.cn/app/provider.php ( 0.19 KB )
  23. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Http.php ( 6.22 KB )
  24. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
  25. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Env.php ( 4.68 KB )
  26. /www/wwwroot/daohw.cn/app/common.php ( 3.32 KB )
  27. /www/wwwroot/daohw.cn/app/common/base.php ( 5.99 KB )
  28. /www/wwwroot/daohw.cn/app/common/ip.php ( 6.27 KB )
  29. /www/wwwroot/daohw.cn/app/common/db.php ( 10.66 KB )
  30. /www/wwwroot/daohw.cn/app/common/db_upgrade.php ( 131.87 KB )
  31. /www/wwwroot/daohw.cn/app/common/schema.php ( 128.95 KB )
  32. /www/wwwroot/daohw.cn/app/common/seed.php ( 155.06 KB )
  33. /www/wwwroot/daohw.cn/app/common/install.php ( 14.51 KB )
  34. /www/wwwroot/daohw.cn/app/common/sec.php ( 18.30 KB )
  35. /www/wwwroot/daohw.cn/app/common/auth.php ( 17.69 KB )
  36. /www/wwwroot/daohw.cn/app/common/user.php ( 34.70 KB )
  37. /www/wwwroot/daohw.cn/app/common/notify.php ( 33.47 KB )
  38. /www/wwwroot/daohw.cn/app/common/queue.php ( 19.44 KB )
  39. /www/wwwroot/daohw.cn/app/common/apisend.php ( 6.32 KB )
  40. /www/wwwroot/daohw.cn/app/common/order.php ( 29.57 KB )
  41. /www/wwwroot/daohw.cn/app/common/view.php ( 42.24 KB )
  42. /www/wwwroot/daohw.cn/app/common/content.php ( 30.30 KB )
  43. /www/wwwroot/daohw.cn/app/common/widget.php ( 47.66 KB )
  44. /www/wwwroot/daohw.cn/app/common/money.php ( 36.91 KB )
  45. /www/wwwroot/daohw.cn/app/common/http.php ( 19.17 KB )
  46. /www/wwwroot/daohw.cn/app/common/ui.php ( 6.91 KB )
  47. /www/wwwroot/daohw.cn/app/common/compat.php ( 26.91 KB )
  48. /www/wwwroot/daohw.cn/app/common/plugin.php ( 40.16 KB )
  49. /www/wwwroot/daohw.cn/app/common/member.php ( 61.47 KB )
  50. /www/wwwroot/daohw.cn/app/common/secret.php ( 10.39 KB )
  51. /www/wwwroot/daohw.cn/app/common/comment.php ( 22.62 KB )
  52. /www/wwwroot/daohw.cn/app/common/download.php ( 67.84 KB )
  53. /www/wwwroot/daohw.cn/app/common/home_modules.php ( 19.91 KB )
  54. /www/wwwroot/daohw.cn/app/common/home_pic.php ( 64.63 KB )
  55. /www/wwwroot/daohw.cn/app/common/shijuan.php ( 7.81 KB )
  56. /www/wwwroot/daohw.cn/app/common/iosdl.php ( 12.61 KB )
  57. /www/wwwroot/daohw.cn/app/common/fx.php ( 9.61 KB )
  58. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/helper.php ( 18.77 KB )
  59. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Config.php ( 5.93 KB )
  60. /www/wwwroot/daohw.cn/config/app.php ( 0.95 KB )
  61. /www/wwwroot/daohw.cn/config/cache.php ( 0.78 KB )
  62. /www/wwwroot/daohw.cn/config/console.php ( 0.80 KB )
  63. /www/wwwroot/daohw.cn/config/cookie.php ( 0.56 KB )
  64. /www/wwwroot/daohw.cn/config/database.php ( 2.13 KB )
  65. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  66. /www/wwwroot/daohw.cn/config/filesystem.php ( 0.61 KB )
  67. /www/wwwroot/daohw.cn/config/lang.php ( 0.91 KB )
  68. /www/wwwroot/daohw.cn/config/log.php ( 1.35 KB )
  69. /www/wwwroot/daohw.cn/config/middleware.php ( 0.19 KB )
  70. /www/wwwroot/daohw.cn/config/route.php ( 1.89 KB )
  71. /www/wwwroot/daohw.cn/config/session.php ( 0.57 KB )
  72. /www/wwwroot/daohw.cn/config/shijuan.php ( 1.16 KB )
  73. /www/wwwroot/daohw.cn/config/trace.php ( 0.34 KB )
  74. /www/wwwroot/daohw.cn/config/view.php ( 1.20 KB )
  75. /www/wwwroot/daohw.cn/app/event.php ( 0.25 KB )
  76. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Event.php ( 7.77 KB )
  77. /www/wwwroot/daohw.cn/app/service.php ( 0.13 KB )
  78. /www/wwwroot/daohw.cn/app/AppService.php ( 0.26 KB )
  79. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  80. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  81. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  82. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  83. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  84. /www/wwwroot/daohw.cn/vendor/services.php ( 0.14 KB )
  85. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  86. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  87. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  88. /www/wwwroot/daohw.cn/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  89. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  90. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  91. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/Paginator.php ( 11.86 KB )
  92. /www/wwwroot/daohw.cn/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  93. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/Model.php ( 23.55 KB )
  94. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 21.05 KB )
  95. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/AutoWriteData.php ( 4.20 KB )
  96. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 6.75 KB )
  97. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/DbConnect.php ( 5.16 KB )
  98. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.33 KB )
  99. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 28.30 KB )
  100. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  101. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  102. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/contract/Modelable.php ( 0.09 KB )
  103. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  104. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/DbManager.php ( 8.52 KB )
  105. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  106. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  107. /www/wwwroot/daohw.cn/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  108. /www/wwwroot/daohw.cn/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  109. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  110. /www/wwwroot/daohw.cn/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  111. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/helper/Arr.php ( 17.45 KB )
  112. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.84 KB )
  113. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/cache/Driver.php ( 9.02 KB )
  114. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  115. /www/wwwroot/daohw.cn/app/Request.php ( 0.09 KB )
  116. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Request.php ( 54.64 KB )
  117. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/traits/UrlHandler.php ( 6.05 KB )
  118. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/traits/DomainHandler.php ( 5.49 KB )
  119. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/traits/HttpMethodHandler.php ( 4.74 KB )
  120. /www/wwwroot/daohw.cn/app/middleware.php ( 0.37 KB )
  121. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  122. /www/wwwroot/daohw.cn/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  123. /www/wwwroot/daohw.cn/app/middleware/SecurityHeaders.php ( 2.08 KB )
  124. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  125. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/RuleName.php ( 5.74 KB )
  126. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  127. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.41 KB )
  128. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/Rule.php ( 27.49 KB )
  129. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  130. /www/wwwroot/daohw.cn/route/apisend.php ( 2.09 KB )
  131. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  132. /www/wwwroot/daohw.cn/route/app.php ( 27.46 KB )
  133. /www/wwwroot/daohw.cn/route/shijuan.php ( 1.60 KB )
  134. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  135. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/Dispatch.php ( 11.32 KB )
  136. /www/wwwroot/daohw.cn/app/controller/Front.php ( 1.21 KB )
  137. /www/wwwroot/daohw.cn/app/BaseController.php ( 2.05 KB )
  138. /www/wwwroot/daohw.cn/app/controller/front/ContextTrait.php ( 19.62 KB )
  139. /www/wwwroot/daohw.cn/app/controller/front/HomeTrait.php ( 29.78 KB )
  140. /www/wwwroot/daohw.cn/app/controller/front/ArticleTrait.php ( 35.02 KB )
  141. /www/wwwroot/daohw.cn/app/controller/front/SponsorTrait.php ( 14.63 KB )
  142. /www/wwwroot/daohw.cn/app/controller/front/ApplyTrait.php ( 12.30 KB )
  143. /www/wwwroot/daohw.cn/app/controller/front/ToolTrait.php ( 12.63 KB )
  144. /www/wwwroot/daohw.cn/app/controller/front/DyTrait.php ( 14.55 KB )
  145. /www/wwwroot/daohw.cn/app/controller/front/SecretTrait.php ( 2.17 KB )
  146. /www/wwwroot/daohw.cn/app/controller/front/DownloadTrait.php ( 5.99 KB )
  147. /www/wwwroot/daohw.cn/app/controller/front/FxTrait.php ( 4.67 KB )
  148. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  149. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 5.73 KB )
  150. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/PDOConnection.php ( 53.74 KB )
  151. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Connection.php ( 8.39 KB )
  152. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.57 KB )
  153. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.58 KB )
  154. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Builder.php ( 24.07 KB )
  155. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.50 KB )
  156. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/log/driver/File.php ( 6.10 KB )
  157. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  158. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  159. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  160. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/exception/PDOException.php ( 1.50 KB )
  161. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/exception/DbException.php ( 1.38 KB )
  162. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Log.php ( 3.07 KB )
  163. /www/wwwroot/daohw.cn/vendor/psr/log/src/LogLevel.php ( 0.33 KB )
  164. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Query.php ( 15.97 KB )
  165. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/BaseQuery.php ( 45.13 KB )
  166. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  167. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  168. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 20.07 KB )
  169. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  170. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.01 KB )
  171. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 19.37 KB )
  172. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.11 KB )
  173. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.63 KB )
  174. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  175. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  176. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/exception/ErrorException.php ( 1.72 KB )
  177. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Raw.php ( 1.30 KB )
  178. /www/wwwroot/daohw.cn/app/utils/IpUtils.php ( 5.41 KB )
  179. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Cache.php ( 2.06 KB )
  180. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Response.php ( 9.07 KB )
  181. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/response/View.php ( 3.29 KB )
  182. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  183. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
  184. /www/wwwroot/daohw.cn/vendor/topthink/think-view/src/Think.php ( 8.38 KB )
  185. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.60 KB )
  186. /www/wwwroot/daohw.cn/vendor/topthink/think-template/src/Template.php ( 46.61 KB )
  187. /www/wwwroot/daohw.cn/vendor/topthink/think-template/src/template/driver/File.php ( 2.41 KB )
  188. /www/wwwroot/daohw.cn/vendor/topthink/think-template/src/template/contract/DriverInterface.php ( 0.86 KB )
  189. /www/wwwroot/daohw.cn/runtime/temp/17dbd12c5b30222f6f81136592ebbfc1.php ( 153.89 KB )
  190. /www/wwwroot/daohw.cn/vendor/topthink/think-trace/src/Html.php ( 4.42 KB )
  1. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_admin_username'
  2. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_category_slug'
  3. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_tag_slug'
  4. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_tag_cat'
  5. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_site_slug'
  6. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_cat'
  7. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_tag'
  8. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_type'
  9. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_create'
  10. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_views'
  11. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_likes'
  12. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_views_date'
  13. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_views_wkey'
  14. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_like_ip'
  15. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_svd_site_day'
  16. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_svd_day'
  17. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_site_health_status'
  18. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_acat_slug'
  19. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_acat_parent'
  20. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_amenu_parent'
  21. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_article_cat'
  22. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_sponsor_site'
  23. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_sponsor_order_no'
  24. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_sponsor_order_sp'
  25. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_link_pos'
  26. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_link_pid'
  27. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_submit_status'
  28. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_submit_cat'
  29. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_submit_create'
  30. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_qlink_sort'
  31. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_qlink_item'
  32. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_qlink_item_sort'
  33. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_ad_state'
  34. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_ad_time'
  35. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_adplan_sort'
  36. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_friend_status'
  37. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_friend_order'
  38. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dock_sort'
  39. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_plugin_slug'
  40. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_plugin_sort'
  41. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dypage_alias'
  42. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dypage_sort'
  43. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_devphase_sort'
  44. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_devlog_day'
  45. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_api_log_channel'
  46. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_api_log_status'
  47. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_api_log_time'
  48. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_name'
  49. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_email'
  50. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_status'
  51. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_regip'
  52. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_create'
  53. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_vip_expire'
  54. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_webmaster_expire'
  55. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_level'
  56. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_token'
  57. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_token_uid'
  58. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_token_exp'
  59. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_fav'
  60. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
  61. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_quick_uid'
  62. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
  63. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_dock_uid'
  64. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_note'
  65. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_note_uid'
  66. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_fx_url_slug'
  67. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_fx_url_uid'
  68. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_fx_url_ip'
  69. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_fx_report_fx'
  70. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_fx_report_ip'
  71. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_theme'
  72. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_theme_uid'
  73. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_like'
  74. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_code'
  75. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_code_exp'
  76. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_hist'
  77. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_hist_time'
  78. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_invite_code'
  79. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_status'
  80. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_user'
  81. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_invite_order'
  82. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_st'
  83. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_ip'
  84. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_uid'
  85. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_create'
  86. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_pay'
  87. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_st_pay'
  88. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_member_plan_type'
  89. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_pack_on'
  90. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_member_order'
  91. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_member_order_uid'
  92. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_member_order_st'
  93. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_member_order_type_pay'
  94. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_log_uid'
  95. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_log_create'
  96. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_article_points_once'
  97. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_article_points_day'
  98. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_article_points_ip'
  99. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_points_signin_day'
  100. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_signin_ip'
  101. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_signin_dev'
  102. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_dl_ticket_sig'
  103. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_ticket_exp'
  104. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_pkg_key_once'
  105. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_pkg_key_bucket'
  106. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_pkg_key_slug'
  107. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_new'
  108. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_hot'
  109. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_dev'
  110. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_uid'
  111. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_ip'
  112. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_hash'
  113. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_site'
  114. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secrep_post'
  115. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secrep_state'
  116. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_page'
  117. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_root'
  118. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_uid'
  119. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_dev'
  120. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_time'
  121. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_rm_scope'
  122. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_rm_item_rid'
  123. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_home_module_mkey'
  124. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_home_block_sort'
  125. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_home_pic_sort'
  126. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_home_pic_block'
  127. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_pic_stat_day'
  128. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_block_stat_day'
  129. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_shijuan_subject_slug'
  130. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_shijuan_cat_slug'
  131. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_shijuan_cat_subject'
  132. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_shijuan_item_cat_id'
  133. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_shijuan_item_cat_sort'
  134. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_shijuan_item_date'
  135. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_shijuan_dl_item'
  136. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_unlock_art'
  137. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_unlock_token'
  138. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_unlock_email'
  139. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_unlock_mt'
  140. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_dl_order_no'
  141. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_order_email'
  142. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_order_art'
  143. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_order_ip'
  144. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_dl_quota'
  145. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_log_art'
  146. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_log_user'
  147. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:144 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_log_ip'
  1. CONNECT:[ UseTime:0.000309s ] mysql:host=127.0.0.1;port=3306;dbname=daohw_cn;charset=utf8mb4
  2. SELECT `v` FROM `nav_setting` WHERE `k` = 'db_version' [ RunTime:0.000215s ]
  3. CREATE TABLE IF NOT EXISTS `nav_setting` ( `k` varchar(64) NOT NULL COMMENT '配置键名', `v` text COMMENT '配置值(JSON / 文本)', `update_time` int NOT NULL DEFAULT 0 COMMENT '最后更新时间(Unix 时间戳)', PRIMARY KEY (`k`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '系统配置表' [ RunTime:0.000270s ]
  4. CREATE TABLE IF NOT EXISTS `nav_admin` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `username` varchar(50) NOT NULL COMMENT '登录账号', `password` varchar(255) NOT NULL COMMENT '登录密码(哈希存储)', `nickname` varchar(50) DEFAULT '' COMMENT '管理员昵称', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `last_login_time` int NOT NULL DEFAULT 0 COMMENT '最后登录时间(Unix 时间戳)', `last_login_ip` varchar(64) DEFAULT '' COMMENT '最后登录 IP', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '后台管理员表' [ RunTime:0.000180s ]
  5. CREATE TABLE IF NOT EXISTS `nav_category` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `name` varchar(50) NOT NULL COMMENT '分类名称', `slug` varchar(64) NOT NULL COMMENT 'URL 标识(英文唯一别名)', `icon` varchar(255) DEFAULT '' COMMENT '分类图标', `color` varchar(64) DEFAULT '' COMMENT '分类图标颜色', `name_color` varchar(64) DEFAULT '' COMMENT '分类名称颜色', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '站点分类表' [ RunTime:0.000243s ]
  6. CREATE TABLE IF NOT EXISTS `nav_category_tag` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `category_id` int NOT NULL DEFAULT 0 COMMENT '所属一级分类', `name` varchar(50) NOT NULL COMMENT '标签名称', `slug` varchar(64) NOT NULL COMMENT 'URL 标识', `icon` varchar(255) DEFAULT '' COMMENT '图标', `name_color` varchar(64) DEFAULT '' COMMENT '标签名称颜色', `icon_color` varchar(64) DEFAULT '' COMMENT '标签图标颜色', `sort` int NOT NULL DEFAULT 0 COMMENT '排序,越大越前', `status` tinyint NOT NULL DEFAULT 1 COMMENT '1 显示 0 隐藏', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '站点分类二级标签表' [ RunTime:0.000179s ]
  7. CREATE TABLE IF NOT EXISTS `nav_site` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `category_id` int NOT NULL DEFAULT 0 COMMENT '所属分类 ID', `tag_id` int NOT NULL DEFAULT 0 COMMENT '二级标签 id', `name` varchar(100) NOT NULL COMMENT '站点名称', `slug` varchar(100) NOT NULL COMMENT 'URL 标识(英文唯一别名)', `url` varchar(500) DEFAULT '' COMMENT '站点访问地址', `icon` varchar(500) DEFAULT '' COMMENT '站点图标地址', `cover` varchar(500) DEFAULT '' COMMENT '封面图地址', `description` varchar(500) DEFAULT '' COMMENT '站点简介', `content` longtext COMMENT '站点详情内容(HTML)', `tags` varchar(255) DEFAULT '' COMMENT '标签(逗号分隔)', `badge` varchar(200) DEFAULT '' COMMENT '角标文字(如 推荐 / 新)', `badge_color` varchar(20) NOT NULL DEFAULT '' COMMENT '角标颜色', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `views` int NOT NULL DEFAULT 0 COMMENT '总浏览次数', `views_today` int NOT NULL DEFAULT 0 COMMENT '今日浏览次数', `views_date` int NOT NULL DEFAULT 0 COMMENT '今日浏览统计日期(YYYYMMDD)', `likes` int NOT NULL DEFAULT 0 COMMENT '点赞数', `is_featured` tinyint NOT NULL DEFAULT 0 COMMENT '是否精选(1 是 / 0 否)', `poster` tinyint NOT NULL DEFAULT 0 COMMENT '是否海报推荐位(1 是 / 0 否)', `is_pick` tinyint NOT NULL DEFAULT 0 COMMENT '是否站长推荐(1 是 / 0 否)', `hide_code` varchar(100) NOT NULL DEFAULT '' COMMENT '隐藏入口口令', `password` varchar(100) NOT NULL DEFAULT '' COMMENT '访问密码(留空不限制)', `type` varchar(50) NOT NULL DEFAULT 'web' COMMENT '站点类型(web 网站 / app 应用)', `platforms` varchar(200) NOT NULL DEFAULT '' COMMENT '支持平台(逗号分隔)', `downloads` longtext COMMENT '下载地址列表(JSON)', `version` varchar(50) NOT NULL DEFAULT '' COMMENT '版本号', `req` varchar(100) NOT NULL DEFAULT '' COMMENT '系统 / 环境要求', `sync_note` varchar(200) NOT NULL DEFAULT '' COMMENT '补全信息说明', `synced_at` datetime DEFAULT NULL COMMENT '最后补全信息时间', `feedback` longtext COMMENT '站点反馈说明', `feedback_status` tinyint NOT NULL DEFAULT 0 COMMENT '反馈处理状态 0 未处理 / 1 已处理', `feedback_time` int NOT NULL DEFAULT 0 COMMENT '最后反馈时间', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '站点表' [ RunTime:0.000247s ]
  8. CREATE TABLE IF NOT EXISTS `nav_like_log` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `type` varchar(50) NOT NULL DEFAULT 'site' COMMENT '点赞对象类型(site 站点 / article 文章 / comment 评论)', `target_id` int NOT NULL DEFAULT 0 COMMENT '关联对象 ID', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '点赞者 IP', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '匿名点赞日志表' [ RunTime:0.000215s ]
  9. CREATE TABLE IF NOT EXISTS `nav_site_view_day` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `site_id` int NOT NULL DEFAULT 0 COMMENT '站点 ID', `day` int NOT NULL DEFAULT 0 COMMENT '统计日期(YYYYMMDD)', `views` int NOT NULL DEFAULT 0 COMMENT '总热度(浏览 + 点击汇总)', `pv` int NOT NULL DEFAULT 0 COMMENT '详情页访问量', `clicks` int NOT NULL DEFAULT 0 COMMENT '外链点击次数', `views_m` int NOT NULL DEFAULT 0 COMMENT '手机端浏览数', `views_d` int NOT NULL DEFAULT 0 COMMENT '电脑端浏览数', `views_p` int NOT NULL DEFAULT 0 COMMENT '平板端浏览数', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '站点每日点击统计表' [ RunTime:0.000206s ]
  10. CREATE TABLE IF NOT EXISTS `nav_site_health` ( `site_id` int NOT NULL COMMENT '站点 ID(主键,与 site 一一对应)', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 未检测 / 1 正常 / 2 受限 / 3 异常)', `http_code` int NOT NULL DEFAULT 0 COMMENT 'HTTP 状态码(0 表示连接失败)', `resp_ms` int NOT NULL DEFAULT 0 COMMENT '响应耗时(毫秒)', `checked_at` int NOT NULL DEFAULT 0 COMMENT '最后检测时间(Unix 时间戳)', `fail_count` int NOT NULL DEFAULT 0 COMMENT '连续失败次数', `manual_status` tinyint NOT NULL DEFAULT 0 COMMENT '人工矫正状态(0 未矫正,其余同 status)', `manual_time` int NOT NULL DEFAULT 0 COMMENT '人工矫正时间(Unix 时间戳)', PRIMARY KEY (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '站点连通性检测结果表' [ RunTime:0.000173s ]
  11. CREATE TABLE IF NOT EXISTS `nav_article_cat` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `name` varchar(50) NOT NULL COMMENT '分类名称', `slug` varchar(64) NOT NULL COMMENT 'URL 标识(英文唯一别名)', `parent_id` int NOT NULL DEFAULT 0 COMMENT '上级分类 id,0=一级', `is_rec` tinyint NOT NULL DEFAULT 0 COMMENT '是否首页推荐(1 是 / 0 否)', `is_nav` tinyint NOT NULL DEFAULT 0 COMMENT '是否显示在导航(1 是 / 0 否)', `is_list` tinyint NOT NULL DEFAULT 0 COMMENT '是否显示在文章列表分类标签栏(1 是 / 0 否)', `icon` varchar(255) DEFAULT '' COMMENT '分类图标', `color` varchar(64) DEFAULT '' COMMENT '分类主题色', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '文章分类表' [ RunTime:0.000187s ]
  12. CREATE TABLE IF NOT EXISTS `nav_article_menu` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `parent_id` int NOT NULL DEFAULT 0, `type` varchar(10) NOT NULL DEFAULT 'cat', `cat_id` int NOT NULL DEFAULT 0, `title` varchar(50) NOT NULL DEFAULT '', `icon` varchar(255) DEFAULT '', `color` varchar(64) DEFAULT '', `title_color` varchar(64) DEFAULT '', `url` varchar(500) DEFAULT '', `target` varchar(10) NOT NULL DEFAULT '_self', `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `hide_in_parent` tinyint NOT NULL DEFAULT 0, `create_time` int NOT NULL DEFAULT 0, `update_time` int NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.000172s ]
  13. CREATE TABLE IF NOT EXISTS `nav_article` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `category_id` int NOT NULL DEFAULT 0 COMMENT '所属文章分类 ID', `title` varchar(200) NOT NULL COMMENT '文章标题', `cover` varchar(500) DEFAULT '' COMMENT '封面图地址', `summary` varchar(500) DEFAULT '' COMMENT '文章摘要', `content` longtext COMMENT '正文内容(HTML)', `tags` varchar(255) DEFAULT '' COMMENT '标签(逗号分隔)', `password` varchar(100) NOT NULL DEFAULT '' COMMENT '访问密码(留空不限制)', `author` varchar(50) DEFAULT '' COMMENT '作者名', `views` int NOT NULL DEFAULT 0 COMMENT '浏览次数', `likes` int NOT NULL DEFAULT 0 COMMENT '点赞数', `is_top` tinyint NOT NULL DEFAULT 0 COMMENT '是否置顶(1 是 / 0 否)', `is_recommend` tinyint NOT NULL DEFAULT 0 COMMENT '是否推荐(1 是 / 0 否)', `is_banner` tinyint NOT NULL DEFAULT 0 COMMENT '是否进入轮播(1 是 / 0 否)', `banner_img` varchar(500) DEFAULT '' COMMENT '轮播图地址', `banner_sub` varchar(200) DEFAULT '' COMMENT '轮播副标题', `banner_sort` int NOT NULL DEFAULT 0 COMMENT '轮播排序值(越大越靠前)', `tile_sort` int NOT NULL DEFAULT 0 COMMENT '首页磁贴排序值(越大越靠前)', `points_on` tinyint NOT NULL DEFAULT 0, `points_price` int NOT NULL DEFAULT 0, `dl_on` tinyint NOT NULL DEFAULT 0 COMMENT '是否开启下载区(1 开 / 0 关)', `dl_gate` varchar(20) NOT NULL DEFAULT 'public' COMMENT '下载门槛(comment 评论可见 / public 公开 / login 登录 / points 积分 / pay 付费)', `dl_price` varchar(20) NOT NULL DEFAULT '0' COMMENT '单篇下载价格(元)', `dl_vip` tinyint NOT NULL DEFAULT 0 COMMENT '是否会员免费(1 是 / 0 否)', `dl_vip_price` varchar(20) NOT NULL DEFAULT '' COMMENT '会员优惠价(元)', `dl_hours` int NOT NULL DEFAULT 0 COMMENT '解锁有效时长(小时,0 = 永久)', `dl_tip` varchar(200) NOT NULL DEFAULT '' COMMENT '下载区提示文案', `downloads` longtext COMMENT '下载项列表(JSON:平台 / 地址 / 提取码等)', `dl_count` int NOT NULL DEFAULT 0 COMMENT '下载点击次数', `comment_count` int NOT NULL DEFAULT 0 COMMENT '评论数量', `remark` varchar(255) DEFAULT '' COMMENT '后台备注(仅管理员可见)', `feedback` longtext COMMENT '读者反馈内容', `feedback_status` tinyint NOT NULL DEFAULT 0 COMMENT '反馈处理状态(0 未处理 / 1 已处理)', `feedback_time` int NOT NULL DEFAULT 0 COMMENT '反馈提交时间(Unix 时间戳)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 已发布 / 0 草稿 / -1 回收站)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '文章表' [ RunTime:0.000353s ]
  14. CREATE TABLE IF NOT EXISTS `nav_micro_post` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `content` varchar(500) NOT NULL COMMENT '微语内容', `author` varchar(50) DEFAULT '' COMMENT '发布者署名', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '微语表' [ RunTime:0.000177s ]
  15. CREATE TABLE IF NOT EXISTS `nav_notice` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `title` varchar(200) NOT NULL COMMENT '公告标题', `content` text COMMENT '公告内容', `type` varchar(50) DEFAULT 'info' COMMENT '公告类型(info 普通 / success 成功 / warning 警告)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '公告表' [ RunTime:0.000690s ]
  16. CREATE TABLE IF NOT EXISTS `nav_sponsor` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `site_id` int NOT NULL DEFAULT 0 COMMENT '关联站点 ID', `category_id` int NOT NULL DEFAULT 0 COMMENT '关联分类 ID', `tag_id` int NOT NULL DEFAULT 0 COMMENT '关联标签 ID', `name` varchar(100) NOT NULL COMMENT '赞助者名称', `url` varchar(500) DEFAULT '' COMMENT '赞助者链接', `icon` varchar(500) DEFAULT '' COMMENT '赞助者图标', `cover` varchar(500) DEFAULT '' COMMENT '封面图地址', `email` varchar(100) DEFAULT '' COMMENT '赞助者邮箱', `message` varchar(200) DEFAULT '' COMMENT '赞助留言', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '提交者 IP', `order_no` varchar(64) DEFAULT '' COMMENT '最近订单号', `pay_channel` varchar(20) DEFAULT '' COMMENT '支付渠道', `pay_trade_no` varchar(64) DEFAULT '' COMMENT '支付平台交易号', `pay_time` int NOT NULL DEFAULT 0 COMMENT '最近支付时间(Unix 时间戳)', `amount` int NOT NULL DEFAULT 0 COMMENT '累计赞助金额(元)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '赞助者表' [ RunTime:0.000212s ]
  17. CREATE TABLE IF NOT EXISTS `nav_sponsor_order` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `order_no` varchar(64) NOT NULL COMMENT '订单号', `sponsor_id` int NOT NULL DEFAULT 0 COMMENT '赞助者记录 ID', `site_id` int NOT NULL DEFAULT 0 COMMENT '关联站点 ID', `amount` int NOT NULL DEFAULT 0 COMMENT '实付金额(元)', `base_amount` int NOT NULL DEFAULT 0 COMMENT '赞助本金(元,不含收录等附加费)', `forever` tinyint NOT NULL DEFAULT 0 COMMENT '是否永久收录(1 是 / 0 否)', `include_site` tinyint NOT NULL DEFAULT 0 COMMENT '是否勾选收录站点(1 是 / 0 否)', `pay_channel` varchar(20) DEFAULT '' COMMENT '支付渠道', `pay_trade_no` varchar(64) DEFAULT '' COMMENT '支付平台交易号', `pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)', `remark` varchar(200) DEFAULT '' COMMENT '订单备注', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '下单 IP', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 未支付 / 1 已支付)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '赞助订单表' [ RunTime:0.000197s ]
  18. CREATE TABLE IF NOT EXISTS `nav_link` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `pid` int NOT NULL DEFAULT 0 COMMENT '上级链接 ID(0 = 顶级)', `position` varchar(50) NOT NULL DEFAULT 'top' COMMENT '显示位置(top 顶部 / footer 底部 等)', `name` varchar(50) NOT NULL COMMENT '链接名称', `name_color` varchar(50) DEFAULT '', `icon` varchar(255) DEFAULT '' COMMENT '链接图标', `url` varchar(500) DEFAULT '' COMMENT '链接地址', `description` varchar(200) DEFAULT '' COMMENT '链接描述', `badge` varchar(50) DEFAULT '' COMMENT '角标文字', `target` tinyint NOT NULL DEFAULT 0 COMMENT '打开方式(1 新窗口 / 0 当前窗口)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '导航链接表' [ RunTime:0.000200s ]
  19. CREATE TABLE IF NOT EXISTS `nav_submit` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `name` varchar(100) NOT NULL COMMENT '站点名称', `url` varchar(500) NOT NULL COMMENT '站点地址', `category_id` int NOT NULL DEFAULT 0 COMMENT '申请分类 ID', `tag_id` int NOT NULL DEFAULT 0 COMMENT '申请标签 ID', `icon` varchar(500) DEFAULT '' COMMENT '站点图标', `cover` varchar(500) DEFAULT '' COMMENT '封面图地址', `description` varchar(500) DEFAULT '' COMMENT '站点简介', `content` longtext COMMENT '站点详情内容', `tags` varchar(255) DEFAULT '' COMMENT '标签(逗号分隔)', `badge` varchar(200) DEFAULT '' COMMENT '角标文字', `contact` varchar(100) NOT NULL DEFAULT '' COMMENT '提交者联系方式', `remark` varchar(200) DEFAULT '' COMMENT '提交备注', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 待审核 / 1 已通过 / 2 已驳回)', `amount` decimal(10,2) NOT NULL DEFAULT 0 COMMENT '收录费用(元)', `order_no` varchar(64) DEFAULT '' COMMENT '付费订单号', `pay_method` varchar(50) DEFAULT '' COMMENT '支付方式', `pay_channel` varchar(20) DEFAULT '' COMMENT '支付渠道', `pay_trade_no` varchar(64) DEFAULT '' COMMENT '支付平台交易号', `pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)', `site_id` int NOT NULL DEFAULT 0 COMMENT '审核通过后生成的站点 ID', `audit_time` int NOT NULL DEFAULT 0 COMMENT '审核时间(Unix 时间戳)', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '提交者 IP', `user_id` int NOT NULL DEFAULT 0 COMMENT '提交用户 ID(0 = 游客)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '站点提交收录表' [ RunTime:0.000321s ]
  20. CREATE TABLE IF NOT EXISTS `nav_qlink` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `name` varchar(50) DEFAULT '' COMMENT '显示名称,留空自动取对象名称', `subtitle` varchar(200) DEFAULT '' COMMENT '副标题', `type` varchar(20) NOT NULL DEFAULT 'cat' COMMENT 'cat 分类 / site 站点 / url 链接', `folder_kind` varchar(20) DEFAULT '' COMMENT '文件夹样式类型', `folder_cats` varchar(500) DEFAULT '', `folder_sort` varchar(20) DEFAULT 'new', `folder_limit` int NOT NULL DEFAULT 0, `folder_cache` int NOT NULL DEFAULT 300, `folder_inc_sub` tinyint NOT NULL DEFAULT 0, `cat_id` int NOT NULL DEFAULT 0 COMMENT '关联分类 ID', `site_id` int NOT NULL DEFAULT 0 COMMENT '关联站点 ID', `url` varchar(500) DEFAULT '' COMMENT '自定义链接地址', `icon` varchar(500) DEFAULT '' COMMENT '图标地址', `extra` varchar(64) DEFAULT '' COMMENT '右侧小字', `cover` varchar(500) DEFAULT '' COMMENT '封面图地址', `bg_style` varchar(32) DEFAULT '' COMMENT '背景样式(CSS)', `name_color` varchar(32) DEFAULT '' COMMENT '名称文字颜色', `extra_color` varchar(32) DEFAULT '' COMMENT '小字文字颜色', `target` tinyint NOT NULL DEFAULT 0 COMMENT '打开方式(1 新窗口 / 0 当前窗口)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '桌面快捷链接表' [ RunTime:0.000203s ]
  21. CREATE TABLE IF NOT EXISTS `nav_qlink_item` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `qlink_id` int NOT NULL DEFAULT 0 COMMENT '所属快捷链接 ID', `kind` varchar(20) NOT NULL DEFAULT 'site' COMMENT '子项类型(site 站点 / cat 分类 / url 链接)', `ref_id` int NOT NULL DEFAULT 0 COMMENT '子项对象 ID', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '快捷链接子项表' [ RunTime:0.000156s ]
  22. CREATE TABLE IF NOT EXISTS `nav_ad` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `position` varchar(20) NOT NULL DEFAULT 'home_banner' COMMENT '广告位标识(如 home_banner / article_top)', `title` varchar(100) NOT NULL COMMENT '广告标题', `subtitle` varchar(200) DEFAULT '' COMMENT '广告副标题', `icon` varchar(500) DEFAULT '' COMMENT '图标地址', `image` varchar(500) DEFAULT '' COMMENT '背景图片地址', `url` varchar(500) DEFAULT '' COMMENT '点击跳转链接', `btn_text` varchar(50) DEFAULT '' COMMENT '按钮文字', `theme` varchar(20) DEFAULT '' COMMENT '主题风格标识', `badge` varchar(50) DEFAULT '' COMMENT '角标文字(如 热门 / 新)', `plan_id` int NOT NULL DEFAULT 0 COMMENT '关联广告套餐 ID', `months` int NOT NULL DEFAULT 1 COMMENT '购买时长(月)', `gift_days` int NOT NULL DEFAULT 0 COMMENT '赠送天数', `unit_price` decimal(10,2) NOT NULL DEFAULT 0 COMMENT '广告单价(元/月)', `amount` decimal(10,2) NOT NULL DEFAULT 0 COMMENT '订单金额(元)', `order_no` varchar(64) DEFAULT '' COMMENT '订单号', `pay_method` varchar(50) DEFAULT '' COMMENT '支付方式', `pay_channel` varchar(20) DEFAULT '' COMMENT '支付渠道', `pay_trade_no` varchar(64) DEFAULT '' COMMENT '支付平台交易号', `pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)', `start_time` int NOT NULL DEFAULT 0 COMMENT '投放开始时间(Unix 时间戳)', `end_time` int NOT NULL DEFAULT 0 COMMENT '投放结束时间(Unix 时间戳)', `audit_time` int NOT NULL DEFAULT 0 COMMENT '审核时间(Unix 时间戳)', `contact` varchar(100) NOT NULL DEFAULT '' COMMENT '联系人', `company` varchar(100) DEFAULT '' COMMENT '公司 / 主体名称', `remark` varchar(255) DEFAULT '' COMMENT '用户提交的备注', `admin_note` varchar(255) DEFAULT '' COMMENT '管理员审核备注', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 待审核 / 1 待付款 / 2 投放中 / 3 已驳回 / 4 已到期 / 5 已下架 / 6 已付款待审核)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `views` int NOT NULL DEFAULT 0 COMMENT '广告曝光次数', `clicks` int NOT NULL DEFAULT 0 COMMENT '广告点击次数', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '提交者 IP', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '广告位投放 / 申请记录表' [ RunTime:0.000236s ]
  23. CREATE TABLE IF NOT EXISTS `nav_ad_plan` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `name` varchar(50) NOT NULL COMMENT '套餐名称', `months` int NOT NULL DEFAULT 1 COMMENT '套餐时长(月)', `price` decimal(10,2) NOT NULL DEFAULT 0 COMMENT '套餐价格(元/月)', `gift_days` int NOT NULL DEFAULT 0 COMMENT '赠送天数', `position` varchar(20) NOT NULL DEFAULT 'home_banner' COMMENT '适用广告位标识', `description` varchar(255) DEFAULT '' COMMENT '套餐说明', `badge` varchar(50) DEFAULT '' COMMENT '角标文字', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 上架 / 0 下架)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '广告投放套餐表' [ RunTime:0.000205s ]
  24. CREATE TABLE IF NOT EXISTS `nav_friend_link` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `name` varchar(100) NOT NULL COMMENT '网站名称', `url` varchar(500) NOT NULL COMMENT '网站地址', `icon` varchar(500) DEFAULT '' COMMENT '网站图标地址', `name_color` varchar(64) DEFAULT '' COMMENT '友链名称颜色', `icon_color` varchar(64) DEFAULT '' COMMENT '友链图标颜色', `description` varchar(200) DEFAULT '' COMMENT '网站简介', `contact` varchar(100) NOT NULL DEFAULT '' COMMENT '联系方式', `remark` varchar(200) DEFAULT '' COMMENT '申请备注', `admin_note` varchar(200) DEFAULT '' COMMENT '管理员备注', `amount` decimal(10,2) NOT NULL DEFAULT 0 COMMENT '友链费用(元)', `order_no` varchar(64) DEFAULT '' COMMENT '付费订单号', `pay_method` varchar(50) DEFAULT '' COMMENT '支付方式', `pay_channel` varchar(20) DEFAULT '' COMMENT '支付渠道', `pay_trade_no` varchar(64) DEFAULT '' COMMENT '支付平台交易号', `pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)', `audit_time` int NOT NULL DEFAULT 0 COMMENT '审核时间(Unix 时间戳)', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 待审核 / 1 已通过 / 2 已驳回,是否付款看 pay_time)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '申请者 IP', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '友情链接申请表' [ RunTime:0.000194s ]
  25. CREATE TABLE IF NOT EXISTS `nav_dock` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `name` varchar(50) DEFAULT '' COMMENT '图标名称', `type` varchar(20) NOT NULL DEFAULT 'url' COMMENT '类型(url 自定义链接 / site 站点 / cat 分类 / tag 标签)', `site_id` int NOT NULL DEFAULT 0 COMMENT '关联站点 ID', `cat_id` int NOT NULL DEFAULT 0 COMMENT '关联分类 ID', `tag_id` int NOT NULL DEFAULT 0 COMMENT '关联标签 ID', `url` varchar(500) DEFAULT '' COMMENT '自定义链接地址', `icon` varchar(500) DEFAULT '' COMMENT '图标地址', `image` varchar(500) DEFAULT '' COMMENT '背景图片地址', `desc` varchar(500) DEFAULT '' COMMENT '描述文字', `extra` varchar(64) DEFAULT '' COMMENT '右下角小字 / 角标', `target` tinyint NOT NULL DEFAULT 0 COMMENT '打开方式(1 新窗口 / 0 当前窗口)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '桌面 Dock / 底栏图标表' [ RunTime:0.000334s ]
  26. CREATE TABLE IF NOT EXISTS `nav_plugin` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `slug` varchar(64) NOT NULL DEFAULT '' COMMENT '插件标识(英文唯一 key)', `type` varchar(20) NOT NULL DEFAULT 'local' COMMENT '插件类型(local 本地 / remote 远程)', `name` varchar(100) NOT NULL DEFAULT '' COMMENT '插件名称', `icon` varchar(100) NOT NULL DEFAULT '' COMMENT '插件图标(Bootstrap Icons 类名)', `icon_url` varchar(500) NOT NULL DEFAULT '' COMMENT '图标图片外链地址', `cover` varchar(500) NOT NULL DEFAULT '' COMMENT '封面图地址', `url` varchar(500) NOT NULL DEFAULT '' COMMENT '插件访问链接', `category` varchar(20) NOT NULL DEFAULT 'life' COMMENT '插件分类(life / tool 等)', `color` varchar(20) NOT NULL DEFAULT '' COMMENT '主题色', `badge` varchar(20) NOT NULL DEFAULT '' COMMENT '角标文字', `description` varchar(200) NOT NULL DEFAULT '' COMMENT '插件简介', `version` varchar(20) NOT NULL DEFAULT '' COMMENT '版本号', `backend` tinyint NOT NULL DEFAULT 0 COMMENT '是否有后台管理入口(1 是 / 0 否)', `need_login` tinyint NOT NULL DEFAULT 0 COMMENT '是否需要登录(1 是 / 0 否)', `points_cost` int NOT NULL DEFAULT 0 COMMENT '每次打开消耗积分', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '插件表' [ RunTime:0.000263s ]
  27. CREATE TABLE IF NOT EXISTS `nav_dypage` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `title` varchar(200) NOT NULL DEFAULT '' COMMENT '单页标题(也作页面 title)', `alias` varchar(64) NOT NULL DEFAULT '' COMMENT '别名,留空则用 id 访问', `template` varchar(50) NOT NULL DEFAULT 'wdhkbpage' COMMENT '模板:无导航空白模板', `content` longtext COMMENT '单页内容(HTML)', `referer_on` tinyint NOT NULL DEFAULT 1 COMMENT '是否开启 referer 校验', `referer_flag` varchar(255) NOT NULL DEFAULT '' COMMENT '来源判断标志(非必填)', `pwd_fail_on` tinyint NOT NULL DEFAULT 0 COMMENT '是否开启密码错误转发', `pwd_fail_url` varchar(500) NOT NULL DEFAULT '' COMMENT '密码错误转发链接(非必填)', `password` varchar(100) NOT NULL DEFAULT '' COMMENT '访问密码(非必填)', `password_tip` varchar(200) NOT NULL DEFAULT '' COMMENT '访问密码提示(非必填)', `owner` varchar(100) NOT NULL DEFAULT '' COMMENT '单页所属用户(非必填)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '自定义单页表' [ RunTime:0.000211s ]
  28. CREATE TABLE IF NOT EXISTS `nav_devphase` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `code` varchar(20) NOT NULL DEFAULT '' COMMENT '阶段标识(英文)', `name` varchar(200) NOT NULL DEFAULT '' COMMENT '阶段名称', `days_range` varchar(200) NOT NULL DEFAULT '' COMMENT '天数范围(如 1-30)', `icon` varchar(200) NOT NULL DEFAULT '' COMMENT '阶段图标', `note` varchar(500) NOT NULL DEFAULT '' COMMENT '阶段说明', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '开发阶段表' [ RunTime:0.000175s ]
  29. CREATE TABLE IF NOT EXISTS `nav_devlog` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `day` int NOT NULL DEFAULT 0 COMMENT '开发第几天(如 89)', `phase` varchar(20) NOT NULL DEFAULT 'start' COMMENT '所属阶段标识(对应 nav_devphase.code)', `title` varchar(200) NOT NULL DEFAULT '' COMMENT '日志标题', `summary` varchar(500) NOT NULL DEFAULT '' COMMENT '日志摘要', `items` longtext COMMENT '当日完成条目(JSON / 换行文本)', `tags` varchar(200) NOT NULL DEFAULT '' COMMENT '标签(逗号分隔)', `log_date` varchar(20) NOT NULL DEFAULT '' COMMENT '记录日期(Y-m-d)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '开发日志表' [ RunTime:0.000166s ]
  30. CREATE TABLE IF NOT EXISTS `nav_api_log` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0 COMMENT '用户ID', `api_type` int NOT NULL DEFAULT 0 COMMENT '套餐类型:1包月 2包点', `api_token` varchar(200) DEFAULT '' COMMENT 'API Token', `token_id` int NOT NULL DEFAULT 0 COMMENT 'Token ID', `token_name` varchar(200) DEFAULT '' COMMENT 'Token名称', `channel_key` varchar(50) DEFAULT '' COMMENT '渠道标识', `channel_name` varchar(100) DEFAULT '' COMMENT '渠道名称', `request_ip` varchar(64) DEFAULT '' COMMENT '请求IP', `request_data` longtext COMMENT '请求数据', `response_data` longtext COMMENT '响应数据', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态:0失败 1成功', `error_msg` longtext COMMENT '错误信息', `response_time` int NOT NULL DEFAULT 0 COMMENT '响应时间(ms)', `remark` varchar(200) DEFAULT '' COMMENT '备注', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'API 接口调用日志表' [ RunTime:0.000187s ]
  31. CREATE TABLE IF NOT EXISTS `nav_user` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `username` varchar(50) NOT NULL DEFAULT '' COMMENT '用户名', `email` varchar(100) NOT NULL DEFAULT '' COMMENT '邮箱', `phone` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号', `password` varchar(255) NOT NULL DEFAULT '' COMMENT '登录密码(哈希存储)', `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称', `avatar` varchar(500) NOT NULL DEFAULT '' COMMENT '头像地址', `level` tinyint NOT NULL DEFAULT 0 COMMENT '用户等级', `vip_expire` int NOT NULL DEFAULT 0 COMMENT '会员到期时间(Unix 时间戳,0 = 非会员)', `webmaster_expire` int NOT NULL DEFAULT 0 COMMENT '站长认证到期时间(Unix 时间戳)', `points` int NOT NULL DEFAULT 0 COMMENT '剩余积分', `email_verified` tinyint NOT NULL DEFAULT 0 COMMENT '邮箱是否已验证(1 是 / 0 否)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 正常 / 0 禁用)', `reg_ip` varchar(64) NOT NULL DEFAULT '' COMMENT '注册 IP', `last_login_ip` varchar(64) NOT NULL DEFAULT '' COMMENT '最后登录 IP', `last_login_time` int NOT NULL DEFAULT 0 COMMENT '最后登录时间(Unix 时间戳)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '前台用户表' [ RunTime:0.000207s ]
  32. CREATE TABLE IF NOT EXISTS `nav_user_token` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `token_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '登录令牌哈希', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '登录 IP', `ua` varchar(200) NOT NULL DEFAULT '' COMMENT '浏览器 UA', `expire_time` int NOT NULL DEFAULT 0 COMMENT '过期时间(Unix 时间戳)', `last_active` int NOT NULL DEFAULT 0 COMMENT '最后活跃时间(Unix 时间戳)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户登录令牌表' [ RunTime:0.000182s ]
  33. CREATE TABLE IF NOT EXISTS `nav_user_favorite` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `type` varchar(20) NOT NULL DEFAULT 'site' COMMENT '对象类型(site 站点 / article 文章)', `target_id` int NOT NULL DEFAULT 0 COMMENT '收藏对象 ID', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '操作 IP', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户收藏表' [ RunTime:0.000198s ]
  34. CREATE TABLE IF NOT EXISTS `nav_user_quick` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `url` varchar(500) NOT NULL DEFAULT '' COMMENT '快捷入口链接', `url_key` varchar(200) NOT NULL DEFAULT '' COMMENT '链接归一化键(去重 / 匹配用)', `title` varchar(100) NOT NULL DEFAULT '' COMMENT '显示标题', `icon` varchar(500) NOT NULL DEFAULT '' COMMENT '图标地址', `description` varchar(200) NOT NULL DEFAULT '' COMMENT '描述文字', `badge` varchar(20) NOT NULL DEFAULT '' COMMENT '角标文字', `platforms` varchar(100) NOT NULL DEFAULT '' COMMENT '支持平台(逗号分隔)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户快捷入口表' [ RunTime:0.000249s ]
  35. CREATE TABLE IF NOT EXISTS `nav_user_dock` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `source` varchar(20) NOT NULL DEFAULT 'custom' COMMENT '来源(custom 手动添加 / fav 收藏自动加入)', `type` varchar(20) NOT NULL DEFAULT 'url' COMMENT '类型(url 网址 / site 站点 / article 文章)', `target_id` int NOT NULL DEFAULT 0 COMMENT '关联对象 ID(站点 / 文章)', `url` varchar(500) NOT NULL DEFAULT '' COMMENT '跳转链接', `url_key` varchar(200) NOT NULL DEFAULT '' COMMENT '归一化去重键', `name` varchar(100) NOT NULL DEFAULT '' COMMENT '显示名称', `desc` varchar(200) NOT NULL DEFAULT '' COMMENT '描述文字', `icon` varchar(500) NOT NULL DEFAULT '' COMMENT '图标地址', `badge` varchar(20) NOT NULL DEFAULT '' COMMENT '角标文字', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(升序)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户 Dock 表' [ RunTime:0.000228s ]
  36. CREATE TABLE IF NOT EXISTS `nav_user_note` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `note_id` varchar(50) NOT NULL DEFAULT '' COMMENT '便签唯一标识(前端生成)', `title` varchar(200) NOT NULL DEFAULT '' COMMENT '便签标题', `content` longtext NULL COMMENT '便签内容', `color` varchar(64) NOT NULL DEFAULT '' COMMENT '便签颜色', `pinned` tinyint NOT NULL DEFAULT 0 COMMENT '是否固定(1 是 / 0 否)', `front` tinyint NOT NULL DEFAULT 0 COMMENT '是否置顶显示(1 是 / 0 否)', `fx` varchar(20) NOT NULL DEFAULT '' COMMENT '便签横向坐标', `fy` varchar(20) NOT NULL DEFAULT '' COMMENT '便签纵向坐标', `w` int NOT NULL DEFAULT 0 COMMENT '便签宽度', `h` int NOT NULL DEFAULT 0 COMMENT '便签高度', `created` bigint NOT NULL DEFAULT 0 COMMENT '创建时间(毫秒时间戳)', `updated` bigint NOT NULL DEFAULT 0 COMMENT '内容更新时间(毫秒时间戳)', `layout_updated` bigint NOT NULL DEFAULT 0 COMMENT '布局最后更新时间(毫秒时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '记录更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户便签表' [ RunTime:0.000233s ]
  37. CREATE TABLE IF NOT EXISTS `nav_fx_url` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `slug` varchar(32) NOT NULL DEFAULT '' COMMENT '自定义地址(全局唯一)', `title` varchar(200) NOT NULL DEFAULT '' COMMENT '标题(留空时取正文首行)', `content` longtext NULL COMMENT '正文(Markdown / 纯文本原文)', `fmt` varchar(10) NOT NULL DEFAULT 'md' COMMENT '格式(md / txt)', `pass_hash` varchar(255) NOT NULL DEFAULT '' COMMENT '访问密码哈希(password_hash,空 = 公开访问)', `pass_view` varchar(255) NOT NULL DEFAULT '' COMMENT '访问密码回显密文(AES-256-GCM / HMAC 流,仅作者可解密查看)', `edit_key_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '编辑密钥哈希(sha256,明文仅创建时返回一次)', `user_id` int NOT NULL DEFAULT 0 COMMENT '创建者用户 ID(0 = 匿名)', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '创建 IP', `views` int NOT NULL DEFAULT 0 COMMENT '访问次数', `view_time` int NOT NULL DEFAULT 0 COMMENT '最后预览时间(Unix 时间戳,0 = 还没人访问过)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 正常 / 0 已删除)', `notified` tinyint NOT NULL DEFAULT 0 COMMENT '发布通知标记(0 未通知 / 1 已通知,首次填写正文时通知管理员一次)', `expire_time` int NOT NULL DEFAULT 0 COMMENT '过期时间(Unix 时间戳,0 = 永久)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '云分享表' [ RunTime:0.000329s ]
  38. CREATE TABLE IF NOT EXISTS `nav_fx_report` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `fx_id` int NOT NULL DEFAULT 0 COMMENT '云分享 ID', `slug` varchar(32) NOT NULL DEFAULT '' COMMENT '云分享地址', `reason` varchar(100) NOT NULL DEFAULT '' COMMENT '举报原因', `note` varchar(500) NOT NULL DEFAULT '' COMMENT '补充说明', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '举报 IP', `status` tinyint NOT NULL DEFAULT 0 COMMENT '处理状态(0 待处理 / 1 已处理)', `create_time` int NOT NULL DEFAULT 0 COMMENT '举报时间', `update_time` int NOT NULL DEFAULT 0 COMMENT '处理时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '云分享举报表' [ RunTime:0.001047s ]
  39. CREATE TABLE IF NOT EXISTS `nav_user_theme` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `theme_id` varchar(50) NOT NULL DEFAULT '' COMMENT '主题唯一标识', `name` varchar(100) NOT NULL DEFAULT '' COMMENT '主题名称', `config` longtext NULL COMMENT '主题配置(JSON)', `created` bigint NOT NULL DEFAULT 0 COMMENT '创建时间(毫秒时间戳)', `updated` bigint NOT NULL DEFAULT 0 COMMENT '更新时间(毫秒时间戳)', `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '是否已删除(1 已删除)', `update_time` int NOT NULL DEFAULT 0 COMMENT '记录更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户主题配置表' [ RunTime:0.000307s ]
  40. CREATE TABLE IF NOT EXISTS `nav_user_like` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `type` varchar(20) NOT NULL DEFAULT 'site' COMMENT '对象类型(site 站点 / article 文章 / comment 评论)', `target_id` int NOT NULL DEFAULT 0 COMMENT '点赞对象 ID', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '操作 IP', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户点赞表' [ RunTime:0.000251s ]
  41. CREATE TABLE IF NOT EXISTS `nav_user_email_code` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `email` varchar(100) NOT NULL DEFAULT '' COMMENT '目标邮箱', `scene` varchar(20) NOT NULL DEFAULT 'register' COMMENT '使用场景(register 注册 / login 登录 / reset 重置密码)', `code_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '验证码哈希', `attempts` tinyint NOT NULL DEFAULT 0 COMMENT '已尝试验证次数', `used` tinyint NOT NULL DEFAULT 0 COMMENT '是否已使用(1 是 / 0 否)', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '请求 IP', `expire_time` int NOT NULL DEFAULT 0 COMMENT '过期时间(Unix 时间戳)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '邮箱验证码表' [ RunTime:0.000772s ]
  42. CREATE TABLE IF NOT EXISTS `nav_user_history` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `type` varchar(20) NOT NULL DEFAULT 'site' COMMENT '对象类型(site 站点 / article 文章)', `target_id` int NOT NULL DEFAULT 0 COMMENT '浏览对象 ID', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '用户浏览历史表' [ RunTime:0.000234s ]
  43. CREATE TABLE IF NOT EXISTS `nav_invite_code` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `code` varchar(64) NOT NULL DEFAULT '' COMMENT '邀请码', `batch` varchar(50) NOT NULL DEFAULT '' COMMENT '生成批次号', `remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 未使用 / 1 已使用)', `user_id` int NOT NULL DEFAULT 0 COMMENT '使用者用户 ID', `used_time` int NOT NULL DEFAULT 0 COMMENT '使用时间(Unix 时间戳)', `expire_time` int NOT NULL DEFAULT 0 COMMENT '过期时间(Unix 时间戳)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '邀请码表' [ RunTime:0.000180s ]
  44. CREATE TABLE IF NOT EXISTS `nav_invite_order` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `order_no` varchar(64) NOT NULL DEFAULT '' COMMENT '订单号', `price` varchar(20) NOT NULL DEFAULT '0' COMMENT '订单金额(元)', `status` tinyint NOT NULL DEFAULT 0 COMMENT '支付状态(0 未支付 / 1 已支付)', `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `email` varchar(100) NOT NULL DEFAULT '' COMMENT '购买者邮箱', `trade_no` varchar(100) NOT NULL DEFAULT '' COMMENT '支付平台交易号', `pay_channel` varchar(20) NOT NULL DEFAULT '' COMMENT '支付渠道', `invite_code` varchar(64) NOT NULL DEFAULT '' COMMENT '发放的邀请码', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '下单 IP', `pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)', `expire_time` int NOT NULL DEFAULT 0 COMMENT '邀请码有效期(Unix 时间戳)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '邀请码购买订单表' [ RunTime:0.000190s ]
  45. CREATE TABLE IF NOT EXISTS `nav_member_plan` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `type` varchar(20) NOT NULL DEFAULT 'vip' COMMENT '套餐类型(vip 会员 / points 积分)', `name` varchar(100) NOT NULL DEFAULT '' COMMENT '套餐名称', `months` int NOT NULL DEFAULT 0 COMMENT '时长(月)', `days` int NOT NULL DEFAULT 0 COMMENT '时长(天)', `price` varchar(20) NOT NULL DEFAULT '0' COMMENT '价格(元)', `gift_days` int NOT NULL DEFAULT 0 COMMENT '赠送天数', `badge` varchar(20) NOT NULL DEFAULT '' COMMENT '角标文字', `description` varchar(200) NOT NULL DEFAULT '' COMMENT '套餐说明', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '会员套餐表' [ RunTime:0.000202s ]
  46. CREATE TABLE IF NOT EXISTS `nav_points_pack` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `name` varchar(100) NOT NULL DEFAULT '' COMMENT '套餐名称', `points` int NOT NULL DEFAULT 0 COMMENT '积分数量', `bonus` int NOT NULL DEFAULT 0 COMMENT '赠送积分', `price` varchar(20) NOT NULL DEFAULT '0' COMMENT '价格(元)', `badge` varchar(20) NOT NULL DEFAULT '' COMMENT '角标文字', `description` varchar(200) NOT NULL DEFAULT '' COMMENT '套餐说明', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '积分充值套餐表' [ RunTime:0.000164s ]
  47. CREATE TABLE IF NOT EXISTS `nav_member_order` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `order_no` varchar(64) NOT NULL DEFAULT '' COMMENT '订单号', `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `type` varchar(20) NOT NULL DEFAULT 'vip' COMMENT '订单类型(vip 会员 / points 积分)', `plan_id` int NOT NULL DEFAULT 0 COMMENT '套餐 ID', `title` varchar(100) NOT NULL DEFAULT '' COMMENT '套餐标题快照', `amount` varchar(20) NOT NULL DEFAULT '0' COMMENT '订单金额(元)', `months` int NOT NULL DEFAULT 0 COMMENT '开通时长(月)', `days` int NOT NULL DEFAULT 0 COMMENT '开通天数', `points` int NOT NULL DEFAULT 0 COMMENT '充值积分数量', `bonus` int NOT NULL DEFAULT 0 COMMENT '赠送积分数量', `status` tinyint NOT NULL DEFAULT 0 COMMENT '支付状态(0 未支付 / 1 已支付 / 2 已关闭)', `pay_channel` varchar(20) NOT NULL DEFAULT '' COMMENT '支付渠道', `trade_no` varchar(64) NOT NULL DEFAULT '' COMMENT '支付平台交易号', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '下单 IP', `remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注', `pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)', `expire_time` int NOT NULL DEFAULT 0 COMMENT '会员到期时间(Unix 时间戳)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '会员 / 积分充值订单表' [ RunTime:0.000202s ]
  48. CREATE TABLE IF NOT EXISTS `nav_points_log` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `delta` int NOT NULL DEFAULT 0 COMMENT '积分变动值(正数增加 / 负数扣减)', `before_points` int NOT NULL DEFAULT 0 COMMENT '变动前积分余额', `after_points` int NOT NULL DEFAULT 0 COMMENT '变动后积分余额', `type` varchar(20) NOT NULL DEFAULT '' COMMENT '变动类型(如 recharge 充值 / cost 消费 / admin 后台调整)', `ref` varchar(64) NOT NULL DEFAULT '' COMMENT '关联业务单号 / 标识', `remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '操作 IP', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '积分变动流水表' [ RunTime:0.000194s ]
  49. CREATE TABLE IF NOT EXISTS `nav_article_points_unlock` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0, `article_id` int NOT NULL DEFAULT 0, `points` int NOT NULL DEFAULT 0, `ip` varchar(64) NOT NULL DEFAULT '', `create_time` int NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.000158s ]
  50. CREATE TABLE IF NOT EXISTS `nav_points_signin` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0, `day` varchar(20) NOT NULL DEFAULT '', `ip` varchar(64) NOT NULL DEFAULT '', `device_hash` varchar(64) NOT NULL DEFAULT '', `create_time` int NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.000163s ]
  51. CREATE TABLE IF NOT EXISTS `nav_dl_ticket` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `sig` varchar(64) NOT NULL DEFAULT '', `user_id` int NOT NULL DEFAULT 0, `article_id` int NOT NULL DEFAULT 0, `item` int NOT NULL DEFAULT 0, `expire_time` int NOT NULL DEFAULT 0, `create_time` int NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.000225s ]
  52. CREATE TABLE IF NOT EXISTS `nav_pkg_key_log` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `ticket_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '访问票据哈希', `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `slug` varchar(64) NOT NULL DEFAULT '' COMMENT '资源包标识', `kind` varchar(20) NOT NULL DEFAULT 'anon' COMMENT '访问者类型(anon 游客 / user 登录用户)', `bucket` varchar(64) NOT NULL DEFAULT '' COMMENT '频率限制桶标识', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT 'IP 地址', `ip_hash` varchar(64) NOT NULL DEFAULT '' COMMENT 'IP 哈希(脱敏)', `points` int NOT NULL DEFAULT 0 COMMENT '本次消耗积分', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '资源包访问密钥日志表' [ RunTime:0.000163s ]
  53. CREATE TABLE IF NOT EXISTS `nav_secret_post` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `content` varchar(500) NOT NULL DEFAULT '' COMMENT '树洞内容', `mood` varchar(20) NOT NULL DEFAULT 'heart' COMMENT '心情标识(heart / smile 等)', `site_id` int NOT NULL DEFAULT 0 COMMENT '关联站点 ID(0 = 全站)', `content_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '内容哈希(用于重复提交判断)', `anon_name` varchar(50) NOT NULL DEFAULT '' COMMENT '匿名昵称', `anon_avatar` varchar(20) NOT NULL DEFAULT '' COMMENT '匿名头像标识', `anon_color` varchar(20) NOT NULL DEFAULT '' COMMENT '匿名头像配色', `region` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP 归属地区', `ip_hash` varchar(64) NOT NULL DEFAULT '' COMMENT 'IP 哈希(脱敏)', `device_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '设备指纹哈希', `user_id` int NOT NULL DEFAULT 0 COMMENT '发布者用户 ID(0 = 游客)', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 待审核 / 1 已发布 / 2 未通过 / 3 已隐藏)', `likes` int NOT NULL DEFAULT 0 COMMENT '点赞数', `reports` int NOT NULL DEFAULT 0 COMMENT '被举报次数', `is_top` tinyint NOT NULL DEFAULT 0 COMMENT '是否置顶(1 是 / 0 否)', `audit_note` varchar(200) NOT NULL DEFAULT '' COMMENT '审核备注', `audit_time` int NOT NULL DEFAULT 0 COMMENT '审核时间(Unix 时间戳)', `audit_admin` varchar(50) NOT NULL DEFAULT '' COMMENT '审核管理员账号', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '匿名树洞内容表' [ RunTime:0.000191s ]
  54. CREATE TABLE IF NOT EXISTS `nav_secret_report` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `post_id` int NOT NULL DEFAULT 0 COMMENT '被举报的树洞内容 ID', `reason` varchar(50) NOT NULL DEFAULT '' COMMENT '举报原因', `note` varchar(255) NOT NULL DEFAULT '' COMMENT '补充说明', `ip_hash` varchar(64) NOT NULL DEFAULT '' COMMENT 'IP 哈希(脱敏)', `device_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '设备指纹哈希', `status` tinyint NOT NULL DEFAULT 0 COMMENT '处理状态(0 未处理 / 1 已处理)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '树洞举报表' [ RunTime:0.000160s ]
  55. CREATE TABLE IF NOT EXISTS `nav_comment` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `page_key` varchar(64) NOT NULL DEFAULT '' COMMENT '评论对象标识(如 site-12 / article-8)', `page_title` varchar(200) NOT NULL DEFAULT '' COMMENT '评论页面标题', `root_id` int NOT NULL DEFAULT 0 COMMENT '顶级评论 ID(0 = 一级评论)', `parent_id` int NOT NULL DEFAULT 0 COMMENT '被回复的评论 ID(0 = 直接评论)', `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `is_admin` tinyint NOT NULL DEFAULT 0 COMMENT '是否管理员身份(1 是 / 0 否)', `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '评论者昵称', `email_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '邮箱哈希(脱敏,用于识别同一评论者)', `avatar` varchar(500) NOT NULL DEFAULT '' COMMENT '评论者头像地址', `level` tinyint NOT NULL DEFAULT 1 COMMENT '评论者用户等级', `content` longtext COMMENT '评论内容', `reply_to_name` varchar(50) NOT NULL DEFAULT '' COMMENT '被回复者昵称', `region` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP 归属地区', `ip_hash` varchar(64) NOT NULL DEFAULT '' COMMENT 'IP 哈希(脱敏)', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '评论者 IP', `device_hash` varchar(64) NOT NULL DEFAULT '' COMMENT '设备指纹哈希', `os_name` varchar(50) NOT NULL DEFAULT '' COMMENT '操作系统名称', `os_icon` varchar(100) NOT NULL DEFAULT '' COMMENT '操作系统图标', `browser_name` varchar(50) NOT NULL DEFAULT '' COMMENT '浏览器名称', `browser_icon` varchar(100) NOT NULL DEFAULT '' COMMENT '浏览器图标', `likes` int NOT NULL DEFAULT 0 COMMENT '点赞数', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态(0 待审核 / 1 已发布 / 2 未通过 / 3 已删除)', `is_top` tinyint NOT NULL DEFAULT 0 COMMENT '是否置顶(1 是 / 0 否)', `audit_note` varchar(200) NOT NULL DEFAULT '' COMMENT '审核备注', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '评论表' [ RunTime:0.000241s ]
  56. CREATE TABLE IF NOT EXISTS `nav_right_menu` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `name` varchar(100) NOT NULL DEFAULT '' COMMENT '菜单名称', `scope_type` varchar(50) NOT NULL DEFAULT 'site' COMMENT '作用范围类型(site 站点 / app 软件 / article 文章 / folder 文件夹 / any 兜底,多个用逗号分隔)', `scope_value` varchar(64) NOT NULL DEFAULT '' COMMENT '作用范围取值', `pages` varchar(200) NOT NULL DEFAULT '' COMMENT '生效页面(逗号分隔)', `priority` int NOT NULL DEFAULT 0 COMMENT '优先级(越大越优先)', `enabled` tinyint NOT NULL DEFAULT 1 COMMENT '是否启用(1 是 / 0 否)', `item_count` int NOT NULL DEFAULT 0 COMMENT '菜单项数量', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '右侧悬浮菜单表' [ RunTime:0.000302s ]
  57. CREATE TABLE IF NOT EXISTS `nav_right_menu_item` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `rid` int NOT NULL DEFAULT 0 COMMENT '所属菜单 ID', `pid` int NOT NULL DEFAULT 0 COMMENT '上级菜单项 ID(0 = 顶级)', `label` varchar(50) NOT NULL DEFAULT '' COMMENT '显示文字', `icon` varchar(500) NOT NULL DEFAULT '' COMMENT '图标(类名或图片地址)', `action` varchar(20) NOT NULL DEFAULT 'link' COMMENT '动作类型(link 链接 / js 脚本 / api 接口)', `target` longtext COMMENT '动作目标(链接地址 / JS 代码 / 接口参数)', `newtab` tinyint NOT NULL DEFAULT 0 COMMENT '是否新窗口打开(1 是 / 0 否)', `roles` varchar(20) NOT NULL DEFAULT 'all' COMMENT '可见角色(all 全部 / user 登录 / vip 会员 / admin 管理员)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `enabled` tinyint NOT NULL DEFAULT 1 COMMENT '是否启用(1 是 / 0 否)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '右侧菜单项表' [ RunTime:0.000234s ]
  58. CREATE TABLE IF NOT EXISTS `nav_home_module` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `mkey` varchar(64) NOT NULL DEFAULT '' COMMENT '模块标识(英文 key)', `zone` varchar(20) NOT NULL DEFAULT 'main' COMMENT '所在区域(main 主区 / side 侧栏)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `visible` tinyint NOT NULL DEFAULT 1 COMMENT '是否显示(1 是 / 0 否)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '首页模块排序 / 显示配置表' [ RunTime:0.000207s ]
  59. CREATE TABLE IF NOT EXISTS `nav_home_block` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `title` varchar(50) NOT NULL DEFAULT '' COMMENT '区块标题', `icon` varchar(50) NOT NULL DEFAULT 'bi-image' COMMENT '区块图标', `type` varchar(20) NOT NULL DEFAULT 'manual' COMMENT '内容来源(manual 手动 / auto 自动)', `strategy` varchar(20) NOT NULL DEFAULT 'fixed' COMMENT '展示方式(fixed 固定 / scroll 自动滚动)', `rank_type` varchar(20) NOT NULL DEFAULT 'hot' COMMENT '排行类型(hot 热门 / new 最新 / like 点赞)', `rank_period` varchar(20) NOT NULL DEFAULT 'week' COMMENT '排行周期(day 日 / week 周 / month 月)', `total` int NOT NULL DEFAULT 3 COMMENT '区块内容总条数', `per_view` int NOT NULL DEFAULT 1 COMMENT '每屏显示条数', `interval` int NOT NULL DEFAULT 5 COMMENT '自动切换间隔(秒)', `pause_hover` tinyint NOT NULL DEFAULT 1 COMMENT '鼠标悬停是否暂停(1 是 / 0 否)', `show_dots` tinyint NOT NULL DEFAULT 1 COMMENT '是否显示指示点(1 是 / 0 否)', `transition` varchar(10) NOT NULL DEFAULT 'fade' COMMENT '切换动画(fade 淡入 / slide 滑动)', `mobile_mode` varchar(20) NOT NULL DEFAULT 'auto' COMMENT '移动端展示模式(auto 自适应 等)', `scope` varchar(20) NOT NULL DEFAULT 'all' COMMENT '作用范围(all 全站 / site 站点 / article 文章)', `more_url` varchar(500) NOT NULL DEFAULT '' COMMENT '「更多」跳转链接', `more_text` varchar(50) NOT NULL DEFAULT '更多' COMMENT '「更多」按钮文字', `note_text` varchar(500) NOT NULL DEFAULT '' COMMENT '公告 / 跑马灯文字', `note_author` varchar(50) NOT NULL DEFAULT '' COMMENT '公告署名', `note_items` longtext DEFAULT NULL COMMENT '公告条目列表(JSON)', `audience` varchar(20) NOT NULL DEFAULT 'all' COMMENT '展示人群(all 全部 / guest 游客 / user 登录用户 / vip 会员)', `ab_enable` tinyint NOT NULL DEFAULT 0 COMMENT '是否开启 AB 测试(1 是 / 0 否)', `ab_ratio` int NOT NULL DEFAULT 50 COMMENT 'AB 测试分流比例(0-100,A 组百分比)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `start_time` int NOT NULL DEFAULT 0 COMMENT '生效开始时间(Unix 时间戳)', `end_time` int NOT NULL DEFAULT 0 COMMENT '生效结束时间(Unix 时间戳)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '首页区块配置表' [ RunTime:0.000227s ]
  60. CREATE TABLE IF NOT EXISTS `nav_home_pic` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `block_id` int NOT NULL DEFAULT 0 COMMENT '所属轮播区块 ID', `type` varchar(20) NOT NULL DEFAULT 'manual' COMMENT '内容来源(manual 手动 / auto 自动)', `source_id` int NOT NULL DEFAULT 0 COMMENT '关联内容 ID(自动取数时用)', `weight` int NOT NULL DEFAULT 0 COMMENT '权重(越大越靠前)', `title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题', `subtitle` varchar(200) NOT NULL DEFAULT '' COMMENT '副标题', `image` varchar(500) NOT NULL DEFAULT '' COMMENT '电脑端图片地址', `image_m` varchar(500) NOT NULL DEFAULT '' COMMENT '移动端图片地址', `url` varchar(500) NOT NULL DEFAULT '' COMMENT '点击跳转链接', `badge` varchar(50) NOT NULL DEFAULT '' COMMENT '角标文字', `is_ad` tinyint NOT NULL DEFAULT 0 COMMENT '是否广告位(1 是 / 0 否)', `scope` varchar(20) NOT NULL DEFAULT 'all' COMMENT '作用范围(all 全站 / site 站点 / article 文章)', `target` tinyint NOT NULL DEFAULT 0 COMMENT '打开方式(1 新窗口 / 0 当前窗口)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `start_time` int NOT NULL DEFAULT 0 COMMENT '生效开始时间(Unix 时间戳)', `end_time` int NOT NULL DEFAULT 0 COMMENT '生效结束时间(Unix 时间戳)', `is_countdown` tinyint NOT NULL DEFAULT 0 COMMENT '是否显示倒计时(1 是 / 0 否)', `is_video` tinyint NOT NULL DEFAULT 0 COMMENT '是否视频背景(1 是 / 0 否)', `views` int NOT NULL DEFAULT 0 COMMENT '浏览次数', `clicks` int NOT NULL DEFAULT 0 COMMENT '点击次数', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '首页轮播图 / 焦点图表' [ RunTime:0.000219s ]
  61. CREATE TABLE IF NOT EXISTS `nav_home_pic_stat` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `pic_id` int NOT NULL DEFAULT 0 COMMENT '轮播图 ID', `day` int NOT NULL DEFAULT 0 COMMENT '统计日期(YYYYMMDD)', `views` int NOT NULL DEFAULT 0 COMMENT '浏览次数', `clicks` int NOT NULL DEFAULT 0 COMMENT '点击次数', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '首页轮播图统计表' [ RunTime:0.000217s ]
  62. CREATE TABLE IF NOT EXISTS `nav_home_block_stat` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `block_id` int NOT NULL DEFAULT 0 COMMENT '所属区块 ID', `day` int NOT NULL DEFAULT 0 COMMENT '统计日期(YYYYMMDD)', `grp` varchar(10) NOT NULL DEFAULT 'a' COMMENT 'AB 测试分组(a / b)', `exposes` int NOT NULL DEFAULT 0 COMMENT '曝光次数', `clicks` int NOT NULL DEFAULT 0 COMMENT '点击次数', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '首页区块曝光 / 点击统计表' [ RunTime:0.000162s ]
  63. CREATE TABLE IF NOT EXISTS `nav_shijuan_subject` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `slug` varchar(50) NOT NULL COMMENT 'URL 标识(英文唯一别名)', `name` varchar(100) NOT NULL COMMENT '科目名称', `icon` varchar(255) NOT NULL DEFAULT '' COMMENT '科目图标', `total` int NOT NULL DEFAULT 0 COMMENT '资源总数', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '试卷科目表' [ RunTime:0.001097s ]
  64. CREATE TABLE IF NOT EXISTS `nav_shijuan_category` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `subject_slug` varchar(50) NOT NULL DEFAULT '' COMMENT '所属科目标识(对应 nav_shijuan_subject.slug)', `slug` varchar(50) NOT NULL COMMENT 'URL 标识(英文唯一别名)', `name` varchar(100) NOT NULL COMMENT '分类名称', `icon` varchar(255) NOT NULL DEFAULT '' COMMENT '分类图标', `typeid` varchar(20) NOT NULL DEFAULT '' COMMENT '源站分类 ID', `total` int NOT NULL DEFAULT 0 COMMENT '资源总数', `meta_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO 标题', `meta_keywords` varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO 关键词', `meta_description` varchar(500) NOT NULL DEFAULT '' COMMENT 'SEO 描述', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '试卷资源分类表' [ RunTime:0.001391s ]
  65. CREATE TABLE IF NOT EXISTS `nav_shijuan_item` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `cat` varchar(50) NOT NULL DEFAULT '' COMMENT '所属分类标识(对应 nav_shijuan_category.slug)', `item_id` int NOT NULL DEFAULT 0 COMMENT '源站资源 ID', `title` varchar(255) NOT NULL DEFAULT '' COMMENT '资源标题', `type` varchar(20) NOT NULL DEFAULT '' COMMENT '资源类型', `grade` varchar(50) NOT NULL DEFAULT '' COMMENT '适用年级', `version` varchar(100) NOT NULL DEFAULT '' COMMENT '教材版本', `size` varchar(20) NOT NULL DEFAULT '' COMMENT '文件大小', `pub_date` varchar(20) NOT NULL DEFAULT '' COMMENT '发布时间', `img` varchar(255) NOT NULL DEFAULT '' COMMENT '缩略图地址', `file` varchar(500) NOT NULL DEFAULT '' COMMENT '文件地址', `license` varchar(20) NOT NULL DEFAULT 'free' COMMENT '授权类型(free 免费 / vip 会员)', `rtype` varchar(50) NOT NULL DEFAULT '试题试卷' COMMENT '资源分类名称(如 试题试卷)', `intro` longtext COMMENT '资源简介', `notice` longtext COMMENT '下载提示', `feedback` longtext COMMENT '反馈内容', `feedback_status` tinyint NOT NULL DEFAULT 0 COMMENT '反馈处理状态(0 未处理 / 1 已处理)', `feedback_time` int NOT NULL DEFAULT 0 COMMENT '反馈提交时间(Unix 时间戳)', `images` longtext COMMENT '图片地址列表(JSON)', `meta_json` longtext COMMENT '扩展元数据(JSON)', `source` varchar(255) NOT NULL DEFAULT '' COMMENT '来源站地址', `prev_id` int NOT NULL DEFAULT 0 COMMENT '上一篇资源 ID', `next_id` int NOT NULL DEFAULT 0 COMMENT '下一篇资源 ID', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态(1 启用 / 0 禁用)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '试卷资源表' [ RunTime:0.000361s ]
  66. CREATE TABLE IF NOT EXISTS `nav_shijuan_download` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `item_id` int NOT NULL DEFAULT 0 COMMENT '所属试卷资源 ID', `name` varchar(100) NOT NULL DEFAULT '' COMMENT '下载项名称', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '下载地址', `sort` int NOT NULL DEFAULT 0 COMMENT '排序值(越大越靠前)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '试卷下载项表' [ RunTime:0.000177s ]
  67. CREATE TABLE IF NOT EXISTS `nav_article_dl_unlock` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `article_id` int NOT NULL DEFAULT 0 COMMENT '文章 ID', `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `email` varchar(100) NOT NULL DEFAULT '' COMMENT '解锁邮箱(游客解锁用)', `method` varchar(20) NOT NULL DEFAULT '' COMMENT '解锁方式(login / email / points / pay / comment 等)', `order_no` varchar(64) NOT NULL DEFAULT '' COMMENT '关联付费订单号', `token` varchar(64) NOT NULL DEFAULT '' COMMENT '解锁令牌', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '解锁 IP', `expire_time` int NOT NULL DEFAULT 0 COMMENT '解锁过期时间(Unix 时间戳,0 = 永久)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '文章下载解锁记录表' [ RunTime:0.000199s ]
  68. CREATE TABLE IF NOT EXISTS `nav_article_dl_order` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `order_no` varchar(64) NOT NULL DEFAULT '' COMMENT '订单号', `article_id` int NOT NULL DEFAULT 0 COMMENT '文章 ID', `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `email` varchar(100) NOT NULL DEFAULT '' COMMENT '下单邮箱(游客下单用)', `amount` varchar(20) NOT NULL DEFAULT '0' COMMENT '订单金额(元)', `status` tinyint NOT NULL DEFAULT 0 COMMENT '支付状态(0 未支付 / 1 已支付)', `channel` varchar(20) NOT NULL DEFAULT '' COMMENT '支付渠道', `trade_no` varchar(100) NOT NULL DEFAULT '' COMMENT '支付平台交易号', `token` varchar(64) NOT NULL DEFAULT '' COMMENT '解锁令牌', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '下单 IP', `pay_time` int NOT NULL DEFAULT 0 COMMENT '支付时间(Unix 时间戳)', `expire_time` int NOT NULL DEFAULT 0 COMMENT '解锁过期时间(Unix 时间戳)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)', `update_time` int NOT NULL DEFAULT 0 COMMENT '更新时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '文章付费下载订单表' [ RunTime:0.000172s ]
  69. CREATE TABLE IF NOT EXISTS `nav_article_dl_quota_log` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `article_id` int NOT NULL DEFAULT 0 COMMENT '文章 ID', `period_key` varchar(20) NOT NULL DEFAULT '' COMMENT '额度周期标识(如 2026-11 或 20261116)', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '文章下载额度日志表' [ RunTime:0.000179s ]
  70. CREATE TABLE IF NOT EXISTS `nav_article_dl_log` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键 ID', PRIMARY KEY (`id`), `article_id` int NOT NULL DEFAULT 0 COMMENT '文章 ID', `download_index` int NOT NULL DEFAULT 0 COMMENT '下载项序号(从 0 开始)', `user_id` int NOT NULL DEFAULT 0 COMMENT '用户 ID', `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '下载者 IP', `create_time` int NOT NULL DEFAULT 0 COMMENT '创建时间(Unix 时间戳)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT '文章下载点击日志表' [ RunTime:0.000196s ]
  71. SELECT COUNT(*) AS `c` FROM `nav_devphase` [ RunTime:0.000182s ]
  72. SELECT COUNT(*) AS `c` FROM `nav_devlog` [ RunTime:0.000200s ]
  73. SELECT `k`,`v` FROM `nav_setting` WHERE `k` IN ('ad_banner_total','ad_slots') [ RunTime:0.000187s ]
  74. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_on','1','1795250312') [ RunTime:0.000240s ]
  75. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_free_audit','0','1795250312') [ RunTime:0.000305s ]
  76. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_price','0','1795250312') [ RunTime:0.000191s ]
  77. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_force_pay','0','1795250312') [ RunTime:0.000160s ]
  78. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_pay_audit','0','1795250312') [ RunTime:0.000301s ]
  79. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_on','1','1795250312') [ RunTime:0.000151s ]
  80. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_price_month','0','1795250312') [ RunTime:0.000152s ]
  81. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_free_audit','0','1795250312') [ RunTime:0.000928s ]
  82. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_free_months','1','1795250312') [ RunTime:0.000198s ]
  83. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_require_mark','1','1795250312') [ RunTime:0.000233s ]
  84. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_contact','','1795250312') [ RunTime:0.000222s ]
  85. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_rows','2','1795250312') [ RunTime:0.000156s ]
  86. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_cols','1','1795250312') [ RunTime:0.001791s ]
  87. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_total','24','1795250312') [ RunTime:0.000322s ]
  88. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_rows','2','1795250312') [ RunTime:0.000212s ]
  89. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_cols','9','1795250312') [ RunTime:0.000168s ]
  90. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_total','24','1795250312') [ RunTime:0.000355s ]
  91. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_price','0','1795250312') [ RunTime:0.000310s ]
  92. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('featured_cols','7','1795250312') [ RunTime:0.000208s ]
  93. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('featured_total','14','1795250312') [ RunTime:0.000189s ]
  94. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pick_on','1','1795250312') [ RunTime:0.000153s ]
  95. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pick_cols','5','1795250312') [ RunTime:0.000204s ]
  96. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pick_cols_m','3','1795250312') [ RunTime:0.000182s ]
  97. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_on','1','1795250312') [ RunTime:0.000166s ]
  98. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_cols','5','1795250312') [ RunTime:0.000216s ]
  99. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_cols_m','3','1795250312') [ RunTime:0.000215s ]
  100. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_rows','2','1795250312') [ RunTime:0.000187s ]
  101. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_on','0','1795250312') [ RunTime:0.000183s ]
  102. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_note','','1795250312') [ RunTime:0.003573s ]
  103. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_on','1','1795250312') [ RunTime:0.000413s ]
  104. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_alipay','','1795250312') [ RunTime:0.000302s ]
  105. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_wechat','','1795250312') [ RunTime:0.000317s ]
  106. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_alipay','0','1795250312') [ RunTime:0.000371s ]
  107. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_wxpay','0','1795250312') [ RunTime:0.000391s ]
  108. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_url','','1795250312') [ RunTime:0.000212s ]
  109. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_pid','','1795250312') [ RunTime:0.000325s ]
  110. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_key','','1795250312') [ RunTime:0.000181s ]
  111. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_on','0','1795250312') [ RunTime:0.000426s ]
  112. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_appid','','1795250312') [ RunTime:0.000207s ]
  113. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_private_key','','1795250312') [ RunTime:0.000197s ]
  114. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_public_key','','1795250312') [ RunTime:0.000182s ]
  115. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_on','0','1795250312') [ RunTime:0.000198s ]
  116. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_mchid','','1795250312') [ RunTime:0.000161s ]
  117. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_appid','','1795250312') [ RunTime:0.000147s ]
  118. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_v3key','','1795250312') [ RunTime:0.000166s ]
  119. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_serial','','1795250312') [ RunTime:0.000176s ]
  120. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_private_key','','1795250312') [ RunTime:0.000178s ]
  121. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_platform_cert','','1795250312') [ RunTime:0.000172s ]
  122. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_on','1','1795250312') [ RunTime:0.000154s ]
  123. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_price','0','1795250312') [ RunTime:0.000183s ]
  124. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_free_audit','0','1795250312') [ RunTime:0.000350s ]
  125. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_contact','','1795250312') [ RunTime:0.000169s ]
  126. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_on','1','1795250312') [ RunTime:0.000163s ]
  127. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_amounts','5,10,20,50,100','1795250312') [ RunTime:0.000223s ]
  128. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_min','1','1795250312') [ RunTime:0.000182s ]
  129. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_max','9999','1795250312') [ RunTime:0.000167s ]
  130. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_rules','','1795250312') [ RunTime:0.000195s ]
  131. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_audit','0','1795250312') [ RunTime:0.000346s ]
  132. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_forever_on','0','1795250312') [ RunTime:0.000432s ]
  133. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_forever_price','10','1795250312') [ RunTime:0.000413s ]
  134. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_normal_price','0','1795250312') [ RunTime:0.000257s ]
  135. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_best_price','0','1795250312') [ RunTime:0.000252s ]
  136. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_any_include','0','1795250312') [ RunTime:0.000221s ]
  137. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_top_min','0','1795250312') [ RunTime:0.000294s ]
  138. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('app_debug','0','1795250312') [ RunTime:0.000173s ]
  139. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('dock_on','1','1795250312') [ RunTime:0.000156s ]
  140. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('member_on','1','1795250312') [ RunTime:0.000485s ]
  141. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('member_pay_on','1','1795250312') [ RunTime:0.000841s ]
  142. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('webmaster_on','0','1795250312') [ RunTime:0.000238s ]
  143. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('points_on','1','1795250312') [ RunTime:0.000199s ]
  144. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('member_note','','1795250312') [ RunTime:0.000214s ]
  145. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('points_note','','1795250312') [ RunTime:0.000245s ]
  146. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_gate_on','1','1795250312') [ RunTime:0.000563s ]
  147. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_quota_anon','60','1795250312') [ RunTime:0.000221s ]
  148. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_quota_user','300','1795250312') [ RunTime:0.000189s ]
  149. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_quota_vip','0','1795250312') [ RunTime:0.000162s ]
  150. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_on','0','1795250312') [ RunTime:0.000170s ]
  151. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_audit','1','1795250312') [ RunTime:0.000151s ]
  152. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_max_len','300','1795250312') [ RunTime:0.000149s ]
  153. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_rate','60','1795250312') [ RunTime:0.000158s ]
  154. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_day_limit','10','1795250312') [ RunTime:0.000598s ]
  155. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_ip_day_limit','5','1795250312') [ RunTime:0.000148s ]
  156. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_region','1','1795250312') [ RunTime:0.000172s ]
  157. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_home','0','1795250312') [ RunTime:0.000152s ]
  158. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_site_login','0','1795250312') [ RunTime:0.000157s ]
  159. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_on','1','1795250312') [ RunTime:0.000151s ]
  160. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_login','0','1795250312') [ RunTime:0.000169s ]
  161. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_guest_reply','1','1795250312') [ RunTime:0.000164s ]
  162. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_audit','0','1795250312') [ RunTime:0.000231s ]
  163. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_max_len','500','1795250312') [ RunTime:0.000168s ]
  164. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_rate','30','1795250312') [ RunTime:0.000269s ]
  165. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_page_size','10','1795250312') [ RunTime:0.000235s ]
  166. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_region','1','1795250312') [ RunTime:0.000175s ]
  167. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_admin_badge','1','1795250312') [ RunTime:0.000177s ]
  168. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('right_menu_on','1','1795250312') [ RunTime:0.000277s ]
  169. SELECT COUNT(*) AS `c` FROM `nav_member_plan` [ RunTime:0.000215s ]
  170. SELECT COUNT(*) AS `c` FROM `nav_points_pack` [ RunTime:0.000181s ]
  171. SHOW COLUMNS FROM `nav_site` [ RunTime:0.001100s ]
  172. SHOW COLUMNS FROM `nav_site` [ RunTime:0.001367s ]
  173. SHOW COLUMNS FROM `nav_site` [ RunTime:0.001010s ]
  174. SELECT `id`,`slug` FROM `nav_category` [ RunTime:0.000220s ]
  175. SELECT COUNT(*) AS n FROM `nav_category_tag` [ RunTime:0.002055s ]
  176. SELECT `id`,`category_id` FROM `nav_category_tag` ORDER BY `category_id` ASC, `sort` DESC, `id` ASC [ RunTime:0.000353s ]
  177. UPDATE `nav_category_tag` SET `slug` = 'video-1' WHERE `id` = '1' [ RunTime:0.001431s ]
  178. UPDATE `nav_category_tag` SET `slug` = 'video-2' WHERE `id` = '2' [ RunTime:0.001850s ]
  179. UPDATE `nav_category_tag` SET `slug` = 'video-3' WHERE `id` = '3' [ RunTime:0.005107s ]
  180. UPDATE `nav_category_tag` SET `slug` = 'video-4' WHERE `id` = '4' [ RunTime:0.001890s ]
  181. UPDATE `nav_category_tag` SET `slug` = 'video-5' WHERE `id` = '5' [ RunTime:0.001685s ]
  182. UPDATE `nav_category_tag` SET `slug` = 'video-6' WHERE `id` = '6' [ RunTime:0.001397s ]
  183. UPDATE `nav_category_tag` SET `slug` = 'video-7' WHERE `id` = '7' [ RunTime:0.002263s ]
  184. UPDATE `nav_category_tag` SET `slug` = 'video-8' WHERE `id` = '8' [ RunTime:0.002063s ]
  185. UPDATE `nav_category_tag` SET `slug` = 'video-9' WHERE `id` = '9' [ RunTime:0.005855s ]
  186. UPDATE `nav_category_tag` SET `slug` = 'anime-1' WHERE `id` = '10' [ RunTime:0.002213s ]
  187. UPDATE `nav_category_tag` SET `slug` = 'anime-2' WHERE `id` = '11' [ RunTime:0.001472s ]
  188. UPDATE `nav_category_tag` SET `slug` = 'anime-3' WHERE `id` = '12' [ RunTime:0.001730s ]
  189. UPDATE `nav_category_tag` SET `slug` = 'anime-4' WHERE `id` = '13' [ RunTime:0.001170s ]
  190. UPDATE `nav_category_tag` SET `slug` = 'anime-5' WHERE `id` = '14' [ RunTime:0.001445s ]
  191. UPDATE `nav_category_tag` SET `slug` = 'music-1' WHERE `id` = '15' [ RunTime:0.001211s ]
  192. UPDATE `nav_category_tag` SET `slug` = 'music-2' WHERE `id` = '16' [ RunTime:0.002228s ]
  193. UPDATE `nav_category_tag` SET `slug` = 'music-3' WHERE `id` = '17' [ RunTime:0.001645s ]
  194. UPDATE `nav_category_tag` SET `slug` = 'music-4' WHERE `id` = '18' [ RunTime:0.002613s ]
  195. UPDATE `nav_category_tag` SET `slug` = 'music-5' WHERE `id` = '19' [ RunTime:0.002500s ]
  196. UPDATE `nav_category_tag` SET `slug` = 'music-6' WHERE `id` = '20' [ RunTime:0.002945s ]
  197. UPDATE `nav_category_tag` SET `slug` = 'music-7' WHERE `id` = '21' [ RunTime:0.001413s ]
  198. UPDATE `nav_category_tag` SET `slug` = 'music-8' WHERE `id` = '22' [ RunTime:0.001256s ]
  199. UPDATE `nav_category_tag` SET `slug` = 'read-1' WHERE `id` = '23' [ RunTime:0.004531s ]
  200. UPDATE `nav_category_tag` SET `slug` = 'read-2' WHERE `id` = '166' [ RunTime:0.002019s ]
  201. UPDATE `nav_category_tag` SET `slug` = 'read-3' WHERE `id` = '24' [ RunTime:0.001790s ]
  202. UPDATE `nav_category_tag` SET `slug` = 'read-4' WHERE `id` = '25' [ RunTime:0.001688s ]
  203. UPDATE `nav_category_tag` SET `slug` = 'read-5' WHERE `id` = '26' [ RunTime:0.001372s ]
  204. UPDATE `nav_category_tag` SET `slug` = 'read-6' WHERE `id` = '27' [ RunTime:0.001230s ]
  205. UPDATE `nav_category_tag` SET `slug` = 'read-7' WHERE `id` = '169' [ RunTime:0.001076s ]
  206. UPDATE `nav_category_tag` SET `slug` = 'read-8' WHERE `id` = '167' [ RunTime:0.001644s ]
  207. UPDATE `nav_category_tag` SET `slug` = 'read-9' WHERE `id` = '168' [ RunTime:0.001248s ]
  208. UPDATE `nav_category_tag` SET `slug` = 'game-1' WHERE `id` = '28' [ RunTime:0.001169s ]
  209. UPDATE `nav_category_tag` SET `slug` = 'game-2' WHERE `id` = '29' [ RunTime:0.002031s ]
  210. UPDATE `nav_category_tag` SET `slug` = 'game-3' WHERE `id` = '30' [ RunTime:0.002532s ]
  211. UPDATE `nav_category_tag` SET `slug` = 'fun-1' WHERE `id` = '31' [ RunTime:0.003145s ]
  212. UPDATE `nav_category_tag` SET `slug` = 'fun-2' WHERE `id` = '32' [ RunTime:0.001908s ]
  213. UPDATE `nav_category_tag` SET `slug` = 'tools-1' WHERE `id` = '33' [ RunTime:0.002620s ]
  214. UPDATE `nav_category_tag` SET `slug` = 'tools-2' WHERE `id` = '34' [ RunTime:0.001553s ]
  215. UPDATE `nav_category_tag` SET `slug` = 'tools-3' WHERE `id` = '35' [ RunTime:0.002084s ]
  216. UPDATE `nav_category_tag` SET `slug` = 'tools-4' WHERE `id` = '36' [ RunTime:0.002521s ]
  217. UPDATE `nav_category_tag` SET `slug` = 'tools-5' WHERE `id` = '37' [ RunTime:0.001896s ]
  218. UPDATE `nav_category_tag` SET `slug` = 'tools-6' WHERE `id` = '38' [ RunTime:0.001212s ]
  219. UPDATE `nav_category_tag` SET `slug` = 'tools-7' WHERE `id` = '39' [ RunTime:0.001298s ]
  220. UPDATE `nav_category_tag` SET `slug` = 'tools-8' WHERE `id` = '40' [ RunTime:0.001531s ]
  221. UPDATE `nav_category_tag` SET `slug` = 'tools-9' WHERE `id` = '41' [ RunTime:0.001692s ]
  222. UPDATE `nav_category_tag` SET `slug` = 'tools-10' WHERE `id` = '42' [ RunTime:0.001669s ]
  223. UPDATE `nav_category_tag` SET `slug` = 'tools-11' WHERE `id` = '43' [ RunTime:0.002514s ]
  224. UPDATE `nav_category_tag` SET `slug` = 'githubapp-1' WHERE `id` = '203' [ RunTime:0.002181s ]
  225. UPDATE `nav_category_tag` SET `slug` = 'githubapp-2' WHERE `id` = '165' [ RunTime:0.001926s ]
  226. UPDATE `nav_category_tag` SET `slug` = 'learning-1' WHERE `id` = '170' [ RunTime:0.001185s ]
  227. UPDATE `nav_category_tag` SET `slug` = 'learning-2' WHERE `id` = '171' [ RunTime:0.001754s ]
  228. UPDATE `nav_category_tag` SET `slug` = 'learning-3' WHERE `id` = '172' [ RunTime:0.001187s ]
  229. UPDATE `nav_category_tag` SET `slug` = 'learning-4' WHERE `id` = '173' [ RunTime:0.001060s ]
  230. UPDATE `nav_category_tag` SET `slug` = 'learning-5' WHERE `id` = '174' [ RunTime:0.001548s ]
  231. UPDATE `nav_category_tag` SET `slug` = 'learning-6' WHERE `id` = '175' [ RunTime:0.001950s ]
  232. UPDATE `nav_category_tag` SET `slug` = 'learning-7' WHERE `id` = '176' [ RunTime:0.001452s ]
  233. UPDATE `nav_category_tag` SET `slug` = 'learning-8' WHERE `id` = '177' [ RunTime:0.001871s ]
  234. UPDATE `nav_category_tag` SET `slug` = 'learning-9' WHERE `id` = '178' [ RunTime:0.002027s ]
  235. UPDATE `nav_category_tag` SET `slug` = 'learning-10' WHERE `id` = '216' [ RunTime:0.002205s ]
  236. UPDATE `nav_category_tag` SET `slug` = 'learning-11' WHERE `id` = '179' [ RunTime:0.002398s ]
  237. UPDATE `nav_category_tag` SET `slug` = 'learning-12' WHERE `id` = '180' [ RunTime:0.001184s ]
  238. UPDATE `nav_category_tag` SET `slug` = 'mediatools-1' WHERE `id` = '181' [ RunTime:0.003480s ]
  239. UPDATE `nav_category_tag` SET `slug` = 'mediatools-2' WHERE `id` = '182' [ RunTime:0.002109s ]
  240. UPDATE `nav_category_tag` SET `slug` = 'mediatools-3' WHERE `id` = '183' [ RunTime:0.001411s ]
  241. UPDATE `nav_category_tag` SET `slug` = 'mediatools-4' WHERE `id` = '184' [ RunTime:0.003149s ]
  242. UPDATE `nav_category_tag` SET `slug` = 'mediatools-5' WHERE `id` = '185' [ RunTime:0.003086s ]
  243. UPDATE `nav_category_tag` SET `slug` = 'mediatools-6' WHERE `id` = '186' [ RunTime:0.005745s ]
  244. UPDATE `nav_category_tag` SET `slug` = 'mediatools-7' WHERE `id` = '187' [ RunTime:0.002367s ]
  245. UPDATE `nav_category_tag` SET `slug` = 'mediatools-8' WHERE `id` = '188' [ RunTime:0.003647s ]
  246. UPDATE `nav_category_tag` SET `slug` = 'searchtools-1' WHERE `id` = '189' [ RunTime:0.001492s ]
  247. UPDATE `nav_category_tag` SET `slug` = 'searchtools-2' WHERE `id` = '190' [ RunTime:0.001506s ]
  248. UPDATE `nav_category_tag` SET `slug` = 'searchtools-3' WHERE `id` = '191' [ RunTime:0.003720s ]
  249. UPDATE `nav_category_tag` SET `slug` = 'searchtools-4' WHERE `id` = '192' [ RunTime:0.001675s ]
  250. UPDATE `nav_category_tag` SET `slug` = 'searchtools-5' WHERE `id` = '193' [ RunTime:0.002662s ]
  251. UPDATE `nav_category_tag` SET `slug` = 'searchtools-6' WHERE `id` = '194' [ RunTime:0.003205s ]
  252. UPDATE `nav_category_tag` SET `slug` = 'searchtools-7' WHERE `id` = '195' [ RunTime:0.002380s ]
  253. UPDATE `nav_category_tag` SET `slug` = 'searchtools-8' WHERE `id` = '196' [ RunTime:0.002022s ]
  254. UPDATE `nav_category_tag` SET `slug` = 'resources-1' WHERE `id` = '197' [ RunTime:0.001949s ]
  255. UPDATE `nav_category_tag` SET `slug` = 'resources-2' WHERE `id` = '198' [ RunTime:0.002841s ]
  256. UPDATE `nav_category_tag` SET `slug` = 'resources-3' WHERE `id` = '199' [ RunTime:0.002352s ]
  257. UPDATE `nav_category_tag` SET `slug` = 'resources-4' WHERE `id` = '200' [ RunTime:0.002324s ]
  258. UPDATE `nav_category_tag` SET `slug` = 'resources-5' WHERE `id` = '201' [ RunTime:0.002863s ]
  259. UPDATE `nav_category_tag` SET `slug` = 'resources-6' WHERE `id` = '202' [ RunTime:0.001703s ]
  260. UPDATE `nav_category_tag` SET `slug` = 'itshare-1' WHERE `id` = '204' [ RunTime:0.001547s ]
  261. UPDATE `nav_category_tag` SET `slug` = 'itshare-2' WHERE `id` = '205' [ RunTime:0.001658s ]
  262. UPDATE `nav_category_tag` SET `slug` = 'itshare-3' WHERE `id` = '207' [ RunTime:0.001204s ]
  263. UPDATE `nav_category_tag` SET `slug` = 'itshare-4' WHERE `id` = '211' [ RunTime:0.001905s ]
  264. UPDATE `nav_category_tag` SET `slug` = 'itshare-5' WHERE `id` = '212' [ RunTime:0.001613s ]
  265. UPDATE `nav_category_tag` SET `slug` = 'itshare-6' WHERE `id` = '213' [ RunTime:0.001056s ]
  266. UPDATE `nav_category_tag` SET `slug` = 'itshare-7' WHERE `id` = '215' [ RunTime:0.001778s ]
  267. UPDATE `nav_category_tag` SET `slug` = 'itshare-8' WHERE `id` = '229' [ RunTime:0.001388s ]
  268. UPDATE `nav_category_tag` SET `slug` = 'webtools-1' WHERE `id` = '206' [ RunTime:0.002040s ]
  269. UPDATE `nav_category_tag` SET `slug` = 'webtools-2' WHERE `id` = '208' [ RunTime:0.001732s ]
  270. UPDATE `nav_category_tag` SET `slug` = 'webtools-3' WHERE `id` = '210' [ RunTime:0.001501s ]
  271. UPDATE `nav_category_tag` SET `slug` = 'webtools-4' WHERE `id` = '218' [ RunTime:0.001237s ]
  272. UPDATE `nav_category_tag` SET `slug` = 'webtools-5' WHERE `id` = '219' [ RunTime:0.004342s ]
  273. UPDATE `nav_category_tag` SET `slug` = 'webtools-6' WHERE `id` = '221' [ RunTime:0.001410s ]
  274. UPDATE `nav_category_tag` SET `slug` = 'webtools-7' WHERE `id` = '223' [ RunTime:0.001388s ]
  275. UPDATE `nav_category_tag` SET `slug` = 'webtools-8' WHERE `id` = '224' [ RunTime:0.003208s ]
  276. UPDATE `nav_category_tag` SET `slug` = 'webtools-9' WHERE `id` = '226' [ RunTime:0.003490s ]
  277. UPDATE `nav_category_tag` SET `slug` = 'creator-1' WHERE `id` = '209' [ RunTime:0.002474s ]
  278. UPDATE `nav_category_tag` SET `slug` = 'creator-2' WHERE `id` = '214' [ RunTime:0.004594s ]
  279. UPDATE `nav_category_tag` SET `slug` = 'creator-3' WHERE `id` = '217' [ RunTime:0.008366s ]
  280. UPDATE `nav_category_tag` SET `slug` = 'creator-4' WHERE `id` = '220' [ RunTime:0.002836s ]
  281. UPDATE `nav_category_tag` SET `slug` = 'creator-5' WHERE `id` = '222' [ RunTime:0.002118s ]
  282. UPDATE `nav_category_tag` SET `slug` = 'creator-6' WHERE `id` = '225' [ RunTime:0.001842s ]
  283. UPDATE `nav_category_tag` SET `slug` = 'creator-7' WHERE `id` = '227' [ RunTime:0.001958s ]
  284. UPDATE `nav_category_tag` SET `slug` = 'creator-8' WHERE `id` = '228' [ RunTime:0.002157s ]
  285. UPDATE `nav_category_tag` SET `slug` = 'itlearning-1' WHERE `id` = '230' [ RunTime:0.002704s ]
  286. UPDATE `nav_category_tag` SET `slug` = 'itlearning-2' WHERE `id` = '232' [ RunTime:0.002203s ]
  287. UPDATE `nav_category_tag` SET `slug` = 'itlearning-3' WHERE `id` = '234' [ RunTime:0.002028s ]
  288. UPDATE `nav_category_tag` SET `slug` = 'itlearning-4' WHERE `id` = '239' [ RunTime:0.001804s ]
  289. UPDATE `nav_category_tag` SET `slug` = 'itlearning-5' WHERE `id` = '241' [ RunTime:0.001835s ]
  290. UPDATE `nav_category_tag` SET `slug` = 'devtools-1' WHERE `id` = '231' [ RunTime:0.001382s ]
  291. UPDATE `nav_category_tag` SET `slug` = 'devtools-2' WHERE `id` = '233' [ RunTime:0.001265s ]
  292. UPDATE `nav_category_tag` SET `slug` = 'devtools-3' WHERE `id` = '235' [ RunTime:0.002518s ]
  293. UPDATE `nav_category_tag` SET `slug` = 'devtools-4' WHERE `id` = '238' [ RunTime:0.001780s ]
  294. UPDATE `nav_category_tag` SET `slug` = 'devtools-5' WHERE `id` = '240' [ RunTime:0.001402s ]
  295. UPDATE `nav_category_tag` SET `slug` = 'devtools-6' WHERE `id` = '247' [ RunTime:0.003268s ]
  296. UPDATE `nav_category_tag` SET `slug` = 'comsofts-1' WHERE `id` = '236' [ RunTime:0.002095s ]
  297. UPDATE `nav_category_tag` SET `slug` = 'comsofts-2' WHERE `id` = '237' [ RunTime:0.001896s ]
  298. UPDATE `nav_category_tag` SET `slug` = 'comsofts-3' WHERE `id` = '242' [ RunTime:0.002014s ]
  299. UPDATE `nav_category_tag` SET `slug` = 'comsofts-4' WHERE `id` = '243' [ RunTime:0.002273s ]
  300. UPDATE `nav_category_tag` SET `slug` = 'comsofts-5' WHERE `id` = '244' [ RunTime:0.001165s ]
  301. UPDATE `nav_category_tag` SET `slug` = 'comsofts-6' WHERE `id` = '245' [ RunTime:0.001371s ]
  302. UPDATE `nav_category_tag` SET `slug` = 'comsofts-7' WHERE `id` = '246' [ RunTime:0.002811s ]
  303. UPDATE `nav_category_tag` SET `slug` = 'comsofts-8' WHERE `id` = '248' [ RunTime:0.001700s ]
  304. UPDATE `nav_category_tag` SET `slug` = 'officetools-1' WHERE `id` = '249' [ RunTime:0.001960s ]
  305. UPDATE `nav_category_tag` SET `slug` = 'officetools-2' WHERE `id` = '250' [ RunTime:0.001496s ]
  306. UPDATE `nav_category_tag` SET `slug` = 'officetools-3' WHERE `id` = '251' [ RunTime:0.002001s ]
  307. UPDATE `nav_category_tag` SET `slug` = 'officetools-4' WHERE `id` = '252' [ RunTime:0.002280s ]
  308. UPDATE `nav_category_tag` SET `slug` = 'officetools-5' WHERE `id` = '253' [ RunTime:0.002470s ]
  309. UPDATE `nav_category_tag` SET `slug` = 'officetools-6' WHERE `id` = '254' [ RunTime:0.003066s ]
  310. UPDATE `nav_category_tag` SET `slug` = 'officetools-7' WHERE `id` = '255' [ RunTime:0.001189s ]
  311. UPDATE `nav_category_tag` SET `slug` = 'officetools-8' WHERE `id` = '256' [ RunTime:0.003954s ]
  312. UPDATE `nav_category_tag` SET `slug` = 'officetools-9' WHERE `id` = '257' [ RunTime:0.004829s ]
  313. UPDATE `nav_category_tag` SET `slug` = 'officetools-10' WHERE `id` = '258' [ RunTime:0.002149s ]
  314. UPDATE `nav_category_tag` SET `slug` = 'officetools-11' WHERE `id` = '259' [ RunTime:0.004030s ]
  315. SELECT COUNT(*) AS n FROM `nav_link` [ RunTime:0.000209s ]
  316. SELECT `id` FROM `nav_category` WHERE `status` = 1 ORDER BY `sort` DESC, `id` ASC [ RunTime:0.000198s ]
  317. SELECT COUNT(*) AS n FROM `nav_site` WHERE `slug` = 'bilibili-demo' [ RunTime:0.000184s ]
  318. SHOW COLUMNS FROM `nav_site` [ RunTime:0.000742s ]
  319. SELECT COUNT(*) AS n FROM `nav_like_log` [ RunTime:0.000177s ]
  320. SELECT `id` FROM `nav_link` LIMIT 1 [ RunTime:0.000140s ]
  321. SELECT `id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000140s ]
  322. SELECT `id` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000140s ]
  323. SELECT `id` FROM `nav_ad` LIMIT 1 [ RunTime:0.000134s ]
  324. SELECT `id` FROM `nav_ad_plan` LIMIT 1 [ RunTime:0.000133s ]
  325. SELECT `id`,`order_no`,`pay_channel`,`pay_trade_no` FROM `nav_friend_link` LIMIT 1 [ RunTime:0.000161s ]
  326. SELECT `id`,`type`,`tag_id` FROM `nav_dock` LIMIT 1 [ RunTime:0.000151s ]
  327. SHOW COLUMNS FROM `nav_dock` [ RunTime:0.000678s ]
  328. SHOW COLUMNS FROM `nav_ad` [ RunTime:0.000716s ]
  329. SELECT `gift_days`,`pay_channel`,`pay_trade_no` FROM `nav_ad` LIMIT 1 [ RunTime:0.000166s ]
  330. SHOW COLUMNS FROM `nav_ad_plan` [ RunTime:0.000645s ]
  331. SELECT `position` FROM `nav_ad_plan` LIMIT 1 [ RunTime:0.000154s ]
  332. SHOW COLUMNS FROM `nav_ad` [ RunTime:0.003742s ]
  333. SELECT `icon` FROM `nav_ad` LIMIT 1 [ RunTime:0.000169s ]
  334. SHOW COLUMNS FROM `nav_qlink` [ RunTime:0.000699s ]
  335. SELECT `subtitle` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000160s ]
  336. SHOW COLUMNS FROM `nav_site` [ RunTime:0.000740s ]
  337. SELECT `hide_code`,`password` FROM `nav_site` LIMIT 1 [ RunTime:0.000181s ]
  338. SELECT `pv`,`clicks`,`views_m`,`views_d`,`views_p` FROM `nav_site_view_day` LIMIT 1 [ RunTime:0.000153s ]
  339. SELECT `quick_default` FROM `nav_site` LIMIT 1 [ RunTime:0.000164s ]
  340. SELECT `badge_color` FROM `nav_site` LIMIT 1 [ RunTime:0.000141s ]
  341. SELECT `user_id`,`url_key`,`title`,`icon`,`description`,`badge`,`platforms` FROM `nav_user_quick` LIMIT 1 [ RunTime:0.000164s ]
  342. SELECT `slug` FROM `nav_plugin` LIMIT 1 [ RunTime:0.000139s ]
  343. SHOW COLUMNS FROM `nav_plugin` [ RunTime:0.000670s ]
  344. SELECT `type`,`url`,`icon_url`,`cover`,`category`,`color`,`badge`,`need_login`,`points_cost` FROM `nav_plugin` LIMIT 1 [ RunTime:0.000178s ]
  345. SHOW FULL COLUMNS FROM `nav_plugin` [ RunTime:0.000899s ]
  346. SELECT * FROM `nav_plugin` [ RunTime:0.000324s ]
  347. UPDATE `nav_plugin` SET `category` = 'plugin' WHERE `type` = 'local' AND `category` = 'life' AND `update_time` = `create_time` [ RunTime:0.000262s ]
  348. SHOW FULL COLUMNS FROM `nav_setting` [ RunTime:0.000709s ]
  349. SELECT * FROM `nav_setting` [ RunTime:0.000501s ]
  350. SELECT `alias`,`template`,`content`,`referer_on`,`referer_flag`,`pwd_fail_on`,`pwd_fail_url`,`password`,`password_tip`,`owner` FROM `nav_dypage` LIMIT 1 [ RunTime:0.000218s ]
  351. SHOW COLUMNS FROM `nav_sponsor` [ RunTime:0.000689s ]
  352. SELECT `order_no`,`pay_time`,`ip` FROM `nav_sponsor` LIMIT 1 [ RunTime:0.003000s ]
  353. SHOW COLUMNS FROM `nav_sponsor_order` [ RunTime:0.000660s ]
  354. SELECT `order_no`,`sponsor_id`,`amount`,`base_amount`,`forever`,`include_site`,`ip` FROM `nav_sponsor_order` LIMIT 1 [ RunTime:0.000385s ]
  355. SHOW COLUMNS FROM `nav_user_favorite` [ RunTime:0.000666s ]
  356. SELECT `ip` FROM `nav_user_favorite` LIMIT 1 [ RunTime:0.000160s ]
  357. SHOW COLUMNS FROM `nav_user_like` [ RunTime:0.000680s ]
  358. SELECT `ip` FROM `nav_user_like` LIMIT 1 [ RunTime:0.000157s ]
  359. SHOW COLUMNS FROM `nav_points_log` [ RunTime:0.000628s ]
  360. SELECT `ip` FROM `nav_points_log` LIMIT 1 [ RunTime:0.000149s ]
  361. SHOW COLUMNS FROM `nav_invite_order` [ RunTime:0.000651s ]
  362. DELETE FROM `nav_sponsor` WHERE `order_no` = '' AND `pay_time` = 0 AND `name` LIKE '星友%' [ RunTime:0.002849s ]
  363. SELECT COUNT(*) AS `c` FROM `nav_sponsor` [ RunTime:0.000163s ]
  364. SHOW COLUMNS FROM `nav_article` [ RunTime:0.000837s ]
  365. SELECT COUNT(*) AS `c` FROM `nav_micro_post` [ RunTime:0.000168s ]
  366. SHOW COLUMNS FROM `nav_submit` [ RunTime:0.000715s ]
  367. SELECT `user_id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000267s ]
  368. SHOW COLUMNS FROM `nav_submit` [ RunTime:0.000714s ]
  369. SELECT `amount`,`order_no`,`pay_time`,`site_id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000178s ]
  370. SELECT `email`,`scene` FROM `nav_user_email_code` LIMIT 1 [ RunTime:0.000145s ]
  371. SELECT `user_id`,`target_id` FROM `nav_user_history` LIMIT 1 [ RunTime:0.000192s ]
  372. UPDATE `nav_user` SET `email_verified` = 1 WHERE `email` = '' [ RunTime:0.000193s ]
  373. SELECT `code`,`status` FROM `nav_invite_code` LIMIT 1 [ RunTime:0.000182s ]
  374. SELECT `order_no`,`status`,`invite_code` FROM `nav_invite_order` LIMIT 1 [ RunTime:0.000157s ]
  375. SELECT `type`,`months`,`price` FROM `nav_member_plan` LIMIT 1 [ RunTime:0.000143s ]
  376. SELECT `points`,`bonus`,`price` FROM `nav_points_pack` LIMIT 1 [ RunTime:0.000243s ]
  377. SELECT `order_no`,`type`,`status` FROM `nav_member_order` LIMIT 1 [ RunTime:0.000145s ]
  378. SELECT `user_id`,`delta`,`type` FROM `nav_points_log` LIMIT 1 [ RunTime:0.000139s ]
  379. SELECT `ticket_hash`,`slug`,`bucket` FROM `nav_pkg_key_log` LIMIT 1 [ RunTime:0.000143s ]
  380. SHOW COLUMNS FROM `nav_user` [ RunTime:0.000652s ]
  381. SELECT `webmaster_expire` FROM `nav_user` LIMIT 1 [ RunTime:0.000155s ]
  382. SHOW INDEX FROM `nav_site` [ RunTime:0.000293s ]
  383. SHOW INDEX FROM `nav_article` [ RunTime:0.000242s ]
  384. SHOW INDEX FROM `nav_submit` [ RunTime:0.000189s ]
  385. SHOW INDEX FROM `nav_user` [ RunTime:0.000194s ]
  386. SHOW INDEX FROM `nav_points_log` [ RunTime:0.000182s ]
  387. SHOW INDEX FROM `nav_invite_order` [ RunTime:0.000225s ]
  388. SHOW INDEX FROM `nav_member_order` [ RunTime:0.000202s ]
  389. SHOW INDEX FROM `nav_ad` [ RunTime:0.000196s ]
  390. SHOW INDEX FROM `nav_sponsor` [ RunTime:0.000183s ]
  391. SHOW INDEX FROM `nav_sponsor_order` [ RunTime:0.000185s ]
  392. SELECT `id`,`status`,`device_hash` FROM `nav_secret_post` LIMIT 1 [ RunTime:0.000166s ]
  393. SELECT `id`,`post_id` FROM `nav_secret_report` LIMIT 1 [ RunTime:0.000140s ]
  394. SELECT `id`,`page_key`,`status`,`root_id` FROM `nav_comment` LIMIT 1 [ RunTime:0.000147s ]
  395. SHOW COLUMNS FROM `nav_comment` [ RunTime:0.003660s ]
  396. SELECT `ip` FROM `nav_comment` LIMIT 1 [ RunTime:0.000157s ]
  397. SHOW COLUMNS FROM `nav_qlink` [ RunTime:0.000788s ]
  398. SELECT `folder_kind` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000159s ]
  399. SELECT `qlink_id`,`kind`,`ref_id`,`sort` FROM `nav_qlink_item` LIMIT 1 [ RunTime:0.000164s ]
  400. SELECT COUNT(*) AS `c` FROM `nav_right_menu` [ RunTime:0.000195s ]
  401. SELECT `id`,`scope_type`,`enabled` FROM `nav_right_menu` LIMIT 1 [ RunTime:0.000150s ]
  402. SELECT `rid`,`label`,`action` FROM `nav_right_menu_item` LIMIT 1 [ RunTime:0.000160s ]
  403. SELECT `id`,`rid`,`sort` FROM `nav_right_menu_item` WHERE `action` = 'fav' AND `label` = '收藏 / 屏蔽此站' [ RunTime:0.000177s ]
  404. ALTER TABLE `nav_right_menu` MODIFY COLUMN `scope_type` varchar(50) NOT NULL DEFAULT 'site' [ RunTime:0.002534s ]
  405. ALTER TABLE `nav_right_menu_item` MODIFY COLUMN `icon` varchar(500) NOT NULL DEFAULT '' [ RunTime:0.001309s ]
  406. SELECT `icon` FROM `nav_right_menu_item` LIMIT 1 [ RunTime:0.000162s ]
  407. SELECT `pid` FROM `nav_right_menu_item` LIMIT 1 [ RunTime:0.000193s ]
  408. SELECT COUNT(*) AS `c` FROM `nav_home_module` [ RunTime:0.000172s ]
  409. SELECT `id`,`mkey`,`zone` FROM `nav_home_module` LIMIT 1 [ RunTime:0.000150s ]
  410. SELECT `id`,`mkey` FROM `nav_home_module` [ RunTime:0.000154s ]
  411. SELECT `id`,`mkey`,`sort` FROM `nav_home_module` [ RunTime:0.000157s ]
  412. SELECT `block_id`,`type`,`source_id`,`weight`,`is_ad` FROM `nav_home_pic` LIMIT 1 [ RunTime:0.000155s ]
  413. SELECT COUNT(*) AS `c` FROM `nav_home_block` [ RunTime:0.000188s ]
  414. SELECT `id` FROM `nav_home_block` ORDER BY `sort` ASC, `id` ASC LIMIT 1 [ RunTime:0.000180s ]
  415. UPDATE `nav_home_pic` SET `block_id` = '3' WHERE `block_id` = 0 [ RunTime:0.000427s ]
  416. SELECT `rank_type`,`rank_period` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000151s ]
  417. SELECT `is_countdown` FROM `nav_home_pic` LIMIT 1 [ RunTime:0.000146s ]
  418. SELECT `note_text`,`note_author` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000189s ]
  419. SELECT `is_video` FROM `nav_home_pic` LIMIT 1 [ RunTime:0.000140s ]
  420. SELECT `audience`,`ab_enable`,`ab_ratio` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000174s ]
  421. SELECT `pic_id`,`day`,`views`,`clicks` FROM `nav_home_pic_stat` LIMIT 1 [ RunTime:0.000157s ]
  422. SELECT `block_id`,`day`,`grp`,`exposes`,`clicks` FROM `nav_home_block_stat` LIMIT 1 [ RunTime:0.000145s ]
  423. SELECT `note_items` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000179s ]
  424. SELECT `cat`,`item_id` FROM `nav_shijuan_item` LIMIT 1 [ RunTime:0.000186s ]
  425. SELECT `item_id` FROM `nav_shijuan_download` LIMIT 1 [ RunTime:0.000135s ]
  426. SELECT `slug` FROM `nav_shijuan_category` LIMIT 1 [ RunTime:0.000147s ]
  427. SELECT `slug` FROM `nav_shijuan_subject` LIMIT 1 [ RunTime:0.000137s ]
  428. SELECT `file`,`license`,`rtype`,`status`,`update_time` FROM `nav_shijuan_item` LIMIT 1 [ RunTime:0.000166s ]
  429. SELECT `icon` FROM `nav_shijuan_subject` LIMIT 1 [ RunTime:0.000162s ]
  430. SELECT `icon` FROM `nav_shijuan_category` LIMIT 1 [ RunTime:0.000155s ]
  431. SELECT `feedback`,`feedback_status`,`feedback_time` FROM `nav_shijuan_item` LIMIT 1 [ RunTime:0.000144s ]
  432. SELECT `cover` FROM `nav_sponsor` LIMIT 1 [ RunTime:0.000152s ]
  433. SELECT `feedback`,`feedback_status`,`feedback_time` FROM `nav_article` LIMIT 1 [ RunTime:0.000161s ]
  434. SELECT `cover`,`bg_style`,`name_color`,`extra_color` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000162s ]
  435. SELECT `parent_id` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000197s ]
  436. SELECT `is_rec` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000156s ]
  437. SELECT `is_nav` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000144s ]
  438. SELECT `banner_img`,`banner_sub`,`tile_sort` FROM `nav_article` LIMIT 1 [ RunTime:0.000169s ]
  439. SELECT `dl_on`,`dl_gate`,`dl_price`,`dl_vip`,`dl_vip_price`,`dl_hours`,`dl_tip`,`downloads`,`dl_count` FROM `nav_article` LIMIT 1 [ RunTime:0.000195s ]
  440. SELECT `remark` FROM `nav_article` LIMIT 1 [ RunTime:0.000152s ]
  441. SELECT `points_on`,`points_price` FROM `nav_article` LIMIT 1 [ RunTime:0.000215s ]
  442. SELECT `id` FROM `nav_article_points_unlock` LIMIT 1 [ RunTime:0.000152s ]
  443. SELECT `id` FROM `nav_points_signin` LIMIT 1 [ RunTime:0.000144s ]
  444. SELECT `id` FROM `nav_dl_ticket` LIMIT 1 [ RunTime:0.000152s ]
  445. SELECT `id`,`type`,`url` FROM `nav_article_menu` LIMIT 1 [ RunTime:0.000172s ]
  446. SELECT COUNT(*) AS `c` FROM `nav_article_menu` [ RunTime:0.000152s ]
  447. SHOW COLUMNS FROM `nav_article_menu` [ RunTime:0.000807s ]
  448. SELECT `hide_in_parent` FROM `nav_article_menu` LIMIT 1 [ RunTime:0.000167s ]
  449. SHOW COLUMNS FROM `nav_article_menu` [ RunTime:0.000683s ]
  450. SELECT `title_color` FROM `nav_article_menu` LIMIT 1 [ RunTime:0.000163s ]
  451. SELECT `article_cfg` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000152s ]
  452. SELECT `is_list` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000142s ]
  453. SHOW COLUMNS FROM `nav_link` [ RunTime:0.000680s ]
  454. SELECT `name_color` FROM `nav_link` LIMIT 1 [ RunTime:0.000158s ]
  455. SHOW COLUMNS FROM `nav_fx_url` [ RunTime:0.000619s ]
  456. SELECT `pass_hash` FROM `nav_fx_url` LIMIT 1 [ RunTime:0.000157s ]
  457. SHOW COLUMNS FROM `nav_fx_url` [ RunTime:0.003089s ]
  458. SELECT `pass_view` FROM `nav_fx_url` LIMIT 1 [ RunTime:0.000188s ]
  459. SHOW COLUMNS FROM `nav_fx_url` [ RunTime:0.000631s ]
  460. SELECT `notified` FROM `nav_fx_url` LIMIT 1 [ RunTime:0.000163s ]
  461. SHOW COLUMNS FROM `nav_fx_url` [ RunTime:0.000646s ]
  462. SELECT `view_time` FROM `nav_fx_url` LIMIT 1 [ RunTime:0.000162s ]
  463. SELECT `name_color` FROM `nav_category` LIMIT 1 [ RunTime:0.000143s ]
  464. SELECT `name_color`,`icon_color` FROM `nav_category_tag` LIMIT 1 [ RunTime:0.000155s ]
  465. SELECT `name_color`,`icon_color` FROM `nav_friend_link` LIMIT 1 [ RunTime:0.000152s ]
  466. SELECT `id`,`source`,`type`,`target_id`,`url_key` FROM `nav_user_dock` LIMIT 1 [ RunTime:0.000158s ]
  467. SHOW FULL COLUMNS FROM `nav_category` [ RunTime:0.000652s ]
  468. SELECT * FROM `nav_category` WHERE `slug` = 'mediatools' AND `status` = 1 LIMIT 1 [ RunTime:0.000249s ]
  469. SHOW FULL COLUMNS FROM `nav_category_tag` [ RunTime:0.000649s ]
  470. SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000441s ]
  471. SHOW FULL COLUMNS FROM `nav_site` [ RunTime:0.004064s ]
  472. SELECT `hide_code` FROM `nav_site` LIMIT 1 [ RunTime:0.000182s ]
  473. SELECT category_id, tag_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id`,`tag_id` [ RunTime:0.006066s ]
  474. SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `category_id` = 46 AND `hide_code` = '' AND `tag_id` = 181 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000614s ]
  475. SELECT * FROM `nav_site` WHERE `status` = 1 AND `category_id` = 46 AND `hide_code` = '' AND `tag_id` = 181 ORDER BY `sort` DESC,`id` DESC LIMIT 0,25 [ RunTime:0.001077s ]
  476. SHOW FULL COLUMNS FROM `nav_like_log` [ RunTime:0.001124s ]
  477. SELECT `target_id` FROM `nav_like_log` WHERE `type` = 'site' AND `ip` = '216.73.216.88' [ RunTime:0.000237s ]
  478. SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000451s ]
  479. SELECT category_id, tag_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id`,`tag_id` [ RunTime:0.009691s ]
  480. SHOW FULL COLUMNS FROM `nav_comment` [ RunTime:0.001050s ]
  481. SELECT page_key, COUNT(*) AS n FROM `nav_comment` WHERE `status` = 1 AND ( `page_key` LIKE 'site:%' OR `page_key` LIKE 'app:%' ) GROUP BY `page_key` [ RunTime:0.000306s ]
  482. SHOW FULL COLUMNS FROM `nav_ad_plan` [ RunTime:0.000849s ]
  483. SELECT * FROM `nav_ad_plan` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000344s ]
  484. SELECT SUM(`views`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.008869s ]
  485. SHOW FULL COLUMNS FROM `nav_article` [ RunTime:0.001050s ]
  486. SELECT SUM(`views`) AS think_sum FROM `nav_article` WHERE `status` = 1 [ RunTime:0.005438s ]
  487. SELECT SUM(`likes`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.004939s ]
  488. SELECT COUNT(*) AS think_count FROM `nav_category_tag` WHERE `status` = 1 [ RunTime:0.000254s ]
  489. SHOW FULL COLUMNS FROM `nav_user` [ RunTime:0.000775s ]
  490. SELECT COUNT(*) AS think_count FROM `nav_user` [ RunTime:0.000173s ]
  491. SELECT SUM(`views_today`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_date` = 1795190400 [ RunTime:0.007448s ]
  492. SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000609s ]
  493. SELECT category_id, tag_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id`,`tag_id` [ RunTime:0.008383s ]
  494. SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_date` = 1795190400 AND `views_today` > 0 ORDER BY `views_today` DESC,`id` DESC LIMIT 8 [ RunTime:0.000660s ]
  495. SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_wkey` = '202647' AND `views_week` > 0 ORDER BY `views_week` DESC,`id` DESC LIMIT 8 [ RunTime:0.000545s ]
  496. SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_mkey` = '202611' AND `views_month` > 0 ORDER BY `views_month` DESC,`id` DESC LIMIT 8 [ RunTime:0.008280s ]
  497. SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' ORDER BY `views` DESC,`id` DESC LIMIT 8 [ RunTime:0.000571s ]
  498. SHOW FULL COLUMNS FROM `nav_ad` [ RunTime:0.000972s ]
  499. SELECT * FROM `nav_ad` WHERE `status` = 2 AND `position` = 'home_banner' AND `start_time` <= 1795250313 AND `end_time` >= 1795250313 ORDER BY `sort` DESC,`id` DESC LIMIT 20 [ RunTime:0.000386s ]
  500. SELECT `cover`,`bg_style`,`name_color`,`extra_color` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000187s ]
  501. SHOW FULL COLUMNS FROM `nav_home_block` [ RunTime:0.000822s ]
  502. SELECT * FROM `nav_home_block` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000279s ]
  503. SHOW FULL COLUMNS FROM `nav_home_module` [ RunTime:0.000697s ]
  504. SELECT * FROM `nav_home_module` WHERE `zone` = 'rail' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000448s ]
  505. SELECT * FROM `nav_home_block` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000250s ]
  506. SELECT * FROM `nav_home_module` WHERE `zone` = 'rail' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000225s ]
  507. SHOW FULL COLUMNS FROM `nav_article_cat` [ RunTime:0.001039s ]
  508. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000315s ]
  509. SELECT * FROM `nav_site` WHERE `id` IN (208,97,69,152,41,124,207) [ RunTime:0.000372s ]
  510. SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.006577s ]
  511. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 [ RunTime:0.001903s ]
  512. SHOW FULL COLUMNS FROM `nav_notice` [ RunTime:0.000795s ]
  513. SELECT COUNT(*) AS think_count FROM `nav_notice` WHERE `status` = 1 [ RunTime:0.000219s ]
  514. SHOW FULL COLUMNS FROM `nav_sponsor` [ RunTime:0.000742s ]
  515. SELECT COUNT(*) AS think_count FROM `nav_sponsor` WHERE `status` = 1 [ RunTime:0.000227s ]
  516. SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `create_time` >= 1795190400 [ RunTime:0.000353s ]
  517. SELECT * FROM `nav_ad` WHERE `status` = 2 AND `position` = 'home_fixed' AND `start_time` <= 1795250313 AND `end_time` >= 1795250313 ORDER BY `sort` DESC,`id` DESC LIMIT 27 [ RunTime:0.000388s ]
0.693215s