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.004997s ]
SHOW TABLES LIKE 'lan_subscription_plan' [ RunTime:0.004259s ]
SHOW TABLES LIKE 'lan_subscription_plan_translation' [ RunTime:0.002745s ]
SHOW TABLES LIKE 'lan_plan_entitlement_translation' [ RunTime:0.003942s ]
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, '1793628170', '1793628170'
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.006713s ]
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, '1793628170', '1793628170'
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.002334s ]
SHOW TABLES LIKE 'lan_user_translation' [ RunTime:0.004324s ]
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, '1793628170', '1793628170'
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.002941s ]
SELECT `name` FROM `lan_addon` WHERE `state` = 1 ORDER BY `is_home` DESC,`id` ASC [ RunTime:0.002177s ]
SELECT `name` FROM `lan_addon` WHERE `is_home` = 1 AND `state` = 1 LIMIT 1 [ RunTime:0.001856s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'special' [ RunTime:0.001321s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'special' [ RunTime:0.001188s ]
SELECT COUNT(*) AS think_count FROM `lan_cms_special` `s` INNER JOIN `lan_cms_special_translation` `t` ON `t`.`special_id`=s.id AND t.lang = 'en' WHERE ( `s`.`status` = 'normal' ) AND `s`.`delete_time` IS NULL [ RunTime:0.001780s ]
SELECT `s`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`intro`,`t`.`content`,`t`.`is_translated` FROM `lan_cms_special` `s` INNER JOIN `lan_cms_special_translation` `t` ON `t`.`special_id`=s.id AND t.lang = 'en' WHERE ( `s`.`status` = 'normal' ) AND `s`.`delete_time` IS NULL ORDER BY `s`.`weigh` DESC,`s`.`id` DESC LIMIT 0,10 [ RunTime:0.001723s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'special' [ RunTime:0.001345s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'special' [ RunTime:0.000923s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'special' [ RunTime:0.001472s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'special' [ RunTime:0.001333s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.005168s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004504s ]
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.007237s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.006183s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001458s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001845s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001092s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 1 [ RunTime:0.001500s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 9 [ RunTime:0.002096s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 14 [ RunTime:0.001144s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 17 [ RunTime:0.002711s ]
SELECT `pid` FROM `lan_cms_category` WHERE `pid` IN (1,9,14,17) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.003228s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001361s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001489s ]
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.001719s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001187s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001784s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001116s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001228s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001225s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.000805s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.003052s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 2 [ RunTime:0.002157s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 3 [ RunTime:0.001711s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 4 [ RunTime:0.001756s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 5 [ RunTime:0.002180s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 6 [ RunTime:0.002488s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 7 [ RunTime:0.001416s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 8 [ RunTime:0.001967s ]
SELECT `pid` FROM `lan_cms_category` WHERE `pid` IN (2,3,4,5,6,7,8) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.001601s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.000959s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001425s ]
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.001983s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001405s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001381s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001149s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001310s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 10 [ RunTime:0.001365s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 11 [ RunTime:0.001826s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 12 [ RunTime:0.001502s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 13 [ RunTime:0.001306s ]
SELECT `pid` FROM `lan_cms_category` WHERE `pid` IN (10,11,12,13) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.002412s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001221s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001301s ]
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.003128s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001861s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002148s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 15 [ RunTime:0.001803s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 16 [ RunTime:0.002009s ]
SELECT `pid` FROM `lan_cms_category` WHERE `pid` IN (15,16) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.002060s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.003636s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.002075s ]
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.014862s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.003423s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.007273s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.006962s ]
SELECT * FROM `lan_cms_page_translation` WHERE `page_id` = 1 [ RunTime:0.009660s ]
SELECT * FROM `lan_cms_page_translation` WHERE `page_id` = 2 [ RunTime:0.005277s ]
SELECT * FROM `lan_cms_page_translation` WHERE `page_id` = 3 [ RunTime:0.004901s ]
SELECT * FROM `lan_cms_special_translation` WHERE `special_id` = 1 [ RunTime:0.004720s ]
SELECT * FROM `lan_cms_special_translation` WHERE `special_id` = 2 [ RunTime:0.003798s ]
SELECT * FROM `lan_cms_special_translation` WHERE `special_id` = 3 [ RunTime:0.005946s ]
SELECT * FROM `lan_cms_special_translation` WHERE `special_id` = 4 [ RunTime:0.004566s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.003239s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002620s ]
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.005087s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.003941s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002590s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002610s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.003844s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 1 [ RunTime:0.007534s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 9 [ RunTime:0.004861s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 14 [ RunTime:0.003617s ]
SELECT * FROM `lan_cms_category_translation` WHERE `category_id` = 17 [ RunTime:0.002226s ]
SELECT `pid` FROM `lan_cms_category` WHERE `pid` IN (1,9,14,17) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.005005s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.002505s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.003016s ]
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.003772s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.003648s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.004491s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'page' [ RunTime:0.004829s ]
SELECT * FROM `lan_cms_page_translation` WHERE `page_id` = 1 [ RunTime:0.003168s ]
SELECT * FROM `lan_cms_page_translation` WHERE `page_id` = 2 [ RunTime:0.005036s ]
SELECT * FROM `lan_cms_page_translation` WHERE `page_id` = 3 [ RunTime:0.003116s ]