Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.menu AS menu_1,
  m0_.locale AS locale_2,
  m0_.title AS title_3,
  m0_.type AS type_4,
  m0_.url AS url_5,
  m0_.hint AS hint_6,
  m0_.button AS button_7,
  m0_.position AS position_8,
  m0_.published AS published_9,
  m0_.open_in_new_tab AS open_in_new_tab_10,
  m0_.source_id AS source_id_11,
  m1_.id AS id_12,
  m1_.menu AS menu_13,
  m1_.locale AS locale_14,
  m1_.title AS title_15,
  m1_.type AS type_16,
  m1_.url AS url_17,
  m1_.hint AS hint_18,
  m1_.button AS button_19,
  m1_.position AS position_20,
  m1_.published AS published_21,
  m1_.open_in_new_tab AS open_in_new_tab_22,
  m1_.source_id AS source_id_23,
  m2_.id AS id_24,
  m2_.menu AS menu_25,
  m2_.locale AS locale_26,
  m2_.title AS title_27,
  m2_.type AS type_28,
  m2_.url AS url_29,
  m2_.hint AS hint_30,
  m2_.button AS button_31,
  m2_.position AS position_32,
  m2_.published AS published_33,
  m2_.open_in_new_tab AS open_in_new_tab_34,
  m2_.source_id AS source_id_35,
  a3_.id AS id_36,
  a3_.title AS title_37,
  a3_.slug AS slug_38,
  a3_.locale AS locale_39,
  a3_.translation_group AS translation_group_40,
  a3_.excerpt AS excerpt_41,
  a3_.content AS content_42,
  a3_.status AS status_43,
  a3_.meta_title AS meta_title_44,
  a3_.meta_description AS meta_description_45,
  a3_.position AS position_46,
  a3_.show_contact_form AS show_contact_form_47,
  a3_.source_id AS source_id_48,
  a3_.source_type AS source_type_49,
  a3_.published_at AS published_at_50,
  a3_.created_at AS created_at_51,
  a3_.updated_at AS updated_at_52,
  a4_.id AS id_53,
  a4_.title AS title_54,
  a4_.slug AS slug_55,
  a4_.locale AS locale_56,
  a4_.translation_group AS translation_group_57,
  a4_.excerpt AS excerpt_58,
  a4_.content AS content_59,
  a4_.status AS status_60,
  a4_.meta_title AS meta_title_61,
  a4_.meta_description AS meta_description_62,
  a4_.position AS position_63,
  a4_.show_contact_form AS show_contact_form_64,
  a4_.source_id AS source_id_65,
  a4_.source_type AS source_type_66,
  a4_.published_at AS published_at_67,
  a4_.created_at AS created_at_68,
  a4_.updated_at AS updated_at_69,
  a5_.id AS id_70,
  a5_.title AS title_71,
  a5_.slug AS slug_72,
  a5_.locale AS locale_73,
  a5_.translation_group AS translation_group_74,
  a5_.excerpt AS excerpt_75,
  a5_.content AS content_76,
  a5_.status AS status_77,
  a5_.meta_title AS meta_title_78,
  a5_.meta_description AS meta_description_79,
  a5_.position AS position_80,
  a5_.show_contact_form AS show_contact_form_81,
  a5_.source_id AS source_id_82,
  a5_.source_type AS source_type_83,
  a5_.published_at AS published_at_84,
  a5_.created_at AS created_at_85,
  a5_.updated_at AS updated_at_86,
  m0_.article_id AS article_id_87,
  m0_.parent_id AS parent_id_88,
  m1_.article_id AS article_id_89,
  m1_.parent_id AS parent_id_90,
  m2_.article_id AS article_id_91,
  m2_.parent_id AS parent_id_92,
  a3_.category_id AS category_id_93,
  a3_.featured_image_id AS featured_image_id_94,
  a4_.category_id AS category_id_95,
  a4_.featured_image_id AS featured_image_id_96,
  a5_.category_id AS category_id_97,
  a5_.featured_image_id AS featured_image_id_98
FROM
  menu_item m0_
  LEFT JOIN menu_item m1_ ON m0_.id = m1_.parent_id
  LEFT JOIN menu_item m2_ ON m1_.id = m2_.parent_id
  LEFT JOIN article a3_ ON m0_.article_id = a3_.id
  LEFT JOIN article a4_ ON m1_.article_id = a4_.id
  LEFT JOIN article a5_ ON m2_.article_id = a5_.id
WHERE
  m0_.menu = ?
  AND m0_.locale = ?
  AND m0_.parent_id IS NULL
  AND m0_.published = 1
ORDER BY
  m0_.position ASC,
  m1_.position ASC,
  m2_.position ASC

