Symfony Profiler

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 <= '2024-09-18 19:47:17') AND (v0_.end_date IS NULL OR v0_.end_date >= '2024-09-18 19:47:17')) AND (v0_.deleted IS NULL) ORDER BY v0_.created DESC LIMIT 4;

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.value AS value_2,
  t0.title AS title_3,
  t0.sub_title AS sub_title_4,
  t0.slug AS slug_5,
  t0.position AS position_6,
  t0.font_awesome_icon AS font_awesome_icon_7,
  t0.youtube_video_url AS youtube_video_url_8,
  t0.content AS content_9,
  t0.content_truncate_at AS content_truncate_at_10,
  t0.external_reference AS external_reference_11,
  t0.visibility_days AS visibility_days_12,
  t0.click_target AS click_target_13,
  t0.detail_page AS detail_page_14,
  t0.matchable_values AS matchable_values_15,
  t0.meta_title AS meta_title_16,
  t0.meta_description AS meta_description_17,
  t0.external_id AS external_id_18,
  t0.external_hash AS external_hash_19,
  t0.layout_file AS layout_file_20,
  t0.option_id AS option_id_21,
  t22.id AS id_23,
  t22.title AS title_24,
  t22.slug AS slug_25,
  t22.font_awesome_icon AS font_awesome_icon_26,
  t22.expanded_by_default AS expanded_by_default_27,
  t22.strategy_on_overview AS strategy_on_overview_28,
  t22.visible_in_detail AS visible_in_detail_29,
  t22.group_text AS group_text_30,
  t22.group_at_count AS group_at_count_31,
  t22.internal_name AS internal_name_32,
  t22.sort_option_images AS sort_option_images_33,
  t22.strategy_on_job_profile_overview AS strategy_on_job_profile_overview_34,
  t22.display_type AS display_type_35,
  t22.expanded_strategy AS expanded_strategy_36,
  t22.contextual_title AS contextual_title_37,
  t22.external_id AS external_id_38,
  t22.external_reference AS external_reference_39,
  t22.external_hash AS external_hash_40,
  t22.position AS position_41,
  t22.job_alert_setting_id AS job_alert_setting_id_42,
  t0.youtube_video_fallback_image_asset_id AS youtube_video_fallback_image_asset_id_43,
  t44.id AS id_45,
  t44.file_name AS file_name_46,
  t44.file_size AS file_size_47,
  t44.file_mime_type AS file_mime_type_48,
  t44.meta_information AS meta_information_49,
  t44.updated_at AS updated_at_50,
  t44.external_id AS external_id_51,
  t44.folder_id AS folder_id_52,
  t0.event_category_id AS event_category_id_53,
  t0.parent_id AS parent_id_54,
  t0.application_process_id AS application_process_id_55,
  t0.applicant_form_id AS applicant_form_id_56,
  t0.recruiter_id AS recruiter_id_57,
  t0.calendar_id AS calendar_id_58,
  t0.gallery_id AS gallery_id_59,
  t60.id AS id_61,
  t60.name AS name_62,
  t60.title AS title_63,
  t60.intro AS intro_64,
  t60.context AS context_65,
  t60.format AS format_66,
  t60.enabled AS enabled_67,
  t60.video_embed_id AS video_embed_id_68,
  t0.site_id AS site_id_69
FROM
  vacancy_option_value t0
  LEFT JOIN vacancy_option t22 ON t0.option_id = t22.id
  LEFT JOIN asset t44 ON t0.youtube_video_fallback_image_asset_id = t44.id
  LEFT JOIN gallery t60 ON t0.gallery_id = t60.id
  INNER JOIN vacancy_option_value_option ON t0.id = vacancy_option_value_option.option_value_id
WHERE
  vacancy_option_value_option.vacancy_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.value AS value_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.slug AS slug_5, t0.position AS position_6, t0.font_awesome_icon AS font_awesome_icon_7, t0.youtube_video_url AS youtube_video_url_8, t0.content AS content_9, t0.content_truncate_at AS content_truncate_at_10, t0.external_reference AS external_reference_11, t0.visibility_days AS visibility_days_12, t0.click_target AS click_target_13, t0.detail_page AS detail_page_14, t0.matchable_values AS matchable_values_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.external_id AS external_id_18, t0.external_hash AS external_hash_19, t0.layout_file AS layout_file_20, t0.option_id AS option_id_21, t22.id AS id_23, t22.title AS title_24, t22.slug AS slug_25, t22.font_awesome_icon AS font_awesome_icon_26, t22.expanded_by_default AS expanded_by_default_27, t22.strategy_on_overview AS strategy_on_overview_28, t22.visible_in_detail AS visible_in_detail_29, t22.group_text AS group_text_30, t22.group_at_count AS group_at_count_31, t22.internal_name AS internal_name_32, t22.sort_option_images AS sort_option_images_33, t22.strategy_on_job_profile_overview AS strategy_on_job_profile_overview_34, t22.display_type AS display_type_35, t22.expanded_strategy AS expanded_strategy_36, t22.contextual_title AS contextual_title_37, t22.external_id AS external_id_38, t22.external_reference AS external_reference_39, t22.external_hash AS external_hash_40, t22.position AS position_41, t22.job_alert_setting_id AS job_alert_setting_id_42, t0.youtube_video_fallback_image_asset_id AS youtube_video_fallback_image_asset_id_43, t44.id AS id_45, t44.file_name AS file_name_46, t44.file_size AS file_size_47, t44.file_mime_type AS file_mime_type_48, t44.meta_information AS meta_information_49, t44.updated_at AS updated_at_50, t44.external_id AS external_id_51, t44.folder_id AS folder_id_52, t0.event_category_id AS event_category_id_53, t0.parent_id AS parent_id_54, t0.application_process_id AS application_process_id_55, t0.applicant_form_id AS applicant_form_id_56, t0.recruiter_id AS recruiter_id_57, t0.calendar_id AS calendar_id_58, t0.gallery_id AS gallery_id_59, t60.id AS id_61, t60.name AS name_62, t60.title AS title_63, t60.intro AS intro_64, t60.context AS context_65, t60.format AS format_66, t60.enabled AS enabled_67, t60.video_embed_id AS video_embed_id_68, t0.site_id AS site_id_69 FROM vacancy_option_value t0 LEFT JOIN vacancy_option t22 ON t0.option_id = t22.id LEFT JOIN asset t44 ON t0.youtube_video_fallback_image_asset_id = t44.id LEFT JOIN gallery t60 ON t0.gallery_id = t60.id INNER JOIN vacancy_option_value_option ON t0.id = vacancy_option_value_option.option_value_id WHERE vacancy_option_value_option.vacancy_id = 354 ORDER BY t0.position ASC;

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
  INNER JOIN vacancy_usp_option ON t0.id = vacancy_usp_option.usp_id
WHERE
  vacancy_usp_option.vacancy_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 INNER JOIN vacancy_usp_option ON t0.id = vacancy_usp_option.usp_id WHERE vacancy_usp_option.vacancy_id = 354;

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)
  )

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 (11) AND ((t0.deleted IS NULL));

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.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_open_graph_image' LIMIT 1;