Symfony Profiler

SELECT
  w0_.host AS host_0,
  w0_.schemes AS schemes_1,
  w0_.methods AS methods_2,
  w0_.defaults AS defaults_3,
  w0_.requirements AS requirements_4,
  w0_.options AS options_5,
  w0_.condition_expr AS condition_expr_6,
  w0_.variable_pattern AS variable_pattern_7,
  w0_.staticPrefix AS staticPrefix_8,
  w0_.id AS id_9,
  w0_.name AS name_10,
  w0_.position AS position_11,
  w0_.canonical_name AS canonical_name_12,
  w0_.tag AS tag_13,
  w0_.sitemapeable AS sitemapeable_14,
  w0_.type AS type_15,
  w0_.seo_meta_data AS seo_meta_data_16,
  w0_.content_class AS content_class_17,
  w0_.content_id AS content_id_18,
  w0_.redirect_target AS redirect_target_19,
  w0_.autoRoute AS autoRoute_20
FROM
  wam_routing_route w0_
WHERE
  (
    w0_.canonical_name = ?
    AND w0_.type = ?
  )
  AND w0_.autoRoute IN ('0', '1')

SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.canonical_name = 'app_routing_url_38' AND w0_.type = 'cmf_routing_auto.primary') AND w0_.autoRoute IN ('0', '1');

SELECT
  t0.reference AS reference_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.parent_id AS parent_id_5,
  t0.category_id AS category_id_6,
  t0.thumbnail_id AS thumbnail_id_7,
  t0.dtype,
  t0.mime_type AS mime_type_8,
  t0.original_format AS original_format_9
FROM
  app_media_media t0
WHERE
  t0.id = ?
  AND t0.dtype IN (
    'media', 'file', 'vimeovideo', 'youtubevideo'
  )

SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = 3730 AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo');

