Symfony Profiler

SELECT
  count(
    DISTINCT (v0_.id)
  ) AS sclr_0
FROM
  company c1_
  LEFT JOIN vacancy v0_ ON c1_.id = v0_.company_id
  AND (v0_.deleted IS NULL)
WHERE
  (
    v0_.active = ?
    AND (
      v0_.start_date IS NULL
      OR v0_.start_date < ?
    )
    AND (
      v0_.end_date IS NULL
      OR v0_.end_date >= ?
    )
    AND c1_.id = ?
  )
  AND (c1_.deleted IS NULL)

SELECT count(DISTINCT (v0_.id)) AS sclr_0 FROM company c1_ LEFT JOIN vacancy v0_ ON c1_.id = v0_.company_id AND (v0_.deleted IS NULL) WHERE (v0_.active = 1 AND (v0_.start_date IS NULL OR v0_.start_date < '2024-11-15 18:26:59') AND (v0_.end_date IS NULL OR v0_.end_date >= '2024-11-15 18:26:59') AND c1_.id = 8) AND (c1_.deleted IS NULL);

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.appearance AS appearance_3
FROM
  tag t0
  INNER JOIN company_tags ON t0.id = company_tags.tag_id
WHERE
  company_tags.company_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.appearance AS appearance_3 FROM tag t0 INNER JOIN company_tags ON t0.id = company_tags.tag_id WHERE company_tags.company_id = 8;

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.parent_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.lft ASC

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.parent_id = 35 AND ((t0.deleted_at IS NULL)) ORDER BY t0.lft ASC;

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_company_overview_option' 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 = 33 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,
  t0.symlink_id AS symlink_id_33,
  t0.mega_menu_item_id AS mega_menu_item_id_34,
  t0.hero_configuration_id AS hero_configuration_id_35,
  t0.connexys_page_configuration_id AS connexys_page_configuration_id_36,
  t0.og_image_id AS og_image_id_37,
  t38.id AS id_39,
  t38.field AS field_40,
  t38.text_size AS text_size_41,
  t38.text_color AS text_color_42,
  t38.text_position AS text_position_43,
  t38.image_id AS image_id_44
FROM
  page t0
  LEFT JOIN og_image t38 ON t0.og_image_id = t38.id
WHERE
  t0.alias = ?
  AND (
    (t0.deleted_at IS NULL)
  )
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, t0.symlink_id AS symlink_id_33, t0.mega_menu_item_id AS mega_menu_item_id_34, t0.hero_configuration_id AS hero_configuration_id_35, t0.connexys_page_configuration_id AS connexys_page_configuration_id_36, t0.og_image_id AS og_image_id_37, t38.id AS id_39, t38.field AS field_40, t38.text_size AS text_size_41, t38.text_color AS text_color_42, t38.text_position AS text_position_43, t38.image_id AS image_id_44 FROM page t0 LEFT JOIN og_image t38 ON t0.og_image_id = t38.id WHERE t0.alias = 'header_navigation' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.location AS location_3,
  t0.script AS script_4,
  t0.type AS type_5
FROM
  google_tag_manager t0
WHERE
  t0.location = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.location AS location_3, t0.script AS script_4, t0.type AS type_5 FROM google_tag_manager t0 WHERE t0.location = 'heading_start';

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_.company_id = ?
    AND v0_.featured = ?
    AND v0_.active = ?
    AND (
      v0_.start_date < ?
      OR v0_.start_date IS NULL
    )
    AND (
      v0_.end_date >= ?
      OR v0_.end_date IS NULL
    )
  )
  AND (v0_.deleted IS NULL)
ORDER BY
  v0_.start_date DESC
LIMIT
  10

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_.company_id = 8 AND v0_.featured = 1 AND v0_.active = 1 AND (v0_.start_date < '2024-11-15 18:27:00' OR v0_.start_date IS NULL) AND (v0_.end_date >= '2024-11-15 18:27:00' OR v0_.end_date IS NULL)) AND (v0_.deleted IS NULL) ORDER BY v0_.start_date DESC LIMIT 10;

