Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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,
          b1_.id AS id_17,
          b1_.name AS name_18,
          b1_.suffix AS suffix_19,
          b1_.title AS title_20,
          b1_.npi_number AS npi_number_21,
          b1_.phone_home AS phone_home_22,
          b1_.phone_work AS phone_work_23,
          b1_.phone_mobile AS phone_mobile_24,
          b1_.cv_filename AS cv_filename_25,
          b1_.country AS country_26,
          b1_.state AS state_27,
          b1_.city AS city_28,
          b1_.zip_code AS zip_code_29,
          b1_.street_address AS street_address_30,
          b1_.desired_pay_rate AS desired_pay_rate_31,
          b1_.pay_rate_hourly AS pay_rate_hourly_32,
          b1_.pay_rate_daily AS pay_rate_daily_33,
          b1_.desired_hour AS desired_hour_34,
          b1_.desired_states AS desired_states_35,
          b1_.availability_to_start AS availability_to_start_36,
          b1_.willing_to_travel AS willing_to_travel_37,
          b1_.preferred_patient_volume AS preferred_patient_volume_38,
          b1_.release_authorization_date AS release_authorization_date_39,
          b1_.ssn AS ssn_40,
          b1_.dob AS dob_41,
          b1_.country_of_birth AS country_of_birth_42,
          b1_.state_of_birth AS state_of_birth_43,
          b1_.city_of_birth AS city_of_birth_44,
          b1_.release_and_authorization_accepted AS release_and_authorization_accepted_45,
          b1_.application_certification_date AS application_certification_date_46,
          b1_.risk_assessment AS risk_assessment_47,
          b1_.health_assessment AS health_assessment_48,
          b1_.cashback AS cashback_49,
          b1_.notification_preferences AS notification_preferences_50,
          b1_.average_point AS average_point_51,
          b1_.skip_onboarding AS skip_onboarding_52,
          b1_.created_at AS created_at_53,
          b1_.updated_at AS updated_at_54,
          b2_.id AS id_55,
          b2_.name AS name_56,
          b2_.email AS email_57,
          b2_.user_type AS user_type_58,
          b2_.roles AS roles_59,
          b2_.password AS password_60,
          b2_.is_verified AS is_verified_61,
          b2_.oauth_provider AS oauth_provider_62,
          b2_.oauth_id AS oauth_id_63,
          b2_.profile_picture_filename AS profile_picture_filename_64,
          b2_.oauth_data AS oauth_data_65,
          b2_.on_boarding_completed_at AS on_boarding_completed_at_66,
          b2_.dob AS dob_67,
          b2_.gender AS gender_68,
          b2_.phone1 AS phone1_69,
          b2_.phone2 AS phone2_70,
          b2_.bio AS bio_71,
          b2_.nickname AS nickname_72,
          b2_.blocked AS blocked_73,
          b2_.is_hybrid_recruiter AS is_hybrid_recruiter_74,
          b2_.address AS address_75,
          b2_.created_at AS created_at_76,
          b2_.updated_at AS updated_at_77,
          b3_.id AS id_78,
          b3_.name AS name_79,
          b3_.provided_at AS provided_at_80,
          b3_.created_at AS created_at_81,
          b3_.updated_at AS updated_at_82,
          b4_.id AS id_83,
          b4_.message AS message_84,
          b4_.reviewed_by AS reviewed_by_85,
          b4_.point AS point_86,
          b4_.professionalism AS professionalism_87,
          b4_.quality AS quality_88,
          b4_.communication AS communication_89,
          b4_.emotional_intelligence AS emotional_intelligence_90,
          b4_.created_at AS created_at_91,
          b4_.updated_at AS updated_at_92
        FROM
          b_application b0_
          INNER JOIN b_job b5_ ON b0_.job_id = b5_.id
          LEFT JOIN b_job_recruiter b6_ ON (b6_.job_id = b5_.id)
          LEFT JOIN b_provider b1_ ON b0_.provider_id = b1_.id
          LEFT JOIN b_user b2_ ON b1_.user_id = b2_.id
          LEFT JOIN b_document_request b3_ ON b0_.id = b3_.application_id
          LEFT JOIN b_review b4_ ON b0_.id = b4_.application_id
        WHERE
          1 = 1
          AND b0_.archived_at IS NULL
          AND b0_.status IN (?, ?)
          AND (
            (
              b0_.recruiter_id = ?
              OR b6_.recruiter_id = ?
              OR b5_.assigned_recruiter_id = ?
            )
          )
          AND (
            (
              b0_.recruiter_id IS NULL
              OR b0_.recruiter_id <> ?
            )
          )
        ORDER BY
          b0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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, b1_.id AS id_17, b1_.name AS name_18, b1_.suffix AS suffix_19, b1_.title AS title_20, b1_.npi_number AS npi_number_21, b1_.phone_home AS phone_home_22, b1_.phone_work AS phone_work_23, b1_.phone_mobile AS phone_mobile_24, b1_.cv_filename AS cv_filename_25, b1_.country AS country_26, b1_.state AS state_27, b1_.city AS city_28, b1_.zip_code AS zip_code_29, b1_.street_address AS street_address_30, b1_.desired_pay_rate AS desired_pay_rate_31, b1_.pay_rate_hourly AS pay_rate_hourly_32, b1_.pay_rate_daily AS pay_rate_daily_33, b1_.desired_hour AS desired_hour_34, b1_.desired_states AS desired_states_35, b1_.availability_to_start AS availability_to_start_36, b1_.willing_to_travel AS willing_to_travel_37, b1_.preferred_patient_volume AS preferred_patient_volume_38, b1_.release_authorization_date AS release_authorization_date_39, b1_.ssn AS ssn_40, b1_.dob AS dob_41, b1_.country_of_birth AS country_of_birth_42, b1_.state_of_birth AS state_of_birth_43, b1_.city_of_birth AS city_of_birth_44, b1_.release_and_authorization_accepted AS release_and_authorization_accepted_45, b1_.application_certification_date AS application_certification_date_46, b1_.risk_assessment AS risk_assessment_47, b1_.health_assessment AS health_assessment_48, b1_.cashback AS cashback_49, b1_.notification_preferences AS notification_preferences_50, b1_.average_point AS average_point_51, b1_.skip_onboarding AS skip_onboarding_52, b1_.created_at AS created_at_53, b1_.updated_at AS updated_at_54, b2_.id AS id_55, b2_.name AS name_56, b2_.email AS email_57, b2_.user_type AS user_type_58, b2_.roles AS roles_59, b2_.password AS password_60, b2_.is_verified AS is_verified_61, b2_.oauth_provider AS oauth_provider_62, b2_.oauth_id AS oauth_id_63, b2_.profile_picture_filename AS profile_picture_filename_64, b2_.oauth_data AS oauth_data_65, b2_.on_boarding_completed_at AS on_boarding_completed_at_66, b2_.dob AS dob_67, b2_.gender AS gender_68, b2_.phone1 AS phone1_69, b2_.phone2 AS phone2_70, b2_.bio AS bio_71, b2_.nickname AS nickname_72, b2_.blocked AS blocked_73, b2_.is_hybrid_recruiter AS is_hybrid_recruiter_74, b2_.address AS address_75, b2_.created_at AS created_at_76, b2_.updated_at AS updated_at_77, b3_.id AS id_78, b3_.name AS name_79, b3_.provided_at AS provided_at_80, b3_.created_at AS created_at_81, b3_.updated_at AS updated_at_82, b4_.id AS id_83, b4_.message AS message_84, b4_.reviewed_by AS reviewed_by_85, b4_.point AS point_86, b4_.professionalism AS professionalism_87, b4_.quality AS quality_88, b4_.communication AS communication_89, b4_.emotional_intelligence AS emotional_intelligence_90, b4_.created_at AS created_at_91, b4_.updated_at AS updated_at_92 FROM b_application b0_ INNER JOIN b_job b5_ ON b0_.job_id = b5_.id LEFT JOIN b_job_recruiter b6_ ON (b6_.job_id = b5_.id) LEFT JOIN b_provider b1_ ON b0_.provider_id = b1_.id LEFT JOIN b_user b2_ ON b1_.user_id = b2_.id LEFT JOIN b_document_request b3_ ON b0_.id = b3_.application_id LEFT JOIN b_review b4_ ON b0_.id = b4_.application_id WHERE 1 = 1 AND b0_.archived_at IS NULL AND b0_.status IN ('accepted', 'hired') AND ((b0_.recruiter_id = 0x1F0E649F12CB6C629070732418ED76C0 OR b6_.recruiter_id = 0x1F0E649F12CB6C629070732418ED76C0 OR b5_.assigned_recruiter_id = 0x1F0E649F12CB6C629070732418ED76C0)) AND ((b0_.recruiter_id IS NULL OR b0_.recruiter_id <> 0x1F0E649F12CB6C629070732418ED76C0)) ORDER BY b0_.id DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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,
          b1_.id AS id_17,
          b1_.name AS name_18,
          b1_.suffix AS suffix_19,
          b1_.title AS title_20,
          b1_.npi_number AS npi_number_21,
          b1_.phone_home AS phone_home_22,
          b1_.phone_work AS phone_work_23,
          b1_.phone_mobile AS phone_mobile_24,
          b1_.cv_filename AS cv_filename_25,
          b1_.country AS country_26,
          b1_.state AS state_27,
          b1_.city AS city_28,
          b1_.zip_code AS zip_code_29,
          b1_.street_address AS street_address_30,
          b1_.desired_pay_rate AS desired_pay_rate_31,
          b1_.pay_rate_hourly AS pay_rate_hourly_32,
          b1_.pay_rate_daily AS pay_rate_daily_33,
          b1_.desired_hour AS desired_hour_34,
          b1_.desired_states AS desired_states_35,
          b1_.availability_to_start AS availability_to_start_36,
          b1_.willing_to_travel AS willing_to_travel_37,
          b1_.preferred_patient_volume AS preferred_patient_volume_38,
          b1_.release_authorization_date AS release_authorization_date_39,
          b1_.ssn AS ssn_40,
          b1_.dob AS dob_41,
          b1_.country_of_birth AS country_of_birth_42,
          b1_.state_of_birth AS state_of_birth_43,
          b1_.city_of_birth AS city_of_birth_44,
          b1_.release_and_authorization_accepted AS release_and_authorization_accepted_45,
          b1_.application_certification_date AS application_certification_date_46,
          b1_.risk_assessment AS risk_assessment_47,
          b1_.health_assessment AS health_assessment_48,
          b1_.cashback AS cashback_49,
          b1_.notification_preferences AS notification_preferences_50,
          b1_.average_point AS average_point_51,
          b1_.skip_onboarding AS skip_onboarding_52,
          b1_.created_at AS created_at_53,
          b1_.updated_at AS updated_at_54,
          b2_.id AS id_55,
          b2_.name AS name_56,
          b2_.email AS email_57,
          b2_.user_type AS user_type_58,
          b2_.roles AS roles_59,
          b2_.password AS password_60,
          b2_.is_verified AS is_verified_61,
          b2_.oauth_provider AS oauth_provider_62,
          b2_.oauth_id AS oauth_id_63,
          b2_.profile_picture_filename AS profile_picture_filename_64,
          b2_.oauth_data AS oauth_data_65,
          b2_.on_boarding_completed_at AS on_boarding_completed_at_66,
          b2_.dob AS dob_67,
          b2_.gender AS gender_68,
          b2_.phone1 AS phone1_69,
          b2_.phone2 AS phone2_70,
          b2_.bio AS bio_71,
          b2_.nickname AS nickname_72,
          b2_.blocked AS blocked_73,
          b2_.is_hybrid_recruiter AS is_hybrid_recruiter_74,
          b2_.address AS address_75,
          b2_.created_at AS created_at_76,
          b2_.updated_at AS updated_at_77,
          b3_.id AS id_78,
          b3_.name AS name_79,
          b3_.provided_at AS provided_at_80,
          b3_.created_at AS created_at_81,
          b3_.updated_at AS updated_at_82,
          b4_.id AS id_83,
          b4_.message AS message_84,
          b4_.reviewed_by AS reviewed_by_85,
          b4_.point AS point_86,
          b4_.professionalism AS professionalism_87,
          b4_.quality AS quality_88,
          b4_.communication AS communication_89,
          b4_.emotional_intelligence AS emotional_intelligence_90,
          b4_.created_at AS created_at_91,
          b4_.updated_at AS updated_at_92,
          b5_.id AS id_93,
          b5_.status AS status_94,
          b5_.commission_rate AS commission_rate_95,
          b5_.assigned_at AS assigned_at_96,
          b6_.id AS id_97,
          b6_.title AS title_98,
          b6_.description AS description_99,
          b6_.status AS status_100,
          b6_.country AS country_101,
          b6_.state AS state_102,
          b6_.city AS city_103,
          b6_.street_address AS street_address_104,
          b6_.expiration_date AS expiration_date_105,
          b6_.highlight AS highlight_106,
          b6_.schedule AS schedule_107,
          b6_.start_date AS start_date_108,
          b6_.year_of_experience AS year_of_experience_109,
          b6_.pay_rate AS pay_rate_110,
          b6_.work_type AS work_type_111,
          b6_.need AS need_112,
          b6_.pay_rate_hourly AS pay_rate_hourly_113,
          b6_.pay_rate_daily AS pay_rate_daily_114,
          b6_.annual_salary AS annual_salary_115,
          b6_.monthly_salary AS monthly_salary_116,
          b6_.salary_type AS salary_type_117,
          b6_.blocked AS blocked_118,
          b6_.job_id AS job_id_119,
          b6_.verified AS verified_120,
          b6_.is_mediated AS is_mediated_121,
          b6_.`rank` AS rank_122,
          b6_.created_at AS created_at_123,
          b6_.updated_at AS updated_at_124
        FROM
          b_application b0_
          INNER JOIN b_job b6_ ON b0_.job_id = b6_.id
          LEFT JOIN b_job_recruiter b5_ ON (b5_.job_id = b6_.id)
          LEFT JOIN b_provider b1_ ON b0_.provider_id = b1_.id
          LEFT JOIN b_user b2_ ON b1_.user_id = b2_.id
          LEFT JOIN b_document_request b3_ ON b0_.id = b3_.application_id
          LEFT JOIN b_review b4_ ON b0_.id = b4_.application_id
        WHERE
          1 = 1
          AND b0_.archived_at IS NULL
          AND b0_.status IN (?, ?)
          AND (
            (
              b0_.recruiter_id = ?
              OR b5_.recruiter_id = ?
              OR b6_.assigned_recruiter_id = ?
            )
          )
          AND (
            (
              b0_.recruiter_id IS NULL
              OR b0_.recruiter_id <> ?
            )
          )
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  25

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (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, b1_.id AS id_17, b1_.name AS name_18, b1_.suffix AS suffix_19, b1_.title AS title_20, b1_.npi_number AS npi_number_21, b1_.phone_home AS phone_home_22, b1_.phone_work AS phone_work_23, b1_.phone_mobile AS phone_mobile_24, b1_.cv_filename AS cv_filename_25, b1_.country AS country_26, b1_.state AS state_27, b1_.city AS city_28, b1_.zip_code AS zip_code_29, b1_.street_address AS street_address_30, b1_.desired_pay_rate AS desired_pay_rate_31, b1_.pay_rate_hourly AS pay_rate_hourly_32, b1_.pay_rate_daily AS pay_rate_daily_33, b1_.desired_hour AS desired_hour_34, b1_.desired_states AS desired_states_35, b1_.availability_to_start AS availability_to_start_36, b1_.willing_to_travel AS willing_to_travel_37, b1_.preferred_patient_volume AS preferred_patient_volume_38, b1_.release_authorization_date AS release_authorization_date_39, b1_.ssn AS ssn_40, b1_.dob AS dob_41, b1_.country_of_birth AS country_of_birth_42, b1_.state_of_birth AS state_of_birth_43, b1_.city_of_birth AS city_of_birth_44, b1_.release_and_authorization_accepted AS release_and_authorization_accepted_45, b1_.application_certification_date AS application_certification_date_46, b1_.risk_assessment AS risk_assessment_47, b1_.health_assessment AS health_assessment_48, b1_.cashback AS cashback_49, b1_.notification_preferences AS notification_preferences_50, b1_.average_point AS average_point_51, b1_.skip_onboarding AS skip_onboarding_52, b1_.created_at AS created_at_53, b1_.updated_at AS updated_at_54, b2_.id AS id_55, b2_.name AS name_56, b2_.email AS email_57, b2_.user_type AS user_type_58, b2_.roles AS roles_59, b2_.password AS password_60, b2_.is_verified AS is_verified_61, b2_.oauth_provider AS oauth_provider_62, b2_.oauth_id AS oauth_id_63, b2_.profile_picture_filename AS profile_picture_filename_64, b2_.oauth_data AS oauth_data_65, b2_.on_boarding_completed_at AS on_boarding_completed_at_66, b2_.dob AS dob_67, b2_.gender AS gender_68, b2_.phone1 AS phone1_69, b2_.phone2 AS phone2_70, b2_.bio AS bio_71, b2_.nickname AS nickname_72, b2_.blocked AS blocked_73, b2_.is_hybrid_recruiter AS is_hybrid_recruiter_74, b2_.address AS address_75, b2_.created_at AS created_at_76, b2_.updated_at AS updated_at_77, b3_.id AS id_78, b3_.name AS name_79, b3_.provided_at AS provided_at_80, b3_.created_at AS created_at_81, b3_.updated_at AS updated_at_82, b4_.id AS id_83, b4_.message AS message_84, b4_.reviewed_by AS reviewed_by_85, b4_.point AS point_86, b4_.professionalism AS professionalism_87, b4_.quality AS quality_88, b4_.communication AS communication_89, b4_.emotional_intelligence AS emotional_intelligence_90, b4_.created_at AS created_at_91, b4_.updated_at AS updated_at_92, b5_.id AS id_93, b5_.status AS status_94, b5_.commission_rate AS commission_rate_95, b5_.assigned_at AS assigned_at_96, b6_.id AS id_97, b6_.title AS title_98, b6_.description AS description_99, b6_.status AS status_100, b6_.country AS country_101, b6_.state AS state_102, b6_.city AS city_103, b6_.street_address AS street_address_104, b6_.expiration_date AS expiration_date_105, b6_.highlight AS highlight_106, b6_.schedule AS schedule_107, b6_.start_date AS start_date_108, b6_.year_of_experience AS year_of_experience_109, b6_.pay_rate AS pay_rate_110, b6_.work_type AS work_type_111, b6_.need AS need_112, b6_.pay_rate_hourly AS pay_rate_hourly_113, b6_.pay_rate_daily AS pay_rate_daily_114, b6_.annual_salary AS annual_salary_115, b6_.monthly_salary AS monthly_salary_116, b6_.salary_type AS salary_type_117, b6_.blocked AS blocked_118, b6_.job_id AS job_id_119, b6_.verified AS verified_120, b6_.is_mediated AS is_mediated_121, b6_.`rank` AS rank_122, b6_.created_at AS created_at_123, b6_.updated_at AS updated_at_124 FROM b_application b0_ INNER JOIN b_job b6_ ON b0_.job_id = b6_.id LEFT JOIN b_job_recruiter b5_ ON (b5_.job_id = b6_.id) LEFT JOIN b_provider b1_ ON b0_.provider_id = b1_.id LEFT JOIN b_user b2_ ON b1_.user_id = b2_.id LEFT JOIN b_document_request b3_ ON b0_.id = b3_.application_id LEFT JOIN b_review b4_ ON b0_.id = b4_.application_id WHERE 1 = 1 AND b0_.archived_at IS NULL AND b0_.status IN ('accepted', 'hired') AND ((b0_.recruiter_id = 0x1F0E649F12CB6C629070732418ED76C0 OR b5_.recruiter_id = 0x1F0E649F12CB6C629070732418ED76C0 OR b6_.assigned_recruiter_id = 0x1F0E649F12CB6C629070732418ED76C0)) AND ((b0_.recruiter_id IS NULL OR b0_.recruiter_id <> 0x1F0E649F12CB6C629070732418ED76C0))) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 25;

