Symfony Profiler

SELECT
  t0.metaTitleSuffix AS metaTitleSuffix_1,
  t0.meta_title AS meta_title_2,
  t0.meta_canonical AS meta_canonical_3,
  t0.meta_keywords AS meta_keywords_4,
  t0.meta_description AS meta_description_5,
  t0.meta_robots AS meta_robots_6,
  t0.meta_ogTitle AS meta_ogTitle_7,
  t0.meta_ogDescription AS meta_ogDescription_8,
  t0.meta_ogImageAlt AS meta_ogImageAlt_9,
  t0.meta_ogImage AS meta_ogImage_10,
  t0.meta_twitterCard AS meta_twitterCard_11,
  t0.meta_twitterDescription AS meta_twitterDescription_12,
  t0.meta_twitterTitle AS meta_twitterTitle_13,
  t0.meta_twitterImage AS meta_twitterImage_14,
  t0.meta_twitterImageAlt AS meta_twitterImageAlt_15,
  t0.locale AS locale_16,
  t0.id AS id_17,
  t0.translatable_id AS translatable_id_18
FROM
  shop_translation t0
WHERE
  t0.translatable_id = ?
  AND (
    (t0.locale = 'pl')
  )

SELECT t0.metaTitleSuffix AS metaTitleSuffix_1, t0.meta_title AS meta_title_2, t0.meta_canonical AS meta_canonical_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.meta_robots AS meta_robots_6, t0.meta_ogTitle AS meta_ogTitle_7, t0.meta_ogDescription AS meta_ogDescription_8, t0.meta_ogImageAlt AS meta_ogImageAlt_9, t0.meta_ogImage AS meta_ogImage_10, t0.meta_twitterCard AS meta_twitterCard_11, t0.meta_twitterDescription AS meta_twitterDescription_12, t0.meta_twitterTitle AS meta_twitterTitle_13, t0.meta_twitterImage AS meta_twitterImage_14, t0.meta_twitterImageAlt AS meta_twitterImageAlt_15, t0.locale AS locale_16, t0.id AS id_17, t0.translatable_id AS translatable_id_18 FROM shop_translation t0 WHERE t0.translatable_id = 1 AND ((t0.locale = 'pl'));

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.name AS name_1,
  t0.topic AS topic_2,
  t0.email AS email_3,
  t0.phone AS phone_4,
  t0.business_hours AS business_hours_5,
  t0.locale AS locale_6,
  t0.id AS id_7,
  t0.translatable_id AS translatable_id_8
FROM
  contact_translation t0
WHERE
  t0.translatable_id = ?
  AND (
    (t0.locale = 'pl')
  )

SELECT t0.name AS name_1, t0.topic AS topic_2, t0.email AS email_3, t0.phone AS phone_4, t0.business_hours AS business_hours_5, t0.locale AS locale_6, t0.id AS id_7, t0.translatable_id AS translatable_id_8 FROM contact_translation t0 WHERE t0.translatable_id = 1 AND ((t0.locale = 'pl'));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.line1 AS line1_4,
  t0.line2 AS line2_5,
  t0.line3 AS line3_6,
  t0.postal_code AS postal_code_7,
  t0.state AS state_8,
  t0.city AS city_9,
  t0.country AS country_10,
  t0.latitude AS latitude_11,
  t0.longitude AS longitude_12,
  t0.phone AS phone_13,
  t0.email AS email_14,
  t0.vatId AS vatId_15,
  t0.krs AS krs_16,
  t0.regon AS regon_17,
  t0.bankAccountNumber AS bankAccountNumber_18,
  t0.bankAccountName AS bankAccountName_19
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.line1 AS line1_4, t0.line2 AS line2_5, t0.line3 AS line3_6, t0.postal_code AS postal_code_7, t0.state AS state_8, t0.city AS city_9, t0.country AS country_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.phone AS phone_13, t0.email AS email_14, t0.vatId AS vatId_15, t0.krs AS krs_16, t0.regon AS regon_17, t0.bankAccountNumber AS bankAccountNumber_18, t0.bankAccountName AS bankAccountName_19 FROM company t0 WHERE t0.id = 1;

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
  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
  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
  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.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 = 1979 ORDER BY t0.hierarchy ASC LIMIT 100;

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 = 1980 ORDER BY t0.hierarchy ASC LIMIT 100;

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 = 1981 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 = ?
  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 = 1982 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 = ?
  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 = 1983 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 = ?
  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 = 1984 AND ((t0.locale = 'pl'));