SELECT
  t0.title AS title_1,
  t0.menu_title AS menu_title_2,
  t0.header_title AS header_title_3,
  t0.block_title1 AS block_title1_4,
  t0.block_anchor1 AS block_anchor1_5,
  t0.block_anchor2 AS block_anchor2_6,
  t0.block_anchor3 AS block_anchor3_7,
  t0.block_anchor4 AS block_anchor4_8,
  t0.downloads_anchor AS downloads_anchor_9,
  t0.block_content1 AS block_content1_10,
  t0.block_title2 AS block_title2_11,
  t0.block_content2 AS block_content2_12,
  t0.block_title3 AS block_title3_13,
  t0.block_content3 AS block_content3_14,
  t0.block_title4 AS block_title4_15,
  t0.block_content4 AS block_content4_16,
  t0.downloadable_item AS downloadable_item_17,
  t0.cta_link_title AS cta_link_title_18,
  t0.cta_link_url AS cta_link_url_19,
  t0.cta_text AS cta_text_20,
  t0.cta_file_title1 AS cta_file_title1_21,
  t0.cta_file_title2 AS cta_file_title2_22,
  t0.cta_file_title3 AS cta_file_title3_23,
  t0.cta_file_title4 AS cta_file_title4_24,
  t0.second_cta_file_title1 AS second_cta_file_title1_25,
  t0.second_cta_file_title2 AS second_cta_file_title2_26,
  t0.second_cta_file_title3 AS second_cta_file_title3_27,
  t0.second_cta_file_title4 AS second_cta_file_title4_28,
  t0.third_cta_file_title1 AS third_cta_file_title1_29,
  t0.third_cta_file_title2 AS third_cta_file_title2_30,
  t0.third_cta_file_title3 AS third_cta_file_title3_31,
  t0.third_cta_file_title4 AS third_cta_file_title4_32,
  t0.pop_up_title1 AS pop_up_title1_33,
  t0.pop_up_title2 AS pop_up_title2_34,
  t0.pop_up_title3 AS pop_up_title3_35,
  t0.pop_up_title4 AS pop_up_title4_36,
  t0.second_pop_up_title1 AS second_pop_up_title1_37,
  t0.second_pop_up_title2 AS second_pop_up_title2_38,
  t0.second_pop_up_title3 AS second_pop_up_title3_39,
  t0.second_pop_up_title4 AS second_pop_up_title4_40,
  t0.third_pop_up_title1 AS third_pop_up_title1_41,
  t0.third_pop_up_title2 AS third_pop_up_title2_42,
  t0.third_pop_up_title3 AS third_pop_up_title3_43,
  t0.third_pop_up_title4 AS third_pop_up_title4_44,
  t0.cta_link_title1 AS cta_link_title1_45,
  t0.cta_link_title2 AS cta_link_title2_46,
  t0.cta_link_title3 AS cta_link_title3_47,
  t0.cta_link_title4 AS cta_link_title4_48,
  t0.cta_link1 AS cta_link1_49,
  t0.cta_link2 AS cta_link2_50,
  t0.cta_link3 AS cta_link3_51,
  t0.cta_link4 AS cta_link4_52,
  t0.second_cta_link_title1 AS second_cta_link_title1_53,
  t0.second_cta_link_title2 AS second_cta_link_title2_54,
  t0.second_cta_link_title3 AS second_cta_link_title3_55,
  t0.second_cta_link_title4 AS second_cta_link_title4_56,
  t0.second_cta_link1 AS second_cta_link1_57,
  t0.second_cta_link2 AS second_cta_link2_58,
  t0.second_cta_link3 AS second_cta_link3_59,
  t0.second_cta_link4 AS second_cta_link4_60,
  t0.third_cta_link_title1 AS third_cta_link_title1_61,
  t0.third_cta_link_title2 AS third_cta_link_title2_62,
  t0.third_cta_link_title3 AS third_cta_link_title3_63,
  t0.third_cta_link_title4 AS third_cta_link_title4_64,
  t0.third_cta_link1 AS third_cta_link1_65,
  t0.third_cta_link2 AS third_cta_link2_66,
  t0.third_cta_link3 AS third_cta_link3_67,
  t0.third_cta_link4 AS third_cta_link4_68,
  t0.form_title AS form_title_69,
  t0.form_intro AS form_intro_70,
  t0.form_html AS form_html_71,
  t0.locale AS locale_72,
  t0.id AS id_73,
  t0.slug AS slug_74,
  t0.cta_file1_id AS cta_file1_id_75,
  t0.cta_file2_id AS cta_file2_id_76,
  t0.cta_file3_id AS cta_file3_id_77,
  t0.cta_file4_id AS cta_file4_id_78,
  t0.second_cta_file1_id AS second_cta_file1_id_79,
  t0.second_cta_file2_id AS second_cta_file2_id_80,
  t0.second_cta_file3_id AS second_cta_file3_id_81,
  t0.second_cta_file4_id AS second_cta_file4_id_82,
  t0.third_cta_file1_id AS third_cta_file1_id_83,
  t0.third_cta_file2_id AS third_cta_file2_id_84,
  t0.third_cta_file3_id AS third_cta_file3_id_85,
  t0.third_cta_file4_id AS third_cta_file4_id_86,
  t0.translatable_id AS translatable_id_87
