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

开源软件

共 61 个站点 · 2 个标签 · 按「推荐」排序

品牌固定位 ¥83.33 起 / 月 立即入驻
枫叶 astryx astryx 是一个完全开源、可自由定制的标准化设计系统,原生适配各类 AI 智能体调用,组件、样式与交互规范都… 45 Web 枫叶 dsh-superagent-prototype dsh-superagent-prototype是DeepSeek开源的超智能体研究原型,面向高自主AI研发,探… 49 Web 枫叶 dsh-Go dsh-Go 是 DeepSeek Harness 的轻量应用,支持安装 Ubuntu 与 Node.js 运行… 51 Web 枫叶 craft-anything craft-anything 是一个纯 Rust 开源反向工程引擎,用来看懂任意网站、App 或游戏怎么运作,再… 53 Web 枫叶 Open Code Review Open Code Review 是阿里巴巴开源的命令行代码审查工具,工程模块拆分任务并定位行号、LLM Age… 149 Web 枫叶 Refero Styles Refero旗下专门面向AI Agent打造的设计系统参考库,从大量真实线上产品网站提取视觉规范,整理成标准化的… 227 Web 枫叶 dsh‑context 基于Apache‑2.0协议开源的DeepSeek Harness专用插件,由枫叶bowenliang123维护… 242 Web 枫叶 高性价比人生指南 长寿防病、急救、省钱理财、法律红线、失业与工伤、医保社保、恋爱婚育、怀孕育儿、创业与做平台合规、出国与技能。 745 Web 枫叶 MarkItDown MarkItDown 是微软开源的多格式文档转换工具,主要用于将不同类型的文件和内容转换成 Markdown。它… 433 Web 枫叶 Firecrawl Firecrawl 是一个面向 AI 应用的网页搜索、抓取和爬取工具,主要用于将互联网网页转换为适合大模型和 A… 343 Web 枫叶 浮生梦 浮生梦是一款用于自定义浏览器新标签页的扩展工具,主要功能是在新标签页界面展示中国经典诗词,并整合常用书签入口。用… 850 Web 枫叶 myIPTV myIPTV 定位为开源的电视直播源整理项目,汇集并维护高清电视源,方便用户通过 IPTV 播放器收看主流卫视频… 1.91k Web 枫叶 open-xiaoai Open-XiaoAI 定位为智能音箱增强项目,通过引入多模态大模型与 AI Agent,将传统的语音指令系统升… 1.41k Web 枫叶 SearXNG SearXNG 是一款基于 Python 开发的开源元搜索引擎项目,旨在为用户提供一个完全不记录、无广告、聚合式… 2k Web 枫叶 png2pdf png2pdf 是一款免费的图片转PDF工具,支持将长图自动切割为A4尺寸的标准格式,并转换成可打印或存储的PD… 1.31k Web 枫叶 ntopng ntopng 是一款开源的网络流量监控和分析工具,它通过直观的浏览器界面,提供实时的流量数据和网络分析结果。作为… 1k Web 枫叶 TrackWeight TrackWeight是一款适用于macOS的轻量级工具,能够借助现代MacBook的Force Touch触控… 1.11k Web 枫叶 2048 2048 是一款由意大利枫叶 Gabriele Cirulli 于 2014 年创建的滑动数字益智游戏。游戏目标… 1.51k Web 枫叶 Pacman Pacman 网页版是一个用 JavaScript 编写的“吃豆人”小游戏,由 GitHub 用户 mumuy … 1.61k Web 枫叶 Battle City Battle City Remake 是一款基于 JavaScript 和 React 技术重构的网页版《坦克大… 1.51k Web 枫叶 React Tetris React Tetris 是由前端枫叶 chvin 基于 React 与 TypeScript 技术开发的一款网… 1.11k Web 枫叶 NetworkPanel NetworkPanel 是一个开源的在线网络测试工具,用户可以通过浏览器直接访问,无需安装任何软件,便捷地进行… 2k Web 枫叶 LiYing LiYing 是一款完全本地化运行的开源证件照处理工具,专为照相馆常见的证件照后期流程设计开发。它由开源枫叶社区… 1.51k Web 枫叶 white200 white200 是一款在线色彩感知挑战类网页小游戏,玩法简单而直接:游戏会在屏幕上生成若干色块,其中只有一块颜… 1.21k Web 枫叶 BiliTools BiliTools 是一款基于 Tauri 框架开发的桌面应用程序,目标是为用户提供一个纯净、稳定、高效的哔哩哔… 2.61k Web
必备 枫叶起始页(必备)
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-11-22 07:06:10 HTTP/1.1 GET : https://dhw.wchulian.com.cn/c/githubapp?page=2
  2. 运行时间 : 0.488673s [ 吞吐率:2.05req/s ] 内存消耗:12,656.88kb 文件加载:191
  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.42 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 ( 166.30 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.48 KB )
  42. /www/wwwroot/daohw.cn/app/common/content.php ( 30.51 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/app/common/search.php ( 10.92 KB )
  59. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/helper.php ( 18.77 KB )
  60. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Config.php ( 5.93 KB )
  61. /www/wwwroot/daohw.cn/config/app.php ( 0.95 KB )
  62. /www/wwwroot/daohw.cn/config/cache.php ( 0.78 KB )
  63. /www/wwwroot/daohw.cn/config/console.php ( 0.80 KB )
  64. /www/wwwroot/daohw.cn/config/cookie.php ( 0.56 KB )
  65. /www/wwwroot/daohw.cn/config/database.php ( 2.13 KB )
  66. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  67. /www/wwwroot/daohw.cn/config/filesystem.php ( 0.61 KB )
  68. /www/wwwroot/daohw.cn/config/lang.php ( 0.91 KB )
  69. /www/wwwroot/daohw.cn/config/log.php ( 1.35 KB )
  70. /www/wwwroot/daohw.cn/config/middleware.php ( 0.19 KB )
  71. /www/wwwroot/daohw.cn/config/route.php ( 1.89 KB )
  72. /www/wwwroot/daohw.cn/config/session.php ( 0.57 KB )
  73. /www/wwwroot/daohw.cn/config/shijuan.php ( 1.16 KB )
  74. /www/wwwroot/daohw.cn/config/trace.php ( 0.34 KB )
  75. /www/wwwroot/daohw.cn/config/view.php ( 1.20 KB )
  76. /www/wwwroot/daohw.cn/app/event.php ( 0.25 KB )
  77. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Event.php ( 7.77 KB )
  78. /www/wwwroot/daohw.cn/app/service.php ( 0.13 KB )
  79. /www/wwwroot/daohw.cn/app/AppService.php ( 0.26 KB )
  80. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  81. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  82. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  83. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  84. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  85. /www/wwwroot/daohw.cn/vendor/services.php ( 0.14 KB )
  86. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  87. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  88. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  89. /www/wwwroot/daohw.cn/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  90. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  91. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  92. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/Paginator.php ( 11.86 KB )
  93. /www/wwwroot/daohw.cn/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  94. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/Model.php ( 23.55 KB )
  95. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 21.05 KB )
  96. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/AutoWriteData.php ( 4.20 KB )
  97. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 6.75 KB )
  98. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/DbConnect.php ( 5.16 KB )
  99. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.33 KB )
  100. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 28.30 KB )
  101. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  102. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  103. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/contract/Modelable.php ( 0.09 KB )
  104. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  105. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/DbManager.php ( 8.52 KB )
  106. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  107. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  108. /www/wwwroot/daohw.cn/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  109. /www/wwwroot/daohw.cn/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  110. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  111. /www/wwwroot/daohw.cn/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  112. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/helper/Arr.php ( 17.45 KB )
  113. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.84 KB )
  114. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/cache/Driver.php ( 9.02 KB )
  115. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  116. /www/wwwroot/daohw.cn/app/Request.php ( 0.09 KB )
  117. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Request.php ( 54.64 KB )
  118. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/traits/UrlHandler.php ( 6.05 KB )
  119. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/traits/DomainHandler.php ( 5.49 KB )
  120. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/traits/HttpMethodHandler.php ( 4.74 KB )
  121. /www/wwwroot/daohw.cn/app/middleware.php ( 0.37 KB )
  122. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  123. /www/wwwroot/daohw.cn/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  124. /www/wwwroot/daohw.cn/app/middleware/SecurityHeaders.php ( 2.08 KB )
  125. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  126. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/RuleName.php ( 5.74 KB )
  127. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  128. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.41 KB )
  129. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/Rule.php ( 27.49 KB )
  130. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  131. /www/wwwroot/daohw.cn/route/apisend.php ( 2.09 KB )
  132. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  133. /www/wwwroot/daohw.cn/route/app.php ( 27.85 KB )
  134. /www/wwwroot/daohw.cn/route/shijuan.php ( 1.60 KB )
  135. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  136. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/Dispatch.php ( 11.32 KB )
  137. /www/wwwroot/daohw.cn/app/controller/Front.php ( 1.21 KB )
  138. /www/wwwroot/daohw.cn/app/BaseController.php ( 2.05 KB )
  139. /www/wwwroot/daohw.cn/app/controller/front/ContextTrait.php ( 19.62 KB )
  140. /www/wwwroot/daohw.cn/app/controller/front/HomeTrait.php ( 31.51 KB )
  141. /www/wwwroot/daohw.cn/app/controller/front/ArticleTrait.php ( 37.66 KB )
  142. /www/wwwroot/daohw.cn/app/controller/front/SponsorTrait.php ( 14.63 KB )
  143. /www/wwwroot/daohw.cn/app/controller/front/ApplyTrait.php ( 12.30 KB )
  144. /www/wwwroot/daohw.cn/app/controller/front/ToolTrait.php ( 12.63 KB )
  145. /www/wwwroot/daohw.cn/app/controller/front/DyTrait.php ( 14.55 KB )
  146. /www/wwwroot/daohw.cn/app/controller/front/SecretTrait.php ( 2.17 KB )
  147. /www/wwwroot/daohw.cn/app/controller/front/DownloadTrait.php ( 5.99 KB )
  148. /www/wwwroot/daohw.cn/app/controller/front/FxTrait.php ( 4.67 KB )
  149. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  150. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 5.73 KB )
  151. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/PDOConnection.php ( 53.74 KB )
  152. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Connection.php ( 8.39 KB )
  153. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.57 KB )
  154. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.58 KB )
  155. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Builder.php ( 24.07 KB )
  156. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.50 KB )
  157. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/log/driver/File.php ( 6.10 KB )
  158. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  159. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  160. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  161. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/exception/PDOException.php ( 1.50 KB )
  162. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/exception/DbException.php ( 1.38 KB )
  163. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Log.php ( 3.07 KB )
  164. /www/wwwroot/daohw.cn/vendor/psr/log/src/LogLevel.php ( 0.33 KB )
  165. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Query.php ( 15.97 KB )
  166. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/BaseQuery.php ( 45.13 KB )
  167. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  168. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  169. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 20.07 KB )
  170. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  171. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.01 KB )
  172. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 19.37 KB )
  173. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.11 KB )
  174. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.63 KB )
  175. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  176. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  177. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/exception/ErrorException.php ( 1.72 KB )
  178. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Raw.php ( 1.30 KB )
  179. /www/wwwroot/daohw.cn/app/utils/IpUtils.php ( 5.41 KB )
  180. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Cache.php ( 2.06 KB )
  181. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Response.php ( 9.07 KB )
  182. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/response/View.php ( 3.29 KB )
  183. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  184. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
  185. /www/wwwroot/daohw.cn/vendor/topthink/think-view/src/Think.php ( 8.38 KB )
  186. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.60 KB )
  187. /www/wwwroot/daohw.cn/vendor/topthink/think-template/src/Template.php ( 46.61 KB )
  188. /www/wwwroot/daohw.cn/vendor/topthink/think-template/src/template/driver/File.php ( 2.41 KB )
  189. /www/wwwroot/daohw.cn/vendor/topthink/think-template/src/template/contract/DriverInterface.php ( 0.86 KB )
  190. /www/wwwroot/daohw.cn/runtime/temp/17dbd12c5b30222f6f81136592ebbfc1.php ( 153.89 KB )
  191. /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.000483s ] 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.000391s ]
  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.000363s ]
  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.000256s ]
  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.000303s ]
  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.000446s ]
  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.000220s ]
  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.000152s ]
  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.000145s ]
  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.000155s ]
  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.000159s ]
  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.000131s ]
  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.000223s ]
  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.000132s ]
  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.000123s ]
  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.000137s ]
  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.000137s ]
  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.000139s ]
  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.000154s ]
  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.000156s ]
  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.000123s ]
  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.000210s ]
  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.000150s ]
  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.000154s ]
  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.000158s ]
  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.000144s ]
  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.000141s ]
  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.000168s ]
  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.000136s ]
  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.000133s ]
  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.000146s ]
  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.000127s ]
  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.000120s ]
  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.000131s ]
  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.000145s ]
  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.000156s ]
  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.000152s ]
  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.000136s ]
  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.000134s ]
  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.000129s ]
  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.000131s ]
  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.000136s ]
  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.000130s ]
  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.000142s ]
  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.000150s ]
  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.000139s ]
  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.000143s ]
  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.000141s ]
  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.000173s ]
  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.000122s ]
  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.000118s ]
  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.000133s ]
  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.000151s ]
  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.000134s ]
  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.000174s ]
  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.000135s ]
  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.000133s ]
  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.000119s ]
  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.000165s ]
  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.000152s ]
  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.000127s ]
  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.000126s ]
  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.000119s ]
  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.000166s ]
  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.000160s ]
  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.000133s ]
  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.000132s ]
  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.000216s ]
  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.000212s ]
  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.000129s ]
  71. SELECT COUNT(*) AS `c` FROM `nav_devphase` [ RunTime:0.000169s ]
  72. SELECT COUNT(*) AS `c` FROM `nav_devlog` [ RunTime:0.000131s ]
  73. SELECT `k`,`v` FROM `nav_setting` WHERE `k` IN ('ad_banner_total','ad_slots') [ RunTime:0.000173s ]
  74. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_on','1','1795302370') [ RunTime:0.000191s ]
  75. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_free_audit','0','1795302370') [ RunTime:0.000125s ]
  76. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_price','0','1795302370') [ RunTime:0.000132s ]
  77. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_force_pay','0','1795302370') [ RunTime:0.000123s ]
  78. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_pay_audit','0','1795302370') [ RunTime:0.000110s ]
  79. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_on','1','1795302370') [ RunTime:0.000119s ]
  80. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_price_month','0','1795302370') [ RunTime:0.000113s ]
  81. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_free_audit','0','1795302370') [ RunTime:0.000121s ]
  82. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_free_months','1','1795302370') [ RunTime:0.000115s ]
  83. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_require_mark','1','1795302370') [ RunTime:0.000113s ]
  84. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_contact','','1795302370') [ RunTime:0.000111s ]
  85. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_rows','2','1795302370') [ RunTime:0.000112s ]
  86. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_cols','1','1795302370') [ RunTime:0.000111s ]
  87. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_total','24','1795302370') [ RunTime:0.000114s ]
  88. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_rows','2','1795302370') [ RunTime:0.000114s ]
  89. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_cols','9','1795302370') [ RunTime:0.000125s ]
  90. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_total','24','1795302370') [ RunTime:0.000127s ]
  91. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_price','0','1795302370') [ RunTime:0.000115s ]
  92. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('featured_cols','7','1795302370') [ RunTime:0.000112s ]
  93. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('featured_total','14','1795302370') [ RunTime:0.000112s ]
  94. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pick_on','1','1795302370') [ RunTime:0.000108s ]
  95. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pick_cols','5','1795302370') [ RunTime:0.000111s ]
  96. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pick_cols_m','3','1795302370') [ RunTime:0.000108s ]
  97. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_on','1','1795302370') [ RunTime:0.000108s ]
  98. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_cols','5','1795302370') [ RunTime:0.000113s ]
  99. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_cols_m','3','1795302370') [ RunTime:0.000110s ]
  100. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_rows','2','1795302370') [ RunTime:0.000110s ]
  101. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_on','0','1795302370') [ RunTime:0.000111s ]
  102. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_note','','1795302370') [ RunTime:0.000109s ]
  103. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_on','1','1795302370') [ RunTime:0.000107s ]
  104. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_alipay','','1795302370') [ RunTime:0.000115s ]
  105. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_wechat','','1795302370') [ RunTime:0.000113s ]
  106. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_alipay','0','1795302370') [ RunTime:0.000119s ]
  107. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_wxpay','0','1795302370') [ RunTime:0.000107s ]
  108. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_url','','1795302370') [ RunTime:0.000105s ]
  109. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_pid','','1795302370') [ RunTime:0.000107s ]
  110. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_key','','1795302370') [ RunTime:0.000106s ]
  111. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_on','0','1795302370') [ RunTime:0.000108s ]
  112. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_appid','','1795302370') [ RunTime:0.000106s ]
  113. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_private_key','','1795302370') [ RunTime:0.000106s ]
  114. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_public_key','','1795302370') [ RunTime:0.000118s ]
  115. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_on','0','1795302370') [ RunTime:0.000107s ]
  116. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_mchid','','1795302370') [ RunTime:0.000107s ]
  117. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_appid','','1795302370') [ RunTime:0.000110s ]
  118. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_v3key','','1795302370') [ RunTime:0.000105s ]
  119. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_serial','','1795302370') [ RunTime:0.000105s ]
  120. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_private_key','','1795302370') [ RunTime:0.000111s ]
  121. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_platform_cert','','1795302370') [ RunTime:0.000110s ]
  122. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_on','1','1795302370') [ RunTime:0.000107s ]
  123. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_price','0','1795302370') [ RunTime:0.000109s ]
  124. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_free_audit','0','1795302370') [ RunTime:0.000116s ]
  125. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_contact','','1795302370') [ RunTime:0.000109s ]
  126. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_on','1','1795302370') [ RunTime:0.000110s ]
  127. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_amounts','5,10,20,50,100','1795302370') [ RunTime:0.000111s ]
  128. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_min','1','1795302370') [ RunTime:0.000108s ]
  129. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_max','9999','1795302370') [ RunTime:0.000105s ]
  130. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_rules','','1795302370') [ RunTime:0.000109s ]
  131. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_audit','0','1795302370') [ RunTime:0.000124s ]
  132. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_forever_on','0','1795302370') [ RunTime:0.000111s ]
  133. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_forever_price','10','1795302370') [ RunTime:0.000109s ]
  134. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_normal_price','0','1795302370') [ RunTime:0.000105s ]
  135. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_best_price','0','1795302370') [ RunTime:0.000113s ]
  136. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_any_include','0','1795302370') [ RunTime:0.000115s ]
  137. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_top_min','0','1795302370') [ RunTime:0.000116s ]
  138. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('app_debug','0','1795302370') [ RunTime:0.000106s ]
  139. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('dock_on','1','1795302370') [ RunTime:0.000114s ]
  140. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('member_on','1','1795302370') [ RunTime:0.000108s ]
  141. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('member_pay_on','1','1795302370') [ RunTime:0.000105s ]
  142. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('webmaster_on','0','1795302370') [ RunTime:0.000106s ]
  143. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('points_on','1','1795302370') [ RunTime:0.000109s ]
  144. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('member_note','','1795302370') [ RunTime:0.000107s ]
  145. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('points_note','','1795302370') [ RunTime:0.000113s ]
  146. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_gate_on','1','1795302370') [ RunTime:0.000110s ]
  147. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_quota_anon','60','1795302370') [ RunTime:0.000117s ]
  148. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_quota_user','300','1795302370') [ RunTime:0.000112s ]
  149. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_quota_vip','0','1795302370') [ RunTime:0.000110s ]
  150. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_on','0','1795302370') [ RunTime:0.000108s ]
  151. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_audit','1','1795302370') [ RunTime:0.000106s ]
  152. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_max_len','300','1795302370') [ RunTime:0.000106s ]
  153. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_rate','60','1795302370') [ RunTime:0.000103s ]
  154. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_day_limit','10','1795302370') [ RunTime:0.000108s ]
  155. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_ip_day_limit','5','1795302370') [ RunTime:0.000104s ]
  156. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_region','1','1795302370') [ RunTime:0.000121s ]
  157. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_home','0','1795302370') [ RunTime:0.000112s ]
  158. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_site_login','0','1795302370') [ RunTime:0.000109s ]
  159. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_on','1','1795302370') [ RunTime:0.000108s ]
  160. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_login','0','1795302370') [ RunTime:0.000105s ]
  161. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_guest_reply','1','1795302370') [ RunTime:0.000109s ]
  162. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_audit','0','1795302370') [ RunTime:0.000108s ]
  163. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_max_len','500','1795302370') [ RunTime:0.000106s ]
  164. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_rate','30','1795302370') [ RunTime:0.000129s ]
  165. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_page_size','10','1795302370') [ RunTime:0.000113s ]
  166. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_region','1','1795302370') [ RunTime:0.000115s ]
  167. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_admin_badge','1','1795302370') [ RunTime:0.000113s ]
  168. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('right_menu_on','1','1795302370') [ RunTime:0.000107s ]
  169. SELECT COUNT(*) AS `c` FROM `nav_member_plan` [ RunTime:0.000152s ]
  170. SELECT COUNT(*) AS `c` FROM `nav_points_pack` [ RunTime:0.000118s ]
  171. SHOW COLUMNS FROM `nav_site` [ RunTime:0.000912s ]
  172. SHOW COLUMNS FROM `nav_site` [ RunTime:0.000707s ]
  173. SHOW COLUMNS FROM `nav_site` [ RunTime:0.000882s ]
  174. SELECT `id`,`slug` FROM `nav_category` [ RunTime:0.000176s ]
  175. SELECT COUNT(*) AS n FROM `nav_category_tag` [ RunTime:0.000142s ]
  176. SELECT `id`,`category_id` FROM `nav_category_tag` ORDER BY `category_id` ASC, `sort` DESC, `id` ASC [ RunTime:0.000216s ]
  177. UPDATE `nav_category_tag` SET `slug` = 'video-1' WHERE `id` = '1' [ RunTime:0.001686s ]
  178. UPDATE `nav_category_tag` SET `slug` = 'video-2' WHERE `id` = '2' [ RunTime:0.001533s ]
  179. UPDATE `nav_category_tag` SET `slug` = 'video-3' WHERE `id` = '3' [ RunTime:0.001254s ]
  180. UPDATE `nav_category_tag` SET `slug` = 'video-4' WHERE `id` = '4' [ RunTime:0.001022s ]
  181. UPDATE `nav_category_tag` SET `slug` = 'video-5' WHERE `id` = '5' [ RunTime:0.000883s ]
  182. UPDATE `nav_category_tag` SET `slug` = 'video-6' WHERE `id` = '6' [ RunTime:0.001219s ]
  183. UPDATE `nav_category_tag` SET `slug` = 'video-7' WHERE `id` = '7' [ RunTime:0.001055s ]
  184. UPDATE `nav_category_tag` SET `slug` = 'video-8' WHERE `id` = '8' [ RunTime:0.000987s ]
  185. UPDATE `nav_category_tag` SET `slug` = 'video-9' WHERE `id` = '9' [ RunTime:0.001006s ]
  186. UPDATE `nav_category_tag` SET `slug` = 'anime-1' WHERE `id` = '10' [ RunTime:0.000937s ]
  187. UPDATE `nav_category_tag` SET `slug` = 'anime-2' WHERE `id` = '11' [ RunTime:0.000530s ]
  188. UPDATE `nav_category_tag` SET `slug` = 'anime-3' WHERE `id` = '12' [ RunTime:0.001031s ]
  189. UPDATE `nav_category_tag` SET `slug` = 'anime-4' WHERE `id` = '13' [ RunTime:0.001103s ]
  190. UPDATE `nav_category_tag` SET `slug` = 'anime-5' WHERE `id` = '14' [ RunTime:0.001120s ]
  191. UPDATE `nav_category_tag` SET `slug` = 'music-1' WHERE `id` = '15' [ RunTime:0.001063s ]
  192. UPDATE `nav_category_tag` SET `slug` = 'music-2' WHERE `id` = '16' [ RunTime:0.003534s ]
  193. UPDATE `nav_category_tag` SET `slug` = 'music-3' WHERE `id` = '17' [ RunTime:0.000989s ]
  194. UPDATE `nav_category_tag` SET `slug` = 'music-4' WHERE `id` = '18' [ RunTime:0.001054s ]
  195. UPDATE `nav_category_tag` SET `slug` = 'music-5' WHERE `id` = '19' [ RunTime:0.001117s ]
  196. UPDATE `nav_category_tag` SET `slug` = 'music-6' WHERE `id` = '20' [ RunTime:0.001003s ]
  197. UPDATE `nav_category_tag` SET `slug` = 'music-7' WHERE `id` = '21' [ RunTime:0.001266s ]
  198. UPDATE `nav_category_tag` SET `slug` = 'music-8' WHERE `id` = '22' [ RunTime:0.001052s ]
  199. UPDATE `nav_category_tag` SET `slug` = 'read-1' WHERE `id` = '23' [ RunTime:0.001257s ]
  200. UPDATE `nav_category_tag` SET `slug` = 'read-2' WHERE `id` = '166' [ RunTime:0.002003s ]
  201. UPDATE `nav_category_tag` SET `slug` = 'read-3' WHERE `id` = '24' [ RunTime:0.001470s ]
  202. UPDATE `nav_category_tag` SET `slug` = 'read-4' WHERE `id` = '25' [ RunTime:0.001647s ]
  203. UPDATE `nav_category_tag` SET `slug` = 'read-5' WHERE `id` = '26' [ RunTime:0.001130s ]
  204. UPDATE `nav_category_tag` SET `slug` = 'read-6' WHERE `id` = '27' [ RunTime:0.001111s ]
  205. UPDATE `nav_category_tag` SET `slug` = 'read-7' WHERE `id` = '169' [ RunTime:0.001202s ]
  206. UPDATE `nav_category_tag` SET `slug` = 'read-8' WHERE `id` = '167' [ RunTime:0.000890s ]
  207. UPDATE `nav_category_tag` SET `slug` = 'read-9' WHERE `id` = '168' [ RunTime:0.000414s ]
  208. UPDATE `nav_category_tag` SET `slug` = 'game-1' WHERE `id` = '28' [ RunTime:0.000827s ]
  209. UPDATE `nav_category_tag` SET `slug` = 'game-2' WHERE `id` = '29' [ RunTime:0.001072s ]
  210. UPDATE `nav_category_tag` SET `slug` = 'game-3' WHERE `id` = '30' [ RunTime:0.001035s ]
  211. UPDATE `nav_category_tag` SET `slug` = 'fun-1' WHERE `id` = '31' [ RunTime:0.001037s ]
  212. UPDATE `nav_category_tag` SET `slug` = 'fun-2' WHERE `id` = '32' [ RunTime:0.000895s ]
  213. UPDATE `nav_category_tag` SET `slug` = 'tools-1' WHERE `id` = '33' [ RunTime:0.001189s ]
  214. UPDATE `nav_category_tag` SET `slug` = 'tools-2' WHERE `id` = '34' [ RunTime:0.000908s ]
  215. UPDATE `nav_category_tag` SET `slug` = 'tools-3' WHERE `id` = '35' [ RunTime:0.001821s ]
  216. UPDATE `nav_category_tag` SET `slug` = 'tools-4' WHERE `id` = '36' [ RunTime:0.004725s ]
  217. UPDATE `nav_category_tag` SET `slug` = 'tools-5' WHERE `id` = '37' [ RunTime:0.002284s ]
  218. UPDATE `nav_category_tag` SET `slug` = 'tools-6' WHERE `id` = '38' [ RunTime:0.001053s ]
  219. UPDATE `nav_category_tag` SET `slug` = 'tools-7' WHERE `id` = '39' [ RunTime:0.001032s ]
  220. UPDATE `nav_category_tag` SET `slug` = 'tools-8' WHERE `id` = '40' [ RunTime:0.001634s ]
  221. UPDATE `nav_category_tag` SET `slug` = 'tools-9' WHERE `id` = '41' [ RunTime:0.001168s ]
  222. UPDATE `nav_category_tag` SET `slug` = 'tools-10' WHERE `id` = '42' [ RunTime:0.001609s ]
  223. UPDATE `nav_category_tag` SET `slug` = 'tools-11' WHERE `id` = '43' [ RunTime:0.001076s ]
  224. UPDATE `nav_category_tag` SET `slug` = 'githubapp-1' WHERE `id` = '203' [ RunTime:0.001057s ]
  225. UPDATE `nav_category_tag` SET `slug` = 'githubapp-2' WHERE `id` = '165' [ RunTime:0.001188s ]
  226. UPDATE `nav_category_tag` SET `slug` = 'learning-1' WHERE `id` = '170' [ RunTime:0.001194s ]
  227. UPDATE `nav_category_tag` SET `slug` = 'learning-2' WHERE `id` = '171' [ RunTime:0.001648s ]
  228. UPDATE `nav_category_tag` SET `slug` = 'learning-3' WHERE `id` = '172' [ RunTime:0.001330s ]
  229. UPDATE `nav_category_tag` SET `slug` = 'learning-4' WHERE `id` = '173' [ RunTime:0.000897s ]
  230. UPDATE `nav_category_tag` SET `slug` = 'learning-5' WHERE `id` = '174' [ RunTime:0.000980s ]
  231. UPDATE `nav_category_tag` SET `slug` = 'learning-6' WHERE `id` = '175' [ RunTime:0.001106s ]
  232. UPDATE `nav_category_tag` SET `slug` = 'learning-7' WHERE `id` = '176' [ RunTime:0.000946s ]
  233. UPDATE `nav_category_tag` SET `slug` = 'learning-8' WHERE `id` = '177' [ RunTime:0.000748s ]
  234. UPDATE `nav_category_tag` SET `slug` = 'learning-9' WHERE `id` = '178' [ RunTime:0.000939s ]
  235. UPDATE `nav_category_tag` SET `slug` = 'learning-10' WHERE `id` = '216' [ RunTime:0.001089s ]
  236. UPDATE `nav_category_tag` SET `slug` = 'learning-11' WHERE `id` = '179' [ RunTime:0.000876s ]
  237. UPDATE `nav_category_tag` SET `slug` = 'learning-12' WHERE `id` = '180' [ RunTime:0.001128s ]
  238. UPDATE `nav_category_tag` SET `slug` = 'mediatools-1' WHERE `id` = '181' [ RunTime:0.001036s ]
  239. UPDATE `nav_category_tag` SET `slug` = 'mediatools-2' WHERE `id` = '182' [ RunTime:0.000769s ]
  240. UPDATE `nav_category_tag` SET `slug` = 'mediatools-3' WHERE `id` = '183' [ RunTime:0.001295s ]
  241. UPDATE `nav_category_tag` SET `slug` = 'mediatools-4' WHERE `id` = '184' [ RunTime:0.000944s ]
  242. UPDATE `nav_category_tag` SET `slug` = 'mediatools-5' WHERE `id` = '185' [ RunTime:0.001102s ]
  243. UPDATE `nav_category_tag` SET `slug` = 'mediatools-6' WHERE `id` = '186' [ RunTime:0.002083s ]
  244. UPDATE `nav_category_tag` SET `slug` = 'mediatools-7' WHERE `id` = '187' [ RunTime:0.001017s ]
  245. UPDATE `nav_category_tag` SET `slug` = 'mediatools-8' WHERE `id` = '188' [ RunTime:0.000464s ]
  246. UPDATE `nav_category_tag` SET `slug` = 'searchtools-1' WHERE `id` = '189' [ RunTime:0.000855s ]
  247. UPDATE `nav_category_tag` SET `slug` = 'searchtools-2' WHERE `id` = '190' [ RunTime:0.000920s ]
  248. UPDATE `nav_category_tag` SET `slug` = 'searchtools-3' WHERE `id` = '191' [ RunTime:0.001116s ]
  249. UPDATE `nav_category_tag` SET `slug` = 'searchtools-4' WHERE `id` = '192' [ RunTime:0.000872s ]
  250. UPDATE `nav_category_tag` SET `slug` = 'searchtools-5' WHERE `id` = '193' [ RunTime:0.000884s ]
  251. UPDATE `nav_category_tag` SET `slug` = 'searchtools-6' WHERE `id` = '194' [ RunTime:0.001086s ]
  252. UPDATE `nav_category_tag` SET `slug` = 'searchtools-7' WHERE `id` = '195' [ RunTime:0.001864s ]
  253. UPDATE `nav_category_tag` SET `slug` = 'searchtools-8' WHERE `id` = '196' [ RunTime:0.000984s ]
  254. UPDATE `nav_category_tag` SET `slug` = 'resources-1' WHERE `id` = '197' [ RunTime:0.002058s ]
  255. UPDATE `nav_category_tag` SET `slug` = 'resources-2' WHERE `id` = '198' [ RunTime:0.001162s ]
  256. UPDATE `nav_category_tag` SET `slug` = 'resources-3' WHERE `id` = '199' [ RunTime:0.001069s ]
  257. UPDATE `nav_category_tag` SET `slug` = 'resources-4' WHERE `id` = '200' [ RunTime:0.001042s ]
  258. UPDATE `nav_category_tag` SET `slug` = 'resources-5' WHERE `id` = '201' [ RunTime:0.001313s ]
  259. UPDATE `nav_category_tag` SET `slug` = 'resources-6' WHERE `id` = '202' [ RunTime:0.001855s ]
  260. UPDATE `nav_category_tag` SET `slug` = 'itshare-1' WHERE `id` = '204' [ RunTime:0.001168s ]
  261. UPDATE `nav_category_tag` SET `slug` = 'itshare-2' WHERE `id` = '205' [ RunTime:0.001286s ]
  262. UPDATE `nav_category_tag` SET `slug` = 'itshare-3' WHERE `id` = '207' [ RunTime:0.001064s ]
  263. UPDATE `nav_category_tag` SET `slug` = 'itshare-4' WHERE `id` = '211' [ RunTime:0.001013s ]
  264. UPDATE `nav_category_tag` SET `slug` = 'itshare-5' WHERE `id` = '212' [ RunTime:0.001416s ]
  265. UPDATE `nav_category_tag` SET `slug` = 'itshare-6' WHERE `id` = '213' [ RunTime:0.001637s ]
  266. UPDATE `nav_category_tag` SET `slug` = 'itshare-7' WHERE `id` = '215' [ RunTime:0.003189s ]
  267. UPDATE `nav_category_tag` SET `slug` = 'itshare-8' WHERE `id` = '229' [ RunTime:0.001455s ]
  268. UPDATE `nav_category_tag` SET `slug` = 'webtools-1' WHERE `id` = '206' [ RunTime:0.004677s ]
  269. UPDATE `nav_category_tag` SET `slug` = 'webtools-2' WHERE `id` = '208' [ RunTime:0.001147s ]
  270. UPDATE `nav_category_tag` SET `slug` = 'webtools-3' WHERE `id` = '210' [ RunTime:0.001175s ]
  271. UPDATE `nav_category_tag` SET `slug` = 'webtools-4' WHERE `id` = '218' [ RunTime:0.000948s ]
  272. UPDATE `nav_category_tag` SET `slug` = 'webtools-5' WHERE `id` = '219' [ RunTime:0.001368s ]
  273. UPDATE `nav_category_tag` SET `slug` = 'webtools-6' WHERE `id` = '221' [ RunTime:0.001149s ]
  274. UPDATE `nav_category_tag` SET `slug` = 'webtools-7' WHERE `id` = '223' [ RunTime:0.003051s ]
  275. UPDATE `nav_category_tag` SET `slug` = 'webtools-8' WHERE `id` = '224' [ RunTime:0.001707s ]
  276. UPDATE `nav_category_tag` SET `slug` = 'webtools-9' WHERE `id` = '226' [ RunTime:0.001321s ]
  277. UPDATE `nav_category_tag` SET `slug` = 'creator-1' WHERE `id` = '209' [ RunTime:0.001050s ]
  278. UPDATE `nav_category_tag` SET `slug` = 'creator-2' WHERE `id` = '214' [ RunTime:0.005920s ]
  279. UPDATE `nav_category_tag` SET `slug` = 'creator-3' WHERE `id` = '217' [ RunTime:0.001168s ]
  280. UPDATE `nav_category_tag` SET `slug` = 'creator-4' WHERE `id` = '220' [ RunTime:0.001084s ]
  281. UPDATE `nav_category_tag` SET `slug` = 'creator-5' WHERE `id` = '222' [ RunTime:0.002069s ]
  282. UPDATE `nav_category_tag` SET `slug` = 'creator-6' WHERE `id` = '225' [ RunTime:0.001119s ]
  283. UPDATE `nav_category_tag` SET `slug` = 'creator-7' WHERE `id` = '227' [ RunTime:0.000997s ]
  284. UPDATE `nav_category_tag` SET `slug` = 'creator-8' WHERE `id` = '228' [ RunTime:0.001163s ]
  285. UPDATE `nav_category_tag` SET `slug` = 'itlearning-1' WHERE `id` = '230' [ RunTime:0.001016s ]
  286. UPDATE `nav_category_tag` SET `slug` = 'itlearning-2' WHERE `id` = '232' [ RunTime:0.001497s ]
  287. UPDATE `nav_category_tag` SET `slug` = 'itlearning-3' WHERE `id` = '234' [ RunTime:0.002705s ]
  288. UPDATE `nav_category_tag` SET `slug` = 'itlearning-4' WHERE `id` = '239' [ RunTime:0.001172s ]
  289. UPDATE `nav_category_tag` SET `slug` = 'itlearning-5' WHERE `id` = '241' [ RunTime:0.003049s ]
  290. UPDATE `nav_category_tag` SET `slug` = 'devtools-1' WHERE `id` = '231' [ RunTime:0.001223s ]
  291. UPDATE `nav_category_tag` SET `slug` = 'devtools-2' WHERE `id` = '233' [ RunTime:0.001063s ]
  292. UPDATE `nav_category_tag` SET `slug` = 'devtools-3' WHERE `id` = '235' [ RunTime:0.001140s ]
  293. UPDATE `nav_category_tag` SET `slug` = 'devtools-4' WHERE `id` = '238' [ RunTime:0.001040s ]
  294. UPDATE `nav_category_tag` SET `slug` = 'devtools-5' WHERE `id` = '240' [ RunTime:0.000971s ]
  295. UPDATE `nav_category_tag` SET `slug` = 'devtools-6' WHERE `id` = '247' [ RunTime:0.001155s ]
  296. UPDATE `nav_category_tag` SET `slug` = 'comsofts-1' WHERE `id` = '236' [ RunTime:0.001525s ]
  297. UPDATE `nav_category_tag` SET `slug` = 'comsofts-2' WHERE `id` = '237' [ RunTime:0.001746s ]
  298. UPDATE `nav_category_tag` SET `slug` = 'comsofts-3' WHERE `id` = '242' [ RunTime:0.001175s ]
  299. UPDATE `nav_category_tag` SET `slug` = 'comsofts-4' WHERE `id` = '243' [ RunTime:0.001275s ]
  300. UPDATE `nav_category_tag` SET `slug` = 'comsofts-5' WHERE `id` = '244' [ RunTime:0.001054s ]
  301. UPDATE `nav_category_tag` SET `slug` = 'comsofts-6' WHERE `id` = '245' [ RunTime:0.000994s ]
  302. UPDATE `nav_category_tag` SET `slug` = 'comsofts-7' WHERE `id` = '246' [ RunTime:0.000961s ]
  303. UPDATE `nav_category_tag` SET `slug` = 'comsofts-8' WHERE `id` = '248' [ RunTime:0.002431s ]
  304. UPDATE `nav_category_tag` SET `slug` = 'officetools-1' WHERE `id` = '249' [ RunTime:0.001442s ]
  305. UPDATE `nav_category_tag` SET `slug` = 'officetools-2' WHERE `id` = '250' [ RunTime:0.001030s ]
  306. UPDATE `nav_category_tag` SET `slug` = 'officetools-3' WHERE `id` = '251' [ RunTime:0.001060s ]
  307. UPDATE `nav_category_tag` SET `slug` = 'officetools-4' WHERE `id` = '252' [ RunTime:0.001011s ]
  308. UPDATE `nav_category_tag` SET `slug` = 'officetools-5' WHERE `id` = '253' [ RunTime:0.001068s ]
  309. UPDATE `nav_category_tag` SET `slug` = 'officetools-6' WHERE `id` = '254' [ RunTime:0.001324s ]
  310. UPDATE `nav_category_tag` SET `slug` = 'officetools-7' WHERE `id` = '255' [ RunTime:0.004335s ]
  311. UPDATE `nav_category_tag` SET `slug` = 'officetools-8' WHERE `id` = '256' [ RunTime:0.001148s ]
  312. UPDATE `nav_category_tag` SET `slug` = 'officetools-9' WHERE `id` = '257' [ RunTime:0.000987s ]
  313. UPDATE `nav_category_tag` SET `slug` = 'officetools-10' WHERE `id` = '258' [ RunTime:0.001311s ]
  314. UPDATE `nav_category_tag` SET `slug` = 'officetools-11' WHERE `id` = '259' [ RunTime:0.001019s ]
  315. SELECT COUNT(*) AS n FROM `nav_link` [ RunTime:0.000168s ]
  316. SELECT `id` FROM `nav_category` WHERE `status` = 1 ORDER BY `sort` DESC, `id` ASC [ RunTime:0.000184s ]
  317. SELECT COUNT(*) AS n FROM `nav_site` WHERE `slug` = 'bilibili-demo' [ RunTime:0.000149s ]
  318. SHOW COLUMNS FROM `nav_site` [ RunTime:0.000914s ]
  319. SELECT COUNT(*) AS n FROM `nav_like_log` [ RunTime:0.000153s ]
  320. SELECT `id` FROM `nav_link` LIMIT 1 [ RunTime:0.000112s ]
  321. SELECT `id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000105s ]
  322. SELECT `id` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000113s ]
  323. SELECT `id` FROM `nav_ad` LIMIT 1 [ RunTime:0.000104s ]
  324. SELECT `id` FROM `nav_ad_plan` LIMIT 1 [ RunTime:0.000107s ]
  325. SELECT `id`,`order_no`,`pay_channel`,`pay_trade_no` FROM `nav_friend_link` LIMIT 1 [ RunTime:0.000121s ]
  326. SELECT `id`,`type`,`tag_id` FROM `nav_dock` LIMIT 1 [ RunTime:0.000112s ]
  327. SHOW COLUMNS FROM `nav_dock` [ RunTime:0.000673s ]
  328. SHOW COLUMNS FROM `nav_ad` [ RunTime:0.000676s ]
  329. SELECT `gift_days`,`pay_channel`,`pay_trade_no` FROM `nav_ad` LIMIT 1 [ RunTime:0.000177s ]
  330. SHOW COLUMNS FROM `nav_ad_plan` [ RunTime:0.000636s ]
  331. SELECT `position` FROM `nav_ad_plan` LIMIT 1 [ RunTime:0.000164s ]
  332. SHOW COLUMNS FROM `nav_ad` [ RunTime:0.000729s ]
  333. SELECT `icon` FROM `nav_ad` LIMIT 1 [ RunTime:0.000130s ]
  334. SHOW COLUMNS FROM `nav_qlink` [ RunTime:0.000621s ]
  335. SELECT `subtitle` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000133s ]
  336. SHOW COLUMNS FROM `nav_site` [ RunTime:0.000698s ]
  337. SELECT `hide_code`,`password` FROM `nav_site` LIMIT 1 [ RunTime:0.000138s ]
  338. SELECT `pv`,`clicks`,`views_m`,`views_d`,`views_p` FROM `nav_site_view_day` LIMIT 1 [ RunTime:0.000120s ]
  339. SELECT `quick_default` FROM `nav_site` LIMIT 1 [ RunTime:0.000120s ]
  340. SELECT `badge_color` FROM `nav_site` LIMIT 1 [ RunTime:0.000103s ]
  341. SELECT `user_id`,`url_key`,`title`,`icon`,`description`,`badge`,`platforms` FROM `nav_user_quick` LIMIT 1 [ RunTime:0.000120s ]
  342. SELECT `slug` FROM `nav_plugin` LIMIT 1 [ RunTime:0.000110s ]
  343. SHOW COLUMNS FROM `nav_plugin` [ RunTime:0.000647s ]
  344. SELECT `type`,`url`,`icon_url`,`cover`,`category`,`color`,`badge`,`need_login`,`points_cost` FROM `nav_plugin` LIMIT 1 [ RunTime:0.000143s ]
  345. SHOW FULL COLUMNS FROM `nav_plugin` [ RunTime:0.000713s ]
  346. SELECT * FROM `nav_plugin` [ RunTime:0.000290s ]
  347. UPDATE `nav_plugin` SET `category` = 'plugin' WHERE `type` = 'local' AND `category` = 'life' AND `update_time` = `create_time` [ RunTime:0.000482s ]
  348. SHOW FULL COLUMNS FROM `nav_setting` [ RunTime:0.000769s ]
  349. SELECT * FROM `nav_setting` [ RunTime:0.000475s ]
  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.000196s ]
  351. SHOW COLUMNS FROM `nav_sponsor` [ RunTime:0.000758s ]
  352. SELECT `order_no`,`pay_time`,`ip` FROM `nav_sponsor` LIMIT 1 [ RunTime:0.000148s ]
  353. SHOW COLUMNS FROM `nav_sponsor_order` [ RunTime:0.000826s ]
  354. SELECT `order_no`,`sponsor_id`,`amount`,`base_amount`,`forever`,`include_site`,`ip` FROM `nav_sponsor_order` LIMIT 1 [ RunTime:0.000160s ]
  355. SHOW COLUMNS FROM `nav_user_favorite` [ RunTime:0.000611s ]
  356. SELECT `ip` FROM `nav_user_favorite` LIMIT 1 [ RunTime:0.000134s ]
  357. SHOW COLUMNS FROM `nav_user_like` [ RunTime:0.000572s ]
  358. SELECT `ip` FROM `nav_user_like` LIMIT 1 [ RunTime:0.000206s ]
  359. SHOW COLUMNS FROM `nav_points_log` [ RunTime:0.000577s ]
  360. SELECT `ip` FROM `nav_points_log` LIMIT 1 [ RunTime:0.000119s ]
  361. SHOW COLUMNS FROM `nav_invite_order` [ RunTime:0.000777s ]
  362. DELETE FROM `nav_sponsor` WHERE `order_no` = '' AND `pay_time` = 0 AND `name` LIKE '星友%' [ RunTime:0.000207s ]
  363. SELECT COUNT(*) AS `c` FROM `nav_sponsor` [ RunTime:0.000237s ]
  364. SHOW COLUMNS FROM `nav_article` [ RunTime:0.000701s ]
  365. SELECT COUNT(*) AS `c` FROM `nav_micro_post` [ RunTime:0.000135s ]
  366. SHOW COLUMNS FROM `nav_submit` [ RunTime:0.000708s ]
  367. SELECT `user_id` FROM `nav_submit` LIMIT 1 [ RunTime:0.001209s ]
  368. SHOW COLUMNS FROM `nav_submit` [ RunTime:0.002229s ]
  369. SELECT `amount`,`order_no`,`pay_time`,`site_id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000626s ]
  370. SELECT `email`,`scene` FROM `nav_user_email_code` LIMIT 1 [ RunTime:0.000251s ]
  371. SELECT `user_id`,`target_id` FROM `nav_user_history` LIMIT 1 [ RunTime:0.000159s ]
  372. UPDATE `nav_user` SET `email_verified` = 1 WHERE `email` = '' [ RunTime:0.000252s ]
  373. SELECT `code`,`status` FROM `nav_invite_code` LIMIT 1 [ RunTime:0.000125s ]
  374. SELECT `order_no`,`status`,`invite_code` FROM `nav_invite_order` LIMIT 1 [ RunTime:0.000125s ]
  375. SELECT `type`,`months`,`price` FROM `nav_member_plan` LIMIT 1 [ RunTime:0.000113s ]
  376. SELECT `points`,`bonus`,`price` FROM `nav_points_pack` LIMIT 1 [ RunTime:0.000190s ]
  377. SELECT `order_no`,`type`,`status` FROM `nav_member_order` LIMIT 1 [ RunTime:0.000220s ]
  378. SELECT `user_id`,`delta`,`type` FROM `nav_points_log` LIMIT 1 [ RunTime:0.000182s ]
  379. SELECT `ticket_hash`,`slug`,`bucket` FROM `nav_pkg_key_log` LIMIT 1 [ RunTime:0.000115s ]
  380. SHOW COLUMNS FROM `nav_user` [ RunTime:0.000845s ]
  381. SELECT `webmaster_expire` FROM `nav_user` LIMIT 1 [ RunTime:0.000153s ]
  382. SHOW INDEX FROM `nav_site` [ RunTime:0.000285s ]
  383. SHOW INDEX FROM `nav_article` [ RunTime:0.000190s ]
  384. SHOW INDEX FROM `nav_submit` [ RunTime:0.000158s ]
  385. SHOW INDEX FROM `nav_user` [ RunTime:0.000172s ]
  386. SHOW INDEX FROM `nav_points_log` [ RunTime:0.000162s ]
  387. SHOW INDEX FROM `nav_invite_order` [ RunTime:0.000213s ]
  388. SHOW INDEX FROM `nav_member_order` [ RunTime:0.000224s ]
  389. SHOW INDEX FROM `nav_ad` [ RunTime:0.000157s ]
  390. SHOW INDEX FROM `nav_sponsor` [ RunTime:0.000139s ]
  391. SHOW INDEX FROM `nav_sponsor_order` [ RunTime:0.000141s ]
  392. SELECT `id`,`status`,`device_hash` FROM `nav_secret_post` LIMIT 1 [ RunTime:0.000142s ]
  393. SELECT `id`,`post_id` FROM `nav_secret_report` LIMIT 1 [ RunTime:0.000109s ]
  394. SELECT `id`,`page_key`,`status`,`root_id` FROM `nav_comment` LIMIT 1 [ RunTime:0.000116s ]
  395. SHOW COLUMNS FROM `nav_comment` [ RunTime:0.001829s ]
  396. SELECT `ip` FROM `nav_comment` LIMIT 1 [ RunTime:0.000177s ]
  397. SHOW COLUMNS FROM `nav_qlink` [ RunTime:0.000671s ]
  398. SELECT `folder_kind` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000155s ]
  399. SELECT `qlink_id`,`kind`,`ref_id`,`sort` FROM `nav_qlink_item` LIMIT 1 [ RunTime:0.000129s ]
  400. SELECT COUNT(*) AS `c` FROM `nav_right_menu` [ RunTime:0.000132s ]
  401. SELECT `id`,`scope_type`,`enabled` FROM `nav_right_menu` LIMIT 1 [ RunTime:0.000119s ]
  402. SELECT `rid`,`label`,`action` FROM `nav_right_menu_item` LIMIT 1 [ RunTime:0.000125s ]
  403. SELECT `id`,`rid`,`sort` FROM `nav_right_menu_item` WHERE `action` = 'fav' AND `label` = '收藏 / 屏蔽此站' [ RunTime:0.000176s ]
  404. ALTER TABLE `nav_right_menu` MODIFY COLUMN `scope_type` varchar(50) NOT NULL DEFAULT 'site' [ RunTime:0.004232s ]
  405. ALTER TABLE `nav_right_menu_item` MODIFY COLUMN `icon` varchar(500) NOT NULL DEFAULT '' [ RunTime:0.003490s ]
  406. SELECT `icon` FROM `nav_right_menu_item` LIMIT 1 [ RunTime:0.000228s ]
  407. SELECT `pid` FROM `nav_right_menu_item` LIMIT 1 [ RunTime:0.000148s ]
  408. SELECT COUNT(*) AS `c` FROM `nav_home_module` [ RunTime:0.000352s ]
  409. SELECT `id`,`mkey`,`zone` FROM `nav_home_module` LIMIT 1 [ RunTime:0.000296s ]
  410. SELECT `id`,`mkey` FROM `nav_home_module` [ RunTime:0.000154s ]
  411. SELECT `id`,`mkey`,`sort` FROM `nav_home_module` [ RunTime:0.000271s ]
  412. SELECT `block_id`,`type`,`source_id`,`weight`,`is_ad` FROM `nav_home_pic` LIMIT 1 [ RunTime:0.000172s ]
  413. SELECT COUNT(*) AS `c` FROM `nav_home_block` [ RunTime:0.000125s ]
  414. SELECT `id` FROM `nav_home_block` ORDER BY `sort` ASC, `id` ASC LIMIT 1 [ RunTime:0.000182s ]
  415. UPDATE `nav_home_pic` SET `block_id` = '3' WHERE `block_id` = 0 [ RunTime:0.000198s ]
  416. SELECT `rank_type`,`rank_period` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000122s ]
  417. SELECT `is_countdown` FROM `nav_home_pic` LIMIT 1 [ RunTime:0.000159s ]
  418. SELECT `note_text`,`note_author` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000147s ]
  419. SELECT `is_video` FROM `nav_home_pic` LIMIT 1 [ RunTime:0.000120s ]
  420. SELECT `audience`,`ab_enable`,`ab_ratio` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000132s ]
  421. SELECT `pic_id`,`day`,`views`,`clicks` FROM `nav_home_pic_stat` LIMIT 1 [ RunTime:0.000127s ]
  422. SELECT `block_id`,`day`,`grp`,`exposes`,`clicks` FROM `nav_home_block_stat` LIMIT 1 [ RunTime:0.000243s ]
  423. SELECT `note_items` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000869s ]
  424. SELECT `cat`,`item_id` FROM `nav_shijuan_item` LIMIT 1 [ RunTime:0.000237s ]
  425. SELECT `item_id` FROM `nav_shijuan_download` LIMIT 1 [ RunTime:0.000127s ]
  426. SELECT `slug` FROM `nav_shijuan_category` LIMIT 1 [ RunTime:0.000145s ]
  427. SELECT `slug` FROM `nav_shijuan_subject` LIMIT 1 [ RunTime:0.000186s ]
  428. SELECT `file`,`license`,`rtype`,`status`,`update_time` FROM `nav_shijuan_item` LIMIT 1 [ RunTime:0.000265s ]
  429. SELECT `icon` FROM `nav_shijuan_subject` LIMIT 1 [ RunTime:0.000135s ]
  430. SELECT `icon` FROM `nav_shijuan_category` LIMIT 1 [ RunTime:0.000113s ]
  431. SELECT `feedback`,`feedback_status`,`feedback_time` FROM `nav_shijuan_item` LIMIT 1 [ RunTime:0.000225s ]
  432. SELECT `cover` FROM `nav_sponsor` LIMIT 1 [ RunTime:0.000159s ]
  433. SELECT `feedback`,`feedback_status`,`feedback_time` FROM `nav_article` LIMIT 1 [ RunTime:0.000201s ]
  434. SELECT `cover`,`bg_style`,`name_color`,`extra_color` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000172s ]
  435. SELECT `parent_id` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000137s ]
  436. SELECT `is_rec` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000143s ]
  437. SELECT `is_nav` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000171s ]
  438. SELECT `banner_img`,`banner_sub`,`tile_sort` FROM `nav_article` LIMIT 1 [ RunTime:0.000600s ]
  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.000181s ]
  440. SELECT `remark` FROM `nav_article` LIMIT 1 [ RunTime:0.000155s ]
  441. SELECT `points_on`,`points_price` FROM `nav_article` LIMIT 1 [ RunTime:0.000148s ]
  442. SELECT `id` FROM `nav_article_points_unlock` LIMIT 1 [ RunTime:0.000169s ]
  443. SELECT `id` FROM `nav_points_signin` LIMIT 1 [ RunTime:0.000121s ]
  444. SELECT `id` FROM `nav_dl_ticket` LIMIT 1 [ RunTime:0.000161s ]
  445. SELECT `id`,`type`,`url` FROM `nav_article_menu` LIMIT 1 [ RunTime:0.000127s ]
  446. SELECT COUNT(*) AS `c` FROM `nav_article_menu` [ RunTime:0.000173s ]
  447. SHOW COLUMNS FROM `nav_article_menu` [ RunTime:0.000825s ]
  448. SELECT `hide_in_parent` FROM `nav_article_menu` LIMIT 1 [ RunTime:0.000235s ]
  449. SHOW COLUMNS FROM `nav_article_menu` [ RunTime:0.000638s ]
  450. SELECT `title_color` FROM `nav_article_menu` LIMIT 1 [ RunTime:0.000155s ]
  451. SELECT `article_cfg` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000123s ]
  452. SELECT `is_list` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000249s ]
  453. SHOW COLUMNS FROM `nav_link` [ RunTime:0.000702s ]
  454. SELECT `name_color` FROM `nav_link` LIMIT 1 [ RunTime:0.000158s ]
  455. SHOW COLUMNS FROM `nav_fx_url` [ RunTime:0.000584s ]
  456. SELECT `pass_hash` FROM `nav_fx_url` LIMIT 1 [ RunTime:0.000128s ]
  457. SHOW COLUMNS FROM `nav_fx_url` [ RunTime:0.000614s ]
  458. SELECT `pass_view` FROM `nav_fx_url` LIMIT 1 [ RunTime:0.000130s ]
  459. SHOW COLUMNS FROM `nav_fx_url` [ RunTime:0.000708s ]
  460. SELECT `notified` FROM `nav_fx_url` LIMIT 1 [ RunTime:0.000153s ]
  461. SHOW COLUMNS FROM `nav_fx_url` [ RunTime:0.000598s ]
  462. SELECT `view_time` FROM `nav_fx_url` LIMIT 1 [ RunTime:0.000131s ]
  463. SELECT `name_color` FROM `nav_category` LIMIT 1 [ RunTime:0.000606s ]
  464. SELECT `name_color`,`icon_color` FROM `nav_category_tag` LIMIT 1 [ RunTime:0.000168s ]
  465. SELECT `name_color`,`icon_color` FROM `nav_friend_link` LIMIT 1 [ RunTime:0.000432s ]
  466. SELECT `id`,`source`,`type`,`target_id`,`url_key` FROM `nav_user_dock` LIMIT 1 [ RunTime:0.000187s ]
  467. SHOW FULL COLUMNS FROM `nav_category` [ RunTime:0.000904s ]
  468. SELECT * FROM `nav_category` WHERE `slug` = 'githubapp' AND `status` = 1 LIMIT 1 [ RunTime:0.000404s ]
  469. SHOW FULL COLUMNS FROM `nav_category_tag` [ RunTime:0.000688s ]
  470. SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000424s ]
  471. SHOW FULL COLUMNS FROM `nav_site` [ RunTime:0.001249s ]
  472. SELECT `hide_code` FROM `nav_site` LIMIT 1 [ RunTime:0.000198s ]
  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.006127s ]
  474. SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `category_id` = 44 AND `hide_code` = '' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000485s ]
  475. SELECT * FROM `nav_site` WHERE `status` = 1 AND `category_id` = 44 AND `hide_code` = '' ORDER BY `sort` DESC,`id` DESC LIMIT 25,25 [ RunTime:0.000913s ]
  476. SHOW FULL COLUMNS FROM `nav_like_log` [ RunTime:0.000832s ]
  477. SELECT `target_id` FROM `nav_like_log` WHERE `type` = 'site' AND `ip` = '216.73.216.88' [ RunTime:0.000628s ]
  478. SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001242s ]
  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.005155s ]
  480. SHOW FULL COLUMNS FROM `nav_comment` [ RunTime:0.001032s ]
  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.000486s ]
  482. SHOW FULL COLUMNS FROM `nav_ad_plan` [ RunTime:0.000876s ]
  483. SELECT * FROM `nav_ad_plan` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000928s ]
  484. SELECT SUM(`views`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.006041s ]
  485. SHOW FULL COLUMNS FROM `nav_article` [ RunTime:0.000908s ]
  486. SELECT SUM(`views`) AS think_sum FROM `nav_article` WHERE `status` = 1 [ RunTime:0.012316s ]
  487. SELECT SUM(`likes`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.004397s ]
  488. SELECT COUNT(*) AS think_count FROM `nav_category_tag` WHERE `status` = 1 [ RunTime:0.000279s ]
  489. SHOW FULL COLUMNS FROM `nav_user` [ RunTime:0.000851s ]
  490. SELECT COUNT(*) AS think_count FROM `nav_user` [ RunTime:0.000166s ]
  491. SELECT SUM(`views_today`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_date` = 1795276800 [ RunTime:0.000493s ]
  492. SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000395s ]
  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.006431s ]
  494. SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_date` = 1795276800 AND `views_today` > 0 ORDER BY `views_today` DESC,`id` DESC LIMIT 8 [ RunTime:0.000561s ]
  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.000464s ]
  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.006436s ]
  497. SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' ORDER BY `views` DESC,`id` DESC LIMIT 8 [ RunTime:0.000545s ]
  498. SHOW FULL COLUMNS FROM `nav_ad` [ RunTime:0.000937s ]
  499. SELECT * FROM `nav_ad` WHERE `status` = 2 AND `position` = 'home_banner' AND `start_time` <= 1795302370 AND `end_time` >= 1795302370 ORDER BY `sort` DESC,`id` DESC LIMIT 20 [ RunTime:0.000370s ]
  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.000939s ]
  502. SELECT * FROM `nav_home_block` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000256s ]
  503. SHOW FULL COLUMNS FROM `nav_home_module` [ RunTime:0.001176s ]
  504. SELECT * FROM `nav_home_module` WHERE `zone` = 'rail' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000259s ]
  505. SELECT * FROM `nav_home_block` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000279s ]
  506. SELECT * FROM `nav_home_module` WHERE `zone` = 'rail' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000170s ]
  507. SHOW FULL COLUMNS FROM `nav_link` [ RunTime:0.000707s ]
  508. SELECT * FROM `nav_link` WHERE `status` = 1 AND `position` = 'top' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000264s ]
  509. SELECT * FROM `nav_link` WHERE `status` = 1 AND `position` = 'foot' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000324s ]
  510. SHOW FULL COLUMNS FROM `nav_article_cat` [ RunTime:0.000655s ]
  511. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000257s ]
  512. SELECT * FROM `nav_site` WHERE `id` IN (208,97,69,152,41,124,207) [ RunTime:0.000257s ]
  513. SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.003975s ]
  514. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 [ RunTime:0.002462s ]
  515. SHOW FULL COLUMNS FROM `nav_notice` [ RunTime:0.000681s ]
  516. SELECT COUNT(*) AS think_count FROM `nav_notice` WHERE `status` = 1 [ RunTime:0.000365s ]
  517. SHOW FULL COLUMNS FROM `nav_sponsor` [ RunTime:0.000892s ]
  518. SELECT COUNT(*) AS think_count FROM `nav_sponsor` WHERE `status` = 1 [ RunTime:0.000188s ]
  519. SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `create_time` >= 1795276800 [ RunTime:0.000444s ]
  520. SELECT * FROM `nav_ad` WHERE `status` = 2 AND `position` = 'home_fixed' AND `start_time` <= 1795302370 AND `end_time` >= 1795302370 ORDER BY `sort` DESC,`id` DESC LIMIT 27 [ RunTime:0.000368s ]
0.490503s