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.010592s ]
SHOW TABLES LIKE 'la_subscription_plan' [ RunTime:0.008591s ]
SHOW TABLES LIKE 'la_subscription_plan_translation' [ RunTime:0.008067s ]
SHOW TABLES LIKE 'la_plan_entitlement_translation' [ RunTime:0.010448s ]
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, '1792963804', '1792963804'
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.005167s ]
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, '1792963804', '1792963804'
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.006015s ]
SHOW TABLES LIKE 'la_user_translation' [ RunTime:0.010548s ]
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, '1792963804', '1792963804'
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.011271s ]
SELECT `name` FROM `la_addon` WHERE `state` = 1 ORDER BY `is_home` DESC,`id` ASC [ RunTime:0.004853s ]
SELECT `name` FROM `la_addon` WHERE `is_home` = 1 AND `state` = 1 LIMIT 1 [ RunTime:0.003675s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004164s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002126s ]
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 `t`.`slug` = 'tutorial-writing' AND `c`.`status` = 'normal' LIMIT 1 [ RunTime:0.003264s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004023s ]
SELECT * FROM `la_cms_model` WHERE `id` = 1 LIMIT 1 [ RunTime:0.004634s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 4 [ RunTime:0.003626s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002699s ]
SELECT * FROM `la_cms_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.003775s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002812s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.002842s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.002625s ]
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` <= '1792963804' AND `a`.`category_id` = '4' ) AND `a`.`delete_time` IS NULL [ RunTime:0.003287s ]
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` <= '1792963804' AND `a`.`category_id` = '4' ) AND `a`.`delete_time` IS NULL ORDER BY `a`.`weigh` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.003630s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.002329s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.004604s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002076s ]
SELECT * FROM `la_cms_category` WHERE ( `id` = 4 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003430s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.007278s ]
SELECT * FROM `la_cms_category_translation` WHERE ( `category_id` = 4 ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.009375s ]
SELECT * FROM `la_cms_archives_translation` WHERE `lang` = 'zh-CN' AND ( `archives_id` IN (3,4) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.003265s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.003321s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004384s ]
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.009523s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001905s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.003046s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 1 [ RunTime:0.002474s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 16 [ RunTime:0.003515s ]
SELECT `pid` FROM `la_cms_category` WHERE `pid` IN (1,16) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.005294s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.003488s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001700s ]
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.003019s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002315s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002269s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.005393s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002312s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002914s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002675s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 2 [ RunTime:0.002954s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 7 [ RunTime:0.004383s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 12 [ RunTime:0.004596s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 13 [ RunTime:0.002850s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 14 [ RunTime:0.002071s ]
SELECT * FROM `la_cms_category_translation` WHERE `category_id` = 15 [ RunTime:0.003046s ]
SELECT `pid` FROM `la_cms_category` WHERE `pid` IN (2,7,12,13,14,15) AND `status` = 'normal' GROUP BY `pid` [ RunTime:0.002802s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'page' [ RunTime:0.001916s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'page' [ RunTime:0.001222s ]
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.002236s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'page' [ RunTime:0.001979s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'page' [ RunTime:0.002463s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'page' [ RunTime:0.002210s ]
SELECT * FROM `la_cms_page_translation` WHERE `page_id` = 1 [ RunTime:0.002371s ]
SELECT * FROM `la_cms_page_translation` WHERE `page_id` = 2 [ RunTime:0.002040s ]
SELECT * FROM `la_cms_page_translation` WHERE `page_id` = 3 [ RunTime:0.002243s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001458s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001283s ]
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` <= '1792963805' ) AND `a`.`delete_time` IS NULL ORDER BY `a`.`publish_time` DESC LIMIT 5 [ RunTime:0.002106s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001376s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001894s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001884s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.002698s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001694s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001336s ]
SELECT * FROM `la_cms_category` WHERE ( `id` IN (15,14,13) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.001963s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002206s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002119s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001108s ]
SELECT * FROM `la_cms_category_translation` WHERE ( `category_id` IN (15,14,13) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.001751s ]
SELECT * FROM `la_cms_archives_translation` WHERE `archives_id` = 21 [ RunTime:0.001930s ]
SELECT * FROM `la_cms_archives_translation` WHERE `archives_id` = 19 [ RunTime:0.002114s ]
SELECT * FROM `la_cms_archives_translation` WHERE `archives_id` = 18 [ RunTime:0.001659s ]
SELECT * FROM `la_cms_archives_translation` WHERE `archives_id` = 17 [ RunTime:0.002596s ]
SELECT * FROM `la_cms_archives_translation` WHERE `archives_id` = 16 [ RunTime:0.001971s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'special' [ RunTime:0.002831s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'special' [ RunTime:0.000950s ]
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 ( `s`.`status` = 'normal' ) AND `s`.`delete_time` IS NULL ORDER BY `s`.`weigh` DESC LIMIT 4 [ RunTime:0.002294s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'special' [ RunTime:0.001407s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'special' [ RunTime:0.001153s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'special' [ RunTime:0.001563s ]
SELECT `name` FROM `la_cms_model_field` WHERE `source` = 'special' [ RunTime:0.001242s ]
SELECT * FROM `la_cms_special_translation` WHERE `special_id` = 1 [ RunTime:0.003106s ]
SELECT * FROM `la_cms_special_translation` WHERE `special_id` = 2 [ RunTime:0.001941s ]
SELECT * FROM `la_cms_special_translation` WHERE `special_id` = 3 [ RunTime:0.001409s ]
SELECT * FROM `la_cms_special_translation` WHERE `special_id` = 4 [ RunTime:0.001662s ]