FROM
  app_experience_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.title AS title_1, t0.menu_title AS menu_title_2, t0.header_title AS header_title_3, t0.block_title1 AS block_title1_4, t0.block_anchor1 AS block_anchor1_5, t0.block_anchor2 AS block_anchor2_6, t0.block_anchor3 AS block_anchor3_7, t0.block_anchor4 AS block_anchor4_8, t0.downloads_anchor AS downloads_anchor_9, t0.block_content1 AS block_content1_10, t0.block_title2 AS block_title2_11, t0.block_content2 AS block_content2_12, t0.block_title3 AS block_title3_13, t0.block_content3 AS block_content3_14, t0.block_title4 AS block_title4_15, t0.block_content4 AS block_content4_16, t0.downloadable_item AS downloadable_item_17, t0.cta_link_title AS cta_link_title_18, t0.cta_link_url AS cta_link_url_19, t0.cta_text AS cta_text_20, t0.cta_file_title1 AS cta_file_title1_21, t0.cta_file_title2 AS cta_file_title2_22, t0.cta_file_title3 AS cta_file_title3_23, t0.cta_file_title4 AS cta_file_title4_24, t0.second_cta_file_title1 AS second_cta_file_title1_25, t0.second_cta_file_title2 AS second_cta_file_title2_26, t0.second_cta_file_title3 AS second_cta_file_title3_27, t0.second_cta_file_title4 AS second_cta_file_title4_28, t0.third_cta_file_title1 AS third_cta_file_title1_29, t0.third_cta_file_title2 AS third_cta_file_title2_30, t0.third_cta_file_title3 AS third_cta_file_title3_31, t0.third_cta_file_title4 AS third_cta_file_title4_32, t0.pop_up_title1 AS pop_up_title1_33, t0.pop_up_title2 AS pop_up_title2_34, t0.pop_up_title3 AS pop_up_title3_35, t0.pop_up_title4 AS pop_up_title4_36, t0.second_pop_up_title1 AS second_pop_up_title1_37, t0.second_pop_up_title2 AS second_pop_up_title2_38, t0.second_pop_up_title3 AS second_pop_up_title3_39, t0.second_pop_up_title4 AS second_pop_up_title4_40, t0.third_pop_up_title1 AS third_pop_up_title1_41, t0.third_pop_up_title2 AS third_pop_up_title2_42, t0.third_pop_up_title3 AS third_pop_up_title3_43, t0.third_pop_up_title4 AS third_pop_up_title4_44, t0.cta_link_title1 AS cta_link_title1_45, t0.cta_link_title2 AS cta_link_title2_46, t0.cta_link_title3 AS cta_link_title3_47, t0.cta_link_title4 AS cta_link_title4_48, t0.cta_link1 AS cta_link1_49, t0.cta_link2 AS cta_link2_50, t0.cta_link3 AS cta_link3_51, t0.cta_link4 AS cta_link4_52, t0.second_cta_link_title1 AS second_cta_link_title1_53, t0.second_cta_link_title2 AS second_cta_link_title2_54, t0.second_cta_link_title3 AS second_cta_link_title3_55, t0.second_cta_link_title4 AS second_cta_link_title4_56, t0.second_cta_link1 AS second_cta_link1_57, t0.second_cta_link2 AS second_cta_link2_58, t0.second_cta_link3 AS second_cta_link3_59, t0.second_cta_link4 AS second_cta_link4_60, t0.third_cta_link_title1 AS third_cta_link_title1_61, t0.third_cta_link_title2 AS third_cta_link_title2_62, t0.third_cta_link_title3 AS third_cta_link_title3_63, t0.third_cta_link_title4 AS third_cta_link_title4_64, t0.third_cta_link1 AS third_cta_link1_65, t0.third_cta_link2 AS third_cta_link2_66, t0.third_cta_link3 AS third_cta_link3_67, t0.third_cta_link4 AS third_cta_link4_68, t0.form_title AS form_title_69, t0.form_intro AS form_intro_70, t0.form_html AS form_html_71, t0.locale AS locale_72, t0.id AS id_73, t0.slug AS slug_74, t0.cta_file1_id AS cta_file1_id_75, t0.cta_file2_id AS cta_file2_id_76, t0.cta_file3_id AS cta_file3_id_77, t0.cta_file4_id AS cta_file4_id_78, t0.second_cta_file1_id AS second_cta_file1_id_79, t0.second_cta_file2_id AS second_cta_file2_id_80, t0.second_cta_file3_id AS second_cta_file3_id_81, t0.second_cta_file4_id AS second_cta_file4_id_82, t0.third_cta_file1_id AS third_cta_file1_id_83, t0.third_cta_file2_id AS third_cta_file2_id_84, t0.third_cta_file3_id AS third_cta_file3_id_85, t0.third_cta_file4_id AS third_cta_file4_id_86, t0.translatable_id AS translatable_id_87 FROM app_experience_translation t0 WHERE t0.translatable_id = 8;

