Query Metrics

9 Database Queries
8 Different statements
1111.20 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
936.06 ms
(84.24%)
1
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.urlClover AS urlClover_18, t0.midClover AS midClover_19, t0.midApi AS midApi_20, t0.fcm_key AS fcm_key_21, t0.fcm_manager_key AS fcm_manager_key_22, t0.fcm_manager_token AS fcm_manager_token_23, t0.lat AS lat_24, t0.lng AS lng_25, t0.cm_firebase_token AS cm_firebase_token_26, t0.default_locale_id AS default_locale_id_27, t28.code AS code_29, t28.created_at AS created_at_30, t28.updated_at AS updated_at_31, t28.id AS id_32, t0.base_currency_id AS base_currency_id_33, t34.code AS code_35, t34.created_at AS created_at_36, t34.updated_at AS updated_at_37, t34.id AS id_38, t0.default_tax_zone_id AS default_tax_zone_id_39, t0.menu_taxon_id AS menu_taxon_id_40, t0.shop_billing_data_id AS shop_billing_data_id_41 FROM sylius_channel t0 INNER JOIN sylius_locale t28 ON t0.default_locale_id = t28.id INNER JOIN sylius_currency t34 ON t0.base_currency_id = t34.id WHERE t0.hostname = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  "api.chtor.com"
  1
]
128.87 ms
(11.60%)
2
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.urlClover AS urlClover_18, t0.midClover AS midClover_19, t0.midApi AS midApi_20, t0.fcm_key AS fcm_key_21, t0.fcm_manager_key AS fcm_manager_key_22, t0.fcm_manager_token AS fcm_manager_token_23, t0.lat AS lat_24, t0.lng AS lng_25, t0.cm_firebase_token AS cm_firebase_token_26, t0.default_locale_id AS default_locale_id_27, t28.code AS code_29, t28.created_at AS created_at_30, t28.updated_at AS updated_at_31, t28.id AS id_32, t0.base_currency_id AS base_currency_id_33, t34.code AS code_35, t34.created_at AS created_at_36, t34.updated_at AS updated_at_37, t34.id AS id_38, t0.default_tax_zone_id AS default_tax_zone_id_39, t0.menu_taxon_id AS menu_taxon_id_40, t0.shop_billing_data_id AS shop_billing_data_id_41 FROM sylius_channel t0 INNER JOIN sylius_locale t28 ON t0.default_locale_id = t28.id INNER JOIN sylius_currency t34 ON t0.base_currency_id = t34.id
Parameters:
[]
44.15 ms
(3.97%)
1
SELECT b0_.name AS name_0, b0_.token AS token_1, b0_.id AS id_2, b0_.shop_user_id AS shop_user_id_3, b0_.channel_id AS channel_id_4 FROM bitbag_wishlist b0_ WHERE b0_.channel_id = ? AND b0_.shop_user_id IS NULL AND b0_.token = ? ORDER BY b0_.id ASC
Parameters:
[
  1
  "20ac657c-2b63-40d5-8a0c-20f1e3a37979"
]
0.79 ms
(0.07%)
1
SELECT b0_.code AS code_0, b0_.type AS type_1, b0_.path AS path_2, b0_.mime_type AS mime_type_3, b0_.enabled AS enabled_4, b0_.width AS width_5, b0_.height AS height_6, b0_.id AS id_7 FROM bitbag_cms_media b0_ LEFT JOIN bitbag_cms_media_translation b1_ ON b0_.id = b1_.translatable_id INNER JOIN bitbag_cms_media_channels b3_ ON b0_.id = b3_.block_id INNER JOIN sylius_channel s2_ ON s2_.id = b3_.channel_id WHERE b1_.locale = ? AND b0_.code = ? AND b0_.enabled = 1 AND s2_.code = ? ORDER BY b0_.id ASC
Parameters:
[
  "en_US"
  "logo"
  "FASHION_WEB"
]
0.38 ms
(0.03%)
1
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.38 ms
(0.03%)
1
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
  1
]
0.30 ms
(0.03%)
1
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?
Parameters:
[
  1
]
0.27 ms
(0.02%)
1
SELECT t0.name AS name_1, t0.content AS content_2, t0.alt AS alt_3, t0.link AS link_4, t0.id AS id_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM bitbag_cms_media_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  1
  "en_US"
]

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.

