SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartSubAccount' LIMIT 1 [ RunTime:0.000433s ]
SELECT * FROM `idcsmart_addon_idcsmart_sub_account` WHERE `client_id` = 0 LIMIT 1 [ RunTime:0.000450s ]
SELECT * FROM `idcsmart_client` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000503s ]
SHOW FULL COLUMNS FROM `idcsmart_template_my_config` [ RunTime:0.001226s ]
SELECT `value` FROM `idcsmart_template_my_config` WHERE `setting` = 'template_header' LIMIT 1 [ RunTime:0.000375s ]
SHOW FULL COLUMNS FROM `idcsmart_plugin` [ RunTime:0.001016s ]
SELECT `id`,`name`,`title`,`url`,`config` FROM `idcsmart_plugin` WHERE ( `module` = 'addon' AND `status` = 1 ) ORDER BY `order` ASC,`id` ASC [ RunTime:0.000470s ]
SELECT * FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartCertification' AND `status` = 1 LIMIT 1 [ RunTime:0.000626s ]
SELECT * FROM `idcsmart_seo` WHERE `page_address` = 'articleInfo.html' LIMIT 1 [ RunTime:0.001494s ]
SELECT * FROM `idcsmart_template_my_config` WHERE `setting` = 'template_header' LIMIT 1 [ RunTime:0.000461s ]
SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartNews' LIMIT 1 [ RunTime:0.000391s ]
SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartAnnouncement' LIMIT 1 [ RunTime:0.000388s ]
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.001086s ]
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.001256s ]
SELECT `id`,`name` FROM `idcsmart_bottom_bar_group` WHERE `theme` = 'my' ORDER BY `order` ASC [ RunTime:0.001110s ]
SELECT `id`,`name`,`icon`,`content` FROM `idcsmart_side_floating_window` ORDER BY `order` ASC [ RunTime:0.001012s ]
SELECT `id`,`name`,`url` FROM `idcsmart_friendly_link` [ RunTime:0.001634s ]
SELECT `id`,`name`,`img` FROM `idcsmart_honor` [ RunTime:0.001117s ]
SELECT `id`,`name`,`img`,`description` FROM `idcsmart_partner` [ RunTime:0.001468s ]
SELECT `setting`,`value` FROM `idcsmart_template_my_config` [ RunTime:0.000424s ]
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.003052s ]
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.003030s ]
SHOW FULL COLUMNS FROM `idcsmart_addon_idcsmart_help` [ RunTime:0.001655s ]
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` = '37' AND `a`.`hidden` = '0' AND ( `a`.`cron_release` = '0' OR ( `a`.`cron_release` = '1' AND `a`.`cron_release_time` <= '1779263186' ) ) LIMIT 1 [ RunTime:0.001153s ]
UPDATE `idcsmart_addon_idcsmart_help` SET `read` = `read` + 1 WHERE `id` = 37 [ RunTime:0.002727s ]
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.002598s ]
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.001428s ]
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` = '37' ORDER BY `l`.`id` ASC [ RunTime:0.000380s ]
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` <= 1779263186 ) ) ) AND `id` < 37 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
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` <= 1779263186 ) ) ) AND `id` > 37 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000905s ]
SELECT `id` FROM `idcsmart_addon_idcsmart_help` WHERE `hidden` = 0 AND `addon_idcsmart_help_type_id` = 3 LIMIT 80 [ RunTime:0.000736s ]
SHOW FULL COLUMNS FROM `idcsmart_article_tag` [ RunTime:0.001004s ]
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.000389s ]
SELECT `id` FROM `idcsmart_addon_idcsmart_help` WHERE `hidden` = 0 AND `addon_idcsmart_help_type_id` = 3 AND `id` <> 37 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263186 ) ) ORDER BY RAND() LIMIT 6 [ RunTime:0.000571s ]
SELECT `id`,`title`,`read` FROM `idcsmart_addon_idcsmart_help` WHERE `id` IN (29,36) AND `hidden` = 0 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263186 ) ) ORDER BY FIELD(id,29,36) LIMIT 6 [ RunTime:0.000516s ]