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_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.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_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.id = 0x1F0E649F12CC645A9429732418ED76C0;

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.annual_salary AS annual_salary_19,
  t0.monthly_salary AS monthly_salary_20,
  t0.salary_type AS salary_type_21,
  t0.blocked AS blocked_22,
  t0.job_id AS job_id_23,
  t0.verified AS verified_24,
  t0.is_mediated AS is_mediated_25,
  t0.`rank` AS rank_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.user_id AS user_id_29,
  t0.employer_id AS employer_id_30,
  t0.profession_id AS profession_id_31,
  t0.speciality_id AS speciality_id_32,
  t0.assigned_recruiter_id AS assigned_recruiter_id_33
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.annual_salary AS annual_salary_19, t0.monthly_salary AS monthly_salary_20, t0.salary_type AS salary_type_21, t0.blocked AS blocked_22, t0.job_id AS job_id_23, t0.verified AS verified_24, t0.is_mediated AS is_mediated_25, t0.`rank` AS rank_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.user_id AS user_id_29, t0.employer_id AS employer_id_30, t0.profession_id AS profession_id_31, t0.speciality_id AS speciality_id_32, t0.assigned_recruiter_id AS assigned_recruiter_id_33 FROM b_job t0 WHERE t0.id = 0x1F0EDD68C0556F8A8BE9D11A55DF1690;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.commission_rate AS commission_rate_3,
  t0.assigned_at AS assigned_at_4,
  t0.job_id AS job_id_5,
  t0.recruiter_id AS recruiter_id_6
FROM
  b_job_recruiter t0
WHERE
  t0.job_id = ?
  AND t0.recruiter_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2, t0.commission_rate AS commission_rate_3, t0.assigned_at AS assigned_at_4, t0.job_id AS job_id_5, t0.recruiter_id AS recruiter_id_6 FROM b_job_recruiter t0 WHERE t0.job_id = 0x1F0EDD68C0556F8A8BE9D11A55DF1690 AND t0.recruiter_id = 0x1F0E649F12CB6C629070732418ED76C0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.applied_at AS applied_at_3,
  t0.hired_at AS hired_at_4,
  t0.document_requested_at AS document_requested_at_5,
  t0.document_provided_at AS document_provided_at_6,
  t0.one_file_requested_at AS one_file_requested_at_7,
  t0.one_file_provided_at AS one_file_provided_at_8,
  t0.contract_sent_at AS contract_sent_at_9,
  t0.contract_file_name AS contract_file_name_10,
  t0.contract_signed_at AS contract_signed_at_11,
  t0.contract_signed_file_name AS contract_signed_file_name_12,
  t0.`rank` AS rank_13,
  t0.archived_at AS archived_at_14,
  t0.is_archived AS is_archived_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.employer_id AS employer_id_18,
  t0.recruiter_id AS recruiter_id_19,
  t0.provider_id AS provider_id_20,
  t0.job_id AS job_id_21,
  t0.interview_id AS interview_id_22
FROM
  b_application t0
WHERE
  t0.job_id = ?
  AND t0.employer_id = ?
  AND t0.is_archived = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2, t0.applied_at AS applied_at_3, t0.hired_at AS hired_at_4, t0.document_requested_at AS document_requested_at_5, t0.document_provided_at AS document_provided_at_6, t0.one_file_requested_at AS one_file_requested_at_7, t0.one_file_provided_at AS one_file_provided_at_8, t0.contract_sent_at AS contract_sent_at_9, t0.contract_file_name AS contract_file_name_10, t0.contract_signed_at AS contract_signed_at_11, t0.contract_signed_file_name AS contract_signed_file_name_12, t0.`rank` AS rank_13, t0.archived_at AS archived_at_14, t0.is_archived AS is_archived_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.employer_id AS employer_id_18, t0.recruiter_id AS recruiter_id_19, t0.provider_id AS provider_id_20, t0.job_id AS job_id_21, t0.interview_id AS interview_id_22 FROM b_application t0 WHERE t0.job_id = 0x1F0EDD68C0556F8A8BE9D11A55DF1690 AND t0.employer_id = 0x0194C15E27807AD292D205BBE18ED47F AND t0.is_archived = 0 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.applied_at AS applied_at_3,
  t0.hired_at AS hired_at_4,
  t0.document_requested_at AS document_requested_at_5,
  t0.document_provided_at AS document_provided_at_6,
  t0.one_file_requested_at AS one_file_requested_at_7,
  t0.one_file_provided_at AS one_file_provided_at_8,
  t0.contract_sent_at AS contract_sent_at_9,
  t0.contract_file_name AS contract_file_name_10,
  t0.contract_signed_at AS contract_signed_at_11,
  t0.contract_signed_file_name AS contract_signed_file_name_12,
  t0.`rank` AS rank_13,
  t0.archived_at AS archived_at_14,
  t0.is_archived AS is_archived_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.employer_id AS employer_id_18,
  t0.recruiter_id AS recruiter_id_19,
  t0.provider_id AS provider_id_20,
  t0.job_id AS job_id_21,
  t0.interview_id AS interview_id_22