SELECT
  t0.host AS host_1,
  t0.schemes AS schemes_2,
  t0.methods AS methods_3,
  t0.defaults AS defaults_4,
  t0.requirements AS requirements_5,
  t0.options AS options_6,
  t0.condition_expr AS condition_expr_7,
  t0.variable_pattern AS variable_pattern_8,
  t0.staticPrefix AS staticPrefix_9,
  t0.id AS id_10,
  t0.name AS name_11,
  t0.position AS position_12,
  t0.canonical_name AS canonical_name_13,
  t0.tag AS tag_14,
  t0.sitemapeable AS sitemapeable_15,
  t0.type AS type_16,
  t0.seo_meta_data AS seo_meta_data_17,
  t0.content_class AS content_class_18,
  t0.content_id AS content_id_19,
  t0.redirect_target AS redirect_target_20,
  t0.autoRoute
FROM
  wam_routing_route t0
WHERE
  t0.name = ?
  AND t0.autoRoute IN ('1')
LIMIT
  1

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.name = 'home' AND t0.autoRoute IN ('1') LIMIT 1;

SELECT
  t0.text AS text_1,
  t0.description AS description_2,
  t0.link AS link_3,
  t0.route_link AS route_link_4,
  t0.locale AS locale_5,
  t0.id AS id_6,
  t0.translatable_id AS translatable_id_7
FROM
  app_web_content_menu_item_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.text AS text_1, t0.description AS description_2, t0.link AS link_3, t0.route_link AS route_link_4, t0.locale AS locale_5, t0.id AS id_6, t0.translatable_id AS translatable_id_7 FROM app_web_content_menu_item_translation t0 WHERE t0.translatable_id = 34;

SELECT
  w0_.host AS host_0,
  w0_.schemes AS schemes_1,
  w0_.methods AS methods_2,
  w0_.defaults AS defaults_3,
  w0_.requirements AS requirements_4,
  w0_.options AS options_5,
  w0_.condition_expr AS condition_expr_6,
  w0_.variable_pattern AS variable_pattern_7,
  w0_.staticPrefix AS staticPrefix_8,
  w0_.id AS id_9,
  w0_.name AS name_10,
  w0_.position AS position_11,
  w0_.canonical_name AS canonical_name_12,
  w0_.tag AS tag_13,
  w0_.sitemapeable AS sitemapeable_14,
  w0_.type AS type_15,
  w0_.seo_meta_data AS seo_meta_data_16,
  w0_.content_class AS content_class_17,
  w0_.content_id AS content_id_18,
  w0_.redirect_target AS redirect_target_19,
  w0_.autoRoute AS autoRoute_20
FROM
  wam_routing_route w0_
WHERE
  (
    w0_.content_class = 'App\\Entity\\Routing\\Url'
    AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":38}')
    AND REPLACE(
      JSON_EXTRACT(w0_.content_id, '$'),
      ' ',
      ''
    ) LIKE '{\"id\":38}'
  )
  AND w0_.autoRoute IN ('1')
ORDER BY
  w0_.position ASC

SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.content_class = 'App\\Entity\\Routing\\Url' AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":38}') AND REPLACE(JSON_EXTRACT(w0_.content_id, '$'),' ','') LIKE '{\"id\":38}') AND w0_.autoRoute IN ('1') ORDER BY w0_.position ASC;

