Symfony Profiler

SELECT
  t0.name AS name_1,
  t0.short_description AS short_description_2,
  t0.description AS description_3,
  t0.slug AS slug_4,
  t0.meta_title AS meta_title_5,
  t0.meta_canonical AS meta_canonical_6,
  t0.meta_keywords AS meta_keywords_7,
  t0.meta_description AS meta_description_8,
  t0.meta_robots AS meta_robots_9,
  t0.meta_ogTitle AS meta_ogTitle_10,
  t0.meta_ogDescription AS meta_ogDescription_11,
  t0.meta_ogImageAlt AS meta_ogImageAlt_12,
  t0.meta_ogImage AS meta_ogImage_13,
  t0.meta_twitterCard AS meta_twitterCard_14,
  t0.meta_twitterDescription AS meta_twitterDescription_15,
  t0.meta_twitterTitle AS meta_twitterTitle_16,
  t0.meta_twitterImage AS meta_twitterImage_17,
  t0.meta_twitterImageAlt AS meta_twitterImageAlt_18,
  t0.locale AS locale_19,
  t0.id AS id_20,
  t0.header1 AS header1_21,
  t0.banner_title AS banner_title_22,
  t0.banner_url AS banner_url_23,
  t0.route_id AS route_id_24,
  t0.translatable_id AS translatable_id_25
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?
  AND (
    (t0.locale = 'pl')
  )

SELECT t0.name AS name_1, t0.short_description AS short_description_2, t0.description AS description_3, t0.slug AS slug_4, t0.meta_title AS meta_title_5, t0.meta_canonical AS meta_canonical_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.meta_robots AS meta_robots_9, t0.meta_ogTitle AS meta_ogTitle_10, t0.meta_ogDescription AS meta_ogDescription_11, t0.meta_ogImageAlt AS meta_ogImageAlt_12, t0.meta_ogImage AS meta_ogImage_13, t0.meta_twitterCard AS meta_twitterCard_14, t0.meta_twitterDescription AS meta_twitterDescription_15, t0.meta_twitterTitle AS meta_twitterTitle_16, t0.meta_twitterImage AS meta_twitterImage_17, t0.meta_twitterImageAlt AS meta_twitterImageAlt_18, t0.locale AS locale_19, t0.id AS id_20, t0.header1 AS header1_21, t0.banner_title AS banner_title_22, t0.banner_url AS banner_url_23, t0.route_id AS route_id_24, t0.translatable_id AS translatable_id_25 FROM category_translation t0 WHERE t0.translatable_id = 1980 AND ((t0.locale = 'pl'));

SELECT
  t0.id AS id_1,
  t0.products_count AS products_count_2,
  t0.level AS level_3,
  t0.children_count AS children_count_4,
  t0.symbol AS symbol_5,
  t0.baselinker_id AS baselinker_id_6,
  t0.size_system AS size_system_7,
  t0.banner_image AS banner_image_8,
  t0.mobile_image AS mobile_image_9,
  t0.show_left_filters AS show_left_filters_10,
  t0.show_top_filters AS show_top_filters_11,
  t0.enabled AS enabled_12,
  t0.reindexable AS reindexable_13,
  t0.hierarchy AS hierarchy_14,
  t0.mobileHierarchy AS mobileHierarchy_15,
  t0.parent_id AS parent_id_16,
  t0.photo_id AS photo_id_17,
  t0.layout_page_id AS layout_page_id_18,
  t0.ceneo_category_id AS ceneo_category_id_19,
  t0.allegro_category_id AS allegro_category_id_20,
  t0.size_chart_id AS size_chart_id_21,
  t0.feature_group_id AS feature_group_id_22
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.hierarchy ASC
LIMIT
  100

SELECT t0.id AS id_1, t0.products_count AS products_count_2, t0.level AS level_3, t0.children_count AS children_count_4, t0.symbol AS symbol_5, t0.baselinker_id AS baselinker_id_6, t0.size_system AS size_system_7, t0.banner_image AS banner_image_8, t0.mobile_image AS mobile_image_9, t0.show_left_filters AS show_left_filters_10, t0.show_top_filters AS show_top_filters_11, t0.enabled AS enabled_12, t0.reindexable AS reindexable_13, t0.hierarchy AS hierarchy_14, t0.mobileHierarchy AS mobileHierarchy_15, t0.parent_id AS parent_id_16, t0.photo_id AS photo_id_17, t0.layout_page_id AS layout_page_id_18, t0.ceneo_category_id AS ceneo_category_id_19, t0.allegro_category_id AS allegro_category_id_20, t0.size_chart_id AS size_chart_id_21, t0.feature_group_id AS feature_group_id_22 FROM category t0 WHERE t0.parent_id = 2150 ORDER BY t0.hierarchy ASC LIMIT 100;

