Symfony Profiler

Query Metrics

30 Database Queries

14 Different statements

25.50 ms Query time

2 Invalid entities

39 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 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 = ?
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id ORDER BY c0_.is_default DESC, c0_.code ASC
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.newsletter_consent AS newsletter_consent_14, c0_.gdpr_consent AS gdpr_consent_15, c0_.payment_method AS payment_method_16, c0_.tracking_heureka_opt_out AS tracking_heureka_opt_out_17, c0_.tracking_zbozi_opt_in AS tracking_zbozi_opt_in_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.address_street AS address_street_21, c0_.address_descriptive_number AS address_descriptive_number_22, c0_.address_city AS address_city_23, c0_.address_country AS address_country_24, c0_.address_zip_code AS address_zip_code_25, c0_.invoice_street AS invoice_street_26, c0_.invoice_descriptive_number AS invoice_descriptive_number_27, c0_.invoice_city AS invoice_city_28, c0_.invoice_country AS invoice_country_29, c0_.invoice_zip_code AS invoice_zip_code_30, c1_.id AS id_31, c1_.quantity AS quantity_32, c1_.is_gift AS is_gift_33, c1_.created_at AS created_at_34, c1_.updated_at AS updated_at_35, p2_.id AS id_36, p2_.public_id AS public_id_37, p2_.code AS code_38, p2_.is_default AS is_default_39, p2_.weight_modification AS weight_modification_40, p2_.price_modification_amount AS price_modification_amount_41, p2_.price_modification_currency AS price_modification_currency_42, p2_.stock_stock AS stock_stock_43, p2_.stock_reserved AS stock_reserved_44, p3_.id AS id_45, p3_.public_id AS public_id_46, p3_.name AS name_47, p3_.description AS description_48, p3_.short_description AS short_description_49, p3_.code AS code_50, p3_.ean AS ean_51, p3_.unit AS unit_52, p3_.active AS active_53, p3_.can_be_bought AS can_be_bought_54, p3_.searchable AS searchable_55, p3_.show_price AS show_price_56, p3_.in_stock_text AS in_stock_text_57, p3_.out_of_stock_text AS out_of_stock_text_58, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_59, p3_.filter_variant_value_ids AS filter_variant_value_ids_60, p3_.search_vector_cs AS search_vector_cs_61, p3_.search_vector_en AS search_vector_en_62, p3_.seo_title AS seo_title_63, p3_.seo_description AS seo_description_64, p3_.seo_url AS seo_url_65, p3_.stock_stock AS stock_stock_66, p3_.stock_reserved AS stock_reserved_67, p3_.logistic_weight AS logistic_weight_68, p3_.logistic_size_width AS logistic_size_width_69, p3_.logistic_size_height AS logistic_size_height_70, p3_.logistic_size_length AS logistic_size_length_71, p3_.price_amount AS price_amount_72, p3_.price_currency AS price_currency_73, p3_.purchase_price_amount AS purchase_price_amount_74, p3_.purchase_price_currency AS purchase_price_currency_75, c0_.customer_id AS customer_id_76, c0_.shipping_method_id AS shipping_method_id_77, c0_.discount_code_id AS discount_code_id_78, c1_.cart_id AS cart_id_79, c1_.product_variant_id AS product_variant_id_80, p2_.product_id AS product_id_81, p3_.vat_id AS vat_id_82, p3_.main_category_id AS main_category_id_83 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.session_id = ? AND c0_.status = ? ORDER BY c1_.id ASC
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.newsletter_consent AS newsletter_consent_14, c0_.gdpr_consent AS gdpr_consent_15, c0_.payment_method AS payment_method_16, c0_.tracking_heureka_opt_out AS tracking_heureka_opt_out_17, c0_.tracking_zbozi_opt_in AS tracking_zbozi_opt_in_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.address_street AS address_street_21, c0_.address_descriptive_number AS address_descriptive_number_22, c0_.address_city AS address_city_23, c0_.address_country AS address_country_24, c0_.address_zip_code AS address_zip_code_25, c0_.invoice_street AS invoice_street_26, c0_.invoice_descriptive_number AS invoice_descriptive_number_27, c0_.invoice_city AS invoice_city_28, c0_.invoice_country AS invoice_country_29, c0_.invoice_zip_code AS invoice_zip_code_30, c1_.id AS id_31, c1_.quantity AS quantity_32, c1_.is_gift AS is_gift_33, c1_.created_at AS created_at_34, c1_.updated_at AS updated_at_35, p2_.id AS id_36, p2_.public_id AS public_id_37, p2_.code AS code_38, p2_.is_default AS is_default_39, p2_.weight_modification AS weight_modification_40, p2_.price_modification_amount AS price_modification_amount_41, p2_.price_modification_currency AS price_modification_currency_42, p2_.stock_stock AS stock_stock_43, p2_.stock_reserved AS stock_reserved_44, p3_.id AS id_45, p3_.public_id AS public_id_46, p3_.name AS name_47, p3_.description AS description_48, p3_.short_description AS short_description_49, p3_.code AS code_50, p3_.ean AS ean_51, p3_.unit AS unit_52, p3_.active AS active_53, p3_.can_be_bought AS can_be_bought_54, p3_.searchable AS searchable_55, p3_.show_price AS show_price_56, p3_.in_stock_text AS in_stock_text_57, p3_.out_of_stock_text AS out_of_stock_text_58, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_59, p3_.filter_variant_value_ids AS filter_variant_value_ids_60, p3_.search_vector_cs AS search_vector_cs_61, p3_.search_vector_en AS search_vector_en_62, p3_.seo_title AS seo_title_63, p3_.seo_description AS seo_description_64, p3_.seo_url AS seo_url_65, p3_.stock_stock AS stock_stock_66, p3_.stock_reserved AS stock_reserved_67, p3_.logistic_weight AS logistic_weight_68, p3_.logistic_size_width AS logistic_size_width_69, p3_.logistic_size_height AS logistic_size_height_70, p3_.logistic_size_length AS logistic_size_length_71, p3_.price_amount AS price_amount_72, p3_.price_currency AS price_currency_73, p3_.purchase_price_amount AS purchase_price_amount_74, p3_.purchase_price_currency AS purchase_price_currency_75, c0_.customer_id AS customer_id_76, c0_.shipping_method_id AS shipping_method_id_77, c0_.discount_code_id AS discount_code_id_78, c1_.cart_id AS cart_id_79, c1_.product_variant_id AS product_variant_id_80, p2_.product_id AS product_id_81, p3_.vat_id AS vat_id_82, p3_.main_category_id AS main_category_id_83 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.session_id = ? AND c0_.status = ? ORDER BY c1_.id ASC
SELECT n0_.id AS id_0, n0_.active AS active_1, n0_.content AS content_2, n0_.notice_position AS notice_position_3, n0_.show_from AS show_from_4, n0_.show_to AS show_to_5, n0_.background_color AS background_color_6, n0_.text_color AS text_color_7, n0_.button_background_color AS button_background_color_8, n0_.button_hover_background_color AS button_hover_background_color_9, n0_.button_text_color AS button_text_color_10, n0_.notice_type AS notice_type_11 FROM notice n0_ WHERE n0_.notice_type IN ('infobar')
SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8, c0_.seo_title AS seo_title_9, c0_.seo_description AS seo_description_10, c0_.seo_url AS seo_url_11 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 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 ORDER BY c0_.is_default DESC, c0_.code 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 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 ORDER BY c0_.is_default DESC, c0_.code ASC
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
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 = ?
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 = ?
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.active AS active_2, g0_.created_at AS created_at_3, g0_.updated_at AS updated_at_4, g0_.threshold_amount AS threshold_amount_5, g0_.threshold_currency AS threshold_currency_6, p1_.id AS id_7, p1_.public_id AS public_id_8, p1_.code AS code_9, p1_.is_default AS is_default_10, p1_.weight_modification AS weight_modification_11, p1_.price_modification_amount AS price_modification_amount_12, p1_.price_modification_currency AS price_modification_currency_13, p1_.stock_stock AS stock_stock_14, p1_.stock_reserved AS stock_reserved_15, p2_.id AS id_16, p2_.public_id AS public_id_17, p2_.name AS name_18, p2_.description AS description_19, p2_.short_description AS short_description_20, p2_.code AS code_21, p2_.ean AS ean_22, p2_.unit AS unit_23, p2_.active AS active_24, p2_.can_be_bought AS can_be_bought_25, p2_.searchable AS searchable_26, p2_.show_price AS show_price_27, p2_.in_stock_text AS in_stock_text_28, p2_.out_of_stock_text AS out_of_stock_text_29, p2_.filter_parameter_value_ids AS filter_parameter_value_ids_30, p2_.filter_variant_value_ids AS filter_variant_value_ids_31, p2_.search_vector_cs AS search_vector_cs_32, p2_.search_vector_en AS search_vector_en_33, p2_.seo_title AS seo_title_34, p2_.seo_description AS seo_description_35, p2_.seo_url AS seo_url_36, p2_.stock_stock AS stock_stock_37, p2_.stock_reserved AS stock_reserved_38, p2_.logistic_weight AS logistic_weight_39, p2_.logistic_size_width AS logistic_size_width_40, p2_.logistic_size_height AS logistic_size_height_41, p2_.logistic_size_length AS logistic_size_length_42, p2_.price_amount AS price_amount_43, p2_.price_currency AS price_currency_44, p2_.purchase_price_amount AS purchase_price_amount_45, p2_.purchase_price_currency AS purchase_price_currency_46, g0_.product_variant_id AS product_variant_id_47, p1_.product_id AS product_id_48, p2_.vat_id AS vat_id_49, p2_.main_category_id AS main_category_id_50 FROM gift g0_ INNER JOIN product_variant p1_ ON g0_.product_variant_id = p1_.id INNER JOIN product p2_ ON p1_.product_id = p2_.id WHERE g0_.active = ? ORDER BY g0_.threshold_amount ASC
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.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.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 = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT s0_.id AS id_0, s0_.range_from AS range_from_1, s0_.range_to AS range_to_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.price_amount AS price_amount_5, s0_.price_currency AS price_currency_6, s0_.shipping_method_id AS shipping_method_id_7, s0_.country_id AS country_id_8 FROM shipping_method_fee s0_ INNER JOIN shipping_method s1_ ON s0_.shipping_method_id = s1_.id WHERE s1_.is_active = true AND s1_.carrier IS NOT NULL AND s0_.price_amount = 0 AND s0_.range_from IS NOT NULL ORDER BY s0_.range_from ASC LIMIT 1
SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.title AS title_2, c0_.content AS content_3, c0_.link_url AS link_url_4, c0_.link_label AS link_label_5, c0_.is_active AS is_active_6, f1_.id AS id_7, f1_.size AS size_8, f1_.mime_type AS mime_type_9, f1_.name AS name_10, c0_.image_id AS image_id_11 FROM cart_sidebar_block c0_ LEFT JOIN file f1_ ON c0_.image_id = f1_.id WHERE c0_.is_active = true ORDER BY c0_.position ASC, c0_.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\File\Domain\Entity\File	5
App\Frontoffice\Domain\Entity\FooterLink	5
App\Product\Domain\Entity\ProductImage	4
App\Frontoffice\Domain\Entity\SocialLink	4
App\Configuration\Domain\Entity\Currency	3
App\PageBuilder\Domain\Entity\StaticPage	3
App\Configuration\Domain\Entity\ExchangeRate	2
App\Gift\Domain\Entity\Gift	2
App\Product\Domain\Entity\ProductVariant	2
App\Product\Domain\Entity\Product	2
App\Product\Domain\Entity\Category	2
App\Frontoffice\Domain\Entity\CartSidebarBlock	2
App\Frontoffice\Domain\Entity\Cart	1
App\Configuration\Domain\Entity\Notice	1
App\Accounting\Domain\Entity\TaxRate	1

