Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.public_id AS public_id_1,
  p0_.name AS name_2,
  p0_.description AS description_3,
  p0_.short_description AS short_description_4,
  p0_.code AS code_5,
  p0_.ean AS ean_6,
  p0_.unit AS unit_7,
  p0_.active AS active_8,
  p0_.can_be_bought AS can_be_bought_9,
  p0_.searchable AS searchable_10,
  p0_.show_price AS show_price_11,
  p0_.in_stock_text AS in_stock_text_12,
  p0_.out_of_stock_text AS out_of_stock_text_13,
  p0_.filter_parameter_value_ids AS filter_parameter_value_ids_14,
  p0_.filter_variant_value_ids AS filter_variant_value_ids_15,
  p0_.search_vector_cs AS search_vector_cs_16,
  p0_.search_vector_en AS search_vector_en_17,
  p0_.seo_title AS seo_title_18,
  p0_.seo_description AS seo_description_19,
  p0_.seo_url AS seo_url_20,
  p0_.stock_stock AS stock_stock_21,
  p0_.stock_reserved AS stock_reserved_22,
  p0_.logistic_weight AS logistic_weight_23,
  p0_.logistic_size_width AS logistic_size_width_24,
  p0_.logistic_size_height AS logistic_size_height_25,
  p0_.logistic_size_length AS logistic_size_length_26,
  p0_.price_amount AS price_amount_27,
  p0_.price_currency AS price_currency_28,
  p0_.purchase_price_amount AS purchase_price_amount_29,
  p0_.purchase_price_currency AS purchase_price_currency_30,
  p1_.id AS id_31,
  p1_.code AS code_32,
  p1_.is_default AS is_default_33,
  p1_.weight_modification AS weight_modification_34,
  p1_.price_modification_amount AS price_modification_amount_35,
  p1_.price_modification_currency AS price_modification_currency_36,
  p1_.stock_stock AS stock_stock_37,
  p1_.stock_reserved AS stock_reserved_38,
  v2_.id AS id_39,
  v2_.name AS name_40,
  v2_.slug AS slug_41,
  v2_.color AS color_42,
  v2_.position AS position_43,
  v3_.id AS id_44,
  v3_.name AS name_45,
  v3_.slug AS slug_46,
  v3_.type AS type_47,
  v3_.position AS position_48,
  p4_.id AS id_49,
  p4_.custom_value AS custom_value_50,
  p5_.id AS id_51,
  p5_.name AS name_52,
  p5_.slug AS slug_53,
  p5_.position AS position_54,
  p6_.id AS id_55,
  p6_.name AS name_56,
  p6_.slug AS slug_57,
  p6_.position AS position_58,
  c7_.id AS id_59,
  c7_.public_id AS public_id_60,
  c7_.name AS name_61,
  c7_.slug AS slug_62,
  c7_.description AS description_63,
  c7_.lft AS lft_64,
  c7_.lvl AS lvl_65,
  c7_.rgt AS rgt_66,
  c7_.position AS position_67,
  p8_.id AS id_68,
  p8_.amount AS amount_69,
  p8_.type AS type_70,
  p8_.created_at AS created_at_71,
  p8_.updated_at AS updated_at_72,
  c9_.code AS code_73,
  c9_.is_default AS is_default_74,
  c9_.is_active AS is_active_75,
  c9_.decimal_places AS decimal_places_76,
  p0_.vat_id AS vat_id_77,
  p0_.main_category_id AS main_category_id_78,
  p1_.product_id AS product_id_79,
  v2_.variant_id AS variant_id_80,
  p4_.product_id AS product_id_81,
  p4_.parameter_id AS parameter_id_82,
  p4_.parameter_value_id AS parameter_value_id_83,
  p6_.parameter_id AS parameter_id_84,
  c7_.image_id AS image_id_85,
  c7_.tree_root AS tree_root_86,
  c7_.parent_id AS parent_id_87,
  p8_.product_id AS product_id_88,
  p8_.currency_code AS currency_code_89
