SHOW FULL COLUMNS FROM `xy_api_log` [ RunTime:0.002178s ]
SELECT COUNT(*) AS think_count FROM `xy_api_log` WHERE `ip` = '44.200.82.149' AND `create_time` BETWEEN 1685661398 AND 1685661402 [ RunTime:0.001803s ]
SHOW FULL COLUMNS FROM `xy_article_cate` [ RunTime:0.002163s ]
SELECT * FROM `xy_article_cate` WHERE `alias` = 'government_institutions' LIMIT 1 [ RunTime:0.001805s ]
SHOW FULL COLUMNS FROM `xy_article` [ RunTime:0.002097s ]
SELECT COUNT(*) AS think_count FROM `xy_article` `article` WHERE ( `article`.`cid` = 12 AND `article`.`status` = 1 AND ( (`article`.`start_time` IS NULL AND `article`.`end_time` IS NULL) OR (`article`.`start_time` < 1685661401 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1685661401) OR (`article`.`start_time` < 1685661401 AND `article`.`end_time` > 1685661401) ) ) AND `article`.`delete_time` IS NULL [ RunTime:0.001874s ]
SELECT `article`.`id`,`article`.`title`,`article`.`view`,`article`.`thumb`,`article`.`start_time`,`article`.`create_time`,`article`.`desc`,`article`.`status_alias` FROM `xy_article` `article` WHERE ( `article`.`cid` = 12 AND `article`.`status` = 1 AND ( (`article`.`start_time` IS NULL AND `article`.`end_time` IS NULL) OR (`article`.`start_time` < 1685661401 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1685661401) OR (`article`.`start_time` < 1685661401 AND `article`.`end_time` > 1685661401) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`start_time` DESC,`article`.`id` DESC LIMIT 0,10 [ RunTime:0.001915s ]
SHOW FULL COLUMNS FROM `xy_status_alias` [ RunTime:0.001971s ]
SELECT `type`,`title` FROM `xy_status_alias` WHERE `alias` = 'article/status_alias' AND `value` = 1 LIMIT 1 [ RunTime:0.001736s ]
SELECT `value`,`title`,`type` FROM `xy_status_alias` WHERE `alias` = 'feedback/type' AND `status` = 1 ORDER BY `value` ASC [ RunTime:0.001799s ]
SELECT `value`,`title`,`type` FROM `xy_status_alias` WHERE `alias` = 'article/status_alias' AND `status` = 1 ORDER BY `value` ASC [ RunTime:0.001785s ]
SHOW FULL COLUMNS FROM `xy_ads_position` [ RunTime:0.002013s ]
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` < 1685661401 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1685661401) OR (`start_time` < 1685661401 AND `end_time` > 1685661401) ) LIMIT 1 [ RunTime:0.001853s ]
SHOW FULL COLUMNS FROM `xy_ads` [ RunTime:0.002037s ]
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 ( (province is null or province=0) AND (city is null or city=0) AND (area is null or area=0) AND (industry is null or industry=0) ) AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1685661401 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1685661401) OR (`start_time` < 1685661401 AND `end_time` > 1685661401) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.001880s ]