SHOW FULL COLUMNS FROM `xycms_api_log` [ RunTime:0.000779s ]
SELECT COUNT(*) AS think_count FROM `xycms_api_log` WHERE `ip` = '52.14.120.83' AND `create_time` BETWEEN 1730241207 AND 1730241211 [ RunTime:0.000367s ]
SHOW FULL COLUMNS FROM `xycms_company` [ RunTime:0.000768s ]
SELECT COUNT(*) AS think_count FROM `xycms_company` WHERE `xycms_company`.`delete_time` IS NULL [ RunTime:0.000966s ]
SHOW FULL COLUMNS FROM `xycms_jobs` [ RunTime:0.000698s ]
SELECT COUNT(*) AS think_count FROM `xycms_jobs` WHERE `xycms_jobs`.`delete_time` IS NULL [ RunTime:0.001702s ]
SHOW FULL COLUMNS FROM `xycms_resume` [ RunTime:0.000645s ]
SELECT COUNT(*) AS think_count FROM `xycms_resume` WHERE `xycms_resume`.`delete_time` IS NULL [ RunTime:0.002178s ]
SHOW FULL COLUMNS FROM `xycms_ads_position` [ RunTime:0.000539s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) LIMIT 1 [ RunTime:0.000655s ]
SHOW FULL COLUMNS FROM `xycms_ads` [ RunTime:0.000674s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000510s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) LIMIT 1 [ RunTime:0.000381s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000369s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) 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` = 31 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000287s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) LIMIT 1 [ RunTime:0.000338s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000389s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) LIMIT 1 [ RunTime:0.000291s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000320s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) LIMIT 1 [ RunTime:0.000297s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000308s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) LIMIT 1 [ RunTime:0.000337s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000393s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) LIMIT 1 [ RunTime:0.000322s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000365s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) LIMIT 1 [ RunTime:0.000319s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000326s ]
SHOW FULL COLUMNS FROM `xycms_article_cate` [ RunTime:0.000687s ]
SELECT * FROM `xycms_article_cate` WHERE `alias` = 'workplace' LIMIT 1 [ RunTime:0.000332s ]
SHOW FULL COLUMNS FROM `xycms_article` [ RunTime:0.000568s ]
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` < 1730241210 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1730241210) OR (`article`.`start_time` < 1730241210 AND `article`.`end_time` > 1730241210) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`sort` ASC,`article`.`update_time` DESC,`article`.`id` DESC LIMIT 20 [ RunTime:0.005272s ]
SELECT * FROM `xycms_article_cate` WHERE `alias` = 'hot' LIMIT 1 [ RunTime:0.000366s ]
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` < 1730241210 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1730241210) OR (`article`.`start_time` < 1730241210 AND `article`.`end_time` > 1730241210) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`sort` ASC,`article`.`update_time` DESC,`article`.`id` DESC LIMIT 20 [ RunTime:0.000416s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) LIMIT 1 [ RunTime:0.000307s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000296s ]
SHOW FULL COLUMNS FROM `xycms_links` [ RunTime:0.000650s ]
SELECT `title`,`url` FROM `xycms_links` WHERE `status` = 1 AND `is_examine` = 1 ORDER BY `sort` ASC LIMIT 100 [ RunTime:0.000341s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) LIMIT 1 [ RunTime:0.000342s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000372s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) LIMIT 1 [ RunTime:0.000307s ]
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` < 1730241210 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1730241210) OR (`start_time` < 1730241210 AND `end_time` > 1730241210) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `xycms_jobs_cate` [ RunTime:0.000792s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000214s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000163s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000193s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 78 LIMIT 1 [ RunTime:0.000161s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000173s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 69 LIMIT 1 [ RunTime:0.000219s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 46 LIMIT 1 [ RunTime:0.000227s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 94 LIMIT 1 [ RunTime:0.000179s ]
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.000352s ]
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.000393s ]
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.000317s ]
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.000363s ]
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.000376s ]
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.000364s ]
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.000416s ]
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.000325s ]
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.000272s ]
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.000387s ]
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.000299s ]
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.000337s ]
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.000247s ]
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.000293s ]
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.000284s ]
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.000465s ]
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.000327s ]
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.000352s ]
SELECT * FROM `xycms_article_cate` WHERE `alias` = 'workplace' LIMIT 1 [ RunTime:0.000331s ]
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.000470s ]
SELECT * FROM `xycms_article_cate` WHERE `alias` = 'hot' LIMIT 1 [ RunTime:0.000306s ]
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.000475s ]
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.000426s ]
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.000384s ]
SELECT `title`,`url` FROM `xycms_links` WHERE `status` = 1 AND `is_examine` = 1 ORDER BY `sort` ASC LIMIT 100 [ RunTime:0.000324s ]
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.000329s ]
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.000392s ]
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.000315s ]
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.000359s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000283s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000213s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000247s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000219s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 78 LIMIT 1 [ RunTime:0.000180s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000216s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 69 LIMIT 1 [ RunTime:0.000196s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 46 LIMIT 1 [ RunTime:0.000175s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 94 LIMIT 1 [ RunTime:0.000239s ]
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.000300s ]
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.000398s ]