SHOW FULL COLUMNS FROM `xycms_api_log` [ RunTime:0.000595s ]
SELECT COUNT(*) AS think_count FROM `xycms_api_log` WHERE `ip` = '18.191.205.110' AND `create_time` BETWEEN 1734919925 AND 1734919929 LIMIT 1 [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `xycms_company` [ RunTime:0.000667s ]
SELECT `c`.`title`,`c`.`id` FROM `xycms_company` `c` INNER JOIN `xycms_company_content` `content` ON `content`.`cid`=`c`.`id` INNER JOIN `xycms_user` `user` ON `user`.`id`=c.uid AND user.status=1 INNER JOIN `xycms_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.000686s ]
SELECT `c`.`title`,`c`.`id` FROM `xycms_company` `c` INNER JOIN `xycms_company_content` `content` ON `content`.`cid`=`c`.`id` INNER JOIN `xycms_user` `user` ON `user`.`id`=c.uid AND user.status=1 INNER JOIN `xycms_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.000435s ]
SHOW FULL COLUMNS FROM `xycms_jobs` [ RunTime:0.000556s ]
SELECT count(jobs_cate3) as countCate,jobs_cate3 as title FROM `xycms_jobs` WHERE ( `status` = 1 AND `examine` = 1 ) AND `xycms_jobs`.`delete_time` IS NULL GROUP BY `jobs_cate3` HAVING count(jobs_cate3)>1 ORDER BY `countCate` DESC LIMIT 20 [ RunTime:0.000407s ]
SHOW FULL COLUMNS FROM `xycms_jobs_cate` [ RunTime:0.000444s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 221 LIMIT 1 [ RunTime:0.000213s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 876 LIMIT 1 [ RunTime:0.000189s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 830 LIMIT 1 [ RunTime:0.000208s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 881 LIMIT 1 [ RunTime:0.000186s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 106 LIMIT 1 [ RunTime:0.000203s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000192s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 162 LIMIT 1 [ RunTime:0.000200s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 191 LIMIT 1 [ RunTime:0.000183s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 397 LIMIT 1 [ RunTime:0.000198s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 647 LIMIT 1 [ RunTime:0.000187s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 975 LIMIT 1 [ RunTime:0.000197s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 224 LIMIT 1 [ RunTime:0.000194s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 1041 LIMIT 1 [ RunTime:0.000199s ]