SHOW FULL COLUMNS FROM `xycms_api_log` [ RunTime:0.000650s ]
SELECT COUNT(*) AS think_count FROM `xycms_api_log` WHERE `ip` = '52.14.120.83' AND `create_time` BETWEEN 1730241208 AND 1730241212 [ RunTime:0.000343s ]
SHOW FULL COLUMNS FROM `xycms_company` [ RunTime:0.000766s ]
SELECT COUNT(*) AS think_count FROM `xycms_company` WHERE `xycms_company`.`delete_time` IS NULL [ RunTime:0.000906s ]
SHOW FULL COLUMNS FROM `xycms_jobs` [ RunTime:0.000618s ]
SELECT COUNT(*) AS think_count FROM `xycms_jobs` WHERE `xycms_jobs`.`delete_time` IS NULL [ RunTime:0.001687s ]
SHOW FULL COLUMNS FROM `xycms_resume` [ RunTime:0.000646s ]
SELECT COUNT(*) AS think_count FROM `xycms_resume` WHERE `xycms_resume`.`delete_time` IS NULL [ RunTime:0.002260s ]
SHOW FULL COLUMNS FROM `xycms_ads_position` [ RunTime:0.000450s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'banner_right' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000370s ]
SHOW FULL COLUMNS FROM `xycms_ads` [ RunTime:0.000454s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 37 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000380s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_top_spread' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 30 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000306s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_top_shrink' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000265s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 31 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000272s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_banner' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000261s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 1 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000298s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'banner_bottom' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000255s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 121 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000265s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_a1' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000292s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 5 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000299s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_a1' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000243s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 5 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000297s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_a2' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 6 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_a2' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000256s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 6 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `xycms_article_cate` [ RunTime:0.000494s ]
SELECT * FROM `xycms_article_cate` WHERE `alias` = 'workplace' LIMIT 1 [ RunTime:0.000264s ]
SHOW FULL COLUMNS FROM `xycms_article` [ RunTime:0.000443s ]
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 `xycms_article` `article` WHERE ( `article`.`cid` = 14 AND `article`.`status` = 1 AND ( (`article`.`start_time` IS NULL AND `article`.`end_time` IS NULL) OR (`article`.`start_time` < 1730241211 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1730241211) OR (`article`.`start_time` < 1730241211 AND `article`.`end_time` > 1730241211) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`sort` ASC,`article`.`update_time` DESC,`article`.`id` DESC LIMIT 20 [ RunTime:0.000438s ]
SELECT * FROM `xycms_article_cate` WHERE `alias` = 'hot' LIMIT 1 [ RunTime:0.000264s ]
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 `xycms_article` `article` WHERE ( `article`.`cid` = 11 AND `article`.`status` = 1 AND ( (`article`.`start_time` IS NULL AND `article`.`end_time` IS NULL) OR (`article`.`start_time` < 1730241211 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1730241211) OR (`article`.`start_time` < 1730241211 AND `article`.`end_time` > 1730241211) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`sort` ASC,`article`.`update_time` DESC,`article`.`id` DESC LIMIT 20 [ RunTime:0.000397s ]
SELECT * FROM `xycms_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` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 14 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000316s ]
SHOW FULL COLUMNS FROM `xycms_links` [ RunTime:0.000426s ]
SELECT `title`,`url` FROM `xycms_links` WHERE `status` = 1 AND `is_examine` = 1 ORDER BY `sort` ASC LIMIT 100 [ RunTime:0.000370s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_a3' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000313s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 25 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000280s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_side' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000252s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 32 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000320s ]
SHOW FULL COLUMNS FROM `xycms_jobs_cate` [ RunTime:0.000512s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000214s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000231s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000177s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000237s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 78 LIMIT 1 [ RunTime:0.000219s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000172s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 69 LIMIT 1 [ RunTime:0.000191s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 46 LIMIT 1 [ RunTime:0.000177s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 94 LIMIT 1 [ RunTime:0.000192s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_top_spread' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 30 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_top_spread' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 30 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000295s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_top_shrink' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000252s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 31 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000269s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_banner' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000277s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 1 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000324s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'banner_bottom' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000273s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 121 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000266s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_a1' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000277s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 5 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_a1' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000272s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 5 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000308s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_a2' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000259s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 6 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000294s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_a2' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000235s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 6 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000348s ]
SELECT * FROM `xycms_article_cate` WHERE `alias` = 'workplace' LIMIT 1 [ RunTime:0.000253s ]
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 `xycms_article` `article` WHERE ( `article`.`cid` = 14 AND `article`.`status` = 1 AND ( (`article`.`start_time` IS NULL AND `article`.`end_time` IS NULL) OR (`article`.`start_time` < 1730241211 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1730241211) OR (`article`.`start_time` < 1730241211 AND `article`.`end_time` > 1730241211) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`sort` ASC,`article`.`update_time` DESC,`article`.`id` DESC LIMIT 20 [ RunTime:0.000480s ]
SELECT * FROM `xycms_article_cate` WHERE `alias` = 'hot' LIMIT 1 [ RunTime:0.000287s ]
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 `xycms_article` `article` WHERE ( `article`.`cid` = 11 AND `article`.`status` = 1 AND ( (`article`.`start_time` IS NULL AND `article`.`end_time` IS NULL) OR (`article`.`start_time` < 1730241211 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1730241211) OR (`article`.`start_time` < 1730241211 AND `article`.`end_time` > 1730241211) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`sort` ASC,`article`.`update_time` DESC,`article`.`id` DESC LIMIT 20 [ RunTime:0.000461s ]
SELECT * FROM `xycms_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` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000279s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 14 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000294s ]
SELECT `title`,`url` FROM `xycms_links` WHERE `status` = 1 AND `is_examine` = 1 ORDER BY `sort` ASC LIMIT 100 [ RunTime:0.000245s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_a3' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000302s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 25 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000287s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_side' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000301s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 32 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000286s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000289s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 78 LIMIT 1 [ RunTime:0.000273s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000215s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 69 LIMIT 1 [ RunTime:0.000224s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 46 LIMIT 1 [ RunTime:0.000229s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 94 LIMIT 1 [ RunTime:0.000247s ]
SELECT * FROM `xycms_ads_position` WHERE `app_id` = 1 AND `alias` = 'home_top_spread' AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) LIMIT 1 [ RunTime:0.000309s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 30 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241211 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241211) OR (`start_time` < 1730241211 AND `end_time` > 1730241211) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000405s ]