Symfony Profiler

SELECT
  CASE WHEN c0_.position IS NULL THEN
    1
  ELSE
    0
  END AS sclr_0,
  p1_.id AS id_1,
  p1_.public_id AS public_id_2,
  p1_.name AS name_3,
  p1_.description AS description_4,
  p1_.short_description AS short_description_5,
  p1_.code AS code_6,
  p1_.ean AS ean_7,
  p1_.unit AS unit_8,
  p1_.active AS active_9,
  p1_.can_be_bought AS can_be_bought_10,
  p1_.searchable AS searchable_11,
  p1_.show_price AS show_price_12,
  p1_.in_stock_text AS in_stock_text_13,
  p1_.out_of_stock_text AS out_of_stock_text_14,
  p1_.filter_parameter_value_ids AS filter_parameter_value_ids_15,
  p1_.filter_variant_value_ids AS filter_variant_value_ids_16,
  p1_.search_vector_cs AS search_vector_cs_17,
  p1_.search_vector_en AS search_vector_en_18,
  p1_.seo_title AS seo_title_19,
  p1_.seo_description AS seo_description_20,
  p1_.seo_url AS seo_url_21,
  p1_.stock_stock AS stock_stock_22,
  p1_.stock_reserved AS stock_reserved_23,
  p1_.logistic_weight AS logistic_weight_24,
  p1_.logistic_size_width AS logistic_size_width_25,
  p1_.logistic_size_height AS logistic_size_height_26,
  p1_.logistic_size_length AS logistic_size_length_27,
  p1_.price_amount AS price_amount_28,
  p1_.price_currency AS price_currency_29,
  p1_.purchase_price_amount AS purchase_price_amount_30,
  p1_.purchase_price_currency AS purchase_price_currency_31,
  p2_.id AS id_32,
  p2_.code AS code_33,
  p2_.is_default AS is_default_34,
  p2_.weight_modification AS weight_modification_35,
  p2_.price_modification_amount AS price_modification_amount_36,
  p2_.price_modification_currency AS price_modification_currency_37,
  p2_.stock_stock AS stock_stock_38,
  p2_.stock_reserved AS stock_reserved_39,
  v3_.id AS id_40,
  v3_.name AS name_41,
  v3_.slug AS slug_42,
  v3_.color AS color_43,
  v3_.position AS position_44,
  v4_.id AS id_45,
  v4_.name AS name_46,
  v4_.slug AS slug_47,
  v4_.type AS type_48,
  v4_.position AS position_49,
  p5_.id AS id_50,
  p5_.custom_value AS custom_value_51,
  p6_.id AS id_52,
  p6_.name AS name_53,
  p6_.slug AS slug_54,
  p6_.position AS position_55,
  p7_.id AS id_56,
  p7_.name AS name_57,
  p7_.slug AS slug_58,
  p7_.position AS position_59,
  c8_.id AS id_60,
  c8_.public_id AS public_id_61,
  c8_.name AS name_62,
  c8_.slug AS slug_63,
  c8_.description AS description_64,
  c8_.lft AS lft_65,
  c8_.lvl AS lvl_66,
  c8_.rgt AS rgt_67,
  c8_.position AS position_68,
  p9_.id AS id_69,
  p9_.amount AS amount_70,
  p9_.type AS type_71,
  p9_.created_at AS created_at_72,
  p9_.updated_at AS updated_at_73,
  c10_.code AS code_74,
  c10_.is_default AS is_default_75,
  c10_.is_active AS is_active_76,
  c10_.decimal_places AS decimal_places_77,
  p1_.vat_id AS vat_id_78,
  p1_.main_category_id AS main_category_id_79,
  p2_.product_id AS product_id_80,
  v3_.variant_id AS variant_id_81,
  p5_.product_id AS product_id_82,
  p5_.parameter_id AS parameter_id_83,
  p5_.parameter_value_id AS parameter_value_id_84,
  p7_.parameter_id AS parameter_id_85,
  c8_.image_id AS image_id_86,
  c8_.tree_root AS tree_root_87,
  c8_.parent_id AS parent_id_88,
  p9_.product_id AS product_id_89,
  p9_.currency_code AS currency_code_90
