SHOW FULL COLUMNS FROM `xy_api_log` [ RunTime:0.000683s ]
SELECT COUNT(*) AS think_count FROM `xy_api_log` WHERE `ip` = '18.118.30.253' AND `create_time` BETWEEN 1714609892 AND 1714609896 [ RunTime:0.000445s ]
SHOW FULL COLUMNS FROM `xy_article_cate` [ RunTime:0.001365s ]
SELECT * FROM `xy_article_cate` WHERE `alias` = 'government_institutions' LIMIT 1 [ RunTime:0.000687s ]
SHOW FULL COLUMNS FROM `xy_ads_position` [ RunTime:0.001402s ]
SELECT * FROM `xy_ads_position` WHERE `app_id` = 1 AND `alias` = 'news_banner' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1714609895 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1714609895) OR (`start_time` < 1714609895 AND `end_time` > 1714609895) ) LIMIT 1 [ RunTime:0.000829s ]
SHOW FULL COLUMNS FROM `xy_ads` [ RunTime:0.001193s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 23 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` < 1714609895 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1714609895) OR (`start_time` < 1714609895 AND `end_time` > 1714609895) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000838s ]
SELECT * FROM `xy_article_cate` WHERE `alias` = 'find' LIMIT 1 [ RunTime:0.000670s ]
SELECT `title`,`alias` FROM `xy_article_cate` WHERE `pid` = 4 AND `pc_show` = 1 AND `alias` IS NOT NULL ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000556s ]
SELECT * FROM `xy_article_cate` WHERE `alias` = 'government_institutions' LIMIT 1 [ RunTime:0.000635s ]
SHOW FULL COLUMNS FROM `xy_article` [ RunTime:0.001237s ]
SELECT COUNT(*) AS think_count FROM `xy_article` `article` INNER JOIN `xy_article_cate` `ac` ON `ac`.`id`=`article`.`cid` WHERE ( `cid` = 12 AND `article`.`status` = 1 AND ( 1 = 1 ) AND ( (`article`.`start_time` IS NULL AND `article`.`end_time` IS NULL) OR (`article`.`start_time` < 1714609895 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1714609895) OR (`article`.`start_time` < 1714609895 AND `article`.`end_time` > 1714609895) ) ) AND `article`.`delete_time` IS NULL [ RunTime:0.026343s ]
SELECT ac.title as acTitle,`article`.`id`,`article`.`title`,`article`.`view`,`article`.`thumb`,`article`.`source`,`article`.`start_time`,`article`.`create_time`,`article`.`desc`,`article`.`status_alias`,`article`.`force_alert`,`article`.`cla` FROM `xy_article` `article` INNER JOIN `xy_article_cate` `ac` ON `ac`.`id`=`article`.`cid` WHERE ( `cid` = 12 AND `article`.`status` = 1 AND ( 1 = 1 ) AND ( (`article`.`start_time` IS NULL AND `article`.`end_time` IS NULL) OR (`article`.`start_time` < 1714609895 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1714609895) OR (`article`.`start_time` < 1714609895 AND `article`.`end_time` > 1714609895) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`sort` ASC,`article`.`update_time` DESC,`article`.`id` DESC LIMIT 10620,10 [ RunTime:0.031637s ]
SELECT * FROM `xy_ads_position` WHERE `app_id` = 1 AND `alias` = 'article_list' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1714609895 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1714609895) OR (`start_time` < 1714609895 AND `end_time` > 1714609895) ) LIMIT 1 [ RunTime:0.000766s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 24 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` < 1714609895 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1714609895) OR (`start_time` < 1714609895 AND `end_time` > 1714609895) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000603s ]
SELECT * FROM `xy_article_cate` WHERE `alias` = 'hot' LIMIT 1 [ RunTime:0.000598s ]
SELECT `article`.`id`,`article`.`title`,`article`.`view`,`article`.`thumb`,`article`.`source`,`article`.`start_time`,`article`.`create_time`,`article`.`desc`,`article`.`status_alias`,`article`.`force_alert`,`article`.`cla` FROM `xy_article` `article` WHERE ( `article`.`cid` = 11 AND `article`.`status` = 1 AND ( 1 = 1 AND 1 = 1 AND 1 = 1 ) AND ( (`article`.`start_time` IS NULL AND `article`.`end_time` IS NULL) OR (`article`.`start_time` < 1714609895 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1714609895) OR (`article`.`start_time` < 1714609895 AND `article`.`end_time` > 1714609895) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`sort` ASC,`article`.`update_time` DESC,`article`.`id` DESC LIMIT 20 [ RunTime:0.000871s ]
SELECT * FROM `xy_ads_position` WHERE `app_id` = 1 AND `alias` = 'pc_news_banner' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1714609895 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1714609895) OR (`start_time` < 1714609895 AND `end_time` > 1714609895) ) LIMIT 1 [ RunTime:0.000651s ]