FROM
  product p0_
  LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id
  LEFT JOIN product_variant_variant_value p10_ ON p1_.id = p10_.product_variant_id
  LEFT JOIN variant_value v2_ ON v2_.id = p10_.variant_value_id
  LEFT JOIN variant v3_ ON v2_.variant_id = v3_.id
  LEFT JOIN product_parameter p4_ ON p0_.id = p4_.product_id
  LEFT JOIN parameter p5_ ON p4_.parameter_id = p5_.id
  LEFT JOIN parameter_value p6_ ON p4_.parameter_value_id = p6_.id
  LEFT JOIN category c7_ ON p0_.main_category_id = c7_.id
  LEFT JOIN product_price p8_ ON p0_.id = p8_.product_id
  LEFT JOIN currency c9_ ON p8_.currency_code = c9_.code
  INNER JOIN product_category p12_ ON p0_.id = p12_.product_id
  INNER JOIN category c11_ ON c11_.id = p12_.category_id
WHERE
  p0_.active = true
  AND c11_.id IN (?, ?, ?, ?)
ORDER BY
  (p0_.name ->> ?) ASC

SELECT p0_.id AS id_0, p0_.public_id AS public_id_1, p0_.name AS name_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.code AS code_5, p0_.ean AS ean_6, p0_.unit AS unit_7, p0_.active AS active_8, p0_.can_be_bought AS can_be_bought_9, p0_.searchable AS searchable_10, p0_.show_price AS show_price_11, p0_.in_stock_text AS in_stock_text_12, p0_.out_of_stock_text AS out_of_stock_text_13, p0_.filter_parameter_value_ids AS filter_parameter_value_ids_14, p0_.filter_variant_value_ids AS filter_variant_value_ids_15, p0_.search_vector_cs AS search_vector_cs_16, p0_.search_vector_en AS search_vector_en_17, p0_.seo_title AS seo_title_18, p0_.seo_description AS seo_description_19, p0_.seo_url AS seo_url_20, p0_.stock_stock AS stock_stock_21, p0_.stock_reserved AS stock_reserved_22, p0_.logistic_weight AS logistic_weight_23, p0_.logistic_size_width AS logistic_size_width_24, p0_.logistic_size_height AS logistic_size_height_25, p0_.logistic_size_length AS logistic_size_length_26, p0_.price_amount AS price_amount_27, p0_.price_currency AS price_currency_28, p0_.purchase_price_amount AS purchase_price_amount_29, p0_.purchase_price_currency AS purchase_price_currency_30, p1_.id AS id_31, p1_.code AS code_32, p1_.is_default AS is_default_33, p1_.weight_modification AS weight_modification_34, p1_.price_modification_amount AS price_modification_amount_35, p1_.price_modification_currency AS price_modification_currency_36, p1_.stock_stock AS stock_stock_37, p1_.stock_reserved AS stock_reserved_38, v2_.id AS id_39, v2_.name AS name_40, v2_.slug AS slug_41, v2_.color AS color_42, v2_.position AS position_43, v3_.id AS id_44, v3_.name AS name_45, v3_.slug AS slug_46, v3_.type AS type_47, v3_.position AS position_48, p4_.id AS id_49, p4_.custom_value AS custom_value_50, p5_.id AS id_51, p5_.name AS name_52, p5_.slug AS slug_53, p5_.position AS position_54, p6_.id AS id_55, p6_.name AS name_56, p6_.slug AS slug_57, p6_.position AS position_58, c7_.id AS id_59, c7_.public_id AS public_id_60, c7_.name AS name_61, c7_.slug AS slug_62, c7_.description AS description_63, c7_.lft AS lft_64, c7_.lvl AS lvl_65, c7_.rgt AS rgt_66, c7_.position AS position_67, p8_.id AS id_68, p8_.amount AS amount_69, p8_.type AS type_70, p8_.created_at AS created_at_71, p8_.updated_at AS updated_at_72, c9_.code AS code_73, c9_.is_default AS is_default_74, c9_.is_active AS is_active_75, c9_.decimal_places AS decimal_places_76, p0_.vat_id AS vat_id_77, p0_.main_category_id AS main_category_id_78, p1_.product_id AS product_id_79, v2_.variant_id AS variant_id_80, p4_.product_id AS product_id_81, p4_.parameter_id AS parameter_id_82, p4_.parameter_value_id AS parameter_value_id_83, p6_.parameter_id AS parameter_id_84, c7_.image_id AS image_id_85, c7_.tree_root AS tree_root_86, c7_.parent_id AS parent_id_87, p8_.product_id AS product_id_88, p8_.currency_code AS currency_code_89 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN product_variant_variant_value p10_ ON p1_.id = p10_.product_variant_id LEFT JOIN variant_value v2_ ON v2_.id = p10_.variant_value_id LEFT JOIN variant v3_ ON v2_.variant_id = v3_.id LEFT JOIN product_parameter p4_ ON p0_.id = p4_.product_id LEFT JOIN parameter p5_ ON p4_.parameter_id = p5_.id LEFT JOIN parameter_value p6_ ON p4_.parameter_value_id = p6_.id LEFT JOIN category c7_ ON p0_.main_category_id = c7_.id LEFT JOIN product_price p8_ ON p0_.id = p8_.product_id LEFT JOIN currency c9_ ON p8_.currency_code = c9_.code INNER JOIN product_category p12_ ON p0_.id = p12_.product_id INNER JOIN category c11_ ON c11_.id = p12_.category_id WHERE p0_.active = true AND c11_.id IN ('6f4b2a8d-0c7e-4d1f-2b5a-4e9c1d6f7b8a', '7a5c3b9e-1d8f-4e2a-3c6b-5f0d2e7a8c9b', '8b6d4c0f-2e9a-4f3b-4d7c-6a1e3f8b9d0c', '7e5a3f9c-1b8d-4c2e-3a6f-5d0b2c7e8a9f') ORDER BY (p0_.name ->> 'cs') 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_.payment_method AS payment_method_14,
  c0_.created_at AS created_at_15,
  c0_.updated_at AS updated_at_16,
  c0_.address_street AS address_street_17,
  c0_.address_descriptive_number AS address_descriptive_number_18,
  c0_.address_city AS address_city_19,
  c0_.address_country AS address_country_20,
  c0_.address_zip_code AS address_zip_code_21,
  c0_.invoice_street AS invoice_street_22,
  c0_.invoice_descriptive_number AS invoice_descriptive_number_23,
  c0_.invoice_city AS invoice_city_24,
  c0_.invoice_country AS invoice_country_25,
  c0_.invoice_zip_code AS invoice_zip_code_26,
  c1_.id AS id_27,
  c1_.quantity AS quantity_28,
  c1_.created_at AS created_at_29,
  c1_.updated_at AS updated_at_30,
  p2_.id AS id_31,
  p2_.code AS code_32,
  p2_.is_default AS is_default_33,
  p2_.weight_modification AS weight_modification_34,
  p2_.price_modification_amount AS price_modification_amount_35,
  p2_.price_modification_currency AS price_modification_currency_36,
  p2_.stock_stock AS stock_stock_37,
  p2_.stock_reserved AS stock_reserved_38,
  p3_.id AS id_39,
  p3_.public_id AS public_id_40,
  p3_.name AS name_41,
  p3_.description AS description_42,
  p3_.short_description AS short_description_43,
  p3_.code AS code_44,
  p3_.ean AS ean_45,
  p3_.unit AS unit_46,
  p3_.active AS active_47,
  p3_.can_be_bought AS can_be_bought_48,
  p3_.searchable AS searchable_49,
  p3_.show_price AS show_price_50,
  p3_.in_stock_text AS in_stock_text_51,
  p3_.out_of_stock_text AS out_of_stock_text_52,
  p3_.filter_parameter_value_ids AS filter_parameter_value_ids_53,
  p3_.filter_variant_value_ids AS filter_variant_value_ids_54,
  p3_.search_vector_cs AS search_vector_cs_55,
  p3_.search_vector_en AS search_vector_en_56,
  p3_.seo_title AS seo_title_57,
  p3_.seo_description AS seo_description_58,
  p3_.seo_url AS seo_url_59,
  p3_.stock_stock AS stock_stock_60,
  p3_.stock_reserved AS stock_reserved_61,
  p3_.logistic_weight AS logistic_weight_62,
  p3_.logistic_size_width AS logistic_size_width_63,
  p3_.logistic_size_height AS logistic_size_height_64,
  p3_.logistic_size_length AS logistic_size_length_65,
  p3_.price_amount AS price_amount_66,
  p3_.price_currency AS price_currency_67,
  p3_.purchase_price_amount AS purchase_price_amount_68,
  p3_.purchase_price_currency AS purchase_price_currency_69,
  c0_.customer_id AS customer_id_70,
  c0_.shipping_method_id AS shipping_method_id_71,
  c0_.discount_code_id AS discount_code_id_72,
  c1_.cart_id AS cart_id_73,
  c1_.product_variant_id AS product_variant_id_74,
  p2_.product_id AS product_id_75,
  p3_.vat_id AS vat_id_76,
  p3_.main_category_id AS main_category_id_77
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_.payment_method AS payment_method_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.address_street AS address_street_17, c0_.address_descriptive_number AS address_descriptive_number_18, c0_.address_city AS address_city_19, c0_.address_country AS address_country_20, c0_.address_zip_code AS address_zip_code_21, c0_.invoice_street AS invoice_street_22, c0_.invoice_descriptive_number AS invoice_descriptive_number_23, c0_.invoice_city AS invoice_city_24, c0_.invoice_country AS invoice_country_25, c0_.invoice_zip_code AS invoice_zip_code_26, c1_.id AS id_27, c1_.quantity AS quantity_28, c1_.created_at AS created_at_29, c1_.updated_at AS updated_at_30, p2_.id AS id_31, p2_.code AS code_32, p2_.is_default AS is_default_33, p2_.weight_modification AS weight_modification_34, p2_.price_modification_amount AS price_modification_amount_35, p2_.price_modification_currency AS price_modification_currency_36, p2_.stock_stock AS stock_stock_37, p2_.stock_reserved AS stock_reserved_38, p3_.id AS id_39, p3_.public_id AS public_id_40, p3_.name AS name_41, p3_.description AS description_42, p3_.short_description AS short_description_43, p3_.code AS code_44, p3_.ean AS ean_45, p3_.unit AS unit_46, p3_.active AS active_47, p3_.can_be_bought AS can_be_bought_48, p3_.searchable AS searchable_49, p3_.show_price AS show_price_50, p3_.in_stock_text AS in_stock_text_51, p3_.out_of_stock_text AS out_of_stock_text_52, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_53, p3_.filter_variant_value_ids AS filter_variant_value_ids_54, p3_.search_vector_cs AS search_vector_cs_55, p3_.search_vector_en AS search_vector_en_56, p3_.seo_title AS seo_title_57, p3_.seo_description AS seo_description_58, p3_.seo_url AS seo_url_59, p3_.stock_stock AS stock_stock_60, p3_.stock_reserved AS stock_reserved_61, p3_.logistic_weight AS logistic_weight_62, p3_.logistic_size_width AS logistic_size_width_63, p3_.logistic_size_height AS logistic_size_height_64, p3_.logistic_size_length AS logistic_size_length_65, p3_.price_amount AS price_amount_66, p3_.price_currency AS price_currency_67, p3_.purchase_price_amount AS purchase_price_amount_68, p3_.purchase_price_currency AS purchase_price_currency_69, c0_.customer_id AS customer_id_70, c0_.shipping_method_id AS shipping_method_id_71, c0_.discount_code_id AS discount_code_id_72, c1_.cart_id AS cart_id_73, c1_.product_variant_id AS product_variant_id_74, p2_.product_id AS product_id_75, p3_.vat_id AS vat_id_76, p3_.main_category_id AS main_category_id_77 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 = 'd1c82394de2d721893687526b8c9575e' AND c0_.status = 'active' ORDER BY c1_.id 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
  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.image_id AS image_id_10,
  t0.tree_root AS tree_root_11,
  t0.parent_id AS parent_id_12
