SHOW FULL COLUMNS FROM `xycms_company` [ RunTime:0.000866s ]
SHOW FULL COLUMNS FROM `xycms_jobs` [ RunTime:0.000737s ]
SHOW FULL COLUMNS FROM `xycms_resume` [ RunTime:0.000715s ]
SHOW FULL COLUMNS FROM `xycms_ads_position` [ RunTime:0.000719s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000513s ]
SHOW FULL COLUMNS FROM `xycms_ads` [ RunTime:0.000568s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000546s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000501s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000450s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000399s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000438s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) 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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000458s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000404s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000441s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000402s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000442s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000392s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000444s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) 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` = 6 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000525s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000374s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000421s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000382s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000393s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) 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` = 32 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000405s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000443s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000663s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) 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` = 31 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000452s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) 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` = 1 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000456s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000408s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000447s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) 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` = 5 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000421s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000396s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000441s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000405s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000436s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000590s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000421s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) LIMIT 1 [ RunTime:0.000618s ]
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 ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000413s ]
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` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) 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` = 32 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1764537237 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1764537237) OR (`start_time` < 1764537237 AND `end_time` > 1764537237) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000419s ]