SHOW FULL COLUMNS FROM `bbs_site_config` [ RunTime:0.001200s ]
SELECT `value`,`name` FROM `bbs_site_config` WHERE `name` IN ('cache_driver','cache_expire','cache_redis_host','cache_redis_port','cache_redis_password','cache_redis_select','cache_request_enable','cache_request_expire') [ RunTime:0.000435s ]
SELECT COUNT(*) AS c FROM information_schema.TABLES WHERE TABLE_SCHEMA = '5gqqw_cn' AND TABLE_NAME = 'plugin' [ RunTime:0.000570s ]
SHOW FULL COLUMNS FROM `bbs_plugin` [ RunTime:0.000558s ]
SELECT `version`,`name` FROM `bbs_plugin` WHERE `status` = 1 [ RunTime:0.000291s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'community' LIMIT 1 [ RunTime:0.000317s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'dataconvert' AND `status` = 1 LIMIT 1 [ RunTime:0.000328s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'dataconvert' LIMIT 1 [ RunTime:0.000196s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'adminavatar' AND `status` = 1 LIMIT 1 [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `bbs_auth_rule` [ RunTime:0.000921s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `name` = '' LIMIT 1 [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `bbs_menu` [ RunTime:0.000480s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000349s ]
DELETE FROM `bbs_menu` WHERE `title` = '广告运营' AND `pid` = 0 AND `type` = 1 [ RunTime:0.000205s ]
DELETE FROM `bbs_auth_rule` WHERE `title` = '广告运营' AND `pid` = 0 AND `name` = '' [ RunTime:0.000172s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/adminavatar' LIMIT 1 [ RunTime:0.000190s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `name` = 'admin/adminavatar' LIMIT 1 [ RunTime:0.000230s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/adminavatar/upload' LIMIT 1 [ RunTime:0.000226s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/adminavatar/save' LIMIT 1 [ RunTime:0.000298s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'adminavatar' LIMIT 1 [ RunTime:0.000280s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'community' AND `status` = 1 LIMIT 1 [ RunTime:0.000397s ]
SELECT `name` FROM `bbs_plugin` WHERE `status` = 1 [ RunTime:0.000235s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'mail' AND `status` = 1 LIMIT 1 [ RunTime:0.000761s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'mail' LIMIT 1 [ RunTime:0.000231s ]
SHOW FULL COLUMNS FROM `bbs_community_topic` [ RunTime:0.001078s ]
SELECT `id`,`title`,`reply_count`,`view_count` FROM `bbs_community_topic` WHERE `status` = 1 ORDER BY `view_count` DESC,`id` DESC LIMIT 5 [ RunTime:0.001133s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'paidread' AND `status` = 1 LIMIT 1 [ RunTime:0.000471s ]
SHOW TABLES LIKE 'bbs_community_topic' [ RunTime:0.000395s ]
SHOW COLUMNS FROM `bbs_community_topic` LIKE 'read_mode' [ RunTime:0.000469s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'paidread' LIMIT 1 [ RunTime:0.000243s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'message' AND `status` = 1 LIMIT 1 [ RunTime:0.000302s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'message' LIMIT 1 [ RunTime:0.000207s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'audio' AND `status` = 1 LIMIT 1 [ RunTime:0.000231s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'audio' LIMIT 1 [ RunTime:0.000250s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'netdisk' AND `status` = 1 LIMIT 1 [ RunTime:0.000224s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'netdisk' LIMIT 1 [ RunTime:0.000174s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'badge' AND `status` = 1 LIMIT 1 [ RunTime:0.000189s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'badge' LIMIT 1 [ RunTime:0.000163s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'signin' AND `status` = 1 LIMIT 1 [ RunTime:0.000173s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'signin' LIMIT 1 [ RunTime:0.000157s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'lottery' AND `status` = 1 LIMIT 1 [ RunTime:0.000167s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'lottery' LIMIT 1 [ RunTime:0.000157s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'ads' AND `status` = 1 LIMIT 1 [ RunTime:0.000184s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'ads' LIMIT 1 [ RunTime:0.000200s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'aiassistant' AND `status` = 1 LIMIT 1 [ RunTime:0.000231s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'aiassistant' LIMIT 1 [ RunTime:0.000286s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'captcha' AND `status` = 1 LIMIT 1 [ RunTime:0.000370s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'captcha' LIMIT 1 [ RunTime:0.000214s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'gamehall' AND `status` = 1 LIMIT 1 [ RunTime:0.000172s ]
SHOW FULL COLUMNS FROM `bbs_gamehall_entry` [ RunTime:0.000594s ]
SELECT * FROM `bbs_gamehall_entry` WHERE `status` = 1 ORDER BY `sort`,`id` LIMIT 30 [ RunTime:0.000439s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'payment' AND `status` = 1 LIMIT 1 [ RunTime:0.000201s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'payment' LIMIT 1 [ RunTime:0.000199s ]
SHOW TABLES LIKE 'bbs_payment_order' [ RunTime:0.000332s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'ranklist' AND `status` = 1 LIMIT 1 [ RunTime:0.000375s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'ranklist' LIMIT 1 [ RunTime:0.000250s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'xiuxian' AND `status` = 1 LIMIT 1 [ RunTime:0.000302s ]
SHOW TABLES LIKE 'bbs_xiuxian_log' [ RunTime:0.000319s ]
SHOW TABLES LIKE 'bbs_xiuxian_member' [ RunTime:0.000246s ]
SHOW COLUMNS FROM `bbs_xiuxian_member` [ RunTime:0.000672s ]
SHOW TABLES LIKE 'bbs_xiuxian_gongfa' [ RunTime:0.000343s ]
SHOW TABLES LIKE 'bbs_xiuxian_dungeon' [ RunTime:0.000485s ]
SHOW TABLES LIKE 'bbs_xiuxian_gongfa_member' [ RunTime:0.000257s ]
SHOW COLUMNS FROM `bbs_xiuxian_gongfa_member` [ RunTime:0.000482s ]
SHOW COLUMNS FROM `bbs_xiuxian_gongfa` [ RunTime:0.000510s ]
SHOW COLUMNS FROM `bbs_xiuxian_gongfa_member` [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `bbs_xiuxian_gongfa` [ RunTime:0.000272s ]
SELECT name, MIN(id) AS keep_id FROM `bbs_xiuxian_gongfa` GROUP BY `name` HAVING COUNT(*) > 1 [ RunTime:0.000289s ]
SHOW FULL COLUMNS FROM `bbs_xiuxian_dungeon` [ RunTime:0.000717s ]
SELECT name, MIN(id) AS keep_id FROM `bbs_xiuxian_dungeon` GROUP BY `name` HAVING COUNT(*) > 1 [ RunTime:0.000251s ]
SHOW TABLES LIKE 'bbs_xiuxian_dungeon_progress' [ RunTime:0.000364s ]
SHOW TABLES LIKE 'bbs_xiuxian_dungeon_log' [ RunTime:0.000289s ]
SHOW TABLES LIKE 'bbs_xiuxian_bag' [ RunTime:0.000247s ]
SHOW TABLES LIKE 'bbs_xiuxian_artifact' [ RunTime:0.000254s ]
SHOW TABLES LIKE 'bbs_xiuxian_artifact_member' [ RunTime:0.000255s ]
SHOW TABLES LIKE 'bbs_xiuxian_realm' [ RunTime:0.000341s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_cave` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned NOT NULL DEFAULT 0 COMMENT '用户UID',
`level` tinyint unsigned NOT NULL DEFAULT 1 COMMENT '洞府等级(重)',
`last_claim` int unsigned NOT NULL DEFAULT 0 COMMENT '上次结算时间戳',
`stone_pool` int unsigned NOT NULL DEFAULT 0 COMMENT '待领灵石',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫洞府挂机' [ RunTime:0.000375s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_sect` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '宗门名',
`desc` varchar(255) NOT NULL DEFAULT '' COMMENT '宗门简介',
`icon` varchar(50) NOT NULL DEFAULT 'mdi-domain' COMMENT '图标标识',
`realm_need` int unsigned NOT NULL DEFAULT 0 COMMENT '加入境界要求',
`max_member` int unsigned NOT NULL DEFAULT 50 COMMENT '人数上限',
`level` int unsigned NOT NULL DEFAULT 1 COMMENT '宗门等级',
`exp` int unsigned NOT NULL DEFAULT 0 COMMENT '宗门经验',
`bonus_type` varchar(20) NOT NULL DEFAULT 'practice_mult' COMMENT '加成类型practice_mult打坐修为/atk_pct攻击',
`bonus_val` int unsigned NOT NULL DEFAULT 1 COMMENT '每级加成数值(%)',
`status` tinyint unsigned NOT NULL DEFAULT 1 COMMENT '状态0停用1启用',
`sort` int unsigned NOT NULL DEFAULT 0 COMMENT '排序',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫宗门定义' [ RunTime:0.000234s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_sect_member` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned NOT NULL DEFAULT 0 COMMENT '用户UID',
`sect_id` int unsigned NOT NULL DEFAULT 0 COMMENT '宗门ID',
`position` tinyint unsigned NOT NULL DEFAULT 3 COMMENT '职位1宗主2长老3弟子',
`contrib` int unsigned NOT NULL DEFAULT 0 COMMENT '累计贡献',
`donate_date` varchar(8) NOT NULL DEFAULT '' COMMENT '最近捐献日Ymd',
`donate_count` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '今日捐献次数',
`bless_date` varchar(8) NOT NULL DEFAULT '' COMMENT '最近宗门修炼日Ymd',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_user` (`user_id`),
KEY `idx_sect` (`sect_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫宗门成员' [ RunTime:0.000267s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_daily_task` (
`user_id` int unsigned NOT NULL DEFAULT 0 COMMENT '用户UID',
`date` varchar(8) NOT NULL DEFAULT '' COMMENT '记录日期Ymd',
`sign` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '今日已签到(0否1是)',
`claimed` varchar(500) NOT NULL DEFAULT '' COMMENT '已领任务id串(逗号分隔)',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`user_id`),
UNIQUE KEY `uk_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫每日任务签到' [ RunTime:0.000277s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_dan_recipe` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '丹方名',
`icon` varchar(30) NOT NULL DEFAULT 'mdi-flask' COMMENT '图标标识',
`quality` varchar(10) NOT NULL DEFAULT '凡品' COMMENT '品质凡品/上品/极品/传说',
`herbs_json` varchar(1000) NOT NULL DEFAULT '' COMMENT '材料JSON[{"name":"灵草","count":2}]',
`stone_cost` int unsigned NOT NULL DEFAULT 0 COMMENT '灵石消耗',
`success_rate` tinyint unsigned NOT NULL DEFAULT 80 COMMENT '炼丹成功率%',
`effect_type` varchar(10) NOT NULL DEFAULT 'exp' COMMENT '效果类型exp修为/heal疗伤/dan渡劫丹',
`effect_val` int unsigned NOT NULL DEFAULT 0 COMMENT '效果值',
`desc` varchar(255) NOT NULL DEFAULT '' COMMENT '丹方说明',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态1启用0停用',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫炼丹丹方' [ RunTime:0.000194s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_alchemy_member` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned NOT NULL DEFAULT 0 COMMENT '用户UID',
`count` int unsigned NOT NULL DEFAULT 0 COMMENT '累计炼丹次数',
`rare_count` int unsigned NOT NULL DEFAULT 0 COMMENT '炼出传说丹药次数',
`gather_count` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '今日已采药次数',
`last_date` varchar(8) NOT NULL DEFAULT '' COMMENT '记录日期Ymd(采药跨天重置)',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫玩家炼丹记录' [ RunTime:0.000172s ]
INSERT INTO `bbs_xiuxian_dan_recipe` (`name`,`icon`,`quality`,`herbs_json`,`stone_cost`,`success_rate`,`effect_type`,`effect_val`,`desc`,`status`,`sort`,`create_time`)
SELECT '聚气丹','mdi-flask-rounded','凡品','[{"name":"灵草","count":2}]',5,90,'exp',150,'聚气养神，服用后修为 +150',1,1,UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `bbs_xiuxian_dan_recipe` WHERE `name`='聚气丹') [ RunTime:0.000345s ]
INSERT INTO `bbs_xiuxian_dan_recipe` (`name`,`icon`,`quality`,`herbs_json`,`stone_cost`,`success_rate`,`effect_type`,`effect_val`,`desc`,`status`,`sort`,`create_time`)
SELECT '清瘀丹','mdi-leaf','凡品','[{"name":"灵草","count":2}]',5,85,'heal',0,'清除渡劫失败伤势，可立即再渡劫',1,2,UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `bbs_xiuxian_dan_recipe` WHERE `name`='清瘀丹') [ RunTime:0.000206s ]
INSERT INTO `bbs_xiuxian_dan_recipe` (`name`,`icon`,`quality`,`herbs_json`,`stone_cost`,`success_rate`,`effect_type`,`effect_val`,`desc`,`status`,`sort`,`create_time`)
SELECT '筑基丹','mdi-shield-plus','上品','[{"name":"灵草","count":4}]',15,70,'exp',500,'固本培元，服用后修为 +500',1,3,UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `bbs_xiuxian_dan_recipe` WHERE `name`='筑基丹') [ RunTime:0.000178s ]
INSERT INTO `bbs_xiuxian_dan_recipe` (`name`,`icon`,`quality`,`herbs_json`,`stone_cost`,`success_rate`,`effect_type`,`effect_val`,`desc`,`status`,`sort`,`create_time`)
SELECT '破厄丹','mdi-sword','极品','[{"name":"灵草","count":5}]',30,45,'dan',1,'破厄解难，服用后渡劫丹 +1',1,4,UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `bbs_xiuxian_dan_recipe` WHERE `name`='破厄丹') [ RunTime:0.000144s ]
INSERT INTO `bbs_xiuxian_dan_recipe` (`name`,`icon`,`quality`,`herbs_json`,`stone_cost`,`success_rate`,`effect_type`,`effect_val`,`desc`,`status`,`sort`,`create_time`)
SELECT '金丹丹','mdi-crystal-ball','极品','[{"name":"灵草","count":6}]',40,50,'exp',1500,'凝丹化婴，服用后修为 +1500',1,5,UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `bbs_xiuxian_dan_recipe` WHERE `name`='金丹丹') [ RunTime:0.000142s ]
INSERT INTO `bbs_xiuxian_dan_recipe` (`name`,`icon`,`quality`,`herbs_json`,`stone_cost`,`success_rate`,`effect_type`,`effect_val`,`desc`,`status`,`sort`,`create_time`)
SELECT '九转金丹','mdi-star-four-points','传说','[{"name":"灵草","count":10}]',100,25,'exp',5000,'九转丹成，服用后修为 +5000，炼出必上全站动态',1,6,UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `bbs_xiuxian_dan_recipe` WHERE `name`='九转金丹') [ RunTime:0.000151s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_dao_request` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`from_uid` int unsigned NOT NULL DEFAULT 0 COMMENT '发起人UID',
`to_uid` int unsigned NOT NULL DEFAULT 0 COMMENT '接收人UID',
`type` varchar(10) NOT NULL DEFAULT 'partner' COMMENT '关系partner道侣/master拜师/apprentice收徒',
`status` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '0待处理1同意2拒绝',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `idx_to` (`to_uid`,`status`),
KEY `idx_from` (`from_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫道侣师徒请求' [ RunTime:0.000241s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_dao` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned NOT NULL DEFAULT 0 COMMENT '用户UID',
`target_id` int unsigned NOT NULL DEFAULT 0 COMMENT '对方UID',
`type` varchar(10) NOT NULL DEFAULT 'partner' COMMENT 'partner道侣/master我师父是target/apprentice我徒弟是target',
`liandu_date` varchar(8) NOT NULL DEFAULT '' COMMENT '同修日期Ymd',
`status` tinyint unsigned NOT NULL DEFAULT 1 COMMENT '状态1有效',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_user_type` (`user_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫道侣师徒关系' [ RunTime:0.000187s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_linggen` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned NOT NULL DEFAULT 0 COMMENT '用户UID',
`recast_count` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '今日已重铸次数(跨天按recast_date重置)',
`recast_date` varchar(8) NOT NULL DEFAULT '' COMMENT '最近重铸日Ymd',
`awaken_level` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '灵根觉醒等级',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫灵根重铸觉醒进度' [ RunTime:0.000217s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_lingsi` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '灵脉名',
`icon` varchar(50) NOT NULL DEFAULT 'mdi-map-marker' COMMENT '图标',
`level` int unsigned NOT NULL DEFAULT 1 COMMENT '灵脉品阶',
`guard_hp` int unsigned NOT NULL DEFAULT 2000 COMMENT '守脉守卫血量',
`guard_atk` int unsigned NOT NULL DEFAULT 180 COMMENT '守脉守卫攻击',
`guard_skill_pct` tinyint unsigned NOT NULL DEFAULT 20 COMMENT '守卫绝技概率%',
`guard_skill_mult` tinyint unsigned NOT NULL DEFAULT 150 COMMENT '守卫绝技伤害倍率%',
`stone_per_hour` int unsigned NOT NULL DEFAULT 10 COMMENT '每小时产出灵石',
`hold_bonus_type` varchar(30) NOT NULL DEFAULT '' COMMENT '占领加成类型(预留展示)',
`hold_bonus_val` int unsigned NOT NULL DEFAULT 0 COMMENT '占领加成数值(预留展示)',
`status` tinyint unsigned NOT NULL DEFAULT 1 COMMENT '状态(1启用0停用)',
`sort` int unsigned NOT NULL DEFAULT 0 COMMENT '排序',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫灵脉定义' [ RunTime:0.000388s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_lingsi_member` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned NOT NULL DEFAULT 0 COMMENT '占领者UID',
`lingsi_id` int unsigned NOT NULL DEFAULT 0 COMMENT '灵脉ID',
`hold_from` int unsigned NOT NULL DEFAULT 0 COMMENT '占领起始时间戳',
`last_claim` int unsigned NOT NULL DEFAULT 0 COMMENT '上次结算时间戳',
`stone_pool` int unsigned NOT NULL DEFAULT 0 COMMENT '待领灵石池',
`attacked` int unsigned NOT NULL DEFAULT 0 COMMENT '被攻占次数',
`last_date` varchar(8) NOT NULL DEFAULT '' COMMENT '最近日期Ymd',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_user_lingsi` (`user_id`,`lingsi_id`),
KEY `idx_lingsi` (`lingsi_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫灵脉占领记录' [ RunTime:0.000314s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_pet` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '灵宠名',
`icon` varchar(30) NOT NULL DEFAULT 'mdi-paw' COMMENT '图标标识(mdi-*)',
`type` varchar(20) NOT NULL DEFAULT 'atk_pct' COMMENT '加成类型atk_pct攻击/dmg_reduce减伤',
`bonus_val` int NOT NULL DEFAULT 0 COMMENT '每级加成数值(百分比)',
`evolve_to_id` int unsigned NOT NULL DEFAULT 0 COMMENT '进化目标形态ID(0=最高形态)',
`evolve_need` int unsigned NOT NULL DEFAULT 10 COMMENT '进化所需等级',
`feed_cost` int unsigned NOT NULL DEFAULT 10 COMMENT '每次喂养消耗灵石',
`max_level` tinyint unsigned NOT NULL DEFAULT 20 COMMENT '最高等级',
`desc` varchar(255) NOT NULL DEFAULT '' COMMENT '灵宠描述',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态1启用0停用',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫灵宠定义' [ RunTime:0.000278s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_pet_member` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned NOT NULL DEFAULT 0 COMMENT '用户UID',
`pet_id` int unsigned NOT NULL DEFAULT 0 COMMENT '灵宠定义ID',
`level` tinyint unsigned NOT NULL DEFAULT 1 COMMENT '灵宠等级',
`exp` int unsigned NOT NULL DEFAULT 0 COMMENT '当前经验',
`equipped` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '佩戴标记(0否1是,仅1只生效)',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '获得时间',
`update_time` int unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_user_pet` (`user_id`,`pet_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫玩家灵宠' [ RunTime:0.000236s ]
INSERT INTO `bbs_xiuxian_pet` (`name`,`icon`,`type`,`bonus_val`,`evolve_to_id`,`evolve_need`,`feed_cost`,`max_level`,`desc`,`status`,`sort`,`create_time`)
SELECT '小火凤','mdi-fire','atk_pct',2,0,10,10,15,'初生火凤，灵性初开，攻击每级+2%',1,1,UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `bbs_xiuxian_pet` WHERE `name`='小火凤') [ RunTime:0.000216s ]
INSERT INTO `bbs_xiuxian_pet` (`name`,`icon`,`type`,`bonus_val`,`evolve_to_id`,`evolve_need`,`feed_cost`,`max_level`,`desc`,`status`,`sort`,`create_time`)
SELECT '烈焰凤','mdi-firework','atk_pct',4,0,20,20,25,'烈焰锻骨，威力大增，攻击每级+4%',1,2,UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `bbs_xiuxian_pet` WHERE `name`='烈焰凤') [ RunTime:0.000144s ]
INSERT INTO `bbs_xiuxian_pet` (`name`,`icon`,`type`,`bonus_val`,`evolve_to_id`,`evolve_need`,`feed_cost`,`max_level`,`desc`,`status`,`sort`,`create_time`)
SELECT '涅槃神凤','mdi-weather-sunset','atk_pct',7,0,0,30,40,'涅槃不灭，焚天煮海，攻击每级+7%（最高形态）',1,3,UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `bbs_xiuxian_pet` WHERE `name`='涅槃神凤') [ RunTime:0.000130s ]
INSERT INTO `bbs_xiuxian_pet` (`name`,`icon`,`type`,`bonus_val`,`evolve_to_id`,`evolve_need`,`feed_cost`,`max_level`,`desc`,`status`,`sort`,`create_time`)
SELECT '玄灵龟','mdi-shield','dmg_reduce',1,0,10,10,15,'玄龟灵体，稳固防守，受伤减免每级+1%',1,4,UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `bbs_xiuxian_pet` WHERE `name`='玄灵龟') [ RunTime:0.000140s ]
INSERT INTO `bbs_xiuxian_pet` (`name`,`icon`,`type`,`bonus_val`,`evolve_to_id`,`evolve_need`,`feed_cost`,`max_level`,`desc`,`status`,`sort`,`create_time`)
SELECT '玄武神龟','mdi-shield-half-full','dmg_reduce',3,0,0,20,30,'玄武镇岳，万法不侵，受伤减免每级+3%（最高形态）',1,5,UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `bbs_xiuxian_pet` WHERE `name`='玄武神龟') [ RunTime:0.000136s ]
UPDATE `bbs_xiuxian_pet` SET `evolve_to_id`=(SELECT `id` FROM (SELECT `id` FROM `bbs_xiuxian_pet` WHERE `name`='烈焰凤' LIMIT 1) `t`) WHERE `name`='小火凤' [ RunTime:0.000588s ]
UPDATE `bbs_xiuxian_pet` SET `evolve_to_id`=(SELECT `id` FROM (SELECT `id` FROM `bbs_xiuxian_pet` WHERE `name`='涅槃神凤' LIMIT 1) `t`) WHERE `name`='烈焰凤' [ RunTime:0.000486s ]
UPDATE `bbs_xiuxian_pet` SET `evolve_to_id`=(SELECT `id` FROM (SELECT `id` FROM `bbs_xiuxian_pet` WHERE `name`='玄武神龟' LIMIT 1) `t`) WHERE `name`='玄灵龟' [ RunTime:0.000363s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_tower_floor` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`floor` int unsigned NOT NULL DEFAULT 1 COMMENT '层数',
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '层名',
`boss_name` varchar(50) NOT NULL DEFAULT '' COMMENT '守层BOSS名',
`boss_hp` int unsigned NOT NULL DEFAULT 1000 COMMENT '守层BOSS血量',
`boss_atk` int unsigned NOT NULL DEFAULT 100 COMMENT '守层BOSS攻击',
`boss_skill_pct` tinyint unsigned NOT NULL DEFAULT 20 COMMENT 'BOSS绝技概率%',
`boss_skill_mult` tinyint unsigned NOT NULL DEFAULT 150 COMMENT 'BOSS绝技伤害倍率%',
`exp_reward` int unsigned NOT NULL DEFAULT 100 COMMENT '通关修为奖励',
`stone_reward` int unsigned NOT NULL DEFAULT 10 COMMENT '通关灵石奖励',
`gold_reward` int unsigned NOT NULL DEFAULT 20 COMMENT '通关金币奖励',
`realm_need` int unsigned NOT NULL DEFAULT 0 COMMENT '进入该层所需境界',
`status` tinyint unsigned NOT NULL DEFAULT 1 COMMENT '状态(1启用0停用)',
`sort` int unsigned NOT NULL DEFAULT 0 COMMENT '排序',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_floor` (`floor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫试炼塔层定义' [ RunTime:0.000294s ]
CREATE TABLE IF NOT EXISTS `bbs_xiuxian_tower_progress` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned NOT NULL DEFAULT 0 COMMENT '用户UID',
`max_floor` int unsigned NOT NULL DEFAULT 0 COMMENT '最高通关层',
`best_time` int unsigned NOT NULL DEFAULT 0 COMMENT '登顶时间戳',
`fight_date` varchar(8) NOT NULL DEFAULT '' COMMENT '今日挑战日期Ymd',
`fight_count` int unsigned NOT NULL DEFAULT 0 COMMENT '今日已挑战次数',
`create_time` int unsigned NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int unsigned NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='修仙渡劫试炼塔玩家进度' [ RunTime:0.000340s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'xiuxian' LIMIT 1 [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `bbs_xiuxian_realm` [ RunTime:0.000527s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 0 LIMIT 1 [ RunTime:0.000225s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 0 LIMIT 1 [ RunTime:0.000158s ]
SHOW FULL COLUMNS FROM `bbs_xiuxian_member` [ RunTime:0.000467s ]
SELECT `user_id`,`nickname`,`today_exp`,`realm` FROM `bbs_xiuxian_member` WHERE `today_date` = '20261003' AND `today_exp` > 0 ORDER BY `today_exp` DESC LIMIT 10 [ RunTime:0.000346s ]
SELECT `user_id`,`nickname`,`exp_total`,`realm` FROM `bbs_xiuxian_member` WHERE `exp_total` > 0 ORDER BY `realm` DESC,`exp_total` DESC LIMIT 10 [ RunTime:0.000328s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 3 LIMIT 1 [ RunTime:0.000188s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 0 LIMIT 1 [ RunTime:0.000172s ]
SHOW FULL COLUMNS FROM `bbs_xiuxian_log` [ RunTime:0.000446s ]
SELECT * FROM `bbs_xiuxian_log` WHERE `action` IN ('break_success','fly','dungeon','duel','compose','gongfa','seal') AND `user_id` > 0 ORDER BY `id` DESC LIMIT 24 [ RunTime:0.000342s ]
SHOW FULL COLUMNS FROM `bbs_user` [ RunTime:0.000662s ]
SELECT `id`,`nickname`,`username` FROM `bbs_user` WHERE `id` IN (1,6) [ RunTime:0.000218s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 3 LIMIT 1 [ RunTime:0.000199s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 3 LIMIT 1 [ RunTime:0.000567s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 3 LIMIT 1 [ RunTime:0.000189s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 3 LIMIT 1 [ RunTime:0.000156s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 0 LIMIT 1 [ RunTime:0.000221s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 3 LIMIT 1 [ RunTime:0.000156s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 2 LIMIT 1 [ RunTime:0.000256s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 2 LIMIT 1 [ RunTime:0.000223s ]
SHOW FULL COLUMNS FROM `bbs_xiuxian_dungeon_progress` [ RunTime:0.000596s ]
SELECT * FROM `bbs_xiuxian_dungeon_progress` ORDER BY `max_floor` DESC,`wins` DESC LIMIT 10 [ RunTime:0.000246s ]
SELECT `nickname` FROM `bbs_xiuxian_member` WHERE `user_id` = 1 LIMIT 1 [ RunTime:0.000167s ]
SELECT `nickname` FROM `bbs_xiuxian_member` WHERE `user_id` = 6 LIMIT 1 [ RunTime:0.000128s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'attachment' AND `status` = 1 LIMIT 1 [ RunTime:0.000517s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'attachment' LIMIT 1 [ RunTime:0.000201s ]
SHOW TABLES LIKE 'bbs_topic_attachment' [ RunTime:0.000361s ]
SHOW COLUMNS FROM `bbs_topic_attachment` LIKE 'price' [ RunTime:0.000540s ]
SHOW COLUMNS FROM `bbs_topic_attachment` LIKE 'currency' [ RunTime:0.000269s ]
SHOW COLUMNS FROM `bbs_topic_attachment` LIKE 'download_count' [ RunTime:0.000257s ]
SHOW COLUMNS FROM `bbs_topic_attachment` LIKE 'vip_only' [ RunTime:0.000300s ]
SHOW COLUMNS FROM `bbs_topic_attachment` LIKE 'storage' [ RunTime:0.000369s ]
SHOW TABLES LIKE 'bbs_topic_attachment_unlock' [ RunTime:0.000326s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'editor' LIMIT 1 [ RunTime:0.000263s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'friends' AND `status` = 1 LIMIT 1 [ RunTime:0.000232s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'friends' LIMIT 1 [ RunTime:0.000393s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'hide' AND `status` = 1 LIMIT 1 [ RunTime:0.000192s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'hide' LIMIT 1 [ RunTime:0.000179s ]
SHOW TABLES LIKE 'bbs_hide_block' [ RunTime:0.000310s ]
SHOW COLUMNS FROM `bbs_hide_block` LIKE 'currency' [ RunTime:0.000503s ]
SHOW TABLES LIKE 'bbs_hide_unlock' [ RunTime:0.000291s ]
SHOW COLUMNS FROM `bbs_hide_unlock` LIKE 'guest_token' [ RunTime:0.000576s ]
ALTER TABLE `bbs_hide_unlock` DROP INDEX `uk_block_actor` [ RunTime:0.003083s ]
DELETE FROM `bbs_auth_rule` WHERE `name` IN ('admin/netdisk_provider','admin/netdisk_provider/list','admin/netdisk_provider/save','admin/netdisk_provider/delete','admin/netdisk_provider/status','admin/netdisk_provider/parse') [ RunTime:0.000322s ]
DELETE FROM `bbs_menu` WHERE `name` IN ('admin/netdisk_provider','admin/netdisk_provider/list','admin/netdisk_provider/save','admin/netdisk_provider/delete','admin/netdisk_provider/status','admin/netdisk_provider/parse') [ RunTime:0.000187s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000285s ]
SELECT COUNT(*) AS think_count FROM `bbs_menu` WHERE `delete_time` = 0 AND `pid` = 54 [ RunTime:0.000209s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'redpacket' AND `status` = 1 LIMIT 1 [ RunTime:0.000301s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'redpacket' LIMIT 1 [ RunTime:0.000173s ]
SHOW TABLES LIKE 'bbs_redpacket' [ RunTime:0.000954s ]
SHOW COLUMNS FROM `bbs_redpacket` LIKE 'claim_type' [ RunTime:0.000875s ]
SHOW COLUMNS FROM `bbs_redpacket` LIKE 'claim_level_id' [ RunTime:0.000327s ]
SHOW COLUMNS FROM `bbs_redpacket` LIKE 'expire_time' [ RunTime:0.000400s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'verify' AND `status` = 1 LIMIT 1 [ RunTime:0.000323s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'verify' LIMIT 1 [ RunTime:0.000242s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'vip' AND `status` = 1 LIMIT 1 [ RunTime:0.000218s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'vip' LIMIT 1 [ RunTime:0.000181s ]
SHOW TABLES LIKE 'bbs_vip_member' [ RunTime:0.000317s ]
DELETE FROM `bbs_auth_rule` WHERE `name` IN ('admin/vip_member','admin/vip_order') [ RunTime:0.000305s ]
DELETE FROM `bbs_menu` WHERE `name` IN ('admin/vip_member','admin/vip_order') [ RunTime:0.000208s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000257s ]
SELECT COUNT(*) AS think_count FROM `bbs_menu` WHERE `delete_time` = 0 AND `pid` = 54 [ RunTime:0.000219s ]
DELETE FROM `bbs_auth_rule` WHERE `name` IN ('admin/vip_settings/labels','admin/vip_settings/saveLabels','admin/vip_settings/authors','admin/vip_settings/saveAuthors','admin/vip_settings/categories','admin/vip_settings/saveCategories') [ RunTime:0.000283s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `name` = '' LIMIT 1 [ RunTime:0.000288s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000217s ]
DELETE FROM `bbs_menu` WHERE `title` = '广告运营' AND `pid` = 0 AND `type` = 1 [ RunTime:0.000164s ]
DELETE FROM `bbs_auth_rule` WHERE `title` = '广告运营' AND `pid` = 0 AND `name` = '' [ RunTime:0.000279s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/vip' LIMIT 1 [ RunTime:0.000277s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `name` = 'admin/vip' LIMIT 1 [ RunTime:0.000333s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/list' LIMIT 1 [ RunTime:0.000253s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/upload' LIMIT 1 [ RunTime:0.000202s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/link' LIMIT 1 [ RunTime:0.000185s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/save' LIMIT 1 [ RunTime:0.000227s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/delete' LIMIT 1 [ RunTime:0.000224s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/clear' LIMIT 1 [ RunTime:0.000211s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/status' LIMIT 1 [ RunTime:0.000186s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'oauth' AND `status` = 1 LIMIT 1 [ RunTime:0.000429s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'oauth' LIMIT 1 [ RunTime:0.000252s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'popup' AND `status` = 1 LIMIT 1 [ RunTime:0.000405s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'popup' LIMIT 1 [ RunTime:0.000837s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'quickreply' AND `status` = 1 LIMIT 1 [ RunTime:0.000279s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'quickreply' LIMIT 1 [ RunTime:0.000189s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'extlink' AND `status` = 1 LIMIT 1 [ RunTime:0.000229s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'extlink' LIMIT 1 [ RunTime:0.000177s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'avatarframe' AND `status` = 1 LIMIT 1 [ RunTime:0.000248s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'avatarframe' LIMIT 1 [ RunTime:0.000197s ]
SHOW TABLES LIKE 'bbs_avatarframe' [ RunTime:0.000404s ]
SHOW COLUMNS FROM `bbs_avatarframe` [ RunTime:0.000572s ]
SHOW TABLES LIKE 'bbs_avatarframe_tag' [ RunTime:0.000323s ]
SHOW COLUMNS FROM `bbs_avatarframe_user` [ RunTime:0.000332s ]
UPDATE `bbs_avatarframe_user` SET `actor_type`='user', `actor_id`=`user_id` WHERE `user_id`>0 AND (`actor_id`=0 OR `actor_type`='' OR `actor_type`='user' AND `actor_id`<> `user_id`) [ RunTime:0.000562s ]
SHOW INDEX FROM `bbs_avatarframe_user` WHERE Key_name='idx_actor_wear' [ RunTime:0.000331s ]
SHOW TABLES LIKE 'bbs_payment_order' [ RunTime:0.000312s ]
SHOW TABLES LIKE 'bbs_payment_order' [ RunTime:0.000312s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'taskcenter' AND `status` = 1 LIMIT 1 [ RunTime:0.000296s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'taskcenter' LIMIT 1 [ RunTime:0.000230s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'userban' AND `status` = 1 LIMIT 1 [ RunTime:0.000273s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'userban' LIMIT 1 [ RunTime:0.000183s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'stat' AND `status` = 1 LIMIT 1 [ RunTime:0.000347s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'stat' LIMIT 1 [ RunTime:0.000425s ]
SELECT COUNT(*) AS c FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = '5gqqw_cn' AND TABLE_NAME = 'bbs_stat_visit_log' AND COLUMN_NAME = 'user_id' [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `bbs_stat_visit` [ RunTime:0.000477s ]
SELECT * FROM `bbs_stat_visit` WHERE `day` = '2026-10-03' LIMIT 1 [ RunTime:0.000211s ]
UPDATE `bbs_stat_visit` SET `pv` = `pv` + 1 , `update_time` = 1790979772 WHERE `id` = 49 [ RunTime:0.001049s ]
SHOW FULL COLUMNS FROM `bbs_stat_visit_log` [ RunTime:0.000491s ]
SELECT * FROM `bbs_stat_visit_log` WHERE `day` = '2026-10-03' AND `visitor` = 'cca1f15d22b9a9d90bc2231ed29abd68' LIMIT 1 [ RunTime:0.000294s ]
