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
  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_.slug AS slug_1,
  c0_.name AS name_2,
  c0_.zipcode AS zipcode_3,
  c0_.city AS city_4,
  c0_.country AS country_5,
  c0_.contact_person AS contact_person_6,
  c0_.contact_person_gender AS contact_person_gender_7,
  c0_.contact_person_first_name AS contact_person_first_name_8,
  c0_.contact_person_initials AS contact_person_initials_9,
  c0_.contact_person_prefix AS contact_person_prefix_10,
  c0_.contact_person_last_name AS contact_person_last_name_11,
  c0_.phone AS phone_12,
  c0_.extension AS extension_13,
  c0_.mobile AS mobile_14,
  c0_.website AS website_15,
  c0_.email AS email_16,
  c0_.updated_at AS updated_at_17,
  c0_.applicant_email AS applicant_email_18,
  c0_.description AS description_19,
  c0_.external_id AS external_id_20,
  c0_.canonical_url AS canonical_url_21,
  c0_.deleted AS deleted_22,
  c0_.openinghours AS openinghours_23,
  c0_.accessibility AS accessibility_24,
  c0_.credits AS credits_25,
  c0_.video AS video_26,
  c0_.action_date AS action_date_27,
  c0_.action_type AS action_type_28,
  c0_.friendly_url AS friendly_url_29,
  c0_.province AS province_30,
  c0_.company_information AS company_information_31,
  c0_.multi_poster_id AS multi_poster_id_32,
  c0_.google_cloud_name AS google_cloud_name_33,
  c0_.featured AS featured_34,
  c0_.department AS department_35,
  c0_.po_number AS po_number_36,
  c0_.invoice_company_name AS invoice_company_name_37,
  c0_.invoice_department AS invoice_department_38,
  c0_.invoice_contact_person AS invoice_contact_person_39,
  c0_.invoice_email_address AS invoice_email_address_40,
  c0_.invoice_address AS invoice_address_41,
  c0_.invoice_zipcode AS invoice_zipcode_42,
  c0_.invoice_city AS invoice_city_43,
  c0_.invoice_phone AS invoice_phone_44,
  c0_.detail_page AS detail_page_45,
  c0_.detail_page_expiration_date AS detail_page_expiration_date_46,
  c0_.address AS address_47,
  c0_.latitude AS latitude_48,
  c0_.longitude AS longitude_49,
  c0_.meta_title AS meta_title_50,
  c0_.meta_description AS meta_description_51,
  c0_.utm_medium AS utm_medium_52,
  c0_.utm_campaign AS utm_campaign_53,
  c0_.logo_asset_id AS logo_asset_id_54,
  c0_.hero_asset_id AS hero_asset_id_55,
  c0_.overview_image_asset_id AS overview_image_asset_id_56,
  c0_.fields_form_id AS fields_form_id_57,
  c0_.hero_configuration_id AS hero_configuration_id_58,
  c0_.company_status_id AS company_status_id_59,
  c0_.action_assignee_id AS action_assignee_id_60,
  c0_.consultant_id AS consultant_id_61,
  c0_.application_process_id AS application_process_id_62,
  c0_.gallery_id AS gallery_id_63,
  c0_.site_id AS site_id_64
FROM
  company c0_