SELECT
  t0.locale AS locale_1,
  t0.id AS id_2,
  t0.translatable_id AS translatable_id_3,
  t0.dtype,
  t0.simple_text AS simple_text_4,
  t0.simple_text AS simple_text_5,
  t0.simple_text2 AS simple_text2_6,
  t0.simple_text3 AS simple_text3_7,
  t0.simple_text4 AS simple_text4_8,
  t0.content AS content_9,
  t0.subtitle AS subtitle_10,
  t0.simple_text AS simple_text_11,
  t0.code AS code_12,
  t0.custom_html AS custom_html_13,
  t0.button_title AS button_title_14,
  t0.button_link AS button_link_15,
  t0.subtitle AS subtitle_16,
  t0.external_link AS external_link_17,
  t0.document_title AS document_title_18,
  t0.graph_titles AS graph_titles_19,
  t0.subtitle AS subtitle_20,
  t0.simple_text AS simple_text_21,
  t0.youtube_video AS youtube_video_22,
  t0.youtube_background_video AS youtube_background_video_23,
  t0.youtube_background_poster_id AS youtube_background_poster_id_24,
  t0.label AS label_25,
  t0.video_url AS video_url_26,
  t0.video_url AS video_url_27,
  t0.description AS description_28,
  t0.price AS price_29,
  t0.image_id AS image_id_30
FROM
  wam_block_block_translation t0
WHERE
  t0.translatable_id = ?
  AND t0.dtype IN (
    'simpleTextBlockTranslation', 'multiple4SimpleTextBlockTranslation',
    'richTextBlockTranslation', 'completeTextBlockTranslation',
    'completeTextImageBlockTranslation',
    'galleryBlockTranslation', 'menuBlockTranslation',
    'bannerBlockTranslation', 'socialBlockTranslation',
    'hubspotFormBlockTranslation',
    'headerBlockTranslation', 'customHtmlBlockTranslation',
    'collectionBlockTranslation', 'keySellingPointBlockTranslation',
    'ctaBlockTranslation', 'mapBlockTranslation',
    'imageBlockTranslation', 'documentBlockTranslation',
    'graphBlockTranslation', 'advancedHeaderBlockTranslation',
    'containerBlockTranslation', 'customFormBlockTranslation',
    'linkBlockTranslation', 'breadcrumbBlockTranslation',
    'pardotFormBlockTranslation', 'embedBlockTranslation',
    'imageTextBlockTranslation', 'svgBlockTranslation',
    'doubleImageBlockTranslation',
    'headerWithVideoBlockTranslation',
    'headerWithVideoOnTopBlockTranslation',
    'ctaWithDescriptionAndPriceBlockTranslation',
    'ctaWithGalleryBlockTranslation',
    'containerExperiencesBlockTranslation',
    'completeTextWithTranslatableImageBlockTranslation',
    'downloadableBlockTranslation'
  )

SELECT t0.locale AS locale_1, t0.id AS id_2, t0.translatable_id AS translatable_id_3, t0.dtype, t0.simple_text AS simple_text_4, t0.simple_text AS simple_text_5, t0.simple_text2 AS simple_text2_6, t0.simple_text3 AS simple_text3_7, t0.simple_text4 AS simple_text4_8, t0.content AS content_9, t0.subtitle AS subtitle_10, t0.simple_text AS simple_text_11, t0.code AS code_12, t0.custom_html AS custom_html_13, t0.button_title AS button_title_14, t0.button_link AS button_link_15, t0.subtitle AS subtitle_16, t0.external_link AS external_link_17, t0.document_title AS document_title_18, t0.graph_titles AS graph_titles_19, t0.subtitle AS subtitle_20, t0.simple_text AS simple_text_21, t0.youtube_video AS youtube_video_22, t0.youtube_background_video AS youtube_background_video_23, t0.youtube_background_poster_id AS youtube_background_poster_id_24, t0.label AS label_25, t0.video_url AS video_url_26, t0.video_url AS video_url_27, t0.description AS description_28, t0.price AS price_29, t0.image_id AS image_id_30 FROM wam_block_block_translation t0 WHERE t0.translatable_id = 271 AND t0.dtype IN ('simpleTextBlockTranslation', 'multiple4SimpleTextBlockTranslation', 'richTextBlockTranslation', 'completeTextBlockTranslation', 'completeTextImageBlockTranslation', 'galleryBlockTranslation', 'menuBlockTranslation', 'bannerBlockTranslation', 'socialBlockTranslation', 'hubspotFormBlockTranslation', 'headerBlockTranslation', 'customHtmlBlockTranslation', 'collectionBlockTranslation', 'keySellingPointBlockTranslation', 'ctaBlockTranslation', 'mapBlockTranslation', 'imageBlockTranslation', 'documentBlockTranslation', 'graphBlockTranslation', 'advancedHeaderBlockTranslation', 'containerBlockTranslation', 'customFormBlockTranslation', 'linkBlockTranslation', 'breadcrumbBlockTranslation', 'pardotFormBlockTranslation', 'embedBlockTranslation', 'imageTextBlockTranslation', 'svgBlockTranslation', 'doubleImageBlockTranslation', 'headerWithVideoBlockTranslation', 'headerWithVideoOnTopBlockTranslation', 'ctaWithDescriptionAndPriceBlockTranslation', 'ctaWithGalleryBlockTranslation', 'containerExperiencesBlockTranslation', 'completeTextWithTranslatableImageBlockTranslation', 'downloadableBlockTranslation');

