CREATE TABLE IF NOT EXISTS `la_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.003901s ]
SHOW TABLES LIKE 'la_subscription_plan' [ RunTime:0.003055s ]
SHOW TABLES LIKE 'la_subscription_plan_translation' [ RunTime:0.002664s ]
SHOW TABLES LIKE 'la_plan_entitlement_translation' [ RunTime:0.002671s ]
INSERT IGNORE INTO `la_subscription_plan_translation` (plan_id, lang, name, description, is_translated, create_time, update_time)
SELECT p.id, 'zh-CN', p.name, p.description, 1, '1792899083', '1792899083'
FROM `la_subscription_plan` p
LEFT JOIN `la_subscription_plan_translation` t ON t.plan_id = p.id AND t.lang = 'zh-CN'
WHERE t.id IS NULL [ RunTime:0.002101s ]
INSERT IGNORE INTO `la_plan_entitlement_translation` (entitlement_id, lang, subject_title, is_translated, create_time, update_time)
SELECT e.id, 'zh-CN', e.subject_title, 1, '1792899083', '1792899083'
FROM `la_plan_entitlement` e
LEFT JOIN `la_plan_entitlement_translation` t ON t.entitlement_id = e.id AND t.lang = 'zh-CN'
WHERE t.id IS NULL [ RunTime:0.002258s ]
SHOW TABLES LIKE 'la_user_translation' [ RunTime:0.003073s ]
INSERT IGNORE INTO `la_user_translation` (user_id, lang, nickname, bio, avatar_alt, is_translated, create_time, update_time)
SELECT u.id, 'zh-CN', u.nickname, u.bio, '', 1, '1792899083', '1792899083'
FROM `la_user` u
LEFT JOIN `la_user_translation` t ON t.user_id = u.id AND t.lang = 'zh-CN'
WHERE t.id IS NULL [ RunTime:0.002496s ]
SELECT `name` FROM `la_addon` WHERE `state` = 1 ORDER BY `is_home` DESC,`id` ASC [ RunTime:0.001661s ]
SELECT `name` FROM `la_addon` WHERE `is_home` = 1 AND `state` = 1 LIMIT 1 [ RunTime:0.001329s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'special' [ RunTime:0.002300s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'special' [ RunTime:0.001124s ]
SELECT `s`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`intro`,`t`.`content`,`t`.`is_translated` FROM `la_cms_special` `s` INNER JOIN `la_cms_special_translation` `t` ON `t`.`special_id`=s.id AND t.lang = 'zh-CN' WHERE ( `t`.`slug` = 'cluster-novel' AND `s`.`status` = 'normal' ) AND `s`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001723s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'special' [ RunTime:0.001047s ]
UPDATE `la_cms_special` SET `views` = `views` + 1 WHERE `id` = 1 [ RunTime:0.004804s ]
SELECT `archives_id` FROM `la_cms_special_archives` WHERE `special_id` = 1 ORDER BY `weigh` DESC LIMIT 2000 [ RunTime:0.001951s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001032s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.000940s ]
SELECT COUNT(*) AS think_count FROM `la_cms_archives` `a` INNER JOIN `la_cms_archives_translation` `t` ON `t`.`archives_id`=a.id AND t.lang = 'zh-CN' WHERE ( `a`.`status` = 'normal' AND `a`.`id` IN ('14','1','2','7','15') ) AND `a`.`delete_time` IS NULL [ RunTime:0.001698s ]
SELECT `a`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`content`,`t`.`cover_image`,`t`.`is_translated` FROM `la_cms_archives` `a` INNER JOIN `la_cms_archives_translation` `t` ON `t`.`archives_id`=a.id AND t.lang = 'zh-CN' WHERE ( `a`.`status` = 'normal' AND `a`.`id` IN ('14','1','2','7','15') ) AND `a`.`delete_time` IS NULL ORDER BY `a`.`publish_time` DESC LIMIT 0,15 [ RunTime:0.001612s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001015s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.000996s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.000937s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001110s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.002153s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001086s ]
SELECT * FROM `la_cms_category` WHERE ( `id` IN (13,8,3) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.001799s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.000872s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.000961s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.000842s ]
SELECT * FROM `la_cms_category_translation` WHERE ( `category_id` IN (13,8,3) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.002169s ]
SELECT * FROM `la_cms_special_translation` WHERE `special_id` = 1 [ RunTime:0.001348s ]
SELECT * FROM `la_cms_archives_translation` WHERE `archives_id` = 15 [ RunTime:0.001110s ]
SELECT * FROM `la_cms_archives_translation` WHERE `archives_id` = 14 [ RunTime:0.001385s ]
SELECT * FROM `la_cms_archives_translation` WHERE `archives_id` = 7 [ RunTime:0.001275s ]
SELECT * FROM `la_cms_archives_translation` WHERE `archives_id` = 2 [ RunTime:0.001480s ]
SELECT * FROM `la_cms_archives_translation` WHERE `archives_id` = 1 [ RunTime:0.002384s ]