SELECT
  b0_.status AS status_0,
  COUNT(b0_.id) AS sclr_1
FROM
  b_application b0_
  INNER JOIN b_job b1_ ON b0_.job_id = b1_.id
  INNER JOIN b_job_recruiter b2_ ON (b2_.job_id = b1_.id)
WHERE
  (
    (
      b2_.recruiter_id = ?
      OR b1_.assigned_recruiter_id = ?
    )
  )
  AND (
    (
      b0_.recruiter_id IS NULL
      OR b0_.recruiter_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_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id INNER JOIN b_job_recruiter b2_ ON (b2_.job_id = b1_.id) WHERE ((b2_.recruiter_id = 0x1F0E649F12CB6C629070732418ED76C0 OR b1_.assigned_recruiter_id = 0x1F0E649F12CB6C629070732418ED76C0)) AND ((b0_.recruiter_id IS NULL OR b0_.recruiter_id <> 0x1F0E649F12CB6C629070732418ED76C0)) AND b0_.archived_at IS NULL GROUP BY b0_.status;

SELECT
  count(b0_.id) AS sclr_0
FROM
  b_application b0_
  INNER JOIN b_job b1_ ON b0_.job_id = b1_.id
  LEFT JOIN b_job_recruiter b2_ ON (b2_.job_id = b1_.id)
WHERE
  (
    b2_.recruiter_id = ?
    OR b1_.assigned_recruiter_id = ?
  )
  AND (
    b0_.recruiter_id IS NULL
    OR b0_.recruiter_id <> ?
  )
  AND b0_.archived_at IS NULL

SELECT count(b0_.id) AS sclr_0 FROM b_application b0_ INNER JOIN b_job b1_ ON b0_.job_id = b1_.id LEFT JOIN b_job_recruiter b2_ ON (b2_.job_id = b1_.id) WHERE (b2_.recruiter_id = 0x1F0E649F12CB6C629070732418ED76C0 OR b1_.assigned_recruiter_id = 0x1F0E649F12CB6C629070732418ED76C0) AND (b0_.recruiter_id IS NULL OR b0_.recruiter_id <> 0x1F0E649F12CB6C629070732418ED76C0) AND b0_.archived_at IS NULL;

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.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;