Symfony Profiler

SELECT
  r0_.person_skill AS person_skill_0,
  r0_.person_welcome_skill AS person_welcome_skill_1,
  r0_.person_status AS person_status_2,
  r0_.person_training AS person_training_3,
  r0_.outline_base_pay_lower AS outline_base_pay_lower_4,
  r0_.outline_base_pay_upper AS outline_base_pay_upper_5,
  r0_.outline_salary_supplement_lower AS outline_salary_supplement_lower_6,
  r0_.outline_salary_supplement_upper AS outline_salary_supplement_upper_7,
  r0_.outline_monthly_salary_lower AS outline_monthly_salary_lower_8,
  r0_.outline_monthly_salary_upper AS outline_monthly_salary_upper_9,
  r0_.outline_annual_income_lower AS outline_annual_income_lower_10,
  r0_.outline_annual_income_upper AS outline_annual_income_upper_11,
  r0_.outline_remarks AS outline_remarks_12,
  r0_.outline_location AS outline_location_13,
  r0_.outline_location_remarks AS outline_location_remarks_14,
  r0_.outline_employment_status AS outline_employment_status_15,
  r0_.outline_employment_period AS outline_employment_period_16,
  r0_.outline_holiday AS outline_holiday_17,
  r0_.outline_trial_period AS outline_trial_period_18,
  r0_.outline_welfare_programme AS outline_welfare_programme_19,
  r0_.work_scene AS work_scene_20,
  r0_.form_type AS form_type_21,
  r0_.deleted_at AS deleted_at_22,
  r0_.created_at AS created_at_23,
  r0_.updated_at AS updated_at_24,
  r0_.id AS id_25,
  r0_.entry_date AS entry_date_26,
  r0_.title AS title_27,
  r0_.enable AS enable_28,
  r0_.content AS content_29,
  r0_.description AS description_30,
  r0_.main_image AS main_image_31,
  r0_.main_image_width AS main_image_width_32,
  r0_.main_image_height AS main_image_height_33,
  r0_.thumbnail AS thumbnail_34,
  r0_.link_url AS link_url_35,
  r0_.link_new_tab AS link_new_tab_36,
  r0_.publish_date AS publish_date_37,
  r0_.close_date AS close_date_38,
  r0_.category_id AS category_id_39,
  r0_.account_id AS account_id_40
FROM
  recruit_entry r0_
  LEFT JOIN recruit_category r1_ ON (r0_.category_id = r1_.id)
  AND (r1_.deleted_at IS NULL)
WHERE
  (
    r0_.enable = 1
    AND (
      r0_.publish_date IS NULL
      OR r0_.publish_date <= ?
    )
    AND (
      r0_.close_date IS NULL
      OR r0_.close_date >= ?
    )
    AND r1_.enable = 1
    AND r0_.id = ?
  )
  AND (r0_.deleted_at IS NULL)
ORDER BY
  r0_.entry_date DESC,
  r0_.id DESC

SELECT r0_.person_skill AS person_skill_0, r0_.person_welcome_skill AS person_welcome_skill_1, r0_.person_status AS person_status_2, r0_.person_training AS person_training_3, r0_.outline_base_pay_lower AS outline_base_pay_lower_4, r0_.outline_base_pay_upper AS outline_base_pay_upper_5, r0_.outline_salary_supplement_lower AS outline_salary_supplement_lower_6, r0_.outline_salary_supplement_upper AS outline_salary_supplement_upper_7, r0_.outline_monthly_salary_lower AS outline_monthly_salary_lower_8, r0_.outline_monthly_salary_upper AS outline_monthly_salary_upper_9, r0_.outline_annual_income_lower AS outline_annual_income_lower_10, r0_.outline_annual_income_upper AS outline_annual_income_upper_11, r0_.outline_remarks AS outline_remarks_12, r0_.outline_location AS outline_location_13, r0_.outline_location_remarks AS outline_location_remarks_14, r0_.outline_employment_status AS outline_employment_status_15, r0_.outline_employment_period AS outline_employment_period_16, r0_.outline_holiday AS outline_holiday_17, r0_.outline_trial_period AS outline_trial_period_18, r0_.outline_welfare_programme AS outline_welfare_programme_19, r0_.work_scene AS work_scene_20, r0_.form_type AS form_type_21, r0_.deleted_at AS deleted_at_22, r0_.created_at AS created_at_23, r0_.updated_at AS updated_at_24, r0_.id AS id_25, r0_.entry_date AS entry_date_26, r0_.title AS title_27, r0_.enable AS enable_28, r0_.content AS content_29, r0_.description AS description_30, r0_.main_image AS main_image_31, r0_.main_image_width AS main_image_width_32, r0_.main_image_height AS main_image_height_33, r0_.thumbnail AS thumbnail_34, r0_.link_url AS link_url_35, r0_.link_new_tab AS link_new_tab_36, r0_.publish_date AS publish_date_37, r0_.close_date AS close_date_38, r0_.category_id AS category_id_39, r0_.account_id AS account_id_40 FROM recruit_entry r0_ LEFT JOIN recruit_category r1_ ON (r0_.category_id = r1_.id) AND (r1_.deleted_at IS NULL) WHERE (r0_.enable = 1 AND (r0_.publish_date IS NULL OR r0_.publish_date <= '2026-02-07 03:50:53') AND (r0_.close_date IS NULL OR r0_.close_date >= '2026-02-07 03:50:53') AND r1_.enable = 1 AND r0_.id = 10) AND (r0_.deleted_at IS NULL) ORDER BY r0_.entry_date DESC, r0_.id DESC;

