无效职位
该职位被管理员删除
回到首页
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-05-08 11:57:51 HTTP/2.0 GET : https://www.tfhr.com/jobs/39835.html
- 运行时间 : 0.119984s [ 吞吐率:8.33req/s ] 内存消耗:5,443.88kb 文件加载:306
- 查询信息 : 7 queries
- 缓存信息 : 4 reads,0 writes
- 会话信息 : SESSION_ID=4aefe28cf6f6beea17add1bc024eb221
- CONNECT:[ UseTime:0.000854s ] mysql:host=127.0.0.1;port=3306;dbname=tfhr;charset=utf8mb4
- SHOW FULL COLUMNS FROM `xy_api_log` [ RunTime:0.001404s ]
- SELECT COUNT(*) AS think_count FROM `xy_api_log` WHERE `ip` = '3.141.100.120' AND `create_time` BETWEEN 1715140668 AND 1715140672 [ RunTime:0.001715s ]
- INSERT INTO `xy_api_log` SET `title` = '职位详情' , `uid` = 0 , `sub_account_id` = NULL , `app` = 1 , `api` = 35 , `route` = '/jobs/39835.html' , `mca` = 'index/Jobs/index' , `param` = '{\"id\":\"39835\"}' , `ip` = '3.141.100.120' , `systype` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `create_time` = 1715140671 [ RunTime:0.000362s ]
- SHOW FULL COLUMNS FROM `xy_jobs` [ RunTime:0.001194s ]
- 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 `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` 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` WHERE ( `jobs`.`id` = '39835' 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.001849s ]
- SELECT * FROM `xy_jobs` WHERE ( `id` = 39835 ) AND `xy_jobs`.`delete_time` IS NOT NULL LIMIT 1 [ RunTime:0.000442s ]
- SELECT * FROM `xy_jobs` WHERE ( `id` = 39835 ) AND `xy_jobs`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000376s ]
0.146217s