SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartSubAccount' LIMIT 1 [ RunTime:0.000504s ]
SELECT * FROM `idcsmart_addon_idcsmart_sub_account` WHERE `client_id` = 0 LIMIT 1 [ RunTime:0.000429s ]
SELECT * FROM `idcsmart_client` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `idcsmart_template_my_config` [ RunTime:0.001626s ]
SELECT `value` FROM `idcsmart_template_my_config` WHERE `setting` = 'template_header' LIMIT 1 [ RunTime:0.000411s ]
SHOW FULL COLUMNS FROM `idcsmart_plugin` [ RunTime:0.000741s ]
SELECT `id`,`name`,`title`,`url`,`config` FROM `idcsmart_plugin` WHERE ( `module` = 'addon' AND `status` = 1 ) ORDER BY `order` ASC,`id` ASC [ RunTime:0.000412s ]
SELECT * FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartCertification' AND `status` = 1 LIMIT 1 [ RunTime:0.000488s ]
SELECT * FROM `idcsmart_seo` WHERE `page_address` = 'articleInfo.html' LIMIT 1 [ RunTime:0.001147s ]
SELECT * FROM `idcsmart_template_my_config` WHERE `setting` = 'template_header' LIMIT 1 [ RunTime:0.000439s ]
SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartNews' LIMIT 1 [ RunTime:0.000400s ]
SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartAnnouncement' LIMIT 1 [ RunTime:0.000416s ]
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.001060s ]
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.001106s ]
SELECT `id`,`name` FROM `idcsmart_bottom_bar_group` WHERE `theme` = 'my' ORDER BY `order` ASC [ RunTime:0.001022s ]
SELECT `id`,`name`,`icon`,`content` FROM `idcsmart_side_floating_window` ORDER BY `order` ASC [ RunTime:0.000975s ]
SELECT `id`,`name`,`url` FROM `idcsmart_friendly_link` [ RunTime:0.001012s ]
SELECT `id`,`name`,`img` FROM `idcsmart_honor` [ RunTime:0.001015s ]
SELECT `id`,`name`,`img`,`description` FROM `idcsmart_partner` [ RunTime:0.001033s ]
SELECT `setting`,`value` FROM `idcsmart_template_my_config` [ RunTime:0.000419s ]
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.002945s ]
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.002178s ]
SHOW FULL COLUMNS FROM `idcsmart_addon_idcsmart_help` [ RunTime:0.001531s ]
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` = '33' AND `a`.`hidden` = '0' AND ( `a`.`cron_release` = '0' OR ( `a`.`cron_release` = '1' AND `a`.`cron_release_time` <= '1779266842' ) ) LIMIT 1 [ RunTime:0.001621s ]
UPDATE `idcsmart_addon_idcsmart_help` SET `read` = `read` + 1 WHERE `id` = 33 [ RunTime:0.003244s ]
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.002836s ]
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.001714s ]
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` = '33' ORDER BY `l`.`id` ASC [ RunTime:0.000476s ]
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` <= 1779266842 ) ) ) AND `id` < 33 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
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` <= 1779266842 ) ) ) AND `id` > 33 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id` FROM `idcsmart_addon_idcsmart_help` WHERE `hidden` = 0 AND `addon_idcsmart_help_type_id` = 2 LIMIT 80 [ RunTime:0.000499s ]
SHOW FULL COLUMNS FROM `idcsmart_article_tag` [ RunTime:0.000729s ]
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.000430s ]
SELECT `id` FROM `idcsmart_addon_idcsmart_help` WHERE `hidden` = 0 AND `addon_idcsmart_help_type_id` = 2 AND `id` <> 33 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779266842 ) ) ORDER BY RAND() LIMIT 6 [ RunTime:0.000711s ]
SELECT `id`,`title`,`read` FROM `idcsmart_addon_idcsmart_help` WHERE `id` IN (34,32,31,35) AND `hidden` = 0 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779266842 ) ) ORDER BY FIELD(id,34,32,31,35) LIMIT 6 [ RunTime:0.000531s ]