GET https://dev.slave.scapp.cz/cart/step-one

Response
200 OK
IP
216.73.216.101
Profiled on
Token
4a2d85

Query Metrics

14 Database Queries
7 Different statements
22.41 ms Query time
3 Invalid entities
15 Managed entities

Queries

Group similar statements

#▲ Time Info
1 8.15 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"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 2.08 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"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 1.34 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.59 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.67 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 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.71 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 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.65 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 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.57 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 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.54 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 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.77 ms 
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 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 3.23 ms 
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_.fee_based_on = ? AND s0_.range_from <= ? AND s0_.range_to > ?) OR (s1_.fee_based_on = ? AND s0_.range_from <= ? AND s0_.range_to > ?)) OR (s1_.behaviour_outside_fee_range = ? AND (NOT EXISTS (SELECT 1 AS sclr_9 FROM shipping_method_fee s2_ INNER JOIN shipping_method s3_ ON s2_.shipping_method_id = s3_.id WHERE s3_.id = s1_.id AND ((s3_.fee_based_on = ? AND s2_.range_from <= ? AND s2_.range_to > ?) OR (s3_.fee_based_on = ? AND s2_.range_from <= ? AND s2_.range_to > ?)))) AND s0_.price_amount = (SELECT MAX(s4_.price_amount) AS sclr_10 FROM shipping_method_fee s5_, shipping_method_fee s4_ WHERE s4_.shipping_method_id = s1_.id))) AND s1_.is_active = true AND s1_.carrier IS NOT NULL ORDER BY s0_.price_amount ASC LIMIT 1
Parameters: 
[
  "price"
  0.0
  0.0
  "weight"
  0
  0
  "highest_price"
  "price"
  0.0
  0.0
  "weight"
  0
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.95 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.48 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.fee_based_on AS fee_based_on_4, t0.behaviour_outside_fee_range AS behaviour_outside_fee_range_5, t0.carrier AS carrier_6, t0.allow_home_delivery AS allow_home_delivery_7, t0.allow_box_delivery AS allow_box_delivery_8, t0.allow_pickup_point AS allow_pickup_point_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.logo_id AS logo_id_12, t0.tax_rate_id AS tax_rate_id_13, t0.carrier_shipping_option_id AS carrier_shipping_option_id_14 FROM shipping_method t0 WHERE t0.id = ?
Parameters: 
[
  "769eec05-3da1-451b-9a1a-0ff63b490f3d"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.68 ms 
SELECT t0.id AS id_1, t0.rate AS rate_2 FROM tax_rate t0 WHERE t0.id = ?
Parameters: 
[
  "d4cbf291-83a9-4c10-97a6-39675f525c02"
]
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\PageBuilder\Domain\Entity\StaticPage 3
App\Configuration\Domain\Entity\Currency 3
App\Frontoffice\Domain\Entity\Cart 2
App\Configuration\Domain\Entity\ExchangeRate 2
App\Shipping\Domain\Entity\ShippingMethodFee 1
App\Shipping\Domain\Entity\ShippingMethod 1
App\Configuration\Domain\Entity\Country 1
App\File\Domain\Entity\File 1
App\Accounting\Domain\Entity\TaxRate 1

Entities Mapping

Class Mapping errors
App\Configuration\Domain\Entity\Configuration 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\Stock No errors.
App\Product\Domain\Entity\ProductVariant No errors.
App\SEO\Domain\Entity\SEO 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\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\Discount\Domain\Entity\Discount No errors.
App\Accounting\Domain\Entity\TaxRate 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\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\Shipping\Domain\Entity\ShippingMethodFee No errors.
App\Configuration\Domain\Entity\Country No errors.
App\File\Domain\Entity\File No errors.
App\Shipping\Domain\Entity\CarrierShippingOption 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.