SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartSubAccount' LIMIT 1 [ RunTime:0.000387s ]
SELECT * FROM `idcsmart_addon_idcsmart_sub_account` WHERE `client_id` = 0 LIMIT 1 [ RunTime:0.000288s ]
SELECT * FROM `idcsmart_client` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000457s ]
SHOW FULL COLUMNS FROM `idcsmart_template_my_config` [ RunTime:0.001541s ]
SELECT `value` FROM `idcsmart_template_my_config` WHERE `setting` = 'template_header' LIMIT 1 [ RunTime:0.000378s ]
SHOW FULL COLUMNS FROM `idcsmart_plugin` [ RunTime:0.000767s ]
SELECT `id`,`name`,`title`,`url`,`config` FROM `idcsmart_plugin` WHERE ( `module` = 'addon' AND `status` = 1 ) ORDER BY `order` ASC,`id` ASC [ RunTime:0.000356s ]
SELECT * FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartCertification' AND `status` = 1 LIMIT 1 [ RunTime:0.000421s ]
SELECT * FROM `idcsmart_seo` WHERE `page_address` = 'articleInfo.html' LIMIT 1 [ RunTime:0.001144s ]
SELECT * FROM `idcsmart_template_my_config` WHERE `setting` = 'template_header' LIMIT 1 [ RunTime:0.000544s ]
SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartNews' LIMIT 1 [ RunTime:0.000519s ]
SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartAnnouncement' LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`parent_id`,`name`,`description`,`file_address`,`icon`,`blank` FROM `idcsmart_web_nav` WHERE `show` = 1 AND `theme` = 'my' AND `language` = 'zh-cn' ORDER BY `order` ASC [ RunTime:0.001268s ]
SELECT `id`,`group_id`,`name`,`url`,`blank` FROM `idcsmart_bottom_bar_nav` WHERE `show` = 1 AND `theme` = 'my' AND `language` = 'zh-cn' ORDER BY `order` ASC [ RunTime:0.001195s ]
SELECT `id`,`name` FROM `idcsmart_bottom_bar_group` WHERE `theme` = 'my' ORDER BY `order` ASC [ RunTime:0.001125s ]
SELECT `id`,`name`,`icon`,`content` FROM `idcsmart_side_floating_window` ORDER BY `order` ASC [ RunTime:0.001036s ]
SELECT `id`,`name`,`url` FROM `idcsmart_friendly_link` [ RunTime:0.001097s ]
SELECT `id`,`name`,`img` FROM `idcsmart_honor` [ RunTime:0.001020s ]
SELECT `id`,`name`,`img`,`description` FROM `idcsmart_partner` [ RunTime:0.001032s ]
SELECT `setting`,`value` FROM `idcsmart_template_my_config` [ RunTime:0.000558s ]
CREATE TABLE IF NOT EXISTS `idcsmart_article_tag` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '标签ID',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '标签名称',
`create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章标签表' [ RunTime:0.002926s ]
CREATE TABLE IF NOT EXISTS `idcsmart_article_tag_link` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '关联ID',
`tag_id` int(11) NOT NULL DEFAULT '0' COMMENT '标签ID',
`rel_type` varchar(32) NOT NULL DEFAULT '' COMMENT '关联类型 announcement/help/news',
`rel_id` int(11) NOT NULL DEFAULT '0' COMMENT '文章ID',
`create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `tag_rel` (`tag_id`,`rel_type`,`rel_id`),
KEY `rel` (`rel_type`,`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章标签关联表' [ RunTime:0.002913s ]
SHOW FULL COLUMNS FROM `idcsmart_addon_idcsmart_help` [ RunTime:0.001544s ]
SELECT `a`.`id`,`a`.`title`,`a`.`content`,`a`.`keywords`,`a`.`read`,`a`.`create_time`,`a`.`update_time`,a.addon_idcsmart_help_type_id as type_id,t.name as type_name,`a`.`cron_release`,`a`.`cron_release_time` FROM `idcsmart_addon_idcsmart_help` `a` LEFT JOIN `idcsmart_addon_idcsmart_help_type` `t` ON `t`.`id`=`a`.`addon_idcsmart_help_type_id` WHERE `a`.`id` = '36' AND `a`.`hidden` = '0' AND ( `a`.`cron_release` = '0' OR ( `a`.`cron_release` = '1' AND `a`.`cron_release_time` <= '1779263185' ) ) LIMIT 1 [ RunTime:0.001213s ]
UPDATE `idcsmart_addon_idcsmart_help` SET `read` = `read` + 1 WHERE `id` = 36 [ RunTime:0.002678s ]
CREATE TABLE IF NOT EXISTS `idcsmart_article_tag` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '标签ID',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '标签名称',
`create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章标签表' [ RunTime:0.002776s ]
CREATE TABLE IF NOT EXISTS `idcsmart_article_tag_link` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '关联ID',
`tag_id` int(11) NOT NULL DEFAULT '0' COMMENT '标签ID',
`rel_type` varchar(32) NOT NULL DEFAULT '' COMMENT '关联类型 announcement/help/news',
`rel_id` int(11) NOT NULL DEFAULT '0' COMMENT '文章ID',
`create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `tag_rel` (`tag_id`,`rel_type`,`rel_id`),
KEY `rel` (`rel_type`,`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章标签关联表' [ RunTime:0.001918s ]
SELECT `t`.`name` FROM `idcsmart_article_tag` `t` INNER JOIN `idcsmart_article_tag_link` `l` ON `l`.`tag_id`=`t`.`id` WHERE `l`.`rel_type` = 'help' AND `l`.`rel_id` = '36' ORDER BY `l`.`id` ASC [ RunTime:0.000470s ]
SELECT `id`,`title` FROM `idcsmart_addon_idcsmart_help` WHERE ( `hidden` = 0 AND `addon_idcsmart_help_type_id` = 3 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263185 ) ) ) AND `id` < 36 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001344s ]
SELECT `id`,`title` FROM `idcsmart_addon_idcsmart_help` WHERE ( `hidden` = 0 AND `addon_idcsmart_help_type_id` = 3 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263185 ) ) ) AND `id` > 36 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id` FROM `idcsmart_addon_idcsmart_help` WHERE `hidden` = 0 AND `addon_idcsmart_help_type_id` = 3 LIMIT 80 [ RunTime:0.000452s ]
SHOW FULL COLUMNS FROM `idcsmart_article_tag` [ RunTime:0.000693s ]
SELECT `t`.`name` FROM `idcsmart_article_tag` `t` INNER JOIN `idcsmart_article_tag_link` `l` ON `l`.`tag_id`=`t`.`id` WHERE `l`.`rel_type` = 'help' AND `l`.`rel_id` IN ('29','36','37') GROUP BY `t`.`name` ORDER BY COUNT(*) DESC LIMIT 12 [ RunTime:0.000386s ]
SELECT `id` FROM `idcsmart_addon_idcsmart_help` WHERE `hidden` = 0 AND `addon_idcsmart_help_type_id` = 3 AND `id` <> 36 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263185 ) ) ORDER BY RAND() LIMIT 6 [ RunTime:0.000501s ]
SELECT `id`,`title`,`read` FROM `idcsmart_addon_idcsmart_help` WHERE `id` IN (29,37) AND `hidden` = 0 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263185 ) ) ORDER BY FIELD(id,29,37) LIMIT 6 [ RunTime:0.000473s ]