FROM
  category t0
  INNER JOIN product_category ON t0.id = product_category.category_id
WHERE
  product_category.product_id = ?

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.image_id AS image_id_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = '7d3e9f2b-4c8a-6e1d-9f5a-2b7c4e8d1a6f';

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.code AS code_2,
  d0_.target AS target_3,
  d0_.type AS type_4,
  d0_.value AS value_5,
  d0_.active_from AS active_from_6,
  d0_.active_to AS active_to_7,
  d0_.minimum_quantity AS minimum_quantity_8,
  d0_.active AS active_9,
  p1_.id AS id_10,
  p1_.public_id AS public_id_11,
  p1_.name AS name_12,
  p1_.description AS description_13,
  p1_.short_description AS short_description_14,
  p1_.code AS code_15,
  p1_.ean AS ean_16,
  p1_.unit AS unit_17,
  p1_.active AS active_18,
  p1_.can_be_bought AS can_be_bought_19,
  p1_.searchable AS searchable_20,
  p1_.show_price AS show_price_21,
  p1_.in_stock_text AS in_stock_text_22,
  p1_.out_of_stock_text AS out_of_stock_text_23,
  p1_.filter_parameter_value_ids AS filter_parameter_value_ids_24,
  p1_.filter_variant_value_ids AS filter_variant_value_ids_25,
  p1_.search_vector_cs AS search_vector_cs_26,
  p1_.search_vector_en AS search_vector_en_27,
  p1_.seo_title AS seo_title_28,
  p1_.seo_description AS seo_description_29,
  p1_.seo_url AS seo_url_30,
  p1_.stock_stock AS stock_stock_31,
  p1_.stock_reserved AS stock_reserved_32,
  p1_.logistic_weight AS logistic_weight_33,
  p1_.logistic_size_width AS logistic_size_width_34,
  p1_.logistic_size_height AS logistic_size_height_35,
  p1_.logistic_size_length AS logistic_size_length_36,
  p1_.price_amount AS price_amount_37,
  p1_.price_currency AS price_currency_38,
  p1_.purchase_price_amount AS purchase_price_amount_39,
  p1_.purchase_price_currency AS purchase_price_currency_40,
  p2_.id AS id_41,
  p2_.code AS code_42,
  p2_.is_default AS is_default_43,
  p2_.weight_modification AS weight_modification_44,
  p2_.price_modification_amount AS price_modification_amount_45,
  p2_.price_modification_currency AS price_modification_currency_46,
  p2_.stock_stock AS stock_stock_47,
  p2_.stock_reserved AS stock_reserved_48,
  c3_.id AS id_49,
  c3_.public_id AS public_id_50,
  c3_.name AS name_51,
  c3_.slug AS slug_52,
  c3_.description AS description_53,
  c3_.lft AS lft_54,
  c3_.lvl AS lvl_55,
  c3_.rgt AS rgt_56,
  c3_.position AS position_57,
  d0_.product_id AS product_id_58,
  d0_.product_variant_id AS product_variant_id_59,
  d0_.category_id AS category_id_60,
  d0_.customer_group_id AS customer_group_id_61,
  p1_.vat_id AS vat_id_62,
  p1_.main_category_id AS main_category_id_63,
  p2_.product_id AS product_id_64,
  c3_.image_id AS image_id_65,
  c3_.tree_root AS tree_root_66,
  c3_.parent_id AS parent_id_67
