https://6nergiesboutique.arobases.fr/solar_kit/5

Query Metrics

17 Database Queries
14 Different statements
1325.54 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.32 ms
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_days_estimated AS shipping_days_estimated_17, t0.google_analytics_code AS google_analytics_code_18, t0.google_tag_manager_id AS google_tag_manager_id_19, t0.considerTaxesForProfessionalCustomer AS considerTaxesForProfessionalCustomer_20, t0.default_locale_id AS default_locale_id_21, t22.code AS code_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.id AS id_26, t0.base_currency_id AS base_currency_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.default_tax_zone_id AS default_tax_zone_id_33, t0.menu_taxon_id AS menu_taxon_id_34, t0.shop_billing_data_id AS shop_billing_data_id_35, t0.referenceableContent_id AS referenceableContent_id_36 FROM sylius_channel t0 INNER JOIN sylius_locale t22 ON t0.default_locale_id = t22.id INNER JOIN sylius_currency t28 ON t0.base_currency_id = t28.id WHERE t0.hostname = ? LIMIT 1
Parameters:
[
  "6nergiesboutique.arobases.fr"
]
2 0.27 ms
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_days_estimated AS shipping_days_estimated_17, t0.google_analytics_code AS google_analytics_code_18, t0.google_tag_manager_id AS google_tag_manager_id_19, t0.considerTaxesForProfessionalCustomer AS considerTaxesForProfessionalCustomer_20, t0.default_locale_id AS default_locale_id_21, t22.code AS code_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.id AS id_26, t0.base_currency_id AS base_currency_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.default_tax_zone_id AS default_tax_zone_id_33, t0.menu_taxon_id AS menu_taxon_id_34, t0.shop_billing_data_id AS shop_billing_data_id_35, t0.referenceableContent_id AS referenceableContent_id_36 FROM sylius_channel t0 INNER JOIN sylius_locale t22 ON t0.default_locale_id = t22.id INNER JOIN sylius_currency t28 ON t0.base_currency_id = t28.id
Parameters:
[]
3 0.16 ms
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
]
4 0.16 ms
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
]
5 0.18 ms
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
]
6 1319.18 ms
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 = ?
Parameters:
[
  1
  ""
]
7 0.12 ms
"START TRANSACTION"
Parameters:
[]
8 0.19 ms
INSERT INTO bitbag_wishlist (name, token, shop_user_id, channel_id) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "Wishlist"
  2 => BitBag\SyliusWishlistPlugin\Entity\WishlistToken {#6425
    __toString(): "a51b56db-fae5-4db3-9fa6-2a655018823d"
  }
  3 => null
  4 => 1
]
9 0.12 ms
"COMMIT"
Parameters:
[]
10 0.37 ms
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_.shipping_days_estimated AS shipping_days_estimated_26, s1_.google_analytics_code AS google_analytics_code_27, s1_.google_tag_manager_id AS google_tag_manager_id_28, s1_.considerTaxesForProfessionalCustomer AS considerTaxesForProfessionalCustomer_29, s1_.default_locale_id AS default_locale_id_30, s1_.base_currency_id AS base_currency_id_31, s1_.default_tax_zone_id AS default_tax_zone_id_32, s1_.menu_taxon_id AS menu_taxon_id_33, s1_.shop_billing_data_id AS shop_billing_data_id_34, s1_.referenceableContent_id AS referenceableContent_id_35 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:
[
  "/solar_kit/5"
  0
]
11 0.77 ms
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.color AS color_10, t0.oldId AS oldId_11, t0.visibleInMenu AS visibleInMenu_12, t0.flagshipTaxon AS flagshipTaxon_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "solar_kit"
]
12 1.86 ms
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, s0_.file_path AS file_path_7, s0_.archived_at AS archived_at_8, s0_.seo_brand AS seo_brand_9, s0_.seo_gtin8 AS seo_gtin8_10, s0_.seo_gtin13 AS seo_gtin13_11, s0_.seo_gtin14 AS seo_gtin14_12, s0_.seo_mpn AS seo_mpn_13, s0_.seo_isbn AS seo_isbn_14, s0_.seo_sku AS seo_sku_15, s0_.seo_offer_aggregated AS seo_offer_aggregated_16, s0_.searchable AS searchable_17, s0_.filterable AS filterable_18, s0_.search_weight AS search_weight_19, s1_.name AS name_20, s1_.slug AS slug_21, s1_.description AS description_22, s1_.meta_keywords AS meta_keywords_23, s1_.meta_description AS meta_description_24, s1_.id AS id_25, s1_.short_description AS short_description_26, s1_.technical_documentation AS technical_documentation_27, s1_.composition AS composition_28, s1_.subtitle AS subtitle_29, s1_.informations AS informations_30, s1_.advantages AS advantages_31, s1_.guarantees AS guarantees_32, s1_.locale AS locale_33, s0_.main_taxon_id AS main_taxon_id_34, s0_.supplier_id AS supplier_id_35, s0_.brand_id AS brand_id_36, s0_.referenceableContent_id AS referenceableContent_id_37, s1_.translatable_id AS translatable_id_38 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) INNER JOIN sylius_product_taxon s2_ ON s0_.id = s2_.product_id WHERE s2_.taxon_id = ? AND EXISTS (SELECT 1 FROM sylius_product_channels s3_ WHERE s3_.product_id = s0_.id AND s3_.channel_id IN (?)) AND s0_.enabled = 1 ORDER BY s2_.position ASC LIMIT 5
Parameters:
[
  "fr_FR"
  10
  1
]
13 0.43 ms
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:
[
  65
]
14 0.22 ms
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:
[
  13
]
15 0.55 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM app_brand t0 WHERE t0.id IN (?)
Parameters:
[
  [
    7
  ]
]
16 0.37 ms
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_days_estimated AS shipping_days_estimated_17, t0.google_analytics_code AS google_analytics_code_18, t0.google_tag_manager_id AS google_tag_manager_id_19, t0.considerTaxesForProfessionalCustomer AS considerTaxesForProfessionalCustomer_20, t0.default_locale_id AS default_locale_id_21, t22.code AS code_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.id AS id_26, t0.base_currency_id AS base_currency_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.default_tax_zone_id AS default_tax_zone_id_33, t0.menu_taxon_id AS menu_taxon_id_34, t0.shop_billing_data_id AS shop_billing_data_id_35, t0.referenceableContent_id AS referenceableContent_id_36 FROM sylius_channel t0 INNER JOIN sylius_locale t22 ON t0.default_locale_id = t22.id INNER JOIN sylius_currency t28 ON t0.base_currency_id = t28.id
Parameters:
[]
17 0.28 ms
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_.shipping_days_estimated AS shipping_days_estimated_26, s1_.google_analytics_code AS google_analytics_code_27, s1_.google_tag_manager_id AS google_tag_manager_id_28, s1_.considerTaxesForProfessionalCustomer AS considerTaxesForProfessionalCustomer_29, s1_.default_locale_id AS default_locale_id_30, s1_.base_currency_id AS base_currency_id_31, s1_.default_tax_zone_id AS default_tax_zone_id_32, s1_.menu_taxon_id AS menu_taxon_id_33, s1_.shop_billing_data_id AS shop_billing_data_id_34, s1_.referenceableContent_id AS referenceableContent_id_35 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:
[
  "/solar_kit/5"
  0
]

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\SyliusWishlistPlugin\Entity\Wishlist No errors.
BitBag\SyliusCmsPlugin\Entity\Page No errors.
Sylius\Component\Taxonomy\Model\Taxon No errors.
Sylius\Component\Core\Model\Taxon No errors.
App\Entity\Taxonomy\Taxon No errors.
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
App\Entity\Product\Product
  • The association App\Entity\Product\Product#supplier refers to the inverse side field App\Entity\Supplier\Supplier#Product which does not exist.