FROM
  b_application t0
WHERE
  t0.job_id = ?
  AND t0.is_archived = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.status AS status_2, t0.applied_at AS applied_at_3, t0.hired_at AS hired_at_4, t0.document_requested_at AS document_requested_at_5, t0.document_provided_at AS document_provided_at_6, t0.one_file_requested_at AS one_file_requested_at_7, t0.one_file_provided_at AS one_file_provided_at_8, t0.contract_sent_at AS contract_sent_at_9, t0.contract_file_name AS contract_file_name_10, t0.contract_signed_at AS contract_signed_at_11, t0.contract_signed_file_name AS contract_signed_file_name_12, t0.`rank` AS rank_13, t0.archived_at AS archived_at_14, t0.is_archived AS is_archived_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.employer_id AS employer_id_18, t0.recruiter_id AS recruiter_id_19, t0.provider_id AS provider_id_20, t0.job_id AS job_id_21, t0.interview_id AS interview_id_22 FROM b_application t0 WHERE t0.job_id = 0x1F0EDD68C0556F8A8BE9D11A55DF1690 AND t0.is_archived = 0 ORDER BY t0.id DESC;

SELECT
  b0_.id AS id_0,
  b0_.status AS status_1,
  b0_.applied_at AS applied_at_2,
  b0_.hired_at AS hired_at_3,
  b0_.document_requested_at AS document_requested_at_4,
  b0_.document_provided_at AS document_provided_at_5,
  b0_.one_file_requested_at AS one_file_requested_at_6,
  b0_.one_file_provided_at AS one_file_provided_at_7,
  b0_.contract_sent_at AS contract_sent_at_8,
  b0_.contract_file_name AS contract_file_name_9,
  b0_.contract_signed_at AS contract_signed_at_10,
  b0_.contract_signed_file_name AS contract_signed_file_name_11,
  b0_.`rank` AS rank_12,
  b0_.archived_at AS archived_at_13,
  b0_.is_archived AS is_archived_14,
  b0_.created_at AS created_at_15,
  b0_.updated_at AS updated_at_16,
  b0_.employer_id AS employer_id_17,
  b0_.recruiter_id AS recruiter_id_18,
  b0_.provider_id AS provider_id_19,
  b0_.job_id AS job_id_20,
  b0_.interview_id AS interview_id_21
FROM
  b_application b0_
  INNER JOIN b_job b1_ ON b0_.job_id = b1_.id
WHERE
  b0_.is_archived = 0
  AND b0_.employer_id = ?
  AND b0_.job_id = ?
ORDER BY
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.status AS status_1, b0_.applied_at AS applied_at_2, b0_.hired_at AS hired_at_3, b0_.document_requested_at AS document_requested_at_4, b0_.document_provided_at AS document_provided_at_5, b0_.one_file_requested_at AS one_file_requested_at_6, b0_.one_file_provided_at AS one_file_provided_at_7, b0_.contract_sent_at AS contract_sent_at_8, b0_.contract_file_name AS contract_file_name_9, b0_.contract_signed_at AS contract_signed_at_10, b0_.contract_signed_file_name AS contract_signed_file_name_11, b0_.`rank` AS rank_12, b0_.archived_at AS archived_at_13, b0_.is_archived AS is_archived_14, b0_.created_at AS created_at_15, b0_.updated_at AS updated_at_16, b0_.employer_id AS employer_id_17, b0_.recruiter_id AS recruiter_id_18, b0_.provider_id AS provider_id_19, b0_.job_id AS job_id_20, b0_.interview_id AS interview_id_21 FROM b_application b0_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id WHERE b0_.is_archived = 0 AND b0_.employer_id = '0194c15e-2780-7ad2-92d2-05bbe18ed47f' AND b0_.job_id = '1f0edd68-c055-6f8a-8be9-d11a55df1690' ORDER BY b0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.degree AS degree_2,
  t0.school AS school_3,
  t0.field_of_study AS field_of_study_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.grade AS grade_7,
  t0.description AS description_8,
  t0.country AS country_9,
  t0.state AS state_10,
  t0.city AS city_11,
  t0.user_id AS user_id_12