SELECT
  t0.name AS name_1,
  t0.listingName AS listingName_2,
  t0.description AS description_3,
  t0.css_class AS css_class_4,
  t0.slug AS slug_5,
  t0.meta_title AS meta_title_6,
  t0.meta_canonical AS meta_canonical_7,
  t0.meta_keywords AS meta_keywords_8,
  t0.meta_description AS meta_description_9,
  t0.meta_robots AS meta_robots_10,
  t0.meta_ogTitle AS meta_ogTitle_11,
  t0.meta_ogDescription AS meta_ogDescription_12,
  t0.meta_ogImageAlt AS meta_ogImageAlt_13,
  t0.meta_ogImage AS meta_ogImage_14,
  t0.meta_twitterCard AS meta_twitterCard_15,
  t0.meta_twitterDescription AS meta_twitterDescription_16,
  t0.meta_twitterTitle AS meta_twitterTitle_17,
  t0.meta_twitterImage AS meta_twitterImage_18,
  t0.meta_twitterImageAlt AS meta_twitterImageAlt_19,
  t0.locale AS locale_20,
  t0.id AS id_21,
  t0.route_id AS route_id_22,
  t0.translatable_id AS translatable_id_23
FROM
  product_status_translation t0
WHERE
  t0.translatable_id = ?
  AND (
    (t0.locale = 'pl')
  )

SELECT t0.name AS name_1, t0.listingName AS listingName_2, t0.description AS description_3, t0.css_class AS css_class_4, t0.slug AS slug_5, t0.meta_title AS meta_title_6, t0.meta_canonical AS meta_canonical_7, t0.meta_keywords AS meta_keywords_8, t0.meta_description AS meta_description_9, t0.meta_robots AS meta_robots_10, t0.meta_ogTitle AS meta_ogTitle_11, t0.meta_ogDescription AS meta_ogDescription_12, t0.meta_ogImageAlt AS meta_ogImageAlt_13, t0.meta_ogImage AS meta_ogImage_14, t0.meta_twitterCard AS meta_twitterCard_15, t0.meta_twitterDescription AS meta_twitterDescription_16, t0.meta_twitterTitle AS meta_twitterTitle_17, t0.meta_twitterImage AS meta_twitterImage_18, t0.meta_twitterImageAlt AS meta_twitterImageAlt_19, t0.locale AS locale_20, t0.id AS id_21, t0.route_id AS route_id_22, t0.translatable_id AS translatable_id_23 FROM product_status_translation t0 WHERE t0.translatable_id = 1 AND ((t0.locale = 'pl'));

SELECT
  t0.name AS name_1,
  t0.content AS content_2,
  t0.extra1 AS extra1_3,
  t0.extra2 AS extra2_4,
  t0.extra3 AS extra3_5,
  t0.extra4 AS extra4_6,
  t0.extra5 AS extra5_7,
  t0.extra6 AS extra6_8,
  t0.extra7 AS extra7_9,
  t0.extra8 AS extra8_10,
  t0.extra9 AS extra9_11,
  t0.extra10 AS extra10_12,
  t0.locale AS locale_13,
  t0.id AS id_14,
  t0.translatable_id AS translatable_id_15
FROM
  layout_box_translation t0
WHERE
  t0.translatable_id = ?
  AND (
    (t0.locale = 'pl')
  )

SELECT t0.name AS name_1, t0.content AS content_2, t0.extra1 AS extra1_3, t0.extra2 AS extra2_4, t0.extra3 AS extra3_5, t0.extra4 AS extra4_6, t0.extra5 AS extra5_7, t0.extra6 AS extra6_8, t0.extra7 AS extra7_9, t0.extra8 AS extra8_10, t0.extra9 AS extra9_11, t0.extra10 AS extra10_12, t0.locale AS locale_13, t0.id AS id_14, t0.translatable_id AS translatable_id_15 FROM layout_box_translation t0 WHERE t0.translatable_id = 415 AND ((t0.locale = 'pl'));

