CREATE TABLE IF NOT EXISTS `lan_addon_call_reservation` (
`call_id` varchar(64) NOT NULL COMMENT '服务端生成的单次调用标识',
`user_id` int unsigned NOT NULL COMMENT '归属会员ID',
`subject` varchar(50) NOT NULL COMMENT '调用插件',
`subscription_id` int unsigned NOT NULL COMMENT '调用开始时的订阅ID',
`quota_id` int unsigned NOT NULL COMMENT '调用开始时的额度ID',
`metric` varchar(20) NOT NULL COMMENT '额度计量维度',
`state` varchar(16) NOT NULL COMMENT 'reserved/confirmed/released/expired',
`limit_mode` varchar(16) NOT NULL COMMENT '调用开始时的限制模式',
`period_started_at` int unsigned NOT NULL COMMENT '调用归属周期',
`unlimited` tinyint unsigned NOT NULL COMMENT '是否不限量',
`reserved_at` int unsigned NOT NULL COMMENT '调用开始时间',
`expires_at` int unsigned NOT NULL COMMENT '占用失效时间',
`finished_at` int unsigned NOT NULL DEFAULT 0 COMMENT '状态完成时间',
PRIMARY KEY (`call_id`),
KEY `idx_quota_state` (`quota_id`,`state`,`expires_at`),
KEY `idx_expiry` (`state`,`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='AI成功次数预占用' [ RunTime:0.004619s ]
SHOW TABLES LIKE 'lan_subscription_plan' [ RunTime:0.005968s ]
SHOW TABLES LIKE 'lan_subscription_plan_translation' [ RunTime:0.004449s ]
SHOW TABLES LIKE 'lan_plan_entitlement_translation' [ RunTime:0.004014s ]
INSERT IGNORE INTO `lan_subscription_plan_translation` (plan_id, lang, name, description, is_translated, create_time, update_time)
SELECT p.id, 'en', p.name, p.description, 1, '1793625598', '1793625598'
FROM `lan_subscription_plan` p
LEFT JOIN `lan_subscription_plan_translation` t ON t.plan_id = p.id AND t.lang = 'en'
WHERE t.id IS NULL [ RunTime:0.004113s ]
INSERT IGNORE INTO `lan_plan_entitlement_translation` (entitlement_id, lang, subject_title, is_translated, create_time, update_time)
SELECT e.id, 'en', e.subject_title, 1, '1793625598', '1793625598'
FROM `lan_plan_entitlement` e
LEFT JOIN `lan_plan_entitlement_translation` t ON t.entitlement_id = e.id AND t.lang = 'en'
WHERE t.id IS NULL [ RunTime:0.004396s ]
SHOW TABLES LIKE 'lan_user_translation' [ RunTime:0.006962s ]
INSERT IGNORE INTO `lan_user_translation` (user_id, lang, nickname, bio, avatar_alt, is_translated, create_time, update_time)
SELECT u.id, 'en', u.nickname, u.bio, '', 1, '1793625598', '1793625598'
FROM `lan_user` u
LEFT JOIN `lan_user_translation` t ON t.user_id = u.id AND t.lang = 'en'
WHERE t.id IS NULL [ RunTime:0.004603s ]
SELECT `name` FROM `lan_addon` WHERE `state` = 1 ORDER BY `is_home` DESC,`id` ASC [ RunTime:0.002597s ]
SELECT `name` FROM `lan_addon` WHERE `is_home` = 1 AND `state` = 1 LIMIT 1 [ RunTime:0.003021s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004146s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.011848s ]
SELECT `c`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`is_translated`,t.title as name FROM `lan_cms_category` `c` INNER JOIN `lan_cms_category_translation` `t` ON `t`.`category_id`=c.id AND t.lang = 'en' WHERE `c`.`status` = 'normal' AND `c`.`pid` = '0' ORDER BY `c`.`weigh` DESC LIMIT 6 [ RunTime:0.012479s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.005279s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.006164s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.007631s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.005462s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 1 [ RunTime:0.004415s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 9 [ RunTime:0.010401s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 14 [ RunTime:0.008968s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 17 [ RunTime:0.005016s ]
SELECT `pid` FROM `lan_cms_category` WHERE `pid` IN (1,9,14,17) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.010183s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.005284s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.005098s ]
SELECT `c`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`is_translated`,t.title as name FROM `lan_cms_category` `c` INNER JOIN `lan_cms_category_translation` `t` ON `t`.`category_id`=c.id AND t.lang = 'en' WHERE `c`.`status` = 'normal' AND `c`.`pid` = '1' ORDER BY `c`.`weigh` DESC LIMIT 12 [ RunTime:0.009701s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004328s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.005956s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.009086s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.007611s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004236s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004345s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.007863s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 2 [ RunTime:0.006294s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 3 [ RunTime:0.004589s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 4 [ RunTime:0.006036s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 5 [ RunTime:0.006437s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 6 [ RunTime:0.005393s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 7 [ RunTime:0.005224s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 8 [ RunTime:0.004894s ]
SELECT `pid` FROM `lan_cms_category` WHERE `pid` IN (2,3,4,5,6,7,8) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.005709s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002618s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004034s ]
SELECT `c`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`is_translated`,t.title as name FROM `lan_cms_category` `c` INNER JOIN `lan_cms_category_translation` `t` ON `t`.`category_id`=c.id AND t.lang = 'en' WHERE `c`.`status` = 'normal' AND `c`.`pid` = '9' ORDER BY `c`.`weigh` DESC LIMIT 12 [ RunTime:0.005796s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004298s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004959s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.005213s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.005503s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 10 [ RunTime:0.005142s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 11 [ RunTime:0.005339s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 12 [ RunTime:0.004806s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 13 [ RunTime:0.002922s ]
SELECT `pid` FROM `lan_cms_category` WHERE `pid` IN (10,11,12,13) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.005411s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.003858s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004898s ]
SELECT `c`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`is_translated`,t.title as name FROM `lan_cms_category` `c` INNER JOIN `lan_cms_category_translation` `t` ON `t`.`category_id`=c.id AND t.lang = 'en' WHERE `c`.`status` = 'normal' AND `c`.`pid` = '14' ORDER BY `c`.`weigh` DESC LIMIT 12 [ RunTime:0.004700s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.003194s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.005681s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 15 [ RunTime:0.005904s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 16 [ RunTime:0.004858s ]
SELECT `pid` FROM `lan_cms_category` WHERE `pid` IN (15,16) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.003159s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.003428s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.002391s ]
SELECT `p`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`content`,`t`.`is_translated` FROM `lan_cms_page` `p` INNER JOIN `lan_cms_page_translation` `t` ON `t`.`page_id`=p.id AND t.lang = 'en' WHERE `p`.`status` = 'normal' ORDER BY `p`.`weigh` DESC LIMIT 6 [ RunTime:0.004522s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.003222s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.003508s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.002480s ]
SELECT * FROM `lan_cms_page_translation` WHERE `page_id` = 1 [ RunTime:0.003090s ]
SELECT * FROM `lan_cms_page_translation` WHERE `page_id` = 2 [ RunTime:0.004530s ]
SELECT * FROM `lan_cms_page_translation` WHERE `page_id` = 3 [ RunTime:0.004244s ]
SHOW FULL COLUMNS FROM `lan_cms_tags` [ RunTime:0.006388s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002206s ]
SELECT tg.id, tg.weigh, t.name, t.slug, COUNT(atr.id) as article_count FROM `lan_cms_tags` `tg` INNER JOIN `lan_cms_tags_translation` `t` ON `t`.`tags_id`=tg.id AND t.lang = 'en' LEFT JOIN `lan_cms_archives_tags` `at` ON `at`.`tags_id`=`tg`.`id` LEFT JOIN `lan_cms_archives` `a` ON `a`.`id`=`at`.`archives_id` LEFT JOIN `lan_cms_archives_translation` `atr` ON `atr`.`archives_id`=a.id AND atr.lang = 'en' GROUP BY `tg`.`id`,`t`.`name`,`t`.`slug`,`tg`.`weigh` ORDER BY `tg`.`weigh` DESC LIMIT 6 [ RunTime:0.005165s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002129s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002981s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002494s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002088s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001969s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002792s ]
SHOW FULL COLUMNS FROM `lan_cms_tags_translation` [ RunTime:0.006188s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 1 [ RunTime:0.003906s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 2 [ RunTime:0.002444s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 3 [ RunTime:0.002300s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 4 [ RunTime:0.001665s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 5 [ RunTime:0.002424s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 6 [ RunTime:0.002111s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001917s ]
SELECT tg.id, tg.weigh, t.name, t.slug, COUNT(atr.id) as article_count FROM `lan_cms_tags` `tg` INNER JOIN `lan_cms_tags_translation` `t` ON `t`.`tags_id`=tg.id AND t.lang = 'en' LEFT JOIN `lan_cms_archives_tags` `at` ON `at`.`tags_id`=`tg`.`id` LEFT JOIN `lan_cms_archives` `a` ON `a`.`id`=`at`.`archives_id` LEFT JOIN `lan_cms_archives_translation` `atr` ON `atr`.`archives_id`=a.id AND atr.lang = 'en' GROUP BY `tg`.`id`,`t`.`name`,`t`.`slug`,`tg`.`weigh` ORDER BY `tg`.`weigh` DESC LIMIT 20 [ RunTime:0.010022s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.004223s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.003320s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002669s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002840s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.007887s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.003323s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.004849s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.003055s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002375s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002365s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.004380s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.003745s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 1 [ RunTime:0.005275s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 2 [ RunTime:0.003299s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 3 [ RunTime:0.005852s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 4 [ RunTime:0.003052s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 5 [ RunTime:0.004564s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 6 [ RunTime:0.003002s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 7 [ RunTime:0.004223s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 8 [ RunTime:0.005112s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 9 [ RunTime:0.005078s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 10 [ RunTime:0.002694s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 11 [ RunTime:0.003484s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 12 [ RunTime:0.004041s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001540s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002027s ]
SELECT `c`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`is_translated`,t.title as name FROM `lan_cms_category` `c` INNER JOIN `lan_cms_category_translation` `t` ON `t`.`category_id`=c.id AND t.lang = 'en' WHERE `c`.`status` = 'normal' AND `c`.`pid` = '0' ORDER BY `c`.`weigh` DESC LIMIT 8 [ RunTime:0.002766s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002540s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001859s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001593s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001429s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 1 [ RunTime:0.002224s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 9 [ RunTime:0.004432s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 14 [ RunTime:0.003425s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 17 [ RunTime:0.002090s ]
SELECT `pid` FROM `lan_cms_category` WHERE `pid` IN (1,9,14,17) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.002786s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.002399s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.002249s ]
SELECT `p`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`content`,`t`.`is_translated` FROM `lan_cms_page` `p` INNER JOIN `lan_cms_page_translation` `t` ON `t`.`page_id`=p.id AND t.lang = 'en' WHERE `p`.`status` = 'normal' ORDER BY `p`.`weigh` DESC LIMIT 8 [ RunTime:0.005120s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.002602s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.002424s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.003821s ]
SELECT * FROM `lan_cms_page_translation` WHERE `page_id` = 1 [ RunTime:0.005087s ]
SELECT * FROM `lan_cms_page_translation` WHERE `page_id` = 2 [ RunTime:0.005623s ]
SELECT * FROM `lan_cms_page_translation` WHERE `page_id` = 3 [ RunTime:0.004158s ]