FROM
  discount d0_
  LEFT JOIN product p1_ ON d0_.product_id = p1_.id
  LEFT JOIN product_variant p2_ ON d0_.product_variant_id = p2_.id
  LEFT JOIN category c3_ ON d0_.category_id = c3_.id
WHERE
  d0_.active = ?
  AND d0_.code IS NULL
  AND (
    (
      d0_.active_from IS NULL
      OR d0_.active_from <= ?
    )
  )
  AND (
    (
      d0_.active_to IS NULL
      OR d0_.active_to >= ?
    )
  )
  AND d0_.customer_group_id IS NULL
  AND (
    (
      d0_.target = ?
      AND d0_.product_variant_id IN (?, ?, ?, ?, ?, ?)
    )
    OR (
      d0_.target = ?
      AND d0_.product_id IN (?, ?, ?, ?, ?, ?)
    )
    OR (
      d0_.target = ?
      AND d0_.category_id IN (
        SELECT
          c4_.id
        FROM
          category c4_
        WHERE
          EXISTS (
            SELECT
              c5_.id
            FROM
              category c5_
            WHERE
              c5_.id IN (?, ?, ?)
              AND c5_.tree_root = c4_.tree_root
              AND c5_.lft >= c4_.lft
              AND c5_.rgt <= c4_.rgt
          )
      )
    )
  )

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.code AS code_2, d0_.target AS target_3, d0_.type AS type_4, d0_.value AS value_5, d0_.active_from AS active_from_6, d0_.active_to AS active_to_7, d0_.minimum_quantity AS minimum_quantity_8, d0_.active AS active_9, p1_.id AS id_10, p1_.public_id AS public_id_11, p1_.name AS name_12, p1_.description AS description_13, p1_.short_description AS short_description_14, p1_.code AS code_15, p1_.ean AS ean_16, p1_.unit AS unit_17, p1_.active AS active_18, p1_.can_be_bought AS can_be_bought_19, p1_.searchable AS searchable_20, p1_.show_price AS show_price_21, p1_.in_stock_text AS in_stock_text_22, p1_.out_of_stock_text AS out_of_stock_text_23, p1_.filter_parameter_value_ids AS filter_parameter_value_ids_24, p1_.filter_variant_value_ids AS filter_variant_value_ids_25, p1_.search_vector_cs AS search_vector_cs_26, p1_.search_vector_en AS search_vector_en_27, p1_.seo_title AS seo_title_28, p1_.seo_description AS seo_description_29, p1_.seo_url AS seo_url_30, p1_.stock_stock AS stock_stock_31, p1_.stock_reserved AS stock_reserved_32, p1_.logistic_weight AS logistic_weight_33, p1_.logistic_size_width AS logistic_size_width_34, p1_.logistic_size_height AS logistic_size_height_35, p1_.logistic_size_length AS logistic_size_length_36, p1_.price_amount AS price_amount_37, p1_.price_currency AS price_currency_38, p1_.purchase_price_amount AS purchase_price_amount_39, p1_.purchase_price_currency AS purchase_price_currency_40, p2_.id AS id_41, p2_.code AS code_42, p2_.is_default AS is_default_43, p2_.weight_modification AS weight_modification_44, p2_.price_modification_amount AS price_modification_amount_45, p2_.price_modification_currency AS price_modification_currency_46, p2_.stock_stock AS stock_stock_47, p2_.stock_reserved AS stock_reserved_48, c3_.id AS id_49, c3_.public_id AS public_id_50, c3_.name AS name_51, c3_.slug AS slug_52, c3_.description AS description_53, c3_.lft AS lft_54, c3_.lvl AS lvl_55, c3_.rgt AS rgt_56, c3_.position AS position_57, d0_.product_id AS product_id_58, d0_.product_variant_id AS product_variant_id_59, d0_.category_id AS category_id_60, d0_.customer_group_id AS customer_group_id_61, p1_.vat_id AS vat_id_62, p1_.main_category_id AS main_category_id_63, p2_.product_id AS product_id_64, c3_.image_id AS image_id_65, c3_.tree_root AS tree_root_66, c3_.parent_id AS parent_id_67 FROM discount d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_variant p2_ ON d0_.product_variant_id = p2_.id LEFT JOIN category c3_ ON d0_.category_id = c3_.id WHERE d0_.active = 1 AND d0_.code IS NULL AND ((d0_.active_from IS NULL OR d0_.active_from <= '2026-06-07 22:21:09')) AND ((d0_.active_to IS NULL OR d0_.active_to >= '2026-06-07 22:21:09')) AND d0_.customer_group_id IS NULL AND ((d0_.target = 'product_variant' AND d0_.product_variant_id IN ('32cf1da0-ba4c-45aa-b3a5-7aa8582d8fa5', 'abd44f48-0158-4af7-b6d2-86db62939e76', '45db1a19-1e37-47eb-9db8-d1d1c5f91da2', 'ea3aa338-a8c6-4f0d-867e-99d9e1ca8719', 'f13304bd-341f-47f1-a123-2b6c3a7d9709', '9a116ba3-8f37-4636-8d17-64f07af2b1a7')) OR (d0_.target = 'product' AND d0_.product_id IN ('7d3e9f2b-4c8a-6e1d-9f5a-2b7c4e8d1a6f', '2c5f8e3a-9b1d-4f7c-a6e2-8d4b3c1a5e9f', 'ae83d740-dff6-4b7f-bddc-c29b5cea0e40', '218299ee-b6b4-42cb-8bb2-fad3a1e159a3', 'a9f11ae5-e623-4b09-aae7-b5945dcc3ca5', '5b5eee20-b779-42e1-8f4b-e76935466242')) OR (d0_.target = 'category' AND d0_.category_id IN (SELECT c4_.id FROM category c4_ WHERE EXISTS (SELECT c5_.id FROM category c5_ WHERE c5_.id IN ('6f4b2a8d-0c7e-4d1f-2b5a-4e9c1d6f7b8a', '5c3e1d7a-9f6b-4a0c-1e4d-3b8f0a5c6e7f', '4f2b0a6d-8c5e-4d9f-0b3a-2e7c9d4f5b6a') AND c5_.tree_root = c4_.tree_root AND c5_.lft >= c4_.lft AND c5_.rgt <= c4_.rgt))));

