Symfony Profiler

SELECT
  r0_.japanese_name AS japanese_name_0,
  r0_.deleted_at AS deleted_at_1,
  r0_.created_at AS created_at_2,
  r0_.updated_at AS updated_at_3,
  r0_.id AS id_4,
  r0_.name AS name_5,
  r0_.enable AS enable_6,
  r0_.sort AS sort_7,
  COUNT(r1_.category_id) AS sclr_8
FROM
  recruit_category r0_
  LEFT JOIN recruit_entry r1_ ON (r0_.id = r1_.category_id)
  AND (r1_.deleted_at IS NULL)
WHERE
  (
    r0_.enable = 1
    AND r1_.enable = 1
    AND (
      r1_.publish_date IS NULL
      OR r1_.publish_date <= ?
    )
    AND (
      r1_.close_date IS NULL
      OR r1_.close_date >= ?
    )
  )
  AND (r0_.deleted_at IS NULL)
GROUP BY
  r1_.category_id
ORDER BY
  r1_.entry_date DESC,
  r1_.id DESC

SELECT r0_.japanese_name AS japanese_name_0, r0_.deleted_at AS deleted_at_1, r0_.created_at AS created_at_2, r0_.updated_at AS updated_at_3, r0_.id AS id_4, r0_.name AS name_5, r0_.enable AS enable_6, r0_.sort AS sort_7, COUNT(r1_.category_id) AS sclr_8 FROM recruit_category r0_ LEFT JOIN recruit_entry r1_ ON (r0_.id = r1_.category_id) AND (r1_.deleted_at IS NULL) WHERE (r0_.enable = 1 AND r1_.enable = 1 AND (r1_.publish_date IS NULL OR r1_.publish_date <= '2026-02-07 00:18:45') AND (r1_.close_date IS NULL OR r1_.close_date >= '2026-02-07 00:18:45')) AND (r0_.deleted_at IS NULL) GROUP BY r1_.category_id ORDER BY r1_.entry_date DESC, r1_.id DESC;

SELECT
  DISTINCT id_25
FROM
  (
    SELECT
      DISTINCT id_25,
      entry_date_26
    FROM
      (
        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,
          r1_.japanese_name AS japanese_name_39,
          r1_.deleted_at AS deleted_at_40,
          r1_.created_at AS created_at_41,
          r1_.updated_at AS updated_at_42,
          r1_.id AS id_43,
          r1_.name AS name_44,
          r1_.enable AS enable_45,
          r1_.sort AS sort_46
        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)
      ) dctrn_result_inner
    ORDER BY
      entry_date_26 DESC,
      id_25 DESC
  ) dctrn_result
LIMIT
  16

SELECT DISTINCT id_25 FROM (SELECT DISTINCT id_25, entry_date_26 FROM (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, r1_.japanese_name AS japanese_name_39, r1_.deleted_at AS deleted_at_40, r1_.created_at AS created_at_41, r1_.updated_at AS updated_at_42, r1_.id AS id_43, r1_.name AS name_44, r1_.enable AS enable_45, r1_.sort AS sort_46 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 00:18:45') AND (r0_.close_date IS NULL OR r0_.close_date >= '2026-02-07 00:18:45') AND r1_.enable = 1) AND (r0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY entry_date_26 DESC, id_25 DESC) dctrn_result LIMIT 16;

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 IN (?, ?, ?, ?, ?)
  )
  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 00:18:45') AND (r0_.close_date IS NULL OR r0_.close_date >= '2026-02-07 00:18:45') AND r1_.enable = 1 AND r0_.id IN (11, 10, 9, 1, 12)) AND (r0_.deleted_at IS NULL) ORDER BY r0_.entry_date DESC, r0_.id DESC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_25
    FROM
      (
        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
        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
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_25 FROM (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 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 00:18:45') AND (r0_.close_date IS NULL OR r0_.close_date >= '2026-02-07 00:18:45') AND r1_.enable = 1) AND (r0_.deleted_at IS NULL) ORDER BY r0_.entry_date DESC, r0_.id DESC) dctrn_result) dctrn_table;