SELECT
  t0.id AS id_1,
  t0.box_type AS box_type_2,
  t0.settings AS settings_3,
  t0.identifier AS identifier_4,
  t0.visibleForGuests AS visibleForGuests_5,
  t0.copyable AS copyable_6,
  t0.valid_from AS valid_from_7,
  t0.valid_to AS valid_to_8,
  t0.week_schedule_monday AS week_schedule_monday_9,
  t0.week_schedule_tuesday AS week_schedule_tuesday_10,
  t0.week_schedule_wednesday AS week_schedule_wednesday_11,
  t0.week_schedule_thursday AS week_schedule_thursday_12,
  t0.week_schedule_friday AS week_schedule_friday_13,
  t0.week_schedule_saturday AS week_schedule_saturday_14,
  t0.week_schedule_sunday AS week_schedule_sunday_15,
  t0.shop_id AS shop_id_16
FROM
  layout_box t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.box_type AS box_type_2, t0.settings AS settings_3, t0.identifier AS identifier_4, t0.visibleForGuests AS visibleForGuests_5, t0.copyable AS copyable_6, t0.valid_from AS valid_from_7, t0.valid_to AS valid_to_8, t0.week_schedule_monday AS week_schedule_monday_9, t0.week_schedule_tuesday AS week_schedule_tuesday_10, t0.week_schedule_wednesday AS week_schedule_wednesday_11, t0.week_schedule_thursday AS week_schedule_thursday_12, t0.week_schedule_friday AS week_schedule_friday_13, t0.week_schedule_saturday AS week_schedule_saturday_14, t0.week_schedule_sunday AS week_schedule_sunday_15, t0.shop_id AS shop_id_16 FROM layout_box t0 WHERE t0.id = 415;

SELECT
  p0_.id AS id_0,
  p0_.symbol AS symbol_1,
  p0_.colour AS colour_2,
  p0_.backgroundColour AS backgroundColour_3,
  p0_.filterable AS filterable_4,
  p0_.visible AS visible_5,
  p0_.enabled AS enabled_6,
  p0_.hierarchy AS hierarchy_7,
  p0_.mobileHierarchy AS mobileHierarchy_8,
  p0_.photo_id AS photo_id_9
FROM
  product_status p0_
  LEFT JOIN product_status_translation p1_ ON p0_.id = p1_.translatable_id
  AND (p1_.locale = 'pl')
  INNER JOIN productstatus_shop p3_ ON p0_.id = p3_.productstatus_id
  INNER JOIN shop s2_ ON s2_.id = p3_.shop_id
  AND (s2_.id = ?)
WHERE
  p0_.enabled = 1
GROUP BY
  p0_.id

SELECT p0_.id AS id_0, p0_.symbol AS symbol_1, p0_.colour AS colour_2, p0_.backgroundColour AS backgroundColour_3, p0_.filterable AS filterable_4, p0_.visible AS visible_5, p0_.enabled AS enabled_6, p0_.hierarchy AS hierarchy_7, p0_.mobileHierarchy AS mobileHierarchy_8, p0_.photo_id AS photo_id_9 FROM product_status p0_ LEFT JOIN product_status_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale = 'pl') INNER JOIN productstatus_shop p3_ ON p0_.id = p3_.productstatus_id INNER JOIN shop s2_ ON s2_.id = p3_.shop_id AND (s2_.id = 1) WHERE p0_.enabled = 1 GROUP BY p0_.id;

SELECT
  p0_.id AS id_0,
  p0_.section AS section_1,
  p0_.publish AS publish_2,
  p0_.atob AS atob_3,
  p0_.redirect_type AS redirect_type_4,
  p0_.redirect_url AS redirect_url_5,
  p0_.redirect_route AS redirect_route_6,
  p0_.layout AS layout_7,
  p0_.layoutHtml AS layoutHtml_8,
  p0_.identifier AS identifier_9,
  p0_.icon AS icon_10,
  p0_.visibleForGuests AS visibleForGuests_11,
  p0_.hierarchy AS hierarchy_12,
  p0_.mobileHierarchy AS mobileHierarchy_13,
  p0_.createdAt AS createdAt_14,
  p0_.updatedAt AS updatedAt_15,
  p1_.name AS name_16,
  p1_.content AS content_17,
  p1_.slug AS slug_18,
  p1_.meta_title AS meta_title_19,
  p1_.meta_canonical AS meta_canonical_20,
  p1_.meta_keywords AS meta_keywords_21,
  p1_.meta_description AS meta_description_22,
  p1_.meta_robots AS meta_robots_23,
  p1_.meta_ogTitle AS meta_ogTitle_24,
  p1_.meta_ogDescription AS meta_ogDescription_25,
  p1_.meta_ogImageAlt AS meta_ogImageAlt_26,
  p1_.meta_ogImage AS meta_ogImage_27,
  p1_.meta_twitterCard AS meta_twitterCard_28,
  p1_.meta_twitterDescription AS meta_twitterDescription_29,
  p1_.meta_twitterTitle AS meta_twitterTitle_30,
  p1_.meta_twitterImage AS meta_twitterImage_31,
  p1_.meta_twitterImageAlt AS meta_twitterImageAlt_32,
  p1_.locale AS locale_33,
  p1_.id AS id_34,
  p0_.photo_id AS photo_id_35,
  p0_.parent_id AS parent_id_36,
  p0_.theme_id AS theme_id_37,
  p0_.layout_page_id AS layout_page_id_38,
  p1_.route_id AS route_id_39,
  p1_.translatable_id AS translatable_id_40
