SHOW FULL COLUMNS FROM `xy_api_log` [ RunTime:0.003216s ]
SELECT COUNT(*) AS think_count FROM `xy_api_log` WHERE `ip` = '44.200.112.172' AND `create_time` BETWEEN 1686156365 AND 1686156369 [ RunTime:0.002765s ]
SHOW FULL COLUMNS FROM `xy_article` [ RunTime:0.003152s ]
SELECT `article`.`id`,`article`.`create_time`,`article`.`start_time`,`article`.`end_time`,`article`.`title`,`article`.`view`,`article`.`alias`,`article`.`source`,`article`.`desc`,`content`.`content`,`article`.`status_alias`,`article`.`qrcode`,`article`.`thumb`,`article`.`cla` FROM `xy_article` `article` INNER JOIN `xy_article_content` `content` ON `content`.`tid`=`article`.`id` WHERE ( `article`.`alias` = 'about' AND `article`.`status` = 1 AND ( (`article`.`start_time` IS NULL AND `article`.`end_time` IS NULL) OR (`article`.`start_time` < 1686156368 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1686156368) OR (`article`.`start_time` < 1686156368 AND `article`.`end_time` > 1686156368) ) ) AND `article`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.003038s ]
SELECT `article`.`id`,`article`.`cid`,`cate`.`title`,`cate`.`alias` FROM `xy_article` `article` INNER JOIN `xy_article_cate` `cate` ON `cate`.`id`=`article`.`cid` WHERE ( `article`.`id` = 1 ) AND `article`.`delete_time` IS NULL ORDER BY `cate`.`sort` ASC LIMIT 1 [ RunTime:0.002914s ]
SELECT `id`,`title` FROM `xy_article` WHERE ( `cid` = 2 AND `status` = 1 AND `id` < 1 ) AND `xy_article`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002748s ]
SELECT `id`,`title` FROM `xy_article` WHERE ( `cid` = 2 AND `status` = 1 AND `id` > 1 ) AND `xy_article`.`delete_time` IS NULL ORDER BY `id` ASC LIMIT 1 [ RunTime:0.002838s ]
UPDATE `xy_article` SET `view` = `view` + 2 WHERE ( `id` = 1 ) AND `xy_article`.`delete_time` IS NULL [ RunTime:0.002825s ]
SHOW FULL COLUMNS FROM `xy_status_alias` [ RunTime:0.003046s ]
SELECT `value`,`title`,`type` FROM `xy_status_alias` WHERE `alias` = 'feedback/type' AND `status` = 1 ORDER BY `value` ASC [ RunTime:0.002729s ]
SHOW FULL COLUMNS FROM `xy_ads_position` [ RunTime:0.003039s ]
SELECT * FROM `xy_ads_position` WHERE `app_id` = 1 AND `alias` = 'footer' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1686156368 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1686156368) OR (`start_time` < 1686156368 AND `end_time` > 1686156368) ) LIMIT 1 [ RunTime:0.002825s ]
SHOW FULL COLUMNS FROM `xy_ads` [ RunTime:0.003081s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 14 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1686156368 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1686156368) OR (`start_time` < 1686156368 AND `end_time` > 1686156368) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.002814s ]