SHOW FULL COLUMNS FROM `xy_company` [ RunTime:0.001457s ]
SHOW FULL COLUMNS FROM `xy_jobs` [ RunTime:0.001138s ]
SHOW FULL COLUMNS FROM `xy_resume` [ RunTime:0.001096s ]
SHOW FULL COLUMNS FROM `xy_ads_position` [ RunTime:0.000979s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `xy_ads` [ RunTime:0.000973s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000659s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000486s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000540s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000432s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000700s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000483s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000538s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000548s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000479s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000439s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000553s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000407s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000676s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000419s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000506s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000422s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000512s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) 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` = 25 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000431s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000439s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000556s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000622s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000553s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000437s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000435s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000474s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000557s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000409s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000503s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000409s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000532s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000334s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 100 [ RunTime:0.000494s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) 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 `xy_ads` WHERE `pid` = 6 AND `status` = 1 AND ( (`start_time` IS NULL AND `end_time` IS NULL) OR (`start_time` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000429s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000385s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.000401s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000357s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000403s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) LIMIT 1 [ RunTime:0.000370s ]
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` < 1751517193 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1751517193) OR (`start_time` < 1751517193 AND `end_time` > 1751517193) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000439s ]