FROM
  page p0_
  LEFT JOIN page_translation p1_ ON p0_.id = p1_.translatable_id
  AND (p1_.locale = 'pl')
  INNER JOIN page_shop p3_ ON p0_.id = p3_.page_id
  INNER JOIN shop s2_ ON s2_.id = p3_.shop_id
  AND (s2_.id = ?)
WHERE
  p0_.parent_id IS NULL
  AND p0_.publish = 1
GROUP BY
  p0_.id
ORDER BY
  p0_.hierarchy ASC
LIMIT
  100

SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.publish AS publish_2, p0_.atob AS atob_3, p0_.redirect_type AS redirect_type_4, p0_.redirect_url AS redirect_url_5, p0_.redirect_route AS redirect_route_6, p0_.layout AS layout_7, p0_.layoutHtml AS layoutHtml_8, p0_.identifier AS identifier_9, p0_.icon AS icon_10, p0_.visibleForGuests AS visibleForGuests_11, p0_.hierarchy AS hierarchy_12, p0_.mobileHierarchy AS mobileHierarchy_13, p0_.createdAt AS createdAt_14, p0_.updatedAt AS updatedAt_15, p1_.name AS name_16, p1_.content AS content_17, p1_.slug AS slug_18, p1_.meta_title AS meta_title_19, p1_.meta_canonical AS meta_canonical_20, p1_.meta_keywords AS meta_keywords_21, p1_.meta_description AS meta_description_22, p1_.meta_robots AS meta_robots_23, p1_.meta_ogTitle AS meta_ogTitle_24, p1_.meta_ogDescription AS meta_ogDescription_25, p1_.meta_ogImageAlt AS meta_ogImageAlt_26, p1_.meta_ogImage AS meta_ogImage_27, p1_.meta_twitterCard AS meta_twitterCard_28, p1_.meta_twitterDescription AS meta_twitterDescription_29, p1_.meta_twitterTitle AS meta_twitterTitle_30, p1_.meta_twitterImage AS meta_twitterImage_31, p1_.meta_twitterImageAlt AS meta_twitterImageAlt_32, p1_.locale AS locale_33, p1_.id AS id_34, p0_.photo_id AS photo_id_35, p0_.parent_id AS parent_id_36, p0_.theme_id AS theme_id_37, p0_.layout_page_id AS layout_page_id_38, p1_.route_id AS route_id_39, p1_.translatable_id AS translatable_id_40 FROM page p0_ LEFT JOIN page_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale = 'pl') INNER JOIN page_shop p3_ ON p0_.id = p3_.page_id INNER JOIN shop s2_ ON s2_.id = p3_.shop_id AND (s2_.id = 1) WHERE p0_.parent_id IS NULL AND p0_.publish = 1 GROUP BY p0_.id ORDER BY p0_.hierarchy ASC LIMIT 100;

