Symfony Profiler

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 = ?
      ) 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 = 0x1F0E649F12CB6C629070732418ED76C0) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 25;

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,
  b0_.employer_id AS employer_id_93,
  b0_.recruiter_id AS recruiter_id_94,
  b0_.provider_id AS provider_id_95,
  b0_.job_id AS job_id_96,
  b0_.interview_id AS interview_id_97,
  b1_.user_id AS user_id_98,
  b1_.profession_id AS profession_id_99,
  b2_.employer_id AS employer_id_100,
  b2_.recruiter_id AS recruiter_id_101,
  b3_.provider_id AS provider_id_102,
  b3_.requested_by_id AS requested_by_id_103,
  b3_.application_id AS application_id_104,
  b3_.document_id AS document_id_105,
  b4_.provider_id AS provider_id_106,
  b4_.employer_id AS employer_id_107,
  b4_.recruiter_id AS recruiter_id_108,
  b4_.application_id AS application_id_109
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 = ?
  AND b0_.id IN (?)
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, 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, b0_.employer_id AS employer_id_93, b0_.recruiter_id AS recruiter_id_94, b0_.provider_id AS provider_id_95, b0_.job_id AS job_id_96, b0_.interview_id AS interview_id_97, b1_.user_id AS user_id_98, b1_.profession_id AS profession_id_99, b2_.employer_id AS employer_id_100, b2_.recruiter_id AS recruiter_id_101, b3_.provider_id AS provider_id_102, b3_.requested_by_id AS requested_by_id_103, b3_.application_id AS application_id_104, b3_.document_id AS document_id_105, b4_.provider_id AS provider_id_106, b4_.employer_id AS employer_id_107, b4_.recruiter_id AS recruiter_id_108, b4_.application_id AS application_id_109 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 = 0x1F0E649F12CB6C629070732418ED76C0 AND b0_.id IN (0x1F0EDD6D521A600CA3C4BF8CA0545471) ORDER BY b0_.id DESC;

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.application_id = ?
  AND t0.provider_id = ?
  AND t0.provided_at IS NULL

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.application_id = 0x1F0EDD6D521A600CA3C4BF8CA0545471 AND t0.provider_id = 0x1F0ECA8D91B56A1A8F1F37CD0F3E6203 AND t0.provided_at IS NULL;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.type AS type_4,
  t0.is_completed AS is_completed_5,
  t0.created_at AS created_at_6,
  t0.completed_at AS completed_at_7,
  t0.provider_id AS provider_id_8,
  t0.employer_id AS employer_id_9,
  t0.recruiter_id AS recruiter_id_10,
  t0.bookmark_id AS bookmark_id_11,
  t0.job_id AS job_id_12,
  t0.document_request_id AS document_request_id_13
FROM
  to_do t0
WHERE
  t0.recruiter_id = ?
  AND t0.is_completed = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.is_completed AS is_completed_5, t0.created_at AS created_at_6, t0.completed_at AS completed_at_7, t0.provider_id AS provider_id_8, t0.employer_id AS employer_id_9, t0.recruiter_id AS recruiter_id_10, t0.bookmark_id AS bookmark_id_11, t0.job_id AS job_id_12, t0.document_request_id AS document_request_id_13 FROM to_do t0 WHERE t0.recruiter_id = 0x1F0E649F12CB6C629070732418ED76C0 AND t0.is_completed = 0;

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 = ?
        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 = 0x1F0E649F12CB6C629070732418ED76C0 ORDER BY b0_.id DESC) dctrn_result) dctrn_table;