Symfony Profiler

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 AS profile_picture_10,
  t0.profile_picture_filename AS profile_picture_filename_11,
  t0.oauth_data AS oauth_data_12,
  t0.on_boarding_completed_at AS on_boarding_completed_at_13,
  t0.dob AS dob_14,
  t0.gender AS gender_15,
  t0.phone1 AS phone1_16,
  t0.phone2 AS phone2_17,
  t0.bio AS bio_18,
  t0.blocked AS blocked_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.employer_id AS employer_id_22,
  t0.provider_id AS provider_id_23
FROM
  b_user t0
WHERE
  t0.id = ?

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 AS profile_picture_10, t0.profile_picture_filename AS profile_picture_filename_11, t0.oauth_data AS oauth_data_12, t0.on_boarding_completed_at AS on_boarding_completed_at_13, t0.dob AS dob_14, t0.gender AS gender_15, t0.phone1 AS phone1_16, t0.phone2 AS phone2_17, t0.bio AS bio_18, t0.blocked AS blocked_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.employer_id AS employer_id_22, t0.provider_id AS provider_id_23 FROM b_user t0 WHERE t0.id = 0x0194C15E296F7B50877A02318E6DEEFF;

SELECT
  t0.id AS id_1,
  t0.message AS message_2,
  t0.reviewed_by AS reviewed_by_3,
  t0.point AS point_4,
  t0.professionalism AS professionalism_5,
  t0.quality AS quality_6,
  t0.communication AS communication_7,
  t0.emotional_intelligence AS emotional_intelligence_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.provider_id AS provider_id_11,
  t0.employer_id AS employer_id_12,
  t0.application_id AS application_id_13
FROM
  b_review t0
WHERE
  t0.employer_id = ?
  AND t0.reviewed_by = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.message AS message_2, t0.reviewed_by AS reviewed_by_3, t0.point AS point_4, t0.professionalism AS professionalism_5, t0.quality AS quality_6, t0.communication AS communication_7, t0.emotional_intelligence AS emotional_intelligence_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.provider_id AS provider_id_11, t0.employer_id AS employer_id_12, t0.application_id AS application_id_13 FROM b_review t0 WHERE t0.employer_id = 0x0194C15E27807AD292D205BBE18ED47F AND t0.reviewed_by = 'PROVIDER' ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.config_key AS config_key_2,
  t0.config_value AS config_value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  b_config t0

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM b_config t0;

SELECT
  t0.id AS id_1,
  t0.notification_type AS notification_type_2,
  t0.user_type AS user_type_3,
  t0.message AS message_4,
  t0.seen AS seen_5,
  t0.extra_data AS extra_data_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.user_id AS user_id_9
FROM
  b_notification t0
WHERE
  t0.user_type = ?
  AND t0.seen = ?
  AND t0.user_id = ?
ORDER BY
  t0.created_at DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.notification_type AS notification_type_2, t0.user_type AS user_type_3, t0.message AS message_4, t0.seen AS seen_5, t0.extra_data AS extra_data_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM b_notification t0 WHERE t0.user_type = 'EMPLOYER' AND t0.seen = 0 AND t0.user_id = 0x0194C15E296F7B50877A02318E6DEEFF ORDER BY t0.created_at DESC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.notification_type AS notification_type_2,
  t0.user_type AS user_type_3,
  t0.message AS message_4,
  t0.seen AS seen_5,
  t0.extra_data AS extra_data_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.user_id AS user_id_9
FROM
  b_notification t0
WHERE
  t0.user_id = ?
  AND t0.seen = ?

SELECT t0.id AS id_1, t0.notification_type AS notification_type_2, t0.user_type AS user_type_3, t0.message AS message_4, t0.seen AS seen_5, t0.extra_data AS extra_data_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM b_notification t0 WHERE t0.user_id = 0x0194C15E296F7B50877A02318E6DEEFF AND t0.seen = 0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.phone1 AS phone1_4,
  t0.phone2 AS phone2_5,
  t0.email AS email_6,
  t0.website AS website_7,
  t0.logo AS logo_8,
  t0.average_point AS average_point_9,
  t0.company_name AS company_name_10,
  t0.contact_person_name AS contact_person_name_11,
  t0.contact_email AS contact_email_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14
