SELECT `v` FROM `nav_setting` WHERE `k` = 'db_version' [ RunTime:0.000407s ]
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.000318s ]
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.000272s ]
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.000289s ]
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.000229s ]
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.000213s ]
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.000189s ]
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.002398s ]
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.000229s ]
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.000284s ]
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.000217s ]
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.000238s ]
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.000201s ]
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.000245s ]
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.000208s ]
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.000300s ]
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.000223s ]
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.000215s ]
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.000215s ]
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.000210s ]
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.002907s ]
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.000215s ]
SELECT COUNT(*) AS `c` FROM `nav_devlog` [ RunTime:0.000268s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_on','1','1793120410') [ RunTime:0.000276s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_free_audit','0','1793120410') [ RunTime:0.000205s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('submit_price','0','1793120410') [ RunTime:0.000186s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_on','1','1793120410') [ RunTime:0.000183s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_price_month','0','1793120410') [ RunTime:0.000190s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_free_audit','0','1793120410') [ RunTime:0.000192s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_free_months','1','1793120410') [ RunTime:0.000184s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_slots','1','1793120410') [ RunTime:0.000202s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_max','3','1793120410') [ RunTime:0.000209s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_require_mark','1','1793120410') [ RunTime:0.000189s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_contact','','1793120410') [ RunTime:0.000202s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_banner_cols','1','1793120410') [ RunTime:0.000208s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_cols','4','1793120410') [ RunTime:0.000229s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('ad_fixed_price','0','1793120410') [ RunTime:0.000195s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_on','0','1793120410') [ RunTime:0.000201s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_note','','1793120410') [ RunTime:0.000197s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_on','1','1793120410') [ RunTime:0.000207s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_alipay','','1793120410') [ RunTime:0.000198s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_qr_wechat','','1793120410') [ RunTime:0.000204s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_alipay','0','1793120410') [ RunTime:0.000206s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_wxpay','0','1793120410') [ RunTime:0.000290s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_url','','1793120410') [ RunTime:0.000214s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_pid','','1793120410') [ RunTime:0.000195s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_epay_key','','1793120410') [ RunTime:0.003129s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_on','0','1793120410') [ RunTime:0.000195s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_appid','','1793120410') [ RunTime:0.000314s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_private_key','','1793120410') [ RunTime:0.000240s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_alipay_public_key','','1793120410') [ RunTime:0.000182s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_on','0','1793120410') [ RunTime:0.000174s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_mchid','','1793120410') [ RunTime:0.000280s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_appid','','1793120410') [ RunTime:0.000234s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_v3key','','1793120410') [ RunTime:0.000187s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_serial','','1793120410') [ RunTime:0.000183s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_private_key','','1793120410') [ RunTime:0.000285s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('pay_wechat_platform_cert','','1793120410') [ RunTime:0.000278s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_on','1','1793120410') [ RunTime:0.000204s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_price','0','1793120410') [ RunTime:0.000194s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_free_audit','0','1793120410') [ RunTime:0.000256s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('friend_contact','','1793120410') [ RunTime:0.000192s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_on','1','1793120410') [ RunTime:0.000180s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_amounts','5,10,20,50,100','1793120410') [ RunTime:0.000187s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_min','1','1793120410') [ RunTime:0.000211s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_max','9999','1793120410') [ RunTime:0.000194s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_rules','','1793120410') [ RunTime:0.000188s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_audit','0','1793120410') [ RunTime:0.000189s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_forever_on','0','1793120410') [ RunTime:0.000208s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_forever_price','10','1793120410') [ RunTime:0.000180s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_normal_price','0','1793120410') [ RunTime:0.000176s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_best_price','0','1793120410') [ RunTime:0.000185s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_any_include','0','1793120410') [ RunTime:0.000198s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('sponsor_top_min','0','1793120410') [ RunTime:0.000210s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('app_debug','0','1793120410') [ RunTime:0.000194s ]
INSERT IGNORE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('dock_on','1','1793120410') [ RunTime:0.002766s ]
SHOW COLUMNS FROM `nav_site` [ RunTime:0.003845s ]
SHOW COLUMNS FROM `nav_site` [ RunTime:0.001214s ]
SHOW COLUMNS FROM `nav_site` [ RunTime:0.004299s ]
SELECT `id`,`slug` FROM `nav_category` [ RunTime:0.000255s ]
SELECT COUNT(*) AS n FROM `nav_category_tag` [ RunTime:0.000216s ]
SELECT `id`,`category_id` FROM `nav_category_tag` ORDER BY `category_id` ASC, `sort` DESC, `id` ASC [ RunTime:0.000343s ]
UPDATE `nav_category_tag` SET `slug` = 'hot-1' WHERE `id` = '1' [ RunTime:0.001741s ]
UPDATE `nav_category_tag` SET `slug` = 'hot-2' WHERE `id` = '2' [ RunTime:0.001426s ]
UPDATE `nav_category_tag` SET `slug` = 'hot-3' WHERE `id` = '3' [ RunTime:0.001020s ]
UPDATE `nav_category_tag` SET `slug` = 'media-1' WHERE `id` = '4' [ RunTime:0.001055s ]
UPDATE `nav_category_tag` SET `slug` = 'media-2' WHERE `id` = '5' [ RunTime:0.003922s ]
UPDATE `nav_category_tag` SET `slug` = 'media-3' WHERE `id` = '6' [ RunTime:0.001255s ]
UPDATE `nav_category_tag` SET `slug` = 'ai-1' WHERE `id` = '7' [ RunTime:0.001236s ]
UPDATE `nav_category_tag` SET `slug` = 'ai-2' WHERE `id` = '8' [ RunTime:0.001178s ]
UPDATE `nav_category_tag` SET `slug` = 'ai-3' WHERE `id` = '9' [ RunTime:0.001131s ]
UPDATE `nav_category_tag` SET `slug` = 'game-1' WHERE `id` = '10' [ RunTime:0.001039s ]
UPDATE `nav_category_tag` SET `slug` = 'game-2' WHERE `id` = '11' [ RunTime:0.003040s ]
UPDATE `nav_category_tag` SET `slug` = 'game-3' WHERE `id` = '12' [ RunTime:0.001238s ]
UPDATE `nav_category_tag` SET `slug` = 'office-1' WHERE `id` = '13' [ RunTime:0.001792s ]
UPDATE `nav_category_tag` SET `slug` = 'office-2' WHERE `id` = '14' [ RunTime:0.000934s ]
UPDATE `nav_category_tag` SET `slug` = 'office-3' WHERE `id` = '15' [ RunTime:0.001070s ]
UPDATE `nav_category_tag` SET `slug` = 'life-1' WHERE `id` = '16' [ RunTime:0.001188s ]
UPDATE `nav_category_tag` SET `slug` = 'life-2' WHERE `id` = '17' [ RunTime:0.003591s ]
UPDATE `nav_category_tag` SET `slug` = 'life-3' WHERE `id` = '18' [ RunTime:0.003162s ]
UPDATE `nav_category_tag` SET `slug` = 'search-1' WHERE `id` = '19' [ RunTime:0.001815s ]
UPDATE `nav_category_tag` SET `slug` = 'search-2' WHERE `id` = '20' [ RunTime:0.001688s ]
UPDATE `nav_category_tag` SET `slug` = 'design-1' WHERE `id` = '22' [ RunTime:0.001677s ]
UPDATE `nav_category_tag` SET `slug` = 'design-2' WHERE `id` = '23' [ RunTime:0.008926s ]
UPDATE `nav_category_tag` SET `slug` = 'design-3' WHERE `id` = '24' [ RunTime:0.002162s ]
UPDATE `nav_category_tag` SET `slug` = 'fun-1' WHERE `id` = '25' [ RunTime:0.001616s ]
UPDATE `nav_category_tag` SET `slug` = 'fun-2' WHERE `id` = '26' [ RunTime:0.002248s ]
UPDATE `nav_category_tag` SET `slug` = 'fun-3' WHERE `id` = '27' [ RunTime:0.001441s ]
UPDATE `nav_category_tag` SET `slug` = 'resource-1' WHERE `id` = '28' [ RunTime:0.001864s ]
UPDATE `nav_category_tag` SET `slug` = 'resource-2' WHERE `id` = '29' [ RunTime:0.001706s ]
UPDATE `nav_category_tag` SET `slug` = 'resource-3' WHERE `id` = '30' [ RunTime:0.001244s ]
UPDATE `nav_category_tag` SET `slug` = 'study-1' WHERE `id` = '31' [ RunTime:0.002116s ]
UPDATE `nav_category_tag` SET `slug` = 'study-2' WHERE `id` = '32' [ RunTime:0.001936s ]
UPDATE `nav_category_tag` SET `slug` = 'study-3' WHERE `id` = '33' [ RunTime:0.007071s ]
SELECT COUNT(*) AS n FROM `nav_link` [ RunTime:0.000344s ]
SELECT COUNT(*) AS n FROM `nav_site` WHERE `slug` = 'bilibili-demo' [ RunTime:0.000721s ]
SHOW COLUMNS FROM `nav_site` [ RunTime:0.001135s ]
SELECT COUNT(*) AS n FROM `nav_like_log` [ RunTime:0.000193s ]
SELECT `id` FROM `nav_link` LIMIT 1 [ RunTime:0.000159s ]
SELECT `id` FROM `nav_submit` LIMIT 1 [ RunTime:0.000142s ]
SELECT `id` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000138s ]
SELECT `id` FROM `nav_ad` LIMIT 1 [ RunTime:0.000138s ]
SELECT `id` FROM `nav_ad_plan` LIMIT 1 [ RunTime:0.000168s ]
SELECT `id`,`order_no`,`pay_channel`,`pay_trade_no` FROM `nav_friend_link` LIMIT 1 [ RunTime:0.000186s ]
SELECT `id`,`type`,`tag_id` FROM `nav_dock` LIMIT 1 [ RunTime:0.000152s ]
SHOW COLUMNS FROM `nav_ad` [ RunTime:0.000902s ]
SELECT `gift_days`,`pay_channel`,`pay_trade_no` FROM `nav_ad` LIMIT 1 [ RunTime:0.000172s ]
SHOW COLUMNS FROM `nav_ad_plan` [ RunTime:0.000763s ]
SELECT `position` FROM `nav_ad_plan` LIMIT 1 [ RunTime:0.000156s ]
SHOW COLUMNS FROM `nav_ad` [ RunTime:0.000785s ]
SELECT `icon` FROM `nav_ad` LIMIT 1 [ RunTime:0.000160s ]
SHOW COLUMNS FROM `nav_qlink` [ RunTime:0.002987s ]
SELECT `subtitle` FROM `nav_qlink` LIMIT 1 [ RunTime:0.000164s ]
SHOW COLUMNS FROM `nav_site` [ RunTime:0.000881s ]
SELECT `hide_code`,`password` FROM `nav_site` LIMIT 1 [ RunTime:0.000166s ]
SELECT `slug` FROM `nav_plugin` LIMIT 1 [ RunTime:0.000159s ]
SHOW COLUMNS FROM `nav_plugin` [ RunTime:0.000713s ]
SELECT `type`,`url`,`icon_url`,`category`,`color`,`badge` FROM `nav_plugin` LIMIT 1 [ RunTime:0.000201s ]
SHOW FULL COLUMNS FROM `nav_plugin` [ RunTime:0.003596s ]
SELECT * FROM `nav_plugin` [ RunTime:0.000273s ]
UPDATE `nav_plugin` SET `category` = 'plugin' WHERE `type` = 'local' AND `category` = 'life' AND `update_time` = `create_time` [ RunTime:0.000252s ]
SHOW FULL COLUMNS FROM `nav_setting` [ RunTime:0.000773s ]
SELECT * FROM `nav_setting` [ RunTime:0.000253s ]
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.000279s ]
SHOW COLUMNS FROM `nav_sponsor` [ RunTime:0.000730s ]
SELECT `order_no`,`pay_time` FROM `nav_sponsor` LIMIT 1 [ RunTime:0.000175s ]
SHOW COLUMNS FROM `nav_sponsor_order` [ RunTime:0.000687s ]
SELECT `order_no`,`sponsor_id`,`amount`,`base_amount`,`forever`,`include_site` FROM `nav_sponsor_order` LIMIT 1 [ RunTime:0.000185s ]
DELETE FROM `nav_sponsor` WHERE `order_no` = '' AND `pay_time` = 0 AND `name` LIKE '星友%' [ RunTime:0.000190s ]
SELECT COUNT(*) AS `c` FROM `nav_sponsor` [ RunTime:0.000145s ]
REPLACE INTO `nav_setting` (`k`,`v`,`update_time`) VALUES ('db_version','29','1793120410') [ RunTime:0.001289s ]
SHOW FULL COLUMNS FROM `nav_category` [ RunTime:0.002827s ]
SELECT * FROM `nav_category` WHERE `slug` = 'game' AND `status` = 1 LIMIT 1 [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `nav_category_tag` [ RunTime:0.001472s ]
SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000380s ]
SHOW FULL COLUMNS FROM `nav_site` [ RunTime:0.001069s ]
SELECT `hide_code` FROM `nav_site` LIMIT 1 [ RunTime:0.000171s ]
SELECT tag_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `tag_id` [ RunTime:0.000692s ]
SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `category_id` = 4 AND `hide_code` = '' AND `tag_id` = 10 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000417s ]
SELECT * FROM `nav_site` WHERE `status` = 1 AND `category_id` = 4 AND `hide_code` = '' AND `tag_id` = 10 ORDER BY `sort` DESC,`id` DESC LIMIT 12,12 [ RunTime:0.000363s ]
SHOW FULL COLUMNS FROM `nav_ad_plan` [ RunTime:0.000796s ]
SELECT * FROM `nav_ad_plan` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000228s ]
SELECT * FROM `nav_category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001866s ]
SELECT category_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id` [ RunTime:0.000442s ]
SELECT SUM(`views`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.000362s ]
SHOW FULL COLUMNS FROM `nav_article` [ RunTime:0.000855s ]
SELECT SUM(`views`) AS think_sum FROM `nav_article` WHERE `status` = 1 [ RunTime:0.000266s ]
SELECT SUM(`likes`) AS think_sum FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.000292s ]
SELECT COUNT(*) AS think_count FROM `nav_category_tag` WHERE `status` = 1 [ RunTime:0.000287s ]
SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000298s ]
SELECT tag_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `tag_id` [ RunTime:0.000541s ]
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.000439s ]
SHOW FULL COLUMNS FROM `nav_like_log` [ RunTime:0.000958s ]
SELECT `target_id` FROM `nav_like_log` WHERE `type` = 'site' AND `ip` = '117.68.3.145' [ RunTime:0.000240s ]
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.000595s ]
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.000455s ]
SELECT * FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' ORDER BY `views` DESC,`id` DESC LIMIT 8 [ RunTime:0.000402s ]
SHOW FULL COLUMNS FROM `nav_ad` [ RunTime:0.003346s ]
SELECT * FROM `nav_ad` WHERE `status` = 2 AND `position` = 'home_banner' AND `start_time` <= 1793120410 AND `end_time` >= 1793120410 ORDER BY `sort` DESC,`id` DESC LIMIT 30 [ RunTime:0.000470s ]
SHOW FULL COLUMNS FROM `nav_link` [ RunTime:0.000604s ]
SELECT * FROM `nav_link` WHERE `status` = 1 AND `position` = 'top' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000290s ]
SELECT * FROM `nav_link` WHERE `status` = 1 AND `position` = 'foot' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000279s ]
SHOW FULL COLUMNS FROM `nav_qlink` [ RunTime:0.003181s ]
SELECT * FROM `nav_qlink` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 16 [ RunTime:0.000249s ]
SELECT * FROM `nav_category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000229s ]
SELECT category_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id` [ RunTime:0.000807s ]
SHOW FULL COLUMNS FROM `nav_dock` [ RunTime:0.000713s ]
SELECT * FROM `nav_dock` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 12 [ RunTime:0.000247s ]
SELECT * FROM `nav_category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000220s ]
SELECT category_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `category_id` [ RunTime:0.000417s ]
SELECT * FROM `nav_category_tag` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000247s ]
SELECT tag_id, COUNT(*) AS n FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' GROUP BY `tag_id` [ RunTime:0.000448s ]
SELECT * FROM `nav_site` WHERE `status` = 1 AND `id` = 96 AND `hide_code` = '' [ RunTime:0.000260s ]
SHOW FULL COLUMNS FROM `nav_article_cat` [ RunTime:0.000794s ]
SELECT * FROM `nav_article_cat` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000659s ]
SHOW FULL COLUMNS FROM `nav_notice` [ RunTime:0.000737s ]
SELECT * FROM `nav_notice` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.000229s ]
SHOW FULL COLUMNS FROM `nav_sponsor` [ RunTime:0.000727s ]
SELECT * FROM `nav_sponsor` WHERE `status` = 1 ORDER BY `amount` DESC,`id` ASC LIMIT 6 [ RunTime:0.000254s ]
SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' [ RunTime:0.000283s ]
SELECT COUNT(*) AS think_count FROM `nav_article` WHERE `status` = 1 [ RunTime:0.000184s ]
SELECT COUNT(*) AS think_count FROM `nav_notice` WHERE `status` = 1 [ RunTime:0.000173s ]
SELECT COUNT(*) AS think_count FROM `nav_sponsor` WHERE `status` = 1 [ RunTime:0.000178s ]
SELECT COUNT(*) AS think_count FROM `nav_site` WHERE `status` = 1 AND `hide_code` = '' AND `create_time` >= 1793116800 [ RunTime:0.000282s ]
SELECT * FROM `nav_ad` WHERE `status` = 2 AND `position` = 'home_fixed' AND `start_time` <= 1793120410 AND `end_time` >= 1793120410 ORDER BY `sort` DESC,`id` DESC LIMIT 9 [ RunTime:0.000355s ]
SELECT * FROM `nav_ad` WHERE `status` = 2 AND `position` = 'home_fixed' AND `start_time` <= 1793120410 AND `end_time` >= 1793120410 ORDER BY `sort` DESC,`id` DESC LIMIT 30 [ RunTime:0.000335s ]
