Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.exchange_rate AS exchange_rate_1,
  e0_.last_automatic_update AS last_automatic_update_2,
  e0_.created_at AS created_at_3,
  e0_.updated_at AS updated_at_4,
  e0_.currency_from_id AS currency_from_id_5,
  e0_.currency_to_id AS currency_to_id_6
FROM
  exchange_rate e0_

SELECT e0_.id AS id_0, e0_.exchange_rate AS exchange_rate_1, e0_.last_automatic_update AS last_automatic_update_2, e0_.created_at AS created_at_3, e0_.updated_at AS updated_at_4, e0_.currency_from_id AS currency_from_id_5, e0_.currency_to_id AS currency_to_id_6 FROM exchange_rate e0_;

SELECT
  r0_.id AS id_0,
  r0_.source AS source_1,
  r0_.destination AS destination_2,
  r0_.active AS active_3,
  r0_.status_code AS status_code_4,
  r0_.created_at AS created_at_5,
  r0_.updated_at AS updated_at_6
FROM
  redirect_route r0_
WHERE
  r0_.source = ?

SELECT r0_.id AS id_0, r0_.source AS source_1, r0_.destination AS destination_2, r0_.active AS active_3, r0_.status_code AS status_code_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6 FROM redirect_route r0_ WHERE r0_.source = '/en/375-sale';

SELECT
  c0_.code AS code_0,
  c0_.is_default AS is_default_1,
  c0_.is_active AS is_active_2,
  c0_.decimal_places AS decimal_places_3,
  e1_.id AS id_4,
  e1_.exchange_rate AS exchange_rate_5,
  e1_.last_automatic_update AS last_automatic_update_6,
  e1_.created_at AS created_at_7,
  e1_.updated_at AS updated_at_8,
  e2_.id AS id_9,
  e2_.exchange_rate AS exchange_rate_10,
  e2_.last_automatic_update AS last_automatic_update_11,
  e2_.created_at AS created_at_12,
  e2_.updated_at AS updated_at_13,
  e1_.currency_from_id AS currency_from_id_14,
  e1_.currency_to_id AS currency_to_id_15,
  e2_.currency_from_id AS currency_from_id_16,
  e2_.currency_to_id AS currency_to_id_17
FROM
  currency c0_
  LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id
  LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id
WHERE
  c0_.is_default = ?

SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = 1;

SELECT
  c0_.code AS code_0,
  c0_.is_default AS is_default_1,
  c0_.is_active AS is_active_2,
  c0_.decimal_places AS decimal_places_3,
  e1_.id AS id_4,
  e1_.exchange_rate AS exchange_rate_5,
  e1_.last_automatic_update AS last_automatic_update_6,
  e1_.created_at AS created_at_7,
  e1_.updated_at AS updated_at_8,
  e2_.id AS id_9,
  e2_.exchange_rate AS exchange_rate_10,
  e2_.last_automatic_update AS last_automatic_update_11,
  e2_.created_at AS created_at_12,
  e2_.updated_at AS updated_at_13,
  e1_.currency_from_id AS currency_from_id_14,
  e1_.currency_to_id AS currency_to_id_15,
  e2_.currency_from_id AS currency_from_id_16,
  e2_.currency_to_id AS currency_to_id_17
FROM
  currency c0_
  LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id
  LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id
WHERE
  c0_.is_default = ?

SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = 1;

SELECT
  c0_.code AS code_0,
  c0_.is_default AS is_default_1,
  c0_.is_active AS is_active_2,
  c0_.decimal_places AS decimal_places_3,
  e1_.id AS id_4,
  e1_.exchange_rate AS exchange_rate_5,
  e1_.last_automatic_update AS last_automatic_update_6,
  e1_.created_at AS created_at_7,
  e1_.updated_at AS updated_at_8,
  e2_.id AS id_9,
  e2_.exchange_rate AS exchange_rate_10,
  e2_.last_automatic_update AS last_automatic_update_11,
  e2_.created_at AS created_at_12,
  e2_.updated_at AS updated_at_13,
  e1_.currency_from_id AS currency_from_id_14,
  e1_.currency_to_id AS currency_to_id_15,
  e2_.currency_from_id AS currency_from_id_16,
  e2_.currency_to_id AS currency_to_id_17
