无效职位
该职位未达到展示要求(地区或职位分类不明确)
回到首页
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2023-06-02 05:46:18 HTTP/1.1 GET : https://www.lzsf.com/jobs/5082.html
- 运行时间 : 0.057554s [ 吞吐率:17.37req/s ] 内存消耗:5,032.93kb 文件加载:298
- 查询信息 : 7 queries
- 缓存信息 : 4 reads,0 writes
- 会话信息 : SESSION_ID=100db248633f11783614042d8fc790a0
- CONNECT:[ UseTime:0.000901s ] mysql:host=gz-cdb-hudwadaf.sql.tencentcdb.com;port=60704;dbname=lzsf;charset=utf8mb4
- SHOW FULL COLUMNS FROM `xy_api_log` [ RunTime:0.002169s ]
- SELECT COUNT(*) AS think_count FROM `xy_api_log` WHERE `ip` = '44.200.82.149' AND `create_time` BETWEEN 1685655975 AND 1685655979 [ RunTime:0.001990s ]
- INSERT INTO `xy_api_log` SET `title` = '职位详情' , `uid` = 0 , `app` = 1 , `api` = 35 , `route` = '/jobs/5082.html' , `mca` = 'index/Jobs/index' , `param` = '{\"id\":\"5082\"}' , `ip` = '44.200.82.149' , `systype` = 'CCBot/2.0 (https://commoncrawl.org/faq/)' , `create_time` = 1685655978 [ RunTime:0.001865s ]
- SHOW FULL COLUMNS FROM `xy_jobs` [ RunTime:0.002273s ]
- SELECT `jobs`.*,`desc`.`jobs_desc`,`contacts`.`jobs_id`,`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,`user_timer`.`online_time`,province.title as jobs_province,city.title as jobs_city,area.title as jobs_area,jobs_cate.title as jobs_cate_text,nature.title as nature,finance.title as finance,size_type.title as size_type,industry.title as industry,industry2.title as industry2 FROM `xy_jobs` `jobs` INNER JOIN `xy_company` `company` ON `company`.`id`=`jobs`.`company_id` INNER JOIN `xy_company_content` `company_content` ON `company`.`id`=`company_content`.`cid` INNER JOIN `xy_jobs_cate` `jobs_cate` ON `jobs_cate`.`id`=`jobs`.`jobs_cate3` LEFT JOIN `xy_user_timer` `user_timer` ON `user_timer`.`uid`=`company`.`uid` LEFT JOIN `xy_jobs_desc` `desc` ON `desc`.`jobs_id`=`jobs`.`id` LEFT JOIN `xy_jobs_contacts` `contacts` ON `contacts`.`jobs_id`=`jobs`.`id` INNER JOIN `xy_status_alias` `education` ON `education`.`value`=`jobs`.`education_level` LEFT JOIN `xy_status_alias` `exp_level` ON `exp_level`.`value`=`jobs`.`exp_level` INNER JOIN `xy_status_alias` `nature` ON `nature`.`value`=`company`.`nature` INNER JOIN `xy_status_alias` `finance` ON `finance`.`value`=`company`.`finance` INNER JOIN `xy_status_alias` `size_type` ON `size_type`.`value`=`company`.`size_type` INNER JOIN `xy_company_industry` `industry` ON `industry`.`id`=`company`.`industry_id` LEFT JOIN `xy_company_industry` `industry2` ON `industry2`.`id`=`company`.`industry_id2` LEFT JOIN `xy_area` `province` ON `province`.`id`=`jobs`.`jobs_area1` LEFT JOIN `xy_area` `city` ON `city`.`id`=`jobs`.`jobs_area2` LEFT JOIN `xy_area` `area` ON `area`.`id`=`jobs`.`jobs_area3` WHERE ( `jobs`.`id` = '5082' AND `jobs`.`status` = 1 AND `jobs`.`examine` IN (0,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.003324s ]
- SELECT * FROM `xy_jobs` WHERE ( `id` = 5082 ) AND `xy_jobs`.`delete_time` IS NOT NULL LIMIT 1 [ RunTime:0.002014s ]
- SELECT * FROM `xy_jobs` WHERE ( `id` = 5082 ) AND `xy_jobs`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001950s ]

0.058754s