Symfony Profiler

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  g0_.id AS id_0,
  g0_.title AS title_1,
  g0_.location AS location_2,
  g0_.script AS script_3,
  g0_.type AS type_4
FROM
  google_tag_manager g0_
WHERE
  g0_.type = ?

SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.location AS location_2, g0_.script AS script_3, g0_.type AS type_4 FROM google_tag_manager g0_ WHERE g0_.type = 'script';

SELECT
  f0_.name AS name_0,
  f0_.active AS active_1
FROM
  feature f0_

SELECT f0_.name AS name_0, f0_.active AS active_1 FROM feature f0_;

SELECT
  c0_.id AS id_0,
  c0_.category AS category_1,
  c0_.slug AS slug_2,
  c0_.icon_class AS icon_class_3,
  b1_.meta_title AS meta_title_4,
  b1_.meta_description AS meta_description_5,
  b1_.deleted AS deleted_6,
  b1_.title AS title_7,
  b1_.status AS status_8,
  b1_.slug AS slug_9,
  b1_.intro AS intro_10,
  b1_.body AS body_11,
  b1_.author AS author_12,
  b1_.top_post AS top_post_13,
  b1_.youtube AS youtube_14,
  b1_.id AS id_15,
  b1_.created_at AS created_at_16,
  b1_.updated_at AS updated_at_17,
  b1_.robots AS robots_18,
  b1_.canonical_url AS canonical_url_19,
  b1_.banner_image_asset_id AS banner_image_asset_id_20,
  b1_.owner_id AS owner_id_21,
  b1_.employee_id AS employee_id_22
FROM
  category c0_
  LEFT JOIN blog_category b2_ ON c0_.id = b2_.category_id
  LEFT JOIN blog b1_ ON b1_.id = b2_.blog_id
  AND (b1_.deleted IS NULL)
ORDER BY
  b1_.created_at DESC

SELECT c0_.id AS id_0, c0_.category AS category_1, c0_.slug AS slug_2, c0_.icon_class AS icon_class_3, b1_.meta_title AS meta_title_4, b1_.meta_description AS meta_description_5, b1_.deleted AS deleted_6, b1_.title AS title_7, b1_.status AS status_8, b1_.slug AS slug_9, b1_.intro AS intro_10, b1_.body AS body_11, b1_.author AS author_12, b1_.top_post AS top_post_13, b1_.youtube AS youtube_14, b1_.id AS id_15, b1_.created_at AS created_at_16, b1_.updated_at AS updated_at_17, b1_.robots AS robots_18, b1_.canonical_url AS canonical_url_19, b1_.banner_image_asset_id AS banner_image_asset_id_20, b1_.owner_id AS owner_id_21, b1_.employee_id AS employee_id_22 FROM category c0_ LEFT JOIN blog_category b2_ ON c0_.id = b2_.category_id LEFT JOIN blog b1_ ON b1_.id = b2_.blog_id AND (b1_.deleted IS NULL) ORDER BY b1_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.`name` AS name_2,
  t0.defaults AS defaults_3,
  t0.staticPrefix AS staticPrefix_4,
  t0.variable_pattern AS variable_pattern_5,
  t0.requirements AS requirements_6,
  t0.options AS options_7,
  t0.host AS host_8,
  t0.schemes AS schemes_9,
  t0.`methods` AS methods_10,
  t0.`condition` AS condition_11,
  t0.locale AS locale_12,
  t0.page_id AS page_id_13
FROM
  route t0