SELECT
  l0_.id AS id_0,
  l0_.startDate AS startDate_1,
  l0_.endDate AS endDate_2,
  l0_.enabled AS enabled_3,
  l0_.hierarchy AS hierarchy_4,
  l0_.mobileHierarchy AS mobileHierarchy_5,
  l0_.createdAt AS createdAt_6,
  l0_.updatedAt AS updatedAt_7,
  l1_.name AS name_8,
  l1_.shortDescription AS shortDescription_9,
  l1_.description AS description_10,
  l1_.slug AS slug_11,
  l1_.meta_title AS meta_title_12,
  l1_.meta_canonical AS meta_canonical_13,
  l1_.meta_keywords AS meta_keywords_14,
  l1_.meta_description AS meta_description_15,
  l1_.meta_robots AS meta_robots_16,
  l1_.meta_ogTitle AS meta_ogTitle_17,
  l1_.meta_ogDescription AS meta_ogDescription_18,
  l1_.meta_ogImageAlt AS meta_ogImageAlt_19,
  l1_.meta_ogImage AS meta_ogImage_20,
  l1_.meta_twitterCard AS meta_twitterCard_21,
  l1_.meta_twitterDescription AS meta_twitterDescription_22,
  l1_.meta_twitterTitle AS meta_twitterTitle_23,
  l1_.meta_twitterImage AS meta_twitterImage_24,
  l1_.meta_twitterImageAlt AS meta_twitterImageAlt_25,
  l1_.locale AS locale_26,
  l1_.id AS id_27,
  l0_.photo_id AS photo_id_28,
  l0_.layout_page_id AS layout_page_id_29,
  l1_.route_id AS route_id_30,
  l1_.translatable_id AS translatable_id_31
FROM
  landing_page l0_
  LEFT JOIN landing_page_translation l1_ ON l0_.id = l1_.translatable_id
  AND (l1_.locale = 'pl')
  INNER JOIN landingpage_shop l3_ ON l0_.id = l3_.landingpage_id
  INNER JOIN shop s2_ ON s2_.id = l3_.shop_id
  AND (s2_.id = ?)
GROUP BY
  l0_.id
ORDER BY
  l0_.hierarchy ASC
LIMIT
  100

SELECT l0_.id AS id_0, l0_.startDate AS startDate_1, l0_.endDate AS endDate_2, l0_.enabled AS enabled_3, l0_.hierarchy AS hierarchy_4, l0_.mobileHierarchy AS mobileHierarchy_5, l0_.createdAt AS createdAt_6, l0_.updatedAt AS updatedAt_7, l1_.name AS name_8, l1_.shortDescription AS shortDescription_9, l1_.description AS description_10, l1_.slug AS slug_11, l1_.meta_title AS meta_title_12, l1_.meta_canonical AS meta_canonical_13, l1_.meta_keywords AS meta_keywords_14, l1_.meta_description AS meta_description_15, l1_.meta_robots AS meta_robots_16, l1_.meta_ogTitle AS meta_ogTitle_17, l1_.meta_ogDescription AS meta_ogDescription_18, l1_.meta_ogImageAlt AS meta_ogImageAlt_19, l1_.meta_ogImage AS meta_ogImage_20, l1_.meta_twitterCard AS meta_twitterCard_21, l1_.meta_twitterDescription AS meta_twitterDescription_22, l1_.meta_twitterTitle AS meta_twitterTitle_23, l1_.meta_twitterImage AS meta_twitterImage_24, l1_.meta_twitterImageAlt AS meta_twitterImageAlt_25, l1_.locale AS locale_26, l1_.id AS id_27, l0_.photo_id AS photo_id_28, l0_.layout_page_id AS layout_page_id_29, l1_.route_id AS route_id_30, l1_.translatable_id AS translatable_id_31 FROM landing_page l0_ LEFT JOIN landing_page_translation l1_ ON l0_.id = l1_.translatable_id AND (l1_.locale = 'pl') INNER JOIN landingpage_shop l3_ ON l0_.id = l3_.landingpage_id INNER JOIN shop s2_ ON s2_.id = l3_.shop_id AND (s2_.id = 1) GROUP BY l0_.id ORDER BY l0_.hierarchy ASC LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.path AS path_3,
  t0.extension AS extension_4,
  t0.mime AS mime_5,
  t0.size AS size_6,
  t0.type AS type_7,
  t0.hierarchy AS hierarchy_8,
  t0.mobileHierarchy AS mobileHierarchy_9,
  t0.shop_id AS shop_id_10
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.extension AS extension_4, t0.mime AS mime_5, t0.size AS size_6, t0.type AS type_7, t0.hierarchy AS hierarchy_8, t0.mobileHierarchy AS mobileHierarchy_9, t0.shop_id AS shop_id_10 FROM media t0 WHERE t0.id = 88489;