SELECT
  r0_.person_skill AS person_skill_0,
  r0_.person_welcome_skill AS person_welcome_skill_1,
  r0_.person_status AS person_status_2,
  r0_.person_training AS person_training_3,
  r0_.outline_base_pay_lower AS outline_base_pay_lower_4,
  r0_.outline_base_pay_upper AS outline_base_pay_upper_5,
  r0_.outline_salary_supplement_lower AS outline_salary_supplement_lower_6,
  r0_.outline_salary_supplement_upper AS outline_salary_supplement_upper_7,
  r0_.outline_monthly_salary_lower AS outline_monthly_salary_lower_8,
  r0_.outline_monthly_salary_upper AS outline_monthly_salary_upper_9,
  r0_.outline_annual_income_lower AS outline_annual_income_lower_10,
  r0_.outline_annual_income_upper AS outline_annual_income_upper_11,
  r0_.outline_remarks AS outline_remarks_12,
  r0_.outline_location AS outline_location_13,
  r0_.outline_location_remarks AS outline_location_remarks_14,
  r0_.outline_employment_status AS outline_employment_status_15,
  r0_.outline_employment_period AS outline_employment_period_16,
  r0_.outline_holiday AS outline_holiday_17,
  r0_.outline_trial_period AS outline_trial_period_18,
  r0_.outline_welfare_programme AS outline_welfare_programme_19,
  r0_.work_scene AS work_scene_20,
  r0_.form_type AS form_type_21,
  r0_.deleted_at AS deleted_at_22,
  r0_.created_at AS created_at_23,
  r0_.updated_at AS updated_at_24,
  r0_.id AS id_25,
  r0_.entry_date AS entry_date_26,
  r0_.title AS title_27,
  r0_.enable AS enable_28,
  r0_.content AS content_29,
  r0_.description AS description_30,
  r0_.main_image AS main_image_31,
  r0_.main_image_width AS main_image_width_32,
  r0_.main_image_height AS main_image_height_33,
  r0_.thumbnail AS thumbnail_34,
  r0_.link_url AS link_url_35,
  r0_.link_new_tab AS link_new_tab_36,
  r0_.publish_date AS publish_date_37,
  r0_.close_date AS close_date_38,
  r0_.category_id AS category_id_39,
  r0_.account_id AS account_id_40
FROM
  recruit_entry r0_
  LEFT JOIN recruit_category r1_ ON (r0_.category_id = r1_.id)
  AND (r1_.deleted_at IS NULL)
WHERE
  (
    r0_.enable = 1
    AND (
      r0_.publish_date IS NULL
      OR r0_.publish_date <= ?
    )
    AND (
      r0_.close_date IS NULL
      OR r0_.close_date >= ?
    )
    AND r1_.enable = 1
  )
  AND (r0_.deleted_at IS NULL)
ORDER BY
  r0_.entry_date DESC,
  r0_.id DESC

SELECT r0_.person_skill AS person_skill_0, r0_.person_welcome_skill AS person_welcome_skill_1, r0_.person_status AS person_status_2, r0_.person_training AS person_training_3, r0_.outline_base_pay_lower AS outline_base_pay_lower_4, r0_.outline_base_pay_upper AS outline_base_pay_upper_5, r0_.outline_salary_supplement_lower AS outline_salary_supplement_lower_6, r0_.outline_salary_supplement_upper AS outline_salary_supplement_upper_7, r0_.outline_monthly_salary_lower AS outline_monthly_salary_lower_8, r0_.outline_monthly_salary_upper AS outline_monthly_salary_upper_9, r0_.outline_annual_income_lower AS outline_annual_income_lower_10, r0_.outline_annual_income_upper AS outline_annual_income_upper_11, r0_.outline_remarks AS outline_remarks_12, r0_.outline_location AS outline_location_13, r0_.outline_location_remarks AS outline_location_remarks_14, r0_.outline_employment_status AS outline_employment_status_15, r0_.outline_employment_period AS outline_employment_period_16, r0_.outline_holiday AS outline_holiday_17, r0_.outline_trial_period AS outline_trial_period_18, r0_.outline_welfare_programme AS outline_welfare_programme_19, r0_.work_scene AS work_scene_20, r0_.form_type AS form_type_21, r0_.deleted_at AS deleted_at_22, r0_.created_at AS created_at_23, r0_.updated_at AS updated_at_24, r0_.id AS id_25, r0_.entry_date AS entry_date_26, r0_.title AS title_27, r0_.enable AS enable_28, r0_.content AS content_29, r0_.description AS description_30, r0_.main_image AS main_image_31, r0_.main_image_width AS main_image_width_32, r0_.main_image_height AS main_image_height_33, r0_.thumbnail AS thumbnail_34, r0_.link_url AS link_url_35, r0_.link_new_tab AS link_new_tab_36, r0_.publish_date AS publish_date_37, r0_.close_date AS close_date_38, r0_.category_id AS category_id_39, r0_.account_id AS account_id_40 FROM recruit_entry r0_ LEFT JOIN recruit_category r1_ ON (r0_.category_id = r1_.id) AND (r1_.deleted_at IS NULL) WHERE (r0_.enable = 1 AND (r0_.publish_date IS NULL OR r0_.publish_date <= '2026-02-07 03:50:53') AND (r0_.close_date IS NULL OR r0_.close_date >= '2026-02-07 03:50:53') AND r1_.enable = 1) AND (r0_.deleted_at IS NULL) ORDER BY r0_.entry_date DESC, r0_.id DESC;