Symfony Profiler

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
WHERE
  t0.hostname = ?
  AND t0.enabled = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = 'dev.kamedia.pl' AND t0.enabled = 1 ORDER BY t0.id ASC LIMIT 1;

SELECT
  COUNT(*)
FROM
  sylius_channel t0

SELECT COUNT(*) FROM sylius_channel t0;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4
FROM
  sylius_locale t0
  INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id
WHERE
  sylius_channel_locales.channel_id = ?

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = 1;

SELECT
  t0.id AS id_1,
  t0.original_filename AS original_filename_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.hash AS hash_5,
  t0.path AS path_6,
  t0.width AS width_7,
  t0.height AS height_8,
  t0.original_width AS original_width_9,
  t0.original_height AS original_height_10,
  t0.mime_type AS mime_type_11,
  t0.source AS source_12,
  t0.s3_key AS s3_key_13,
  t0.popularity AS popularity_14,
  t0.created_at AS created_at_15,
  t0.seo_title AS seo_title_16,
  t0.seo_description AS seo_description_17,
  t0.seo_subtitle AS seo_subtitle_18,
  t0.description_intro AS description_intro_19,
  t0.description_features AS description_features_20,
  t0.description_usage AS description_usage_21,
  t0.category1_id AS category1_id_22,
  t0.category2_id AS category2_id_23,
  t0.main_room_id AS main_room_id_24,
  t0.collection_id AS collection_id_25
FROM
  km_pattern t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.original_filename AS original_filename_2, t0.name AS name_3, t0.slug AS slug_4, t0.hash AS hash_5, t0.path AS path_6, t0.width AS width_7, t0.height AS height_8, t0.original_width AS original_width_9, t0.original_height AS original_height_10, t0.mime_type AS mime_type_11, t0.source AS source_12, t0.s3_key AS s3_key_13, t0.popularity AS popularity_14, t0.created_at AS created_at_15, t0.seo_title AS seo_title_16, t0.seo_description AS seo_description_17, t0.seo_subtitle AS seo_subtitle_18, t0.description_intro AS description_intro_19, t0.description_features AS description_features_20, t0.description_usage AS description_usage_21, t0.category1_id AS category1_id_22, t0.category2_id AS category2_id_23, t0.main_room_id AS main_room_id_24, t0.collection_id AS collection_id_25 FROM km_pattern t0 WHERE t0.slug = 'lesna-opowiesc' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.is_main AS is_main_3,
  t0.orientation AS orientation_4,
  t0.alt_text AS alt_text_5,
  t0.pattern_id AS pattern_id_6,
  t0.room_type_id AS room_type_id_7
FROM
  km_mockup t0
WHERE
  t0.pattern_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.path AS path_2, t0.is_main AS is_main_3, t0.orientation AS orientation_4, t0.alt_text AS alt_text_5, t0.pattern_id AS pattern_id_6, t0.room_type_id AS room_type_id_7 FROM km_mockup t0 WHERE t0.pattern_id = 31 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  km_pattern_style t0
  INNER JOIN km_pattern_style_relation ON t0.id = km_pattern_style_relation.pattern_style_id
WHERE
  km_pattern_style_relation.pattern_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM km_pattern_style t0 INNER JOIN km_pattern_style_relation ON t0.id = km_pattern_style_relation.pattern_style_id WHERE km_pattern_style_relation.pattern_id = 31;

SELECT
  k0_.id AS id_0,
  k0_.original_filename AS original_filename_1,
  k0_.name AS name_2,
  k0_.slug AS slug_3,
  k0_.hash AS hash_4,
  k0_.path AS path_5,
  k0_.width AS width_6,
  k0_.height AS height_7,
  k0_.original_width AS original_width_8,
  k0_.original_height AS original_height_9,
  k0_.mime_type AS mime_type_10,
  k0_.source AS source_11,
  k0_.s3_key AS s3_key_12,
  k0_.popularity AS popularity_13,
  k0_.created_at AS created_at_14,
  k0_.seo_title AS seo_title_15,
  k0_.seo_description AS seo_description_16,
  k0_.seo_subtitle AS seo_subtitle_17,
  k0_.description_intro AS description_intro_18,
  k0_.description_features AS description_features_19,
  k0_.description_usage AS description_usage_20,
  k0_.category1_id AS category1_id_21,
  k0_.category2_id AS category2_id_22,
  k0_.main_room_id AS main_room_id_23,
  k0_.collection_id AS collection_id_24
FROM
  km_pattern k0_
  INNER JOIN km_pattern_style_relation k2_ ON k0_.id = k2_.pattern_id
  INNER JOIN km_pattern_style k1_ ON k1_.id = k2_.pattern_style_id
WHERE
  k1_.id = ?
  AND k0_.id <> ?
ORDER BY
  k0_.id ASC
LIMIT
  4

SELECT k0_.id AS id_0, k0_.original_filename AS original_filename_1, k0_.name AS name_2, k0_.slug AS slug_3, k0_.hash AS hash_4, k0_.path AS path_5, k0_.width AS width_6, k0_.height AS height_7, k0_.original_width AS original_width_8, k0_.original_height AS original_height_9, k0_.mime_type AS mime_type_10, k0_.source AS source_11, k0_.s3_key AS s3_key_12, k0_.popularity AS popularity_13, k0_.created_at AS created_at_14, k0_.seo_title AS seo_title_15, k0_.seo_description AS seo_description_16, k0_.seo_subtitle AS seo_subtitle_17, k0_.description_intro AS description_intro_18, k0_.description_features AS description_features_19, k0_.description_usage AS description_usage_20, k0_.category1_id AS category1_id_21, k0_.category2_id AS category2_id_22, k0_.main_room_id AS main_room_id_23, k0_.collection_id AS collection_id_24 FROM km_pattern k0_ INNER JOIN km_pattern_style_relation k2_ ON k0_.id = k2_.pattern_id INNER JOIN km_pattern_style k1_ ON k1_.id = k2_.pattern_style_id WHERE k1_.id = 7 AND k0_.id <> 31 ORDER BY k0_.id ASC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.visible AS visible_5,
  t0.parent_id AS parent_id_6