SELECT
  c0_.id AS id_0,
  c0_.products_count AS products_count_1,
  c0_.level AS level_2,
  c0_.children_count AS children_count_3,
  c0_.symbol AS symbol_4,
  c0_.baselinker_id AS baselinker_id_5,
  c0_.size_system AS size_system_6,
  c0_.banner_image AS banner_image_7,
  c0_.mobile_image AS mobile_image_8,
  c0_.show_left_filters AS show_left_filters_9,
  c0_.show_top_filters AS show_top_filters_10,
  c0_.enabled AS enabled_11,
  c0_.reindexable AS reindexable_12,
  c0_.hierarchy AS hierarchy_13,
  c0_.mobileHierarchy AS mobileHierarchy_14,
  c1_.name AS name_15,
  c1_.short_description AS short_description_16,
  c1_.description AS description_17,
  c1_.slug AS slug_18,
  c1_.meta_title AS meta_title_19,
  c1_.meta_canonical AS meta_canonical_20,
  c1_.meta_keywords AS meta_keywords_21,
  c1_.meta_description AS meta_description_22,
  c1_.meta_robots AS meta_robots_23,
  c1_.meta_ogTitle AS meta_ogTitle_24,
  c1_.meta_ogDescription AS meta_ogDescription_25,
  c1_.meta_ogImageAlt AS meta_ogImageAlt_26,
  c1_.meta_ogImage AS meta_ogImage_27,
  c1_.meta_twitterCard AS meta_twitterCard_28,
  c1_.meta_twitterDescription AS meta_twitterDescription_29,
  c1_.meta_twitterTitle AS meta_twitterTitle_30,
  c1_.meta_twitterImage AS meta_twitterImage_31,
  c1_.meta_twitterImageAlt AS meta_twitterImageAlt_32,
  c1_.locale AS locale_33,
  c1_.id AS id_34,
  c1_.header1 AS header1_35,
  c1_.banner_title AS banner_title_36,
  c1_.banner_url AS banner_url_37,
  c0_.parent_id AS parent_id_38,
  c0_.photo_id AS photo_id_39,
  c0_.layout_page_id AS layout_page_id_40,
  c0_.ceneo_category_id AS ceneo_category_id_41,
  c0_.allegro_category_id AS allegro_category_id_42,
  c0_.size_chart_id AS size_chart_id_43,
  c0_.feature_group_id AS feature_group_id_44,
  c1_.route_id AS route_id_45,
  c1_.translatable_id AS translatable_id_46
FROM
  category c0_
  LEFT JOIN category_translation c1_ ON c0_.id = c1_.translatable_id
  AND (c1_.locale = 'pl')
  LEFT JOIN category c2_ ON c0_.parent_id = c2_.id
  INNER JOIN category_shop c4_ ON c0_.id = c4_.category_id
  INNER JOIN shop s3_ ON s3_.id = c4_.shop_id
  AND (s3_.id = ?)
WHERE
  c0_.enabled = 1
  AND c2_.id IS NULL
GROUP BY
  c0_.id
ORDER BY
  c0_.hierarchy ASC
LIMIT
  100

SELECT c0_.id AS id_0, c0_.products_count AS products_count_1, c0_.level AS level_2, c0_.children_count AS children_count_3, c0_.symbol AS symbol_4, c0_.baselinker_id AS baselinker_id_5, c0_.size_system AS size_system_6, c0_.banner_image AS banner_image_7, c0_.mobile_image AS mobile_image_8, c0_.show_left_filters AS show_left_filters_9, c0_.show_top_filters AS show_top_filters_10, c0_.enabled AS enabled_11, c0_.reindexable AS reindexable_12, c0_.hierarchy AS hierarchy_13, c0_.mobileHierarchy AS mobileHierarchy_14, c1_.name AS name_15, c1_.short_description AS short_description_16, c1_.description AS description_17, c1_.slug AS slug_18, c1_.meta_title AS meta_title_19, c1_.meta_canonical AS meta_canonical_20, c1_.meta_keywords AS meta_keywords_21, c1_.meta_description AS meta_description_22, c1_.meta_robots AS meta_robots_23, c1_.meta_ogTitle AS meta_ogTitle_24, c1_.meta_ogDescription AS meta_ogDescription_25, c1_.meta_ogImageAlt AS meta_ogImageAlt_26, c1_.meta_ogImage AS meta_ogImage_27, c1_.meta_twitterCard AS meta_twitterCard_28, c1_.meta_twitterDescription AS meta_twitterDescription_29, c1_.meta_twitterTitle AS meta_twitterTitle_30, c1_.meta_twitterImage AS meta_twitterImage_31, c1_.meta_twitterImageAlt AS meta_twitterImageAlt_32, c1_.locale AS locale_33, c1_.id AS id_34, c1_.header1 AS header1_35, c1_.banner_title AS banner_title_36, c1_.banner_url AS banner_url_37, c0_.parent_id AS parent_id_38, c0_.photo_id AS photo_id_39, c0_.layout_page_id AS layout_page_id_40, c0_.ceneo_category_id AS ceneo_category_id_41, c0_.allegro_category_id AS allegro_category_id_42, c0_.size_chart_id AS size_chart_id_43, c0_.feature_group_id AS feature_group_id_44, c1_.route_id AS route_id_45, c1_.translatable_id AS translatable_id_46 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = 'pl') LEFT JOIN category c2_ ON c0_.parent_id = c2_.id INNER JOIN category_shop c4_ ON c0_.id = c4_.category_id INNER JOIN shop s3_ ON s3_.id = c4_.shop_id AND (s3_.id = 1) WHERE c0_.enabled = 1 AND c2_.id IS NULL GROUP BY c0_.id ORDER BY c0_.hierarchy ASC LIMIT 100;

