SHOW FULL COLUMNS FROM `zp_user` [ RunTime:0.002604s ]
SELECT * FROM `zp_user` WHERE ( `id` IS NULL ) AND `zp_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000994s ]
SHOW FULL COLUMNS FROM `zp_jobs` [ RunTime:0.002312s ]
SELECT * FROM `zp_jobs` WHERE ( `audit_status` = 1 AND `publish_status` = 1 AND `id` = 6005 ) AND `zp_jobs`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001101s ]
SHOW FULL COLUMNS FROM `zp_address` [ RunTime:0.001824s ]
SELECT `id`,`address`,`position`,`longitude`,`latitude`,`location_code` FROM `zp_address` WHERE ( `id` = 5025 ) AND `zp_address`.`delete_time` IS NULL [ RunTime:0.001122s ]
SHOW FULL COLUMNS FROM `zp_jobs_industry` [ RunTime:0.001899s ]
SELECT * FROM `zp_jobs_industry` WHERE `jobs_id` = 6005 [ RunTime:0.001074s ]
SHOW FULL COLUMNS FROM `zp_brand_user` [ RunTime:0.002240s ]
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` = 15679 [ RunTime:0.001065s ]
SHOW FULL COLUMNS FROM `zp_position` [ RunTime:0.002277s ]
SELECT * FROM `zp_position` WHERE ( `id` = 847 ) AND `zp_position`.`delete_time` IS NULL [ RunTime:0.001073s ]
SHOW FULL COLUMNS FROM `zp_brand` [ RunTime:0.002569s ]
SELECT `id`,`name`,`logo`,`scale`,`company_id`,`industry_id`,`stage`,`location_code`,`location_name` FROM `zp_brand` WHERE `id` = 5650 LIMIT 1 [ RunTime:0.001113s ]
SHOW FULL COLUMNS FROM `zp_brand_welfare` [ RunTime:0.002098s ]
SELECT `brand_id`,`welfare_id` FROM `zp_brand_welfare` WHERE `brand_id` = 5650 [ RunTime:0.001107s ]
SHOW FULL COLUMNS FROM `zp_brand_business` [ RunTime:0.001641s ]
SELECT * FROM `zp_brand_business` WHERE `brand_id` = 5650 ORDER BY `list_order` ASC [ RunTime:0.000831s ]
SHOW FULL COLUMNS FROM `zp_industry` [ RunTime:0.001732s ]
SELECT `id`,name as industry_name FROM `zp_industry` WHERE `id` = 0 [ RunTime:0.000871s ]
SHOW FULL COLUMNS FROM `zp_company` [ RunTime:0.001907s ]
SELECT `id`,name as company_name,`operator_name`,`register_capital`,`start_date`,`stage`,`location_code`,`location_name` FROM `zp_company` WHERE `id` = 5637 [ RunTime:0.000901s ]
SHOW FULL COLUMNS FROM `sys_setting_item` [ RunTime:0.002087s ]
SELECT `value`,`key` FROM `sys_setting_item` WHERE ( `key` = 'head_image' ) AND `sys_setting_item`.`delete_time` IS NULL [ RunTime:0.000923s ]
SHOW FULL COLUMNS FROM `zp_user_tencent_im` [ RunTime:0.002073s ]
SELECT `im_user_id` FROM `zp_user_tencent_im` WHERE ( `user_id` = 15679 AND `type` = 'recruiter' ) AND `zp_user_tencent_im`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.007923s ]
SHOW FULL COLUMNS FROM `zp_brand_introduce` [ RunTime:0.001947s ]
SELECT * FROM `zp_brand_introduce` WHERE `brand_id` = 5650 LIMIT 1 [ RunTime:0.000939s ]
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` = '5650' AND `a`.`id` <> '6005' ) AND `a`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004141s ]