FROM
  product p1_
  LEFT JOIN product_variant p2_ ON p1_.id = p2_.product_id
  LEFT JOIN product_variant_variant_value p11_ ON p2_.id = p11_.product_variant_id
  LEFT JOIN variant_value v3_ ON v3_.id = p11_.variant_value_id
  LEFT JOIN variant v4_ ON v3_.variant_id = v4_.id
  LEFT JOIN product_parameter p5_ ON p1_.id = p5_.product_id
  LEFT JOIN parameter p6_ ON p5_.parameter_id = p6_.id
  LEFT JOIN parameter_value p7_ ON p5_.parameter_value_id = p7_.id
  LEFT JOIN category c8_ ON p1_.main_category_id = c8_.id
  LEFT JOIN product_price p9_ ON p1_.id = p9_.product_id
  LEFT JOIN currency c10_ ON p9_.currency_code = c10_.code
  INNER JOIN product_category p13_ ON p1_.id = p13_.product_id
  INNER JOIN category c12_ ON c12_.id = p13_.category_id
  LEFT JOIN category_product_position c0_ ON (
    c0_.product_id = p1_.id
    AND c0_.category_id = ?
  )
WHERE
  p1_.active = true
  AND (
    SELECT
      COUNT(*)
    FROM
      product_category p14_
    WHERE
      p14_.product_id = p1_.id
  ) > 0
  AND c12_.id IN (?)
ORDER BY
  sclr_0 ASC,
  c0_.position ASC,
  (p1_.name ->> ?) ASC

