GET https://dev.slave.scapp.cz/page/dodani-a-platba

Query Metrics

4 Database Queries
3 Different statements
9.67 ms Query time
7 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 6.88 ms
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.payment_method AS payment_method_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.address_street AS address_street_17, c0_.address_descriptive_number AS address_descriptive_number_18, c0_.address_city AS address_city_19, c0_.address_country AS address_country_20, c0_.address_zip_code AS address_zip_code_21, c0_.invoice_street AS invoice_street_22, c0_.invoice_descriptive_number AS invoice_descriptive_number_23, c0_.invoice_city AS invoice_city_24, c0_.invoice_country AS invoice_country_25, c0_.invoice_zip_code AS invoice_zip_code_26, c1_.id AS id_27, c1_.quantity AS quantity_28, c1_.created_at AS created_at_29, c1_.updated_at AS updated_at_30, p2_.id AS id_31, p2_.code AS code_32, p2_.is_default AS is_default_33, p2_.weight_modification AS weight_modification_34, p2_.price_modification_amount AS price_modification_amount_35, p2_.price_modification_currency AS price_modification_currency_36, p2_.stock_stock AS stock_stock_37, p2_.stock_reserved AS stock_reserved_38, p3_.id AS id_39, p3_.name AS name_40, p3_.description AS description_41, p3_.short_description AS short_description_42, p3_.code AS code_43, p3_.ean AS ean_44, p3_.unit AS unit_45, p3_.active AS active_46, p3_.can_be_bought AS can_be_bought_47, p3_.in_stock_text AS in_stock_text_48, p3_.out_of_stock_text AS out_of_stock_text_49, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_50, p3_.filter_variant_value_ids AS filter_variant_value_ids_51, p3_.seo_title AS seo_title_52, p3_.seo_description AS seo_description_53, p3_.seo_url AS seo_url_54, p3_.stock_stock AS stock_stock_55, p3_.stock_reserved AS stock_reserved_56, p3_.logistic_weight AS logistic_weight_57, p3_.logistic_size_width AS logistic_size_width_58, p3_.logistic_size_height AS logistic_size_height_59, p3_.logistic_size_length AS logistic_size_length_60, p3_.price_amount AS price_amount_61, p3_.price_currency AS price_currency_62, p3_.purchase_price_amount AS purchase_price_amount_63, p3_.purchase_price_currency AS purchase_price_currency_64, c0_.customer_id AS customer_id_65, c0_.shipping_method_id AS shipping_method_id_66, c0_.discount_code_id AS discount_code_id_67, c1_.cart_id AS cart_id_68, c1_.product_variant_id AS product_variant_id_69, p2_.product_id AS product_id_70, p3_.vat_id AS vat_id_71, p3_.main_category_id AS main_category_id_72 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.session_id = ? AND c0_.status = ? ORDER BY c1_.id ASC
Parameters:
[
  ""
  "active"
]
2 1.30 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.show_contact_form AS show_contact_form_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_url AS seo_url_10 FROM static_page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "dodani-a-platba"
]
3 0.95 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:
[]
4 0.54 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:
[]

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\Frontoffice\Domain\Entity\Cart 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\Configuration\Domain\Entity\Country No errors.
App\Configuration\Domain\Entity\Currency No errors.
App\Configuration\Domain\Entity\ExchangeRate No errors.
App\Invoice\Domain\Entity\InvoiceNumberSeries No errors.
App\Invoice\Domain\Entity\Invoice No errors.
App\Filter\Domain\Entity\FilterConfiguration No errors.
App\Filter\Domain\Entity\ParameterFilterConfiguration No errors.
App\Filter\Domain\Entity\VariantFilterConfiguration No errors.
App\Shipping\Domain\Entity\CarrierConfiguration No errors.
App\Shipping\Domain\Entity\CarrierShippingOption No errors.
App\Shipping\Domain\Entity\ShippingMethodFee 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\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\Order\Domain\Entity\OrderItem 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.
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\User\Domain\Entity\User No errors.
App\User\Domain\Entity\UserRole No errors.
App\Product\Domain\Entity\Parameter No errors.
App\Product\Domain\Entity\Variant No errors.
App\CarrierExport\Domain\Entity\ExportProcess No errors.
App\PageBuilder\Domain\Entity\StaticPage No errors.