Query Metrics

37 Database Queries
13 Different statements
114.44 ms Query time
0 Invalid entities
8611 Managed entities

Grouped Statements

Show all queries

Time Count Info
74.10 ms
(64.75%)
1
SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.apiLastModifiedAt AS apiLastModifiedAt_9, s0_.showChildren AS showChildren_10, s0_.productListingType AS productListingType_11, s0_.displayStyle AS displayStyle_12, s0_.apiParentId AS apiParentId_13, s0_.apiOrder AS apiOrder_14, s0_.apiId AS apiId_15, s0_.apiValue AS apiValue_16, s0_.includeInLatestProducts AS includeInLatestProducts_17, s0_.code AS code_18, s0_.tree_left AS tree_left_19, s0_.tree_right AS tree_right_20, s0_.tree_level AS tree_level_21, s0_.position AS position_22, s0_.enabled AS enabled_23, s0_.id AS id_24, s0_.created_at AS created_at_25, s0_.updated_at AS updated_at_26, s0_.apiLastModifiedAt AS apiLastModifiedAt_27, s0_.showChildren AS showChildren_28, s0_.productListingType AS productListingType_29, s0_.displayStyle AS displayStyle_30, s0_.apiParentId AS apiParentId_31, s0_.apiOrder AS apiOrder_32, s0_.apiId AS apiId_33, s0_.apiValue AS apiValue_34, s0_.includeInLatestProducts AS includeInLatestProducts_35, s1_.name AS name_36, s1_.description AS description_37, s1_.id AS id_38, s1_.url AS url_39, s1_.cmsContent AS cmsContent_40, s1_.slug AS slug_41, s1_.locale AS locale_42, s2_.code AS code_43, s2_.tree_left AS tree_left_44, s2_.tree_right AS tree_right_45, s2_.tree_level AS tree_level_46, s2_.position AS position_47, s2_.enabled AS enabled_48, s2_.id AS id_49, s2_.created_at AS created_at_50, s2_.updated_at AS updated_at_51, s2_.apiLastModifiedAt AS apiLastModifiedAt_52, s2_.showChildren AS showChildren_53, s2_.productListingType AS productListingType_54, s2_.displayStyle AS displayStyle_55, s2_.apiParentId AS apiParentId_56, s2_.apiOrder AS apiOrder_57, s2_.apiId AS apiId_58, s2_.apiValue AS apiValue_59, s2_.includeInLatestProducts AS includeInLatestProducts_60, s0_.tree_root AS tree_root_61, s0_.parent_id AS parent_id_62, s1_.translatable_id AS translatable_id_63, s2_.tree_root AS tree_root_64, s2_.parent_id AS parent_id_65 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.tree_root = ? ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC
Parameters:
[
  "en_US"
  1
]
28.46 ms
(24.87%)
2
SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.apiLastModifiedAt AS apiLastModifiedAt_9, s0_.showChildren AS showChildren_10, s0_.productListingType AS productListingType_11, s0_.displayStyle AS displayStyle_12, s0_.apiParentId AS apiParentId_13, s0_.apiOrder AS apiOrder_14, s0_.apiId AS apiId_15, s0_.apiValue AS apiValue_16, s0_.includeInLatestProducts AS includeInLatestProducts_17, s1_.name AS name_18, s1_.description AS description_19, s1_.id AS id_20, s1_.url AS url_21, s1_.cmsContent AS cmsContent_22, s1_.slug AS slug_23, s1_.locale AS locale_24, s0_.tree_root AS tree_root_25, s0_.parent_id AS parent_id_26, s1_.translatable_id AS translatable_id_27 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.enabled = ? AND s1_.slug = ? AND s1_.locale = ? ORDER BY s0_.id ASC
Parameters:
[
  1
  "main/test-2"
  "en_US"
]
2.61 ms
(2.28%)
1
SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.apiLastModifiedAt AS apiLastModifiedAt_9, s0_.showChildren AS showChildren_10, s0_.productListingType AS productListingType_11, s0_.displayStyle AS displayStyle_12, s0_.apiParentId AS apiParentId_13, s0_.apiOrder AS apiOrder_14, s0_.apiId AS apiId_15, s0_.apiValue AS apiValue_16, s0_.includeInLatestProducts AS includeInLatestProducts_17, s1_.name AS name_18, s1_.description AS description_19, s1_.id AS id_20, s1_.url AS url_21, s1_.cmsContent AS cmsContent_22, s1_.slug AS slug_23, s1_.locale AS locale_24, s2_.code AS code_25, s2_.tree_left AS tree_left_26, s2_.tree_right AS tree_right_27, s2_.tree_level AS tree_level_28, s2_.position AS position_29, s2_.enabled AS enabled_30, s2_.id AS id_31, s2_.created_at AS created_at_32, s2_.updated_at AS updated_at_33, s2_.apiLastModifiedAt AS apiLastModifiedAt_34, s2_.showChildren AS showChildren_35, s2_.productListingType AS productListingType_36, s2_.displayStyle AS displayStyle_37, s2_.apiParentId AS apiParentId_38, s2_.apiOrder AS apiOrder_39, s2_.apiId AS apiId_40, s2_.apiValue AS apiValue_41, s2_.includeInLatestProducts AS includeInLatestProducts_42, s0_.tree_root AS tree_root_43, s0_.parent_id AS parent_id_44, s1_.translatable_id AS translatable_id_45, s2_.tree_root AS tree_root_46, s2_.parent_id AS parent_id_47 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.enabled = ? AND s3_.code = ? ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC
Parameters:
[
  "en_US"
  1
  "main"
]
2.34 ms
(2.05%)
10
SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.apiLastModifiedAt AS apiLastModifiedAt_10, t0.showChildren AS showChildren_11, t0.productListingType AS productListingType_12, t0.displayStyle AS displayStyle_13, t0.apiParentId AS apiParentId_14, t0.apiOrder AS apiOrder_15, t0.apiId AS apiId_16, t0.apiValue AS apiValue_17, t0.includeInLatestProducts AS includeInLatestProducts_18, t0.tree_root AS tree_root_19, t0.parent_id AS parent_id_20 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "main"
]
1.66 ms
(1.45%)
9
SELECT t0.name AS name_1, t0.description AS description_2, t0.id AS id_3, t0.url AS url_4, t0.cmsContent AS cmsContent_5, t0.slug AS slug_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  1
  "en_US"
]
0.94 ms
(0.82%)
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.certification AS certification_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.default_tax_zone_id AS default_tax_zone_id_31, t0.menu_taxon_id AS menu_taxon_id_32, t0.base_country_id AS base_country_id_33, t34.code AS code_35, t34.enabled AS enabled_36, t34.id AS id_37, t0.european_zone_id AS european_zone_id_38, t39.code AS code_40, t39.name AS name_41, t39.type AS type_42, t39.scope AS scope_43, t39.id AS id_44, t39.euVatNumberRequired AS euVatNumberRequired_45, t0.shop_billing_data_id AS shop_billing_data_id_46, t0.channel_price_history_config_id AS channel_price_history_config_id_47 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id LEFT JOIN sylius_country t34 ON t0.base_country_id = t34.id LEFT JOIN sylius_zone t39 ON t0.european_zone_id = t39.id WHERE t0.hostname = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  "dev.normadoc.fr"
  1
]
0.89 ms
(0.78%)
2
SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.code AS code_2, m0_.is_system AS is_system_3, m0_.id AS id_4, m1_.created_at AS created_at_5, m1_.updated_at AS updated_at_6, m1_.position AS position_7, m1_.target_blank AS target_blank_8, m1_.noreferrer AS noreferrer_9, m1_.noopener AS noopener_10, m1_.nofollow AS nofollow_11, m1_.id AS id_12, m2_.locale AS locale_13, m2_.url AS url_14, m2_.label AS label_15, m2_.id AS id_16, m1_.menu_id AS menu_id_17, m1_.parent_id AS parent_id_18, m2_.translatable_id AS translatable_id_19 FROM monsieurbiz_menu m0_ INNER JOIN monsieurbiz_menu_item m1_ ON m0_.id = m1_.menu_id INNER JOIN monsieurbiz_menu_item_translation m2_ ON m1_.id = m2_.translatable_id AND (m2_.locale = ?) WHERE m0_.code = ? ORDER BY m0_.id ASC, m1_.position ASC
Parameters:
[
  "en_US"
  "top"
]
0.87 ms
(0.76%)
2
SELECT s0_.code AS code_0, s0_.type AS type_1, s0_.storage_type AS storage_type_2, s0_.configuration AS configuration_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.position AS position_6, s0_.translatable AS translatable_7, s0_.id AS id_8 FROM sylius_product_attribute s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.id ASC
Parameters:
[
  "136"
  "137"
  "138"
  "139"
  "140"
  "141"
  "142"
  "143"
  "144"
  "147"
  "149"
]
0.76 ms
(0.67%)
2
SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC
Parameters:
[]
0.63 ms
(0.55%)
4
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_option_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  31
  "en_US"
]
0.59 ms
(0.51%)
1
SELECT s0_.code AS code_0, s0_.type AS type_1, s0_.storage_type AS storage_type_2, s0_.configuration AS configuration_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.position AS position_6, s0_.translatable AS translatable_7, s0_.id AS id_8, s1_.name AS name_9, s1_.id AS id_10, s1_.locale AS locale_11, s1_.translatable_id AS translatable_id_12 FROM sylius_product_attribute s0_ LEFT JOIN sylius_product_attribute_translation s1_ ON s0_.id = s1_.translatable_id WHERE s1_.locale = ? ORDER BY s0_.id ASC
Parameters:
[
  "en_US"
]
0.31 ms
(0.27%)
1
SELECT s0_.code AS code_0, s0_.position AS position_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.id AS id_4 FROM sylius_product_option s0_ ORDER BY s0_.id ASC
Parameters:
[]
0.29 ms
(0.25%)
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
]

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\Entity\Taxonomy\Taxon 4282
App\Entity\Taxonomy\TaxonTranslation 4282
App\Entity\Product\ProductAttribute 13
App\Entity\Product\ProductAttributeTranslation 13
App\Entity\Locale\Locale 4
App\Entity\Product\ProductOption 4
App\Entity\Product\ProductOptionTranslation 4
MonsieurBiz\SyliusMenuPlugin\Entity\MenuItem 2
MonsieurBiz\SyliusMenuPlugin\Entity\MenuItemTranslation 2
App\Entity\Channel\Channel 1
App\Entity\Channel\ShopBillingData 1
App\Entity\Channel\ChannelPriceHistoryConfig 1
App\Entity\Currency\Currency 1
MonsieurBiz\SyliusMenuPlugin\Entity\Menu 1

