| 1 |
1.96 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.user_type AS user_type_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.oauth_provider AS oauth_provider_8, t0.oauth_id AS oauth_id_9, t0.profile_picture_filename AS profile_picture_filename_10, t0.oauth_data AS oauth_data_11, t0.on_boarding_completed_at AS on_boarding_completed_at_12, t0.dob AS dob_13, t0.gender AS gender_14, t0.phone1 AS phone1_15, t0.phone2 AS phone2_16, t0.bio AS bio_17, t0.nickname AS nickname_18, t0.blocked AS blocked_19, t0.is_hybrid_recruiter AS is_hybrid_recruiter_20, t0.address AS address_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.employer_id AS employer_id_24, t25.id AS id_26, t25.name AS name_27, t25.suffix AS suffix_28, t25.title AS title_29, t25.npi_number AS npi_number_30, t25.phone_home AS phone_home_31, t25.phone_work AS phone_work_32, t25.phone_mobile AS phone_mobile_33, t25.cv_filename AS cv_filename_34, t25.country AS country_35, t25.state AS state_36, t25.city AS city_37, t25.zip_code AS zip_code_38, t25.street_address AS street_address_39, t25.desired_pay_rate AS desired_pay_rate_40, t25.pay_rate_hourly AS pay_rate_hourly_41, t25.pay_rate_daily AS pay_rate_daily_42, t25.desired_hour AS desired_hour_43, t25.desired_states AS desired_states_44, t25.availability_to_start AS availability_to_start_45, t25.willing_to_travel AS willing_to_travel_46, t25.preferred_patient_volume AS preferred_patient_volume_47, t25.release_authorization_date AS release_authorization_date_48, t25.ssn AS ssn_49, t25.dob AS dob_50, t25.country_of_birth AS country_of_birth_51, t25.state_of_birth AS state_of_birth_52, t25.city_of_birth AS city_of_birth_53, t25.release_and_authorization_accepted AS release_and_authorization_accepted_54, t25.application_certification_date AS application_certification_date_55, t25.risk_assessment AS risk_assessment_56, t25.health_assessment AS health_assessment_57, t25.cashback AS cashback_58, t25.notification_preferences AS notification_preferences_59, t25.average_point AS average_point_60, t25.skip_onboarding AS skip_onboarding_61, t25.created_at AS created_at_62, t25.updated_at AS updated_at_63, t25.user_id AS user_id_64, t25.profession_id AS profession_id_65, t66.id AS id_67, t66.company_name AS company_name_68, t66.speciality AS speciality_69, t66.membership_level AS membership_level_70, t66.rating AS rating_71, t66.is_verified AS is_verified_72, t66.created_at AS created_at_73, t66.updated_at AS updated_at_74, t66.user_id AS user_id_75, t0.recruiter_id AS recruiter_id_76 FROM b_user t0 LEFT JOIN b_provider t25 ON t25.user_id = t0.id LEFT JOIN b_recruiter t66 ON t66.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters: [
"SUBASTAKOTI@GMAIL.COM"
]
SELECT
t0.id AS id_1,
t0.name AS name_2,
t0.email AS email_3,
t0.user_type AS user_type_4,
t0.roles AS roles_5,
t0.password AS password_6,
t0.is_verified AS is_verified_7,
t0.oauth_provider AS oauth_provider_8,
t0.oauth_id AS oauth_id_9,
t0.profile_picture_filename AS profile_picture_filename_10,
t0.oauth_data AS oauth_data_11,
t0.on_boarding_completed_at AS on_boarding_completed_at_12,
t0.dob AS dob_13,
t0.gender AS gender_14,
t0.phone1 AS phone1_15,
t0.phone2 AS phone2_16,
t0.bio AS bio_17,
t0.nickname AS nickname_18,
t0.blocked AS blocked_19,
t0.is_hybrid_recruiter AS is_hybrid_recruiter_20,
t0.address AS address_21,
t0.created_at AS created_at_22,
t0.updated_at AS updated_at_23,
t0.employer_id AS employer_id_24,
t25.id AS id_26,
t25.name AS name_27,
t25.suffix AS suffix_28,
t25.title AS title_29,
t25.npi_number AS npi_number_30,
t25.phone_home AS phone_home_31,
t25.phone_work AS phone_work_32,
t25.phone_mobile AS phone_mobile_33,
t25.cv_filename AS cv_filename_34,
t25.country AS country_35,
t25.state AS state_36,
t25.city AS city_37,
t25.zip_code AS zip_code_38,
t25.street_address AS street_address_39,
t25.desired_pay_rate AS desired_pay_rate_40,
t25.pay_rate_hourly AS pay_rate_hourly_41,
t25.pay_rate_daily AS pay_rate_daily_42,
t25.desired_hour AS desired_hour_43,
t25.desired_states AS desired_states_44,
t25.availability_to_start AS availability_to_start_45,
t25.willing_to_travel AS willing_to_travel_46,
t25.preferred_patient_volume AS preferred_patient_volume_47,
t25.release_authorization_date AS release_authorization_date_48,
t25.ssn AS ssn_49,
t25.dob AS dob_50,
t25.country_of_birth AS country_of_birth_51,
t25.state_of_birth AS state_of_birth_52,
t25.city_of_birth AS city_of_birth_53,
t25.release_and_authorization_accepted AS release_and_authorization_accepted_54,
t25.application_certification_date AS application_certification_date_55,
t25.risk_assessment AS risk_assessment_56,
t25.health_assessment AS health_assessment_57,
t25.cashback AS cashback_58,
t25.notification_preferences AS notification_preferences_59,
t25.average_point AS average_point_60,
t25.skip_onboarding AS skip_onboarding_61,
t25.created_at AS created_at_62,
t25.updated_at AS updated_at_63,
t25.user_id AS user_id_64,
t25.profession_id AS profession_id_65,
t66.id AS id_67,
t66.company_name AS company_name_68,
t66.speciality AS speciality_69,
t66.membership_level AS membership_level_70,
t66.rating AS rating_71,
t66.is_verified AS is_verified_72,
t66.created_at AS created_at_73,
t66.updated_at AS updated_at_74,
t66.user_id AS user_id_75,
t0.recruiter_id AS recruiter_id_76
FROM
b_user t0
LEFT JOIN b_provider t25 ON t25.user_id = t0.id
LEFT JOIN b_recruiter t66 ON t66.user_id = t0.id
WHERE
t0.email = ?
LIMIT
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.user_type AS user_type_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.oauth_provider AS oauth_provider_8, t0.oauth_id AS oauth_id_9, t0.profile_picture_filename AS profile_picture_filename_10, t0.oauth_data AS oauth_data_11, t0.on_boarding_completed_at AS on_boarding_completed_at_12, t0.dob AS dob_13, t0.gender AS gender_14, t0.phone1 AS phone1_15, t0.phone2 AS phone2_16, t0.bio AS bio_17, t0.nickname AS nickname_18, t0.blocked AS blocked_19, t0.is_hybrid_recruiter AS is_hybrid_recruiter_20, t0.address AS address_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.employer_id AS employer_id_24, t25.id AS id_26, t25.name AS name_27, t25.suffix AS suffix_28, t25.title AS title_29, t25.npi_number AS npi_number_30, t25.phone_home AS phone_home_31, t25.phone_work AS phone_work_32, t25.phone_mobile AS phone_mobile_33, t25.cv_filename AS cv_filename_34, t25.country AS country_35, t25.state AS state_36, t25.city AS city_37, t25.zip_code AS zip_code_38, t25.street_address AS street_address_39, t25.desired_pay_rate AS desired_pay_rate_40, t25.pay_rate_hourly AS pay_rate_hourly_41, t25.pay_rate_daily AS pay_rate_daily_42, t25.desired_hour AS desired_hour_43, t25.desired_states AS desired_states_44, t25.availability_to_start AS availability_to_start_45, t25.willing_to_travel AS willing_to_travel_46, t25.preferred_patient_volume AS preferred_patient_volume_47, t25.release_authorization_date AS release_authorization_date_48, t25.ssn AS ssn_49, t25.dob AS dob_50, t25.country_of_birth AS country_of_birth_51, t25.state_of_birth AS state_of_birth_52, t25.city_of_birth AS city_of_birth_53, t25.release_and_authorization_accepted AS release_and_authorization_accepted_54, t25.application_certification_date AS application_certification_date_55, t25.risk_assessment AS risk_assessment_56, t25.health_assessment AS health_assessment_57, t25.cashback AS cashback_58, t25.notification_preferences AS notification_preferences_59, t25.average_point AS average_point_60, t25.skip_onboarding AS skip_onboarding_61, t25.created_at AS created_at_62, t25.updated_at AS updated_at_63, t25.user_id AS user_id_64, t25.profession_id AS profession_id_65, t66.id AS id_67, t66.company_name AS company_name_68, t66.speciality AS speciality_69, t66.membership_level AS membership_level_70, t66.rating AS rating_71, t66.is_verified AS is_verified_72, t66.created_at AS created_at_73, t66.updated_at AS updated_at_74, t66.user_id AS user_id_75, t0.recruiter_id AS recruiter_id_76 FROM b_user t0 LEFT JOIN b_provider t25 ON t25.user_id = t0.id LEFT JOIN b_recruiter t66 ON t66.user_id = t0.id WHERE t0.email = 'SUBASTAKOTI@GMAIL.COM' LIMIT 1;
|