WHERE
  t0.`name` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`name` AS name_2, t0.defaults AS defaults_3, t0.staticPrefix AS staticPrefix_4, t0.variable_pattern AS variable_pattern_5, t0.requirements AS requirements_6, t0.options AS options_7, t0.host AS host_8, t0.schemes AS schemes_9, t0.`methods` AS methods_10, t0.`condition` AS condition_11, t0.locale AS locale_12, t0.page_id AS page_id_13 FROM route t0 WHERE t0.`name` = 'blogs' LIMIT 1;

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.fixed_header_title AS fixed_header_title_4,
  t0.body AS body_5,
  t0.lft AS lft_6,
  t0.lvl AS lvl_7,
  t0.rgt AS rgt_8,
  t0.symlink_variable_pattern AS symlink_variable_pattern_9,
  t0.show_in_menu AS show_in_menu_10,
  t0.alias AS alias_11,
  t0.deletable AS deletable_12,
  t0.class AS class_13,
  t0.body_class AS body_class_14,
  t0.breadcrumbs AS breadcrumbs_15,
  t0.controller AS controller_16,
  t0.feature AS feature_17,
  t0.icon_class AS icon_class_18,
  t0.hide_title AS hide_title_19,
  t0.concept AS concept_20,
  t0.target AS target_21,
  t0.mega_menu AS mega_menu_22,
  t0.mega_menu_title AS mega_menu_title_23,
  t0.mega_menu_intro AS mega_menu_intro_24,
  t0.mega_menu_outro AS mega_menu_outro_25,
  t0.id AS id_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.robots AS robots_29,
  t0.meta_title AS meta_title_30,
  t0.meta_description AS meta_description_31,
  t0.parent_id AS parent_id_32,
  t33.id AS id_34,
  t33.`name` AS name_35,
  t33.defaults AS defaults_36,
  t33.staticPrefix AS staticPrefix_37,
  t33.variable_pattern AS variable_pattern_38,
  t33.requirements AS requirements_39,
  t33.options AS options_40,
  t33.host AS host_41,
  t33.schemes AS schemes_42,
  t33.`methods` AS methods_43,
  t33.`condition` AS condition_44,
  t33.locale AS locale_45,
  t33.page_id AS page_id_46,
  t0.symlink_id AS symlink_id_47,
  t0.mega_menu_item_id AS mega_menu_item_id_48,
  t0.hero_configuration_id AS hero_configuration_id_49,
  t0.connexys_page_configuration_id AS connexys_page_configuration_id_50,
  t0.og_image_id AS og_image_id_51,
  t52.id AS id_53,
  t52.field AS field_54,
  t52.text_size AS text_size_55,
  t52.text_color AS text_color_56,
  t52.text_position AS text_position_57,
  t52.image_id AS image_id_58
