Symfony Profiler

SELECT
  v0_.id AS id_0,
  v0_.slug AS slug_1
FROM
  vacancy v0_
  LEFT JOIN vacancy_domain v1_ ON v0_.domain_id = v1_.id
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_.domain_id IS NULL
      OR v1_.indexable <> ?
    )
  )
  AND (v0_.deleted IS NULL)

SELECT v0_.id AS id_0, v0_.slug AS slug_1 FROM vacancy v0_ LEFT JOIN vacancy_domain v1_ ON v0_.domain_id = v1_.id WHERE (v0_.deleted IS NULL AND v0_.active = 1 AND (v0_.start_date IS NULL OR v0_.start_date <= '2025-04-26 23:07:58') AND (v0_.end_date IS NULL OR v0_.end_date > '2025-04-26 23:07:58') AND (v0_.domain_id IS NULL OR v1_.indexable <> 0)) AND (v0_.deleted 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 = 6 AND ((t0.deleted_at IS NULL));

SELECT
  t0.meta_title AS meta_title_1,
  t0.meta_description AS meta_description_2,
  t0.deleted AS deleted_3,
  t0.title AS title_4,
  t0.status AS status_5,
  t0.slug AS slug_6,
  t0.intro AS intro_7,
  t0.body AS body_8,
  t0.author AS author_9,
  t0.top_post AS top_post_10,
  t0.youtube AS youtube_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.canonical_url AS canonical_url_16,
  t0.banner_image_asset_id AS banner_image_asset_id_17,
  t0.owner_id AS owner_id_18,
  t0.employee_id AS employee_id_19
FROM
  blog t0
WHERE
  (
    (t0.deleted IS NULL)
  )

SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.deleted AS deleted_3, t0.title AS title_4, t0.status AS status_5, t0.slug AS slug_6, t0.intro AS intro_7, t0.body AS body_8, t0.author AS author_9, t0.top_post AS top_post_10, t0.youtube AS youtube_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.canonical_url AS canonical_url_16, t0.banner_image_asset_id AS banner_image_asset_id_17, t0.owner_id AS owner_id_18, t0.employee_id AS employee_id_19 FROM blog t0 WHERE ((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.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.deleted IS NULL));

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

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;

SELECT
  t0.title AS title_1,
  t0.employee_name AS employee_name_2,
  t0.company AS company_3,
  t0.slug AS slug_4,
  t0.intro AS intro_5,
  t0.url AS url_6,
  t0.url_target AS url_target_7,
  t0.value AS value_8,
  t0.picture_title AS picture_title_9,
  t0.meta_title AS meta_title_10,
  t0.meta_description AS meta_description_11,
  t0.detail_page AS detail_page_12,
  t0.id AS id_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.robots AS robots_16,
  t0.layout_file AS layout_file_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,
  t23.id AS id_24,
  t23.active AS active_25,
  t23.`default` AS default_26,
  t23.function AS function_27,
  t23.department AS department_28,
  t23.first_name AS first_name_29,
  t23.last_name AS last_name_30,
  t23.slug AS slug_31,
  t23.quote AS quote_32,
  t23.email AS email_33,
  t23.phone AS phone_34,
  t23.mobile AS mobile_35,
  t23.linkedin_url AS linkedin_url_36,
  t23.facebook_url AS facebook_url_37,
  t23.twitter_url AS twitter_url_38,
  t23.intro AS intro_39,
  t23.description AS description_40,
  t23.updated_at AS updated_at_41,
  t23.external_id AS external_id_42,
  t23.employed_date AS employed_date_43,
  t23.meta_title AS meta_title_44,
  t23.meta_description AS meta_description_45,
  t23.position AS position_46,
  t23.employee_picture_asset_id AS employee_picture_asset_id_47,
  t23.employee_overlay_picture_asset_id AS employee_overlay_picture_asset_id_48,
  t23.company_id AS company_id_49,
  t23.employee_backdrop_asset_id AS employee_backdrop_asset_id_50,
  t0.product_id AS product_id_51,
  t0.portfolio_id AS portfolio_id_52,
  t0.calendar_id AS calendar_id_53,
  t0.gallery_id AS gallery_id_54,
  t55.id AS id_56,
  t55.name AS name_57,
  t55.title AS title_58,
  t55.intro AS intro_59,
  t55.context AS context_60,
  t55.format AS format_61,
  t55.enabled AS enabled_62,
  t55.video_embed_id AS video_embed_id_63,
  t0.video_embed_id AS video_embed_id_64
FROM
  testimonial t0
  LEFT JOIN employee t23 ON t0.employee_id = t23.id
  LEFT JOIN gallery t55 ON t0.gallery_id = t55.id
WHERE
  t0.detail_page = ?

SELECT t0.title AS title_1, t0.employee_name AS employee_name_2, t0.company AS company_3, t0.slug AS slug_4, t0.intro AS intro_5, t0.url AS url_6, t0.url_target AS url_target_7, t0.value AS value_8, t0.picture_title AS picture_title_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.detail_page AS detail_page_12, t0.id AS id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.robots AS robots_16, t0.layout_file AS layout_file_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, t23.id AS id_24, t23.active AS active_25, t23.`default` AS default_26, t23.function AS function_27, t23.department AS department_28, t23.first_name AS first_name_29, t23.last_name AS last_name_30, t23.slug AS slug_31, t23.quote AS quote_32, t23.email AS email_33, t23.phone AS phone_34, t23.mobile AS mobile_35, t23.linkedin_url AS linkedin_url_36, t23.facebook_url AS facebook_url_37, t23.twitter_url AS twitter_url_38, t23.intro AS intro_39, t23.description AS description_40, t23.updated_at AS updated_at_41, t23.external_id AS external_id_42, t23.employed_date AS employed_date_43, t23.meta_title AS meta_title_44, t23.meta_description AS meta_description_45, t23.position AS position_46, t23.employee_picture_asset_id AS employee_picture_asset_id_47, t23.employee_overlay_picture_asset_id AS employee_overlay_picture_asset_id_48, t23.company_id AS company_id_49, t23.employee_backdrop_asset_id AS employee_backdrop_asset_id_50, t0.product_id AS product_id_51, t0.portfolio_id AS portfolio_id_52, t0.calendar_id AS calendar_id_53, t0.gallery_id AS gallery_id_54, t55.id AS id_56, t55.name AS name_57, t55.title AS title_58, t55.intro AS intro_59, t55.context AS context_60, t55.format AS format_61, t55.enabled AS enabled_62, t55.video_embed_id AS video_embed_id_63, t0.video_embed_id AS video_embed_id_64 FROM testimonial t0 LEFT JOIN employee t23 ON t0.employee_id = t23.id LEFT JOIN gallery t55 ON t0.gallery_id = t55.id WHERE t0.detail_page = 1;

SELECT
  t0.meta_title AS meta_title_1,
  t0.meta_description AS meta_description_2,
  t0.id AS id_3,
  t0.name AS name_4,
  t0.sku AS sku_5,
  t0.price AS price_6,
  t0.price_sale AS price_sale_7,
  t0.brand AS brand_8,
  t0.slug AS slug_9,
  t0.short_description AS short_description_10,
  t0.description AS description_11,
  t0.technical_options AS technical_options_12,
  t0.property_color AS property_color_13,
  t0.youtube AS youtube_14,
  t0.score AS score_15,
  t0.created AS created_16,
  t0.position AS position_17,
  t0.attachment_asset_id AS attachment_asset_id_18,
  t0.attachment_secondary_asset_id AS attachment_secondary_asset_id_19,
  t0.product_image_asset_id AS product_image_asset_id_20,
  t0.background_id AS background_id_21,
  t0.expert_image_asset_id AS expert_image_asset_id_22,
  t0.grid_id AS grid_id_23,
  t0.hero_asset_id AS hero_asset_id_24
FROM
  product t0

SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.id AS id_3, t0.name AS name_4, t0.sku AS sku_5, t0.price AS price_6, t0.price_sale AS price_sale_7, t0.brand AS brand_8, t0.slug AS slug_9, t0.short_description AS short_description_10, t0.description AS description_11, t0.technical_options AS technical_options_12, t0.property_color AS property_color_13, t0.youtube AS youtube_14, t0.score AS score_15, t0.created AS created_16, t0.position AS position_17, t0.attachment_asset_id AS attachment_asset_id_18, t0.attachment_secondary_asset_id AS attachment_secondary_asset_id_19, t0.product_image_asset_id AS product_image_asset_id_20, t0.background_id AS background_id_21, t0.expert_image_asset_id AS expert_image_asset_id_22, t0.grid_id AS grid_id_23, t0.hero_asset_id AS hero_asset_id_24 FROM product t0;

SELECT
  t0.id AS id_1,
  t0.updated AS updated_2,
  t0.date_from AS date_from_3,
  t0.date_to AS date_to_4,
  t0.deleted AS deleted_5,
  t0.title AS title_6,
  t0.status AS status_7,
  t0.slug AS slug_8,
  t0.close_registrations_at AS close_registrations_at_9,
  t0.available_registration_spots AS available_registration_spots_10,
  t0.body AS body_11,
  t0.intro AS intro_12,
  t0.requires_registrations AS requires_registrations_13,
  t0.external_registration_url AS external_registration_url_14,
  t0.external_url_strategy AS external_url_strategy_15,
  t0.external_id AS external_id_16,
  t0.external_reference AS external_reference_17,
  t0.external_hash AS external_hash_18,
  t0.meta_title AS meta_title_19,
  t0.meta_description AS meta_description_20,
  t0.location_id AS location_id_21,
  t0.owner_id AS owner_id_22,
  t0.image_id AS image_id_23,
  t0.mail_id AS mail_id_24,
  t0.og_image_id AS og_image_id_25,
  t0.video_embed_id AS video_embed_id_26
FROM
  event t0
WHERE
  (
    (t0.deleted IS NULL)
  )

SELECT t0.id AS id_1, t0.updated AS updated_2, t0.date_from AS date_from_3, t0.date_to AS date_to_4, t0.deleted AS deleted_5, t0.title AS title_6, t0.status AS status_7, t0.slug AS slug_8, t0.close_registrations_at AS close_registrations_at_9, t0.available_registration_spots AS available_registration_spots_10, t0.body AS body_11, t0.intro AS intro_12, t0.requires_registrations AS requires_registrations_13, t0.external_registration_url AS external_registration_url_14, t0.external_url_strategy AS external_url_strategy_15, t0.external_id AS external_id_16, t0.external_reference AS external_reference_17, t0.external_hash AS external_hash_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.location_id AS location_id_21, t0.owner_id AS owner_id_22, t0.image_id AS image_id_23, t0.mail_id AS mail_id_24, t0.og_image_id AS og_image_id_25, t0.video_embed_id AS video_embed_id_26 FROM event t0 WHERE ((t0.deleted IS NULL));

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

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;

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
  t0.id AS id_1,
  t0.uri AS uri_2,
  t0.variable_pattern AS variable_pattern_3,
  t0.is_permanent AS is_permanent_4,
  t0.route_target_id AS route_target_id_5
FROM
  redirect_route t0

SELECT t0.id AS id_1, t0.uri AS uri_2, t0.variable_pattern AS variable_pattern_3, t0.is_permanent AS is_permanent_4, t0.route_target_id AS route_target_id_5 FROM redirect_route t0;