SHOW FULL COLUMNS FROM `xy_api_log` [ RunTime:0.002316s ]
SELECT COUNT(*) AS think_count FROM `xy_api_log` WHERE `ip` = '44.200.82.149' AND `create_time` BETWEEN 1685658958 AND 1685658962 [ RunTime:0.001875s ]
SHOW FULL COLUMNS FROM `xy_company` [ RunTime:0.002447s ]
SELECT `c`.`title`,`c`.`id` FROM `xy_company` `c` INNER JOIN `xy_company_content` `content` ON `content`.`cid`=`c`.`id` INNER JOIN `xy_user` `user` ON `user`.`id`=c.uid AND user.status=1 INNER JOIN `xy_user_vip` `uv` ON `c`.`uid`=`uv`.`uid` WHERE `c`.`delete_time` IS NULL ORDER BY `uv`.`company_vip_level` DESC,`c`.`refresh_time` DESC,`c`.`attestation` DESC LIMIT 10 [ RunTime:0.003390s ]
SELECT `c`.`title`,`c`.`id` FROM `xy_company` `c` INNER JOIN `xy_company_content` `content` ON `content`.`cid`=`c`.`id` INNER JOIN `xy_user` `user` ON `user`.`id`=c.uid AND user.status=1 INNER JOIN `xy_user_vip` `uv` ON `c`.`uid`=`uv`.`uid` WHERE `c`.`delete_time` IS NULL ORDER BY `c`.`refresh_time` DESC,`uv`.`company_vip_level` DESC,`c`.`attestation` DESC LIMIT 10 [ RunTime:0.002853s ]
SHOW FULL COLUMNS FROM `xy_jobs` [ RunTime:0.002118s ]
SELECT count(jobs_cate3) as countCate,jobs_cate3 as title FROM `xy_jobs` WHERE ( `status` = 1 AND `examine` = 1 ) AND `xy_jobs`.`delete_time` IS NULL GROUP BY `jobs_cate3` HAVING count(jobs_cate3)>1 ORDER BY `countCate` DESC LIMIT 20 [ RunTime:0.002744s ]
SHOW FULL COLUMNS FROM `xy_status_alias` [ RunTime:0.002530s ]
SELECT `value`,`title`,`type` FROM `xy_status_alias` WHERE `alias` = 'feedback/type' AND `status` = 1 ORDER BY `value` ASC [ RunTime:0.001795s ]
SHOW FULL COLUMNS FROM `xy_jobs_cate` [ RunTime:0.002161s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 33 LIMIT 1 [ RunTime:0.001743s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 107 LIMIT 1 [ RunTime:0.001706s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 1041 LIMIT 1 [ RunTime:0.001713s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 271 LIMIT 1 [ RunTime:0.001707s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 38 LIMIT 1 [ RunTime:0.001684s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 269 LIMIT 1 [ RunTime:0.001678s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 35 LIMIT 1 [ RunTime:0.002183s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 114 LIMIT 1 [ RunTime:0.001751s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 934 LIMIT 1 [ RunTime:0.001711s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 108 LIMIT 1 [ RunTime:0.001665s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 97 LIMIT 1 [ RunTime:0.001716s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 158 LIMIT 1 [ RunTime:0.001706s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 298 LIMIT 1 [ RunTime:0.001685s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 931 LIMIT 1 [ RunTime:0.001751s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 45 LIMIT 1 [ RunTime:0.001777s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 94 LIMIT 1 [ RunTime:0.002385s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 302 LIMIT 1 [ RunTime:0.001701s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 34 LIMIT 1 [ RunTime:0.001728s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 95 LIMIT 1 [ RunTime:0.001729s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 137 LIMIT 1 [ RunTime:0.002185s ]
SHOW FULL COLUMNS FROM `xy_ads_position` [ RunTime:0.002183s ]
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` < 1685658962 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1685658962) OR (`start_time` < 1685658962 AND `end_time` > 1685658962) ) LIMIT 1 [ RunTime:0.001828s ]
SHOW FULL COLUMNS FROM `xy_ads` [ RunTime:0.003130s ]
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` < 1685658962 AND `end_time` IS NULL) OR (`start_time` IS NULL AND `end_time` > 1685658962) OR (`start_time` < 1685658962 AND `end_time` > 1685658962) ) ORDER BY `sort` ASC,`id` DESC LIMIT 3 [ RunTime:0.001885s ]
SELECT `value`,`title`,`type` FROM `xy_status_alias` WHERE `alias` = 'company/finance' AND `status` = 1 ORDER BY `value` ASC [ RunTime:0.001940s ]
SELECT `value`,`title`,`type` FROM `xy_status_alias` WHERE `alias` = 'company/size_type' AND `status` = 1 ORDER BY `value` ASC [ RunTime:0.002502s ]