SELECT
  c0_.id AS id_0,
  c0_.line1 AS line1_1,
  c0_.line2 AS line2_2,
  c0_.line3 AS line3_3,
  c0_.postalCode AS postalCode_4,
  c0_.state AS state_5,
  c0_.city AS city_6,
  c0_.country AS country_7,
  c0_.enabled AS enabled_8,
  c0_.hierarchy AS hierarchy_9,
  c0_.mobileHierarchy AS mobileHierarchy_10,
  c1_.name AS name_11,
  c1_.topic AS topic_12,
  c1_.email AS email_13,
  c1_.phone AS phone_14,
  c1_.business_hours AS business_hours_15,
  c1_.locale AS locale_16,
  c1_.id AS id_17,
  c1_.translatable_id AS translatable_id_18
FROM
  contact c0_
  LEFT JOIN contact_translation c1_ ON c0_.id = c1_.translatable_id
  AND (c1_.locale = 'pl')
  INNER JOIN contact_shop c3_ ON c0_.id = c3_.contact_id
  INNER JOIN shop s2_ ON s2_.id = c3_.shop_id
  AND (s2_.id = ?)
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, c0_.line1 AS line1_1, c0_.line2 AS line2_2, c0_.line3 AS line3_3, c0_.postalCode AS postalCode_4, c0_.state AS state_5, c0_.city AS city_6, c0_.country AS country_7, c0_.enabled AS enabled_8, c0_.hierarchy AS hierarchy_9, c0_.mobileHierarchy AS mobileHierarchy_10, c1_.name AS name_11, c1_.topic AS topic_12, c1_.email AS email_13, c1_.phone AS phone_14, c1_.business_hours AS business_hours_15, c1_.locale AS locale_16, c1_.id AS id_17, c1_.translatable_id AS translatable_id_18 FROM contact c0_ LEFT JOIN contact_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = 'pl') INNER JOIN contact_shop c3_ ON c0_.id = c3_.contact_id INNER JOIN shop s2_ ON s2_.id = c3_.shop_id AND (s2_.id = 1) GROUP BY c0_.id;

SELECT
  t1.id AS id_2,
  t1.path AS path_3,
  t1.locale AS locale_4,
  t0.foreign_id AS foreign_id_5,
  t1.type
FROM
  route_landing_page t0
  INNER JOIN route t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.path AS path_3, t1.locale AS locale_4, t0.foreign_id AS foreign_id_5, t1.type FROM route_landing_page t0 INNER JOIN route t1 ON t0.id = t1.id WHERE t1.id = 254271;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3,
  t0.description AS description_4,
  t0.phone AS phone_5,
  t0.icon AS icon_6,
  t0.email AS email_7,
  t0.openingHours AS openingHours_8,
  t0.line1 AS line1_9,
  t0.line2 AS line2_10,
  t0.postal_code AS postal_code_11,
  t0.state AS state_12,
  t0.city AS city_13,
  t0.country AS country_14,
  t0.latitude AS latitude_15,
  t0.longitude AS longitude_16,
  t0.directionsUrl AS directionsUrl_17,
  t0.sprintInstance AS sprintInstance_18,
  t0.sprintDatabase AS sprintDatabase_19,
  t0.sprintUser AS sprintUser_20,
  t0.sprintPass AS sprintPass_21,
  t0.documentsTotal AS documentsTotal_22,
  t0.documentsMonth AS documentsMonth_23,
  t0.documentsToday AS documentsToday_24,
  t0.salesTotal AS salesTotal_25,
  t0.salesMonth AS salesMonth_26,
  t0.salesDay AS salesDay_27,
  t0.synced AS synced_28,
  t0.enabled AS enabled_29,
  t0.hierarchy AS hierarchy_30,
  t0.mobileHierarchy AS mobileHierarchy_31,
  t0.warehouse_id AS warehouse_id_32,
  t0.promotion_box_id AS promotion_box_id_33,
  t0.layout_page_id AS layout_page_id_34