Entities Mapping

Class Mapping errors
BitBag\SyliusCmsPlugin\Entity\Media No errors.
Odiseo\SyliusBannerPlugin\Entity\Banner No errors.
Sylius\Component\Customer\Model\Customer No errors.
Sylius\Component\Core\Model\Customer No errors.
App\Entity\Customer\Customer No errors.
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
App\Entity\Product\Product
  • The field App\Entity\Product\Product#group_modifiers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGroupRelation#product does not contain the required 'inversedBy="group_modifiers"' attribute.
App\Entity\Product\ProductModifier No errors.
Sylius\Component\Channel\Model\Channel No errors.
Sylius\Component\Core\Model\Channel No errors.
App\Entity\Channel\Channel No errors.
Sylius\Component\Order\Model\Order No errors.
Sylius\Component\Core\Model\Order No errors.
App\Entity\Order\Order No errors.
Sylius\Component\Shipping\Model\Shipment No errors.
Sylius\Component\Core\Model\Shipment No errors.
App\Entity\Shipping\Shipment No errors.
BitBag\SyliusWishlistPlugin\Entity\Wishlist No errors.
Sylius\Component\Locale\Model\Locale No errors.
App\Entity\Locale\Locale No errors.
Sylius\Component\Currency\Model\Currency No errors.
App\Entity\Currency\Currency No errors.
Sylius\Component\Addressing\Model\Zone No errors.
App\Entity\Addressing\Zone No errors.
Sylius\Component\Taxonomy\Model\Taxon No errors.
Sylius\Component\Core\Model\Taxon No errors.
App\Entity\Taxonomy\Taxon No errors.
Sylius\Component\Core\Model\ShopBillingData No errors.
Sylius\Component\Addressing\Model\Country No errors.
App\Entity\Addressing\Country No errors.
Sylius\Component\Addressing\Model\Province No errors.
App\Entity\Addressing\Province No errors.
Sylius\Component\User\Model\User No errors.
Sylius\Component\Core\Model\ShopUser No errors.
App\Entity\User\PhoneNumber No errors.
App\Entity\User\ShopUser No errors.
BitBag\SyliusWishlistPlugin\Entity\WishlistProduct No errors.
BitBag\SyliusCmsPlugin\Entity\Block No errors.
BitBag\SyliusCmsPlugin\Entity\Page No errors.
Sylius\Component\Payment\Model\PaymentMethod No errors.
Sylius\Component\Core\Model\PaymentMethod No errors.
App\Entity\Payment\PaymentMethod No errors.
BitBag\SyliusCmsPlugin\Entity\MediaTranslation No errors.
BitBag\SyliusCmsPlugin\Entity\Section No errors.
Odiseo\SyliusBannerPlugin\Entity\BannerTranslation No errors.
Sylius\Component\Customer\Model\CustomerGroup No errors.
App\Entity\Customer\CustomerGroup No errors.
Sylius\Component\Addressing\Model\Address No errors.
Sylius\Component\Core\Model\Address No errors.
App\Entity\Addressing\Address No errors.
App\Entity\Product\ProductModifierGroups
  • The field App\Entity\Product\ProductModifierGroups#group_modifiers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductVariantGroupRelation#group_modifier does not contain the required 'inversedBy="group_modifiers"' attribute.
  • The field App\Entity\Product\ProductModifierGroups#group_product_modifiers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGroupRelation#group_modifier does not contain the required 'inversedBy="group_product_modifiers"' attribute.