FROM
  currency c0_
  LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id
  LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id
ORDER BY
  c0_.is_default DESC,
  c0_.code ASC

SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id ORDER BY c0_.is_default DESC, c0_.code ASC;

SELECT
  c0_.code AS code_0,
  c0_.is_default AS is_default_1,
  c0_.is_active AS is_active_2,
  c0_.decimal_places AS decimal_places_3,
  e1_.id AS id_4,
  e1_.exchange_rate AS exchange_rate_5,
  e1_.last_automatic_update AS last_automatic_update_6,
  e1_.created_at AS created_at_7,
  e1_.updated_at AS updated_at_8,
  e2_.id AS id_9,
  e2_.exchange_rate AS exchange_rate_10,
  e2_.last_automatic_update AS last_automatic_update_11,
  e2_.created_at AS created_at_12,
  e2_.updated_at AS updated_at_13,
  e1_.currency_from_id AS currency_from_id_14,
  e1_.currency_to_id AS currency_to_id_15,
  e2_.currency_from_id AS currency_from_id_16,
  e2_.currency_to_id AS currency_to_id_17
FROM
  currency c0_
  LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id
  LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id
WHERE
  c0_.is_default = ?

SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = 1;

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.status AS status_2,
  c0_.last_activity_at AS last_activity_at_3,
  c0_.email AS email_4,
  c0_.firstname AS firstname_5,
  c0_.lastname AS lastname_6,
  c0_.telephone AS telephone_7,
  c0_.company_name AS company_name_8,
  c0_.cin AS cin_9,
  c0_.vat_id AS vat_id_10,
  c0_.pickup_point_id AS pickup_point_id_11,
  c0_.pickup_point_name AS pickup_point_name_12,
  c0_.note AS note_13,
  c0_.newsletter_consent AS newsletter_consent_14,
  c0_.gdpr_consent AS gdpr_consent_15,
  c0_.payment_method AS payment_method_16,
  c0_.tracking_heureka_opt_out AS tracking_heureka_opt_out_17,
  c0_.tracking_zbozi_opt_in AS tracking_zbozi_opt_in_18,
  c0_.created_at AS created_at_19,
  c0_.updated_at AS updated_at_20,
  c0_.address_street AS address_street_21,
  c0_.address_descriptive_number AS address_descriptive_number_22,
  c0_.address_city AS address_city_23,
  c0_.address_country AS address_country_24,
  c0_.address_zip_code AS address_zip_code_25,
  c0_.invoice_street AS invoice_street_26,
  c0_.invoice_descriptive_number AS invoice_descriptive_number_27,
  c0_.invoice_city AS invoice_city_28,
  c0_.invoice_country AS invoice_country_29,
  c0_.invoice_zip_code AS invoice_zip_code_30,
  c1_.id AS id_31,
  c1_.quantity AS quantity_32,
  c1_.is_gift AS is_gift_33,
  c1_.created_at AS created_at_34,
  c1_.updated_at AS updated_at_35,
  p2_.id AS id_36,
  p2_.public_id AS public_id_37,
  p2_.code AS code_38,
  p2_.is_default AS is_default_39,
  p2_.weight_modification AS weight_modification_40,
  p2_.price_modification_amount AS price_modification_amount_41,
  p2_.price_modification_currency AS price_modification_currency_42,
  p2_.stock_stock AS stock_stock_43,
  p2_.stock_reserved AS stock_reserved_44,
  p3_.id AS id_45,
  p3_.public_id AS public_id_46,
  p3_.name AS name_47,
  p3_.description AS description_48,
  p3_.short_description AS short_description_49,
  p3_.code AS code_50,
  p3_.ean AS ean_51,
  p3_.unit AS unit_52,
  p3_.active AS active_53,
  p3_.can_be_bought AS can_be_bought_54,
  p3_.searchable AS searchable_55,
  p3_.show_price AS show_price_56,
  p3_.in_stock_text AS in_stock_text_57,
  p3_.out_of_stock_text AS out_of_stock_text_58,
  p3_.filter_parameter_value_ids AS filter_parameter_value_ids_59,
  p3_.filter_variant_value_ids AS filter_variant_value_ids_60,
  p3_.search_vector_cs AS search_vector_cs_61,
  p3_.search_vector_en AS search_vector_en_62,
  p3_.seo_title AS seo_title_63,
  p3_.seo_description AS seo_description_64,
  p3_.seo_url AS seo_url_65,
  p3_.stock_stock AS stock_stock_66,
  p3_.stock_reserved AS stock_reserved_67,
  p3_.logistic_weight AS logistic_weight_68,
  p3_.logistic_size_width AS logistic_size_width_69,
  p3_.logistic_size_height AS logistic_size_height_70,
  p3_.logistic_size_length AS logistic_size_length_71,
  p3_.price_amount AS price_amount_72,
  p3_.price_currency AS price_currency_73,
  p3_.purchase_price_amount AS purchase_price_amount_74,
  p3_.purchase_price_currency AS purchase_price_currency_75,
  c0_.customer_id AS customer_id_76,
  c0_.shipping_method_id AS shipping_method_id_77,
  c0_.discount_code_id AS discount_code_id_78,
  c1_.cart_id AS cart_id_79,
  c1_.product_variant_id AS product_variant_id_80,
  p2_.product_id AS product_id_81,
  p3_.vat_id AS vat_id_82,
  p3_.main_category_id AS main_category_id_83