SELECT
  unnested_value :: text as value_id,
  COUNT(*) as count
FROM
  product p,
  LATERAL unnest(p.filter_variant_value_ids) as unnested_value
WHERE
  p.active = true
  AND unnested_value = ANY(?)
  AND EXISTS (
    SELECT
      1
    FROM
      product_category pc
    WHERE
      pc.product_id = p.id
      AND pc.category_id = ANY(?)
  )
GROUP BY
  unnested_value

SELECT
                unnested_value::text as value_id,
                COUNT(*) as count
            FROM product p,
            LATERAL unnest(p.filter_variant_value_ids) as unnested_value
            WHERE p.active = true
            AND unnested_value = ANY('{108dfc9c-413e-41eb-a428-d2aca29bd206,8244b454-3336-4233-92cc-eebde24d2615}')
         AND EXISTS (SELECT 1 FROM product_category pc WHERE pc.product_id = p.id AND pc.category_id = ANY('{6f4b2a8d-0c7e-4d1f-2b5a-4e9c1d6f7b8a,7a5c3b9e-1d8f-4e2a-3c6b-5f0d2e7a8c9b,8b6d4c0f-2e9a-4f3b-4d7c-6a1e3f8b9d0c,7e5a3f9c-1b8d-4c2e-3a6f-5d0b2c7e8a9f}')) GROUP BY unnested_value;