FROM
  b_provider_education t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.degree AS degree_2, t0.school AS school_3, t0.field_of_study AS field_of_study_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.grade AS grade_7, t0.description AS description_8, t0.country AS country_9, t0.state AS state_10, t0.city AS city_11, t0.user_id AS user_id_12 FROM b_provider_education t0 WHERE t0.user_id = 0x1F0E649F12CC645A9429732418ED76C0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.employment_type AS employment_type_3,
  t0.company AS company_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.location AS location_7,
  t0.location_type AS location_type_8,
  t0.description AS description_9,
  t0.user_id AS user_id_10
FROM
  b_provider_experience t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.employment_type AS employment_type_3, t0.company AS company_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.location AS location_7, t0.location_type AS location_type_8, t0.description AS description_9, t0.user_id AS user_id_10 FROM b_provider_experience t0 WHERE t0.user_id = 0x1F0E649F12CC645A9429732418ED76C0;

SELECT
  t0.id AS id_1,
  t0.carrier AS carrier_2,
  t0.policy_number AS policy_number_3,
  t0.amount AS amount_4,
  t0.state AS state_5,
  t0.city AS city_6,
  t0.effective_date AS effective_date_7,
  t0.expiration_date AS expiration_date_8,
  t0.user_id AS user_id_9
FROM
  b_provider_insurance t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.carrier AS carrier_2, t0.policy_number AS policy_number_3, t0.amount AS amount_4, t0.state AS state_5, t0.city AS city_6, t0.effective_date AS effective_date_7, t0.expiration_date AS expiration_date_8, t0.user_id AS user_id_9 FROM b_provider_insurance t0 WHERE t0.user_id = 0x1F0E649F12CC645A9429732418ED76C0;

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.recruiter_id AS recruiter_id_13,
  t0.application_id AS application_id_14
FROM
  b_review t0
WHERE
  t0.application_id = ?
  AND t0.provider_id = ?
LIMIT
  1

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.recruiter_id AS recruiter_id_13, t0.application_id AS application_id_14 FROM b_review t0 WHERE t0.application_id = 0x1F0EDD6D521A600CA3C4BF8CA0545471 AND t0.provider_id = 0x1F0ECA8D91B56A1A8F1F37CD0F3E6203 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.provided_at AS provided_at_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.provider_id AS provider_id_6,
  t0.requested_by_id AS requested_by_id_7,
  t0.application_id AS application_id_8,
  t0.document_id AS document_id_9
FROM
  b_document_request t0
WHERE
  t0.provider_id = ?
  AND t0.application_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.provided_at AS provided_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.provider_id AS provider_id_6, t0.requested_by_id AS requested_by_id_7, t0.application_id AS application_id_8, t0.document_id AS document_id_9 FROM b_document_request t0 WHERE t0.provider_id = 0x1F0ECA8D91B56A1A8F1F37CD0F3E6203 AND t0.application_id = 0x1F0EDD6D521A600CA3C4BF8CA0545471;

SELECT
  b0_.status AS status_0,
  COUNT(b0_.id) AS sclr_1
FROM
  b_application b0_
WHERE
  b0_.job_id = ?
  AND b0_.archived_at IS NULL
GROUP BY
  b0_.status

SELECT b0_.status AS status_0, COUNT(b0_.id) AS sclr_1 FROM b_application b0_ WHERE b0_.job_id = 0x1F0EDD68C0556F8A8BE9D11A55DF1690 AND b0_.archived_at IS NULL GROUP BY b0_.status;

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 = 0x1F0E649F12CC645A9429732418ED76C0 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 = 0x1F0E649F12CC645A9429732418ED76C0 AND t0.seen = 0;