SHOW FULL COLUMNS FROM `zp_user` [ RunTime:0.003387s ]
SELECT * FROM `zp_user` WHERE ( `id` IS NULL ) AND `zp_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001174s ]
SHOW FULL COLUMNS FROM `zp_jobs` [ RunTime:0.002790s ]
SELECT * FROM `zp_jobs` WHERE ( `audit_status` = 1 AND `publish_status` = 1 AND `id` = 19795 ) AND `zp_jobs`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001190s ]
SHOW FULL COLUMNS FROM `zp_address` [ RunTime:0.002501s ]
SELECT `id`,`address`,`position`,`longitude`,`latitude`,`location_code` FROM `zp_address` WHERE ( `id` = 18011 ) AND `zp_address`.`delete_time` IS NULL [ RunTime:0.000944s ]
SHOW FULL COLUMNS FROM `zp_jobs_industry` [ RunTime:0.002228s ]
SELECT * FROM `zp_jobs_industry` WHERE `jobs_id` = 19795 [ RunTime:0.000997s ]
SHOW FULL COLUMNS FROM `zp_brand_user` [ RunTime:0.002565s ]
SELECT `a`.`id`,`a`.`brand_id`,`a`.`user_id`,`a`.`duties_name`,`b`.`real_name`,`b`.`mobile`,`b`.`username`,`b`.`avatar` FROM `zp_brand_user` `a` INNER JOIN `zp_user` `b` ON `a`.`user_id`=`b`.`id` WHERE `user_id` = 56115 [ RunTime:0.001800s ]
SHOW FULL COLUMNS FROM `zp_position` [ RunTime:0.002337s ]
SELECT * FROM `zp_position` WHERE ( `id` = 237 ) AND `zp_position`.`delete_time` IS NULL [ RunTime:0.001019s ]
SHOW FULL COLUMNS FROM `zp_brand` [ RunTime:0.003387s ]
SELECT `id`,`name`,`logo`,`scale`,`company_id`,`industry_id`,`stage`,`location_code`,`location_name` FROM `zp_brand` WHERE `id` = 7094 LIMIT 1 [ RunTime:0.001013s ]
SHOW FULL COLUMNS FROM `zp_brand_welfare` [ RunTime:0.002176s ]
SELECT `brand_id`,`welfare_id` FROM `zp_brand_welfare` WHERE `brand_id` = 7094 [ RunTime:0.006884s ]
SHOW FULL COLUMNS FROM `zp_brand_business` [ RunTime:0.002627s ]
SELECT * FROM `zp_brand_business` WHERE `brand_id` = 7094 ORDER BY `list_order` ASC [ RunTime:0.000980s ]
SHOW FULL COLUMNS FROM `zp_industry` [ RunTime:0.002338s ]
SELECT `id`,name as industry_name FROM `zp_industry` WHERE `id` = 15 [ RunTime:0.000914s ]
SHOW FULL COLUMNS FROM `zp_company` [ RunTime:0.002205s ]
SELECT `id`,name as company_name,`operator_name`,`register_capital`,`start_date`,`stage`,`location_code`,`location_name` FROM `zp_company` WHERE `id` = 7081 [ RunTime:0.000942s ]
SELECT `b`.* FROM `zp_brand` `b` LEFT JOIN `zp_brand_user` `bu` ON `b`.`id`=`bu`.`brand_id` WHERE `bu`.`user_id` = '56115' LIMIT 1 [ RunTime:0.001009s ]
SHOW FULL COLUMNS FROM `zp_vip_level` [ RunTime:0.002227s ]
SELECT * FROM `zp_vip_level` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000897s ]
SELECT `id`,`name` FROM `zp_industry` WHERE `id` IN (80,126,137) [ RunTime:0.000970s ]
SHOW FULL COLUMNS FROM `zp_user_job_track` [ RunTime:0.002221s ]
UPDATE `zp_jobs` SET `view_count` = `view_count` + 1 WHERE ( `id` = 19795 ) AND `zp_jobs`.`delete_time` IS NULL [ RunTime:0.001548s ]
SHOW FULL COLUMNS FROM `sys_setting_item` [ RunTime:0.002426s ]
SELECT `value`,`key` FROM `sys_setting_item` WHERE ( `key` = 'head_image' ) AND `sys_setting_item`.`delete_time` IS NULL [ RunTime:0.000996s ]
SHOW FULL COLUMNS FROM `zp_user_tencent_im` [ RunTime:0.002417s ]
SELECT `im_user_id` FROM `zp_user_tencent_im` WHERE ( `user_id` = 56115 AND `type` = 'recruiter' ) AND `zp_user_tencent_im`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.036914s ]
SHOW FULL COLUMNS FROM `zp_brand_introduce` [ RunTime:0.002124s ]
SELECT * FROM `zp_brand_introduce` WHERE `brand_id` = 7094 LIMIT 1 [ RunTime:0.002646s ]
SELECT COUNT(*) AS think_count FROM `zp_jobs` `a` LEFT JOIN `zp_address` `b` ON `a`.`address_id`=`b`.`id` WHERE ( `a`.`publish_status` = '1' AND `a`.`audit_status` = '1' AND `a`.`brand_id` = '7094' AND `a`.`id` <> '19795' ) AND `a`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.016953s ]
SELECT `a`.`id`,`a`.`user_id`,`a`.`position_id`,`a`.`min_salary`,`a`.`max_salary`,`a`.`salary_month`,`a`.`publish_status`,`a`.`experience`,`a`.`education`,`a`.`brand_id`,`a`.`name`,`a`.`description`,`a`.`position_name`,`a`.`position_label`,`a`.`employment_type`,`a`.`keywords`,concat(`b`.`address`,`b`.`position`) as address,`b`.`longitude`,`b`.`latitude`,`b`.`location_code` FROM `zp_jobs` `a` LEFT JOIN `zp_address` `b` ON `a`.`address_id`=`b`.`id` WHERE ( `a`.`publish_status` = '1' AND `a`.`audit_status` = '1' AND `a`.`brand_id` = '7094' AND `a`.`id` <> '19795' ) AND `a`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.041397s ]
SELECT * FROM `zp_jobs_industry` WHERE `jobs_id` IN (19794,7640) [ RunTime:0.001009s ]
SELECT `a`.`id`,`a`.`brand_id`,`a`.`user_id`,`a`.`duties_name`,`b`.`real_name`,`b`.`mobile`,`b`.`username`,`b`.`avatar` FROM `zp_brand_user` `a` INNER JOIN `zp_user` `b` ON `a`.`user_id`=`b`.`id` WHERE `user_id` IN (56115,18195) [ RunTime:0.001590s ]
SELECT id,name,logo,scale,stage,industry_id,"" as scale_desc,"" as stage_desc, location_code, vip_id, vip_end_time FROM `zp_brand` WHERE `id` = 7094 [ RunTime:0.001021s ]
SELECT `b`.* FROM `zp_brand` `b` LEFT JOIN `zp_brand_user` `bu` ON `b`.`id`=`bu`.`brand_id` WHERE `bu`.`user_id` = '56115' LIMIT 1 [ RunTime:0.000994s ]
SELECT * FROM `zp_vip_level` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000903s ]
SELECT `b`.* FROM `zp_brand` `b` LEFT JOIN `zp_brand_user` `bu` ON `b`.`id`=`bu`.`brand_id` WHERE `bu`.`user_id` = '18195' LIMIT 1 [ RunTime:0.002069s ]
SELECT * FROM `zp_vip_level` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000849s ]
SELECT * FROM `zp_industry` WHERE 0 = 1 [ RunTime:0.002126s ]