SELECT m0_.id AS id_0, m0_.menu AS menu_1, m0_.locale AS locale_2, m0_.title AS title_3, m0_.type AS type_4, m0_.url AS url_5, m0_.hint AS hint_6, m0_.button AS button_7, m0_.position AS position_8, m0_.published AS published_9, m0_.open_in_new_tab AS open_in_new_tab_10, m0_.source_id AS source_id_11, m1_.id AS id_12, m1_.menu AS menu_13, m1_.locale AS locale_14, m1_.title AS title_15, m1_.type AS type_16, m1_.url AS url_17, m1_.hint AS hint_18, m1_.button AS button_19, m1_.position AS position_20, m1_.published AS published_21, m1_.open_in_new_tab AS open_in_new_tab_22, m1_.source_id AS source_id_23, m2_.id AS id_24, m2_.menu AS menu_25, m2_.locale AS locale_26, m2_.title AS title_27, m2_.type AS type_28, m2_.url AS url_29, m2_.hint AS hint_30, m2_.button AS button_31, m2_.position AS position_32, m2_.published AS published_33, m2_.open_in_new_tab AS open_in_new_tab_34, m2_.source_id AS source_id_35, a3_.id AS id_36, a3_.title AS title_37, a3_.slug AS slug_38, a3_.locale AS locale_39, a3_.translation_group AS translation_group_40, a3_.excerpt AS excerpt_41, a3_.content AS content_42, a3_.status AS status_43, a3_.meta_title AS meta_title_44, a3_.meta_description AS meta_description_45, a3_.position AS position_46, a3_.show_contact_form AS show_contact_form_47, a3_.source_id AS source_id_48, a3_.source_type AS source_type_49, a3_.published_at AS published_at_50, a3_.created_at AS created_at_51, a3_.updated_at AS updated_at_52, a4_.id AS id_53, a4_.title AS title_54, a4_.slug AS slug_55, a4_.locale AS locale_56, a4_.translation_group AS translation_group_57, a4_.excerpt AS excerpt_58, a4_.content AS content_59, a4_.status AS status_60, a4_.meta_title AS meta_title_61, a4_.meta_description AS meta_description_62, a4_.position AS position_63, a4_.show_contact_form AS show_contact_form_64, a4_.source_id AS source_id_65, a4_.source_type AS source_type_66, a4_.published_at AS published_at_67, a4_.created_at AS created_at_68, a4_.updated_at AS updated_at_69, a5_.id AS id_70, a5_.title AS title_71, a5_.slug AS slug_72, a5_.locale AS locale_73, a5_.translation_group AS translation_group_74, a5_.excerpt AS excerpt_75, a5_.content AS content_76, a5_.status AS status_77, a5_.meta_title AS meta_title_78, a5_.meta_description AS meta_description_79, a5_.position AS position_80, a5_.show_contact_form AS show_contact_form_81, a5_.source_id AS source_id_82, a5_.source_type AS source_type_83, a5_.published_at AS published_at_84, a5_.created_at AS created_at_85, a5_.updated_at AS updated_at_86, m0_.article_id AS article_id_87, m0_.parent_id AS parent_id_88, m1_.article_id AS article_id_89, m1_.parent_id AS parent_id_90, m2_.article_id AS article_id_91, m2_.parent_id AS parent_id_92, a3_.category_id AS category_id_93, a3_.featured_image_id AS featured_image_id_94, a4_.category_id AS category_id_95, a4_.featured_image_id AS featured_image_id_96, a5_.category_id AS category_id_97, a5_.featured_image_id AS featured_image_id_98 FROM menu_item m0_ LEFT JOIN menu_item m1_ ON m0_.id = m1_.parent_id LEFT JOIN menu_item m2_ ON m1_.id = m2_.parent_id LEFT JOIN article a3_ ON m0_.article_id = a3_.id LEFT JOIN article a4_ ON m1_.article_id = a4_.id LEFT JOIN article a5_ ON m2_.article_id = a5_.id WHERE m0_.menu = 'main' AND m0_.locale = 'pl' AND m0_.parent_id IS NULL AND m0_.published = 1 ORDER BY m0_.position ASC, m1_.position ASC, m2_.position ASC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.meta AS meta_2,
  a0_.description AS description_3,
  a0_.price_from AS price_from_4,
  a0_.link_label AS link_label_5,
  a0_.url AS url_6,
  a0_.featured AS featured_7,
  a0_.position AS position_8,
  a0_.published AS published_9,
  m1_.id AS id_10,
  m1_.path AS path_11,
  m1_.filename AS filename_12,
  m1_.title AS title_13,
  m1_.alt AS alt_14,
  m1_.caption AS caption_15,
  m1_.width AS width_16,
  m1_.height AS height_17,
  m1_.filesize AS filesize_18,
  m1_.mime_type AS mime_type_19,
  m1_.file_exists AS file_exists_20,
  m1_.source AS source_21,
  m1_.created_at AS created_at_22,
  a0_.article_id AS article_id_23,
  a0_.image_id AS image_id_24
