Query Metrics

102 Database Queries
18 Different statements
13.75 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.73 ms
(41.70%)
40
SELECT t0.id AS id_1, t0.product_variant_id AS product_variant_id_2, t3.code AS code_4, t3.created_at AS created_at_5, t3.updated_at AS updated_at_6, t3.position AS position_7, t3.enabled AS enabled_8, t3.id AS id_9, t3.version AS version_10, t3.on_hold AS on_hold_11, t3.on_hand AS on_hand_12, t3.tracked AS tracked_13, t3.width AS width_14, t3.height AS height_15, t3.depth AS depth_16, t3.weight AS weight_17, t3.shipping_required AS shipping_required_18, t3.incoming_stock AS incoming_stock_19, t3.date_incoming_stock AS date_incoming_stock_20, t3.main_material AS main_material_21, t3.gift_for AS gift_for_22, t3.coating_type AS coating_type_23, t3.coating_vegetal AS coating_vegetal_24, t3.badge AS badge_25, t3.tags AS tags_26, t3.price_per_two AS price_per_two_27, t3.old_url AS old_url_28, t3.is_blocked AS is_blocked_29, t3.product_id AS product_id_30, t3.tax_category_id AS tax_category_id_31, t3.shipping_category_id AS shipping_category_id_32, t0.taxon_id AS taxon_id_33, t34.code AS code_35, t34.tree_left AS tree_left_36, t34.tree_right AS tree_right_37, t34.tree_level AS tree_level_38, t34.position AS position_39, t34.enabled AS enabled_40, t34.id AS id_41, t34.created_at AS created_at_42, t34.updated_at AS updated_at_43, t34.category_type AS category_type_44, t34.referencement AS referencement_45, t34.referencementen AS referencementen_46, t34.seo_links AS seo_links_47, t34.single_article_category_title AS single_article_category_title_48, t34.single_article_category_title_en AS single_article_category_title_en_49, t34.ctas AS ctas_50, t34.ctasen AS ctasen_51, t34.filters AS filters_52, t34.automatic AS automatic_53, t34.tree_root AS tree_root_54, t34.parent_id AS parent_id_55, t34.article_id AS article_id_56, t34.article_category_id AS article_category_id_57 FROM sylius_product_variant_taxon t0 LEFT JOIN sylius_product_variant t3 ON t0.product_variant_id = t3.id LEFT JOIN sylius_taxon t34 ON t0.taxon_id = t34.id WHERE t0.product_variant_id = ?
Parameters:
[
  41526
]
3.64 ms
(26.50%)
40
SELECT t0.locale_code AS locale_code_1, t0.text_value AS text_value_2, t0.boolean_value AS boolean_value_3, t0.integer_value AS integer_value_4, t0.float_value AS float_value_5, t0.datetime_value AS datetime_value_6, t0.date_value AS date_value_7, t0.json_value AS json_value_8, t0.id AS id_9, t0.variant_id AS variant_id_10, t0.attribute_id AS attribute_id_11 FROM sylius_product_variant_attribute_value t0 WHERE t0.variant_id = ?
Parameters:
[
  41526
]
0.50 ms
(3.63%)
1
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.category_type AS category_type_10, t0.referencement AS referencement_11, t0.referencementen AS referencementen_12, t0.seo_links AS seo_links_13, t0.single_article_category_title AS single_article_category_title_14, t0.single_article_category_title_en AS single_article_category_title_en_15, t0.ctas AS ctas_16, t0.ctasen AS ctasen_17, t0.filters AS filters_18, t0.automatic AS automatic_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.article_id AS article_id_22, t0.article_category_id AS article_category_id_23 FROM sylius_taxon t0
Parameters:
[]
0.50 ms
(3.61%)
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_.category_type AS category_type_9, s0_.referencement AS referencement_10, s0_.referencementen AS referencementen_11, s0_.seo_links AS seo_links_12, s0_.single_article_category_title AS single_article_category_title_13, s0_.single_article_category_title_en AS single_article_category_title_en_14, s0_.ctas AS ctas_15, s0_.ctasen AS ctasen_16, s0_.filters AS filters_17, s0_.automatic AS automatic_18, s1_.name AS name_19, s1_.description AS description_20, s1_.id AS id_21, s1_.seo_title AS seo_title_22, s1_.seo_meta_description AS seo_meta_description_23, s1_.rectangle_orange_text AS rectangle_orange_text_24, s1_.rectangle_orange_text_button AS rectangle_orange_text_button_25, s1_.rectangle_orange_text_url AS rectangle_orange_text_url_26, s1_.link_image_lastlevel1 AS link_image_lastlevel1_27, s1_.link_image_lastlevel2 AS link_image_lastlevel2_28, s1_.slug AS slug_29, s1_.locale AS locale_30, s0_.tree_root AS tree_root_31, s0_.parent_id AS parent_id_32, s0_.article_id AS article_id_33, s0_.article_category_id AS article_category_id_34, s1_.translatable_id AS translatable_id_35 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 = ?
Parameters:
[
  1
  "nos-produits/accessoires-de-sacs/portefeuilles"
  "fr_FR"
]
0.49 ms
(3.57%)
1
SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.position AS position_3, s0_.enabled AS enabled_4, s0_.id AS id_5, s0_.version AS version_6, s0_.on_hold AS on_hold_7, s0_.on_hand AS on_hand_8, s0_.tracked AS tracked_9, s0_.width AS width_10, s0_.height AS height_11, s0_.depth AS depth_12, s0_.weight AS weight_13, s0_.shipping_required AS shipping_required_14, s0_.incoming_stock AS incoming_stock_15, s0_.date_incoming_stock AS date_incoming_stock_16, s0_.main_material AS main_material_17, s0_.gift_for AS gift_for_18, s0_.coating_type AS coating_type_19, s0_.coating_vegetal AS coating_vegetal_20, s0_.badge AS badge_21, s0_.tags AS tags_22, s0_.price_per_two AS price_per_two_23, s0_.old_url AS old_url_24, s0_.is_blocked AS is_blocked_25, s0_.product_id AS product_id_26, s0_.tax_category_id AS tax_category_id_27, s0_.shipping_category_id AS shipping_category_id_28 FROM sylius_product_variant s0_ WHERE s0_.id IN (?) ORDER BY FIELD(s0_.id, 41526, 41871, 41525, 41460, 41463, 34654, 34653, 34655, 37169, 37166, 37819, 36361, 37167, 38770, 40809, 38192, 40980, 36944, 40406, 40350, 37823, 41309, 38774, 40313, 39474, 39794, 33688, 38859, 40938, 38294, 34523, 38775, 40854, 37900, 36281, 38293, 38860, 32688, 38651, 38715) ASC
Parameters:
[
  [
    "41526"
    "41871"
    "41525"
    "41460"
    "41463"
    "34654"
    "34653"
    "34655"
    "37169"
    "37166"
    "37819"
    "36361"
    "37167"
    "38770"
    "40809"
    "38192"
    "40980"
    "36944"
    "40406"
    "40350"
    "37823"
    "41309"
    "38774"
    "40313"
    "39474"
    "39794"
    "33688"
    "38859"
    "40938"
    "38294"
    "34523"
    "38775"
    "40854"
    "37900"
    "36281"
    "38293"
    "38860"
    "32688"
    "38651"
    "38715"
  ]
]
0.42 ms
(3.04%)
2
SELECT s0_.source AS source_0, s0_.destination AS destination_1, s0_.permanent AS permanent_2, s0_.count AS count_3, s0_.last_accessed AS last_accessed_4, s0_.enabled AS enabled_5, s0_.only_404 AS only_404_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s1_.code AS code_10, s1_.name AS name_11, s1_.color AS color_12, s1_.description AS description_13, s1_.enabled AS enabled_14, s1_.hostname AS hostname_15, s1_.created_at AS created_at_16, s1_.updated_at AS updated_at_17, s1_.id AS id_18, s1_.theme_name AS theme_name_19, s1_.tax_calculation_strategy AS tax_calculation_strategy_20, s1_.contact_email AS contact_email_21, s1_.contact_phone_number AS contact_phone_number_22, s1_.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_23, s1_.skipping_payment_step_allowed AS skipping_payment_step_allowed_24, s1_.account_verification_required AS account_verification_required_25, s1_.shop_billing_data_id AS shop_billing_data_id_26, s1_.default_locale_id AS default_locale_id_27, s1_.base_currency_id AS base_currency_id_28, s1_.default_tax_zone_id AS default_tax_zone_id_29, s1_.menu_taxon_id AS menu_taxon_id_30 FROM setono_sylius_redirect__redirect s0_ LEFT JOIN setono_sylius_redirect__redirect_channels s2_ ON s0_.id = s2_.redirect_id LEFT JOIN sylius_channel s1_ ON s1_.id = s2_.channel_id WHERE s0_.source = ? AND s0_.enabled = 1 AND s0_.only_404 = ?
Parameters:
[
  "/nos-produits/accessoires-de-sacs/portefeuilles"
  0
]
0.36 ms
(2.65%)
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.shop_billing_data_id AS shop_billing_data_id_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
Parameters:
[]
0.35 ms
(2.55%)
3
SELECT t0.name AS name_1, t0.description AS description_2, t0.meta_keywords AS meta_keywords_3, t0.meta_description AS meta_description_4, t0.id AS id_5, t0.short_description AS short_description_6, t0.advantages AS advantages_7, t0.maintenance AS maintenance_8, t0.small_add_text AS small_add_text_9, t0.slug AS slug_10, t0.locale AS locale_11, t0.translatable_id AS translatable_id_12 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  1249
  "fr_FR"
]
0.26 ms
(1.87%)
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.shop_billing_data_id AS shop_billing_data_id_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = ? LIMIT 1
Parameters:
[
  "ppmc-staging.webapic.com"
]
0.26 ms
(1.86%)
1
SELECT t0.name AS name_1, t0.new AS new_2, t0.enabled AS enabled_3, t0.category AS category_4, t0.main_color AS main_color_5, t0.colors AS colors_6, t0.dateRelease AS dateRelease_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.visible AS visible_10, t0.replay AS replay_11, t0.id AS id_12, t0.article_id AS article_id_13, t0.product_option_value_id AS product_option_value_id_14 FROM site_collection t0 WHERE t0.product_option_value_id IN (?)
Parameters:
[
  [
    "3696"
    "3956"
    "4040"
    "4088"
    "3694"
    "3970"
    "4056"
    "4059"
    "4089"
    "4132"
    "4140"
    "4141"
    "4190"
    "4191"
    "4192"
    "4193"
    "4211"
    "4212"
    "4248"
    "4250"
    "4253"
    "3579"
    "3672"
    "3835"
    "3905"
    "3926"
    "4042"
    "4055"
    "4085"
    "4087"
    "4116"
    "4133"
    "4213"
    "4258"
    "51"
  ]
]
0.23 ms
(1.70%)
1
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enabled AS enabled_4, t0.id AS id_5, t0.variant_selection_method AS variant_selection_method_6, t0.average_rating AS average_rating_7, t0.conditioning AS conditioning_8, t0.strong_points AS strong_points_9, t0.google_product_type_id AS google_product_type_id_10, t0.gift_wrap_myself AS gift_wrap_myself_11, t0.gift_wrap_by_ppmc AS gift_wrap_by_ppmc_12, t0.main_taxon_id AS main_taxon_id_13, t0.article_id AS article_id_14 FROM sylius_product t0 WHERE t0.id IN (?) AND t0.enabled = ? ORDER BY t0.code ASC
Parameters:
[
  [
    1600
    2239
    1249
  ]
  1
]
0.21 ms
(1.54%)
2
SELECT t0.name AS name_1, t0.description AS description_2, t0.id AS id_3, t0.seo_title AS seo_title_4, t0.seo_meta_description AS seo_meta_description_5, t0.rectangle_orange_text AS rectangle_orange_text_6, t0.rectangle_orange_text_button AS rectangle_orange_text_button_7, t0.rectangle_orange_text_url AS rectangle_orange_text_url_8, t0.link_image_lastlevel1 AS link_image_lastlevel1_9, t0.link_image_lastlevel2 AS link_image_lastlevel2_10, t0.slug AS slug_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  162
  "fr_FR"
]
0.18 ms
(1.32%)
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.16 ms
(1.14%)
1
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.category_type AS category_type_10, t0.referencement AS referencement_11, t0.referencementen AS referencementen_12, t0.seo_links AS seo_links_13, t0.single_article_category_title AS single_article_category_title_14, t0.single_article_category_title_en AS single_article_category_title_en_15, t0.ctas AS ctas_16, t0.ctasen AS ctasen_17, t0.filters AS filters_18, t0.automatic AS automatic_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.article_id AS article_id_22, t0.article_category_id AS article_category_id_23 FROM sylius_taxon t0 WHERE t0.id IN (?)
Parameters:
[
  [
    163
    164
    166
    167
    168
    169
    170
    171
    172
    174
  ]
]
0.13 ms
(0.92%)
1
SELECT t0.display_type AS display_type_1, t0.filter_type AS filter_type_2, t0.indexable_seo AS indexable_seo_3, t0.enabled AS enabled_4, t0.position AS position_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.id AS id_8, t0.product_attribute_id AS product_attribute_id_9, t0.product_option_id AS product_option_id_10 FROM site_filter_facet t0 WHERE t0.enabled = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
0.12 ms
(0.87%)
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.11 ms
(0.83%)
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.10 ms
(0.71%)
1
SELECT * FROM sylius_taxon_translation
                WHERE translatable_id = :translatable_id
                AND locale = :locale