SELECT
  unnested_value :: text as value_id,
  COUNT(*) as count
FROM
  product p,
  LATERAL unnest(p.filter_parameter_value_ids) as unnested_value
WHERE
  p.active = true
  AND unnested_value = ANY(?)
  AND EXISTS (
    SELECT
      1
    FROM
      product_category pc
    WHERE
      pc.product_id = p.id
      AND pc.category_id = ANY(?)
  )
GROUP BY
  unnested_value

SELECT
                unnested_value::text as value_id,
                COUNT(*) as count
            FROM product p,
            LATERAL unnest(p.filter_parameter_value_ids) as unnested_value
            WHERE p.active = true
            AND unnested_value = ANY('{7f904120-f8b3-4566-b409-472698f59584,dd1b5415-c000-494b-92f0-ed10c8b7e16d}')
         AND EXISTS (SELECT 1 FROM product_category pc WHERE pc.product_id = p.id AND pc.category_id = ANY('{6f4b2a8d-0c7e-4d1f-2b5a-4e9c1d6f7b8a,7a5c3b9e-1d8f-4e2a-3c6b-5f0d2e7a8c9b,8b6d4c0f-2e9a-4f3b-4d7c-6a1e3f8b9d0c,7e5a3f9c-1b8d-4c2e-3a6f-5d0b2c7e8a9f}')) GROUP BY unnested_value;

SELECT
  t0.id AS id_1,
  t0.is_main AS is_main_2,
  t0.position AS position_3,
  t0.product_id AS product_id_4,
  t0.file_id AS file_id_5
FROM
  product_image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = '7d3e9f2b-4c8a-6e1d-9f5a-2b7c4e8d1a6f';