FROM
  accommodation a0_
  LEFT JOIN media m1_ ON a0_.image_id = m1_.id
WHERE
  a0_.published = 1
  AND a0_.featured = 1
ORDER BY
  a0_.position ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.meta AS meta_2, a0_.description AS description_3, a0_.price_from AS price_from_4, a0_.link_label AS link_label_5, a0_.url AS url_6, a0_.featured AS featured_7, a0_.position AS position_8, a0_.published AS published_9, m1_.id AS id_10, m1_.path AS path_11, m1_.filename AS filename_12, m1_.title AS title_13, m1_.alt AS alt_14, m1_.caption AS caption_15, m1_.width AS width_16, m1_.height AS height_17, m1_.filesize AS filesize_18, m1_.mime_type AS mime_type_19, m1_.file_exists AS file_exists_20, m1_.source AS source_21, m1_.created_at AS created_at_22, a0_.article_id AS article_id_23, a0_.image_id AS image_id_24 FROM accommodation a0_ LEFT JOIN media m1_ ON a0_.image_id = m1_.id WHERE a0_.published = 1 AND a0_.featured = 1 ORDER BY a0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.filename AS filename_3,
  t0.title AS title_4,
  t0.alt AS alt_5,
  t0.caption AS caption_6,
  t0.width AS width_7,
  t0.height AS height_8,
  t0.filesize AS filesize_9,
  t0.mime_type AS mime_type_10,
  t0.file_exists AS file_exists_11,
  t0.source AS source_12,
  t0.created_at AS created_at_13
FROM
  media t0
  INNER JOIN article_media ON t0.id = article_media.media_id
WHERE
  article_media.article_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.path AS path_2, t0.filename AS filename_3, t0.title AS title_4, t0.alt AS alt_5, t0.caption AS caption_6, t0.width AS width_7, t0.height AS height_8, t0.filesize AS filesize_9, t0.mime_type AS mime_type_10, t0.file_exists AS file_exists_11, t0.source AS source_12, t0.created_at AS created_at_13 FROM media t0 INNER JOIN article_media ON t0.id = article_media.media_id WHERE article_media.article_id = 432 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.brand_name AS brand_name_2,
  t0.brand_tagline AS brand_tagline_3,
  t0.reception_hours AS reception_hours_4,
  t0.phone AS phone_5,
  t0.address AS address_6,
  t0.email AS email_7,
  t0.coordinates AS coordinates_8,
  t0.booking_url AS booking_url_9,
  t0.booking_label AS booking_label_10,
  t0.footer_hours AS footer_hours_11,
  t0.copyright AS copyright_12,
  t0.meta_title AS meta_title_13,
  t0.meta_description AS meta_description_14
FROM
  site_settings t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_tagline AS brand_tagline_3, t0.reception_hours AS reception_hours_4, t0.phone AS phone_5, t0.address AS address_6, t0.email AS email_7, t0.coordinates AS coordinates_8, t0.booking_url AS booking_url_9, t0.booking_label AS booking_label_10, t0.footer_hours AS footer_hours_11, t0.copyright AS copyright_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14 FROM site_settings t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.duration AS duration_2,
  r0_.copy_label AS copy_label_3,
  r0_.copy_value AS copy_value_4,
  r0_.note AS note_5,
  r0_.position AS position_6,
  r0_.published AS published_7,
  r1_.id AS id_8,
  r1_.shield AS shield_9,
  r1_.shield_type AS shield_type_10,
  r1_.title AS title_11,
  r1_.description AS description_12,
  r1_.distance AS distance_13,
  r1_.position AS position_14,
  r2_.id AS id_15,
  r2_.label AS label_16,
  r2_.value AS value_17,
  r2_.position AS position_18,
  r1_.variant_id AS variant_id_19,
  r2_.variant_id AS variant_id_20
FROM
  route_variant r0_
  LEFT JOIN route_leg r1_ ON r0_.id = r1_.variant_id
  LEFT JOIN route_fact r2_ ON r0_.id = r2_.variant_id
WHERE
  r0_.published = 1
ORDER BY
  r0_.position ASC,
  r1_.position ASC,
  r2_.position ASC

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.duration AS duration_2, r0_.copy_label AS copy_label_3, r0_.copy_value AS copy_value_4, r0_.note AS note_5, r0_.position AS position_6, r0_.published AS published_7, r1_.id AS id_8, r1_.shield AS shield_9, r1_.shield_type AS shield_type_10, r1_.title AS title_11, r1_.description AS description_12, r1_.distance AS distance_13, r1_.position AS position_14, r2_.id AS id_15, r2_.label AS label_16, r2_.value AS value_17, r2_.position AS position_18, r1_.variant_id AS variant_id_19, r2_.variant_id AS variant_id_20 FROM route_variant r0_ LEFT JOIN route_leg r1_ ON r0_.id = r1_.variant_id LEFT JOIN route_fact r2_ ON r0_.id = r2_.variant_id WHERE r0_.published = 1 ORDER BY r0_.position ASC, r1_.position ASC, r2_.position ASC;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.label AS label_3,
  t0.position AS position_4,
  t0.home_page_id AS home_page_id_5