FROM
  cart c0_
  LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id
  LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id
  LEFT JOIN product p3_ ON p2_.product_id = p3_.id
WHERE
  c0_.session_id = ?
  AND c0_.status = ?
ORDER BY
  c1_.id ASC

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.newsletter_consent AS newsletter_consent_14, c0_.gdpr_consent AS gdpr_consent_15, c0_.payment_method AS payment_method_16, c0_.tracking_heureka_opt_out AS tracking_heureka_opt_out_17, c0_.tracking_zbozi_opt_in AS tracking_zbozi_opt_in_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.address_street AS address_street_21, c0_.address_descriptive_number AS address_descriptive_number_22, c0_.address_city AS address_city_23, c0_.address_country AS address_country_24, c0_.address_zip_code AS address_zip_code_25, c0_.invoice_street AS invoice_street_26, c0_.invoice_descriptive_number AS invoice_descriptive_number_27, c0_.invoice_city AS invoice_city_28, c0_.invoice_country AS invoice_country_29, c0_.invoice_zip_code AS invoice_zip_code_30, c1_.id AS id_31, c1_.quantity AS quantity_32, c1_.is_gift AS is_gift_33, c1_.created_at AS created_at_34, c1_.updated_at AS updated_at_35, p2_.id AS id_36, p2_.public_id AS public_id_37, p2_.code AS code_38, p2_.is_default AS is_default_39, p2_.weight_modification AS weight_modification_40, p2_.price_modification_amount AS price_modification_amount_41, p2_.price_modification_currency AS price_modification_currency_42, p2_.stock_stock AS stock_stock_43, p2_.stock_reserved AS stock_reserved_44, p3_.id AS id_45, p3_.public_id AS public_id_46, p3_.name AS name_47, p3_.description AS description_48, p3_.short_description AS short_description_49, p3_.code AS code_50, p3_.ean AS ean_51, p3_.unit AS unit_52, p3_.active AS active_53, p3_.can_be_bought AS can_be_bought_54, p3_.searchable AS searchable_55, p3_.show_price AS show_price_56, p3_.in_stock_text AS in_stock_text_57, p3_.out_of_stock_text AS out_of_stock_text_58, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_59, p3_.filter_variant_value_ids AS filter_variant_value_ids_60, p3_.search_vector_cs AS search_vector_cs_61, p3_.search_vector_en AS search_vector_en_62, p3_.seo_title AS seo_title_63, p3_.seo_description AS seo_description_64, p3_.seo_url AS seo_url_65, p3_.stock_stock AS stock_stock_66, p3_.stock_reserved AS stock_reserved_67, p3_.logistic_weight AS logistic_weight_68, p3_.logistic_size_width AS logistic_size_width_69, p3_.logistic_size_height AS logistic_size_height_70, p3_.logistic_size_length AS logistic_size_length_71, p3_.price_amount AS price_amount_72, p3_.price_currency AS price_currency_73, p3_.purchase_price_amount AS purchase_price_amount_74, p3_.purchase_price_currency AS purchase_price_currency_75, c0_.customer_id AS customer_id_76, c0_.shipping_method_id AS shipping_method_id_77, c0_.discount_code_id AS discount_code_id_78, c1_.cart_id AS cart_id_79, c1_.product_variant_id AS product_variant_id_80, p2_.product_id AS product_id_81, p3_.vat_id AS vat_id_82, p3_.main_category_id AS main_category_id_83 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.session_id = '6ce01bc8a4e782f840663df6cd6d1444' AND c0_.status = 'active' ORDER BY c1_.id ASC;

