GET https://dev.slave.forga.cz/en/currency/USD

Response
302 Found
IP
216.73.216.117
Profiled on
Token
046529

Query Metrics

7 Database Queries
4 Different statements
6.59 ms Query time
8 Invalid entities
5 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.89 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.11 ms 
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 = ?
Parameters: 
[
  "/en/currency/USD"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 1.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 0.66 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
5 0.76 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
6 0.96 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.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 ORDER BY c0_.is_default DESC, c0_.code ASC
Parameters: 
[]
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

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\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\PaymentGate\Domain\Entity\PaymentGateConfiguration No errors.
App\Shared\Domain\Entity\ServerSideEvent No errors.
App\ProductInquiry\Domain\Entity\ProductInquiry No errors.
App\Accounting\Domain\Entity\TaxRate 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\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\Product\Domain\Entity\CategoryProductPosition No errors.
App\Product\Domain\Entity\Parameter No errors.
App\Product\Domain\Entity\ParameterValue No errors.
App\Product\Domain\Entity\ProductPrice No errors.
App\Product\Domain\Entity\Variant No errors.
App\Product\Domain\Entity\VariantValue No errors.
App\Filter\Domain\Entity\FilterConfiguration No errors.
App\Filter\Domain\Entity\ParameterFilterConfiguration No errors.
App\Filter\Domain\Entity\VariantFilterConfiguration No errors.
App\Discount\Domain\Entity\Discount No errors.
App\ReturnRequest\Domain\Entity\ReturnRequest No errors.
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\Shared\Domain\Entity\NullablePrice 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\Customer\Domain\Entity\Customer 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\CartItem 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.