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

没有找到想要的内容?可以试试更短的关键词,或从上方分类频道中浏览;也可以 查看全部文章。

排序 更新· 浏览· 点赞· 评论
这里还没有文章
« 1 … »
推荐专区
友情链接
必备 枫叶起始页(必备)
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-11-18 01:09:31 HTTP/1.1 GET : https://dhw.wchulian.com.cn/articles?page=215&q=%E6%B8%B8%E6%88%8F%E5%B7%A5%E5%85%B7
  2. 运行时间 : 1.193214s [ 吞吐率:0.84req/s ] 内存消耗:12,950.40kb 文件加载:188
  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.23 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 ( 8.74 KB )
  30. /www/wwwroot/daohw.cn/app/common/db_upgrade.php ( 119.50 KB )
  31. /www/wwwroot/daohw.cn/app/common/schema.php ( 120.82 KB )
  32. /www/wwwroot/daohw.cn/app/common/seed.php ( 139.52 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 ( 37.61 KB )
  42. /www/wwwroot/daohw.cn/app/common/content.php ( 26.49 KB )
  43. /www/wwwroot/daohw.cn/app/common/widget.php ( 37.43 KB )
  44. /www/wwwroot/daohw.cn/app/common/money.php ( 36.77 KB )
  45. /www/wwwroot/daohw.cn/app/common/http.php ( 11.16 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 ( 14.29 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.26 KB )
  57. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/helper.php ( 18.77 KB )
  58. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Config.php ( 5.93 KB )
  59. /www/wwwroot/daohw.cn/config/app.php ( 0.95 KB )
  60. /www/wwwroot/daohw.cn/config/cache.php ( 0.78 KB )
  61. /www/wwwroot/daohw.cn/config/console.php ( 0.64 KB )
  62. /www/wwwroot/daohw.cn/config/cookie.php ( 0.56 KB )
  63. /www/wwwroot/daohw.cn/config/database.php ( 2.13 KB )
  64. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  65. /www/wwwroot/daohw.cn/config/filesystem.php ( 0.61 KB )
  66. /www/wwwroot/daohw.cn/config/lang.php ( 0.91 KB )
  67. /www/wwwroot/daohw.cn/config/log.php ( 1.35 KB )
  68. /www/wwwroot/daohw.cn/config/middleware.php ( 0.19 KB )
  69. /www/wwwroot/daohw.cn/config/route.php ( 1.89 KB )
  70. /www/wwwroot/daohw.cn/config/session.php ( 0.57 KB )
  71. /www/wwwroot/daohw.cn/config/shijuan.php ( 1.16 KB )
  72. /www/wwwroot/daohw.cn/config/trace.php ( 0.34 KB )
  73. /www/wwwroot/daohw.cn/config/view.php ( 1.20 KB )
  74. /www/wwwroot/daohw.cn/app/event.php ( 0.25 KB )
  75. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Event.php ( 7.77 KB )
  76. /www/wwwroot/daohw.cn/app/service.php ( 0.13 KB )
  77. /www/wwwroot/daohw.cn/app/AppService.php ( 0.26 KB )
  78. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  79. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  80. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  81. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  82. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  83. /www/wwwroot/daohw.cn/vendor/services.php ( 0.14 KB )
  84. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  85. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  86. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  87. /www/wwwroot/daohw.cn/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  88. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  89. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  90. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/Paginator.php ( 11.86 KB )
  91. /www/wwwroot/daohw.cn/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  92. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/Model.php ( 23.55 KB )
  93. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 21.05 KB )
  94. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/AutoWriteData.php ( 4.20 KB )
  95. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 6.75 KB )
  96. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/DbConnect.php ( 5.16 KB )
  97. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.33 KB )
  98. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 28.30 KB )
  99. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  100. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  101. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/contract/Modelable.php ( 0.09 KB )
  102. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  103. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/DbManager.php ( 8.52 KB )
  104. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  105. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  106. /www/wwwroot/daohw.cn/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  107. /www/wwwroot/daohw.cn/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  108. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  109. /www/wwwroot/daohw.cn/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  110. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/helper/Arr.php ( 17.45 KB )
  111. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.84 KB )
  112. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/cache/Driver.php ( 9.02 KB )
  113. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  114. /www/wwwroot/daohw.cn/app/Request.php ( 0.09 KB )
  115. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Request.php ( 54.64 KB )
  116. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/traits/UrlHandler.php ( 6.05 KB )
  117. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/traits/DomainHandler.php ( 5.49 KB )
  118. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/traits/HttpMethodHandler.php ( 4.74 KB )
  119. /www/wwwroot/daohw.cn/app/middleware.php ( 0.37 KB )
  120. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  121. /www/wwwroot/daohw.cn/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  122. /www/wwwroot/daohw.cn/app/middleware/SecurityHeaders.php ( 1.71 KB )
  123. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  124. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/RuleName.php ( 5.74 KB )
  125. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  126. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.41 KB )
  127. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/Rule.php ( 27.49 KB )
  128. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  129. /www/wwwroot/daohw.cn/route/apisend.php ( 2.09 KB )
  130. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  131. /www/wwwroot/daohw.cn/route/app.php ( 25.75 KB )
  132. /www/wwwroot/daohw.cn/route/shijuan.php ( 1.60 KB )
  133. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  134. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/Dispatch.php ( 11.32 KB )
  135. /www/wwwroot/daohw.cn/app/controller/Front.php ( 1.12 KB )
  136. /www/wwwroot/daohw.cn/app/BaseController.php ( 2.05 KB )
  137. /www/wwwroot/daohw.cn/app/controller/front/ContextTrait.php ( 16.29 KB )
  138. /www/wwwroot/daohw.cn/app/controller/front/HomeTrait.php ( 23.93 KB )
  139. /www/wwwroot/daohw.cn/app/controller/front/ArticleTrait.php ( 32.48 KB )
  140. /www/wwwroot/daohw.cn/app/controller/front/SponsorTrait.php ( 14.63 KB )
  141. /www/wwwroot/daohw.cn/app/controller/front/ApplyTrait.php ( 12.30 KB )
  142. /www/wwwroot/daohw.cn/app/controller/front/ToolTrait.php ( 12.63 KB )
  143. /www/wwwroot/daohw.cn/app/controller/front/DyTrait.php ( 14.55 KB )
  144. /www/wwwroot/daohw.cn/app/controller/front/SecretTrait.php ( 2.17 KB )
  145. /www/wwwroot/daohw.cn/app/controller/front/DownloadTrait.php ( 5.99 KB )
  146. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  147. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 5.73 KB )
  148. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/PDOConnection.php ( 53.74 KB )
  149. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Connection.php ( 8.39 KB )
  150. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.57 KB )
  151. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.58 KB )
  152. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Builder.php ( 24.07 KB )
  153. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.50 KB )
  154. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/log/driver/File.php ( 6.10 KB )
  155. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  156. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  157. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  158. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/exception/PDOException.php ( 1.50 KB )
  159. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/exception/DbException.php ( 1.38 KB )
  160. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Log.php ( 3.07 KB )
  161. /www/wwwroot/daohw.cn/vendor/psr/log/src/LogLevel.php ( 0.33 KB )
  162. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Query.php ( 15.97 KB )
  163. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/BaseQuery.php ( 45.13 KB )
  164. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  165. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  166. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 20.07 KB )
  167. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  168. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.01 KB )
  169. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 19.37 KB )
  170. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.11 KB )
  171. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.63 KB )
  172. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  173. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  174. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/exception/ErrorException.php ( 1.72 KB )
  175. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Raw.php ( 1.30 KB )
  176. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Cache.php ( 2.06 KB )
  177. /www/wwwroot/daohw.cn/app/utils/IpUtils.php ( 5.41 KB )
  178. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Response.php ( 9.07 KB )
  179. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/response/View.php ( 3.29 KB )
  180. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  181. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
  182. /www/wwwroot/daohw.cn/vendor/topthink/think-view/src/Think.php ( 8.38 KB )
  183. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.60 KB )
  184. /www/wwwroot/daohw.cn/vendor/topthink/think-template/src/Template.php ( 46.61 KB )
  185. /www/wwwroot/daohw.cn/vendor/topthink/think-template/src/template/driver/File.php ( 2.41 KB )
  186. /www/wwwroot/daohw.cn/vendor/topthink/think-template/src/template/contract/DriverInterface.php ( 0.86 KB )
  187. /www/wwwroot/daohw.cn/runtime/temp/a330fbbb42d980d66ee81c8ed24b3a0a.php ( 184.13 KB )
  188. /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:112 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:112 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:112 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:112 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:112 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:112 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:112 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:112 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:112 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:112 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:112 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:112 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:112 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:112 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:112 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:112 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:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_acat_slug'
  18. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_acat_parent'
  19. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_amenu_parent'
  20. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_article_cat'
  21. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_sponsor_site'
  22. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_sponsor_order_no'
  23. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_sponsor_order_sp'
  24. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_link_pos'
  25. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_link_pid'
  26. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_submit_status'
  27. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_submit_cat'
  28. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_submit_create'
  29. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_qlink_sort'
  30. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_qlink_item'
  31. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_qlink_item_sort'
  32. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_ad_state'
  33. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_ad_time'
  34. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_adplan_sort'
  35. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_friend_status'
  36. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_friend_order'
  37. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dock_sort'
  38. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_plugin_slug'
  39. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_plugin_sort'
  40. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dypage_alias'
  41. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dypage_sort'
  42. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_devphase_sort'
  43. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_devlog_day'
  44. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_api_log_channel'
  45. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_api_log_status'
  46. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_api_log_time'
  47. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_name'
  48. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_email'
  49. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_status'
  50. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_regip'
  51. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_create'
  52. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_vip_expire'
  53. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_webmaster_expire'
  54. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_level'
  55. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_token'
  56. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_token_uid'
  57. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_token_exp'
  58. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_fav'
  59. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
  60. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_quick_uid'
  61. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_note'
  62. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_note_uid'
  63. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_theme'
  64. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_theme_uid'
  65. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_like'
  66. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_code'
  67. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_code_exp'
  68. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_user_hist'
  69. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_user_hist_time'
  70. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_invite_code'
  71. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_status'
  72. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_user'
  73. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_invite_order'
  74. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_st'
  75. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_ip'
  76. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_uid'
  77. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_create'
  78. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_pay'
  79. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_invite_order_st_pay'
  80. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_member_plan_type'
  81. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_pack_on'
  82. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_member_order'
  83. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_member_order_uid'
  84. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_member_order_st'
  85. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_member_order_type_pay'
  86. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_log_uid'
  87. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_log_create'
  88. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_article_points_once'
  89. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_article_points_day'
  90. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_article_points_ip'
  91. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_points_signin_day'
  92. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_signin_ip'
  93. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_points_signin_dev'
  94. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_dl_ticket_sig'
  95. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_ticket_exp'
  96. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_pkg_key_once'
  97. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_pkg_key_bucket'
  98. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_pkg_key_slug'
  99. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_new'
  100. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_hot'
  101. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_dev'
  102. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_uid'
  103. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_ip'
  104. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_hash'
  105. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secret_site'
  106. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secrep_post'
  107. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_secrep_state'
  108. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_page'
  109. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_root'
  110. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_uid'
  111. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_dev'
  112. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_comment_time'
  113. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_rm_scope'
  114. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_rm_item_rid'
  115. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_home_module_mkey'
  116. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_home_block_sort'
  117. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_home_pic_sort'
  118. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_home_pic_block'
  119. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_pic_stat_day'
  120. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_block_stat_day'
  121. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_shijuan_subject_slug'
  122. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_shijuan_cat_slug'
  123. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_shijuan_cat_subject'
  124. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_shijuan_item_cat_id'
  125. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_shijuan_item_cat_sort'
  126. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_shijuan_item_date'
  127. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_shijuan_dl_item'
  128. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_unlock_art'
  129. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_unlock_token'
  130. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_unlock_email'
  131. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_unlock_mt'
  132. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_dl_order_no'
  133. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_order_email'
  134. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_order_art'
  135. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_order_ip'
  136. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ux_nav_dl_quota'
  137. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_log_art'
  138. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ix_nav_dl_log_user'
  139. [nav] /www/wwwroot/daohw.cn/app/common/db_upgrade.php:112 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.000311s ]
  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.001540s ]
  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.000417s ]
  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 '分类主题色', `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.000357s ]
  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 '图标', `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.000238s ]
  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.002892s ]
  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.000274s ]
  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.000285s ]
  10. 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.000242s ]
  11. 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.000242s ]
  12. 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.000337s ]
  13. 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.000246s ]
  14. 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.000246s ]
  15. 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.002806s ]
  16. 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.000685s ]
  17. 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 '链接名称', `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.000336s ]
  18. 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.000388s ]
  19. 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 '文件夹样式类型', `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.000390s ]
  20. 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.000484s ]
  21. 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.000311s ]
  22. 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.000228s ]
  23. 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 '网站图标地址', `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.000578s ]
  24. 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.000387s ]
  25. 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.000317s ]
  26. 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.000264s ]
  27. 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.000314s ]
  28. 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.000337s ]
  29. 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.000260s ]
  30. 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.000360s ]
  31. 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.000306s ]
  32. 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.000228s ]
  33. 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.000253s ]
  34. 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.000410s ]
  35. 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.000259s ]
  36. 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.000227s ]
  37. 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.000232s ]
  38. 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.000528s ]
  39. 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.000234s ]
  40. 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.000353s ]
  41. 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.000238s ]
  42. 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.000234s ]
  43. 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.000190s ]
  44. 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.003347s ]
  45. 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.000290s ]
  46. 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.000407s ]
  47. 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.000410s ]
  48. 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.000432s ]
  49. 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.000292s ]
  50. 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.000244s ]
  51. 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.000313s ]
  52. 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(20) NOT NULL DEFAULT 'site' COMMENT '作用范围类型(site 站点 / cat 分类 / page 页面)', `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.000471s ]
  53. 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.000259s ]
  54. 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.000237s ]
  55. 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.000493s ]
  56. 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.000373s ]
  57. 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.000501s ]
  58. 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.000473s ]
  59. 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.000328s ]
  60. 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.000251s ]
  61. 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.000277s ]
  62. 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.000232s ]
  63. 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.002615s ]
  64. 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.000247s ]
  65. 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.000244s ]
  66. 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.000259s ]
  67. SELECT COUNT(*) AS `c` FROM `nav_devphase` [ RunTime:0.000301s ]
  68. SELECT COUNT(*) AS `c` FROM `nav_devlog` [ RunTime:0.000200s ]
  69. SELECT `k`,`v` FROM `nav_setting` WHERE `k` IN ('ad_banner_total','ad_slots') [ RunTime:0.000215s ]
  70. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_on','1','1794935371') [ RunTime:0.000226s ]
  71. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_free_audit','0','1794935371') [ RunTime:0.000196s ]
  72. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_price','0','1794935371') [ RunTime:0.000281s ]
  73. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_force_pay','0','1794935371') [ RunTime:0.000230s ]
  74. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_pay_audit','0','1794935371') [ RunTime:0.000253s ]
  75. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_on','1','1794935371') [ RunTime:0.000202s ]
  76. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_price_month','0','1794935371') [ RunTime:0.000191s ]
  77. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_free_audit','0','1794935371') [ RunTime:0.002934s ]
  78. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_free_months','1','1794935371') [ RunTime:0.000389s ]
  79. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_require_mark','1','1794935371') [ RunTime:0.000260s ]
  80. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_contact','','1794935371') [ RunTime:0.000202s ]
  81. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_rows','2','1794935371') [ RunTime:0.000193s ]
  82. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_cols','1','1794935371') [ RunTime:0.000207s ]
  83. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_total','24','1794935371') [ RunTime:0.000214s ]
  84. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_rows','2','1794935371') [ RunTime:0.000220s ]
  85. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_cols','9','1794935371') [ RunTime:0.000208s ]
  86. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_total','24','1794935371') [ RunTime:0.000229s ]
  87. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_price','0','1794935371') [ RunTime:0.000208s ]
  88. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('featured_cols','7','1794935371') [ RunTime:0.000207s ]
  89. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('featured_total','14','1794935371') [ RunTime:0.000353s ]
  90. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pick_on','1','1794935371') [ RunTime:0.000207s ]
  91. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pick_cols','5','1794935371') [ RunTime:0.000224s ]
  92. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pick_cols_m','3','1794935371') [ RunTime:0.000200s ]
  93. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_on','1','1794935371') [ RunTime:0.000220s ]
  94. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_cols','5','1794935371') [ RunTime:0.000245s ]
  95. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_cols_m','3','1794935371') [ RunTime:0.000216s ]
  96. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('quick_rows','2','1794935371') [ RunTime:0.000206s ]
  97. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_on','0','1794935371') [ RunTime:0.000213s ]
  98. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_note','','1794935371') [ RunTime:0.000206s ]
  99. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_on','1','1794935371') [ RunTime:0.000210s ]
  100. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_alipay','','1794935371') [ RunTime:0.000215s ]
  101. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_wechat','','1794935371') [ RunTime:0.000201s ]
  102. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_alipay','0','1794935371') [ RunTime:0.000205s ]
  103. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_wxpay','0','1794935371') [ RunTime:0.000193s ]
  104. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_url','','1794935371') [ RunTime:0.000195s ]
  105. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_pid','','1794935371') [ RunTime:0.003502s ]
  106. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_key','','1794935371') [ RunTime:0.000220s ]
  107. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_on','0','1794935371') [ RunTime:0.000198s ]
  108. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_appid','','1794935371') [ RunTime:0.000207s ]
  109. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_private_key','','1794935371') [ RunTime:0.000306s ]
  110. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_public_key','','1794935371') [ RunTime:0.000206s ]
  111. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_on','0','1794935371') [ RunTime:0.000213s ]
  112. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_mchid','','1794935371') [ RunTime:0.000209s ]
  113. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_appid','','1794935371') [ RunTime:0.000670s ]
  114. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_v3key','','1794935371') [ RunTime:0.000208s ]
  115. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_serial','','1794935371') [ RunTime:0.000201s ]
  116. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_private_key','','1794935371') [ RunTime:0.000208s ]
  117. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_platform_cert','','1794935371') [ RunTime:0.000292s ]
  118. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_on','1','1794935371') [ RunTime:0.000209s ]
  119. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_price','0','1794935371') [ RunTime:0.000216s ]
  120. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_free_audit','0','1794935371') [ RunTime:0.000210s ]
  121. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_contact','','1794935371') [ RunTime:0.000389s ]
  122. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_on','1','1794935371') [ RunTime:0.000322s ]
  123. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_amounts','5,10,20,50,100','1794935371') [ RunTime:0.000813s ]
  124. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_min','1','1794935371') [ RunTime:0.000302s ]
  125. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_max','9999','1794935371') [ RunTime:0.000364s ]
  126. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_rules','','1794935371') [ RunTime:0.000300s ]
  127. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_audit','0','1794935371') [ RunTime:0.000217s ]
  128. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_forever_on','0','1794935371') [ RunTime:0.000224s ]
  129. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_forever_price','10','1794935371') [ RunTime:0.000259s ]
  130. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_normal_price','0','1794935371') [ RunTime:0.000221s ]
  131. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_best_price','0','1794935371') [ RunTime:0.000226s ]
  132. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_any_include','0','1794935371') [ RunTime:0.000236s ]
  133. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_top_min','0','1794935371') [ RunTime:0.000293s ]
  134. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('app_debug','0','1794935371') [ RunTime:0.000206s ]
  135. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('dock_on','1','1794935371') [ RunTime:0.000213s ]
  136. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('member_on','1','1794935371') [ RunTime:0.000220s ]
  137. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('member_pay_on','1','1794935371') [ RunTime:0.000223s ]
  138. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('webmaster_on','0','1794935371') [ RunTime:0.000202s ]
  139. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('points_on','1','1794935371') [ RunTime:0.000224s ]
  140. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('member_note','','1794935371') [ RunTime:0.000255s ]
  141. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('points_note','','1794935371') [ RunTime:0.000576s ]
  142. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_gate_on','1','1794935371') [ RunTime:0.000235s ]
  143. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_quota_anon','60','1794935371') [ RunTime:0.000591s ]
  144. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_quota_user','300','1794935371') [ RunTime:0.000732s ]
  145. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pkg_quota_vip','0','1794935371') [ RunTime:0.000217s ]
  146. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_on','0','1794935371') [ RunTime:0.000231s ]
  147. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_audit','1','1794935371') [ RunTime:0.000213s ]
  148. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_max_len','300','1794935371') [ RunTime:0.000246s ]
  149. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_rate','60','1794935371') [ RunTime:0.000191s ]
  150. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_day_limit','10','1794935371') [ RunTime:0.002648s ]
  151. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_ip_day_limit','5','1794935371') [ RunTime:0.000191s ]
  152. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_region','1','1794935371') [ RunTime:0.000198s ]
  153. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_home','0','1794935371') [ RunTime:0.000238s ]
  154. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('secret_site_login','0','1794935371') [ RunTime:0.000188s ]
  155. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_on','1','1794935371') [ RunTime:0.000185s ]
  156. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_login','0','1794935371') [ RunTime:0.000196s ]
  157. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_guest_reply','1','1794935371') [ RunTime:0.000217s ]
  158. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_audit','0','1794935371') [ RunTime:0.000274s ]
  159. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_max_len','500','1794935371') [ RunTime:0.000191s ]
  160. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_rate','30','1794935371') [ RunTime:0.000195s ]
  161. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_page_size','10','1794935371') [ RunTime:0.000187s ]
  162. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_region','1','1794935371') [ RunTime:0.000191s ]
  163. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('comment_admin_badge','1','1794935371') [ RunTime:0.000193s ]
  164. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('right_menu_on','1','1794935371') [ RunTime:0.000194s ]
  165. SELECT COUNT(*) AS `c` FROM `nav_member_plan` [ RunTime:0.000267s ]
  166. SELECT COUNT(*) AS `c` FROM `nav_points_pack` [ RunTime:0.000216s ]
  167. SHOW COLUMNS FROM `nav_site` [ RunTime:0.002317s ]
  168. SHOW COLUMNS FROM `nav_site` [ RunTime:0.001186s ]
  169. SHOW COLUMNS FROM `nav_site` [ RunTime:0.001114s ]
  170. SELECT `id`,`slug` FROM `nav_category` [ RunTime:0.000223s ]
  171. SELECT COUNT(*) AS n FROM `nav_category_tag` [ RunTime:0.000200s ]
  172. SELECT `id`,`category_id` FROM `nav_category_tag` ORDER BY `category_id` ASC, `sort` DESC, `id` ASC [ RunTime:0.003143s ]
  173. UPDATE `nav_category_tag` SET `slug` = 'video-1' WHERE `id` = '1' [ RunTime:0.009508s ]
  174. UPDATE `nav_category_tag` SET `slug` = 'video-2' WHERE `id` = '2' [ RunTime:0.005300s ]
  175. UPDATE `nav_category_tag` SET `slug` = 'video-3' WHERE `id` = '3' [ RunTime:0.005638s ]
  176. UPDATE `nav_category_tag` SET `slug` = 'video-4' WHERE `id` = '4' [ RunTime:0.003099s ]
  177. UPDATE `nav_category_tag` SET `slug` = 'video-5' WHERE `id` = '5' [ RunTime:0.007873s ]
  178. UPDATE `nav_category_tag` SET `slug` = 'video-6' WHERE `id` = '6' [ RunTime:0.006751s ]
  179. UPDATE `nav_category_tag` SET `slug` = 'video-7' WHERE `id` = '7' [ RunTime:0.002083s ]
  180. UPDATE `nav_category_tag` SET `slug` = 'video-8' WHERE `id` = '8' [ RunTime:0.006685s ]
  181. UPDATE `nav_category_tag` SET `slug` = 'video-9' WHERE `id` = '9' [ RunTime:0.003180s ]
  182. UPDATE `nav_category_tag` SET `slug` = 'anime-1' WHERE `id` = '10' [ RunTime:0.008095s ]
  183. UPDATE `nav_category_tag` SET `slug` = 'anime-2' WHERE `id` = '11' [ RunTime:0.009330s ]
  184. UPDATE `nav_category_tag` SET `slug` = 'anime-3' WHERE `id` = '12' [ RunTime:0.009283s ]
  185. UPDATE `nav_category_tag` SET `slug` = 'anime-4' WHERE `id` = '13' [ RunTime:0.008885s ]
  186. UPDATE `nav_category_tag` SET `slug` = 'anime-5' WHERE `id` = '14' [ RunTime:0.006191s ]
  187. UPDATE `nav_category_tag` SET `slug` = 'music-1' WHERE `id` = '15' [ RunTime:0.007215s ]
  188. UPDATE `nav_category_tag` SET `slug` = 'music-2' WHERE `id` = '16' [ RunTime:0.014816s ]
  189. UPDATE `nav_category_tag` SET `slug` = 'music-3' WHERE `id` = '17' [ RunTime:0.001196s ]
  190. UPDATE `nav_category_tag` SET `slug` = 'music-4' WHERE `id` = '18' [ RunTime:0.002523s ]
  191. UPDATE `nav_category_tag` SET `slug` = 'music-5' WHERE `id` = '19' [ RunTime:0.005477s ]
  192. UPDATE `nav_category_tag` SET `slug` = 'music-6' WHERE `id` = '20' [ RunTime:0.006700s ]
  193. UPDATE `nav_category_tag` SET `slug` = 'music-7' WHERE `id` = '21' [ RunTime:0.006574s ]
  194. UPDATE `nav_category_tag` SET `slug` = 'music-8' WHERE `id` = '22' [ RunTime:0.008996s ]
  195. UPDATE `nav_category_tag` SET `slug` = 'read-1' WHERE `id` = '23' [ RunTime:0.003467s ]
  196. UPDATE `nav_category_tag` SET `slug` = 'read-2' WHERE `id` = '24' [ RunTime:0.011548s ]
  197. UPDATE `nav_category_tag` SET `slug` = 'read-3' WHERE `id` = '25' [ RunTime:0.007667s ]
  198. UPDATE `nav_category_tag` SET `slug` = 'read-4' WHERE `id` = '26' [ RunTime:0.009777s ]
  199. UPDATE `nav_category_tag` SET `slug` = 'read-5' WHERE `id` = '27' [ RunTime:0.010427s ]
  200. UPDATE `nav_category_tag` SET `slug` = 'game-1' WHERE `id` = '28' [ RunTime:0.006523s ]
  201. UPDATE `nav_category_tag` SET `slug` = 'game-2' WHERE `id` = '29' [ RunTime:0.008184s ]
  202. UPDATE `nav_category_tag` SET `slug` = 'game-3' WHERE `id` = '30' [ RunTime:0.009355s ]
  203. UPDATE `nav_category_tag` SET `slug` = 'fun-1' WHERE `id` = '31' [ RunTime:0.003503s ]
  204. UPDATE `nav_category_tag` SET `slug` = 'fun-2' WHERE `id` = '32' [ RunTime:0.006003s ]
  205. UPDATE `nav_category_tag` SET `slug` = 'tools-1' WHERE `id` = '33' [ RunTime:0.006341s ]
  206. UPDATE `nav_category_tag` SET `slug` = 'tools-2' WHERE `id` = '34' [ RunTime:0.001294s ]
  207. UPDATE `nav_category_tag` SET `slug` = 'tools-3' WHERE `id` = '35' [ RunTime:0.002067s ]
  208. UPDATE `nav_category_tag` SET `slug` = 'tools-4' WHERE `id` = '36' [ RunTime:0.001070s ]
  209. UPDATE `nav_category_tag` SET `slug` = 'tools-5' WHERE `id` = '37' [ RunTime:0.001672s ]
  210. UPDATE `nav_category_tag` SET `slug` = 'tools-6' WHERE `id` = '38' [ RunTime:0.001093s ]
  211. UPDATE `nav_category_tag` SET `slug` = 'tools-7' WHERE `id` = '39' [ RunTime:0.004785s ]
  212. UPDATE `nav_category_tag` SET `slug` = 'tools-8' WHERE `id` = '40' [ RunTime:0.001990s ]
  213. UPDATE `nav_category_tag` SET `slug` = 'tools-9' WHERE `id` = '41' [ RunTime:0.001446s ]
  214. UPDATE `nav_category_tag` SET `slug` = 'tools-10' WHERE `id` = '42' [ RunTime:0.001604s ]
  215. UPDATE `nav_category_tag` SET `slug` = 'tools-11' WHERE `id` = '43' [ RunTime:0.004105s ]
  216. UPDATE `nav_category_tag` SET `slug` = 'githubapp-1' WHERE `id` = '165' [ RunTime:0.009735s ]
  217. SELECT COUNT(*) AS n FROM `nav_link` [ RunTime:0.000315s ]
  218. SELECT `id` FROM `nav_category` WHERE `status` = 1 ORDER BY `sort` DESC, `id` ASC [ RunTime:0.000286s ]
  219. SELECT COUNT(*) AS n FROM `nav_site` WHERE `slug` = 'bilibili-demo' [ RunTime:0.000223s ]
  220. SHOW COLUMNS FROM `nav_site` [ RunTime:0.002893s ]
  221. SELECT COUNT(*) AS n FROM `nav_like_log` [ RunTime:0.000222s ]
  222. SELECT `id` FROM `nav_link` LIMIT 1 [ RunTime:0.000320s ]
  223. SELECT `id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000192s ]
  224. SELECT `id` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000302s ]
  225. SELECT `id` FROM `nav_ad` LIMIT 1 [ RunTime:0.000242s ]
  226. SELECT `id` FROM `nav_ad_plan` LIMIT 1 [ RunTime:0.000371s ]
  227. SELECT `id`,`order_no`,`pay_channel`,`pay_trade_no` FROM `nav_friend_link` LIMIT 1 [ RunTime:0.000211s ]
  228. SELECT `id`,`type`,`tag_id` FROM `nav_dock` LIMIT 1 [ RunTime:0.000359s ]
  229. SHOW COLUMNS FROM `nav_dock` [ RunTime:0.003478s ]
  230. SHOW COLUMNS FROM `nav_ad` [ RunTime:0.002189s ]
  231. SELECT `gift_days`,`pay_channel`,`pay_trade_no` FROM `nav_ad` LIMIT 1 [ RunTime:0.000299s ]
  232. SHOW COLUMNS FROM `nav_ad_plan` [ RunTime:0.001347s ]
  233. SELECT `position` FROM `nav_ad_plan` LIMIT 1 [ RunTime:0.000239s ]
  234. SHOW COLUMNS FROM `nav_ad` [ RunTime:0.001527s ]
  235. SELECT `icon` FROM `nav_ad` LIMIT 1 [ RunTime:0.000257s ]
  236. SHOW COLUMNS FROM `nav_qlink` [ RunTime:0.004409s ]
  237. SELECT `subtitle` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000216s ]
  238. SHOW COLUMNS FROM `nav_site` [ RunTime:0.003136s ]
  239. SELECT `hide_code`,`password` FROM `nav_site` LIMIT 1 [ RunTime:0.000250s ]
  240. SELECT `pv`,`clicks`,`views_m`,`views_d`,`views_p` FROM `nav_site_view_day` LIMIT 1 [ RunTime:0.000209s ]
  241. SELECT `quick_default` FROM `nav_site` LIMIT 1 [ RunTime:0.000154s ]
  242. SELECT `badge_color` FROM `nav_site` LIMIT 1 [ RunTime:0.000148s ]
  243. SELECT `user_id`,`url_key`,`title`,`icon`,`description`,`badge`,`platforms` FROM `nav_user_quick` LIMIT 1 [ RunTime:0.000206s ]
  244. SELECT `slug` FROM `nav_plugin` LIMIT 1 [ RunTime:0.000166s ]
  245. SHOW COLUMNS FROM `nav_plugin` [ RunTime:0.000846s ]
  246. SELECT `type`,`url`,`icon_url`,`cover`,`category`,`color`,`badge`,`need_login`,`points_cost` FROM `nav_plugin` LIMIT 1 [ RunTime:0.000189s ]
  247. SHOW FULL COLUMNS FROM `nav_plugin` [ RunTime:0.001269s ]
  248. SELECT * FROM `nav_plugin` [ RunTime:0.000457s ]
  249. UPDATE `nav_plugin` SET `category` = 'plugin' WHERE `type` = 'local' AND `category` = 'life' AND `update_time` = `create_time` [ RunTime:0.000420s ]
  250. SHOW FULL COLUMNS FROM `nav_setting` [ RunTime:0.004108s ]
  251. SELECT * FROM `nav_setting` [ RunTime:0.000722s ]
  252. 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.000283s ]
  253. SHOW COLUMNS FROM `nav_sponsor` [ RunTime:0.001201s ]
  254. SELECT `order_no`,`pay_time`,`ip` FROM `nav_sponsor` LIMIT 1 [ RunTime:0.000210s ]
  255. SHOW COLUMNS FROM `nav_sponsor_order` [ RunTime:0.001043s ]
  256. SELECT `order_no`,`sponsor_id`,`amount`,`base_amount`,`forever`,`include_site`,`ip` FROM `nav_sponsor_order` LIMIT 1 [ RunTime:0.000215s ]
  257. SHOW COLUMNS FROM `nav_user_favorite` [ RunTime:0.001024s ]
  258. SELECT `ip` FROM `nav_user_favorite` LIMIT 1 [ RunTime:0.000211s ]
  259. SHOW COLUMNS FROM `nav_user_like` [ RunTime:0.001047s ]
  260. SELECT `ip` FROM `nav_user_like` LIMIT 1 [ RunTime:0.000201s ]
  261. SHOW COLUMNS FROM `nav_points_log` [ RunTime:0.001015s ]
  262. SELECT `ip` FROM `nav_points_log` LIMIT 1 [ RunTime:0.000195s ]
  263. SHOW COLUMNS FROM `nav_invite_order` [ RunTime:0.001036s ]
  264. DELETE FROM `nav_sponsor` WHERE `order_no` = '' AND `pay_time` = 0 AND `name` LIKE '星友%' [ RunTime:0.000290s ]
  265. SELECT COUNT(*) AS `c` FROM `nav_sponsor` [ RunTime:0.000203s ]
  266. SHOW COLUMNS FROM `nav_article` [ RunTime:0.001136s ]
  267. SELECT COUNT(*) AS `c` FROM `nav_micro_post` [ RunTime:0.000196s ]
  268. SHOW COLUMNS FROM `nav_submit` [ RunTime:0.001175s ]
  269. SELECT `user_id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000295s ]
  270. SHOW COLUMNS FROM `nav_submit` [ RunTime:0.001282s ]
  271. SELECT `amount`,`order_no`,`pay_time`,`site_id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000190s ]
  272. SELECT `email`,`scene` FROM `nav_user_email_code` LIMIT 1 [ RunTime:0.000169s ]
  273. SELECT `user_id`,`target_id` FROM `nav_user_history` LIMIT 1 [ RunTime:0.000183s ]
  274. UPDATE `nav_user` SET `email_verified` = 1 WHERE `email` = '' [ RunTime:0.000192s ]
  275. SELECT `code`,`status` FROM `nav_invite_code` LIMIT 1 [ RunTime:0.000152s ]
  276. SELECT `order_no`,`status`,`invite_code` FROM `nav_invite_order` LIMIT 1 [ RunTime:0.000150s ]
  277. SELECT `type`,`months`,`price` FROM `nav_member_plan` LIMIT 1 [ RunTime:0.000172s ]
  278. SELECT `points`,`bonus`,`price` FROM `nav_points_pack` LIMIT 1 [ RunTime:0.000180s ]
  279. SELECT `order_no`,`type`,`status` FROM `nav_member_order` LIMIT 1 [ RunTime:0.000157s ]
  280. SELECT `user_id`,`delta`,`type` FROM `nav_points_log` LIMIT 1 [ RunTime:0.000151s ]
  281. SELECT `ticket_hash`,`slug`,`bucket` FROM `nav_pkg_key_log` LIMIT 1 [ RunTime:0.000156s ]
  282. SHOW COLUMNS FROM `nav_user` [ RunTime:0.000908s ]
  283. SELECT `webmaster_expire` FROM `nav_user` LIMIT 1 [ RunTime:0.000194s ]
  284. SHOW INDEX FROM `nav_site` [ RunTime:0.000355s ]
  285. SHOW INDEX FROM `nav_article` [ RunTime:0.000270s ]
  286. SHOW INDEX FROM `nav_submit` [ RunTime:0.000266s ]
  287. SHOW INDEX FROM `nav_user` [ RunTime:0.000286s ]
  288. SHOW INDEX FROM `nav_points_log` [ RunTime:0.000756s ]
  289. SHOW INDEX FROM `nav_invite_order` [ RunTime:0.000334s ]
  290. SHOW INDEX FROM `nav_member_order` [ RunTime:0.000301s ]
  291. SHOW INDEX FROM `nav_ad` [ RunTime:0.000284s ]
  292. SHOW INDEX FROM `nav_sponsor` [ RunTime:0.000293s ]
  293. SHOW INDEX FROM `nav_sponsor_order` [ RunTime:0.000274s ]
  294. SELECT `id`,`status`,`device_hash` FROM `nav_secret_post` LIMIT 1 [ RunTime:0.000228s ]
  295. SELECT `id`,`post_id` FROM `nav_secret_report` LIMIT 1 [ RunTime:0.000220s ]
  296. SELECT `id`,`page_key`,`status`,`root_id` FROM `nav_comment` LIMIT 1 [ RunTime:0.000256s ]
  297. SHOW COLUMNS FROM `nav_comment` [ RunTime:0.001224s ]
  298. SELECT `ip` FROM `nav_comment` LIMIT 1 [ RunTime:0.000232s ]
  299. SHOW COLUMNS FROM `nav_qlink` [ RunTime:0.001209s ]
  300. SELECT `folder_kind` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000221s ]
  301. SELECT `qlink_id`,`kind`,`ref_id`,`sort` FROM `nav_qlink_item` LIMIT 1 [ RunTime:0.000210s ]
  302. SELECT COUNT(*) AS `c` FROM `nav_right_menu` [ RunTime:0.000208s ]
  303. SELECT `id`,`scope_type`,`enabled` FROM `nav_right_menu` LIMIT 1 [ RunTime:0.000209s ]
  304. SELECT `rid`,`label`,`action` FROM `nav_right_menu_item` LIMIT 1 [ RunTime:0.000207s ]
  305. SELECT `id`,`rid`,`sort` FROM `nav_right_menu_item` WHERE `action` = 'fav' AND `label` = '收藏 / 屏蔽此站' [ RunTime:0.000256s ]
  306. ALTER TABLE `nav_right_menu_item` MODIFY COLUMN `icon` varchar(500) NOT NULL DEFAULT '' [ RunTime:0.005666s ]
  307. SELECT `icon` FROM `nav_right_menu_item` LIMIT 1 [ RunTime:0.000276s ]
  308. SELECT `pid` FROM `nav_right_menu_item` LIMIT 1 [ RunTime:0.000202s ]
  309. SELECT COUNT(*) AS `c` FROM `nav_home_module` [ RunTime:0.000208s ]
  310. SELECT `id`,`mkey`,`zone` FROM `nav_home_module` LIMIT 1 [ RunTime:0.000232s ]
  311. SELECT `id`,`mkey` FROM `nav_home_module` [ RunTime:0.000225s ]
  312. SELECT `id`,`mkey`,`sort` FROM `nav_home_module` [ RunTime:0.000220s ]
  313. SELECT `block_id`,`type`,`source_id`,`weight`,`is_ad` FROM `nav_home_pic` LIMIT 1 [ RunTime:0.000215s ]
  314. SELECT COUNT(*) AS `c` FROM `nav_home_block` [ RunTime:0.000190s ]
  315. SELECT `id` FROM `nav_home_block` ORDER BY `sort` ASC, `id` ASC LIMIT 1 [ RunTime:0.000219s ]
  316. UPDATE `nav_home_pic` SET `block_id` = '3' WHERE `block_id` = 0 [ RunTime:0.000251s ]
  317. SELECT `rank_type`,`rank_period` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000225s ]
  318. SELECT `is_countdown` FROM `nav_home_pic` LIMIT 1 [ RunTime:0.000204s ]
  319. SELECT `note_text`,`note_author` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000311s ]
  320. SELECT `is_video` FROM `nav_home_pic` LIMIT 1 [ RunTime:0.000199s ]
  321. SELECT `audience`,`ab_enable`,`ab_ratio` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000222s ]
  322. SELECT `pic_id`,`day`,`views`,`clicks` FROM `nav_home_pic_stat` LIMIT 1 [ RunTime:0.000212s ]
  323. SELECT `block_id`,`day`,`grp`,`exposes`,`clicks` FROM `nav_home_block_stat` LIMIT 1 [ RunTime:0.000206s ]
  324. SELECT `note_items` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000198s ]
  325. SELECT `cat`,`item_id` FROM `nav_shijuan_item` LIMIT 1 [ RunTime:0.000194s ]
  326. SELECT `item_id` FROM `nav_shijuan_download` LIMIT 1 [ RunTime:0.000178s ]
  327. SELECT `slug` FROM `nav_shijuan_category` LIMIT 1 [ RunTime:0.000172s ]
  328. SELECT `slug` FROM `nav_shijuan_subject` LIMIT 1 [ RunTime:0.000171s ]
  329. SELECT `file`,`license`,`rtype`,`status`,`update_time` FROM `nav_shijuan_item` LIMIT 1 [ RunTime:0.000235s ]
  330. SELECT `icon` FROM `nav_shijuan_subject` LIMIT 1 [ RunTime:0.000210s ]
  331. SELECT `icon` FROM `nav_shijuan_category` LIMIT 1 [ RunTime:0.000205s ]
  332. SELECT `feedback`,`feedback_status`,`feedback_time` FROM `nav_shijuan_item` LIMIT 1 [ RunTime:0.000204s ]
  333. SELECT `cover` FROM `nav_sponsor` LIMIT 1 [ RunTime:0.000252s ]
  334. SELECT `feedback`,`feedback_status`,`feedback_time` FROM `nav_article` LIMIT 1 [ RunTime:0.000196s ]
  335. SELECT `cover`,`bg_style`,`name_color`,`extra_color` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000203s ]
  336. SELECT `parent_id` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000200s ]
  337. SELECT `is_rec` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000216s ]
  338. SELECT `is_nav` FROM `nav_article_cat` LIMIT 1 [ RunTime:0.000157s ]
  339. SELECT `banner_img`,`banner_sub`,`tile_sort` FROM `nav_article` LIMIT 1 [ RunTime:0.000192s ]
  340. 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.000518s ]
  341. SELECT `remark` FROM `nav_article` LIMIT 1 [ RunTime:0.005053s ]
  342. SELECT `points_on`,`points_price` FROM `nav_article` LIMIT 1 [ RunTime:0.000213s ]
  343. SELECT `id` FROM `nav_article_points_unlock` LIMIT 1 [ RunTime:0.000431s ]
  344. SELECT `id` FROM `nav_points_signin` LIMIT 1 [ RunTime:0.000201s ]
  345. SELECT `id` FROM `nav_dl_ticket` LIMIT 1 [ RunTime:0.000218s ]
  346. SELECT `id`,`type`,`url` FROM `nav_article_menu` LIMIT 1 [ RunTime:0.000165s ]
  347. SELECT COUNT(*) AS `c` FROM `nav_article_menu` [ RunTime:0.000152s ]
  348. SHOW COLUMNS FROM `nav_article_menu` [ RunTime:0.000927s ]
  349. SELECT `hide_in_parent` FROM `nav_article_menu` LIMIT 1 [ RunTime:0.000171s ]
  350. SHOW COLUMNS FROM `nav_article_menu` [ RunTime:0.000921s ]
  351. SELECT `title_color` FROM `nav_article_menu` LIMIT 1 [ RunTime:0.002451s ]
  352. SELECT `article_cfg` FROM `nav_home_block` LIMIT 1 [ RunTime:0.000183s ]
  353. SHOW FULL COLUMNS FROM `nav_article_cat` [ RunTime:0.001974s ]
  354. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000394s ]
  355. SHOW FULL COLUMNS FROM `nav_article` [ RunTime:0.000929s ]
  356. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND ( `title` LIKE '%游戏工具%' OR `summary` LIKE '%游戏工具%' OR `tags` LIKE '%游戏工具%' ) [ RunTime:0.025172s ]
  357. SELECT * FROM `nav_article` WHERE `status` = 1 AND ( `title` LIKE '%游戏工具%' OR `summary` LIKE '%游戏工具%' OR `tags` LIKE '%游戏工具%' ) ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 2568,12 [ RunTime:0.028201s ]
  358. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000530s ]
  359. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 [ RunTime:0.003377s ]
  360. SELECT * FROM `nav_article` WHERE `status` = 1 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.008701s ]
  361. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000489s ]
  362. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (4,8,9,10,11,12,13,14,15,16,17,18,19,20,21,65,72,74) [ RunTime:0.015741s ]
  363. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (4,8,9,10,11,12,13,14,15,16,17,18,19,20,21,65,72,74) ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.014043s ]
  364. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (5,22,23,39) [ RunTime:0.005583s ]
  365. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (5,22,23,39) ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.003088s ]
  366. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (6,28,29,30,31,32,33,34) [ RunTime:0.000541s ]
  367. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (6,28,29,30,31,32,33,34) ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.001273s ]
  368. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 38 [ RunTime:0.000257s ]
  369. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 38 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000361s ]
  370. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (40,63,64) [ RunTime:0.000670s ]
  371. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (40,63,64) ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000995s ]
  372. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (43,44,45,54) [ RunTime:0.001778s ]
  373. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (43,44,45,54) ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.002258s ]
  374. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 8 [ RunTime:0.000350s ]
  375. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 8 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000718s ]
  376. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 9 [ RunTime:0.001216s ]
  377. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 9 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.004663s ]
  378. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 10 [ RunTime:0.001211s ]
  379. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 10 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.001655s ]
  380. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 11 [ RunTime:0.000706s ]
  381. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 11 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.001038s ]
  382. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 12 [ RunTime:0.001793s ]
  383. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 12 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.002232s ]
  384. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 13 [ RunTime:0.000266s ]
  385. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 13 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000447s ]
  386. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 14 [ RunTime:0.000384s ]
  387. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 14 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.003758s ]
  388. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 15 [ RunTime:0.000982s ]
  389. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 15 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000839s ]
  390. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 28 [ RunTime:0.000334s ]
  391. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 28 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000933s ]
  392. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 16 [ RunTime:0.000705s ]
  393. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 16 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.003777s ]
  394. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 22 [ RunTime:0.002226s ]
  395. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 22 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.006203s ]
  396. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 29 [ RunTime:0.000354s ]
  397. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 29 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000822s ]
  398. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 17 [ RunTime:0.000656s ]
  399. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 17 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.001018s ]
  400. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 23 [ RunTime:0.000315s ]
  401. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 23 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000574s ]
  402. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 30 [ RunTime:0.003230s ]
  403. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 30 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000476s ]
  404. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 18 [ RunTime:0.000291s ]
  405. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 18 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000542s ]
  406. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 31 [ RunTime:0.000311s ]
  407. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 31 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000470s ]
  408. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 19 [ RunTime:0.002078s ]
  409. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 19 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.005142s ]
  410. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 32 [ RunTime:0.000334s ]
  411. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 32 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000617s ]
  412. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 20 [ RunTime:0.000856s ]
  413. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 20 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.001218s ]
  414. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 33 [ RunTime:0.000284s ]
  415. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 33 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000512s ]
  416. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 21 [ RunTime:0.000344s ]
  417. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 21 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000686s ]
  418. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 34 [ RunTime:0.000362s ]
  419. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 34 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000667s ]
  420. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 39 [ RunTime:0.000292s ]
  421. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 39 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000541s ]
  422. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 44 [ RunTime:0.001014s ]
  423. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 44 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.004383s ]
  424. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 45 [ RunTime:0.000563s ]
  425. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 45 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000864s ]
  426. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 48 [ RunTime:0.000265s ]
  427. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 48 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000364s ]
  428. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 49 [ RunTime:0.000273s ]
  429. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 49 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000380s ]
  430. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 50 [ RunTime:0.000248s ]
  431. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 50 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000367s ]
  432. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 51 [ RunTime:0.000252s ]
  433. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 51 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000728s ]
  434. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 52 [ RunTime:0.002763s ]
  435. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 52 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000351s ]
  436. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 53 [ RunTime:0.000262s ]
  437. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 53 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000392s ]
  438. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 54 [ RunTime:0.000489s ]
  439. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 54 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000760s ]
  440. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 58 [ RunTime:0.000274s ]
  441. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 58 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000391s ]
  442. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 59 [ RunTime:0.000252s ]
  443. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 59 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000381s ]
  444. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 61 [ RunTime:0.000273s ]
  445. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 61 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000367s ]
  446. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 62 [ RunTime:0.000272s ]
  447. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 62 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000403s ]
  448. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 63 [ RunTime:0.000604s ]
  449. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 63 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.001091s ]
  450. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 64 [ RunTime:0.000451s ]
  451. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 64 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000887s ]
  452. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 65 [ RunTime:0.000439s ]
  453. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 65 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000711s ]
  454. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 72 [ RunTime:0.000441s ]
  455. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 72 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000819s ]
  456. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 AND `category_id` = 74 [ RunTime:0.000263s ]
  457. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 74 ORDER BY `is_top` DESC,`create_time` DESC,`id` DESC LIMIT 12 [ RunTime:0.000355s ]
  458. SELECT * FROM `nav_article` WHERE `status` = 1 AND `is_recommend` = 1 ORDER BY `is_top` DESC,`id` DESC LIMIT 20 [ RunTime:0.004603s ]
  459. SELECT * FROM `nav_article` WHERE `status` = 1 AND `id` <> 5507 ORDER BY `views` DESC,`id` DESC LIMIT 16 [ RunTime:0.005884s ]
  460. SELECT * FROM `nav_article` WHERE `status` = 1 AND `is_banner` = 1 ORDER BY `banner_sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.007550s ]
  461. SELECT * FROM `nav_article` WHERE `status` = 1 AND `tile_sort` > 0 AND `id` NOT IN (5507,5506,5505,5504,5503) ORDER BY `tile_sort` DESC,`id` DESC LIMIT 6 [ RunTime:0.007884s ]
  462. SELECT * FROM `nav_article` WHERE `status` = 1 AND `id` NOT IN (5507,5506,5505,5504,5503,5501,5500) ORDER BY `views` DESC,`id` DESC LIMIT 24 [ RunTime:0.009315s ]
  463. SELECT * FROM `nav_article_cat` WHERE `status` = 1 AND `is_rec` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000352s ]
  464. SELECT category_id, COUNT(*) AS n FROM `nav_article` WHERE `status` = 1 GROUP BY `category_id` [ RunTime:0.017891s ]
  465. SHOW FULL COLUMNS FROM `nav_article_menu` [ RunTime:0.001455s ]
  466. SELECT COUNT(*) AS think_count FROM `nav_article_menu` [ RunTime:0.000199s ]
  467. SELECT * FROM `nav_article_menu` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000352s ]
  468. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000409s ]
  469. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (4,8,9,10,11,12,13,14,15,16,17,18,19,20,21,65,72,74) AND `is_recommend` = 1 ORDER BY `is_top` DESC,`id` DESC LIMIT 20 [ RunTime:0.017133s ]
  470. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (4,8,9,10,11,12,13,14,15,16,17,18,19,20,21,65,72,74) AND `id` <> 0 ORDER BY `views` DESC,`id` DESC LIMIT 17 [ RunTime:0.010255s ]
  471. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (5,22,23,39) AND `is_recommend` = 1 ORDER BY `is_top` DESC,`id` DESC LIMIT 20 [ RunTime:0.006506s ]
  472. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` IN (5,22,23,39) AND `id` <> 0 ORDER BY `views` DESC,`id` DESC LIMIT 17 [ RunTime:0.009514s ]
  473. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 8 AND `is_recommend` = 1 ORDER BY `is_top` DESC,`id` DESC LIMIT 20 [ RunTime:0.000487s ]
  474. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 8 AND `id` <> 0 ORDER BY `views` DESC,`id` DESC LIMIT 17 [ RunTime:0.000908s ]
  475. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 11 AND `is_recommend` = 1 ORDER BY `is_top` DESC,`id` DESC LIMIT 20 [ RunTime:0.000822s ]
  476. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 11 AND `id` <> 0 ORDER BY `views` DESC,`id` DESC LIMIT 17 [ RunTime:0.001313s ]
  477. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 12 AND `is_recommend` = 1 ORDER BY `is_top` DESC,`id` DESC LIMIT 20 [ RunTime:0.004129s ]
  478. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 12 AND `id` <> 0 ORDER BY `views` DESC,`id` DESC LIMIT 17 [ RunTime:0.002870s ]
  479. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 15 AND `is_recommend` = 1 ORDER BY `is_top` DESC,`id` DESC LIMIT 20 [ RunTime:0.000595s ]
  480. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 15 AND `id` <> 0 ORDER BY `views` DESC,`id` DESC LIMIT 17 [ RunTime:0.000892s ]
  481. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 19 AND `is_recommend` = 1 ORDER BY `is_top` DESC,`id` DESC LIMIT 20 [ RunTime:0.004877s ]
  482. SELECT * FROM `nav_article` WHERE `status` = 1 AND `category_id` = 19 AND `id` <> 0 ORDER BY `views` DESC,`id` DESC LIMIT 17 [ RunTime:0.004727s ]
  483. SHOW FULL COLUMNS FROM `nav_site` [ RunTime:0.002003s ]
  484. SELECT `hide_code` FROM `nav_site` LIMIT 1 [ RunTime:0.000245s ]
  485. SELECT SUM(`views`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.000801s ]
  486. SELECT SUM(`views`) AS think_sum FROM `nav_article` WHERE `status` = 1 [ RunTime:0.004947s ]
  487. SELECT SUM(`likes`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.000761s ]
  488. SHOW FULL COLUMNS FROM `nav_category_tag` [ RunTime:0.003937s ]
  489. SELECT COUNT(*) AS think_count FROM `nav_category_tag` WHERE `status` = 1 [ RunTime:0.000271s ]
  490. SHOW FULL COLUMNS FROM `nav_user` [ RunTime:0.000913s ]
  491. SELECT COUNT(*) AS think_count FROM `nav_user` [ RunTime:0.000391s ]
  492. SELECT SUM(`views_today`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_date` = 1794931200 [ RunTime:0.000487s ]
  493. SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000381s ]
  494. SELECT tag_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `tag_id` [ RunTime:0.001378s ]
  495. SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_date` = 1794931200 AND `views_today` > 0 ORDER BY `views_today` DESC,`id` DESC LIMIT 8 [ RunTime:0.001160s ]
  496. SHOW FULL COLUMNS FROM `nav_like_log` [ RunTime:0.003854s ]
  497. SELECT `target_id` FROM `nav_like_log` WHERE `type` = 'site' AND `ip` = '216.73.216.169' [ RunTime:0.000325s ]
  498. 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.001670s ]
  499. 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.001958s ]
  500. SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' ORDER BY `views` DESC,`id` DESC LIMIT 8 [ RunTime:0.000486s ]
  501. SHOW FULL COLUMNS FROM `nav_ad` [ RunTime:0.003825s ]
  502. SELECT * FROM `nav_ad` WHERE `status` = 2 AND `position` = 'home_banner' AND `start_time` <= 1794935372 AND `end_time` >= 1794935372 ORDER BY `sort` DESC,`id` DESC LIMIT 20 [ RunTime:0.000610s ]
  503. SELECT `cover`,`bg_style`,`name_color`,`extra_color` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000277s ]
  504. SHOW FULL COLUMNS FROM `nav_home_block` [ RunTime:0.004069s ]
  505. SELECT * FROM `nav_home_block` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000365s ]
  506. SHOW FULL COLUMNS FROM `nav_home_module` [ RunTime:0.000806s ]
  507. SELECT * FROM `nav_home_module` WHERE `zone` = 'rail' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000301s ]
  508. SELECT * FROM `nav_home_block` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000284s ]
  509. SELECT * FROM `nav_home_module` WHERE `zone` = 'rail' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000255s ]
  510. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000335s ]
  511. SELECT * FROM `nav_site` WHERE `id` IN (208,97,69,152,41,124,207) [ RunTime:0.000331s ]
  512. SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.000563s ]
  513. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 [ RunTime:0.006875s ]
  514. SHOW FULL COLUMNS FROM `nav_notice` [ RunTime:0.001348s ]
  515. SELECT COUNT(*) AS think_count FROM `nav_notice` WHERE `status` = 1 [ RunTime:0.000279s ]
  516. SHOW FULL COLUMNS FROM `nav_sponsor` [ RunTime:0.001205s ]
  517. SELECT COUNT(*) AS think_count FROM `nav_sponsor` WHERE `status` = 1 [ RunTime:0.003181s ]
  518. SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `create_time` >= 1794931200 [ RunTime:0.000597s ]
  519. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.003711s ]
  520. SELECT * FROM `nav_article` WHERE `status` = 1 ORDER BY `views` DESC,`id` DESC LIMIT 6 [ RunTime:0.008810s ]
  521. SELECT * FROM `nav_article` WHERE `status` = 1 ORDER BY `create_time` DESC,`id` DESC LIMIT 8 [ RunTime:0.000828s ]
  522. SELECT category_id, COUNT(*) AS n FROM `nav_article` WHERE `status` = 1 GROUP BY `category_id` [ RunTime:0.019657s ]
  523. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000516s ]
  524. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 [ RunTime:0.005855s ]
  525. SELECT MAX(`update_time`) AS think_max FROM `nav_article` WHERE `status` = 1 [ RunTime:0.004936s ]
  526. SHOW FULL COLUMNS FROM `nav_comment` [ RunTime:0.001212s ]
  527. SELECT COUNT(*) AS think_count FROM `nav_comment` WHERE `status` = 1 [ RunTime:0.000260s ]
  528. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000435s ]
  529. SELECT `id`,`page_key`,`nickname`,`avatar`,`content`,`create_time`,`is_admin`,`user_id`,`level` FROM `nav_comment` WHERE `status` = 1 AND `page_key` LIKE 'article:%' ORDER BY `id` DESC LIMIT 30 [ RunTime:0.000350s ]
  530. SELECT `tags` FROM `nav_article` WHERE `status` = 1 ORDER BY `id` DESC LIMIT 400 [ RunTime:0.000916s ]
  531. SHOW FULL COLUMNS FROM `nav_friend_link` [ RunTime:0.003730s ]
  532. SELECT * FROM `nav_friend_link` WHERE `status` = 2 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000473s ]
  533. SHOW FULL COLUMNS FROM `nav_micro_post` [ RunTime:0.001205s ]
  534. SELECT * FROM `nav_micro_post` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 3 [ RunTime:0.000608s ]
1.196695s