SHOW FULL COLUMNS FROM `xy_api_log` [ RunTime:0.002300s ]
SELECT COUNT(*) AS think_count FROM `xy_api_log` WHERE `ip` = '44.200.82.149' AND `create_time` BETWEEN 1685656701 AND 1685656705 [ RunTime:0.001822s ]
SHOW FULL COLUMNS FROM `xy_status_alias` [ RunTime:0.002144s ]
SELECT `value`,`title`,`type` FROM `xy_status_alias` WHERE `alias` = 'feedback/type' AND `status` = 1 ORDER BY `value` ASC [ RunTime:0.001843s ]
SHOW FULL COLUMNS FROM `xy_job_fair` [ RunTime:0.002383s ]
SELECT COUNT(*) AS think_count FROM `xy_job_fair` `job` INNER JOIN `xy_job_fair_content` `content` ON `content`.`jid`=`job`.`id` LEFT JOIN `xy_area` `province` ON `province`.`id`=`content`.`job_fair_area1` LEFT JOIN `xy_area` `city` ON `city`.`id`=`content`.`job_fair_area2` LEFT JOIN `xy_area` `area` ON `area`.`id`=`content`.`job_fair_area3` WHERE `job`.`delete_time` IS NULL [ RunTime:0.002177s ]
SELECT `job`.*,province.title as job_fair_province,city.title as job_fair_city,area.title as job_fair_area,`content`.`address` FROM `xy_job_fair` `job` INNER JOIN `xy_job_fair_content` `content` ON `content`.`jid`=`job`.`id` LEFT JOIN `xy_area` `province` ON `province`.`id`=`content`.`job_fair_area1` LEFT JOIN `xy_area` `city` ON `city`.`id`=`content`.`job_fair_area2` LEFT JOIN `xy_area` `area` ON `area`.`id`=`content`.`job_fair_area3` WHERE `job`.`delete_time` IS NULL ORDER BY `job`.`sort` ASC,`job`.`id` DESC LIMIT 0,10 [ RunTime:0.002087s ]
SHOW FULL COLUMNS FROM `xy_job_fair_company` [ RunTime:0.002144s ]
SELECT `company_id` FROM `xy_job_fair_company` WHERE `jid` = 10 [ RunTime:0.001695s ]
SHOW FULL COLUMNS FROM `xy_jobs` [ RunTime:0.002176s ]
SELECT COUNT(*) AS think_count FROM `xy_jobs` WHERE ( `company_id` IN ('') AND `status` = 1 ) AND `xy_jobs`.`delete_time` IS NULL [ RunTime:0.001989s ]
SELECT `company_id` FROM `xy_job_fair_company` WHERE `jid` = 8 [ RunTime:0.001754s ]
SELECT COUNT(*) AS think_count FROM `xy_jobs` WHERE ( `company_id` IN (70,77,109,159,177,178) AND `status` = 1 ) AND `xy_jobs`.`delete_time` IS NULL [ RunTime:0.001935s ]
SELECT `company_id` FROM `xy_job_fair_company` WHERE `jid` = 7 [ RunTime:0.001764s ]
SELECT COUNT(*) AS think_count FROM `xy_jobs` WHERE ( `company_id` = 14 AND `status` = 1 ) AND `xy_jobs`.`delete_time` IS NULL [ RunTime:0.001980s ]
SHOW FULL COLUMNS FROM `xy_ads_position` [ RunTime:0.002077s ]
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` < 1685656704 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1685656704) OR (`start_time` < 1685656704 AND `end_time` > 1685656704) ) LIMIT 1 [ RunTime:0.001885s ]
SHOW FULL COLUMNS FROM `xy_ads` [ RunTime:0.002141s ]
SELECT `id`,`title`,`path`,`url`,url as imgurl,`ads_icon`,`col`,`bg_color`,bg_color as set_type FROM `xy_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` < 1685656704 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1685656704) OR (`start_time` < 1685656704 AND `end_time` > 1685656704) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.001953s ]