Entities Mapping

Class Mapping errors
MonsieurBiz\SyliusCmsPagePlugin\Entity\Page 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.
Sylius\Component\Customer\Model\Customer No errors.
Sylius\Component\Core\Model\Customer No errors.
App\Entity\Customer\Customer No errors.
Sylius\Component\Customer\Model\CustomerGroup No errors.
App\Entity\Customer\CustomerGroup No errors.
Sylius\Component\Channel\Model\Channel No errors.
Sylius\Component\Core\Model\Channel No errors.
App\Entity\Channel\Channel 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\Addressing\Model\Country No errors.
App\Entity\Addressing\Country No errors.
Sylius\Component\Core\Model\ShopBillingData No errors.
App\Entity\Channel\ShopBillingData No errors.
Sylius\Component\Core\Model\ChannelPriceHistoryConfig No errors.
App\Entity\Channel\ChannelPriceHistoryConfig No errors.
App\Entity\Supplier\Supplier No errors.
Sylius\Component\Attribute\Model\Attribute No errors.
Sylius\Component\Product\Model\ProductAttribute No errors.
App\Entity\Product\ProductAttribute No errors.
Sylius\Component\Currency\Model\ExchangeRate No errors.
App\Entity\Currency\ExchangeRate No errors.
MonsieurBiz\SyliusMenuPlugin\Entity\Menu No errors.
Sylius\Component\Payment\Model\PaymentMethod No errors.
Sylius\Component\Core\Model\PaymentMethod No errors.
App\Entity\Payment\PaymentMethod No errors.
Sylius\Component\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
App\Entity\Shipping\ShippingMethod No errors.
Sylius\Component\Product\Model\ProductOption No errors.
App\Entity\Product\ProductOption 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\ProductOptionTranslation No errors.
App\Entity\Product\ProductOptionTranslation No errors.
Sylius\Component\Product\Model\ProductOptionValue No errors.
App\Entity\Product\ProductOptionValue No errors.
Sylius\Component\Taxonomy\Model\TaxonTranslation No errors.
App\Entity\Taxonomy\TaxonTranslation No errors.
Sylius\Component\Core\Model\Image No errors.
Sylius\Component\Core\Model\TaxonImage No errors.
App\Entity\Taxonomy\TaxonImage No errors.
MonsieurBiz\SyliusMenuPlugin\Entity\MenuItem No errors.
MonsieurBiz\SyliusMenuPlugin\Entity\MenuItemTranslation No errors.
MonsieurBiz\SyliusCmsPagePlugin\Entity\PageTranslation No errors.
Sylius\Component\Promotion\Model\PromotionCoupon No errors.
Sylius\Component\Core\Model\PromotionCoupon No errors.
App\Entity\Promotion\PromotionCoupon No errors.
App\Entity\File\File No errors.
App\Entity\File\PrivateFile No errors.
App\Entity\Order\OrderPrivateFile No errors.
App\Entity\Invoice\Invoice No errors.
App\Entity\Company\Company No errors.
Sylius\Component\Addressing\Model\Address No errors.
Sylius\Component\Core\Model\Address No errors.
App\Entity\Addressing\Address 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.
App\Entity\Shipping\ShipmentPrivateFile No errors.
Sylius\Component\Order\Model\OrderItemUnit No errors.
Sylius\Component\Core\Model\OrderItemUnit No errors.
App\Entity\Order\OrderItemUnit No errors.
App\Entity\Drm\DrmToken No errors.
App\Entity\Favorites\Favorites No errors.
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
App\Entity\Product\Product No errors.
App\Entity\Company\CompanyCustomerPair No errors.
Sylius\Component\User\Model\User No errors.
Sylius\Component\Core\Model\ShopUser No errors.
App\Entity\User\ShopUser No errors.
Sylius\Component\Addressing\Model\ZoneMember No errors.
App\Entity\Addressing\ZoneMember No errors.
Sylius\Component\Addressing\Model\Province No errors.
App\Entity\Addressing\Province No errors.
App\Entity\Supplier\SupplierImage No errors.
App\Entity\Subscription\SubscriptionCollection No errors.
App\Entity\Supplier\SupplierTranslation 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.
Sylius\Component\Shipping\Model\ShippingCategory No errors.
App\Entity\Shipping\ShippingCategory No errors.
Sylius\Component\Taxation\Model\TaxCategory No errors.
App\Entity\Taxation\TaxCategory No errors.
Sylius\Component\Shipping\Model\ShippingMethodTranslation No errors.
App\Entity\Shipping\ShippingMethodTranslation No errors.
Sylius\Component\Shipping\Model\ShippingMethodRule No errors.
App\Entity\Shipping\ShippingMethodRule No errors.
Sylius\Component\Product\Model\ProductOptionValueTranslation No errors.
App\Entity\Product\ProductOptionValueTranslation No errors.
App\Entity\Invoice\InvoicePrivateFile No errors.
App\Entity\Company\CompanyImage No errors.
App\Entity\Keycloak\KeycloakIdentityProviderConfiguration No errors.
Sylius\Component\Promotion\Model\PromotionTranslation No errors.
App\Entity\Promotion\PromotionTranslation No errors.
Sylius\Component\Promotion\Model\PromotionRule No errors.
App\Entity\Promotion\PromotionRule No errors.
Sylius\Component\Promotion\Model\PromotionAction No errors.
App\Entity\Promotion\PromotionAction No errors.
Sylius\Component\Product\Model\ProductVariant No errors.
Sylius\Component\Core\Model\ProductVariant No errors.
App\Entity\Product\ProductVariant No errors.
App\Entity\Drm\DrmTokenLog No errors.
App\Entity\Document\Document No errors.
App\Entity\Product\ProductDocument 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\Review\Model\Review No errors.
Sylius\Component\Core\Model\ProductReview No errors.
App\Entity\Product\ProductReview 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\Product\Model\ProductAssociation No errors.
App\Entity\Product\ProductAssociation No errors.
Sylius\Component\User\Model\UserOAuth No errors.
App\Entity\User\UserOAuth No errors.
Sylius\Component\Taxation\Model\TaxRate No errors.
Sylius\Component\Core\Model\TaxRate No errors.
App\Entity\Taxation\TaxRate No errors.