FROM
  km_pattern_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.visible AS visible_5, t0.parent_id AS parent_id_6 FROM km_pattern_category t0 WHERE t0.id = 5;

SELECT
  s0_.text_value AS text_value_0
FROM
  sylius_product_attribute_value s0_
  INNER JOIN sylius_product_attribute s1_ ON s0_.attribute_id = s1_.id
WHERE
  s1_.code = ?
  AND s0_.text_value IN (?)
ORDER BY
  s0_.id ASC
LIMIT
  1

SELECT s0_.text_value AS text_value_0 FROM sylius_product_attribute_value s0_ INNER JOIN sylius_product_attribute s1_ ON s0_.attribute_id = s1_.id WHERE s1_.code = 'restricted_category_slug' AND s0_.text_value IN ('fototapety-skandynawskie-dla-dzieci') ORDER BY s0_.id ASC LIMIT 1;

SELECT
  MIN(s0_.price) AS sclr_0
FROM
  sylius_product_variant s1_
  INNER JOIN sylius_product s2_ ON s1_.product_id = s2_.id
  INNER JOIN sylius_channel_pricing s0_ ON s1_.id = s0_.product_variant_id
WHERE
  s2_.sold_by_square_meter = 1
  AND s1_.enabled = 1
  AND s2_.id NOT IN (
    SELECT
      s3_.product_id AS sclr_1
    FROM
      sylius_product_attribute_value s3_
      INNER JOIN sylius_product_attribute s4_ ON s3_.attribute_id = s4_.id
    WHERE
      s4_.code = ?
  )

SELECT MIN(s0_.price) AS sclr_0 FROM sylius_product_variant s1_ INNER JOIN sylius_product s2_ ON s1_.product_id = s2_.id INNER JOIN sylius_channel_pricing s0_ ON s1_.id = s0_.product_variant_id WHERE s2_.sold_by_square_meter = 1 AND s1_.enabled = 1 AND s2_.id NOT IN (SELECT s3_.product_id AS sclr_1 FROM sylius_product_attribute_value s3_ INNER JOIN sylius_product_attribute s4_ ON s3_.attribute_id = s4_.id WHERE s4_.code = 'restricted_category_slug');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  km_pattern_theme t0
  INNER JOIN km_pattern_theme_relation ON t0.id = km_pattern_theme_relation.pattern_theme_id
WHERE
  km_pattern_theme_relation.pattern_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM km_pattern_theme t0 INNER JOIN km_pattern_theme_relation ON t0.id = km_pattern_theme_relation.pattern_theme_id WHERE km_pattern_theme_relation.pattern_id = 31;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.hex_code AS hex_code_4
FROM
  km_pattern_color t0
  INNER JOIN km_pattern_color_relation ON t0.id = km_pattern_color_relation.pattern_color_id
WHERE
  km_pattern_color_relation.pattern_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.hex_code AS hex_code_4 FROM km_pattern_color t0 INNER JOIN km_pattern_color_relation ON t0.id = km_pattern_color_relation.pattern_color_id WHERE km_pattern_color_relation.pattern_id = 31;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.is_main AS is_main_3,
  t0.orientation AS orientation_4,
  t0.alt_text AS alt_text_5,
  t0.pattern_id AS pattern_id_6,
  t0.room_type_id AS room_type_id_7
FROM
  km_mockup t0
WHERE
  t0.pattern_id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.is_main AS is_main_3, t0.orientation AS orientation_4, t0.alt_text AS alt_text_5, t0.pattern_id AS pattern_id_6, t0.room_type_id AS room_type_id_7 FROM km_mockup t0 WHERE t0.pattern_id = 30;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  km_pattern_style t0
  INNER JOIN km_pattern_style_relation ON t0.id = km_pattern_style_relation.pattern_style_id
WHERE
  km_pattern_style_relation.pattern_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM km_pattern_style t0 INNER JOIN km_pattern_style_relation ON t0.id = km_pattern_style_relation.pattern_style_id WHERE km_pattern_style_relation.pattern_id = 30;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.is_main AS is_main_3,
  t0.orientation AS orientation_4,
  t0.alt_text AS alt_text_5,
  t0.pattern_id AS pattern_id_6,
  t0.room_type_id AS room_type_id_7
FROM
  km_mockup t0
WHERE
  t0.pattern_id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.is_main AS is_main_3, t0.orientation AS orientation_4, t0.alt_text AS alt_text_5, t0.pattern_id AS pattern_id_6, t0.room_type_id AS room_type_id_7 FROM km_mockup t0 WHERE t0.pattern_id = 45;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  km_pattern_style t0
  INNER JOIN km_pattern_style_relation ON t0.id = km_pattern_style_relation.pattern_style_id
WHERE
  km_pattern_style_relation.pattern_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM km_pattern_style t0 INNER JOIN km_pattern_style_relation ON t0.id = km_pattern_style_relation.pattern_style_id WHERE km_pattern_style_relation.pattern_id = 45;