SELECT
  t0.id AS id_1,
  t0.public_id AS public_id_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.lft AS lft_6,
  t0.lvl AS lvl_7,
  t0.rgt AS rgt_8,
  t0.position AS position_9,
  t0.seo_title AS seo_title_10,
  t0.seo_description AS seo_description_11,
  t0.seo_url AS seo_url_12,
  t0.image_id AS image_id_13,
  t0.tree_root AS tree_root_14,
  t0.parent_id AS parent_id_15
FROM
  category t0
WHERE
  t0.public_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 WHERE t0.public_id = '375' LIMIT 1;

SELECT
  c0_.id AS id_0
FROM
  category c0_
WHERE
  c0_.lft > ?
  AND c0_.rgt < ?
  AND c0_.tree_root = ?

SELECT c0_.id AS id_0 FROM category c0_ WHERE c0_.lft > 1 AND c0_.rgt < 8 AND c0_.tree_root = '8f6b4a0d-2c9e-4d3f-4b7a-6e1c3d8f9b0a';

SELECT
  c0_.id AS id_0,
  c0_.public_id AS public_id_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.description AS description_4,
  c0_.lft AS lft_5,
  c0_.lvl AS lvl_6,
  c0_.rgt AS rgt_7,
  c0_.position AS position_8,
  c0_.seo_title AS seo_title_9,
  c0_.seo_description AS seo_description_10,
  c0_.seo_url AS seo_url_11,
  c0_.image_id AS image_id_12,
  c0_.tree_root AS tree_root_13,
  c0_.parent_id AS parent_id_14
FROM
  category c0_
WHERE
  c0_.lft < ?
  AND c0_.rgt > ?
  AND c0_.tree_root = ?
ORDER BY
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8, c0_.seo_title AS seo_title_9, c0_.seo_description AS seo_description_10, c0_.seo_url AS seo_url_11, c0_.image_id AS image_id_12, c0_.tree_root AS tree_root_13, c0_.parent_id AS parent_id_14 FROM category c0_ WHERE c0_.lft < 1 AND c0_.rgt > 8 AND c0_.tree_root = '8f6b4a0d-2c9e-4d3f-4b7a-6e1c3d8f9b0a' ORDER BY c0_.lft ASC;

SELECT
  c0_.id AS id_0,
  c0_.public_id AS public_id_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.description AS description_4,
  c0_.lft AS lft_5,
  c0_.lvl AS lvl_6,
  c0_.rgt AS rgt_7,
  c0_.position AS position_8,
  c0_.seo_title AS seo_title_9,
  c0_.seo_description AS seo_description_10,
  c0_.seo_url AS seo_url_11,
  f1_.id AS id_12,
  f1_.size AS size_13,
  f1_.mime_type AS mime_type_14,
  f1_.name AS name_15,
  c0_.image_id AS image_id_16,
  c0_.tree_root AS tree_root_17,
  c0_.parent_id AS parent_id_18
FROM
  category c0_
  LEFT JOIN file f1_ ON c0_.image_id = f1_.id
WHERE
  c0_.parent_id = ?
ORDER BY
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8, c0_.seo_title AS seo_title_9, c0_.seo_description AS seo_description_10, c0_.seo_url AS seo_url_11, f1_.id AS id_12, f1_.size AS size_13, f1_.mime_type AS mime_type_14, f1_.name AS name_15, c0_.image_id AS image_id_16, c0_.tree_root AS tree_root_17, c0_.parent_id AS parent_id_18 FROM category c0_ LEFT JOIN file f1_ ON c0_.image_id = f1_.id WHERE c0_.parent_id = '8f6b4a0d-2c9e-4d3f-4b7a-6e1c3d8f9b0a' ORDER BY c0_.lft ASC;

