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.005024s ]
SHOW TABLES LIKE 'la_subscription_plan' [ RunTime:0.004655s ]
SHOW TABLES LIKE 'la_subscription_plan_translation' [ RunTime:0.003949s ]
SHOW TABLES LIKE 'la_plan_entitlement_translation' [ RunTime:0.003982s ]
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, '1792967499', '1792967499'
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.003743s ]
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, '1792967499', '1792967499'
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.002487s ]
SHOW TABLES LIKE 'la_user_translation' [ RunTime:0.004831s ]
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, '1792967499', '1792967499'
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.004397s ]
SELECT `name` FROM `la_addon` WHERE `state` = 1 ORDER BY `is_home` DESC,`id` ASC [ RunTime:0.002390s ]
SELECT `name` FROM `la_addon` WHERE `is_home` = 1 AND `state` = 1 LIMIT 1 [ RunTime:0.001741s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001814s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001558s ]
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`.`publish_time` <= '1792967499' AND ( MATCH(`t`.`title`, `t`.`keywords`, `t`.`description`) AGAINST ('标题' IN BOOLEAN MODE) ) ) AND `a`.`delete_time` IS NULL [ RunTime:0.003113s ]
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`.`publish_time` <= '1792967499' AND ( MATCH(`t`.`title`, `t`.`keywords`, `t`.`description`) AGAINST ('标题' IN BOOLEAN MODE) ) ) AND `a`.`delete_time` IS NULL ORDER BY `a`.`weigh` DESC,`a`.`id` DESC LIMIT 0,15 [ RunTime:0.002093s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001221s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001413s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001263s ]
SELECT * FROM `la_cms_category` WHERE ( `id` IN (4,9) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.003306s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001185s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001611s ]
SELECT * FROM `la_cms_category_translation` WHERE ( `category_id` IN (9,4) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.004926s ]
SELECT * FROM `la_cms_archives_translation` WHERE `lang` = 'zh-CN' AND ( `archives_id` IN (4,8) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.002196s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.000990s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001515s ]
SELECT `c`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`is_translated`,t.title as name FROM `la_cms_category` `c` INNER JOIN `la_cms_category_translation` `t` ON `t`.`category_id`=c.id AND t.lang = 'zh-CN' WHERE `c`.`status` = 'normal' AND `c`.`pid` = '0' ORDER BY `c`.`weigh` DESC LIMIT 6 [ RunTime:0.001791s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.000834s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001453s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 1 [ RunTime:0.001876s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 16 [ RunTime:0.001241s ]
SELECT `pid` FROM `la_cms_category` WHERE `pid` IN (1,16) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.003040s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001263s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001828s ]
SELECT `c`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`is_translated`,t.title as name FROM `la_cms_category` `c` INNER JOIN `la_cms_category_translation` `t` ON `t`.`category_id`=c.id AND t.lang = 'zh-CN' WHERE `c`.`status` = 'normal' AND `c`.`pid` = '1' ORDER BY `c`.`weigh` DESC LIMIT 12 [ RunTime:0.002506s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001276s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001425s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001347s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001557s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002653s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002331s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 2 [ RunTime:0.001588s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 7 [ RunTime:0.001568s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 12 [ RunTime:0.002496s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 13 [ RunTime:0.003055s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 14 [ RunTime:0.001830s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 15 [ RunTime:0.002363s ]
SELECT `pid` FROM `la_cms_category` WHERE `pid` IN (2,7,12,13,14,15) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.001626s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'page' [ RunTime:0.001512s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'page' [ RunTime:0.001028s ]
SELECT `p`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`content`,`t`.`is_translated` FROM `la_cms_page` `p` INNER JOIN `la_cms_page_translation` `t` ON `t`.`page_id`=p.id AND t.lang = 'zh-CN' WHERE `p`.`status` = 'normal' ORDER BY `p`.`weigh` DESC LIMIT 6 [ RunTime:0.002134s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'page' [ RunTime:0.001943s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'page' [ RunTime:0.008085s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'page' [ RunTime:0.002431s ]
SELECT * FROM `la_cms_page_translation` WHERE `page_id` = 1 [ RunTime:0.002207s ]
SELECT * FROM `la_cms_page_translation` WHERE `page_id` = 2 [ RunTime:0.003309s ]
SELECT * FROM `la_cms_page_translation` WHERE `page_id` = 3 [ RunTime:0.001944s ]
SHOW FULL COLUMNS FROM `la_cms_tags` [ RunTime:0.004470s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001315s ]
SELECT `tg`.`id`,`tg`.`weigh`,`t`.`name`,`t`.`slug` FROM `la_cms_tags` `tg` INNER JOIN `la_cms_tags_translation` `t` ON `t`.`tags_id`=tg.id AND t.lang = 'zh-CN' ORDER BY `tg`.`weigh` DESC LIMIT 8 [ RunTime:0.002582s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002349s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002464s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001762s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002168s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.000914s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002493s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001598s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001620s ]
SHOW FULL COLUMNS FROM `la_cms_tags_translation` [ RunTime:0.004131s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 1 [ RunTime:0.002473s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 2 [ RunTime:0.001947s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 3 [ RunTime:0.001437s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 4 [ RunTime:0.001740s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 5 [ RunTime:0.001537s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 6 [ RunTime:0.001796s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 7 [ RunTime:0.001359s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 8 [ RunTime:0.001290s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002964s ]
SELECT tg.id, tg.weigh, t.name, t.slug, COUNT(atr.id) as article_count FROM `la_cms_tags` `tg` INNER JOIN `la_cms_tags_translation` `t` ON `t`.`tags_id`=tg.id AND t.lang = 'zh-CN' LEFT JOIN `la_cms_archives_tags` `at` ON `at`.`tags_id`=`tg`.`id` LEFT JOIN `la_cms_archives` `a` ON `a`.`id`=`at`.`archives_id` LEFT JOIN `la_cms_archives_translation` `atr` ON `atr`.`archives_id`=a.id AND atr.lang = 'zh-CN' GROUP BY `tg`.`id`,`t`.`name`,`t`.`slug`,`tg`.`weigh` ORDER BY `tg`.`weigh` DESC LIMIT 6 [ RunTime:0.004033s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002970s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001510s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001715s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001721s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001408s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001906s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 1 [ RunTime:0.001879s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 2 [ RunTime:0.001604s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 3 [ RunTime:0.001676s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 4 [ RunTime:0.001637s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 5 [ RunTime:0.001746s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 6 [ RunTime:0.002545s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001601s ]
SELECT tg.id, tg.weigh, t.name, t.slug, COUNT(atr.id) as article_count FROM `la_cms_tags` `tg` INNER JOIN `la_cms_tags_translation` `t` ON `t`.`tags_id`=tg.id AND t.lang = 'zh-CN' LEFT JOIN `la_cms_archives_tags` `at` ON `at`.`tags_id`=`tg`.`id` LEFT JOIN `la_cms_archives` `a` ON `a`.`id`=`at`.`archives_id` LEFT JOIN `la_cms_archives_translation` `atr` ON `atr`.`archives_id`=a.id AND atr.lang = 'zh-CN' GROUP BY `tg`.`id`,`t`.`name`,`t`.`slug`,`tg`.`weigh` ORDER BY `tg`.`weigh` DESC LIMIT 20 [ RunTime:0.002549s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001553s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001064s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002068s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002422s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001798s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001246s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002070s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002231s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001726s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001961s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001981s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001351s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 1 [ RunTime:0.001137s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 2 [ RunTime:0.001952s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 3 [ RunTime:0.001602s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 4 [ RunTime:0.001560s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 5 [ RunTime:0.001364s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 6 [ RunTime:0.001542s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 7 [ RunTime:0.001727s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 8 [ RunTime:0.001740s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 9 [ RunTime:0.001391s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 10 [ RunTime:0.001337s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 11 [ RunTime:0.002517s ]
SELECT * FROM `la_cms_tags_translation` WHERE `tags_id` = 12 [ RunTime:0.001828s ]