FROM
  b_employer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.email AS email_6, t0.website AS website_7, t0.logo AS logo_8, t0.average_point AS average_point_9, t0.company_name AS company_name_10, t0.contact_person_name AS contact_person_name_11, t0.contact_email AS contact_email_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM b_employer t0 WHERE t0.id = 0x0194C15E27807AD292D205BBE18ED47F;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.suffix AS suffix_3,
  t0.title AS title_4,
  t0.npi_number AS npi_number_5,
  t0.phone_home AS phone_home_6,
  t0.phone_work AS phone_work_7,
  t0.phone_mobile AS phone_mobile_8,
  t0.cv_filename AS cv_filename_9,
  t0.country AS country_10,
  t0.state AS state_11,
  t0.city AS city_12,
  t0.zip_code AS zip_code_13,
  t0.street_address AS street_address_14,
  t0.desired_pay_rate AS desired_pay_rate_15,
  t0.pay_rate_hourly AS pay_rate_hourly_16,
  t0.pay_rate_daily AS pay_rate_daily_17,
  t0.desired_hour AS desired_hour_18,
  t0.desired_states AS desired_states_19,
  t0.availability_to_start AS availability_to_start_20,
  t0.willing_to_travel AS willing_to_travel_21,
  t0.preferred_patient_volume AS preferred_patient_volume_22,
  t0.release_authorization_date AS release_authorization_date_23,
  t0.ssn AS ssn_24,
  t0.dob AS dob_25,
  t0.country_of_birth AS country_of_birth_26,
  t0.state_of_birth AS state_of_birth_27,
  t0.city_of_birth AS city_of_birth_28,
  t0.release_and_authorization_accepted AS release_and_authorization_accepted_29,
  t0.application_certification_date AS application_certification_date_30,
  t0.risk_assessment AS risk_assessment_31,
  t0.health_assessment AS health_assessment_32,
  t0.cashback AS cashback_33,
  t0.notification_preferences AS notification_preferences_34,
  t0.average_point AS average_point_35,
  t0.skip_onboarding AS skip_onboarding_36,
  t0.created_at AS created_at_37,
  t0.updated_at AS updated_at_38,
  t0.user_id AS user_id_39,
  t0.profession_id AS profession_id_40
FROM
  b_provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.suffix AS suffix_3, t0.title AS title_4, t0.npi_number AS npi_number_5, t0.phone_home AS phone_home_6, t0.phone_work AS phone_work_7, t0.phone_mobile AS phone_mobile_8, t0.cv_filename AS cv_filename_9, t0.country AS country_10, t0.state AS state_11, t0.city AS city_12, t0.zip_code AS zip_code_13, t0.street_address AS street_address_14, t0.desired_pay_rate AS desired_pay_rate_15, t0.pay_rate_hourly AS pay_rate_hourly_16, t0.pay_rate_daily AS pay_rate_daily_17, t0.desired_hour AS desired_hour_18, t0.desired_states AS desired_states_19, t0.availability_to_start AS availability_to_start_20, t0.willing_to_travel AS willing_to_travel_21, t0.preferred_patient_volume AS preferred_patient_volume_22, t0.release_authorization_date AS release_authorization_date_23, t0.ssn AS ssn_24, t0.dob AS dob_25, t0.country_of_birth AS country_of_birth_26, t0.state_of_birth AS state_of_birth_27, t0.city_of_birth AS city_of_birth_28, t0.release_and_authorization_accepted AS release_and_authorization_accepted_29, t0.application_certification_date AS application_certification_date_30, t0.risk_assessment AS risk_assessment_31, t0.health_assessment AS health_assessment_32, t0.cashback AS cashback_33, t0.notification_preferences AS notification_preferences_34, t0.average_point AS average_point_35, t0.skip_onboarding AS skip_onboarding_36, t0.created_at AS created_at_37, t0.updated_at AS updated_at_38, t0.user_id AS user_id_39, t0.profession_id AS profession_id_40 FROM b_provider t0 WHERE t0.id = 0x0194C15BAB0D76CA86F835495F1D6116;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.document_requested_at AS document_requested_at_3,
  t0.document_provided_at AS document_provided_at_4,
  t0.one_file_requested_at AS one_file_requested_at_5,
  t0.one_file_provided_at AS one_file_provided_at_6,
  t0.contract_sent_at AS contract_sent_at_7,
  t0.contract_file_name AS contract_file_name_8,
  t0.contract_signed_at AS contract_signed_at_9,
  t0.contract_signed_file_name AS contract_signed_file_name_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.employer_id AS employer_id_13,
  t0.provider_id AS provider_id_14,
  t0.job_id AS job_id_15,
  t0.interview_id AS interview_id_16
FROM
  b_application t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.document_requested_at AS document_requested_at_3, t0.document_provided_at AS document_provided_at_4, t0.one_file_requested_at AS one_file_requested_at_5, t0.one_file_provided_at AS one_file_provided_at_6, t0.contract_sent_at AS contract_sent_at_7, t0.contract_file_name AS contract_file_name_8, t0.contract_signed_at AS contract_signed_at_9, t0.contract_signed_file_name AS contract_signed_file_name_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.employer_id AS employer_id_13, t0.provider_id AS provider_id_14, t0.job_id AS job_id_15, t0.interview_id AS interview_id_16 FROM b_application t0 WHERE t0.id = 0x0196FAD8388B7CB19F085C1B3BEE5BF2;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.country AS country_5,
  t0.state AS state_6,
  t0.city AS city_7,
  t0.street_address AS street_address_8,
  t0.expiration_date AS expiration_date_9,
  t0.highlight AS highlight_10,
  t0.schedule AS schedule_11,
  t0.start_date AS start_date_12,
  t0.year_of_experience AS year_of_experience_13,
  t0.pay_rate AS pay_rate_14,
  t0.work_type AS work_type_15,
  t0.need AS need_16,
  t0.pay_rate_hourly AS pay_rate_hourly_17,
  t0.pay_rate_daily AS pay_rate_daily_18,
  t0.blocked AS blocked_19,
  t0.job_id AS job_id_20,
  t0.verified AS verified_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.user_id AS user_id_24,
  t0.employer_id AS employer_id_25,
  t0.profession_id AS profession_id_26,
  t0.speciality_id AS speciality_id_27