SELECT CASE WHEN c0_.position IS NULL THEN 1 ELSE 0 END AS sclr_0, p1_.id AS id_1, p1_.public_id AS public_id_2, p1_.name AS name_3, p1_.description AS description_4, p1_.short_description AS short_description_5, p1_.code AS code_6, p1_.ean AS ean_7, p1_.unit AS unit_8, p1_.active AS active_9, p1_.can_be_bought AS can_be_bought_10, p1_.searchable AS searchable_11, p1_.show_price AS show_price_12, p1_.in_stock_text AS in_stock_text_13, p1_.out_of_stock_text AS out_of_stock_text_14, p1_.filter_parameter_value_ids AS filter_parameter_value_ids_15, p1_.filter_variant_value_ids AS filter_variant_value_ids_16, p1_.search_vector_cs AS search_vector_cs_17, p1_.search_vector_en AS search_vector_en_18, p1_.seo_title AS seo_title_19, p1_.seo_description AS seo_description_20, p1_.seo_url AS seo_url_21, p1_.stock_stock AS stock_stock_22, p1_.stock_reserved AS stock_reserved_23, p1_.logistic_weight AS logistic_weight_24, p1_.logistic_size_width AS logistic_size_width_25, p1_.logistic_size_height AS logistic_size_height_26, p1_.logistic_size_length AS logistic_size_length_27, p1_.price_amount AS price_amount_28, p1_.price_currency AS price_currency_29, p1_.purchase_price_amount AS purchase_price_amount_30, p1_.purchase_price_currency AS purchase_price_currency_31, p2_.id AS id_32, p2_.code AS code_33, p2_.is_default AS is_default_34, p2_.weight_modification AS weight_modification_35, p2_.price_modification_amount AS price_modification_amount_36, p2_.price_modification_currency AS price_modification_currency_37, p2_.stock_stock AS stock_stock_38, p2_.stock_reserved AS stock_reserved_39, v3_.id AS id_40, v3_.name AS name_41, v3_.slug AS slug_42, v3_.color AS color_43, v3_.position AS position_44, v4_.id AS id_45, v4_.name AS name_46, v4_.slug AS slug_47, v4_.type AS type_48, v4_.position AS position_49, p5_.id AS id_50, p5_.custom_value AS custom_value_51, p6_.id AS id_52, p6_.name AS name_53, p6_.slug AS slug_54, p6_.position AS position_55, p7_.id AS id_56, p7_.name AS name_57, p7_.slug AS slug_58, p7_.position AS position_59, c8_.id AS id_60, c8_.public_id AS public_id_61, c8_.name AS name_62, c8_.slug AS slug_63, c8_.description AS description_64, c8_.lft AS lft_65, c8_.lvl AS lvl_66, c8_.rgt AS rgt_67, c8_.position AS position_68, p9_.id AS id_69, p9_.amount AS amount_70, p9_.type AS type_71, p9_.created_at AS created_at_72, p9_.updated_at AS updated_at_73, c10_.code AS code_74, c10_.is_default AS is_default_75, c10_.is_active AS is_active_76, c10_.decimal_places AS decimal_places_77, p1_.vat_id AS vat_id_78, p1_.main_category_id AS main_category_id_79, p2_.product_id AS product_id_80, v3_.variant_id AS variant_id_81, p5_.product_id AS product_id_82, p5_.parameter_id AS parameter_id_83, p5_.parameter_value_id AS parameter_value_id_84, p7_.parameter_id AS parameter_id_85, c8_.image_id AS image_id_86, c8_.tree_root AS tree_root_87, c8_.parent_id AS parent_id_88, p9_.product_id AS product_id_89, p9_.currency_code AS currency_code_90 FROM product p1_ LEFT JOIN product_variant p2_ ON p1_.id = p2_.product_id LEFT JOIN product_variant_variant_value p11_ ON p2_.id = p11_.product_variant_id LEFT JOIN variant_value v3_ ON v3_.id = p11_.variant_value_id LEFT JOIN variant v4_ ON v3_.variant_id = v4_.id LEFT JOIN product_parameter p5_ ON p1_.id = p5_.product_id LEFT JOIN parameter p6_ ON p5_.parameter_id = p6_.id LEFT JOIN parameter_value p7_ ON p5_.parameter_value_id = p7_.id LEFT JOIN category c8_ ON p1_.main_category_id = c8_.id LEFT JOIN product_price p9_ ON p1_.id = p9_.product_id LEFT JOIN currency c10_ ON p9_.currency_code = c10_.code INNER JOIN product_category p13_ ON p1_.id = p13_.product_id INNER JOIN category c12_ ON c12_.id = p13_.category_id LEFT JOIN category_product_position c0_ ON (c0_.product_id = p1_.id AND c0_.category_id = '0d8f6e2b-4a1c-4b5d-6f9e-8c3a5b0d1f2e') WHERE p1_.active = true AND (SELECT COUNT(*) FROM product_category p14_ WHERE p14_.product_id = p1_.id) > 0 AND c12_.id IN ('0d8f6e2b-4a1c-4b5d-6f9e-8c3a5b0d1f2e') ORDER BY sclr_0 ASC, c0_.position ASC, (p1_.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 = '868ab0551557c840fccf84b0eb49c2fe' 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
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.image_id AS image_id_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.public_id = '9145' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.public_id AS public_id_1,
  s0_.title AS title_2,
  s0_.slug AS slug_3,
  s0_.content AS content_4,
  s0_.show_contact_form AS show_contact_form_5,
  s0_.active AS active_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s0_.seo_title AS seo_title_9,
  s0_.seo_description AS seo_description_10,
  s0_.seo_url AS seo_url_11
FROM
  static_page s0_
WHERE
  s0_.active = true
ORDER BY
  s0_.created_at ASC

SELECT s0_.id AS id_0, s0_.public_id AS public_id_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.content AS content_4, s0_.show_contact_form AS show_contact_form_5, s0_.active AS active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.seo_title AS seo_title_9, s0_.seo_description AS seo_description_10, s0_.seo_url AS seo_url_11 FROM static_page s0_ WHERE s0_.active = true ORDER BY s0_.created_at 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 ORDER BY c0_.is_default DESC, c0_.code ASC;

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('{6fbf9bb2-99ad-4078-9225-439fcef7824e,55308aae-972f-4347-8591-e2f032497d39}')
         AND EXISTS (SELECT 1 FROM product_category pc WHERE pc.product_id = p.id AND pc.category_id = ANY('{0d8f6e2b-4a1c-4b5d-6f9e-8c3a5b0d1f2e}')) 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('{0d8f6e2b-4a1c-4b5d-6f9e-8c3a5b0d1f2e}')) GROUP BY unnested_value;

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
FROM
  category c0_
ORDER BY
  c0_.tree_root ASC,
  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 FROM category c0_ ORDER BY c0_.tree_root ASC, c0_.lft ASC;

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
  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;