WHERE
  (c0_.id = ?)
  AND (c0_.deleted IS NULL)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.name AS name_2, c0_.zipcode AS zipcode_3, c0_.city AS city_4, c0_.country AS country_5, c0_.contact_person AS contact_person_6, c0_.contact_person_gender AS contact_person_gender_7, c0_.contact_person_first_name AS contact_person_first_name_8, c0_.contact_person_initials AS contact_person_initials_9, c0_.contact_person_prefix AS contact_person_prefix_10, c0_.contact_person_last_name AS contact_person_last_name_11, c0_.phone AS phone_12, c0_.extension AS extension_13, c0_.mobile AS mobile_14, c0_.website AS website_15, c0_.email AS email_16, c0_.updated_at AS updated_at_17, c0_.applicant_email AS applicant_email_18, c0_.description AS description_19, c0_.external_id AS external_id_20, c0_.canonical_url AS canonical_url_21, c0_.deleted AS deleted_22, c0_.openinghours AS openinghours_23, c0_.accessibility AS accessibility_24, c0_.credits AS credits_25, c0_.video AS video_26, c0_.action_date AS action_date_27, c0_.action_type AS action_type_28, c0_.friendly_url AS friendly_url_29, c0_.province AS province_30, c0_.company_information AS company_information_31, c0_.multi_poster_id AS multi_poster_id_32, c0_.google_cloud_name AS google_cloud_name_33, c0_.featured AS featured_34, c0_.department AS department_35, c0_.po_number AS po_number_36, c0_.invoice_company_name AS invoice_company_name_37, c0_.invoice_department AS invoice_department_38, c0_.invoice_contact_person AS invoice_contact_person_39, c0_.invoice_email_address AS invoice_email_address_40, c0_.invoice_address AS invoice_address_41, c0_.invoice_zipcode AS invoice_zipcode_42, c0_.invoice_city AS invoice_city_43, c0_.invoice_phone AS invoice_phone_44, c0_.detail_page AS detail_page_45, c0_.detail_page_expiration_date AS detail_page_expiration_date_46, c0_.address AS address_47, c0_.latitude AS latitude_48, c0_.longitude AS longitude_49, c0_.meta_title AS meta_title_50, c0_.meta_description AS meta_description_51, c0_.utm_medium AS utm_medium_52, c0_.utm_campaign AS utm_campaign_53, c0_.logo_asset_id AS logo_asset_id_54, c0_.hero_asset_id AS hero_asset_id_55, c0_.overview_image_asset_id AS overview_image_asset_id_56, c0_.fields_form_id AS fields_form_id_57, c0_.hero_configuration_id AS hero_configuration_id_58, c0_.company_status_id AS company_status_id_59, c0_.action_assignee_id AS action_assignee_id_60, c0_.consultant_id AS consultant_id_61, c0_.application_process_id AS application_process_id_62, c0_.gallery_id AS gallery_id_63, c0_.site_id AS site_id_64 FROM company c0_ WHERE (c0_.id = 11) AND (c0_.deleted IS NULL);

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.file_size AS file_size_3,
  t0.file_mime_type AS file_mime_type_4,
  t0.meta_information AS meta_information_5,
  t0.updated_at AS updated_at_6,
  t0.external_id AS external_id_7,
  t0.folder_id AS folder_id_8
FROM
  asset t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.file_mime_type AS file_mime_type_4, t0.meta_information AS meta_information_5, t0.updated_at AS updated_at_6, t0.external_id AS external_id_7, t0.folder_id AS folder_id_8 FROM asset t0 WHERE t0.id IN (157);

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
  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-09-19 16:07:47') AND (v0_.end_date IS NULL OR v0_.end_date >= '2024-09-19 16:07:47') AND c1_.id = 11) AND (c1_.deleted IS NULL);

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)

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 = 1 AND (v0_.start_date IS NULL OR v0_.start_date <= '2024-09-19 16:07:47') AND (v0_.end_date IS NULL OR v0_.end_date > '2024-09-19 16:07:47') AND v0_.company_id = 11) AND (v0_.deleted IS NULL);

SELECT
  t0.id AS id_1,
  t0.field AS field_2,
  t0.text_size AS text_size_3,
  t0.text_color AS text_color_4,
  t0.text_position AS text_position_5,
  t0.image_id AS image_id_6
FROM
  og_image t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

SELECT t0.id AS id_1, t0.field AS field_2, t0.text_size AS text_size_3, t0.text_color AS text_color_4, t0.text_position AS text_position_5, t0.image_id AS image_id_6 FROM og_image t0 WHERE t0.id IN (104, 106, 107, 109, 113, 114, 116, 120, 122, 124, 125, 126, 127, 128, 129, 158, 187, 190, 268, 269, 326, 335, 337, 339, 342, 343, 348, 349, 350, 351, 353, 354);

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
  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 = 11 AND v0_.featured = 1 AND v0_.active = 1 AND (v0_.start_date < '2024-09-19 16:07:47' OR v0_.start_date IS NULL) AND (v0_.end_date >= '2024-09-19 16:07:47' OR v0_.end_date IS NULL)) AND (v0_.deleted IS NULL) ORDER BY v0_.start_date DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.font_awesome_icon AS font_awesome_icon_3,
  t0.counter AS counter_4,
  t0.`type` AS type_5,
  t0.category AS category_6,
  t0.description AS description_7,
  t0.url AS url_8,
  t0.url_target AS url_target_9,
  t0.dot_start_at AS dot_start_at_10,
  t0.prefix AS prefix_11,
  t0.suffix AS suffix_12,
  t0.position AS position_13,
  t0.usp_image_asset_id AS usp_image_asset_id_14,
  t15.id AS id_16,
  t15.file_name AS file_name_17,
  t15.file_size AS file_size_18,
  t15.file_mime_type AS file_mime_type_19,
  t15.meta_information AS meta_information_20,
  t15.updated_at AS updated_at_21,
  t15.external_id AS external_id_22,
  t15.folder_id AS folder_id_23