SELECT
  t0.title AS title_1,
  t0.description AS description_2,
  t0.locale AS locale_3,
  t0.id AS id_4,
  t0.translatable_id AS translatable_id_5,
  t0.dtype,
  t0.alt AS alt_6
FROM
  app_media_media_translation t0
WHERE
  t0.translatable_id = ?
  AND t0.dtype IN (
    'mediatranslation', 'vimeovideotranslation',
    'filetranslation', 'youtubevideotranslation'
  )

SELECT t0.title AS title_1, t0.description AS description_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5, t0.dtype, t0.alt AS alt_6 FROM app_media_media_translation t0 WHERE t0.translatable_id = 8043 AND t0.dtype IN ('mediatranslation', 'vimeovideotranslation', 'filetranslation', 'youtubevideotranslation');

SELECT
  w0_.host AS host_0,
  w0_.schemes AS schemes_1,
  w0_.methods AS methods_2,
  w0_.defaults AS defaults_3,
  w0_.requirements AS requirements_4,
  w0_.options AS options_5,
  w0_.condition_expr AS condition_expr_6,
  w0_.variable_pattern AS variable_pattern_7,
  w0_.staticPrefix AS staticPrefix_8,
  w0_.id AS id_9,
  w0_.name AS name_10,
  w0_.position AS position_11,
  w0_.canonical_name AS canonical_name_12,
  w0_.tag AS tag_13,
  w0_.sitemapeable AS sitemapeable_14,
  w0_.type AS type_15,
  w0_.seo_meta_data AS seo_meta_data_16,
  w0_.content_class AS content_class_17,
  w0_.content_id AS content_id_18,
  w0_.redirect_target AS redirect_target_19,
  w0_.autoRoute AS autoRoute_20
FROM
  wam_routing_route w0_
WHERE
  (
    w0_.content_class = 'App\\Entity\\Routing\\Url'
    AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":1}')
    AND REPLACE(
      JSON_EXTRACT(w0_.content_id, '$'),
      ' ',
      ''
    ) LIKE '{\"id\":1}'
  )
  AND w0_.autoRoute IN ('1')
ORDER BY
  w0_.position ASC

SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.content_class = 'App\\Entity\\Routing\\Url' AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":1}') AND REPLACE(JSON_EXTRACT(w0_.content_id, '$'),' ','') LIKE '{\"id\":1}') AND w0_.autoRoute IN ('1') ORDER BY w0_.position ASC;

SELECT
  w0_.host AS host_0,
  w0_.schemes AS schemes_1,
  w0_.methods AS methods_2,
  w0_.defaults AS defaults_3,
  w0_.requirements AS requirements_4,
  w0_.options AS options_5,
  w0_.condition_expr AS condition_expr_6,
  w0_.variable_pattern AS variable_pattern_7,
  w0_.staticPrefix AS staticPrefix_8,
  w0_.id AS id_9,
  w0_.name AS name_10,
  w0_.position AS position_11,
  w0_.canonical_name AS canonical_name_12,
  w0_.tag AS tag_13,
  w0_.sitemapeable AS sitemapeable_14,
  w0_.type AS type_15,
  w0_.seo_meta_data AS seo_meta_data_16,
  w0_.content_class AS content_class_17,
  w0_.content_id AS content_id_18,
  w0_.redirect_target AS redirect_target_19,
  w0_.autoRoute AS autoRoute_20
