SHOW FULL COLUMNS FROM `xycms_company` [ RunTime:0.000721s ]
SELECT COUNT(*) AS think_count FROM `xycms_company` WHERE `xycms_company`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000679s ]
SHOW FULL COLUMNS FROM `xycms_jobs` [ RunTime:0.000628s ]
SELECT COUNT(*) AS think_count FROM `xycms_jobs` WHERE `xycms_jobs`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001678s ]
SHOW FULL COLUMNS FROM `xycms_resume` [ RunTime:0.000636s ]
SELECT COUNT(*) AS think_count FROM `xycms_resume` WHERE `xycms_resume`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000319s ]
SHOW FULL COLUMNS FROM `xycms_ads_position` [ RunTime:0.000626s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000501s ]
SHOW FULL COLUMNS FROM `xycms_ads` [ RunTime:0.000654s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 37 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000515s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 30 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000501s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 31 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000444s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 1 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000486s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 121 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000553s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 5 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000461s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 5 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000472s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 6 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000450s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 25 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000426s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 32 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT count(jobs_cate3) as countCate,jobs_cate3 as cate FROM `xycms_jobs` `jobs` WHERE ( `jobs`.`status` = '1' AND `jobs`.`jobs_area1` = '12' AND `jobs`.`jobs_area2` = '132' AND `jobs`.`examine` IN ('0','1') ) AND `jobs`.`delete_time` IS NULL GROUP BY `jobs_cate3` HAVING count(jobs_cate3)>1 ORDER BY `countCate` DESC LIMIT 9 [ RunTime:0.000576s ]
SHOW FULL COLUMNS FROM `xycms_jobs_cate` [ RunTime:0.000576s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 221 LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000305s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.001076s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 30 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000569s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 31 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000526s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 1 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000448s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 121 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000407s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 5 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000479s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 5 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000448s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000726s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 6 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000563s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000425s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 25 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000445s ]
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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xycms_ads` WHERE `pid` = 32 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` < 1750454318 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1750454318) OR (`start_time` < 1750454318 AND `end_time` > 1750454318) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000412s ]