FROM
  b_job t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.country AS country_5, t0.state AS state_6, t0.city AS city_7, t0.street_address AS street_address_8, t0.expiration_date AS expiration_date_9, t0.highlight AS highlight_10, t0.schedule AS schedule_11, t0.start_date AS start_date_12, t0.year_of_experience AS year_of_experience_13, t0.pay_rate AS pay_rate_14, t0.work_type AS work_type_15, t0.need AS need_16, t0.pay_rate_hourly AS pay_rate_hourly_17, t0.pay_rate_daily AS pay_rate_daily_18, t0.blocked AS blocked_19, t0.job_id AS job_id_20, t0.verified AS verified_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.user_id AS user_id_24, t0.employer_id AS employer_id_25, t0.profession_id AS profession_id_26, t0.speciality_id AS speciality_id_27 FROM b_job t0 WHERE t0.id = 0x0196D8BE386A77E3BD5FCDC8ABB01D26;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.document_requested_at AS document_requested_at_3,
  t0.document_provided_at AS document_provided_at_4,
  t0.one_file_requested_at AS one_file_requested_at_5,
  t0.one_file_provided_at AS one_file_provided_at_6,
  t0.contract_sent_at AS contract_sent_at_7,
  t0.contract_file_name AS contract_file_name_8,
  t0.contract_signed_at AS contract_signed_at_9,
  t0.contract_signed_file_name AS contract_signed_file_name_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.employer_id AS employer_id_13,
  t0.provider_id AS provider_id_14,
  t0.job_id AS job_id_15,
  t0.interview_id AS interview_id_16
FROM
  b_application t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.document_requested_at AS document_requested_at_3, t0.document_provided_at AS document_provided_at_4, t0.one_file_requested_at AS one_file_requested_at_5, t0.one_file_provided_at AS one_file_provided_at_6, t0.contract_sent_at AS contract_sent_at_7, t0.contract_file_name AS contract_file_name_8, t0.contract_signed_at AS contract_signed_at_9, t0.contract_signed_file_name AS contract_signed_file_name_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.employer_id AS employer_id_13, t0.provider_id AS provider_id_14, t0.job_id AS job_id_15, t0.interview_id AS interview_id_16 FROM b_application t0 WHERE t0.id = 0x019584E61709751FBA556835476F3156;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.country AS country_5,
  t0.state AS state_6,
  t0.city AS city_7,
  t0.street_address AS street_address_8,
  t0.expiration_date AS expiration_date_9,
  t0.highlight AS highlight_10,
  t0.schedule AS schedule_11,
  t0.start_date AS start_date_12,
  t0.year_of_experience AS year_of_experience_13,
  t0.pay_rate AS pay_rate_14,
  t0.work_type AS work_type_15,
  t0.need AS need_16,
  t0.pay_rate_hourly AS pay_rate_hourly_17,
  t0.pay_rate_daily AS pay_rate_daily_18,
  t0.blocked AS blocked_19,
  t0.job_id AS job_id_20,
  t0.verified AS verified_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.user_id AS user_id_24,
  t0.employer_id AS employer_id_25,
  t0.profession_id AS profession_id_26,
  t0.speciality_id AS speciality_id_27
FROM
  b_job t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.country AS country_5, t0.state AS state_6, t0.city AS city_7, t0.street_address AS street_address_8, t0.expiration_date AS expiration_date_9, t0.highlight AS highlight_10, t0.schedule AS schedule_11, t0.start_date AS start_date_12, t0.year_of_experience AS year_of_experience_13, t0.pay_rate AS pay_rate_14, t0.work_type AS work_type_15, t0.need AS need_16, t0.pay_rate_hourly AS pay_rate_hourly_17, t0.pay_rate_daily AS pay_rate_daily_18, t0.blocked AS blocked_19, t0.job_id AS job_id_20, t0.verified AS verified_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.user_id AS user_id_24, t0.employer_id AS employer_id_25, t0.profession_id AS profession_id_26, t0.speciality_id AS speciality_id_27 FROM b_job t0 WHERE t0.id = 0x019584CD8EA175359A2D1A5D555C135C;