Parameters:
[
  "translatable_id" => 165
  "locale" => "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\SyliusMailTemplatePlugin\Entity\EmailTemplate 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.
Sylius\Component\Core\Model\ShopBillingData No errors.
Sylius\Component\Locale\Model\Locale No errors.
Sylius\Component\Currency\Model\Currency No errors.
Sylius\Component\Addressing\Model\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.
Sylius\Component\Addressing\Model\Province No errors.
App\Entity\SitePageCMS No errors.
App\Entity\SiteArticleCategory No errors.
App\Entity\SiteSelectionCategory No errors.
App\Entity\SiteCollection No errors.
BitBag\SyliusCmsPlugin\Entity\Block No errors.
App\Entity\Bitbag\Block No errors.
BitBag\SyliusCmsPlugin\Entity\Media No errors.
BitBag\SyliusCmsPlugin\Entity\Page No errors.
App\Entity\Bitbag\Page No errors.
Sylius\Component\Promotion\Model\Promotion No errors.
Sylius\Component\Core\Model\Promotion No errors.
App\Entity\SiteMenuHeader No errors.
App\Entity\SiteArticle 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\SiteMenuFooter No errors.
App\Entity\SiteSelection No errors.
App\Entity\SiteBlocInsurance No errors.
App\Entity\SiteSearchSuggestText No errors.
App\Entity\SiteSearchSuggestProductVariant No errors.
Setono\SyliusRedirectPlugin\Model\Redirect 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\ProductVariant No errors.
Sylius\Component\Core\Model\ProductVariant No errors.
App\Entity\Product\ProductVariant
  • The field App\Entity\Product\ProductVariant#taxons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductVariantTaxon#productVariant does not contain the required 'inversedBy="taxons"' attribute.
Sylius\Component\Attribute\Model\AttributeValue No errors.
Sylius\Component\Product\Model\ProductAttributeValue No errors.
Sylius\Component\Attribute\Model\Attribute No errors.
Sylius\Component\Product\Model\ProductAttribute No errors.
App\Entity\SiteFilterFacet No errors.
Sylius\Component\Product\Model\ProductOption No errors.
App\Entity\SiteFilterFacetTranslation 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.
Sylius\Component\Core\Model\ProductImage No errors.
Sylius\Component\Product\Model\ProductAssociation No errors.
Sylius\Component\Review\Model\Review No errors.
Sylius\Component\Core\Model\ProductReview No errors.
Sylius\Component\Customer\Model\Customer No errors.
Sylius\Component\Core\Model\Customer No errors.
App\Entity\Customer\Customer
  • The field App\Entity\Customer\Customer#wishlistProductVariants is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SiteWishlistProductVariant#customer does not contain the required 'inversedBy="wishlistProductVariants"' attribute.
  • The field App\Entity\Customer\Customer#newsletterPreference is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SiteNewsletterPreference#customer does not contain the required 'inversedBy="newsletterPreference"' attribute.
Sylius\Component\Product\Model\ProductOptionValue No errors.
App\Entity\Product\ProductOptionValue No errors.
App\Entity\SiteCollectionImage No errors.
App\Entity\SiteCollectionTranslation No errors.
Sylius\Component\Taxation\Model\TaxCategory No errors.
Sylius\Component\Shipping\Model\ShippingCategory No errors.
App\Entity\Product\ProductVariantTaxon No errors.
Sylius\Component\Product\Model\ProductVariantTranslation No errors.
App\Entity\Product\ProductVariantTranslation No errors.
App\Entity\Product\ProductVariantAttributeValue No errors.
Sylius\Component\Core\Model\ChannelPricing No errors.