FROM
  wam_routing_route w0_
WHERE
  (
    w0_.content_class = 'App\\Entity\\Experience'
    AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":1}')
    AND REPLACE(
      JSON_EXTRACT(w0_.content_id, '$'),
      ' ',
      ''
    ) LIKE '{\"id\":1}'
  )
  AND w0_.autoRoute IN ('1')
ORDER BY
  w0_.position ASC

SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.content_class = 'App\\Entity\\Experience' AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":1}') AND REPLACE(JSON_EXTRACT(w0_.content_id, '$'),' ','') LIKE '{\"id\":1}') AND w0_.autoRoute IN ('1') ORDER BY w0_.position ASC;

SELECT
  w0_.host AS host_0,
  w0_.schemes AS schemes_1,
  w0_.methods AS methods_2,
  w0_.defaults AS defaults_3,
  w0_.requirements AS requirements_4,
  w0_.options AS options_5,
  w0_.condition_expr AS condition_expr_6,
  w0_.variable_pattern AS variable_pattern_7,
  w0_.staticPrefix AS staticPrefix_8,
  w0_.id AS id_9,
  w0_.name AS name_10,
  w0_.position AS position_11,
  w0_.canonical_name AS canonical_name_12,
  w0_.tag AS tag_13,
  w0_.sitemapeable AS sitemapeable_14,
  w0_.type AS type_15,
  w0_.seo_meta_data AS seo_meta_data_16,
  w0_.content_class AS content_class_17,
  w0_.content_id AS content_id_18,
  w0_.redirect_target AS redirect_target_19,
  w0_.autoRoute AS autoRoute_20
FROM
  wam_routing_route w0_
WHERE
  (
    w0_.content_class = 'App\\Entity\\Experience'
    AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":19}')
    AND REPLACE(
      JSON_EXTRACT(w0_.content_id, '$'),
      ' ',
      ''
    ) LIKE '{\"id\":19}'
  )
  AND w0_.autoRoute IN ('1')
ORDER BY
  w0_.position ASC

SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.content_class = 'App\\Entity\\Experience' AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":19}') AND REPLACE(JSON_EXTRACT(w0_.content_id, '$'),' ','') LIKE '{\"id\":19}') AND w0_.autoRoute IN ('1') ORDER BY w0_.position ASC;

SELECT
  w0_.host AS host_0,
  w0_.schemes AS schemes_1,
  w0_.methods AS methods_2,
  w0_.defaults AS defaults_3,
  w0_.requirements AS requirements_4,
  w0_.options AS options_5,
  w0_.condition_expr AS condition_expr_6,
  w0_.variable_pattern AS variable_pattern_7,
  w0_.staticPrefix AS staticPrefix_8,
  w0_.id AS id_9,
  w0_.name AS name_10,
  w0_.position AS position_11,
  w0_.canonical_name AS canonical_name_12,
  w0_.tag AS tag_13,
  w0_.sitemapeable AS sitemapeable_14,
  w0_.type AS type_15,
  w0_.seo_meta_data AS seo_meta_data_16,
  w0_.content_class AS content_class_17,
  w0_.content_id AS content_id_18,
  w0_.redirect_target AS redirect_target_19,
  w0_.autoRoute AS autoRoute_20
FROM
  wam_routing_route w0_
WHERE
  (
    w0_.content_class = 'App\\Entity\\Experience'
    AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":18}')
    AND REPLACE(
      JSON_EXTRACT(w0_.content_id, '$'),
      ' ',
      ''
    ) LIKE '{\"id\":18}'
  )
  AND w0_.autoRoute IN ('1')
