无效职位
该职位已招满或已下架
回到首页
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-03-29 09:54:37 HTTP/2.0 GET : https://www.suqianjob.com/jobs/167.html
- 运行时间 : 0.047639s [ 吞吐率:20.99req/s ] 内存消耗:5,459.33kb 文件加载:305
- 查询信息 : 7 queries
- 缓存信息 : 4 reads,0 writes
- 会话信息 : SESSION_ID=0d5701e5e7dae3a6b6c1060c70a8e5db
- CONNECT:[ UseTime:0.000439s ] mysql:host=127.0.0.1;port=3306;dbname=suqianjob;charset=utf8mb4
- SHOW FULL COLUMNS FROM `xycms_api_log` [ RunTime:0.000890s ]
- SELECT COUNT(*) AS think_count FROM `xycms_api_log` WHERE `ip` = '18.213.110.162' AND `create_time` BETWEEN 1711677274 AND 1711677278 [ RunTime:0.000417s ]
- INSERT INTO `xycms_api_log` SET `title` = '职位详情' , `uid` = 0 , `sub_account_id` = NULL , `app` = 1 , `api` = 35 , `route` = '/jobs/167.html' , `mca` = 'index/Jobs/index' , `param` = '{\"id\":\"167\"}' , `ip` = '18.213.110.162' , `systype` = 'claudebot' , `create_time` = 1711677277 [ RunTime:0.000324s ]
- SHOW FULL COLUMNS FROM `xycms_jobs` [ RunTime:0.000676s ]
- SELECT `jobs`.*,`desc`.`jobs_desc`,`contacts`.`jobs_id`,`contacts`.`contacts_wechat`,`contacts`.`contacts`,`contacts`.`contacts_mobile`,`contacts`.`contacts_tel`,`contacts`.`contacts_email`,`contacts`.`contacts_address`,`contacts`.`contacts_lng`,`contacts`.`contacts_lat`,`contacts`.`contacts_type`,`contacts`.`geo_address`,`contacts`.`geo_area`,`company`.`uid`,company.title as company_name,company.stitle as company_sname,company.logo as company_logo,`company`.`attestation`,`company_content`.`company_descript`,education.title as education_level,exp_level.title as exp_level,nature.title as nature,finance.title as finance,size_type.title as size_type,`user_timer`.`online_time` FROM `xycms_jobs` `jobs` INNER JOIN `xycms_company` `company` ON `company`.`id`=`jobs`.`company_id` INNER JOIN `xycms_company_content` `company_content` ON `company`.`id`=`company_content`.`cid` LEFT JOIN `xycms_user_timer` `user_timer` ON `user_timer`.`uid`=`company`.`uid` LEFT JOIN `xycms_jobs_desc` `desc` ON `desc`.`jobs_id`=`jobs`.`id` LEFT JOIN `xycms_jobs_contacts` `contacts` ON `contacts`.`jobs_id`=`jobs`.`id` INNER JOIN `xycms_status_alias` `education` ON `education`.`value`=`jobs`.`education_level` LEFT JOIN `xycms_status_alias` `exp_level` ON `exp_level`.`value`=`jobs`.`exp_level` INNER JOIN `xycms_status_alias` `nature` ON `nature`.`value`=`company`.`nature` INNER JOIN `xycms_status_alias` `finance` ON `finance`.`value`=`company`.`finance` INNER JOIN `xycms_status_alias` `size_type` ON `size_type`.`value`=`company`.`size_type` WHERE ( `jobs`.`id` = '167' AND `jobs`.`status` = 1 AND `jobs`.`examine` = 1 AND `company`.`attestation` = 3 AND `company`.`delete_time` IS NULL AND `education`.`alias` = 'jobs/education_level' AND `exp_level`.`alias` = 'jobs/exp_level' AND `nature`.`alias` = 'company/nature' AND `finance`.`alias` = 'company/finance' AND `size_type`.`alias` = 'company/size_type' ) AND `jobs`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001694s ]
- SELECT * FROM `xycms_jobs` WHERE ( `id` = 167 ) AND `xycms_jobs`.`delete_time` IS NOT NULL LIMIT 1 [ RunTime:0.000382s ]
- SELECT * FROM `xycms_jobs` WHERE ( `id` = 167 ) AND `xycms_jobs`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000328s ]
0.048949s