Symfony Profiler

Query Metrics

31 Database Queries

21 Different statements

25.95 ms Query time

8 Invalid entities

54 Managed entities

Queries


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 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
"START TRANSACTION"
INSERT INTO cart (id, session_id, status, last_activity_at, email, firstname, lastname, telephone, company_name, cin, vat_id, pickup_point_id, pickup_point_name, note, payment_method, created_at, updated_at, address_street, address_descriptive_number, address_city, address_country, address_zip_code, invoice_street, invoice_descriptive_number, invoice_city, invoice_country, invoice_zip_code, customer_id, shipping_method_id, discount_code_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
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 c0_.id AS id_0 FROM category c0_ WHERE c0_.lft > ? AND c0_.rgt < ? AND c0_.tree_root = ?
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_.image_id AS image_id_9, c0_.tree_root AS tree_root_10, c0_.parent_id AS parent_id_11 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, f1_.id AS id_9, f1_.size AS size_10, f1_.mime_type AS mime_type_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_ 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, f1_.id AS id_9, f1_.size AS size_10, f1_.mime_type AS mime_type_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_ 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, 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
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 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
                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(?)
         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(?)
         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(?)
         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(?)
         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(?)
         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(?)
         AND EXISTS (SELECT 1 FROM product_category pc WHERE pc.product_id = p.id AND pc.category_id = ANY(?)) 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 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 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 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 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 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 s0_.id AS id_0, s0_.position AS position_1, s0_.title AS title_2, s0_.content AS content_3, s0_.link_url AS link_url_4, s0_.link_label AS link_label_5, s0_.is_active AS is_active_6, f1_.id AS id_7, f1_.size AS size_8, f1_.mime_type AS mime_type_9, s0_.image_id AS image_id_10 FROM sidebar_block s0_ LEFT JOIN file f1_ ON s0_.image_id = f1_.id WHERE s0_.is_active = true ORDER BY s0_.position ASC, s0_.id ASC
SELECT f0_.id AS id_0, f0_.position AS position_1, f0_.label AS label_2, f0_.url AS url_3, f0_.is_active AS is_active_4 FROM footer_link f0_ WHERE f0_.is_active = true ORDER BY f0_.position ASC, f0_.id ASC
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.network AS network_2, s0_.url AS url_3, s0_.is_active AS is_active_4 FROM social_link s0_ WHERE s0_.is_active = true ORDER BY s0_.position ASC, s0_.id ASC

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\Category	7
App\Filter\Domain\Entity\FilterConfiguration	6
App\Product\Domain\Entity\ParameterValue	5
App\Frontoffice\Domain\Entity\FooterLink	5
App\Frontoffice\Domain\Entity\SocialLink	4
App\Configuration\Domain\Entity\Currency	3
App\Product\Domain\Entity\Parameter	3
App\Product\Domain\Entity\Variant	3
App\PageBuilder\Domain\Entity\StaticPage	3
App\Configuration\Domain\Entity\ExchangeRate	2
App\File\Domain\Entity\File	2
App\Frontoffice\Domain\Entity\SidebarBlock	2
App\Frontoffice\Domain\Entity\Cart	1

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\Product\Domain\Entity\Category	No errors.
App\PageBuilder\Domain\Entity\StaticPage	No errors.
App\Configuration\Domain\Entity\Currency	No errors.
App\Configuration\Domain\Entity\ExchangeRate	No errors.
App\Localization\Domain\Entity\Language	No errors.
App\Routing\Domain\Entity\RedirectRoute	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\ParameterValue	No errors.
App\Product\Domain\Entity\VariantValue	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\PaymentGate\Domain\Entity\PaymentGateConfiguration	No errors.
App\Shared\Domain\Entity\ServerSideEvent	No errors.
App\Help\Domain\Entity\HelpEntry	No errors.
App\Invoice\Domain\Entity\InvoiceNumberSeries	No errors.
App\Invoice\Domain\Entity\Invoice	No errors.
App\CarrierExport\Domain\Entity\ExportProcess	No errors.
App\Shipping\Domain\Entity\CarrierConfiguration	No errors.
App\Shipping\Domain\Entity\CarrierShippingOption	No errors.
App\Shipping\Domain\Entity\ShippingMethodFee	No errors.
App\Product\Domain\Entity\Parameter	No errors.
App\Product\Domain\Entity\ProductPrice	No errors.
App\Product\Domain\Entity\Variant	No errors.
App\Payment\Domain\Entity\PaymentMethodConfiguration	The field App\Payment\Domain\Entity\PaymentMethodConfiguration#countryConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCountryConfiguration#paymentMethodConfiguration does not contain the required 'inversedBy: "countryConfigurations"' attribute.
App\Payment\Domain\Entity\PaymentMethodBankTransferConfiguration	The field App\Payment\Domain\Entity\PaymentMethodBankTransferConfiguration#countryConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCountryConfiguration#paymentMethodConfiguration does not contain the required 'inversedBy: "countryConfigurations"' attribute. The field App\Payment\Domain\Entity\PaymentMethodBankTransferConfiguration#currencyConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodBankTransferCurrencyConfiguration#paymentMethodBankTransferConfiguration does not contain the required 'inversedBy: "currencyConfigurations"' attribute.
App\Payment\Domain\Entity\PaymentMethodCashOnDeliveryConfiguration	The field App\Payment\Domain\Entity\PaymentMethodCashOnDeliveryConfiguration#countryConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCountryConfiguration#paymentMethodConfiguration does not contain the required 'inversedBy: "countryConfigurations"' attribute. The field App\Payment\Domain\Entity\PaymentMethodCashOnDeliveryConfiguration#countryFees is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCashOnDeliveryCountryConfiguration#paymentMethodCashOnDeliveryConfiguration does not contain the required 'inversedBy: "countryFees"' attribute.
App\Payment\Domain\Entity\PaymentMethodFee	No errors.
App\Payment\Domain\Entity\PaymentMethodPayAtStoreConfiguration	The field App\Payment\Domain\Entity\PaymentMethodPayAtStoreConfiguration#countryConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCountryConfiguration#paymentMethodConfiguration does not contain the required 'inversedBy: "countryConfigurations"' attribute.
App\Payment\Domain\Entity\PaymentMethodPaymentCardConfiguration	The field App\Payment\Domain\Entity\PaymentMethodPaymentCardConfiguration#countryConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCountryConfiguration#paymentMethodConfiguration does not contain the required 'inversedBy: "countryConfigurations"' attribute.
App\Import\Domain\Entity\ExternalIdMapping	No errors.
App\Import\Domain\Entity\ImportLog	No errors.
App\Import\Domain\Entity\ImportSession	No errors.
App\Homepage\Domain\Entity\Homepage	No errors.
App\Homepage\Domain\Entity\HomepageSelectedProduct	No errors.
App\Homepage\Domain\Entity\HomepageSlide	No errors.
App\Order\Domain\Entity\OrderItem	No errors.
App\Order\Domain\Entity\OrderPayment	No errors.
App\Order\Domain\Entity\Order	The field App\Order\Domain\Entity\Order#history is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Order\Domain\Entity\OrderHistory#order does not contain the required 'inversedBy: "history"' attribute. The field App\Order\Domain\Entity\Order#invoice is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Invoice\Domain\Entity\Invoice#order does not contain the required 'inversedBy: "invoice"' attribute. The field App\Order\Domain\Entity\Order#shipment is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Order\Domain\Entity\OrderShipment#order does not contain the required 'inversedBy: "shipment"' attribute.
App\Order\Domain\Entity\OrderStatus	The field App\Order\Domain\Entity\OrderStatus#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Order\Domain\Entity\Order#status does not contain the required 'inversedBy: "orders"' attribute.
App\Configuration\Domain\Entity\Country	No errors.
App\User\Domain\Entity\PasswordResetToken	No errors.
App\User\Domain\Entity\User	No errors.
App\User\Domain\Entity\UserRole	No errors.
App\Frontoffice\Domain\Entity\CartSidebarBlock	No errors.
App\Frontoffice\Domain\Entity\FooterLink	No errors.
App\Frontoffice\Domain\Entity\HamburgerLink	No errors.
App\Frontoffice\Domain\Entity\SidebarBlock	No errors.
App\Frontoffice\Domain\Entity\SocialLink	No errors.
App\Product\Domain\Entity\ProductParameter	No errors.

Symfony Profiler

GET https://dev.slave.scapp.cz/en/6844-hats

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping