页面主题选择后自动记忆
自定义主题主色与底色自由搭配
星际导航 为开发者与创作者整理的高质量资源导航
首页 文章 资源合集
资源合集

本期精选：设计与开发资源合集

编 编辑 2026-10-22 发布 · 约 2 分钟读完 211 阅读 29 点赞
本期精选：设计与开发资源合集

整理了最近常用的设计与开发站点，附上使用场景说明。

本期精选

设计类

  • Figma：协作设计与原型
  • Dribbble：找配色与版式灵感
  • 站酷：国内设计师社区

开发类

  • MDN：Web 文档的标准答案
  • 掘金：工程实践与踩坑记录
  • GitHub：代码与开源项目

AI 类

  • ChatGPT：通用问答与写作
  • Claude：长文本与代码阅读

精选封面

以上资源均可在首页分类中直接进入，欢迎在留言中补充你常用的站点。

标签 # 合集# 资源
返回列表

相关推荐

继续阅读
从 0 到 1 搭建一个长期可维护的导航站 文章 从 0 到 1 搭建一个长期可维护的导航站 书签越来越乱？用一套可运营的结构，把高频入口固定下来。 星际导航使用指南：后台与加密设置 使用指南 星际导航使用指南：后台与加密设置 从添加站点到开启接口加密，一篇文章讲清后台的每个开关。
纯真网络 必备 枫叶起始页（必备）
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-10-28 00:53:23 HTTP/1.1 GET : https://dhw.wchulian.com.cn/article/3
  2. 运行时间 : 0.196126s [ 吞吐率：5.10req/s ] 内存消耗：6,176.03kb 文件加载：141
  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 ( 230.06 KB )
  27. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/helper.php ( 18.77 KB )
  28. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Config.php ( 5.93 KB )
  29. /www/wwwroot/daohw.cn/config/app.php ( 0.95 KB )
  30. /www/wwwroot/daohw.cn/config/cache.php ( 0.78 KB )
  31. /www/wwwroot/daohw.cn/config/console.php ( 0.23 KB )
  32. /www/wwwroot/daohw.cn/config/cookie.php ( 0.56 KB )
  33. /www/wwwroot/daohw.cn/config/database.php ( 2.13 KB )
  34. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  35. /www/wwwroot/daohw.cn/config/filesystem.php ( 0.61 KB )
  36. /www/wwwroot/daohw.cn/config/lang.php ( 0.91 KB )
  37. /www/wwwroot/daohw.cn/config/log.php ( 1.35 KB )
  38. /www/wwwroot/daohw.cn/config/middleware.php ( 0.19 KB )
  39. /www/wwwroot/daohw.cn/config/route.php ( 1.89 KB )
  40. /www/wwwroot/daohw.cn/config/session.php ( 0.57 KB )
  41. /www/wwwroot/daohw.cn/config/trace.php ( 0.34 KB )
  42. /www/wwwroot/daohw.cn/config/view.php ( 0.92 KB )
  43. /www/wwwroot/daohw.cn/app/event.php ( 0.25 KB )
  44. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Event.php ( 7.77 KB )
  45. /www/wwwroot/daohw.cn/app/service.php ( 0.13 KB )
  46. /www/wwwroot/daohw.cn/app/AppService.php ( 0.26 KB )
  47. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  48. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  49. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  50. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  51. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  52. /www/wwwroot/daohw.cn/vendor/services.php ( 0.14 KB )
  53. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  54. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  55. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  56. /www/wwwroot/daohw.cn/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  57. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  58. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  59. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/Paginator.php ( 11.86 KB )
  60. /www/wwwroot/daohw.cn/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  61. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/Model.php ( 23.55 KB )
  62. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 21.05 KB )
  63. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/AutoWriteData.php ( 4.20 KB )
  64. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 6.75 KB )
  65. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/DbConnect.php ( 5.16 KB )
  66. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.33 KB )
  67. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 28.30 KB )
  68. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  69. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  70. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/model/contract/Modelable.php ( 0.09 KB )
  71. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  72. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/DbManager.php ( 8.52 KB )
  73. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  74. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  75. /www/wwwroot/daohw.cn/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  76. /www/wwwroot/daohw.cn/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  77. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  78. /www/wwwroot/daohw.cn/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  79. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/helper/Arr.php ( 17.45 KB )
  80. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.84 KB )
  81. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/cache/Driver.php ( 9.02 KB )
  82. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  83. /www/wwwroot/daohw.cn/app/Request.php ( 0.09 KB )
  84. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Request.php ( 54.64 KB )
  85. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/traits/UrlHandler.php ( 6.05 KB )
  86. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/traits/DomainHandler.php ( 5.49 KB )
  87. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/traits/HttpMethodHandler.php ( 4.74 KB )
  88. /www/wwwroot/daohw.cn/app/middleware.php ( 0.26 KB )
  89. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  90. /www/wwwroot/daohw.cn/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  91. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  92. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/RuleName.php ( 5.74 KB )
  93. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  94. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.41 KB )
  95. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/Rule.php ( 27.49 KB )
  96. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  97. /www/wwwroot/daohw.cn/route/app.php ( 7.17 KB )
  98. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  99. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  100. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/route/Dispatch.php ( 11.32 KB )
  101. /www/wwwroot/daohw.cn/app/controller/Front.php ( 60.60 KB )
  102. /www/wwwroot/daohw.cn/app/BaseController.php ( 2.05 KB )
  103. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  104. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 5.73 KB )
  105. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/PDOConnection.php ( 53.74 KB )
  106. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Connection.php ( 8.39 KB )
  107. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.57 KB )
  108. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.58 KB )
  109. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Builder.php ( 24.07 KB )
  110. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.50 KB )
  111. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/log/driver/File.php ( 6.10 KB )
  112. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  113. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  114. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  115. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/exception/PDOException.php ( 1.50 KB )
  116. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/exception/DbException.php ( 1.38 KB )
  117. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Query.php ( 15.97 KB )
  118. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/BaseQuery.php ( 45.13 KB )
  119. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  120. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  121. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 20.07 KB )
  122. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  123. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.01 KB )
  124. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 19.37 KB )
  125. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.11 KB )
  126. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.63 KB )
  127. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  128. /www/wwwroot/daohw.cn/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  129. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Express.php ( 1.53 KB )
  130. /www/wwwroot/daohw.cn/vendor/topthink/think-orm/src/db/Raw.php ( 1.30 KB )
  131. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Response.php ( 9.07 KB )
  132. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/response/View.php ( 3.29 KB )
  133. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  134. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
  135. /www/wwwroot/daohw.cn/vendor/topthink/think-view/src/Think.php ( 8.38 KB )
  136. /www/wwwroot/daohw.cn/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.60 KB )
  137. /www/wwwroot/daohw.cn/vendor/topthink/think-template/src/Template.php ( 46.61 KB )
  138. /www/wwwroot/daohw.cn/vendor/topthink/think-template/src/template/driver/File.php ( 2.41 KB )
  139. /www/wwwroot/daohw.cn/vendor/topthink/think-template/src/template/contract/DriverInterface.php ( 0.86 KB )
  140. /www/wwwroot/daohw.cn/runtime/temp/0e6475287e4a9bdd3439f95a2ddabaa9.php ( 50.77 KB )
  141. /www/wwwroot/daohw.cn/vendor/topthink/think-trace/src/Html.php ( 4.42 KB )
  1. CONNECT:[ UseTime:0.000404s ] 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.000267s ]
  3. CREATE TABLE IF NOT EXISTS `nav_setting` ( `k` varchar(64) NOT NULL, `v` text, `update_time` int NOT NULL DEFAULT 0, PRIMARY KEY (`k`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.000199s ]
  4. CREATE TABLE IF NOT EXISTS `nav_admin` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `username` varchar(50) NOT NULL, `password` varchar(255) NOT NULL, `nickname` varchar(50) DEFAULT '', `status` tinyint NOT NULL DEFAULT 1, `last_login_time` int NOT NULL DEFAULT 0, `last_login_ip` varchar(64) DEFAULT '', `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.000204s ]
  5. CREATE TABLE IF NOT EXISTS `nav_category` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `name` varchar(50) NOT NULL, `slug` varchar(64) NOT NULL, `icon` varchar(255) DEFAULT '', `color` varchar(64) DEFAULT '', `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `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.000162s ]
  6. CREATE TABLE IF NOT EXISTS `nav_category_tag` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `category_id` int NOT NULL DEFAULT 0, `name` varchar(50) NOT NULL, `slug` varchar(64) NOT NULL, `icon` varchar(255) DEFAULT '', `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `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.000122s ]
  7. CREATE TABLE IF NOT EXISTS `nav_site` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `category_id` int NOT NULL DEFAULT 0, `tag_id` int NOT NULL DEFAULT 0, `name` varchar(100) NOT NULL, `slug` varchar(100) NOT NULL, `url` varchar(500) DEFAULT '', `icon` varchar(500) DEFAULT '', `cover` varchar(500) DEFAULT '', `description` varchar(500) DEFAULT '', `content` longtext, `tags` varchar(255) DEFAULT '', `badge` varchar(200) DEFAULT '', `sort` int NOT NULL DEFAULT 0, `views` int NOT NULL DEFAULT 0, `views_today` int NOT NULL DEFAULT 0, `views_date` int NOT NULL DEFAULT 0, `likes` int NOT NULL DEFAULT 0, `is_featured` tinyint NOT NULL DEFAULT 0, `hide_code` varchar(100) NOT NULL DEFAULT '', `password` varchar(100) NOT NULL DEFAULT '', `sync_note` varchar(200) NOT NULL DEFAULT '', `synced_at` datetime DEFAULT NULL, `status` tinyint NOT NULL DEFAULT 1, `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.000233s ]
  8. CREATE TABLE IF NOT EXISTS `nav_like_log` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `type` varchar(50) NOT NULL DEFAULT 'site', `target_id` 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.000136s ]
  9. CREATE TABLE IF NOT EXISTS `nav_article_cat` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `name` varchar(50) NOT NULL, `slug` varchar(64) NOT NULL, `icon` varchar(255) DEFAULT '', `color` varchar(64) DEFAULT '', `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `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.000209s ]
  10. CREATE TABLE IF NOT EXISTS `nav_article` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `category_id` int NOT NULL DEFAULT 0, `title` varchar(200) NOT NULL, `cover` varchar(500) DEFAULT '', `summary` varchar(500) DEFAULT '', `content` longtext, `tags` varchar(255) DEFAULT '', `author` varchar(50) DEFAULT '', `views` int NOT NULL DEFAULT 0, `likes` int NOT NULL DEFAULT 0, `is_top` tinyint NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `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.000128s ]
  11. CREATE TABLE IF NOT EXISTS `nav_notice` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `title` varchar(200) NOT NULL, `content` text, `type` varchar(50) DEFAULT 'info', `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `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.000116s ]
  12. CREATE TABLE IF NOT EXISTS `nav_sponsor` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `site_id` int NOT NULL DEFAULT 0, `category_id` int NOT NULL DEFAULT 0, `tag_id` int NOT NULL DEFAULT 0, `name` varchar(100) NOT NULL, `url` varchar(500) DEFAULT '', `icon` varchar(500) DEFAULT '', `email` varchar(100) DEFAULT '', `message` varchar(200) DEFAULT '', `order_no` varchar(64) DEFAULT '', `pay_channel` varchar(20) DEFAULT '', `pay_trade_no` varchar(64) DEFAULT '', `pay_time` int NOT NULL DEFAULT 0, `amount` int NOT NULL DEFAULT 0, `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `create_time` int NOT NULL DEFAULT 0, `update_time` int NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.000172s ]
  13. CREATE TABLE IF NOT EXISTS `nav_sponsor_order` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `order_no` varchar(64) NOT NULL, `sponsor_id` int NOT NULL DEFAULT 0, `site_id` int NOT NULL DEFAULT 0, `amount` int NOT NULL DEFAULT 0, `base_amount` int NOT NULL DEFAULT 0, `forever` tinyint NOT NULL DEFAULT 0, `include_site` tinyint NOT NULL DEFAULT 0, `pay_channel` varchar(20) DEFAULT '', `pay_trade_no` varchar(64) DEFAULT '', `pay_time` int NOT NULL DEFAULT 0, `remark` varchar(200) DEFAULT '', `status` 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.000186s ]
  14. CREATE TABLE IF NOT EXISTS `nav_link` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `pid` int NOT NULL DEFAULT 0, `position` varchar(50) NOT NULL DEFAULT 'top', `name` varchar(50) NOT NULL, `icon` varchar(255) DEFAULT '', `url` varchar(500) DEFAULT '', `description` varchar(200) DEFAULT '', `badge` varchar(50) DEFAULT '', `target` tinyint NOT NULL DEFAULT 0, `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `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.000136s ]
  15. CREATE TABLE IF NOT EXISTS `nav_submit` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `name` varchar(100) NOT NULL, `url` varchar(500) NOT NULL, `category_id` int NOT NULL DEFAULT 0, `tag_id` int NOT NULL DEFAULT 0, `icon` varchar(500) DEFAULT '', `cover` varchar(500) DEFAULT '', `description` varchar(500) DEFAULT '', `content` longtext, `tags` varchar(255) DEFAULT '', `badge` varchar(200) DEFAULT '', `contact` varchar(100) NOT NULL DEFAULT '', `remark` varchar(200) DEFAULT '', `status` tinyint NOT NULL DEFAULT 0, `audit_time` int NOT NULL DEFAULT 0, `ip` varchar(64) NOT NULL DEFAULT '', `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.000166s ]
  16. CREATE TABLE IF NOT EXISTS `nav_qlink` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `name` varchar(50) DEFAULT '', `subtitle` varchar(200) DEFAULT '', `type` varchar(20) NOT NULL DEFAULT 'cat', `cat_id` int NOT NULL DEFAULT 0, `site_id` int NOT NULL DEFAULT 0, `url` varchar(500) DEFAULT '', `icon` varchar(500) DEFAULT '', `extra` varchar(64) DEFAULT '', `target` tinyint NOT NULL DEFAULT 0, `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `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.000127s ]
  17. CREATE TABLE IF NOT EXISTS `nav_ad` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `position` varchar(20) NOT NULL DEFAULT 'home_banner', `title` varchar(100) NOT NULL, `subtitle` varchar(200) DEFAULT '', `icon` varchar(500) DEFAULT '', `image` varchar(500) DEFAULT '', `url` varchar(500) DEFAULT '', `btn_text` varchar(50) DEFAULT '', `theme` varchar(20) DEFAULT '', `badge` varchar(50) DEFAULT '', `plan_id` int NOT NULL DEFAULT 0, `months` int NOT NULL DEFAULT 1, `gift_days` int NOT NULL DEFAULT 0, `unit_price` decimal(10,2) NOT NULL DEFAULT 0, `amount` decimal(10,2) NOT NULL DEFAULT 0, `order_no` varchar(64) DEFAULT '', `pay_method` varchar(50) DEFAULT '', `pay_channel` varchar(20) DEFAULT '', `pay_trade_no` varchar(64) DEFAULT '', `pay_time` int NOT NULL DEFAULT 0, `start_time` int NOT NULL DEFAULT 0, `end_time` int NOT NULL DEFAULT 0, `audit_time` int NOT NULL DEFAULT 0, `contact` varchar(100) NOT NULL DEFAULT '', `company` varchar(100) DEFAULT '', `remark` varchar(255) DEFAULT '', `admin_note` varchar(255) DEFAULT '', `status` tinyint NOT NULL DEFAULT 0, `sort` int NOT NULL DEFAULT 0, `views` int NOT NULL DEFAULT 0, `clicks` int NOT NULL DEFAULT 0, `ip` varchar(64) NOT NULL DEFAULT '', `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.000153s ]
  18. CREATE TABLE IF NOT EXISTS `nav_ad_plan` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `name` varchar(50) NOT NULL, `months` int NOT NULL DEFAULT 1, `price` decimal(10,2) NOT NULL DEFAULT 0, `gift_days` int NOT NULL DEFAULT 0, `position` varchar(20) NOT NULL DEFAULT 'home_banner', `description` varchar(255) DEFAULT '', `badge` varchar(50) DEFAULT '', `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `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.000132s ]
  19. CREATE TABLE IF NOT EXISTS `nav_friend_link` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `name` varchar(100) NOT NULL, `url` varchar(500) NOT NULL, `icon` varchar(500) DEFAULT '', `description` varchar(200) DEFAULT '', `contact` varchar(100) NOT NULL DEFAULT '', `remark` varchar(200) DEFAULT '', `admin_note` varchar(200) DEFAULT '', `amount` decimal(10,2) NOT NULL DEFAULT 0, `order_no` varchar(64) DEFAULT '', `pay_method` varchar(50) DEFAULT '', `pay_channel` varchar(20) DEFAULT '', `pay_trade_no` varchar(64) DEFAULT '', `pay_time` int NOT NULL DEFAULT 0, `audit_time` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 0, `sort` int NOT NULL DEFAULT 0, `ip` varchar(64) NOT NULL DEFAULT '', `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.000128s ]
  20. CREATE TABLE IF NOT EXISTS `nav_dock` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `name` varchar(50) DEFAULT '', `type` varchar(20) NOT NULL DEFAULT 'url', `site_id` int NOT NULL DEFAULT 0, `cat_id` int NOT NULL DEFAULT 0, `tag_id` int NOT NULL DEFAULT 0, `url` varchar(500) DEFAULT '', `icon` varchar(500) DEFAULT '', `extra` varchar(64) DEFAULT '', `target` tinyint NOT NULL DEFAULT 0, `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `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.000126s ]
  21. CREATE TABLE IF NOT EXISTS `nav_plugin` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `slug` varchar(64) NOT NULL DEFAULT '', `type` varchar(20) NOT NULL DEFAULT 'local', `name` varchar(100) NOT NULL DEFAULT '', `icon` varchar(100) NOT NULL DEFAULT '', `icon_url` varchar(500) NOT NULL DEFAULT '', `url` varchar(500) NOT NULL DEFAULT '', `category` varchar(20) NOT NULL DEFAULT 'life', `color` varchar(20) NOT NULL DEFAULT '', `badge` varchar(20) NOT NULL DEFAULT '', `description` varchar(200) NOT NULL DEFAULT '', `version` varchar(20) NOT NULL DEFAULT '', `backend` tinyint NOT NULL DEFAULT 0, `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `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.000244s ]
  22. CREATE TABLE IF NOT EXISTS `nav_dypage` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `title` varchar(200) NOT NULL DEFAULT '', `alias` varchar(64) NOT NULL DEFAULT '', `template` varchar(50) NOT NULL DEFAULT 'wdhkbpage', `content` longtext, `referer_on` tinyint NOT NULL DEFAULT 1, `referer_flag` varchar(255) NOT NULL DEFAULT '', `pwd_fail_on` tinyint NOT NULL DEFAULT 0, `pwd_fail_url` varchar(500) NOT NULL DEFAULT '', `password` varchar(100) NOT NULL DEFAULT '', `password_tip` varchar(200) NOT NULL DEFAULT '', `owner` varchar(100) NOT NULL DEFAULT '', `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `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.000126s ]
  23. CREATE TABLE IF NOT EXISTS `nav_devlog` ( `id` int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `day` int NOT NULL DEFAULT 0, `phase` varchar(20) NOT NULL DEFAULT 'start', `title` varchar(200) NOT NULL DEFAULT '', `summary` varchar(500) NOT NULL DEFAULT '', `items` longtext, `tags` varchar(200) NOT NULL DEFAULT '', `log_date` varchar(20) NOT NULL DEFAULT '', `sort` int NOT NULL DEFAULT 0, `status` tinyint NOT NULL DEFAULT 1, `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.000118s ]
  24. SELECT COUNT(*) AS `c` FROM `nav_devlog` [ RunTime:0.000194s ]
  25. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_on','1','1793120003') [ RunTime:0.000196s ]
  26. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_free_audit','0','1793120003') [ RunTime:0.000121s ]
  27. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_price','0','1793120003') [ RunTime:0.000116s ]
  28. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_on','1','1793120003') [ RunTime:0.000202s ]
  29. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_price_month','0','1793120003') [ RunTime:0.000122s ]
  30. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_free_audit','0','1793120003') [ RunTime:0.000230s ]
  31. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_free_months','1','1793120003') [ RunTime:0.000169s ]
  32. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_slots','1','1793120003') [ RunTime:0.000150s ]
  33. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_max','3','1793120003') [ RunTime:0.000151s ]
  34. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_require_mark','1','1793120003') [ RunTime:0.000149s ]
  35. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_contact','','1793120003') [ RunTime:0.000258s ]
  36. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_cols','1','1793120003') [ RunTime:0.000204s ]
  37. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_cols','4','1793120003') [ RunTime:0.000150s ]
  38. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_price','0','1793120003') [ RunTime:0.000149s ]
  39. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_on','0','1793120003') [ RunTime:0.000148s ]
  40. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_note','','1793120003') [ RunTime:0.000158s ]
  41. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_on','1','1793120003') [ RunTime:0.000154s ]
  42. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_alipay','','1793120003') [ RunTime:0.000155s ]
  43. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_wechat','','1793120003') [ RunTime:0.000146s ]
  44. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_alipay','0','1793120003') [ RunTime:0.000147s ]
  45. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_wxpay','0','1793120003') [ RunTime:0.000152s ]
  46. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_url','','1793120003') [ RunTime:0.000156s ]
  47. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_pid','','1793120003') [ RunTime:0.000143s ]
  48. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_key','','1793120003') [ RunTime:0.000142s ]
  49. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_on','0','1793120003') [ RunTime:0.000143s ]
  50. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_appid','','1793120003') [ RunTime:0.000143s ]
  51. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_private_key','','1793120003') [ RunTime:0.000145s ]
  52. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_public_key','','1793120003') [ RunTime:0.000150s ]
  53. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_on','0','1793120003') [ RunTime:0.000149s ]
  54. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_mchid','','1793120003') [ RunTime:0.000146s ]
  55. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_appid','','1793120003') [ RunTime:0.000145s ]
  56. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_v3key','','1793120003') [ RunTime:0.000152s ]
  57. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_serial','','1793120003') [ RunTime:0.000154s ]
  58. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_private_key','','1793120003') [ RunTime:0.000148s ]
  59. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_platform_cert','','1793120003') [ RunTime:0.000145s ]
  60. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_on','1','1793120003') [ RunTime:0.000144s ]
  61. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_price','0','1793120003') [ RunTime:0.000143s ]
  62. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_free_audit','0','1793120003') [ RunTime:0.000144s ]
  63. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_contact','','1793120003') [ RunTime:0.000157s ]
  64. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_on','1','1793120003') [ RunTime:0.000143s ]
  65. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_amounts','5,10,20,50,100','1793120003') [ RunTime:0.002288s ]
  66. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_min','1','1793120003') [ RunTime:0.000170s ]
  67. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_max','9999','1793120003') [ RunTime:0.000147s ]
  68. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_rules','','1793120003') [ RunTime:0.000154s ]
  69. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_audit','0','1793120003') [ RunTime:0.000146s ]
  70. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_forever_on','0','1793120003') [ RunTime:0.000153s ]
  71. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_forever_price','10','1793120003') [ RunTime:0.000149s ]
  72. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_normal_price','0','1793120003') [ RunTime:0.000145s ]
  73. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_best_price','0','1793120003') [ RunTime:0.000142s ]
  74. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_any_include','0','1793120003') [ RunTime:0.000151s ]
  75. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_top_min','0','1793120003') [ RunTime:0.000144s ]
  76. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('app_debug','0','1793120003') [ RunTime:0.000147s ]
  77. INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('dock_on','1','1793120003') [ RunTime:0.000146s ]
  78. SHOW COLUMNS FROM `nav_site` [ RunTime:0.001045s ]
  79. SHOW COLUMNS FROM `nav_site` [ RunTime:0.000786s ]
  80. SHOW COLUMNS FROM `nav_site` [ RunTime:0.000763s ]
  81. SELECT `id`,`slug` FROM `nav_category` [ RunTime:0.000188s ]
  82. SELECT COUNT(*) AS n FROM `nav_category_tag` [ RunTime:0.000156s ]
  83. SELECT `id`,`category_id` FROM `nav_category_tag` ORDER BY `category_id` ASC, `sort` DESC, `id` ASC [ RunTime:0.000177s ]
  84. UPDATE `nav_category_tag` SET `slug` = 'hot-1' WHERE `id` = '1' [ RunTime:0.001713s ]
  85. UPDATE `nav_category_tag` SET `slug` = 'hot-2' WHERE `id` = '2' [ RunTime:0.001274s ]
  86. UPDATE `nav_category_tag` SET `slug` = 'hot-3' WHERE `id` = '3' [ RunTime:0.001798s ]
  87. UPDATE `nav_category_tag` SET `slug` = 'media-1' WHERE `id` = '4' [ RunTime:0.001565s ]
  88. UPDATE `nav_category_tag` SET `slug` = 'media-2' WHERE `id` = '5' [ RunTime:0.003812s ]
  89. UPDATE `nav_category_tag` SET `slug` = 'media-3' WHERE `id` = '6' [ RunTime:0.001453s ]
  90. UPDATE `nav_category_tag` SET `slug` = 'ai-1' WHERE `id` = '7' [ RunTime:0.001097s ]
  91. UPDATE `nav_category_tag` SET `slug` = 'ai-2' WHERE `id` = '8' [ RunTime:0.001050s ]
  92. UPDATE `nav_category_tag` SET `slug` = 'ai-3' WHERE `id` = '9' [ RunTime:0.001054s ]
  93. UPDATE `nav_category_tag` SET `slug` = 'game-1' WHERE `id` = '10' [ RunTime:0.001004s ]
  94. UPDATE `nav_category_tag` SET `slug` = 'game-2' WHERE `id` = '11' [ RunTime:0.005763s ]
  95. UPDATE `nav_category_tag` SET `slug` = 'game-3' WHERE `id` = '12' [ RunTime:0.000961s ]
  96. UPDATE `nav_category_tag` SET `slug` = 'office-1' WHERE `id` = '13' [ RunTime:0.001065s ]
  97. UPDATE `nav_category_tag` SET `slug` = 'office-2' WHERE `id` = '14' [ RunTime:0.001074s ]
  98. UPDATE `nav_category_tag` SET `slug` = 'office-3' WHERE `id` = '15' [ RunTime:0.005082s ]
  99. UPDATE `nav_category_tag` SET `slug` = 'life-1' WHERE `id` = '16' [ RunTime:0.001225s ]
  100. UPDATE `nav_category_tag` SET `slug` = 'life-2' WHERE `id` = '17' [ RunTime:0.001115s ]
  101. UPDATE `nav_category_tag` SET `slug` = 'life-3' WHERE `id` = '18' [ RunTime:0.001177s ]
  102. UPDATE `nav_category_tag` SET `slug` = 'search-1' WHERE `id` = '19' [ RunTime:0.005506s ]
  103. UPDATE `nav_category_tag` SET `slug` = 'search-2' WHERE `id` = '20' [ RunTime:0.001040s ]
  104. UPDATE `nav_category_tag` SET `slug` = 'design-1' WHERE `id` = '22' [ RunTime:0.001057s ]
  105. UPDATE `nav_category_tag` SET `slug` = 'design-2' WHERE `id` = '23' [ RunTime:0.001021s ]
  106. UPDATE `nav_category_tag` SET `slug` = 'design-3' WHERE `id` = '24' [ RunTime:0.001385s ]
  107. UPDATE `nav_category_tag` SET `slug` = 'fun-1' WHERE `id` = '25' [ RunTime:0.001151s ]
  108. UPDATE `nav_category_tag` SET `slug` = 'fun-2' WHERE `id` = '26' [ RunTime:0.003769s ]
  109. UPDATE `nav_category_tag` SET `slug` = 'fun-3' WHERE `id` = '27' [ RunTime:0.002960s ]
  110. UPDATE `nav_category_tag` SET `slug` = 'resource-1' WHERE `id` = '28' [ RunTime:0.001223s ]
  111. UPDATE `nav_category_tag` SET `slug` = 'resource-2' WHERE `id` = '29' [ RunTime:0.001218s ]
  112. UPDATE `nav_category_tag` SET `slug` = 'resource-3' WHERE `id` = '30' [ RunTime:0.004031s ]
  113. UPDATE `nav_category_tag` SET `slug` = 'study-1' WHERE `id` = '31' [ RunTime:0.001238s ]
  114. UPDATE `nav_category_tag` SET `slug` = 'study-2' WHERE `id` = '32' [ RunTime:0.001189s ]
  115. UPDATE `nav_category_tag` SET `slug` = 'study-3' WHERE `id` = '33' [ RunTime:0.001221s ]
  116. SELECT COUNT(*) AS n FROM `nav_link` [ RunTime:0.000212s ]
  117. SELECT COUNT(*) AS n FROM `nav_site` WHERE `slug` = 'bilibili-demo' [ RunTime:0.000176s ]
  118. SHOW COLUMNS FROM `nav_site` [ RunTime:0.001347s ]
  119. SELECT COUNT(*) AS n FROM `nav_like_log` [ RunTime:0.000337s ]
  120. SELECT `id` FROM `nav_link` LIMIT 1 [ RunTime:0.000191s ]
  121. SELECT `id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000173s ]
  122. SELECT `id` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000122s ]
  123. SELECT `id` FROM `nav_ad` LIMIT 1 [ RunTime:0.000171s ]
  124. SELECT `id` FROM `nav_ad_plan` LIMIT 1 [ RunTime:0.000174s ]
  125. SELECT `id`,`order_no`,`pay_channel`,`pay_trade_no` FROM `nav_friend_link` LIMIT 1 [ RunTime:0.000254s ]
  126. SELECT `id`,`type`,`tag_id` FROM `nav_dock` LIMIT 1 [ RunTime:0.000241s ]
  127. SHOW COLUMNS FROM `nav_ad` [ RunTime:0.001125s ]
  128. SELECT `gift_days`,`pay_channel`,`pay_trade_no` FROM `nav_ad` LIMIT 1 [ RunTime:0.000204s ]
  129. SHOW COLUMNS FROM `nav_ad_plan` [ RunTime:0.000756s ]
  130. SELECT `position` FROM `nav_ad_plan` LIMIT 1 [ RunTime:0.000267s ]
  131. SHOW COLUMNS FROM `nav_ad` [ RunTime:0.000797s ]
  132. SELECT `icon` FROM `nav_ad` LIMIT 1 [ RunTime:0.000267s ]
  133. SHOW COLUMNS FROM `nav_qlink` [ RunTime:0.000703s ]
  134. SELECT `subtitle` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000203s ]
  135. SHOW COLUMNS FROM `nav_site` [ RunTime:0.000778s ]
  136. SELECT `hide_code`,`password` FROM `nav_site` LIMIT 1 [ RunTime:0.000184s ]
  137. SELECT `slug` FROM `nav_plugin` LIMIT 1 [ RunTime:0.000138s ]
  138. SHOW COLUMNS FROM `nav_plugin` [ RunTime:0.000875s ]
  139. SELECT `type`,`url`,`icon_url`,`category`,`color`,`badge` FROM `nav_plugin` LIMIT 1 [ RunTime:0.001419s ]
  140. SHOW FULL COLUMNS FROM `nav_plugin` [ RunTime:0.000920s ]
  141. SELECT * FROM `nav_plugin` [ RunTime:0.000305s ]
  142. UPDATE `nav_plugin` SET `category` = 'plugin' WHERE `type` = 'local' AND `category` = 'life' AND `update_time` = `create_time` [ RunTime:0.000407s ]
  143. SHOW FULL COLUMNS FROM `nav_setting` [ RunTime:0.000923s ]
  144. SELECT * FROM `nav_setting` [ RunTime:0.000278s ]
  145. 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.000318s ]
  146. SHOW COLUMNS FROM `nav_sponsor` [ RunTime:0.000747s ]
  147. SELECT `order_no`,`pay_time` FROM `nav_sponsor` LIMIT 1 [ RunTime:0.000169s ]
  148. SHOW COLUMNS FROM `nav_sponsor_order` [ RunTime:0.000716s ]
  149. SELECT `order_no`,`sponsor_id`,`amount`,`base_amount`,`forever`,`include_site` FROM `nav_sponsor_order` LIMIT 1 [ RunTime:0.000179s ]
  150. DELETE FROM `nav_sponsor` WHERE `order_no` = '' AND `pay_time` = 0 AND `name` LIKE '星友%' [ RunTime:0.000222s ]
  151. SELECT COUNT(*) AS `c` FROM `nav_sponsor` [ RunTime:0.000145s ]
  152. REPLACE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('db_version','29','1793120003') [ RunTime:0.002415s ]
  153. SHOW FULL COLUMNS FROM `nav_article` [ RunTime:0.000789s ]
  154. SELECT * FROM `nav_article` WHERE `id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.000275s ]
  155. UPDATE `nav_article` SET `views` = `views` + 1 WHERE `id` = 3 [ RunTime:0.002269s ]
  156. SELECT * FROM `nav_article` WHERE `status` = 1 AND `id` < 3 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
  157. SELECT * FROM `nav_article` WHERE `status` = 1 AND `id` > 3 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000581s ]
  158. SELECT * FROM `nav_article` WHERE `status` = 1 AND `id` <> 3 ORDER BY `views` DESC LIMIT 4 [ RunTime:0.000293s ]
  159. SHOW FULL COLUMNS FROM `nav_article_cat` [ RunTime:0.000964s ]
  160. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000236s ]
  161. SHOW FULL COLUMNS FROM `nav_category` [ RunTime:0.000722s ]
  162. SELECT * FROM `nav_category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000288s ]
  163. SHOW FULL COLUMNS FROM `nav_site` [ RunTime:0.000872s ]
  164. SELECT `hide_code` FROM `nav_site` LIMIT 1 [ RunTime:0.000175s ]
  165. SELECT category_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id` [ RunTime:0.000580s ]
  166. SELECT SUM(`views`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.000316s ]
  167. SELECT SUM(`views`) AS think_sum FROM `nav_article` WHERE `status` = 1 [ RunTime:0.000263s ]
  168. SELECT SUM(`likes`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.000278s ]
  169. SHOW FULL COLUMNS FROM `nav_category_tag` [ RunTime:0.000787s ]
  170. SELECT COUNT(*) AS think_count FROM `nav_category_tag` WHERE `status` = 1 [ RunTime:0.000210s ]
  171. SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000311s ]
  172. SELECT tag_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `tag_id` [ RunTime:0.000417s ]
  173. SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_date` = 1793116800 AND `views_today` > 0 ORDER BY `views_today` DESC,`id` DESC LIMIT 8 [ RunTime:0.000436s ]
  174. SHOW FULL COLUMNS FROM `nav_like_log` [ RunTime:0.000798s ]
  175. SELECT `target_id` FROM `nav_like_log` WHERE `type` = 'site' AND `ip` = '39.145.32.217' [ RunTime:0.000220s ]
  176. SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_wkey` = '202644' AND `views_week` > 0 ORDER BY `views_week` DESC,`id` DESC LIMIT 8 [ RunTime:0.000502s ]
  177. SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `views_mkey` = '202610' AND `views_month` > 0 ORDER BY `views_month` DESC,`id` DESC LIMIT 8 [ RunTime:0.000475s ]
  178. SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' ORDER BY `views` DESC,`id` DESC LIMIT 8 [ RunTime:0.000391s ]
  179. SHOW FULL COLUMNS FROM `nav_ad` [ RunTime:0.003564s ]
  180. SELECT * FROM `nav_ad` WHERE `status` = 2 AND `position` = 'home_banner' AND `start_time` <= 1793120003 AND `end_time` >= 1793120003 ORDER BY `sort` DESC,`id` DESC LIMIT 30 [ RunTime:0.000384s ]
  181. SHOW FULL COLUMNS FROM `nav_link` [ RunTime:0.000726s ]
  182. SELECT * FROM `nav_link` WHERE `status` = 1 AND `position` = 'top' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000273s ]
  183. SELECT * FROM `nav_link` WHERE `status` = 1 AND `position` = 'foot' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000267s ]
  184. SHOW FULL COLUMNS FROM `nav_qlink` [ RunTime:0.000707s ]
  185. SELECT * FROM `nav_qlink` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 16 [ RunTime:0.000244s ]
  186. SELECT * FROM `nav_category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000224s ]
  187. SELECT category_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id` [ RunTime:0.000425s ]
  188. SHOW FULL COLUMNS FROM `nav_dock` [ RunTime:0.000705s ]
  189. SELECT * FROM `nav_dock` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 12 [ RunTime:0.000241s ]
  190. SELECT * FROM `nav_category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000220s ]
  191. SELECT category_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id` [ RunTime:0.000405s ]
  192. SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000251s ]
  193. SELECT tag_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `tag_id` [ RunTime:0.000410s ]
  194. SELECT * FROM `nav_site` WHERE `status` = 1 AND `id` = 96 AND `hide_code` = '' [ RunTime:0.000285s ]
  195. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000223s ]
  196. SHOW FULL COLUMNS FROM `nav_notice` [ RunTime:0.000737s ]
  197. SELECT * FROM `nav_notice` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.000218s ]
  198. SHOW FULL COLUMNS FROM `nav_sponsor` [ RunTime:0.000741s ]
  199. SELECT * FROM `nav_sponsor` WHERE `status` = 1 ORDER BY `amount` DESC,`id` ASC LIMIT 6 [ RunTime:0.000312s ]
  200. SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.000285s ]
  201. SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 [ RunTime:0.000179s ]
  202. SELECT COUNT(*) AS think_count FROM `nav_notice` WHERE `status` = 1 [ RunTime:0.000177s ]
  203. SELECT COUNT(*) AS think_count FROM `nav_sponsor` WHERE `status` = 1 [ RunTime:0.000171s ]
  204. SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `create_time` >= 1793116800 [ RunTime:0.000269s ]
  205. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000202s ]
  206. SELECT * FROM `nav_article` WHERE `status` = 1 ORDER BY `views` DESC,`id` DESC LIMIT 6 [ RunTime:0.000226s ]
  207. SELECT * FROM `nav_article` WHERE `status` = 1 ORDER BY `id` DESC LIMIT 6 [ RunTime:0.000211s ]
  208. SELECT category_id, COUNT(*) AS n FROM `nav_article` WHERE `status` = 1 GROUP BY `category_id` [ RunTime:0.000192s ]
  209. SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.003086s ]
0.196966s