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.stripe_customer_id AS stripe_customer_id_15,
  t0.stripe_connect_id AS stripe_connect_id_16,
  t0.stripe_account_status AS stripe_account_status_17,
  t0.subscription_status AS subscription_status_18,
  t0.subscription_ends_at AS subscription_ends_at_19,
  t0.custom_fee_structure AS custom_fee_structure_20,
  t0.phone1 AS phone1_21,
  t0.phone2 AS phone2_22,
  t0.bio AS bio_23,
  t0.nickname AS nickname_24,
  t0.blocked AS blocked_25,
  t0.mfa_code AS mfa_code_26,
  t0.mfa_expires_at AS mfa_expires_at_27,
  t0.is_hybrid_recruiter AS is_hybrid_recruiter_28,
  t0.address AS address_29,
  t0.created_at AS created_at_30,
  t0.updated_at AS updated_at_31,
  t0.employer_id AS employer_id_32,
  t0.staffing_agency_id AS staffing_agency_id_33,
  t35.id AS id_34,
  t35.name AS name_36,
  t35.suffix AS suffix_37,
  t35.title AS title_38,
  t35.npi_number AS npi_number_39,
  t35.phone_home AS phone_home_40,
  t35.phone_work AS phone_work_41,
  t35.phone_mobile AS phone_mobile_42,
  t35.cv_filename AS cv_filename_43,
  t35.country AS country_44,
  t35.state AS state_45,
  t35.city AS city_46,
  t35.zip_code AS zip_code_47,
  t35.street_address AS street_address_48,
  t35.desired_pay_rate AS desired_pay_rate_49,
  t35.pay_rate_hourly AS pay_rate_hourly_50,
  t35.pay_rate_daily AS pay_rate_daily_51,
  t35.desired_hour AS desired_hour_52,
  t35.desired_states AS desired_states_53,
  t35.availability_to_start AS availability_to_start_54,
  t35.willing_to_travel AS willing_to_travel_55,
  t35.preferred_patient_volume AS preferred_patient_volume_56,
  t35.release_authorization_date AS release_authorization_date_57,
  t35.ssn AS ssn_58,
  t35.dob AS dob_59,
  t35.country_of_birth AS country_of_birth_60,
  t35.state_of_birth AS state_of_birth_61,
  t35.city_of_birth AS city_of_birth_62,
  t35.release_and_authorization_accepted AS release_and_authorization_accepted_63,
  t35.application_certification_date AS application_certification_date_64,
  t35.risk_assessment AS risk_assessment_65,
  t35.health_assessment AS health_assessment_66,
  t35.cashback AS cashback_67,
  t35.notification_preferences AS notification_preferences_68,
  t35.average_point AS average_point_69,
  t35.skip_onboarding AS skip_onboarding_70,
  t35.professional_references AS professional_references_71,
  t35.rewards_points AS rewards_points_72,
  t35.created_at AS created_at_73,
  t35.updated_at AS updated_at_74,
  t35.user_id AS user_id_75,
  t35.profession_id AS profession_id_76,
  t78.id AS id_77,
  t78.company_name AS company_name_79,
  t78.speciality AS speciality_80,
  t78.membership_level AS membership_level_81,
  t78.rating AS rating_82,
  t78.is_verified AS is_verified_83,
  t78.stripe_connect_account_id AS stripe_connect_account_id_84,
  t78.stripe_account_status AS stripe_account_status_85,
  t78.created_at AS created_at_86,
  t78.updated_at AS updated_at_87,
  t78.user_id AS user_id_88,
  t90.id AS id_89,
  t90.balance AS balance_91,
  t90.updated_at AS updated_at_92,
  t90.user_id AS user_id_93,
  t0.membership_tier_id AS membership_tier_id_94,
  t0.recruiter_id AS recruiter_id_95,
  t0.dtype
FROM
  b_user t0
  LEFT JOIN b_provider t35 ON t35.user_id = t0.id
  LEFT JOIN b_recruiter t78 ON t78.user_id = t0.id
  LEFT JOIN b_credit_wallet t90 ON t90.user_id = t0.id