Entities Mapping

Class	Mapping errors
App\Configuration\Domain\Entity\Configuration	No errors.
App\Localization\Domain\Entity\Language	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\Configuration\Domain\Entity\Notice	No errors.
App\Routing\Domain\Entity\RedirectRoute	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\Shared\Domain\Entity\Address	No errors.
App\Frontoffice\Domain\Entity\Cart	No errors.
App\Gift\Domain\Entity\Gift	No errors.
App\Discount\Domain\Entity\Discount	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\Configuration\Domain\Entity\InfoBarNotice	No errors.
App\Gdpr\Domain\Entity\CustomerGdprState	No errors.
App\Payment\Domain\Entity\PaymentMethodFee	No errors.
App\Configuration\Domain\Entity\Country	No errors.
App\Shipping\Domain\Entity\ShippingMethodFee	No errors.
App\Product\Domain\Entity\VariantValue	No errors.
App\Product\Domain\Entity\ProductImage	No errors.
App\Product\Domain\Entity\ProductPrice	No errors.
App\Product\Domain\Entity\ProductFile	No errors.
App\Product\Domain\Entity\ProductVideo	No errors.
App\Product\Domain\Entity\ProductParameter	No errors.
App\File\Domain\Entity\File	No errors.
App\Frontoffice\Domain\Entity\CartSidebarBlock	No errors.
App\Frontoffice\Domain\Entity\FooterLink	No errors.
App\Frontoffice\Domain\Entity\SocialLink	No errors.

Symfony Profiler

GET https://poole7f3b5fd.s1.stage.forga.cz/cs/cart/step-one

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping