ZsAdmin 智数网址导航插件部署完整教程

张森森主理

管理员

部署教程 103 浏览 0 回复

插件简介：本插件基于 ZsAdmin「智数」插件化机制开发，使用独立数据表，不会污染主系统业务数据，安装完成即可快速搭建一套完整的网址导航站点。插件官方地址：https://www.zsadmin.com/market/52.html

一、环境前置条件

已经部署完成 ZsAdmin「智数」主程序，系统运行正常，后台可以正常登录访问。
服务器文件目录读写权限正常，保证插件安装过程数据表可以正常创建。
伪静态功能如需使用 SEO 自定义 URL 规则，请确认服务器已开启伪静态支持（Nginx/Apache）。

提示：插件采用独立数据表，不会改动原有业务表，安装不会影响现有系统业务。

二、插件安装步骤

登录你的 ZsAdmin「智数」系统后台管理界面。
在后台菜单找到【应用中心】，进入应用插件市场。
在应用中心列表找到网址导航插件，点击安装，系统将自动完成插件文件部署、数据表创建。
安装完成后刷新后台菜单，即可看到导航插件对应的管理功能菜单。

补充：如应用中心加载异常，确认服务器网络可访问 ZsAdmin 官方市场源。

三、后台基础配置流程

3.1 分类管理配置

进入插件后台→分类管理，新增导航分类。
设置分类名称，调整排序权重，控制是否前台显示 / 隐藏。
需要独立在线工具页面时，标记该分类为【常用工具分类】，保存后自动生成独立在线工具前台页面。

3.2 站点信息录入管理

进入【站点管理】，添加导航站点信息。
填写站点名称、访问 URL、站点图标、简介、权重、排序、启用状态，选择归属分类。
支持批量维护站点，权重数值越大前台排序越靠前；禁用状态前台不再展示该站点。

3.3 SEO 优化设置

分别对站点、分类、自定义单页配置独立 SEO 标题、关键词、页面描述。
如需开启伪静态，进入插件设置，开启并自定义伪静态 URL 规则，同步修改服务器伪静态配置使之匹配规则。

3.4 游客交互功能配置

插件自带游客提交收录、站点举报功能：

前台访客可以提交站点收录申请、提交违规站点举报。
在后台待审核列表查看用户提交内容，审核通过 / 驳回处理访客申请。

3.5 访问统计功能说明

插件自动记录每个站点每日点击数据，自动生成日 / 周 / 月榜单，输出 SVG 格式访问趋势图表。
后台可查看站点点击统计，榜单页面会同步展示到前台排行榜页面，无需额外配置。

3.6 扩展功能对接

可选对接百度热榜、百度权重采集功能，在插件设置开启对应采集开关。
支持联动社区会员插件、友情链接插件，安装对应配套插件后即可实现数据互通。

四、前台页面访问说明

插件安装配置完成后，自动生成多套独立前台页面：

首页聚合页：全部导航站点聚合展示
分类页：按分类筛选站点
在线工具页：标记常用工具分类后的独立页面
最近更新页：展示新增 / 更新站点
排行榜页：点击统计生成榜单
站点详情页：单站点详情介绍
自定义单页内容：自定义静态内容页面
游客提交收录页、站点举报反馈页

UI 布局为现代卡片式，自动适配 PC 端与移动端；站点图标加载失败会自动使用文字占位，内置配色算法自动生成卡片主题色，无需手动调整样式。

五、数据导入

1、分类数据导入（phpmyadmin数据库管理、sql命令复制粘贴执行）

INSERT INTO `zsens_navigation_category`
(`name`, `icon`, `sort`, `status`, `is_tool`, `create_time`, `update_time`)
VALUES
('搜索引擎',   '', 1,  1, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()),
('新闻资讯',   '', 2,  1, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()),
('购物生活',   '', 3,  1, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()),
('影音娱乐',   '', 4,  1, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()),
('社交社区',   '', 5,  1, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()),
('学习教育',   '', 6,  1, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()),
('开发工具',   '', 7,  1, 1, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()),
('人工智能',   '', 8,  1, 1, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()),
('财经办公',   '', 9,  1, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()),
('求职出行',   '', 10, 1, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()),
('数码科技',   '', 11, 1, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()),
('政务便民',   '', 12, 1, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP());

2、站点数据导入（phpmyadmin数据库管理、sql命令复制粘贴执行）

INSERT INTO `zsens_navigation_site`
(`category_id`, `name`, `url`, `icon`, `description`, `color`,
 `weight_baidu`, `weight_360`, `weight_sogou`, `weight_google`, `alexa_rank`,
 `clicks`, `is_featured`, `is_tool`, `backlink_status`, `backlink_checked`,
 `sort`, `status`, `create_time`, `update_time`)
VALUES
-- ============ 1. 搜索引擎 ============
(1,'百度','https://www.baidu.com','','全球最大的中文搜索引擎','',10,10,10,9,4,520,1,0,0,0,10,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'谷歌搜索','https://www.google.com','','全球最流行的搜索引擎','',10,10,10,10,1,500,1,0,0,0,20,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'必应','https://www.bing.com','','微软出品的国际搜索引擎','',9,9,9,9,20,380,0,0,0,0,30,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'360搜索','https://www.so.com','','360旗下的安全搜索引擎','',9,9,8,7,80,300,0,0,0,0,40,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'搜狗搜索','https://www.sogou.com','','搜狗旗下中文搜索引擎','',9,8,9,7,90,290,0,0,0,0,50,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'神马搜索','https://m.sm.cn','','阿里旗下移动搜索引擎','',8,7,7,6,150,200,0,0,0,0,60,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'DuckDuckGo','https://duckduckgo.com','','注重隐私的搜索引擎','',7,6,6,8,180,180,0,0,0,0,70,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'Yandex','https://yandex.com','','俄罗斯最大搜索引擎','',6,5,5,7,220,150,0,0,0,0,80,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'雅虎搜索','https://search.yahoo.com','','老牌门户搜索','',6,5,5,6,300,130,0,0,0,0,90,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'夸克搜索','https://quark.sm.cn','','阿里旗下智能搜索','',8,7,7,6,260,210,0,0,0,0,100,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'头条搜索','https://so.toutiao.com','','字节跳动综合搜索','',8,7,7,6,240,190,0,0,0,0,110,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'知乎搜索','https://www.zhihu.com/search','','知乎站内搜索','',7,6,6,5,400,120,0,0,0,0,120,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'微博搜索','https://s.weibo.com','','微博热搜与搜索','',7,6,6,5,410,110,0,0,0,0,130,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'Brave搜索','https://search.brave.com','','隐私优先的独立搜索','',5,5,5,6,500,80,0,0,0,0,140,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'Ecosia','https://www.ecosia.org','','环保植树搜索','',5,5,5,6,520,70,0,0,0,0,150,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'Startpage','https://www.startpage.com','','匿名谷歌搜索','',5,5,5,5,600,60,0,0,0,0,160,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'Qwant','https://www.qwant.com','','欧洲隐私搜索引擎','',4,4,4,5,650,55,0,0,0,0,170,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'Naver','https://www.naver.com','','韩国最大搜索引擎','',4,4,4,5,700,50,0,0,0,0,180,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'百度学术','https://xueshu.baidu.com','','百度学术搜索','',6,6,6,5,450,90,0,0,0,0,190,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(1,'中国搜索','http://www.chinaso.com','','国家级搜索引擎','',6,6,6,5,480,85,0,0,0,0,200,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),

-- ============ 2. 新闻资讯 ============
(2,'新浪新闻','https://news.sina.com.cn','','综合新闻门户','',9,8,8,7,30,480,1,0,0,0,10,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'腾讯新闻','https://news.qq.com','','腾讯综合新闻','',9,8,8,7,25,470,1,0,0,0,20,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'网易新闻','https://news.163.com','','有态度的新闻','',9,8,8,7,28,450,0,0,0,0,30,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'搜狐新闻','https://news.sohu.com','','老牌门户新闻','',8,8,8,7,35,400,0,0,0,0,40,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'凤凰新闻','https://news.ifeng.com','','凤凰卫视新闻','',8,8,8,7,40,380,0,0,0,0,50,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'澎湃新闻','https://www.thepaper.cn','','时政思想类新闻','',8,8,8,7,60,350,0,0,0,0,60,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'界面新闻','https://www.jiemian.com','','财经商业新闻','',7,7,7,6,120,260,0,0,0,0,70,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'财新网','https://www.caixin.com','','专业财经新闻','',7,7,7,6,130,240,0,0,0,0,80,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'第一财经','https://www.yicai.com','','财经资讯平台','',7,7,7,6,140,230,0,0,0,0,90,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'新华网','http://www.xinhuanet.com','','国家通讯社新闻','',8,8,8,7,50,360,0,0,0,0,100,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'人民网','http://www.people.com.cn','','权威时政新闻','',8,8,8,7,55,340,0,0,0,0,110,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'央视网','https://www.cctv.com','','中央电视台官网','',8,8,8,7,65,330,0,0,0,0,120,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'中国新闻网','http://www.chinanews.com.cn','','中新社新闻','',8,8,8,7,70,320,0,0,0,0,130,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'环球网','https://www.huanqiu.com','','国际资讯','',7,7,7,6,110,270,0,0,0,0,140,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'观察者网','https://www.guancha.cn','','时政评论','',7,7,7,6,150,220,0,0,0,0,150,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'36氪','https://36kr.com','','科技创投媒体','',7,7,7,6,160,210,0,0,0,0,160,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'虎嗅网','https://www.huxiu.com','','商业科技资讯','',7,7,7,6,170,200,0,0,0,0,170,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'钛媒体','https://www.tmtpost.com','','科技财经媒体','',6,6,6,6,200,180,0,0,0,0,180,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'今日头条','https://www.toutiao.com','','个性化资讯推荐','',9,8,8,7,22,460,0,0,0,0,190,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(2,'百度新闻','https://news.baidu.com','','百度聚合新闻','',8,8,8,7,45,390,0,0,0,0,200,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),

-- ============ 3. 购物生活 ============
(3,'淘宝','https://www.taobao.com','','中国最大电商平台','',10,9,9,8,8,510,1,0,0,0,10,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'京东','https://www.jd.com','','正品自营电商','',10,9,9,8,10,500,1,0,0,0,20,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'天猫','https://www.tmall.com','','品牌旗舰商城','',9,9,9,8,12,480,0,0,0,0,30,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'拼多多','https://www.pinduoduo.com','','社交拼团电商','',9,9,9,8,15,460,0,0,0,0,40,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'唯品会','https://www.vip.com','','品牌特卖','',8,8,8,7,45,320,0,0,0,0,50,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'苏宁易购','https://www.suning.com','','家电3C商城','',8,8,8,7,50,310,0,0,0,0,60,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'美团','https://www.meituan.com','','本地生活服务','',9,9,9,8,18,450,0,0,0,0,70,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'饿了么','https://www.ele.me','','外卖订餐平台','',8,8,8,7,40,340,0,0,0,0,80,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'大众点评','https://www.dianping.com','','生活消费点评','',8,8,8,7,42,330,0,0,0,0,90,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'携程旅行','https://www.ctrip.com','','在线旅行服务','',8,8,8,7,48,300,0,0,0,0,100,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'去哪儿','https://www.qunar.com','','旅行搜索比价','',8,8,8,7,55,290,0,0,0,0,110,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'飞猪','https://www.fliggy.com','','阿里旅行平台','',8,8,8,7,58,280,0,0,0,0,120,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'闲鱼','https://www.goofish.com','','二手交易平台','',8,8,8,7,62,270,0,0,0,0,130,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'小红书','https://www.xiaohongshu.com','','生活方式分享','',9,9,9,8,20,440,0,0,0,0,140,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'什么值得买','https://www.smzdm.com','','消费决策平台','',7,7,7,6,130,220,0,0,0,0,150,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'国美','https://www.gome.com.cn','','家电连锁商城','',7,7,7,6,150,190,0,0,0,0,160,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'亚马逊中国','https://www.amazon.cn','','全球电商中国站','',7,7,7,7,120,200,0,0,0,0,170,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'网易严选','https://you.163.com','','品质生活电商','',7,7,7,6,160,180,0,0,0,0,180,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'盒马','https://www.freshhippo.com','','生鲜新零售','',7,7,7,6,170,170,0,0,0,0,190,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(3,'叮咚买菜','https://www.100.me','','生鲜到家','',6,6,6,6,200,150,0,0,0,0,200,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),

-- ============ 4. 影音娱乐 ============
(4,'爱奇艺','https://www.iqiyi.com','','在线视频平台','',9,9,9,8,14,490,1,0,0,0,10,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'腾讯视频','https://v.qq.com','','腾讯在线视频','',9,9,9,8,16,480,1,0,0,0,20,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'优酷','https://www.youku.com','','阿里视频平台','',9,8,9,8,17,460,0,0,0,0,30,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'芒果TV','https://www.mgtv.com','','湖南卫视视频','',8,8,8,7,35,380,0,0,0,0,40,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'哔哩哔哩','https://www.bilibili.com','','弹幕视频社区','',9,9,9,8,19,470,0,0,0,0,50,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'搜狐视频','https://tv.sohu.com','','搜狐在线视频','',7,7,7,6,80,240,0,0,0,0,60,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'PP视频','https://www.pptv.com','','苏宁旗下视频','',7,7,7,6,100,200,0,0,0,0,70,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'抖音','https://www.douyin.com','','短视频平台','',10,9,9,8,6,510,0,0,0,0,80,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'快手','https://www.kuaishou.com','','短视频社区','',9,9,9,8,11,490,0,0,0,0,90,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'网易云音乐','https://music.163.com','','音乐流媒体','',8,8,8,7,38,360,0,0,0,0,100,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'QQ音乐','https://y.qq.com','','腾讯音乐平台','',8,8,8,7,36,370,0,0,0,0,110,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'酷狗音乐','https://www.kugou.com','','音乐播放平台','',8,8,8,7,42,330,0,0,0,0,120,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'喜马拉雅','https://www.ximalaya.com','','音频分享平台','',8,8,8,7,48,310,0,0,0,0,130,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'猫眼电影','https://www.maoyan.com','','电影票务平台','',8,8,8,7,55,290,0,0,0,0,140,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'豆瓣电影','https://movie.douban.com','','电影评分社区','',8,8,8,7,60,280,0,0,0,0,150,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'虎牙直播','https://www.huya.com','','游戏直播平台','',8,8,8,7,70,260,0,0,0,0,160,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'斗鱼直播','https://www.douyu.com','','游戏直播平台','',8,8,8,7,72,250,0,0,0,0,170,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'Netflix','https://www.netflix.com','','全球流媒体','',7,7,7,8,90,220,0,0,0,0,180,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'YouTube','https://www.youtube.com','','全球视频平台','',9,9,9,10,2,500,0,0,0,0,190,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(4,'Spotify','https://www.spotify.com','','全球音乐流媒体','',7,7,7,9,30,230,0,0,0,0,200,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),

-- ============ 5. 社交社区 ============
(5,'微信','https://weixin.qq.com','','国民级社交应用','',10,10,10,8,5,520,1,0,0,0,10,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'QQ','https://im.qq.com','','腾讯即时通讯','',10,9,10,8,7,510,1,0,0,0,20,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'微博','https://weibo.com','','新浪微博','',9,9,9,8,9,480,0,0,0,0,30,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'知乎','https://www.zhihu.com','','问答社区','',9,9,9,8,21,460,0,0,0,0,40,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'豆瓣','https://www.douban.com','','文艺社区','',8,8,8,7,44,340,0,0,0,0,50,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'贴吧','https://tieba.baidu.com','','百度兴趣社区','',8,8,8,7,46,330,0,0,0,0,60,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'天涯社区','https://www.tianya.cn','','老牌论坛','',7,7,7,6,120,220,0,0,0,0,70,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'虎扑','https://www.hupu.com','','体育社区','',7,7,7,6,130,210,0,0,0,0,80,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'脉脉','https://maimai.cn','','职场社交','',7,7,7,6,140,200,0,0,0,0,90,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'Soul','https://www.soulapp.cn','','社交App','',7,7,7,6,150,190,0,0,0,0,100,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'陌陌','https://www.immomo.com','','社交App','',7,7,7,6,160,180,0,0,0,0,110,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'探探','https://www.tantanapp.com','','社交App','',6,6,6,6,170,170,0,0,0,0,120,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'Facebook','https://www.facebook.com','','全球社交网络','',9,9,9,10,3,500,0,0,0,0,130,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'Twitter/X','https://twitter.com','','全球微博客','',9,9,9,10,4,490,0,0,0,0,140,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'Instagram','https://www.instagram.com','','图片社交','',8,8,8,9,6,470,0,0,0,0,150,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'Reddit','https://www.reddit.com','','全球论坛社区','',8,8,8,9,8,450,0,0,0,0,160,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'LinkedIn','https://www.linkedin.com','','职业社交','',7,7,7,9,12,300,0,0,0,0,170,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'Discord','https://discord.com','','游戏语音社区','',7,7,7,8,20,280,0,0,0,0,180,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'Telegram','https://telegram.org','','加密即时通讯','',7,7,7,8,18,290,0,0,0,0,190,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(5,'WhatsApp','https://www.whatsapp.com','','全球即时通讯','',8,8,8,9,10,400,0,0,0,0,200,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),

-- ============ 6. 学习教育 ============
(6,'中国大学MOOC','https://www.icourse163.org','','高校在线课程','',8,8,8,7,80,350,1,0,0,0,10,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'学堂在线','https://www.xuetangx.com','','清华在线课程','',8,8,8,7,90,330,1,0,0,0,20,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'网易公开课','https://open.163.com','','名校公开课','',8,8,8,7,95,320,0,0,0,0,30,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'腾讯课堂','https://ke.qq.com','','在线职业课堂','',8,8,8,7,85,340,0,0,0,0,40,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'B站学习区','https://www.bilibili.com/v/knowledge','','B站知识区','',8,8,8,7,60,360,0,0,0,0,50,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'得到','https://www.dedao.cn','','知识付费平台','',7,7,7,6,150,240,0,0,0,0,60,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'喜马拉雅教育','https://www.ximalaya.com','','音频学习','',7,7,7,6,130,250,0,0,0,0,70,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'Coursera','https://www.coursera.org','','国际在线课程','',8,8,8,9,25,300,0,0,0,0,80,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'edX','https://www.edx.org','','国际名校课程','',8,8,8,9,28,290,0,0,0,0,90,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'Udemy','https://www.udemy.com','','技能学习平台','',7,7,7,9,35,260,0,0,0,0,100,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'Khan Academy','https://www.khanacademy.org','','免费教育平台','',8,8,8,9,30,280,0,0,0,0,110,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'可汗学院中文','https://zh.khanacademy.org','','可汗学院中文','',7,7,7,7,180,150,0,0,0,0,120,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'扇贝单词','https://www.shanbay.com','','英语学习','',7,7,7,6,200,180,0,0,0,0,130,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'百词斩','https://www.baicizhan.com','','英语背单词','',7,7,7,6,210,170,0,0,0,0,140,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'多邻国','https://www.duolingo.com','','语言学习','',8,8,8,9,40,270,0,0,0,0,150,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'作业帮','https://www.zybang.com','','K12在线辅导','',7,7,7,6,160,200,0,0,0,0,160,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'学而思网校','https://www.xueersi.com','','K12在线教育','',7,7,7,6,170,190,0,0,0,0,170,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'猿辅导','https://www.yuanfudao.com','','K12在线辅导','',7,7,7,6,175,185,0,0,0,0,180,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'粉笔网','https://www.fenbi.com','','公考学习平台','',7,7,7,6,190,175,0,0,0,0,190,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(6,'沪江网校','https://www.hujiang.com','','外语学习','',7,7,7,6,195,170,0,0,0,0,200,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),

-- ============ 7. IT 工具 ============
(7,'GitHub','https://github.com','','全球最大代码托管','',10,10,10,10,13,510,1,1,0,0,10,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'Gitee','https://gitee.com','','国内代码托管','',9,9,9,8,45,480,1,1,0,0,20,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'Stack Overflow','https://stackoverflow.com','','程序员问答社区','',10,10,10,10,32,470,0,1,0,0,30,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'CSDN','https://www.csdn.net','','中文技术社区','',9,9,9,8,60,460,0,1,0,0,40,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'博客园','https://www.cnblogs.com','','开发者博客社区','',8,8,8,7,120,380,0,1,0,0,50,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'掘金','https://juejin.cn','','技术分享社区','',8,8,8,7,130,360,0,1,0,0,60,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'思否','https://segmentfault.com','','技术问答社区','',8,8,8,7,140,340,0,1,0,0,70,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'开源中国','https://www.oschina.net','','开源技术社区','',8,8,8,7,150,330,0,1,0,0,80,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'InfoQ','https://www.infoq.cn','','技术资讯','',7,7,7,7,180,260,0,1,0,0,90,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'V2EX','https://www.v2ex.com','','程序员社区','',7,7,7,7,190,250,0,1,0,0,100,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'Postman','https://www.postman.com','','API调试工具','',8,8,8,9,80,300,0,1,0,0,110,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'Docker Hub','https://hub.docker.com','','容器镜像仓库','',8,8,8,9,70,310,0,1,0,0,120,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'npm','https://www.npmjs.com','','Node包管理','',8,8,8,9,90,290,0,1,0,0,130,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'PyPI','https://pypi.org','','Python包管理','',8,8,8,9,95,280,0,1,0,0,140,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'Maven','https://maven.apache.org','','Java构建工具','',7,7,7,8,200,220,0,1,0,0,150,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'阿里云','https://www.aliyun.com','','云计算服务','',9,9,9,8,50,440,0,1,0,0,160,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'腾讯云','https://cloud.tencent.com','','云计算服务','',9,9,9,8,55,430,0,1,0,0,170,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'华为云','https://www.huaweicloud.com','','云计算服务','',9,9,9,8,58,420,0,1,0,0,180,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'七牛云','https://www.qiniu.com','','云存储CDN','',7,7,7,7,220,200,0,1,0,0,190,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(7,'又拍云','https://www.upyun.com','','云存储CDN','',7,7,7,7,230,190,0,1,0,0,200,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),

-- ============ 8. AI 专区 ============
(8,'ChatGPT','https://chat.openai.com','','OpenAI对话AI','',10,10,10,10,1,520,1,1,0,0,10,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'Claude','https://claude.ai','','Anthropic对话AI','',9,9,9,10,15,490,1,1,0,0,20,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'文心一言','https://yiyan.baidu.com','','百度大模型','',9,9,9,8,20,470,0,1,0,0,30,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'通义千问','https://tongyi.aliyun.com','','阿里大模型','',9,9,9,8,22,460,0,1,0,0,40,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'讯飞星火','https://xinghuo.xfyun.cn','','科大讯飞大模型','',8,8,8,7,60,380,0,1,0,0,50,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'智谱清言','https://chatglm.cn','','智谱AI大模型','',8,8,8,7,70,360,0,1,0,0,60,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'Kimi','https://kimi.moonshot.cn','','月之暗面AI','',9,9,9,8,30,450,0,1,0,0,70,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'豆包','https://www.doubao.com','','字节AI助手','',9,9,9,8,28,440,0,1,0,0,80,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'腾讯混元','https://hunyuan.tencent.com','','腾讯大模型','',8,8,8,7,75,340,0,1,0,0,90,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'Gemini','https://gemini.google.com','','谷歌AI助手','',9,9,9,10,10,480,0,1,0,0,100,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'Copilot','https://copilot.microsoft.com','','微软AI助手','',9,9,9,10,12,470,0,1,0,0,110,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'Midjourney','https://www.midjourney.com','','AI绘画','',8,8,8,9,40,380,0,1,0,0,120,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'Stable Diffusion','https://stability.ai','','开源AI绘画','',8,8,8,9,45,360,0,1,0,0,130,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'Hugging Face','https://huggingface.co','','AI模型社区','',9,9,9,10,25,420,0,1,0,0,140,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'Perplexity','https://www.perplexity.ai','','AI搜索引擎','',8,8,8,9,35,390,0,1,0,0,150,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'Suno','https://www.suno.ai','','AI音乐生成','',7,7,7,8,80,280,0,1,0,0,160,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'Runway','https://runwayml.com','','AI视频生成','',7,7,7,8,85,270,0,1,0,0,170,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'剪映AI','https://www.capcut.cn','','AI视频剪辑','',8,8,8,7,65,320,0,1,0,0,180,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'Gamma','https://gamma.app','','AI演示文稿','',7,7,7,8,90,240,0,1,0,0,190,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(8,'Notion AI','https://www.notion.so/product/ai','','AI笔记助手','',7,7,7,8,95,230,0,1,0,0,200,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),

-- ============ 9. 财经办公 ============
(9,'东方财富','https://www.eastmoney.com','','财经证券门户','',9,8,8,7,30,470,1,0,0,0,10,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'同花顺','https://www.10jqka.com.cn','','股票行情软件','',9,8,8,7,32,460,1,0,0,0,20,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'雪球','https://xueqiu.com','','投资社区','',8,8,8,7,55,380,0,0,0,0,30,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'和讯网','https://www.hexun.com','','财经资讯','',8,8,8,7,80,300,0,0,0,0,40,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'金融界','https://www.jrj.com.cn','','财经资讯','',7,7,7,6,100,260,0,0,0,0,50,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'新浪财经','https://finance.sina.com.cn','','财经资讯','',8,8,8,7,40,340,0,0,0,0,60,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'腾讯财经','https://new.qq.com/ch/finance','','财经资讯','',8,8,8,7,42,330,0,0,0,0,70,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'WPS Office','https://www.wps.cn','','国产办公软件','',9,9,9,8,25,450,0,0,0,0,80,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'Microsoft 365','https://www.office.com','','微软办公套件','',9,9,9,10,18,440,0,0,0,0,90,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'石墨文档','https://shimo.im','','在线协作文档','',8,8,8,7,90,320,0,0,0,0,100,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'腾讯文档','https://docs.qq.com','','在线协作文档','',8,8,8,7,85,330,0,0,0,0,110,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'飞书','https://www.feishu.cn','','字节办公协作','',9,9,9,8,35,410,0,0,0,0,120,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'钉钉','https://www.dingtalk.com','','阿里办公协作','',9,9,9,8,38,400,0,0,0,0,130,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'企业微信','https://work.weixin.qq.com','','腾讯办公协作','',9,9,9,8,36,405,0,0,0,0,140,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'Notion','https://www.notion.so','','笔记协作平台','',8,8,8,9,60,300,0,0,0,0,150,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'Slack','https://slack.com','','团队协作','',8,8,8,9,65,290,0,0,0,0,160,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'Zoom','https://zoom.us','','视频会议','',8,8,8,9,70,280,0,0,0,0,170,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'Trello','https://trello.com','','看板项目管理','',7,7,7,8,110,230,0,0,0,0,180,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'Xmind','https://www.xmind.cn','','思维导图','',7,7,7,7,150,210,0,0,0,0,190,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(9,'ProcessOn','https://www.processon.com','','在线流程图','',7,7,7,7,160,200,0,0,0,0,200,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),

-- ============ 10. 求职出行 ============
(10,'BOSS直聘','https://www.zhipin.com','','直聊招聘平台','',9,9,9,8,45,470,1,0,0,0,10,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'智联招聘','https://www.zhaopin.com','','老牌招聘平台','',9,8,8,7,50,440,1,0,0,0,20,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'前程无忧','https://www.51job.com','','招聘求职平台','',8,8,8,7,55,420,0,0,0,0,30,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'猎聘','https://www.liepin.com','','中高端招聘','',8,8,8,7,60,380,0,0,0,0,40,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'拉勾网','https://www.lagou.com','','互联网招聘','',8,8,8,7,70,340,0,0,0,0,50,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'58同城','https://www.58.com','','同城生活服务','',8,8,8,7,40,400,0,0,0,0,60,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'脉脉招聘','https://maimai.cn','','职场招聘社交','',7,7,7,6,100,260,0,0,0,0,70,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'LinkedIn招聘','https://www.linkedin.com','','全球职业社交','',7,7,7,9,15,300,0,0,0,0,80,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'12306','https://www.12306.cn','','铁路购票官网','',9,9,9,8,30,490,0,0,0,0,90,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'携程机票','https://flights.ctrip.com','','机票预订','',8,8,8,7,42,380,0,0,0,0,100,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'飞猪机票','https://www.fliggy.com','','机票预订','',8,8,8,7,48,360,0,0,0,0,110,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'高德地图','https://www.amap.com','','地图导航','',9,9,9,8,25,480,0,0,0,0,120,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'百度地图','https://map.baidu.com','','地图导航','',9,9,9,8,28,470,0,0,0,0,130,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'腾讯地图','https://map.qq.com','','地图导航','',8,8,8,7,35,400,0,0,0,0,140,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'滴滴出行','https://www.didiglobal.com','','网约车平台','',9,9,9,8,32,460,0,0,0,0,150,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'哈啰出行','https://www.hello-inc.com','','共享单车','',8,8,8,7,50,360,0,0,0,0,160,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'美团打车','https://www.meituan.com','','网约车','',7,7,7,6,90,280,0,0,0,0,170,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'T3出行','https://www.t3go.cn','','网约车','',7,7,7,6,95,270,0,0,0,0,180,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'Booking','https://www.booking.com','','全球酒店预订','',8,8,8,9,20,320,0,0,0,0,190,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(10,'Airbnb','https://www.airbnb.cn','','全球民宿预订','',8,8,8,9,22,310,0,0,0,0,200,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),

-- ============ 11. 数码科技 ============
(11,'中关村在线','https://www.zol.com.cn','','数码科技门户','',9,8,8,7,45,450,1,0,0,0,10,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'太平洋电脑网','https://www.pconline.com.cn','','数码科技门户','',8,8,8,7,55,400,1,0,0,0,20,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'IT之家','https://www.ithome.com','','科技资讯','',8,8,8,7,60,380,0,0,0,0,30,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'快科技','https://www.mydrivers.com','','科技资讯','',8,8,8,7,65,360,0,0,0,0,40,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'爱范儿','https://www.ifanr.com','','科技媒体','',7,7,7,6,120,260,0,0,0,0,50,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'极客公园','https://www.geekpark.net','','科技媒体','',7,7,7,6,130,250,0,0,0,0,60,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'少数派','https://sspai.com','','数码效率','',7,7,7,6,140,240,0,0,0,0,70,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'数字尾巴','https://www.dgtle.com','','数码社区','',7,7,7,6,150,230,0,0,0,0,80,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'苹果官网','https://www.apple.com.cn','','Apple中国','',9,9,9,10,12,470,0,0,0,0,90,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'小米官网','https://www.mi.com','','小米商城','',9,9,9,8,20,460,0,0,0,0,100,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'华为官网','https://www.huawei.com','','华为官网','',9,9,9,8,18,465,0,0,0,0,110,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'三星官网','https://www.samsung.com','','三星官网','',8,8,8,9,22,380,0,0,0,0,120,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'OPPO官网','https://www.oppo.com','','OPPO官网','',8,8,8,7,30,360,0,0,0,0,130,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'vivo官网','https://www.vivo.com','','vivo官网','',8,8,8,7,32,350,0,0,0,0,140,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'联想官网','https://www.lenovo.com.cn','','联想商城','',8,8,8,7,40,330,0,0,0,0,150,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'戴尔官网','https://www.dell.com','','戴尔官网','',8,8,8,8,35,320,0,0,0,0,160,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'华硕官网','https://www.asus.com.cn','','华硕官网','',7,7,7,7,60,280,0,0,0,0,170,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'英伟达','https://www.nvidia.cn','','NVIDIA中国','',8,8,8,9,50,300,0,0,0,0,180,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'英特尔','https://www.intel.cn','','Intel中国','',8,8,8,9,48,310,0,0,0,0,190,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(11,'AMD','https://www.amd.com','','AMD官网','',8,8,8,9,46,305,0,0,0,0,200,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),

-- ============ 12. 政务便民 ============
(12,'中国政府网','https://www.gov.cn','','国务院官网','',9,9,9,8,25,490,1,0,0,0,10,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'国家政务服务平台','http://gjzwfw.www.gov.cn','','全国政务平台','',9,9,9,8,30,470,1,0,0,0,20,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'公安部','https://www.mps.gov.cn','','公安部官网','',8,8,8,7,60,380,0,0,0,0,30,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'人社部','http://www.mohrss.gov.cn','','人力资源和社会保障部','',8,8,8,7,70,360,0,0,0,0,40,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'国家税务总局','http://www.chinatax.gov.cn','','国家税务总局','',8,8,8,7,65,370,0,0,0,0,50,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'教育部','http://www.moe.gov.cn','','教育部官网','',8,8,8,7,68,365,0,0,0,0,60,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'国家医保局','http://www.nhsa.gov.cn','','国家医保局','',8,8,8,7,75,340,0,0,0,0,70,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'民政部','https://www.mca.gov.cn','','民政部官网','',7,7,7,6,90,300,0,0,0,0,80,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'12315平台','https://www.12315.cn','','消费者投诉举报','',8,8,8,7,80,330,0,0,0,0,90,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'12345政务服务','https://www.12345.gov.cn','','政务服务热线','',8,8,8,7,85,320,0,0,0,0,100,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'信用中国','https://www.creditchina.gov.cn','','信用信息查询','',8,8,8,7,88,310,0,0,0,0,110,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'国家知识产权局','https://www.cnipa.gov.cn','','知识产权服务','',7,7,7,6,95,290,0,0,0,0,120,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'中国气象局','https://www.cma.gov.cn','','天气预报','',7,7,7,6,100,280,0,0,0,0,130,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'国家统计局','http://www.stats.gov.cn','','统计数据','',7,7,7,6,105,270,0,0,0,0,140,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'中国裁判文书网','https://wenshu.court.gov.cn','','法院文书查询','',8,8,8,7,92,300,0,0,0,0,150,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'国家企业信用信息','https://www.gsxt.gov.cn','','企业信用查询','',8,8,8,7,86,315,0,0,0,0,160,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'中国领事服务网','http://cs.mfa.gov.cn','','领事服务','',7,7,7,6,110,260,0,0,0,0,170,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'全国公积金查询','http://www.gjj.mohrss.gov.cn','','公积金服务','',7,7,7,6,115,250,0,0,0,0,180,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'中国法律服务网','http://12348.gov.cn','','公共法律服务','',7,7,7,6,120,240,0,0,0,0,190,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()),
(12,'国家移民管理局','https://www.nia.gov.cn','','出入境服务','',7,7,7,6,118,245,0,0,0,0,200,1,UNIX_TIMESTAMP(),UNIX_TIMESTAMP());

3、近30天随机人气（phpmyadmin数据库管理、sql命令复制粘贴执行）

INSERT INTO zsens_navigation_site_daily (site_id, day, clicks, create_time, update_time)
SELECT s.id, d.day, FLOOR(20 + s.weight_baidu*30 + s.weight_google*20 + s.is_featured*150 + s.is_tool*80 + RAND()*120), UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM zsens_navigation_site s
CROSS JOIN (
    SELECT CURDATE() AS day
    UNION ALL SELECT CURDATE() - INTERVAL 1 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 2 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 3 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 4 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 5 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 6 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 7 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 8 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 9 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 10 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 11 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 12 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 13 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 14 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 15 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 16 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 17 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 18 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 19 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 20 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 21 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 22 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 23 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 24 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 25 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 26 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 27 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 28 DAY
    UNION ALL SELECT CURDATE() - INTERVAL 29 DAY
) d
WHERE s.status = 1;

六、测试上线

复制前台访问链接，PC、手机分别访问，检查页面布局、站点展示、分类跳转是否正常。
测试游客提交收录、举报反馈，确认后台可以收到审核数据。
点击导航站点，确认点击统计正常记录。
伪静态模式下，检查页面 URL、SEO 标签是否生效。

七、常见注意事项

卸载插件：后台插件管理直接卸载，独立数据表随插件卸载处理，不影响主系统。
图标不显示：检查图标 URL 地址可公网访问，开启图标回退文字占位兜底。
伪静态 404：核对服务器伪静态规则，需要和插件后台配置规则保持一致。
采集功能无数据：确认服务器可以访问对应第三方接口地址。

七、插件完整功能清单回顾

✅独立数据表，不污染主系统业务
✅分类管理：排序、显隐、常用工具标记
✅站点管理：名称、URL、图标、简介、权重、分类归属
✅多独立前台全套页面
✅访问点击统计，日周月榜单，SVG 趋势图表
✅站点 / 分类 / 单页独立 SEO，自定义伪静态
✅游客站点收录申请、违规举报 + 后台审核
✅卡片自适应 UI，图标兜底，自动卡片配色
✅支持百度热榜、权重采集；社区、友链插件联动
✅安装路径：后台应用中心→应用插件安装