App\Entity\Product\ProductGroupRelation No errors.
Sylius\Component\Product\Model\ProductTranslation No errors.
Sylius\Component\Core\Model\ProductTranslation No errors.
App\Entity\Product\ProductTranslation No errors.
Sylius\Component\Core\Model\ProductTaxon No errors.
App\Entity\Product\ProductTaxon No errors.
Sylius\Component\Core\Model\Image No errors.
Sylius\Component\Core\Model\ProductImage No errors.
App\Entity\Product\ProductImage No errors.
Sylius\Component\Attribute\Model\AttributeValue No errors.
Sylius\Component\Product\Model\ProductAttributeValue No errors.
App\Entity\Product\ProductAttributeValue No errors.
Sylius\Component\Attribute\Model\Attribute No errors.
Sylius\Component\Product\Model\ProductAttribute No errors.
App\Entity\Product\ProductAttribute No errors.
Sylius\Component\Product\Model\ProductVariant No errors.
Sylius\Component\Core\Model\ProductVariant No errors.
App\Entity\Product\ProductVariant
  • The field App\Entity\Product\ProductVariant#group_modifiers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductVariantGroupRelation#product_variant does not contain the required 'inversedBy="group_modifiers"' attribute.
Sylius\Component\Product\Model\ProductAssociation No errors.
App\Entity\Product\ProductAssociation No errors.
Sylius\Component\Product\Model\ProductOption No errors.
App\Entity\Product\ProductOption No errors.
Sylius\Component\Review\Model\Review No errors.
Sylius\Component\Core\Model\ProductReview No errors.
App\Entity\Product\ProductReview No errors.
Sylius\Component\Promotion\Model\PromotionCoupon No errors.
Sylius\Component\Core\Model\PromotionCoupon No errors.
App\Entity\Promotion\PromotionCoupon No errors.
Sylius\Component\Payment\Model\Payment No errors.
Sylius\Component\Core\Model\Payment No errors.
App\Entity\Payment\Payment No errors.
Sylius\Component\Promotion\Model\Promotion No errors.
Sylius\Component\Core\Model\Promotion No errors.
App\Entity\Promotion\Promotion No errors.
Sylius\Component\Order\Model\OrderItem No errors.
Sylius\Component\Core\Model\OrderItem No errors.
App\Entity\Order\OrderItem No errors.
Sylius\Component\Order\Model\Adjustment No errors.
Sylius\Component\Core\Model\Adjustment No errors.
App\Entity\Order\Adjustment No errors.
Sylius\Component\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
App\Entity\Shipping\ShippingMethod No errors.
Sylius\Component\Order\Model\OrderItemUnit No errors.
Sylius\Component\Core\Model\OrderItemUnit No errors.
App\Entity\Order\OrderItemUnit No errors.
Sylius\Component\Addressing\Model\ZoneMember No errors.
App\Entity\Addressing\ZoneMember No errors.
Sylius\Component\Taxonomy\Model\TaxonTranslation No errors.
App\Entity\Taxonomy\TaxonTranslation No errors.
Sylius\Component\Core\Model\TaxonImage No errors.
App\Entity\Taxonomy\TaxonImage No errors.
Sylius\Component\User\Model\UserOAuth No errors.
App\Entity\User\UserOAuth No errors.
BitBag\SyliusCmsPlugin\Entity\BlockTranslation No errors.
BitBag\SyliusCmsPlugin\Entity\PageTranslation No errors.
Payum\Core\Model\GatewayConfig No errors.
Sylius\Bundle\PayumBundle\Model\GatewayConfig No errors.
App\Entity\Payment\GatewayConfig No errors.
Sylius\Component\Payment\Model\PaymentMethodTranslation No errors.
App\Entity\Payment\PaymentMethodTranslation No errors.
BitBag\SyliusCmsPlugin\Entity\SectionTranslation No errors.
Payum\Core\Model\Token No errors.
Payum\Core\Model\Payout No errors.
Payum\Core\Model\Payment No errors.
Payum\Core\Model\ArrayObject No errors.
BitBag\SyliusCmsPlugin\Entity\FrequentlyAskedQuestion No errors.
BitBag\SyliusCmsPlugin\Entity\FrequentlyAskedQuestionTranslation No errors.
Vich\UploaderBundle\Entity\File No errors.
Sylius\Component\Currency\Model\ExchangeRate No errors.
App\Entity\Currency\ExchangeRate No errors.
Sylius\Component\Promotion\Model\CatalogPromotion No errors.
Sylius\Component\Core\Model\CatalogPromotion No errors.
App\Entity\Promotion\CatalogPromotion No errors.
Sylius\Component\Promotion\Model\CatalogPromotionScope No errors.
Sylius\Component\Core\Model\CatalogPromotionScope No errors.
App\Entity\Promotion\CatalogPromotionScope No errors.
Sylius\Component\Promotion\Model\CatalogPromotionAction No errors.
App\Entity\Promotion\CatalogPromotionAction No errors.
Sylius\Component\Promotion\Model\PromotionAction No errors.
App\Entity\Promotion\PromotionAction No errors.
Sylius\Component\Promotion\Model\PromotionRule No errors.
App\Entity\Promotion\PromotionRule No errors.
Sylius\Component\Core\Model\ChannelPricing No errors.
App\Entity\Channel\ChannelPricing No errors.
App\Entity\Driver\Shift No errors.
Sylius\Component\Shipping\Model\ShippingCategory No errors.
App\Entity\Shipping\ShippingCategory No errors.
Sylius\Component\Shipping\Model\ShippingMethodTranslation No errors.
App\Entity\Shipping\ShippingMethodTranslation No errors.
Sylius\Component\Attribute\Model\AttributeTranslation No errors.
Sylius\Component\Product\Model\ProductAttributeTranslation No errors.
App\Entity\Product\ProductAttributeTranslation No errors.
Sylius\Component\Product\Model\ProductOptionValueTranslation No errors.
App\Entity\Product\ProductOptionValueTranslation No errors.
Sylius\Component\Product\Model\ProductOptionValue No errors.
App\Entity\Product\ProductOptionValue No errors.
App\Entity\Product\ProductVariantGroupRelation No errors.
Sylius\Component\Product\Model\ProductAssociationTypeTranslation No errors.
App\Entity\Product\ProductAssociationTypeTranslation No errors.
Sylius\Component\Product\Model\ProductAssociationType No errors.
App\Entity\Product\ProductAssociationType No errors.
Sylius\Component\Product\Model\ProductVariantTranslation No errors.
App\Entity\Product\ProductVariantTranslation No errors.
Sylius\Component\Product\Model\ProductOptionTranslation No errors.
App\Entity\Product\ProductOptionTranslation No errors.
App\Entity\Order\OrderVariantDetails No errors.
Sylius\Component\Order\Model\OrderSequence No errors.
Sylius\Component\Core\Model\OrderSequence No errors.
App\Entity\Order\OrderSequence No errors.
App\Entity\Order\OrderVariantValue No errors.
Sylius\Component\Core\Model\AdminUser No errors.
App\Entity\User\AdminUser No errors.
Sylius\Component\Taxation\Model\TaxCategory No errors.
App\Entity\Taxation\TaxCategory No errors.
Sylius\Component\Taxation\Model\TaxRate No errors.
Sylius\Component\Core\Model\TaxRate No errors.
App\Entity\Taxation\TaxRate No errors.
Sylius\Bundle\PayumBundle\Model\PaymentSecurityToken No errors.
App\Entity\Payment\PaymentSecurityToken No errors.
Sylius\PayPalPlugin\Entity\PayPalCredentials No errors.
Sylius\Component\Shipping\Model\ShipmentUnit No errors.
Sylius\Component\Shipping\Model\ShippingMethodRule No errors.
Sylius\Component\Promotion\Model\CatalogPromotionTranslation No errors.
Sylius\Component\Addressing\Model\AddressLogEntry No errors.
Sylius\Component\Inventory\Model\InventoryUnit No errors.
Sylius\Component\Review\Model\Reviewer No errors.
Sylius\Component\Core\Model\AvatarImage No errors.