FROM
  home_fact t0
WHERE
  t0.home_page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.value AS value_2, t0.label AS label_3, t0.position AS position_4, t0.home_page_id AS home_page_id_5 FROM home_fact t0 WHERE t0.home_page_id = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.eyebrow AS eyebrow_2,
  t0.heading AS heading_3,
  t0.lead AS lead_4,
  t0.primary_button_label AS primary_button_label_5,
  t0.primary_button_url AS primary_button_url_6,
  t0.secondary_button_label AS secondary_button_label_7,
  t0.secondary_button_url AS secondary_button_url_8,
  t0.route_eyebrow AS route_eyebrow_9,
  t0.route_title AS route_title_10,
  t0.route_intro AS route_intro_11,
  t0.gallery_eyebrow AS gallery_eyebrow_12,
  t0.gallery_title AS gallery_title_13,
  t0.stay_eyebrow AS stay_eyebrow_14,
  t0.stay_title AS stay_title_15,
  t0.image_id AS image_id_16,
  t0.inset_image_id AS inset_image_id_17,
  t0.gallery_article_id AS gallery_article_id_18
FROM
  home_page t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.eyebrow AS eyebrow_2, t0.heading AS heading_3, t0.lead AS lead_4, t0.primary_button_label AS primary_button_label_5, t0.primary_button_url AS primary_button_url_6, t0.secondary_button_label AS secondary_button_label_7, t0.secondary_button_url AS secondary_button_url_8, t0.route_eyebrow AS route_eyebrow_9, t0.route_title AS route_title_10, t0.route_intro AS route_intro_11, t0.gallery_eyebrow AS gallery_eyebrow_12, t0.gallery_title AS gallery_title_13, t0.stay_eyebrow AS stay_eyebrow_14, t0.stay_title AS stay_title_15, t0.image_id AS image_id_16, t0.inset_image_id AS inset_image_id_17, t0.gallery_article_id AS gallery_article_id_18 FROM home_page t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  g0_.id AS id_0,
  g0_.caption AS caption_1,
  g0_.crop AS crop_2,
  g0_.position AS position_3,
  g0_.published AS published_4,
  m1_.id AS id_5,
  m1_.path AS path_6,
  m1_.filename AS filename_7,
  m1_.title AS title_8,
  m1_.alt AS alt_9,
  m1_.caption AS caption_10,
  m1_.width AS width_11,
  m1_.height AS height_12,
  m1_.filesize AS filesize_13,
  m1_.mime_type AS mime_type_14,
  m1_.file_exists AS file_exists_15,
  m1_.source AS source_16,
  m1_.created_at AS created_at_17,
  g0_.media_id AS media_id_18
FROM
  gallery_item g0_
  LEFT JOIN media m1_ ON g0_.media_id = m1_.id
WHERE
  g0_.published = 1
ORDER BY
  g0_.position ASC

SELECT g0_.id AS id_0, g0_.caption AS caption_1, g0_.crop AS crop_2, g0_.position AS position_3, g0_.published AS published_4, m1_.id AS id_5, m1_.path AS path_6, m1_.filename AS filename_7, m1_.title AS title_8, m1_.alt AS alt_9, m1_.caption AS caption_10, m1_.width AS width_11, m1_.height AS height_12, m1_.filesize AS filesize_13, m1_.mime_type AS mime_type_14, m1_.file_exists AS file_exists_15, m1_.source AS source_16, m1_.created_at AS created_at_17, g0_.media_id AS media_id_18 FROM gallery_item g0_ LEFT JOIN media m1_ ON g0_.media_id = m1_.id WHERE g0_.published = 1 ORDER BY g0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.filename AS filename_3,
  t0.title AS title_4,
  t0.alt AS alt_5,
  t0.caption AS caption_6,
  t0.width AS width_7,
  t0.height AS height_8,
  t0.filesize AS filesize_9,
  t0.mime_type AS mime_type_10,
  t0.file_exists AS file_exists_11,
  t0.source AS source_12,
  t0.created_at AS created_at_13
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.filename AS filename_3, t0.title AS title_4, t0.alt AS alt_5, t0.caption AS caption_6, t0.width AS width_7, t0.height AS height_8, t0.filesize AS filesize_9, t0.mime_type AS mime_type_10, t0.file_exists AS file_exists_11, t0.source AS source_12, t0.created_at AS created_at_13 FROM media t0 WHERE t0.id = 10390;