FROM
  page t0
  LEFT JOIN route t33 ON t33.page_id = t0.id
  LEFT JOIN og_image t52 ON t0.og_image_id = t52.id
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.type AS type_2, t0.title AS title_3, t0.fixed_header_title AS fixed_header_title_4, t0.body AS body_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.symlink_variable_pattern AS symlink_variable_pattern_9, t0.show_in_menu AS show_in_menu_10, t0.alias AS alias_11, t0.deletable AS deletable_12, t0.class AS class_13, t0.body_class AS body_class_14, t0.breadcrumbs AS breadcrumbs_15, t0.controller AS controller_16, t0.feature AS feature_17, t0.icon_class AS icon_class_18, t0.hide_title AS hide_title_19, t0.concept AS concept_20, t0.target AS target_21, t0.mega_menu AS mega_menu_22, t0.mega_menu_title AS mega_menu_title_23, t0.mega_menu_intro AS mega_menu_intro_24, t0.mega_menu_outro AS mega_menu_outro_25, t0.id AS id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.robots AS robots_29, t0.meta_title AS meta_title_30, t0.meta_description AS meta_description_31, t0.parent_id AS parent_id_32, t33.id AS id_34, t33.`name` AS name_35, t33.defaults AS defaults_36, t33.staticPrefix AS staticPrefix_37, t33.variable_pattern AS variable_pattern_38, t33.requirements AS requirements_39, t33.options AS options_40, t33.host AS host_41, t33.schemes AS schemes_42, t33.`methods` AS methods_43, t33.`condition` AS condition_44, t33.locale AS locale_45, t33.page_id AS page_id_46, t0.symlink_id AS symlink_id_47, t0.mega_menu_item_id AS mega_menu_item_id_48, t0.hero_configuration_id AS hero_configuration_id_49, t0.connexys_page_configuration_id AS connexys_page_configuration_id_50, t0.og_image_id AS og_image_id_51, t52.id AS id_53, t52.field AS field_54, t52.text_size AS text_size_55, t52.text_color AS text_color_56, t52.text_position AS text_position_57, t52.image_id AS image_id_58 FROM page t0 LEFT JOIN route t33 ON t33.page_id = t0.id LEFT JOIN og_image t52 ON t0.og_image_id = t52.id WHERE t0.id = 9 AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.fixed_header_title AS fixed_header_title_4,
  t0.body AS body_5,
  t0.lft AS lft_6,
  t0.lvl AS lvl_7,
  t0.rgt AS rgt_8,
  t0.symlink_variable_pattern AS symlink_variable_pattern_9,
  t0.show_in_menu AS show_in_menu_10,
  t0.alias AS alias_11,
  t0.deletable AS deletable_12,
  t0.class AS class_13,
  t0.body_class AS body_class_14,
  t0.breadcrumbs AS breadcrumbs_15,
  t0.controller AS controller_16,
  t0.feature AS feature_17,
  t0.icon_class AS icon_class_18,
  t0.hide_title AS hide_title_19,
  t0.concept AS concept_20,
  t0.target AS target_21,
  t0.mega_menu AS mega_menu_22,
  t0.mega_menu_title AS mega_menu_title_23,
  t0.mega_menu_intro AS mega_menu_intro_24,
  t0.mega_menu_outro AS mega_menu_outro_25,
  t0.id AS id_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.robots AS robots_29,
  t0.meta_title AS meta_title_30,
  t0.meta_description AS meta_description_31,
  t0.parent_id AS parent_id_32,
  t33.id AS id_34,
  t33.`name` AS name_35,
  t33.defaults AS defaults_36,
  t33.staticPrefix AS staticPrefix_37,
  t33.variable_pattern AS variable_pattern_38,
  t33.requirements AS requirements_39,
  t33.options AS options_40,
  t33.host AS host_41,
  t33.schemes AS schemes_42,
  t33.`methods` AS methods_43,
  t33.`condition` AS condition_44,
  t33.locale AS locale_45,
  t33.page_id AS page_id_46,
  t0.symlink_id AS symlink_id_47,
  t0.mega_menu_item_id AS mega_menu_item_id_48,
  t0.hero_configuration_id AS hero_configuration_id_49,
  t0.connexys_page_configuration_id AS connexys_page_configuration_id_50,
  t0.og_image_id AS og_image_id_51,
  t52.id AS id_53,
  t52.field AS field_54,
  t52.text_size AS text_size_55,
  t52.text_color AS text_color_56,
  t52.text_position AS text_position_57,
  t52.image_id AS image_id_58
FROM
  page t0
  LEFT JOIN route t33 ON t33.page_id = t0.id
  LEFT JOIN og_image t52 ON t0.og_image_id = t52.id
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.type AS type_2, t0.title AS title_3, t0.fixed_header_title AS fixed_header_title_4, t0.body AS body_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.symlink_variable_pattern AS symlink_variable_pattern_9, t0.show_in_menu AS show_in_menu_10, t0.alias AS alias_11, t0.deletable AS deletable_12, t0.class AS class_13, t0.body_class AS body_class_14, t0.breadcrumbs AS breadcrumbs_15, t0.controller AS controller_16, t0.feature AS feature_17, t0.icon_class AS icon_class_18, t0.hide_title AS hide_title_19, t0.concept AS concept_20, t0.target AS target_21, t0.mega_menu AS mega_menu_22, t0.mega_menu_title AS mega_menu_title_23, t0.mega_menu_intro AS mega_menu_intro_24, t0.mega_menu_outro AS mega_menu_outro_25, t0.id AS id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.robots AS robots_29, t0.meta_title AS meta_title_30, t0.meta_description AS meta_description_31, t0.parent_id AS parent_id_32, t33.id AS id_34, t33.`name` AS name_35, t33.defaults AS defaults_36, t33.staticPrefix AS staticPrefix_37, t33.variable_pattern AS variable_pattern_38, t33.requirements AS requirements_39, t33.options AS options_40, t33.host AS host_41, t33.schemes AS schemes_42, t33.`methods` AS methods_43, t33.`condition` AS condition_44, t33.locale AS locale_45, t33.page_id AS page_id_46, t0.symlink_id AS symlink_id_47, t0.mega_menu_item_id AS mega_menu_item_id_48, t0.hero_configuration_id AS hero_configuration_id_49, t0.connexys_page_configuration_id AS connexys_page_configuration_id_50, t0.og_image_id AS og_image_id_51, t52.id AS id_53, t52.field AS field_54, t52.text_size AS text_size_55, t52.text_color AS text_color_56, t52.text_position AS text_position_57, t52.image_id AS image_id_58 FROM page t0 LEFT JOIN route t33 ON t33.page_id = t0.id LEFT JOIN og_image t52 ON t0.og_image_id = t52.id WHERE t0.id = 2 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.`name` AS name_2,
  t0.defaults AS defaults_3,
  t0.staticPrefix AS staticPrefix_4,
  t0.variable_pattern AS variable_pattern_5,
  t0.requirements AS requirements_6,
  t0.options AS options_7,
  t0.host AS host_8,
  t0.schemes AS schemes_9,
  t0.`methods` AS methods_10,
  t0.`condition` AS condition_11,
  t0.locale AS locale_12,
  t0.page_id AS page_id_13
FROM
  route t0
WHERE
  t0.`name` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`name` AS name_2, t0.defaults AS defaults_3, t0.staticPrefix AS staticPrefix_4, t0.variable_pattern AS variable_pattern_5, t0.requirements AS requirements_6, t0.options AS options_7, t0.host AS host_8, t0.schemes AS schemes_9, t0.`methods` AS methods_10, t0.`condition` AS condition_11, t0.locale AS locale_12, t0.page_id AS page_id_13 FROM route t0 WHERE t0.`name` = 'homepage' LIMIT 1;

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.fixed_header_title AS fixed_header_title_4,
  t0.body AS body_5,
  t0.lft AS lft_6,
  t0.lvl AS lvl_7,
  t0.rgt AS rgt_8,
  t0.symlink_variable_pattern AS symlink_variable_pattern_9,
  t0.show_in_menu AS show_in_menu_10,
  t0.alias AS alias_11,
  t0.deletable AS deletable_12,
  t0.class AS class_13,
  t0.body_class AS body_class_14,
  t0.breadcrumbs AS breadcrumbs_15,
  t0.controller AS controller_16,
  t0.feature AS feature_17,
  t0.icon_class AS icon_class_18,
  t0.hide_title AS hide_title_19,
  t0.concept AS concept_20,
  t0.target AS target_21,
  t0.mega_menu AS mega_menu_22,
  t0.mega_menu_title AS mega_menu_title_23,
  t0.mega_menu_intro AS mega_menu_intro_24,
  t0.mega_menu_outro AS mega_menu_outro_25,
  t0.id AS id_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.robots AS robots_29,
  t0.meta_title AS meta_title_30,
  t0.meta_description AS meta_description_31,
  t0.parent_id AS parent_id_32,
  t33.id AS id_34,
  t33.`name` AS name_35,
  t33.defaults AS defaults_36,
  t33.staticPrefix AS staticPrefix_37,
  t33.variable_pattern AS variable_pattern_38,
  t33.requirements AS requirements_39,
  t33.options AS options_40,
  t33.host AS host_41,
  t33.schemes AS schemes_42,
  t33.`methods` AS methods_43,
  t33.`condition` AS condition_44,
  t33.locale AS locale_45,
  t33.page_id AS page_id_46,
  t0.symlink_id AS symlink_id_47,
  t0.mega_menu_item_id AS mega_menu_item_id_48,
  t0.hero_configuration_id AS hero_configuration_id_49,
  t0.connexys_page_configuration_id AS connexys_page_configuration_id_50,
  t0.og_image_id AS og_image_id_51,
  t52.id AS id_53,
  t52.field AS field_54,
  t52.text_size AS text_size_55,
  t52.text_color AS text_color_56,
  t52.text_position AS text_position_57,
  t52.image_id AS image_id_58
FROM
  page t0
  LEFT JOIN route t33 ON t33.page_id = t0.id
  LEFT JOIN og_image t52 ON t0.og_image_id = t52.id
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.type AS type_2, t0.title AS title_3, t0.fixed_header_title AS fixed_header_title_4, t0.body AS body_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.symlink_variable_pattern AS symlink_variable_pattern_9, t0.show_in_menu AS show_in_menu_10, t0.alias AS alias_11, t0.deletable AS deletable_12, t0.class AS class_13, t0.body_class AS body_class_14, t0.breadcrumbs AS breadcrumbs_15, t0.controller AS controller_16, t0.feature AS feature_17, t0.icon_class AS icon_class_18, t0.hide_title AS hide_title_19, t0.concept AS concept_20, t0.target AS target_21, t0.mega_menu AS mega_menu_22, t0.mega_menu_title AS mega_menu_title_23, t0.mega_menu_intro AS mega_menu_intro_24, t0.mega_menu_outro AS mega_menu_outro_25, t0.id AS id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.robots AS robots_29, t0.meta_title AS meta_title_30, t0.meta_description AS meta_description_31, t0.parent_id AS parent_id_32, t33.id AS id_34, t33.`name` AS name_35, t33.defaults AS defaults_36, t33.staticPrefix AS staticPrefix_37, t33.variable_pattern AS variable_pattern_38, t33.requirements AS requirements_39, t33.options AS options_40, t33.host AS host_41, t33.schemes AS schemes_42, t33.`methods` AS methods_43, t33.`condition` AS condition_44, t33.locale AS locale_45, t33.page_id AS page_id_46, t0.symlink_id AS symlink_id_47, t0.mega_menu_item_id AS mega_menu_item_id_48, t0.hero_configuration_id AS hero_configuration_id_49, t0.connexys_page_configuration_id AS connexys_page_configuration_id_50, t0.og_image_id AS og_image_id_51, t52.id AS id_53, t52.field AS field_54, t52.text_size AS text_size_55, t52.text_color AS text_color_56, t52.text_position AS text_position_57, t52.image_id AS image_id_58 FROM page t0 LEFT JOIN route t33 ON t33.page_id = t0.id LEFT JOIN og_image t52 ON t0.og_image_id = t52.id WHERE t0.id = 6 AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.section AS section_2,
  t0.value AS value_3,
  t0.type AS type_4
FROM
  configuration_setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.section AS section_2, t0.value AS value_3, t0.type AS type_4 FROM configuration_setting t0 WHERE t0.name = 'site_open_graph_image' LIMIT 1;

SELECT
  f0_.name AS name_0,
  f0_.active AS active_1
FROM
  feature f0_

SELECT f0_.name AS name_0, f0_.active AS active_1 FROM feature f0_;

SELECT
  v0_.id AS id_0,
  v0_.active AS active_1,
  v0_.created AS created_2,
  v0_.updated AS updated_3,
  v0_.sort_date AS sort_date_4,
  v0_.contact_person AS contact_person_5,
  v0_.contact_person_phone AS contact_person_phone_6,
  v0_.slug AS slug_7,
  v0_.title AS title_8,
  v0_.company_name AS company_name_9,
  v0_.city AS city_10,
  v0_.zipcode AS zipcode_11,
  v0_.external_url AS external_url_12,
  v0_.intro AS intro_13,
  v0_.description AS description_14,
  v0_.featured AS featured_15,
  v0_.internal_vacancy AS internal_vacancy_16,
  v0_.start_date AS start_date_17,
  v0_.end_date AS end_date_18,
  v0_.job_start_date AS job_start_date_19,
  v0_.applicant_form_custom AS applicant_form_custom_20,
  v0_.applicant_email AS applicant_email_21,
  v0_.deleted AS deleted_22,
  v0_.external_reference AS external_reference_23,
  v0_.synced AS synced_24,
  v0_.youtube AS youtube_25,
  v0_.external_id AS external_id_26,
  v0_.displayable_external_id AS displayable_external_id_27,
  v0_.master_vacancy AS master_vacancy_28,
  v0_.country AS country_29,
  v0_.salary_amount AS salary_amount_30,
  v0_.salary_currency AS salary_currency_31,
  v0_.min_salary_amount AS min_salary_amount_32,
  v0_.min_salary_currency AS min_salary_currency_33,
  v0_.max_salary_amount AS max_salary_amount_34,
  v0_.max_salary_currency AS max_salary_currency_35,
  v0_.custom_salary AS custom_salary_36,
  v0_.redirect_count AS redirect_count_37,
  v0_.province AS province_38,
  v0_.company_information AS company_information_39,
  v0_.has_more_info_button AS has_more_info_button_40,
  v0_.owner_notified AS owner_notified_41,
  v0_.`function` AS function_42,
  v0_.external_detail_url AS external_detail_url_43,
  v0_.google_for_job_mapping AS google_for_job_mapping_44,
  v0_.salary_unit AS salary_unit_45,
  v0_.department AS department_46,
  v0_.google_cloud_name AS google_cloud_name_47,
  v0_.address AS address_48,
  v0_.latitude AS latitude_49,
  v0_.longitude AS longitude_50,
  v0_.external_hash AS external_hash_51,
  v0_.meta_title AS meta_title_52,
  v0_.meta_description AS meta_description_53,
  v0_.utm_medium AS utm_medium_54,
  v0_.utm_campaign AS utm_campaign_55,
  v0_.detail_image_asset_id AS detail_image_asset_id_56,
  v0_.overview_image_asset_id AS overview_image_asset_id_57,
  v0_.hero_image_asset_id AS hero_image_asset_id_58,
  v0_.company_id AS company_id_59,
  v0_.recruiter_id AS recruiter_id_60,
  v0_.main_icon_id AS main_icon_id_61,
  v0_.usp_sub_title_id AS usp_sub_title_id_62,
  v0_.description_form_id AS description_form_id_63,
  v0_.applicant_form_id AS applicant_form_id_64,
  v0_.custom_applicant_form_id AS custom_applicant_form_id_65,
  v0_.invoice_id AS invoice_id_66,
  v0_.template_id AS template_id_67,
  v0_.company_logo_asset_id AS company_logo_asset_id_68,
  v0_.multi_poster_id AS multi_poster_id_69,
  v0_.primary_discipline_id AS primary_discipline_id_70,
  v0_.secundary_discipline_id AS secundary_discipline_id_71,
  v0_.harver_experience_id AS harver_experience_id_72,
  v0_.application_process_id AS application_process_id_73,
  v0_.domain_id AS domain_id_74,
  v0_.calendar_id AS calendar_id_75,
  v0_.gallery_id AS gallery_id_76,
  v0_.og_image_id AS og_image_id_77,
  v0_.site_id AS site_id_78
FROM
  vacancy v0_
WHERE
  (
    v0_.active = 1
    AND v0_.deleted IS NULL
    AND (
      v0_.start_date IS NULL
      OR v0_.start_date <= ?
    )
    AND (
      v0_.end_date IS NULL
      OR v0_.end_date >= ?
    )
  )
  AND (v0_.deleted IS NULL)
ORDER BY
  v0_.created DESC
LIMIT
  4

SELECT v0_.id AS id_0, v0_.active AS active_1, v0_.created AS created_2, v0_.updated AS updated_3, v0_.sort_date AS sort_date_4, v0_.contact_person AS contact_person_5, v0_.contact_person_phone AS contact_person_phone_6, v0_.slug AS slug_7, v0_.title AS title_8, v0_.company_name AS company_name_9, v0_.city AS city_10, v0_.zipcode AS zipcode_11, v0_.external_url AS external_url_12, v0_.intro AS intro_13, v0_.description AS description_14, v0_.featured AS featured_15, v0_.internal_vacancy AS internal_vacancy_16, v0_.start_date AS start_date_17, v0_.end_date AS end_date_18, v0_.job_start_date AS job_start_date_19, v0_.applicant_form_custom AS applicant_form_custom_20, v0_.applicant_email AS applicant_email_21, v0_.deleted AS deleted_22, v0_.external_reference AS external_reference_23, v0_.synced AS synced_24, v0_.youtube AS youtube_25, v0_.external_id AS external_id_26, v0_.displayable_external_id AS displayable_external_id_27, v0_.master_vacancy AS master_vacancy_28, v0_.country AS country_29, v0_.salary_amount AS salary_amount_30, v0_.salary_currency AS salary_currency_31, v0_.min_salary_amount AS min_salary_amount_32, v0_.min_salary_currency AS min_salary_currency_33, v0_.max_salary_amount AS max_salary_amount_34, v0_.max_salary_currency AS max_salary_currency_35, v0_.custom_salary AS custom_salary_36, v0_.redirect_count AS redirect_count_37, v0_.province AS province_38, v0_.company_information AS company_information_39, v0_.has_more_info_button AS has_more_info_button_40, v0_.owner_notified AS owner_notified_41, v0_.`function` AS function_42, v0_.external_detail_url AS external_detail_url_43, v0_.google_for_job_mapping AS google_for_job_mapping_44, v0_.salary_unit AS salary_unit_45, v0_.department AS department_46, v0_.google_cloud_name AS google_cloud_name_47, v0_.address AS address_48, v0_.latitude AS latitude_49, v0_.longitude AS longitude_50, v0_.external_hash AS external_hash_51, v0_.meta_title AS meta_title_52, v0_.meta_description AS meta_description_53, v0_.utm_medium AS utm_medium_54, v0_.utm_campaign AS utm_campaign_55, v0_.detail_image_asset_id AS detail_image_asset_id_56, v0_.overview_image_asset_id AS overview_image_asset_id_57, v0_.hero_image_asset_id AS hero_image_asset_id_58, v0_.company_id AS company_id_59, v0_.recruiter_id AS recruiter_id_60, v0_.main_icon_id AS main_icon_id_61, v0_.usp_sub_title_id AS usp_sub_title_id_62, v0_.description_form_id AS description_form_id_63, v0_.applicant_form_id AS applicant_form_id_64, v0_.custom_applicant_form_id AS custom_applicant_form_id_65, v0_.invoice_id AS invoice_id_66, v0_.template_id AS template_id_67, v0_.company_logo_asset_id AS company_logo_asset_id_68, v0_.multi_poster_id AS multi_poster_id_69, v0_.primary_discipline_id AS primary_discipline_id_70, v0_.secundary_discipline_id AS secundary_discipline_id_71, v0_.harver_experience_id AS harver_experience_id_72, v0_.application_process_id AS application_process_id_73, v0_.domain_id AS domain_id_74, v0_.calendar_id AS calendar_id_75, v0_.gallery_id AS gallery_id_76, v0_.og_image_id AS og_image_id_77, v0_.site_id AS site_id_78 FROM vacancy v0_ WHERE (v0_.active = 1 AND v0_.deleted IS NULL AND (v0_.start_date IS NULL OR v0_.start_date <= '2025-01-18 02:52:34') AND (v0_.end_date IS NULL OR v0_.end_date >= '2025-01-18 02:52:34')) AND (v0_.deleted IS NULL) ORDER BY v0_.created DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.country AS country_6,
  t0.contact_person AS contact_person_7,
  t0.contact_person_gender AS contact_person_gender_8,
  t0.contact_person_first_name AS contact_person_first_name_9,
  t0.contact_person_initials AS contact_person_initials_10,
  t0.contact_person_prefix AS contact_person_prefix_11,
  t0.contact_person_last_name AS contact_person_last_name_12,
  t0.phone AS phone_13,
  t0.extension AS extension_14,
  t0.mobile AS mobile_15,
  t0.website AS website_16,
  t0.email AS email_17,
  t0.updated_at AS updated_at_18,
  t0.applicant_email AS applicant_email_19,
  t0.description AS description_20,
  t0.external_id AS external_id_21,
  t0.canonical_url AS canonical_url_22,
  t0.deleted AS deleted_23,
  t0.openinghours AS openinghours_24,
  t0.accessibility AS accessibility_25,
  t0.credits AS credits_26,
  t0.video AS video_27,
  t0.action_date AS action_date_28,
  t0.action_type AS action_type_29,
  t0.friendly_url AS friendly_url_30,
  t0.province AS province_31,
  t0.company_information AS company_information_32,
  t0.multi_poster_id AS multi_poster_id_33,
  t0.google_cloud_name AS google_cloud_name_34,
  t0.featured AS featured_35,
  t0.department AS department_36,
  t0.po_number AS po_number_37,
  t0.invoice_company_name AS invoice_company_name_38,
  t0.invoice_department AS invoice_department_39,
  t0.invoice_contact_person AS invoice_contact_person_40,
  t0.invoice_email_address AS invoice_email_address_41,
  t0.invoice_address AS invoice_address_42,
  t0.invoice_zipcode AS invoice_zipcode_43,
  t0.invoice_city AS invoice_city_44,
  t0.invoice_phone AS invoice_phone_45,
  t0.detail_page AS detail_page_46,
  t0.detail_page_expiration_date AS detail_page_expiration_date_47,
  t0.address AS address_48,
  t0.latitude AS latitude_49,
  t0.longitude AS longitude_50,
  t0.meta_title AS meta_title_51,
  t0.meta_description AS meta_description_52,
  t0.utm_medium AS utm_medium_53,
  t0.utm_campaign AS utm_campaign_54,
  t0.logo_asset_id AS logo_asset_id_55,
  t56.id AS id_57,
  t56.file_name AS file_name_58,
  t56.file_size AS file_size_59,
  t56.file_mime_type AS file_mime_type_60,
  t56.meta_information AS meta_information_61,
  t56.updated_at AS updated_at_62,
  t56.external_id AS external_id_63,
  t56.folder_id AS folder_id_64,
  t0.hero_asset_id AS hero_asset_id_65,
  t0.overview_image_asset_id AS overview_image_asset_id_66,
  t0.fields_form_id AS fields_form_id_67,
  t0.hero_configuration_id AS hero_configuration_id_68,
  t0.company_status_id AS company_status_id_69,
  t0.action_assignee_id AS action_assignee_id_70,
  t0.consultant_id AS consultant_id_71,
  t0.application_process_id AS application_process_id_72,
  t0.gallery_id AS gallery_id_73,
  t74.id AS id_75,
  t74.name AS name_76,
  t74.title AS title_77,
  t74.intro AS intro_78,
  t74.context AS context_79,
  t74.format AS format_80,
  t74.enabled AS enabled_81,
  t74.video_embed_id AS video_embed_id_82,
  t0.site_id AS site_id_83
FROM
  company t0
  LEFT JOIN asset t56 ON t0.logo_asset_id = t56.id
  LEFT JOIN gallery t74 ON t0.gallery_id = t74.id
WHERE
  t0.id IN (?)
  AND (
    (t0.deleted IS NULL)
  )