FROM
  usp t0
  LEFT JOIN asset t15 ON t0.usp_image_asset_id = t15.id

SELECT t0.id AS id_1, t0.value AS value_2, t0.font_awesome_icon AS font_awesome_icon_3, t0.counter AS counter_4, t0.`type` AS type_5, t0.category AS category_6, t0.description AS description_7, t0.url AS url_8, t0.url_target AS url_target_9, t0.dot_start_at AS dot_start_at_10, t0.prefix AS prefix_11, t0.suffix AS suffix_12, t0.position AS position_13, t0.usp_image_asset_id AS usp_image_asset_id_14, t15.id AS id_16, t15.file_name AS file_name_17, t15.file_size AS file_size_18, t15.file_mime_type AS file_mime_type_19, t15.meta_information AS meta_information_20, t15.updated_at AS updated_at_21, t15.external_id AS external_id_22, t15.folder_id AS folder_id_23 FROM usp t0 LEFT JOIN asset t15 ON t0.usp_image_asset_id = t15.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 = ?

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 = 11;

SELECT
  t0_.title AS title_0,
  t0_.employee_name AS employee_name_1,
  t0_.company AS company_2,
  t0_.slug AS slug_3,
  t0_.intro AS intro_4,
  t0_.url AS url_5,
  t0_.url_target AS url_target_6,
  t0_.value AS value_7,
  t0_.picture_title AS picture_title_8,
  t0_.meta_title AS meta_title_9,
  t0_.meta_description AS meta_description_10,
  t0_.detail_page AS detail_page_11,
  t0_.id AS id_12,
  t0_.created_at AS created_at_13,
  t0_.updated_at AS updated_at_14,
  t0_.robots AS robots_15,
  t0_.layout_file AS layout_file_16,
  count(t1_.id) AS sclr_17,
  t0_.picture_asset_id AS picture_asset_id_18,
  t0_.author_picture_asset_id AS author_picture_asset_id_19,
  t0_.og_asset_id AS og_asset_id_20,
  t0_.company_logo_asset_id AS company_logo_asset_id_21,
  t0_.employee_id AS employee_id_22,
  t0_.product_id AS product_id_23,
  t0_.portfolio_id AS portfolio_id_24,
  t0_.calendar_id AS calendar_id_25,
  t0_.gallery_id AS gallery_id_26,
  t0_.video_embed_id AS video_embed_id_27
FROM
  testimonial t0_
  INNER JOIN testimonial_tags t2_ ON t0_.id = t2_.testimonial_id
  INNER JOIN tag t1_ ON t1_.id = t2_.tag_id
  AND (
    t1_.id IN (NULL)
  )
GROUP BY
  t0_.id
ORDER BY
  sclr_17 DESC

SELECT t0_.title AS title_0, t0_.employee_name AS employee_name_1, t0_.company AS company_2, t0_.slug AS slug_3, t0_.intro AS intro_4, t0_.url AS url_5, t0_.url_target AS url_target_6, t0_.value AS value_7, t0_.picture_title AS picture_title_8, t0_.meta_title AS meta_title_9, t0_.meta_description AS meta_description_10, t0_.detail_page AS detail_page_11, t0_.id AS id_12, t0_.created_at AS created_at_13, t0_.updated_at AS updated_at_14, t0_.robots AS robots_15, t0_.layout_file AS layout_file_16, count(t1_.id) AS sclr_17, t0_.picture_asset_id AS picture_asset_id_18, t0_.author_picture_asset_id AS author_picture_asset_id_19, t0_.og_asset_id AS og_asset_id_20, t0_.company_logo_asset_id AS company_logo_asset_id_21, t0_.employee_id AS employee_id_22, t0_.product_id AS product_id_23, t0_.portfolio_id AS portfolio_id_24, t0_.calendar_id AS calendar_id_25, t0_.gallery_id AS gallery_id_26, t0_.video_embed_id AS video_embed_id_27 FROM testimonial t0_ INNER JOIN testimonial_tags t2_ ON t0_.id = t2_.testimonial_id INNER JOIN tag t1_ ON t1_.id = t2_.tag_id AND (t1_.id IN (NULL)) GROUP BY t0_.id ORDER BY sclr_17 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