ORDER BY
  w0_.position ASC

SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.content_class = 'App\\Entity\\Experience' AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":18}') AND REPLACE(JSON_EXTRACT(w0_.content_id, '$'),' ','') LIKE '{\"id\":18}') AND w0_.autoRoute IN ('1') ORDER BY w0_.position ASC;

SELECT
  a0_.name AS name_0,
  a0_.open_new_window AS open_new_window_1,
  a0_.enabled AS enabled_2,
  a0_.no_follow AS no_follow_3,
  a0_.menu AS menu_4,
  a0_.route AS route_5,
  a0_.is_separated AS is_separated_6,
  a0_.icon_class AS icon_class_7,
  a0_.id AS id_8,
  a0_.position AS position_9,
  a0_.date_start AS date_start_10,
  a0_.date_end AS date_end_11,
  a0_.status AS status_12,
  a0_.parent_id AS parent_id_13,
  a0_.image_id AS image_id_14
FROM
  app_web_content_menu_item a0_
WHERE
  a0_.status = ?
  AND a0_.date_start <= ?
  AND (
    (
      a0_.date_end > ?
      OR a0_.date_end IS NULL
    )
  )
  AND a0_.parent_id IS NULL
  AND a0_.menu = ?
  AND a0_.enabled = 1
ORDER BY
  a0_.position ASC

SELECT a0_.name AS name_0, a0_.open_new_window AS open_new_window_1, a0_.enabled AS enabled_2, a0_.no_follow AS no_follow_3, a0_.menu AS menu_4, a0_.route AS route_5, a0_.is_separated AS is_separated_6, a0_.icon_class AS icon_class_7, a0_.id AS id_8, a0_.position AS position_9, a0_.date_start AS date_start_10, a0_.date_end AS date_end_11, a0_.status AS status_12, a0_.parent_id AS parent_id_13, a0_.image_id AS image_id_14 FROM app_web_content_menu_item a0_ WHERE a0_.status = 'PUBLISHED' AND a0_.date_start <= '2024-09-21 12:48:04' AND ((a0_.date_end > '2024-09-21 12:48:04' OR a0_.date_end IS NULL)) AND a0_.parent_id IS NULL AND a0_.menu = 'TOP' AND a0_.enabled = 1 ORDER BY a0_.position ASC;

SELECT
  w0_.host AS host_0,
  w0_.schemes AS schemes_1,
  w0_.methods AS methods_2,
  w0_.defaults AS defaults_3,
  w0_.requirements AS requirements_4,
  w0_.options AS options_5,
  w0_.condition_expr AS condition_expr_6,
  w0_.variable_pattern AS variable_pattern_7,
  w0_.staticPrefix AS staticPrefix_8,
  w0_.id AS id_9,
  w0_.name AS name_10,
  w0_.position AS position_11,
  w0_.canonical_name AS canonical_name_12,
  w0_.tag AS tag_13,
  w0_.sitemapeable AS sitemapeable_14,
  w0_.type AS type_15,
  w0_.seo_meta_data AS seo_meta_data_16,
  w0_.content_class AS content_class_17,
  w0_.content_id AS content_id_18,
  w0_.redirect_target AS redirect_target_19,
  w0_.autoRoute AS autoRoute_20
FROM
  wam_routing_route w0_
WHERE
  (
    w0_.content_class = 'App\\Entity\\Experience'
    AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":15}')
    AND REPLACE(
      JSON_EXTRACT(w0_.content_id, '$'),
      ' ',
      ''
    ) LIKE '{\"id\":15}'
  )
  AND w0_.autoRoute IN ('1')
ORDER BY
  w0_.position ASC

SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.content_class = 'App\\Entity\\Experience' AND JSON_LENGTH(w0_.content_id) = JSON_LENGTH('{\"id\":15}') AND REPLACE(JSON_EXTRACT(w0_.content_id, '$'),' ','') LIKE '{\"id\":15}') AND w0_.autoRoute IN ('1') ORDER BY w0_.position ASC;