FROM
  pos t0
  INNER JOIN pos_hop ON t0.id = pos_hop.foreign_id
WHERE
  pos_hop.shop_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.description AS description_4, t0.phone AS phone_5, t0.icon AS icon_6, t0.email AS email_7, t0.openingHours AS openingHours_8, t0.line1 AS line1_9, t0.line2 AS line2_10, t0.postal_code AS postal_code_11, t0.state AS state_12, t0.city AS city_13, t0.country AS country_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.directionsUrl AS directionsUrl_17, t0.sprintInstance AS sprintInstance_18, t0.sprintDatabase AS sprintDatabase_19, t0.sprintUser AS sprintUser_20, t0.sprintPass AS sprintPass_21, t0.documentsTotal AS documentsTotal_22, t0.documentsMonth AS documentsMonth_23, t0.documentsToday AS documentsToday_24, t0.salesTotal AS salesTotal_25, t0.salesMonth AS salesMonth_26, t0.salesDay AS salesDay_27, t0.synced AS synced_28, t0.enabled AS enabled_29, t0.hierarchy AS hierarchy_30, t0.mobileHierarchy AS mobileHierarchy_31, t0.warehouse_id AS warehouse_id_32, t0.promotion_box_id AS promotion_box_id_33, t0.layout_page_id AS layout_page_id_34 FROM pos t0 INNER JOIN pos_hop ON t0.id = pos_hop.foreign_id WHERE pos_hop.shop_id = 1;

SELECT
  t0.id AS id_1,
  t0.line1 AS line1_2,
  t0.line2 AS line2_3,
  t0.line3 AS line3_4,
  t0.postalCode AS postalCode_5,
  t0.state AS state_6,
  t0.city AS city_7,
  t0.country AS country_8,
  t0.enabled AS enabled_9,
  t0.hierarchy AS hierarchy_10,
  t0.mobileHierarchy AS mobileHierarchy_11
FROM
  contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.line1 AS line1_2, t0.line2 AS line2_3, t0.line3 AS line3_4, t0.postalCode AS postalCode_5, t0.state AS state_6, t0.city AS city_7, t0.country AS country_8, t0.enabled AS enabled_9, t0.hierarchy AS hierarchy_10, t0.mobileHierarchy AS mobileHierarchy_11 FROM contact t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.positionX AS positionX_2,
  t0.positionY AS positionY_3,
  t0.width AS width_4,
  t0.page_id AS page_id_5,
  t0.box_id AS box_id_6
FROM
  layout_page_box t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.positionX AS positionX_2, t0.positionY AS positionY_3, t0.width AS width_4, t0.page_id AS page_id_5, t0.box_id AS box_id_6 FROM layout_page_box t0 WHERE t0.page_id = 1;

SELECT
  t0.id AS id_1,
  t0.section AS section_2,
  t0.publish AS publish_3,
  t0.atob AS atob_4,
  t0.redirect_type AS redirect_type_5,
  t0.redirect_url AS redirect_url_6,
  t0.redirect_route AS redirect_route_7,
  t0.layout AS layout_8,
  t0.layoutHtml AS layoutHtml_9,
  t0.identifier AS identifier_10,
  t0.icon AS icon_11,
  t0.visibleForGuests AS visibleForGuests_12,
  t0.hierarchy AS hierarchy_13,
  t0.mobileHierarchy AS mobileHierarchy_14,
  t0.createdAt AS createdAt_15,
  t0.updatedAt AS updatedAt_16,
  t0.photo_id AS photo_id_17,
  t0.parent_id AS parent_id_18,
  t0.theme_id AS theme_id_19,
  t0.layout_page_id AS layout_page_id_20
FROM
  page t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.hierarchy ASC
LIMIT
  100