SELECT
  c0_.id AS id_0,
  c0_.public_id AS public_id_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.description AS description_4,
  c0_.lft AS lft_5,
  c0_.lvl AS lvl_6,
  c0_.rgt AS rgt_7,
  c0_.position AS position_8,
  c0_.seo_title AS seo_title_9,
  c0_.seo_description AS seo_description_10,
  c0_.seo_url AS seo_url_11,
  f1_.id AS id_12,
  f1_.size AS size_13,
  f1_.mime_type AS mime_type_14,
  f1_.name AS name_15,
  c0_.image_id AS image_id_16,
  c0_.tree_root AS tree_root_17,
  c0_.parent_id AS parent_id_18
FROM
  category c0_
  LEFT JOIN file f1_ ON c0_.image_id = f1_.id
WHERE
  c0_.parent_id IS NULL
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8, c0_.seo_title AS seo_title_9, c0_.seo_description AS seo_description_10, c0_.seo_url AS seo_url_11, f1_.id AS id_12, f1_.size AS size_13, f1_.mime_type AS mime_type_14, f1_.name AS name_15, c0_.image_id AS image_id_16, c0_.tree_root AS tree_root_17, c0_.parent_id AS parent_id_18 FROM category c0_ LEFT JOIN file f1_ ON c0_.image_id = f1_.id WHERE c0_.parent_id IS NULL ORDER BY c0_.position ASC;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.type AS type_2,
  f0_.is_enabled AS is_enabled_3,
  p1_.id AS id_4,
  p1_.name AS name_5,
  p1_.slug AS slug_6,
  p1_.position AS position_7,
  p2_.id AS id_8,
  p2_.name AS name_9,
  p2_.slug AS slug_10,
  p2_.position AS position_11,
  f0_.entity AS entity_12,
  f0_.parameter_id AS parameter_id_13,
  p2_.parameter_id AS parameter_id_14
FROM
  filter_configuration f0_
  LEFT JOIN parameter p1_ ON f0_.parameter_id = p1_.id
  LEFT JOIN parameter_value p2_ ON p1_.id = p2_.parameter_id
WHERE
  (f0_.is_enabled = ?)
  AND f0_.entity IN ('parameter')
ORDER BY
  f0_.name ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.type AS type_2, f0_.is_enabled AS is_enabled_3, p1_.id AS id_4, p1_.name AS name_5, p1_.slug AS slug_6, p1_.position AS position_7, p2_.id AS id_8, p2_.name AS name_9, p2_.slug AS slug_10, p2_.position AS position_11, f0_.entity AS entity_12, f0_.parameter_id AS parameter_id_13, p2_.parameter_id AS parameter_id_14 FROM filter_configuration f0_ LEFT JOIN parameter p1_ ON f0_.parameter_id = p1_.id LEFT JOIN parameter_value p2_ ON p1_.id = p2_.parameter_id WHERE (f0_.is_enabled = 1) AND f0_.entity IN ('parameter') ORDER BY f0_.name ASC;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.type AS type_2,
  f0_.is_enabled AS is_enabled_3,
  v1_.id AS id_4,
  v1_.name AS name_5,
  v1_.slug AS slug_6,
  v1_.type AS type_7,
  v1_.position AS position_8,
  v2_.id AS id_9,
  v2_.name AS name_10,
  v2_.slug AS slug_11,
  v2_.color AS color_12,
  v2_.position AS position_13,
  f0_.entity AS entity_14,
  f0_.variant_id AS variant_id_15,
  v2_.variant_id AS variant_id_16
FROM
  filter_configuration f0_
  LEFT JOIN variant v1_ ON f0_.variant_id = v1_.id
  LEFT JOIN variant_value v2_ ON v1_.id = v2_.variant_id
WHERE
  (f0_.is_enabled = ?)
  AND f0_.entity IN ('variant')
ORDER BY
  f0_.name ASC