SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartSubAccount' LIMIT 1 [ RunTime:0.000308s ]
SELECT * FROM `idcsmart_addon_idcsmart_sub_account` WHERE `client_id` = 0 LIMIT 1 [ RunTime:0.000268s ]
SELECT * FROM `idcsmart_client` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000269s ]
SHOW FULL COLUMNS FROM `idcsmart_template_my_config` [ RunTime:0.001353s ]
SELECT `value` FROM `idcsmart_template_my_config` WHERE `setting` = 'template_header' LIMIT 1 [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `idcsmart_plugin` [ RunTime:0.000839s ]
SELECT `id`,`name`,`title`,`url`,`config` FROM `idcsmart_plugin` WHERE ( `module` = 'addon' AND `status` = 1 ) ORDER BY `order` ASC,`id` ASC [ RunTime:0.000768s ]
SELECT * FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartCertification' AND `status` = 1 LIMIT 1 [ RunTime:0.000379s ]
SELECT * FROM `idcsmart_seo` WHERE `page_address` = 'articleInfo.html' LIMIT 1 [ RunTime:0.000999s ]
SELECT * FROM `idcsmart_template_my_config` WHERE `setting` = 'template_header' LIMIT 1 [ RunTime:0.000266s ]
SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartNews' LIMIT 1 [ RunTime:0.000208s ]
SELECT `config` FROM `idcsmart_plugin` WHERE `name` = 'IdcsmartAnnouncement' LIMIT 1 [ RunTime:0.000172s ]
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.002474s ]
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.001291s ]
SELECT `id`,`name` FROM `idcsmart_bottom_bar_group` WHERE `theme` = 'my' ORDER BY `order` ASC [ RunTime:0.001053s ]
SELECT `id`,`name`,`icon`,`content` FROM `idcsmart_side_floating_window` ORDER BY `order` ASC [ RunTime:0.001021s ]
SELECT `id`,`name`,`url` FROM `idcsmart_friendly_link` [ RunTime:0.001065s ]
SELECT `id`,`name`,`img` FROM `idcsmart_honor` [ RunTime:0.000915s ]
SELECT `id`,`name`,`img`,`description` FROM `idcsmart_partner` [ RunTime:0.001071s ]
SELECT `setting`,`value` FROM `idcsmart_template_my_config` [ RunTime:0.000794s ]
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.002167s ]
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.001897s ]
SELECT `id`,`name` FROM `idcsmart_plugin` WHERE `module` = 'addon' AND `status` = 1 [ RunTime:0.000208s ]
SHOW FULL COLUMNS FROM `idcsmart_addon_idcsmart_news` [ RunTime:0.001377s ]
SELECT `a`.`id`,`a`.`title`,`a`.`content`,`a`.`keywords`,`a`.`read`,`a`.`create_time`,`a`.`update_time`,a.addon_idcsmart_news_type_id as type_id,t.name as type_name,`a`.`cron_release`,`a`.`cron_release_time` FROM `idcsmart_addon_idcsmart_news` `a` LEFT JOIN `idcsmart_addon_idcsmart_news_type` `t` ON `t`.`id`=`a`.`addon_idcsmart_news_type_id` WHERE `a`.`id` = '1' AND `a`.`hidden` = '0' AND ( `a`.`cron_release` = '0' OR ( `a`.`cron_release` = '1' AND `a`.`cron_release_time` <= '1779263235' ) ) LIMIT 1 [ RunTime:0.001200s ]
UPDATE `idcsmart_addon_idcsmart_news` SET `read` = `read` + 1 WHERE `id` = 1 [ RunTime:0.002010s ]
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.002716s ]
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.001086s ]
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` = 'news' AND `l`.`rel_id` = '1' ORDER BY `l`.`id` ASC [ RunTime:0.000282s ]
SELECT `id`,`title` FROM `idcsmart_addon_idcsmart_news` WHERE ( `hidden` = 0 AND `addon_idcsmart_news_type_id` = 1 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263235 ) ) ) AND `id` > 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`title` FROM `idcsmart_addon_idcsmart_news` WHERE ( `hidden` = 0 AND `addon_idcsmart_news_type_id` = 1 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263235 ) ) ) AND `id` < 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000270s ]
SHOW FULL COLUMNS FROM `idcsmart_article_tag` [ RunTime:0.000492s ]
SELECT `id` FROM `idcsmart_article_tag` WHERE `name` = '香港服务器' [ RunTime:0.000159s ]
SHOW FULL COLUMNS FROM `idcsmart_article_tag_link` [ RunTime:0.000444s ]
SELECT `rel_id` FROM `idcsmart_article_tag_link` WHERE `rel_type` = 'news' AND `tag_id` = 1 AND `rel_id` <> 1 GROUP BY `rel_id` [ RunTime:0.000182s ]
SELECT `id` FROM `idcsmart_addon_idcsmart_news` WHERE `hidden` = 0 AND `addon_idcsmart_news_type_id` = 1 LIMIT 80 [ RunTime:0.000238s ]
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` = 'news' AND `l`.`rel_id` = '1' GROUP BY `t`.`name` ORDER BY COUNT(*) DESC LIMIT 12 [ RunTime:0.000227s ]
SELECT `id` FROM `idcsmart_addon_idcsmart_news` WHERE `hidden` = 0 AND `addon_idcsmart_news_type_id` = 1 AND `id` <> 1 AND ( `cron_release` = 0 OR ( `cron_release` = 1 AND `cron_release_time` <= 1779263235 ) ) ORDER BY RAND() LIMIT 6 [ RunTime:0.000308s ]
SELECT `id`,`name` FROM `idcsmart_plugin` WHERE `module` = 'addon' AND `status` = 1 [ RunTime:0.000169s ]