WHERE
  t0.id = ?
  AND t0.dtype IN ('user')

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.stripe_customer_id AS stripe_customer_id_15, t0.stripe_connect_id AS stripe_connect_id_16, t0.stripe_account_status AS stripe_account_status_17, t0.subscription_status AS subscription_status_18, t0.subscription_ends_at AS subscription_ends_at_19, t0.custom_fee_structure AS custom_fee_structure_20, t0.phone1 AS phone1_21, t0.phone2 AS phone2_22, t0.bio AS bio_23, t0.nickname AS nickname_24, t0.blocked AS blocked_25, t0.mfa_code AS mfa_code_26, t0.mfa_expires_at AS mfa_expires_at_27, t0.is_hybrid_recruiter AS is_hybrid_recruiter_28, t0.address AS address_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.employer_id AS employer_id_32, t0.staffing_agency_id AS staffing_agency_id_33, t35.id AS id_34, t35.name AS name_36, t35.suffix AS suffix_37, t35.title AS title_38, t35.npi_number AS npi_number_39, t35.phone_home AS phone_home_40, t35.phone_work AS phone_work_41, t35.phone_mobile AS phone_mobile_42, t35.cv_filename AS cv_filename_43, t35.country AS country_44, t35.state AS state_45, t35.city AS city_46, t35.zip_code AS zip_code_47, t35.street_address AS street_address_48, t35.desired_pay_rate AS desired_pay_rate_49, t35.pay_rate_hourly AS pay_rate_hourly_50, t35.pay_rate_daily AS pay_rate_daily_51, t35.desired_hour AS desired_hour_52, t35.desired_states AS desired_states_53, t35.availability_to_start AS availability_to_start_54, t35.willing_to_travel AS willing_to_travel_55, t35.preferred_patient_volume AS preferred_patient_volume_56, t35.release_authorization_date AS release_authorization_date_57, t35.ssn AS ssn_58, t35.dob AS dob_59, t35.country_of_birth AS country_of_birth_60, t35.state_of_birth AS state_of_birth_61, t35.city_of_birth AS city_of_birth_62, t35.release_and_authorization_accepted AS release_and_authorization_accepted_63, t35.application_certification_date AS application_certification_date_64, t35.risk_assessment AS risk_assessment_65, t35.health_assessment AS health_assessment_66, t35.cashback AS cashback_67, t35.notification_preferences AS notification_preferences_68, t35.average_point AS average_point_69, t35.skip_onboarding AS skip_onboarding_70, t35.professional_references AS professional_references_71, t35.rewards_points AS rewards_points_72, t35.created_at AS created_at_73, t35.updated_at AS updated_at_74, t35.user_id AS user_id_75, t35.profession_id AS profession_id_76, t78.id AS id_77, t78.company_name AS company_name_79, t78.speciality AS speciality_80, t78.membership_level AS membership_level_81, t78.rating AS rating_82, t78.is_verified AS is_verified_83, t78.stripe_connect_account_id AS stripe_connect_account_id_84, t78.stripe_account_status AS stripe_account_status_85, t78.created_at AS created_at_86, t78.updated_at AS updated_at_87, t78.user_id AS user_id_88, t90.id AS id_89, t90.balance AS balance_91, t90.updated_at AS updated_at_92, t90.user_id AS user_id_93, t0.membership_tier_id AS membership_tier_id_94, t0.recruiter_id AS recruiter_id_95, t0.dtype FROM b_user t0 LEFT JOIN b_provider t35 ON t35.user_id = t0.id LEFT JOIN b_recruiter t78 ON t78.user_id = t0.id LEFT JOIN b_credit_wallet t90 ON t90.user_id = t0.id WHERE t0.id = 0x1F113CE91D8F641CBB1F4BFA35181489 AND t0.dtype IN ('user');

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  b_job b0_
WHERE
  b0_.employer_id = ?
  AND b0_.verified = 1