Sylius\Component\Order\Model\Order No errors.
Sylius\Component\Core\Model\Order No errors.
App\Entity\Order\Order No errors.
Sylius\Component\Taxation\Model\TaxRate No errors.
Sylius\Component\Core\Model\TaxRate No errors.
App\Entity\Taxation\TaxRate 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\Core\Model\ShopBillingData No errors.
Dedi\SyliusSEOPlugin\Entity\SEOContent No errors.
Sylius\Component\Addressing\Model\Country No errors.
App\Entity\Addressing\Country No errors.
Sylius\Component\User\Model\User No errors.
Sylius\Component\Core\Model\ShopUser No errors.
App\Entity\User\ShopUser No errors.
BitBag\SyliusWishlistPlugin\Entity\WishlistProduct 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\Addressing\Model\Address No errors.
Sylius\Component\Core\Model\Address No errors.
App\Entity\Addressing\Address No errors.
Sylius\Component\Payment\Model\PaymentMethod No errors.
Sylius\Component\Core\Model\PaymentMethod No errors.
App\Entity\Payment\PaymentMethod No errors.
Setono\SyliusRedirectPlugin\Model\Redirect 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.
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.
App\Entity\Supplier\Supplier No errors.
App\Entity\Brand\Brand No errors.
App\Entity\Product\Pictogram No errors.
App\Entity\Product\ProductFile No errors.
App\Entity\Configurator\ConfiguratorOption
  • The mappings App\Entity\Configurator\ConfiguratorOption#configuratotOptionValues and App\Entity\Configurator\ConfiguratorOptionValue#configuratorOption are inconsistent with each other.
App\Entity\Product\SimpleProductOption No errors.
BitBag\SyliusProductBundlePlugin\Entity\ProductBundle No errors.
BitBag\SyliusProductBundlePlugin\Entity\ProductBundleItem No errors.
Setono\SyliusCalloutPlugin\Model\Callout 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.
App\Entity\Brand\BrandImage No errors.
App\Entity\Brand\BrandTranslation No errors.
BitBag\SyliusCmsPlugin\Entity\Block No errors.
BitBag\SyliusCmsPlugin\Entity\Media No errors.
BitBag\SyliusProductBundlePlugin\Entity\ProductBundleOrderItem No errors.
BitBag\SyliusCmsPlugin\Entity\PageTranslation No errors.
Sylius\Component\Core\Model\ChannelPricing No errors.
App\Entity\Channel\ChannelPricing No errors.
BitBag\SyliusCmsPlugin\Entity\FrequentlyAskedQuestion No errors.
App\Entity\CMS\FrequentlyAskedQuestion No errors.
App\Entity\Shipping\ShippingDeliveryDate No errors.
App\Entity\Parameter\Parameter No errors.
Sylius\Component\Promotion\Model\Promotion No errors.
Sylius\Component\Core\Model\Promotion No errors.
App\Entity\Promotion\Promotion No errors.
Sylius\Component\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
App\Entity\Shipping\ShippingMethod No errors.
App\Entity\Partners\Partner No errors.
Sylius\RefundPlugin\Entity\Refund No errors.
Sylius\Component\Order\Model\OrderItemUnit No errors.
Sylius\Component\Core\Model\OrderItemUnit No errors.
App\Entity\Order\OrderItemUnit No errors.
Sylius\Component\Order\Model\Adjustment No errors.
Sylius\Component\Core\Model\Adjustment No errors.
App\Entity\Order\Adjustment No errors.
Sylius\RefundPlugin\Entity\RefundPayment No errors.
MonsieurBiz\SyliusSettingsPlugin\Entity\Setting\Setting No errors.