GET https://dev.slave.scapp.cz/products?category=womens-tops

Query Metrics

26 Database Queries
16 Different statements
18.83 ms Query time
2 Invalid entities
55 Managed entities

Queries

Group similar statements

# Time Info
1 3.13 ms
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_.name AS name_40, p3_.description AS description_41, p3_.short_description AS short_description_42, p3_.code AS code_43, p3_.ean AS ean_44, p3_.unit AS unit_45, p3_.active AS active_46, p3_.can_be_bought AS can_be_bought_47, p3_.in_stock_text AS in_stock_text_48, p3_.out_of_stock_text AS out_of_stock_text_49, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_50, p3_.filter_variant_value_ids AS filter_variant_value_ids_51, p3_.seo_title AS seo_title_52, p3_.seo_description AS seo_description_53, p3_.seo_url AS seo_url_54, p3_.stock_stock AS stock_stock_55, p3_.stock_reserved AS stock_reserved_56, p3_.logistic_weight AS logistic_weight_57, p3_.logistic_size_width AS logistic_size_width_58, p3_.logistic_size_height AS logistic_size_height_59, p3_.logistic_size_length AS logistic_size_length_60, p3_.price_amount AS price_amount_61, p3_.price_currency AS price_currency_62, p3_.purchase_price_amount AS purchase_price_amount_63, p3_.purchase_price_currency AS purchase_price_currency_64, c0_.customer_id AS customer_id_65, c0_.shipping_method_id AS shipping_method_id_66, c0_.discount_code_id AS discount_code_id_67, c1_.cart_id AS cart_id_68, c1_.product_variant_id AS product_variant_id_69, p2_.product_id AS product_id_70, p3_.vat_id AS vat_id_71, p3_.main_category_id AS main_category_id_72 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
Parameters:
[
  ""
  "active"
]
2 0.68 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.lft AS lft_4, c0_.lvl AS lvl_5, c0_.rgt AS rgt_6, c0_.position AS position_7, f1_.id AS id_8, f1_.size AS size_9, f1_.mime_type AS mime_type_10, c0_.image_id AS image_id_11, c0_.tree_root AS tree_root_12, c0_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN file f1_ ON c0_.image_id = f1_.id WHERE c0_.slug = ?
Parameters:
[
  "womens-tops"
]
3 0.32 ms
SELECT c0_.id AS id_0 FROM category c0_ WHERE c0_.lft > ? AND c0_.rgt < ? AND c0_.tree_root = ?
Parameters:
[
  2
  3
  Symfony\Component\Uid\UuidV4 {#1979
    __toString(): "3a1c9b5e-7d4f-4e8a-9c2b-1f6d8e3a4c5b"
  }
]
4 0.36 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.lft AS lft_4, c0_.lvl AS lvl_5, c0_.rgt AS rgt_6, c0_.position AS position_7, c0_.image_id AS image_id_8, c0_.tree_root AS tree_root_9, c0_.parent_id AS parent_id_10 FROM category c0_ WHERE c0_.lft < ? AND c0_.rgt > ? AND c0_.tree_root = ? ORDER BY c0_.lft ASC
Parameters:
[
  2
  3
  Symfony\Component\Uid\UuidV4 {#1979
    __toString(): "3a1c9b5e-7d4f-4e8a-9c2b-1f6d8e3a4c5b"
  }
]
5 0.32 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.lft AS lft_4, c0_.lvl AS lvl_5, c0_.rgt AS rgt_6, c0_.position AS position_7, f1_.id AS id_8, f1_.size AS size_9, f1_.mime_type AS mime_type_10, c0_.image_id AS image_id_11, c0_.tree_root AS tree_root_12, c0_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN file f1_ ON c0_.image_id = f1_.id WHERE c0_.parent_id = ? ORDER BY c0_.lft ASC
Parameters:
[
  Symfony\Component\Uid\Uuid {#1989
    __toString(): "9a7c5b1e-3d0f-4e4a-5c8b-7f2d4e9a0c1b"
  }
]
6 0.34 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.lft AS lft_4, c0_.lvl AS lvl_5, c0_.rgt AS rgt_6, c0_.position AS position_7, f1_.id AS id_8, f1_.size AS size_9, f1_.mime_type AS mime_type_10, c0_.image_id AS image_id_11, c0_.tree_root AS tree_root_12, c0_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN file f1_ ON c0_.image_id = f1_.id WHERE c0_.parent_id IS NULL ORDER BY c0_.position ASC
Parameters:
[]
7 0.80 ms
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, p2_.id AS id_7, p2_.name AS name_8, p2_.slug AS slug_9, f0_.entity AS entity_10, f0_.parameter_id AS parameter_id_11, p2_.parameter_id AS parameter_id_12 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
Parameters:
[
  1
]
8 0.63 ms
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, v2_.id AS id_8, v2_.name AS name_9, v2_.slug AS slug_10, v2_.color AS color_11, f0_.entity AS entity_12, f0_.variant_id AS variant_id_13, v2_.variant_id AS variant_id_14 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
Parameters:
[
  1
]
9 2.45 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.short_description AS short_description_3, p0_.code AS code_4, p0_.ean AS ean_5, p0_.unit AS unit_6, p0_.active AS active_7, p0_.can_be_bought AS can_be_bought_8, p0_.in_stock_text AS in_stock_text_9, p0_.out_of_stock_text AS out_of_stock_text_10, p0_.filter_parameter_value_ids AS filter_parameter_value_ids_11, p0_.filter_variant_value_ids AS filter_variant_value_ids_12, p0_.seo_title AS seo_title_13, p0_.seo_description AS seo_description_14, p0_.seo_url AS seo_url_15, p0_.stock_stock AS stock_stock_16, p0_.stock_reserved AS stock_reserved_17, p0_.logistic_weight AS logistic_weight_18, p0_.logistic_size_width AS logistic_size_width_19, p0_.logistic_size_height AS logistic_size_height_20, p0_.logistic_size_length AS logistic_size_length_21, p0_.price_amount AS price_amount_22, p0_.price_currency AS price_currency_23, p0_.purchase_price_amount AS purchase_price_amount_24, p0_.purchase_price_currency AS purchase_price_currency_25, p1_.id AS id_26, p1_.code AS code_27, p1_.is_default AS is_default_28, p1_.weight_modification AS weight_modification_29, p1_.price_modification_amount AS price_modification_amount_30, p1_.price_modification_currency AS price_modification_currency_31, p1_.stock_stock AS stock_stock_32, p1_.stock_reserved AS stock_reserved_33, v2_.id AS id_34, v2_.name AS name_35, v2_.slug AS slug_36, v2_.color AS color_37, v3_.id AS id_38, v3_.name AS name_39, v3_.slug AS slug_40, v3_.type AS type_41, p4_.id AS id_42, p4_.custom_value AS custom_value_43, p5_.id AS id_44, p5_.name AS name_45, p5_.slug AS slug_46, p6_.id AS id_47, p6_.name AS name_48, p6_.slug AS slug_49, p0_.vat_id AS vat_id_50, p0_.main_category_id AS main_category_id_51, p1_.product_id AS product_id_52, v2_.variant_id AS variant_id_53, p4_.product_id AS product_id_54, p4_.parameter_id AS parameter_id_55, p4_.parameter_value_id AS parameter_value_id_56, p6_.parameter_id AS parameter_id_57 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN product_variant_variant_value p7_ ON p1_.id = p7_.product_variant_id LEFT JOIN variant_value v2_ ON v2_.id = p7_.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 INNER JOIN product_category p9_ ON p0_.id = p9_.product_id INNER JOIN category c8_ ON c8_.id = p9_.category_id WHERE c8_.id IN (?) ORDER BY p0_.name ASC
Parameters:
[
  "9a7c5b1e-3d0f-4e4a-5c8b-7f2d4e9a0c1b"
]
10 0.75 ms
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_.name AS name_40, p3_.description AS description_41, p3_.short_description AS short_description_42, p3_.code AS code_43, p3_.ean AS ean_44, p3_.unit AS unit_45, p3_.active AS active_46, p3_.can_be_bought AS can_be_bought_47, p3_.in_stock_text AS in_stock_text_48, p3_.out_of_stock_text AS out_of_stock_text_49, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_50, p3_.filter_variant_value_ids AS filter_variant_value_ids_51, p3_.seo_title AS seo_title_52, p3_.seo_description AS seo_description_53, p3_.seo_url AS seo_url_54, p3_.stock_stock AS stock_stock_55, p3_.stock_reserved AS stock_reserved_56, p3_.logistic_weight AS logistic_weight_57, p3_.logistic_size_width AS logistic_size_width_58, p3_.logistic_size_height AS logistic_size_height_59, p3_.logistic_size_length AS logistic_size_length_60, p3_.price_amount AS price_amount_61, p3_.price_currency AS price_currency_62, p3_.purchase_price_amount AS purchase_price_amount_63, p3_.purchase_price_currency AS purchase_price_currency_64, c0_.customer_id AS customer_id_65, c0_.shipping_method_id AS shipping_method_id_66, c0_.discount_code_id AS discount_code_id_67, c1_.cart_id AS cart_id_68, c1_.product_variant_id AS product_variant_id_69, p2_.product_id AS product_id_70, p3_.vat_id AS vat_id_71, p3_.main_category_id AS main_category_id_72 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
Parameters:
[
  ""
  "active"
]
11 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.position AS position_8, t0.image_id AS image_id_9, t0.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
Parameters:
[
  "7a79ea94-236b-4062-a3b5-5a047d63c05f"
]
12 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.position AS position_8, t0.image_id AS image_id_9, t0.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
Parameters:
[
  "3fdfb7bc-49b9-46b9-9431-366c90e2605e"
]
13 1.50 ms
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_.name AS name_11, p1_.description AS description_12, p1_.short_description AS short_description_13, p1_.code AS code_14, p1_.ean AS ean_15, p1_.unit AS unit_16, p1_.active AS active_17, p1_.can_be_bought AS can_be_bought_18, p1_.in_stock_text AS in_stock_text_19, p1_.out_of_stock_text AS out_of_stock_text_20, p1_.filter_parameter_value_ids AS filter_parameter_value_ids_21, p1_.filter_variant_value_ids AS filter_variant_value_ids_22, p1_.seo_title AS seo_title_23, p1_.seo_description AS seo_description_24, p1_.seo_url AS seo_url_25, p1_.stock_stock AS stock_stock_26, p1_.stock_reserved AS stock_reserved_27, p1_.logistic_weight AS logistic_weight_28, p1_.logistic_size_width AS logistic_size_width_29, p1_.logistic_size_height AS logistic_size_height_30, p1_.logistic_size_length AS logistic_size_length_31, p1_.price_amount AS price_amount_32, p1_.price_currency AS price_currency_33, p1_.purchase_price_amount AS purchase_price_amount_34, p1_.purchase_price_currency AS purchase_price_currency_35, p2_.id AS id_36, p2_.code AS code_37, p2_.is_default AS is_default_38, p2_.weight_modification AS weight_modification_39, p2_.price_modification_amount AS price_modification_amount_40, p2_.price_modification_currency AS price_modification_currency_41, p2_.stock_stock AS stock_stock_42, p2_.stock_reserved AS stock_reserved_43, c3_.id AS id_44, c3_.name AS name_45, c3_.slug AS slug_46, c3_.description AS description_47, c3_.lft AS lft_48, c3_.lvl AS lvl_49, c3_.rgt AS rgt_50, c3_.position AS position_51, d0_.product_id AS product_id_52, d0_.product_variant_id AS product_variant_id_53, d0_.category_id AS category_id_54, d0_.customer_group_id AS customer_group_id_55, p1_.vat_id AS vat_id_56, p1_.main_category_id AS main_category_id_57, p2_.product_id AS product_id_58, c3_.image_id AS image_id_59, c3_.tree_root AS tree_root_60, c3_.parent_id AS parent_id_61 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))))
Parameters:
[
  1
  "2026-03-09 18:03:44"
  "2026-03-09 18:03:44"
  "product_variant"
  "963d5d1c-f36f-4250-8251-f97adc6a20b1"
  "55b6cd4b-96e8-41c7-aeb1-6551e67f8303"
  "product"
  "7a79ea94-236b-4062-a3b5-5a047d63c05f"
  "3fdfb7bc-49b9-46b9-9431-366c90e2605e"
  "category"
  "9a7c5b1e-3d0f-4e4a-5c8b-7f2d4e9a0c1b"
]
14 0.79 ms
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
Parameters:
[
  "{7f904120-f8b3-4566-b409-472698f59584,dd1b5415-c000-494b-92f0-ed10c8b7e16d}"
  "{9a7c5b1e-3d0f-4e4a-5c8b-7f2d4e9a0c1b}"
]
15 0.44 ms
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
Parameters:
[
  "{8e85442d-8616-48ff-8b24-2e8aec165027,77d73b6e-ba4c-461c-a022-d80f824b116b,bf3d495a-37c3-4c0a-8f61-fed434ff2d13}"
  "{9a7c5b1e-3d0f-4e4a-5c8b-7f2d4e9a0c1b}"
]
16 0.42 ms
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
Parameters:
[
  "{85af27eb-5e1b-49de-a509-fafe5e3549bf,1def715c-1870-4847-8398-1077d75d1e2f}"
  "{9a7c5b1e-3d0f-4e4a-5c8b-7f2d4e9a0c1b}"
]
17 0.41 ms
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
Parameters:
[
  "{9b880df1-482c-4f0e-ac91-304c0554dd93,8a6a4c62-3a9a-47fa-8935-5b2c8edef512,63a4b4eb-5b5d-48a1-94a7-7af3764f5642}"
  "{9a7c5b1e-3d0f-4e4a-5c8b-7f2d4e9a0c1b}"
]
18 0.45 ms
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
Parameters:
[
  "{7efc6872-b156-4bf2-afb8-33d03ede6097,cbb9595f-a34d-4ddc-aa9b-e58e92bf8cf4,cef1c56c-c574-4e6b-a3f7-7643f0376f35}"
  "{9a7c5b1e-3d0f-4e4a-5c8b-7f2d4e9a0c1b}"
]
19 0.42 ms
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
Parameters:
[
  "{7f904120-f8b3-4566-b409-472698f59584,dd1b5415-c000-494b-92f0-ed10c8b7e16d,8e85442d-8616-48ff-8b24-2e8aec165027,77d73b6e-ba4c-461c-a022-d80f824b116b,bf3d495a-37c3-4c0a-8f61-fed434ff2d13}"
  "{9a7c5b1e-3d0f-4e4a-5c8b-7f2d4e9a0c1b}"
]
20 0.45 ms
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
Parameters:
[
  "{85af27eb-5e1b-49de-a509-fafe5e3549bf,1def715c-1870-4847-8398-1077d75d1e2f,9b880df1-482c-4f0e-ac91-304c0554dd93,8a6a4c62-3a9a-47fa-8935-5b2c8edef512,63a4b4eb-5b5d-48a1-94a7-7af3764f5642,7efc6872-b156-4bf2-afb8-33d03ede6097,cbb9595f-a34d-4ddc-aa9b-e58e92bf8cf4,cef1c56c-c574-4e6b-a3f7-7643f0376f35}"
  "{9a7c5b1e-3d0f-4e4a-5c8b-7f2d4e9a0c1b}"
]
21 0.56 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.show_contact_form AS show_contact_form_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.seo_title AS seo_title_7, s0_.seo_description AS seo_description_8, s0_.seo_url AS seo_url_9 FROM static_page s0_ ORDER BY s0_.title ASC
Parameters:
[]
22 0.49 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.show_contact_form AS show_contact_form_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.seo_title AS seo_title_7, s0_.seo_description AS seo_description_8, s0_.seo_url AS seo_url_9 FROM static_page s0_ ORDER BY s0_.title ASC
Parameters:
[]
23 1.24 ms
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 = ?
Parameters:
[
  "7a79ea94-236b-4062-a3b5-5a047d63c05f"
]
24 0.41 ms
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3 FROM file t0 WHERE t0.id = ?
Parameters:
[
  "f34410e4-6b10-4cd6-955b-b2b0a5ade713"
]
25 0.43 ms
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 = ?
Parameters:
[
  "3fdfb7bc-49b9-46b9-9431-366c90e2605e"
]
26 0.41 ms
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3 FROM file t0 WHERE t0.id = ?
Parameters:
[
  "f5e5078f-097e-4f59-aae9-3550912b6808"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Product\Domain\Entity\VariantValue 8
App\Product\Domain\Entity\ProductVariant 8
App\Product\Domain\Entity\Category 7
App\Filter\Domain\Entity\FilterConfiguration 6
App\Product\Domain\Entity\ParameterValue 5
App\File\Domain\Entity\File 4
App\Product\Domain\Entity\Parameter 3
App\Product\Domain\Entity\Variant 3
App\PageBuilder\Domain\Entity\StaticPage 3
App\Frontoffice\Domain\Entity\Cart 2
App\Product\Domain\Entity\Product 2
App\Accounting\Domain\Entity\TaxRate 2
App\Product\Domain\Entity\ProductImage 2

Entities Mapping

Class Mapping errors
App\Configuration\Domain\Entity\Configuration No errors.
App\SEO\Domain\Entity\SEO No errors.
App\Product\Domain\Entity\Stock No errors.
App\Logistic\Domain\Entity\Size No errors.
App\Logistic\Domain\Entity\Logistic No errors.
App\Shared\Domain\Entity\Price No errors.
App\Product\Domain\Entity\Product No errors.
App\Filter\Domain\Entity\FilterConfiguration No errors.
App\Filter\Domain\Entity\ParameterFilterConfiguration No errors.
App\Filter\Domain\Entity\VariantFilterConfiguration No errors.
App\Product\Domain\Entity\Category No errors.
App\Discount\Domain\Entity\Discount No errors.
App\Shared\Domain\Entity\Address No errors.
App\Frontoffice\Domain\Entity\Cart No errors.
App\Frontoffice\Domain\Entity\CartItem No errors.
App\Shared\Domain\Entity\NullablePrice No errors.
App\Product\Domain\Entity\ProductVariant No errors.
App\Customer\Domain\Entity\Customer No errors.
App\Shipping\Domain\Entity\ShippingMethod
  • The field App\Shipping\Domain\Entity\ShippingMethod#fees is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Shipping\Domain\Entity\ShippingMethodFee#shippingMethod does not contain the required 'inversedBy: "fees"' attribute.
App\Accounting\Domain\Entity\TaxRate No errors.
App\File\Domain\Entity\File No errors.
App\Product\Domain\Entity\Parameter No errors.
App\Product\Domain\Entity\ParameterValue No errors.
App\Product\Domain\Entity\ProductParameter No errors.
App\Product\Domain\Entity\Variant No errors.
App\Product\Domain\Entity\VariantValue No errors.
App\Product\Domain\Entity\ProductImage No errors.
App\Product\Domain\Entity\ProductFile No errors.
App\Customer\Domain\Entity\CustomerGroup
  • The field 'App\Customer\Domain\Entity\CustomerGroup#discount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\PageBuilder\Domain\Entity\StaticPage No errors.