SHOW FULL COLUMNS FROM `xy_company` [ RunTime:0.001139s ]
SELECT COUNT(*) AS think_count FROM `xy_company` WHERE `xy_company`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000535s ]
SHOW FULL COLUMNS FROM `xy_jobs` [ RunTime:0.001144s ]
SELECT COUNT(*) AS think_count FROM `xy_jobs` WHERE `xy_jobs`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000690s ]
SHOW FULL COLUMNS FROM `xy_resume` [ RunTime:0.000733s ]
SELECT COUNT(*) AS think_count FROM `xy_resume` WHERE `xy_resume`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000724s ]
SHOW FULL COLUMNS FROM `xy_ads_position` [ RunTime:0.000582s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `xy_ads` [ RunTime:0.000681s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 37 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000447s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 30 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 31 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 1 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000427s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000714s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 121 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000891s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 5 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 5 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000702s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) 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 `xy_ads` WHERE `pid` = 6 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) 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 `xy_ads` WHERE `pid` = 14 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000430s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 25 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 32 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 30 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) 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 `xy_ads` WHERE `pid` = 31 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 1 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000485s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 121 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000438s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) 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 `xy_ads` WHERE `pid` = 5 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 5 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000632s ]
SELECT * FROM `xy_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` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) 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 `xy_ads` WHERE `pid` = 6 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781791 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781791) OR (`start_time` < 1757781791 AND `end_time` > 1757781791) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT * FROM `xy_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` < 1757781792 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781792) OR (`start_time` < 1757781792 AND `end_time` > 1757781792) ) 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 `xy_ads` WHERE `pid` = 14 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781792 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781792) OR (`start_time` < 1757781792 AND `end_time` > 1757781792) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000406s ]
SELECT * FROM `xy_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` < 1757781792 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781792) OR (`start_time` < 1757781792 AND `end_time` > 1757781792) ) LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 25 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781792 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781792) OR (`start_time` < 1757781792 AND `end_time` > 1757781792) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT * FROM `xy_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` < 1757781792 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781792) OR (`start_time` < 1757781792 AND `end_time` > 1757781792) ) LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`title`,`path`,`url`,`type`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_ads` WHERE `pid` = 32 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1757781792 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1757781792) OR (`start_time` < 1757781792 AND `end_time` > 1757781792) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000428s ]