SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartSubAccount' LIMIT 1 [ RunTime:0.000364s ]
SELECT * FROM `idcsmart_addon_idcsmart_sub_account` WHERE `client_id` = 0 LIMIT 1 [ RunTime:0.000319s ]
SELECT * FROM `idcsmart_client` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000315s ]
SHOW FULL COLUMNS FROM `idcsmart_template_my_config` [ RunTime:0.002353s ]
SELECT `value` FROM `idcsmart_template_my_config` WHERE `setting` = 'template_header' LIMIT 1 [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `idcsmart_plugin` [ RunTime:0.001805s ]
SELECT `id`,`name`,`title`,`url`,`config` FROM `idcsmart_plugin` WHERE ( `module` = 'addon' AND `status` = 1 ) ORDER BY `order` ASC,`id` ASC [ RunTime:0.000495s ]
SELECT * FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartCertification' AND `status` = 1 LIMIT 1 [ RunTime:0.000382s ]
SELECT * FROM `idcsmart_seo` WHERE `page_address` = 'articleInfo.html' LIMIT 1 [ RunTime:0.001026s ]
SELECT * FROM `idcsmart_template_my_config` WHERE `setting` = 'template_header' LIMIT 1 [ RunTime:0.000450s ]
SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartNews' LIMIT 1 [ RunTime:0.000419s ]
SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartAnnouncement' LIMIT 1 [ RunTime:0.000283s ]
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.001043s ]
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.000958s ]
SELECT `id`,`name` FROM `idcsmart_bottom_bar_group` WHERE `theme` = 'my' ORDER BY `order` ASC [ RunTime:0.000833s ]
SELECT `id`,`name`,`icon`,`content` FROM `idcsmart_side_floating_window` ORDER BY `order` ASC [ RunTime:0.000817s ]
SELECT `id`,`name`,`url` FROM `idcsmart_friendly_link` [ RunTime:0.001133s ]
SELECT `id`,`name`,`img` FROM `idcsmart_honor` [ RunTime:0.001126s ]
SELECT `id`,`name`,`img`,`description` FROM `idcsmart_partner` [ RunTime:0.001104s ]
SELECT `setting`,`value` FROM `idcsmart_template_my_config` [ RunTime:0.000593s ]
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.003054s ]
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.002460s ]
SHOW FULL COLUMNS FROM `idcsmart_addon_idcsmart_help` [ RunTime:0.001562s ]
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` = '35' AND `a`.`hidden` = '0' AND ( `a`.`cron_release` = '0' OR ( `a`.`cron_release` = '1' AND `a`.`cron_release_time` <= '1779263187' ) ) LIMIT 1 [ RunTime:0.001621s ]
UPDATE `idcsmart_addon_idcsmart_help` SET `read` = `read` + 1 WHERE `id` = 35 [ RunTime:0.002609s ]
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.001957s ]
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.001148s ]
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` = '35' ORDER BY `l`.`id` ASC [ RunTime:0.000242s ]
SELECT `id`,`title` FROM `idcsmart_addon_idcsmart_help` WHERE ( `hidden` = 0 AND `addon_idcsmart_help_type_id` = 2 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263187 ) ) ) AND `id` < 35 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`title` FROM `idcsmart_addon_idcsmart_help` WHERE ( `hidden` = 0 AND `addon_idcsmart_help_type_id` = 2 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263187 ) ) ) AND `id` > 35 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001041s ]
SELECT `id` FROM `idcsmart_addon_idcsmart_help` WHERE `hidden` = 0 AND `addon_idcsmart_help_type_id` = 2 LIMIT 80 [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `idcsmart_article_tag` [ RunTime:0.000758s ]
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 ('31','32','33','34','35') GROUP BY `t`.`name` ORDER BY COUNT(*) DESC LIMIT 12 [ RunTime:0.000300s ]
SELECT `id` FROM `idcsmart_addon_idcsmart_help` WHERE `hidden` = 0 AND `addon_idcsmart_help_type_id` = 2 AND `id` <> 35 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263187 ) ) ORDER BY RAND() LIMIT 6 [ RunTime:0.000508s ]
SELECT `id`,`title`,`read` FROM `idcsmart_addon_idcsmart_help` WHERE `id` IN (33,31,34,32) AND `hidden` = 0 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263187 ) ) ORDER BY FIELD(id,33,31,34,32) LIMIT 6 [ RunTime:0.000612s ]