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

Response
302 Found
IP
216.73.216.236
Profiled on
Token
f2eadc

Query Metrics

13 Database Queries
4 Different statements
18.39 ms Query time
2 Invalid entities
6 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.02 ms 
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_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 1.78 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3 2.56 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
4 2.03 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.80 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.65 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.79 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.53 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.69 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.67 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.79 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
12 4.51 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_.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
Parameters: 
[
  "7019f3ea50acfce488e312594475ecb6"
  "active"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 1.54 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_.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
Parameters: 
[
  "7019f3ea50acfce488e312594475ecb6"
  "active"
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Configuration\Domain\Entity\Currency 3
App\Configuration\Domain\Entity\ExchangeRate 2
App\Frontoffice\Domain\Entity\Cart 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\Discount\Domain\Entity\Discount No errors.
App\Payment\Domain\Entity\PaymentMethodFee No errors.
App\Configuration\Domain\Entity\Country 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\Shipping\Domain\Entity\ShippingMethodFee No errors.
App\Shared\Domain\Entity\Address No errors.
App\Frontoffice\Domain\Entity\Cart No errors.
App\Gift\Domain\Entity\Gift 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\Accounting\Domain\Entity\TaxRate No errors.