SELECT
  p0_.deleted_at AS deleted_at_0,
  p0_.type AS type_1,
  p0_.title AS title_2,
  p0_.fixed_header_title AS fixed_header_title_3,
  p0_.body AS body_4,
  p0_.lft AS lft_5,
  p0_.lvl AS lvl_6,
  p0_.rgt AS rgt_7,
  p0_.symlink_variable_pattern AS symlink_variable_pattern_8,
  p0_.show_in_menu AS show_in_menu_9,
  p0_.alias AS alias_10,
  p0_.deletable AS deletable_11,
  p0_.class AS class_12,
  p0_.body_class AS body_class_13,
  p0_.breadcrumbs AS breadcrumbs_14,
  p0_.controller AS controller_15,
  p0_.feature AS feature_16,
  p0_.icon_class AS icon_class_17,
  p0_.hide_title AS hide_title_18,
  p0_.concept AS concept_19,
  p0_.target AS target_20,
  p0_.mega_menu AS mega_menu_21,
  p0_.mega_menu_title AS mega_menu_title_22,
  p0_.mega_menu_intro AS mega_menu_intro_23,
  p0_.mega_menu_outro AS mega_menu_outro_24,
  p0_.id AS id_25,
  p0_.created_at AS created_at_26,
  p0_.updated_at AS updated_at_27,
  p0_.robots AS robots_28,
  p0_.meta_title AS meta_title_29,
  p0_.meta_description AS meta_description_30,
  r1_.id AS id_31,
  r1_.`name` AS name_32,
  r1_.defaults AS defaults_33,
  r1_.staticPrefix AS staticPrefix_34,
  r1_.variable_pattern AS variable_pattern_35,
  r1_.requirements AS requirements_36,
  r1_.options AS options_37,
  r1_.host AS host_38,
  r1_.schemes AS schemes_39,
  r1_.`methods` AS methods_40,
  r1_.`condition` AS condition_41,
  r1_.locale AS locale_42,
  p0_.parent_id AS parent_id_43,
  p0_.symlink_id AS symlink_id_44,
  p0_.mega_menu_item_id AS mega_menu_item_id_45,
  p0_.hero_configuration_id AS hero_configuration_id_46,
  p0_.connexys_page_configuration_id AS connexys_page_configuration_id_47,
  p0_.og_image_id AS og_image_id_48,
  r1_.page_id AS page_id_49
FROM
  page p0_
  LEFT JOIN route r1_ ON p0_.id = r1_.page_id
WHERE
  (
    p0_.parent_id = ?
    AND p0_.show_in_menu = 1
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.lft ASC

SELECT p0_.deleted_at AS deleted_at_0, p0_.type AS type_1, p0_.title AS title_2, p0_.fixed_header_title AS fixed_header_title_3, p0_.body AS body_4, p0_.lft AS lft_5, p0_.lvl AS lvl_6, p0_.rgt AS rgt_7, p0_.symlink_variable_pattern AS symlink_variable_pattern_8, p0_.show_in_menu AS show_in_menu_9, p0_.alias AS alias_10, p0_.deletable AS deletable_11, p0_.class AS class_12, p0_.body_class AS body_class_13, p0_.breadcrumbs AS breadcrumbs_14, p0_.controller AS controller_15, p0_.feature AS feature_16, p0_.icon_class AS icon_class_17, p0_.hide_title AS hide_title_18, p0_.concept AS concept_19, p0_.target AS target_20, p0_.mega_menu AS mega_menu_21, p0_.mega_menu_title AS mega_menu_title_22, p0_.mega_menu_intro AS mega_menu_intro_23, p0_.mega_menu_outro AS mega_menu_outro_24, p0_.id AS id_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.robots AS robots_28, p0_.meta_title AS meta_title_29, p0_.meta_description AS meta_description_30, r1_.id AS id_31, r1_.`name` AS name_32, r1_.defaults AS defaults_33, r1_.staticPrefix AS staticPrefix_34, r1_.variable_pattern AS variable_pattern_35, r1_.requirements AS requirements_36, r1_.options AS options_37, r1_.host AS host_38, r1_.schemes AS schemes_39, r1_.`methods` AS methods_40, r1_.`condition` AS condition_41, r1_.locale AS locale_42, p0_.parent_id AS parent_id_43, p0_.symlink_id AS symlink_id_44, p0_.mega_menu_item_id AS mega_menu_item_id_45, p0_.hero_configuration_id AS hero_configuration_id_46, p0_.connexys_page_configuration_id AS connexys_page_configuration_id_47, p0_.og_image_id AS og_image_id_48, r1_.page_id AS page_id_49 FROM page p0_ LEFT JOIN route r1_ ON p0_.id = r1_.page_id WHERE (p0_.parent_id = 2 AND p0_.show_in_menu = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.site_id AS site_id_3,
  t4.id AS id_5,
  t4.name AS name_6,
  t4.country AS country_7,
  t4.default_locale AS default_locale_8,
  t4.locales AS locales_9,
  t4.mapping_values AS mapping_values_10,
  t4.parent AS parent_11,
  t4.all_vacancies AS all_vacancies_12,
  t4.address AS address_13,
  t4.latitude AS latitude_14,
  t4.longitude AS longitude_15
FROM
  site_domain t0
  LEFT JOIN site t4 ON t0.site_id = t4.id
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.site_id AS site_id_3, t4.id AS id_5, t4.name AS name_6, t4.country AS country_7, t4.default_locale AS default_locale_8, t4.locales AS locales_9, t4.mapping_values AS mapping_values_10, t4.parent AS parent_11, t4.all_vacancies AS all_vacancies_12, t4.address AS address_13, t4.latitude AS latitude_14, t4.longitude AS longitude_15 FROM site_domain t0 LEFT JOIN site t4 ON t0.site_id = t4.id WHERE t0.url = 'mbobanen.staging.03.getnoticed.nl' 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_.deleted IS NULL
    AND v0_.active = ?
    AND (
      v0_.start_date IS NULL
      OR v0_.start_date <= ?
    )
    AND (
      v0_.end_date IS NULL
      OR v0_.end_date > ?
    )
    AND v0_.company_id = ?
  )
  AND (v0_.deleted IS NULL)