SELECT COUNT(b0_.id) AS sclr_0 FROM b_job b0_ WHERE b0_.employer_id = 0x1F113CE8FFBE6CA8BBBA4BFA35181489 AND b0_.verified = 1;

SELECT
  COUNT(b0_.id) AS sclr_0,
  SUM(
    CASE WHEN b0_.status = 'interview' THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN b0_.status = 'hired' THEN
      1
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(
    CASE WHEN b0_.status = 'applied' THEN
      1
    ELSE
      0
    END
  ) AS sclr_3,
  COUNT(DISTINCT b0_.provider_id) AS sclr_4
FROM
  b_application b0_
WHERE
  b0_.employer_id = ?
  AND b0_.archived_at IS NULL

SELECT COUNT(b0_.id) AS sclr_0, SUM(CASE WHEN b0_.status = 'interview' THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN b0_.status = 'hired' THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN b0_.status = 'applied' THEN 1 ELSE 0 END) AS sclr_3, COUNT(DISTINCT b0_.provider_id) AS sclr_4 FROM b_application b0_ WHERE b0_.employer_id = 0x1F113CE8FFBE6CA8BBBA4BFA35181489 AND b0_.archived_at IS NULL;

SELECT
  b0_.status AS status_0,
  COUNT(b0_.id) AS sclr_1
FROM
  b_application b0_
WHERE
  b0_.employer_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_.employer_id = 0x1F113CE8FFBE6CA8BBBA4BFA35181489 AND b0_.archived_at IS NULL GROUP BY b0_.status;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.seen AS seen_3,
  t0.attachment AS attachment_4,
  t0.subject AS subject_5,
  t0.is_draft AS is_draft_6,
  t0.saved_at AS saved_at_7,
  t0.sent_at AS sent_at_8,
  t0.deleted AS deleted_9,
  t0.deleted_at AS deleted_at_10,
  t0.is_forwarded AS is_forwarded_11,
  t0.original_subject AS original_subject_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.parent_id AS parent_id_15,
  t0.sender_id AS sender_id_16,
  t0.receiver_id AS receiver_id_17,
  t0.employer_id AS employer_id_18,
  t0.recruiter_id AS recruiter_id_19,
  t0.job_uuid AS job_uuid_20,
  t0.staffing_agency_id AS staffing_agency_id_21,
  t0.application_id AS application_id_22
FROM
  b_message t0
WHERE
  t0.receiver_id = ?
ORDER BY
  t0.id DESC
LIMIT
  10

SELECT t0.id AS id_1, t0.text AS text_2, t0.seen AS seen_3, t0.attachment AS attachment_4, t0.subject AS subject_5, t0.is_draft AS is_draft_6, t0.saved_at AS saved_at_7, t0.sent_at AS sent_at_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.is_forwarded AS is_forwarded_11, t0.original_subject AS original_subject_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.parent_id AS parent_id_15, t0.sender_id AS sender_id_16, t0.receiver_id AS receiver_id_17, t0.employer_id AS employer_id_18, t0.recruiter_id AS recruiter_id_19, t0.job_uuid AS job_uuid_20, t0.staffing_agency_id AS staffing_agency_id_21, t0.application_id AS application_id_22 FROM b_message t0 WHERE t0.receiver_id = 0x1F113CE91D8F641CBB1F4BFA35181489 ORDER BY t0.id DESC LIMIT 10;

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.stripe_customer_id AS stripe_customer_id_15,
  t0.stripe_connect_id AS stripe_connect_id_16,
  t0.stripe_account_status AS stripe_account_status_17,
  t0.subscription_status AS subscription_status_18,
  t0.subscription_ends_at AS subscription_ends_at_19,
  t0.custom_fee_structure AS custom_fee_structure_20,
  t0.phone1 AS phone1_21,
  t0.phone2 AS phone2_22,
  t0.bio AS bio_23,
  t0.nickname AS nickname_24,
  t0.blocked AS blocked_25,
  t0.mfa_code AS mfa_code_26,
  t0.mfa_expires_at AS mfa_expires_at_27,
  t0.is_hybrid_recruiter AS is_hybrid_recruiter_28,
  t0.address AS address_29,
  t0.created_at AS created_at_30,
  t0.updated_at AS updated_at_31,
  t0.employer_id AS employer_id_32,
  t0.staffing_agency_id AS staffing_agency_id_33,
  t35.id AS id_34,
  t35.name AS name_36,
  t35.suffix AS suffix_37,
  t35.title AS title_38,
  t35.npi_number AS npi_number_39,
  t35.phone_home AS phone_home_40,
  t35.phone_work AS phone_work_41,
  t35.phone_mobile AS phone_mobile_42,
  t35.cv_filename AS cv_filename_43,
  t35.country AS country_44,
  t35.state AS state_45,
  t35.city AS city_46,
  t35.zip_code AS zip_code_47,
  t35.street_address AS street_address_48,
  t35.desired_pay_rate AS desired_pay_rate_49,
  t35.pay_rate_hourly AS pay_rate_hourly_50,
  t35.pay_rate_daily AS pay_rate_daily_51,
  t35.desired_hour AS desired_hour_52,
  t35.desired_states AS desired_states_53,
  t35.availability_to_start AS availability_to_start_54,
  t35.willing_to_travel AS willing_to_travel_55,
  t35.preferred_patient_volume AS preferred_patient_volume_56,
  t35.release_authorization_date AS release_authorization_date_57,
  t35.ssn AS ssn_58,
  t35.dob AS dob_59,
  t35.country_of_birth AS country_of_birth_60,
  t35.state_of_birth AS state_of_birth_61,
  t35.city_of_birth AS city_of_birth_62,
  t35.release_and_authorization_accepted AS release_and_authorization_accepted_63,
  t35.application_certification_date AS application_certification_date_64,
  t35.risk_assessment AS risk_assessment_65,
  t35.health_assessment AS health_assessment_66,
  t35.cashback AS cashback_67,
  t35.notification_preferences AS notification_preferences_68,
  t35.average_point AS average_point_69,
  t35.skip_onboarding AS skip_onboarding_70,
  t35.professional_references AS professional_references_71,
  t35.rewards_points AS rewards_points_72,
  t35.created_at AS created_at_73,
  t35.updated_at AS updated_at_74,
  t35.user_id AS user_id_75,
  t35.profession_id AS profession_id_76,
  t78.id AS id_77,
  t78.company_name AS company_name_79,
  t78.speciality AS speciality_80,
  t78.membership_level AS membership_level_81,
  t78.rating AS rating_82,
  t78.is_verified AS is_verified_83,
  t78.stripe_connect_account_id AS stripe_connect_account_id_84,
  t78.stripe_account_status AS stripe_account_status_85,
  t78.created_at AS created_at_86,
  t78.updated_at AS updated_at_87,
  t78.user_id AS user_id_88,
  t90.id AS id_89,
  t90.balance AS balance_91,
  t90.updated_at AS updated_at_92,
  t90.user_id AS user_id_93,
  t0.membership_tier_id AS membership_tier_id_94,
  t0.recruiter_id AS recruiter_id_95,
  t0.dtype
FROM
  b_user t0
  LEFT JOIN b_provider t35 ON t35.user_id = t0.id
  LEFT JOIN b_recruiter t78 ON t78.user_id = t0.id
  LEFT JOIN b_credit_wallet t90 ON t90.user_id = t0.id
WHERE
  t0.id = ?
  AND t0.dtype IN ('user')

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.stripe_customer_id AS stripe_customer_id_15, t0.stripe_connect_id AS stripe_connect_id_16, t0.stripe_account_status AS stripe_account_status_17, t0.subscription_status AS subscription_status_18, t0.subscription_ends_at AS subscription_ends_at_19, t0.custom_fee_structure AS custom_fee_structure_20, t0.phone1 AS phone1_21, t0.phone2 AS phone2_22, t0.bio AS bio_23, t0.nickname AS nickname_24, t0.blocked AS blocked_25, t0.mfa_code AS mfa_code_26, t0.mfa_expires_at AS mfa_expires_at_27, t0.is_hybrid_recruiter AS is_hybrid_recruiter_28, t0.address AS address_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.employer_id AS employer_id_32, t0.staffing_agency_id AS staffing_agency_id_33, t35.id AS id_34, t35.name AS name_36, t35.suffix AS suffix_37, t35.title AS title_38, t35.npi_number AS npi_number_39, t35.phone_home AS phone_home_40, t35.phone_work AS phone_work_41, t35.phone_mobile AS phone_mobile_42, t35.cv_filename AS cv_filename_43, t35.country AS country_44, t35.state AS state_45, t35.city AS city_46, t35.zip_code AS zip_code_47, t35.street_address AS street_address_48, t35.desired_pay_rate AS desired_pay_rate_49, t35.pay_rate_hourly AS pay_rate_hourly_50, t35.pay_rate_daily AS pay_rate_daily_51, t35.desired_hour AS desired_hour_52, t35.desired_states AS desired_states_53, t35.availability_to_start AS availability_to_start_54, t35.willing_to_travel AS willing_to_travel_55, t35.preferred_patient_volume AS preferred_patient_volume_56, t35.release_authorization_date AS release_authorization_date_57, t35.ssn AS ssn_58, t35.dob AS dob_59, t35.country_of_birth AS country_of_birth_60, t35.state_of_birth AS state_of_birth_61, t35.city_of_birth AS city_of_birth_62, t35.release_and_authorization_accepted AS release_and_authorization_accepted_63, t35.application_certification_date AS application_certification_date_64, t35.risk_assessment AS risk_assessment_65, t35.health_assessment AS health_assessment_66, t35.cashback AS cashback_67, t35.notification_preferences AS notification_preferences_68, t35.average_point AS average_point_69, t35.skip_onboarding AS skip_onboarding_70, t35.professional_references AS professional_references_71, t35.rewards_points AS rewards_points_72, t35.created_at AS created_at_73, t35.updated_at AS updated_at_74, t35.user_id AS user_id_75, t35.profession_id AS profession_id_76, t78.id AS id_77, t78.company_name AS company_name_79, t78.speciality AS speciality_80, t78.membership_level AS membership_level_81, t78.rating AS rating_82, t78.is_verified AS is_verified_83, t78.stripe_connect_account_id AS stripe_connect_account_id_84, t78.stripe_account_status AS stripe_account_status_85, t78.created_at AS created_at_86, t78.updated_at AS updated_at_87, t78.user_id AS user_id_88, t90.id AS id_89, t90.balance AS balance_91, t90.updated_at AS updated_at_92, t90.user_id AS user_id_93, t0.membership_tier_id AS membership_tier_id_94, t0.recruiter_id AS recruiter_id_95, t0.dtype FROM b_user t0 LEFT JOIN b_provider t35 ON t35.user_id = t0.id LEFT JOIN b_recruiter t78 ON t78.user_id = t0.id LEFT JOIN b_credit_wallet t90 ON t90.user_id = t0.id WHERE t0.id = 0x1F1214C0918363BE849E2FF2D72F559A AND t0.dtype IN ('user');

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 = ?
ORDER BY
  t0.id 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 = 0x1F113CE91D8F641CBB1F4BFA35181489 ORDER BY t0.id DESC LIMIT 5;

SELECT
  b0_.status_mode AS status_mode_0,
  b0_.id AS id_1,
  b0_.title AS title_2,
  b0_.description AS description_3,
  b0_.status AS status_4,
  b0_.country AS country_5,
  b0_.state AS state_6,
  b0_.city AS city_7,
  b0_.street_address AS street_address_8,
  b0_.expiration_date AS expiration_date_9,
  b0_.highlight AS highlight_10,
  b0_.schedule AS schedule_11,
  b0_.start_date AS start_date_12,
  b0_.year_of_experience AS year_of_experience_13,
  b0_.pay_rate AS pay_rate_14,
  b0_.work_type AS work_type_15,
  b0_.need AS need_16,
  b0_.pay_rate_hourly AS pay_rate_hourly_17,
  b0_.pay_rate_daily AS pay_rate_daily_18,
  b0_.annual_salary AS annual_salary_19,
  b0_.monthly_salary AS monthly_salary_20,
  b0_.salary_type AS salary_type_21,
  b0_.blocked AS blocked_22,
  b0_.job_id AS job_id_23,
  b0_.verified AS verified_24,
  b0_.is_mediated AS is_mediated_25,
  b0_.`rank` AS rank_26,
  b0_.archived_at AS archived_at_27,
  b0_.is_archived AS is_archived_28,
  b0_.agency_payout_status AS agency_payout_status_29,
  b0_.agency_payout_amount AS agency_payout_amount_30,
  b0_.agency_payout_date AS agency_payout_date_31,
  b0_.agency_payout_reference AS agency_payout_reference_32,
  b0_.created_at AS created_at_33,
  b0_.updated_at AS updated_at_34,
  b0_.user_id AS user_id_35,
  b0_.employer_id AS employer_id_36,
  b0_.staffing_agency_id AS staffing_agency_id_37,
  b0_.profession_id AS profession_id_38,
  b0_.speciality_id AS speciality_id_39,
  b0_.assigned_recruiter_id AS assigned_recruiter_id_40
FROM
  b_job b0_
WHERE
  b0_.employer_id = ?
  AND b0_.archived_at IS NULL
  AND b0_.verified = 1
  AND b0_.expiration_date <= ?
ORDER BY
  b0_.id DESC

SELECT b0_.status_mode AS status_mode_0, b0_.id AS id_1, b0_.title AS title_2, b0_.description AS description_3, b0_.status AS status_4, b0_.country AS country_5, b0_.state AS state_6, b0_.city AS city_7, b0_.street_address AS street_address_8, b0_.expiration_date AS expiration_date_9, b0_.highlight AS highlight_10, b0_.schedule AS schedule_11, b0_.start_date AS start_date_12, b0_.year_of_experience AS year_of_experience_13, b0_.pay_rate AS pay_rate_14, b0_.work_type AS work_type_15, b0_.need AS need_16, b0_.pay_rate_hourly AS pay_rate_hourly_17, b0_.pay_rate_daily AS pay_rate_daily_18, b0_.annual_salary AS annual_salary_19, b0_.monthly_salary AS monthly_salary_20, b0_.salary_type AS salary_type_21, b0_.blocked AS blocked_22, b0_.job_id AS job_id_23, b0_.verified AS verified_24, b0_.is_mediated AS is_mediated_25, b0_.`rank` AS rank_26, b0_.archived_at AS archived_at_27, b0_.is_archived AS is_archived_28, b0_.agency_payout_status AS agency_payout_status_29, b0_.agency_payout_amount AS agency_payout_amount_30, b0_.agency_payout_date AS agency_payout_date_31, b0_.agency_payout_reference AS agency_payout_reference_32, b0_.created_at AS created_at_33, b0_.updated_at AS updated_at_34, b0_.user_id AS user_id_35, b0_.employer_id AS employer_id_36, b0_.staffing_agency_id AS staffing_agency_id_37, b0_.profession_id AS profession_id_38, b0_.speciality_id AS speciality_id_39, b0_.assigned_recruiter_id AS assigned_recruiter_id_40 FROM b_job b0_ WHERE b0_.employer_id = 0x1F113CE8FFBE6CA8BBBA4BFA35181489 AND b0_.archived_at IS NULL AND b0_.verified = 1 AND b0_.expiration_date <= '2026-04-18 15:38:51' ORDER BY b0_.id DESC;

SELECT
  b0_.status_mode AS status_mode_0,
  b0_.id AS id_1,
  b0_.title AS title_2,
  b0_.description AS description_3,
  b0_.status AS status_4,
  b0_.country AS country_5,
  b0_.state AS state_6,
  b0_.city AS city_7,
  b0_.street_address AS street_address_8,
  b0_.expiration_date AS expiration_date_9,
  b0_.highlight AS highlight_10,
  b0_.schedule AS schedule_11,
  b0_.start_date AS start_date_12,
  b0_.year_of_experience AS year_of_experience_13,
  b0_.pay_rate AS pay_rate_14,
  b0_.work_type AS work_type_15,
  b0_.need AS need_16,
  b0_.pay_rate_hourly AS pay_rate_hourly_17,
  b0_.pay_rate_daily AS pay_rate_daily_18,
  b0_.annual_salary AS annual_salary_19,
  b0_.monthly_salary AS monthly_salary_20,
  b0_.salary_type AS salary_type_21,
  b0_.blocked AS blocked_22,
  b0_.job_id AS job_id_23,
  b0_.verified AS verified_24,
  b0_.is_mediated AS is_mediated_25,
  b0_.`rank` AS rank_26,
  b0_.archived_at AS archived_at_27,
  b0_.is_archived AS is_archived_28,
  b0_.agency_payout_status AS agency_payout_status_29,
  b0_.agency_payout_amount AS agency_payout_amount_30,
  b0_.agency_payout_date AS agency_payout_date_31,
  b0_.agency_payout_reference AS agency_payout_reference_32,
  b0_.created_at AS created_at_33,
  b0_.updated_at AS updated_at_34,
  b0_.user_id AS user_id_35,
  b0_.employer_id AS employer_id_36,
  b0_.staffing_agency_id AS staffing_agency_id_37,
  b0_.profession_id AS profession_id_38,
  b0_.speciality_id AS speciality_id_39,
  b0_.assigned_recruiter_id AS assigned_recruiter_id_40
FROM
  b_job b0_
WHERE
  b0_.employer_id = ?
  AND b0_.status IN (?)
  AND b0_.archived_at IS NULL
  AND b0_.verified = 1
  AND b0_.expiration_date >= ?
ORDER BY
  b0_.id DESC

SELECT b0_.status_mode AS status_mode_0, b0_.id AS id_1, b0_.title AS title_2, b0_.description AS description_3, b0_.status AS status_4, b0_.country AS country_5, b0_.state AS state_6, b0_.city AS city_7, b0_.street_address AS street_address_8, b0_.expiration_date AS expiration_date_9, b0_.highlight AS highlight_10, b0_.schedule AS schedule_11, b0_.start_date AS start_date_12, b0_.year_of_experience AS year_of_experience_13, b0_.pay_rate AS pay_rate_14, b0_.work_type AS work_type_15, b0_.need AS need_16, b0_.pay_rate_hourly AS pay_rate_hourly_17, b0_.pay_rate_daily AS pay_rate_daily_18, b0_.annual_salary AS annual_salary_19, b0_.monthly_salary AS monthly_salary_20, b0_.salary_type AS salary_type_21, b0_.blocked AS blocked_22, b0_.job_id AS job_id_23, b0_.verified AS verified_24, b0_.is_mediated AS is_mediated_25, b0_.`rank` AS rank_26, b0_.archived_at AS archived_at_27, b0_.is_archived AS is_archived_28, b0_.agency_payout_status AS agency_payout_status_29, b0_.agency_payout_amount AS agency_payout_amount_30, b0_.agency_payout_date AS agency_payout_date_31, b0_.agency_payout_reference AS agency_payout_reference_32, b0_.created_at AS created_at_33, b0_.updated_at AS updated_at_34, b0_.user_id AS user_id_35, b0_.employer_id AS employer_id_36, b0_.staffing_agency_id AS staffing_agency_id_37, b0_.profession_id AS profession_id_38, b0_.speciality_id AS speciality_id_39, b0_.assigned_recruiter_id AS assigned_recruiter_id_40 FROM b_job b0_ WHERE b0_.employer_id = 0x1F113CE8FFBE6CA8BBBA4BFA35181489 AND b0_.status IN ('published') AND b0_.archived_at IS NULL AND b0_.verified = 1 AND b0_.expiration_date >= '2026-04-18 15:38:51' ORDER BY b0_.id DESC;