Query Metrics

115 Database Queries
22 Different statements
23.60 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.35 ms
(14.21%)
19
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5
  "fr_FR"
]
2.83 ms
(11.97%)
19
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  5
]
2.12 ms
(9.00%)
14
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5
  "fr_FR"
]
1.81 ms
(7.65%)
5
SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.variant_selection_method AS variant_selection_method_5, s0_.average_rating AS average_rating_6, s1_.name AS name_7, s1_.slug AS slug_8, s1_.description AS description_9, s1_.meta_keywords AS meta_keywords_10, s1_.meta_description AS meta_description_11, s1_.id AS id_12, s1_.short_description AS short_description_13, s1_.locale AS locale_14, s0_.main_taxon_id AS main_taxon_id_15, s0_.vendor_id AS vendor_id_16, s1_.translatable_id AS translatable_id_17 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE s1_.slug = ? AND EXISTS (SELECT 1 FROM sylius_product_channels s2_ WHERE s2_.product_id = s0_.id AND s2_.channel_id IN (?)) AND s0_.enabled = ?
Parameters:
[
  "fr_FR"
  "sac-vomitoire"
  1
  1
]
1.26 ms
(5.34%)
5
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.position AS position_2, s1_.created_at AS created_at_3, s1_.updated_at AS updated_at_4, s1_.id AS id_5, s0_.main_taxon_id AS main_taxon_id_6, s0_.vendor_id AS vendor_id_7 FROM sylius_product s0_ LEFT JOIN sylius_product_options s2_ ON s0_.id = s2_.product_id LEFT JOIN sylius_product_option s1_ ON s1_.id = s2_.option_id WHERE s0_.id IN (?) ORDER BY s1_.position ASC
Parameters:
[
  [
    34
  ]
]
1.25 ms
(5.28%)
5
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.created_at AS created_at_2, s1_.updated_at AS updated_at_3, s1_.position AS position_4, s1_.enabled AS enabled_5, s1_.id AS id_6, s1_.version AS version_7, s1_.on_hold AS on_hold_8, s1_.on_hand AS on_hand_9, s1_.tracked AS tracked_10, s1_.width AS width_11, s1_.height AS height_12, s1_.depth AS depth_13, s1_.weight AS weight_14, s1_.shipping_required AS shipping_required_15, s0_.main_taxon_id AS main_taxon_id_16, s0_.vendor_id AS vendor_id_17, s1_.product_id AS product_id_18, s1_.tax_category_id AS tax_category_id_19, s1_.shipping_category_id AS shipping_category_id_20 FROM sylius_product s0_ LEFT JOIN sylius_product_variant s1_ ON s0_.id = s1_.product_id WHERE s0_.id IN (?) ORDER BY s1_.position ASC
Parameters:
[
  [
    34
  ]
]
1.09 ms
(4.61%)
5
SELECT s0_.id AS id_0, s1_.price AS price_1, s1_.original_price AS original_price_2, s1_.channel_code AS channel_code_3, s1_.id AS id_4, s0_.product_id AS product_id_5, s0_.tax_category_id AS tax_category_id_6, s0_.shipping_category_id AS shipping_category_id_7, s1_.product_variant_id AS product_variant_id_8 FROM sylius_product_variant s0_ LEFT JOIN sylius_channel_pricing s1_ ON s0_.id = s1_.product_variant_id WHERE s0_.id IN (?)
Parameters:
[
  [
    35
  ]
]
1.08 ms
(4.59%)
5
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s0_.main_taxon_id AS main_taxon_id_4, s0_.vendor_id AS vendor_id_5, s1_.owner_id AS owner_id_6 FROM sylius_product s0_ LEFT JOIN sylius_product_image s1_ ON s0_.id = s1_.owner_id WHERE s0_.id IN (?)
Parameters:
[
  [
    34
  ]
]
1.02 ms
(4.31%)
5
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s0_.product_id AS product_id_3, s0_.tax_category_id AS tax_category_id_4, s0_.shipping_category_id AS shipping_category_id_5, s1_.option_id AS option_id_6 FROM sylius_product_variant s0_ LEFT JOIN sylius_product_variant_option_value s2_ ON s0_.id = s2_.variant_id LEFT JOIN sylius_product_option_value s1_ ON s1_.id = s2_.option_value_id WHERE s0_.id IN (?)
Parameters:
[
  [
    35
  ]
]
1.00 ms
(4.25%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.category = ?
Parameters:
[
  1
]
0.97 ms
(4.10%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
0.90 ms
(3.83%)
2
SELECT COUNT(m0_.id) AS sclr_0 FROM monsieurbiz_cms_page m0_ INNER JOIN monsieurbiz_cms_page_translation m1_ ON m0_.id = m1_.translatable_id AND (m1_.locale = ?) WHERE m1_.slug = ? AND EXISTS (SELECT 1 FROM monsieurbiz_cms_page_channels m2_ WHERE m2_.page_id = m0_.id AND m2_.channel_id IN (?)) AND m0_.enabled = 1
Parameters:
[
  "fr_FR"
  "products/sac-vomitoire"
  1
]
0.84 ms
(3.58%)
5
SELECT t0.is_packed_product AS is_packed_product_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.product_id AS product_id_5 FROM bitbag_product_bundle t0 WHERE t0.product_id = ?
Parameters:
[
  34
]
0.75 ms
(3.16%)
3
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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0
Parameters:
[]
0.72 ms
(3.03%)
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.default_locale_id AS default_locale_id_17, t18.code AS code_19, t18.created_at AS created_at_20, t18.updated_at AS updated_at_21, t18.id AS id_22, t0.base_currency_id AS base_currency_id_23, t24.code AS code_25, t24.created_at AS created_at_26, t24.updated_at AS updated_at_27, t24.id AS id_28, t0.default_tax_zone_id AS default_tax_zone_id_29, t0.menu_taxon_id AS menu_taxon_id_30, t0.shop_billing_data_id AS shop_billing_data_id_31 FROM sylius_channel t0 INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id WHERE t0.hostname = ? LIMIT 1
Parameters:
[
  "apps.collab.dev0.caramia.fr"
]
0.65 ms
(2.75%)
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.default_locale_id AS default_locale_id_17, t18.code AS code_19, t18.created_at AS created_at_20, t18.updated_at AS updated_at_21, t18.id AS id_22, t0.base_currency_id AS base_currency_id_23, t24.code AS code_25, t24.created_at AS created_at_26, t24.updated_at AS updated_at_27, t24.id AS id_28, t0.default_tax_zone_id AS default_tax_zone_id_29, t0.menu_taxon_id AS menu_taxon_id_30, t0.shop_billing_data_id AS shop_billing_data_id_31 FROM sylius_channel t0 INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id
Parameters:
[]
0.57 ms
(2.40%)
3
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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  5
]
0.37 ms
(1.59%)
1
SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.variant_selection_method AS variant_selection_method_5, s0_.average_rating AS average_rating_6, s1_.name AS name_7, s1_.slug AS slug_8, s1_.description AS description_9, s1_.meta_keywords AS meta_keywords_10, s1_.meta_description AS meta_description_11, s1_.id AS id_12, s1_.short_description AS short_description_13, s1_.locale AS locale_14, s0_.main_taxon_id AS main_taxon_id_15, s0_.vendor_id AS vendor_id_16, s1_.translatable_id AS translatable_id_17 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE EXISTS (SELECT 1 FROM sylius_product_channels s2_ WHERE s2_.product_id = s0_.id AND s2_.channel_id IN (?)) AND s0_.enabled = ? ORDER BY s0_.created_at DESC LIMIT 4
Parameters:
[
  "fr_FR"
  1
  1
]
0.34 ms
(1.43%)
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 = ?
Parameters:
[
  1
]
0.27 ms
(1.16%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.association_type_id AS association_type_id_4, t0.product_id AS product_id_5 FROM sylius_product_association t0 WHERE t0.product_id = ?
Parameters:
[
  34
]
0.21 ms
(0.90%)
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.21 ms
(0.87%)
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
]

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
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\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\Core\Model\ShopBillingData No errors.
Odiseo\SyliusVendorPlugin\Entity\Vendor No errors.
App\Entity\Vendor\Vendor No errors.
Sylius\Component\Addressing\Model\Country No errors.
App\Entity\Addressing\Country No errors.
MonsieurBiz\SyliusCmsPagePlugin\Entity\PageTranslation No errors.
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
App\Entity\Product\Product No errors.
Sylius\Component\Product\Model\ProductTranslation No errors.
Sylius\Component\Core\Model\ProductTranslation No errors.
App\Entity\Product\ProductTranslation No errors.
BitBag\SyliusProductBundlePlugin\Entity\ProductBundle 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 No errors.
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\Customer\Model\Customer No errors.
Sylius\Component\Core\Model\Customer No errors.
App\Entity\Customer\Customer No errors.
Sylius\Component\Taxation\Model\TaxCategory No errors.
App\Entity\Taxation\TaxCategory No errors.
Sylius\Component\Shipping\Model\ShippingCategory No errors.
App\Entity\Shipping\ShippingCategory No errors.
Sylius\Component\Product\Model\ProductVariantTranslation No errors.
App\Entity\Product\ProductVariantTranslation No errors.
Sylius\Component\Core\Model\ChannelPricing No errors.
App\Entity\Channel\ChannelPricing No errors.
Sylius\Component\Product\Model\ProductOptionValue No errors.
App\Entity\Product\ProductOptionValue No errors.
BitBag\SyliusProductBundlePlugin\Entity\ProductBundleOrderItem No errors.
Sylius\Component\Currency\Model\ExchangeRate No errors.
App\Entity\Currency\ExchangeRate No errors.
Sylius\Component\Promotion\Model\PromotionCoupon No errors.
Sylius\Component\Core\Model\PromotionCoupon No errors.
App\Entity\Promotion\PromotionCoupon No errors.
App\Entity\Invoice 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\Shipping\Model\Shipment No errors.
Sylius\Component\Core\Model\Shipment No errors.
App\Entity\Shipping\Shipment 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\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\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
App\Entity\Shipping\ShippingMethod No errors.
Odiseo\SyliusVendorPlugin\Entity\VendorTranslation No errors.
Odiseo\SyliusVendorPlugin\Entity\VendorEmail No errors.
Sylius\Component\Addressing\Model\Province No errors.
App\Entity\Addressing\Province No errors.
BitBag\SyliusProductBundlePlugin\Entity\ProductBundleItem 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\ProductAssociationType No errors.
App\Entity\Product\ProductAssociationType No errors.
Sylius\Component\Product\Model\ProductOptionTranslation No errors.
App\Entity\Product\ProductOptionTranslation No errors.
Sylius\Component\Customer\Model\CustomerGroup No errors.
App\Entity\Customer\CustomerGroup No errors.
Sylius\Component\User\Model\User No errors.
Sylius\Component\Core\Model\ShopUser No errors.
App\Entity\User\ShopUser No errors.
Sylius\Component\Taxation\Model\TaxRate No errors.
Sylius\Component\Core\Model\TaxRate No errors.
App\Entity\Taxation\TaxRate No errors.
Sylius\Component\Product\Model\ProductOptionValueTranslation No errors.
App\Entity\Product\ProductOptionValueTranslation No errors.
Payum\Core\Model\Token No errors.
Payum\Core\Model\Payment No errors.
Payum\Core\Model\Payout No errors.
Payum\Core\Model\GatewayConfig No errors.
Payum\Core\Model\ArrayObject No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\ContactRequest 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\ProductAssociationTypeTranslation No errors.
App\Entity\Product\ProductAssociationTypeTranslation No errors.
Sylius\Component\Core\Model\AdminUser No errors.
App\Entity\User\AdminUser No errors.
Sylius\Component\Order\Model\OrderSequence No errors.
Sylius\Component\Core\Model\OrderSequence No errors.
App\Entity\Order\OrderSequence No errors.
Sylius\Component\Order\Model\OrderItemUnit No errors.
Sylius\Component\Core\Model\OrderItemUnit No errors.
App\Entity\Order\OrderItemUnit No errors.
App\Entity\Menu No errors.
App\Entity\Slide No errors.
Sylius\Bundle\PayumBundle\Model\PaymentSecurityToken No errors.
App\Entity\Payment\PaymentSecurityToken No errors.
Sylius\Bundle\PayumBundle\Model\GatewayConfig No errors.
App\Entity\Payment\GatewayConfig No errors.
Sylius\Component\Payment\Model\PaymentMethod No errors.
Sylius\Component\Core\Model\PaymentMethod No errors.
App\Entity\Payment\PaymentMethod No errors.
Sylius\Component\Payment\Model\PaymentMethodTranslation No errors.
App\Entity\Payment\PaymentMethodTranslation No errors.
Sylius\Component\Shipping\Model\ShippingMethodTranslation No errors.
App\Entity\Shipping\ShippingMethodTranslation No errors.
App\Entity\SlideImage No errors.
App\Entity\Media No errors.
Sylius\Component\Shipping\Model\ShipmentUnit No errors.
Sylius\Component\Shipping\Model\ShippingMethodRule No errors.
Sylius\Component\Addressing\Model\AddressLogEntry No errors.
Sylius\Component\Inventory\Model\InventoryUnit No errors.
Sylius\Component\User\Model\UserOAuth No errors.
Sylius\Component\Review\Model\Reviewer No errors.
Sylius\Component\Core\Model\AvatarImage No errors.