https://ppmc-staging.webapic.com/ajax/update-cart/716 Return to referer URL

Query Metrics

44 Database Queries
32 Different statements
6.94 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.53 ms
(7.69%)
2
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.incoming_stock AS incoming_stock_16, t0.date_incoming_stock AS date_incoming_stock_17, t0.main_material AS main_material_18, t0.gift_for AS gift_for_19, t0.coating_type AS coating_type_20, t0.coating_vegetal AS coating_vegetal_21, t0.badge AS badge_22, t0.tags AS tags_23, t0.price_per_two AS price_per_two_24, t0.old_url AS old_url_25, t0.is_blocked AS is_blocked_26, t0.product_id AS product_id_27, t0.tax_category_id AS tax_category_id_28, t0.shipping_category_id AS shipping_category_id_29, t30.id AS id_31, t30.product_variant_id AS product_variant_id_32, t30.taxon_id AS taxon_id_33, t34.locale_code AS locale_code_35, t34.text_value AS text_value_36, t34.boolean_value AS boolean_value_37, t34.integer_value AS integer_value_38, t34.float_value AS float_value_39, t34.datetime_value AS datetime_value_40, t34.date_value AS date_value_41, t34.json_value AS json_value_42, t34.id AS id_43, t34.variant_id AS variant_id_44, t34.attribute_id AS attribute_id_45 FROM sylius_product_variant t0 LEFT JOIN sylius_product_variant_taxon t30 ON t30.product_variant_id = t0.id LEFT JOIN sylius_product_variant_attribute_value t34 ON t34.variant_id = t0.id WHERE t0.id = ?
Parameters:
[
  41500
]
0.52 ms
(7.47%)
3
SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.old_site_id_order AS old_site_id_order_18, s0_.order_divalto_invoice_number AS order_divalto_invoice_number_19, s0_.order_pickup_so_colissimo AS order_pickup_so_colissimo_20, s0_.order_pickup_shop AS order_pickup_shop_21, s0_.order_pickup_name AS order_pickup_name_22, s0_.order_generix_receipt_number AS order_generix_receipt_number_23, s0_.order_generix_marketing_context_id AS order_generix_marketing_context_id_24, s0_.order_panda_panier_id AS order_panda_panier_id_25, s0_.gift_message AS gift_message_26, s0_.gift_wrap_mode AS gift_wrap_mode_27, s0_.origin AS origin_28, s0_.can_loyalty AS can_loyalty_29, s0_.has_loyalty AS has_loyalty_30, s0_.total_loyalty AS total_loyalty_31, s0_.libelle_loyalty AS libelle_loyalty_32, s0_.code_promo AS code_promo_33, s0_.code_promo_valid AS code_promo_valid_34, s0_.apel AS apel_35, s0_.selected_shipping_address_id AS selected_shipping_address_id_36, s0_.selected_billing_address_id AS selected_billing_address_id_37, s0_.channel_id AS channel_id_38, s0_.promotion_coupon_id AS promotion_coupon_id_39, s0_.customer_id AS customer_id_40, s0_.shipping_address_id AS shipping_address_id_41, s0_.billing_address_id AS billing_address_id_42 FROM sylius_order s0_ WHERE s0_.id = ? AND s0_.state = ? AND s0_.channel_id = ?
Parameters:
[
  411
  "cart"
  1
]
0.49 ms
(7.08%)
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.42 ms
(6.00%)
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.36 ms
(5.15%)
3
SELECT t0.name AS name_1, t0.type AS type_2, t0.value AS value_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.id AS id_6 FROM sylius_parameters t0 WHERE t0.type = ? AND t0.name = ? LIMIT 1
Parameters:
[
  "sales"
  "panier_duree_minute"
]
0.32 ms
(4.56%)
1
SELECT t0.number AS number_1, t0.notes AS notes_2, t0.state AS state_3, t0.checkout_completed_at AS checkout_completed_at_4, t0.items_total AS items_total_5, t0.adjustments_total AS adjustments_total_6, t0.total AS total_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.currency_code AS currency_code_11, t0.locale_code AS locale_code_12, t0.checkout_state AS checkout_state_13, t0.payment_state AS payment_state_14, t0.shipping_state AS shipping_state_15, t0.created_by_guest AS created_by_guest_16, t0.token_value AS token_value_17, t0.customer_ip AS customer_ip_18, t0.old_site_id_order AS old_site_id_order_19, t0.order_divalto_invoice_number AS order_divalto_invoice_number_20, t0.order_pickup_so_colissimo AS order_pickup_so_colissimo_21, t0.order_pickup_shop AS order_pickup_shop_22, t0.order_pickup_name AS order_pickup_name_23, t0.order_generix_receipt_number AS order_generix_receipt_number_24, t0.order_generix_marketing_context_id AS order_generix_marketing_context_id_25, t0.order_panda_panier_id AS order_panda_panier_id_26, t0.gift_message AS gift_message_27, t0.gift_wrap_mode AS gift_wrap_mode_28, t0.origin AS origin_29, t0.can_loyalty AS can_loyalty_30, t0.has_loyalty AS has_loyalty_31, t0.total_loyalty AS total_loyalty_32, t0.libelle_loyalty AS libelle_loyalty_33, t0.code_promo AS code_promo_34, t0.code_promo_valid AS code_promo_valid_35, t0.apel AS apel_36, t0.selected_shipping_address_id AS selected_shipping_address_id_37, t0.selected_billing_address_id AS selected_billing_address_id_38, t0.channel_id AS channel_id_39, t0.promotion_coupon_id AS promotion_coupon_id_40, t0.customer_id AS customer_id_41, t0.shipping_address_id AS shipping_address_id_42, t0.billing_address_id AS billing_address_id_43 FROM sylius_order t0 WHERE t0.id = ?
Parameters:
[
  411
]
0.31 ms
(4.48%)
2
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 = ?
Parameters:
[
  1741
]
0.29 ms
(4.12%)
2
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 INNER JOIN sylius_product_image_product_variants ON t0.id = sylius_product_image_product_variants.image_id WHERE sylius_product_image_product_variants.variant_id = ?
Parameters:
[
  41500
]
0.28 ms
(4.11%)
2
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:
[
  1741
  "fr_FR"
]
0.26 ms
(3.79%)
1
SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.old_site_id_client AS old_site_id_client_12, t0.generix_id_customer AS generix_id_customer_13, t0.generix_id_card_customer AS generix_id_card_customer_14, t0.code_lang_alpha3 AS code_lang_alpha3_15, t0.company AS company_16, t0.intra_community_vat AS intra_community_vat_17, t0.origin_of_customer AS origin_of_customer_18, t0.loyalty_points AS loyalty_points_19, t0.last_synchro_date AS last_synchro_date_20, t0.isshop AS isshop_21, t0.customer_group_id AS customer_group_id_22, t23.createdAt AS createdAt_24, t23.updatedAt AS updatedAt_25, t23.id AS id_26, t23.customer_id AS customer_id_27, t23.product_variant_id AS product_variant_id_28, t29.preference AS preference_30, t29.id AS id_31, t29.customer_id AS customer_id_32, t0.favorite_shop_id AS favorite_shop_id_33, t0.customer_shop_id AS customer_shop_id_34, t0.default_address_id AS default_address_id_35, t36.username AS username_37, t36.username_canonical AS username_canonical_38, t36.enabled AS enabled_39, t36.salt AS salt_40, t36.password AS password_41, t36.encoder_name AS encoder_name_42, t36.last_login AS last_login_43, t36.password_reset_token AS password_reset_token_44, t36.password_requested_at AS password_requested_at_45, t36.email_verification_token AS email_verification_token_46, t36.verified_at AS verified_at_47, t36.locked AS locked_48, t36.expires_at AS expires_at_49, t36.credentials_expire_at AS credentials_expire_at_50, t36.roles AS roles_51, t36.email AS email_52, t36.email_canonical AS email_canonical_53, t36.created_at AS created_at_54, t36.updated_at AS updated_at_55, t36.id AS id_56, t36.customer_id AS customer_id_57 FROM sylius_customer t0 LEFT JOIN site_wishlist_product_variant t23 ON t23.customer_id = t0.id LEFT JOIN site_newsletter_preference t29 ON t29.customer_id = t0.id LEFT JOIN sylius_shop_user t36 ON t36.customer_id = t0.id WHERE t0.id = ?
Parameters:
[
  23
]
0.26 ms
(3.69%)
2
SELECT t0.name AS name_1, t0.id AS id_2, t0.description AS description_3, t0.advantages AS advantages_4, t0.maintenance AS maintenance_5, t0.slug AS slug_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM sylius_product_variant_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  41500
  "fr_FR"
]
0.25 ms
(3.61%)
2
SELECT t0.quantity AS quantity_1, t0.unit_price AS unit_price_2, t0.original_unit_price AS original_unit_price_3, t0.units_total AS units_total_4, t0.adjustments_total AS adjustments_total_5, t0.total AS total_6, t0.is_immutable AS is_immutable_7, t0.id AS id_8, t0.product_name AS product_name_9, t0.variant_name AS variant_name_10, t0.version AS version_11, t0.conditioning AS conditioning_12, t0.conditioning_value AS conditioning_value_13, t0.kdo_mail AS kdo_mail_14, t0.kdo_lastname AS kdo_lastname_15, t0.kdo_firstname AS kdo_firstname_16, t0.kdo_message AS kdo_message_17, t0.kdo_code AS kdo_code_18, t0.kdo_passwd AS kdo_passwd_19, t0.order_id AS order_id_20, t0.variant_id AS variant_id_21 FROM sylius_order_item t0 WHERE t0.order_id = ?
Parameters:
[
  411
]
0.25 ms
(3.57%)
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.23 ms
(3.32%)
2
SELECT t0.quantity AS quantity_1, t0.unit_price AS unit_price_2, t0.original_unit_price AS original_unit_price_3, t0.units_total AS units_total_4, t0.adjustments_total AS adjustments_total_5, t0.total AS total_6, t0.is_immutable AS is_immutable_7, t0.id AS id_8, t0.product_name AS product_name_9, t0.variant_name AS variant_name_10, t0.version AS version_11, t0.conditioning AS conditioning_12, t0.conditioning_value AS conditioning_value_13, t0.kdo_mail AS kdo_mail_14, t0.kdo_lastname AS kdo_lastname_15, t0.kdo_firstname AS kdo_firstname_16, t0.kdo_message AS kdo_message_17, t0.kdo_code AS kdo_code_18, t0.kdo_passwd AS kdo_passwd_19, t0.order_id AS order_id_20, t0.variant_id AS variant_id_21 FROM sylius_order_item t0 WHERE t0.id = ?
Parameters:
[
  716
]
0.20 ms
(2.88%)
1
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.customer_id AS customer_id_21 FROM sylius_shop_user t0 WHERE t0.id = ?
Parameters:
[
  21
]
0.19 ms
(2.72%)
1
SELECT t0.number AS number_1, t0.notes AS notes_2, t0.state AS state_3, t0.checkout_completed_at AS checkout_completed_at_4, t0.items_total AS items_total_5, t0.adjustments_total AS adjustments_total_6, t0.total AS total_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.currency_code AS currency_code_11, t0.locale_code AS locale_code_12, t0.checkout_state AS checkout_state_13, t0.payment_state AS payment_state_14, t0.shipping_state AS shipping_state_15, t0.created_by_guest AS created_by_guest_16, t0.token_value AS token_value_17, t0.customer_ip AS customer_ip_18, t0.old_site_id_order AS old_site_id_order_19, t0.order_divalto_invoice_number AS order_divalto_invoice_number_20, t0.order_pickup_so_colissimo AS order_pickup_so_colissimo_21, t0.order_pickup_shop AS order_pickup_shop_22, t0.order_pickup_name AS order_pickup_name_23, t0.order_generix_receipt_number AS order_generix_receipt_number_24, t0.order_generix_marketing_context_id AS order_generix_marketing_context_id_25, t0.order_panda_panier_id AS order_panda_panier_id_26, t0.gift_message AS gift_message_27, t0.gift_wrap_mode AS gift_wrap_mode_28, t0.origin AS origin_29, t0.can_loyalty AS can_loyalty_30, t0.has_loyalty AS has_loyalty_31, t0.total_loyalty AS total_loyalty_32, t0.libelle_loyalty AS libelle_loyalty_33, t0.code_promo AS code_promo_34, t0.code_promo_valid AS code_promo_valid_35, t0.apel AS apel_36, t0.selected_shipping_address_id AS selected_shipping_address_id_37, t0.selected_billing_address_id AS selected_billing_address_id_38, t0.channel_id AS channel_id_39, t0.promotion_coupon_id AS promotion_coupon_id_40, t0.customer_id AS customer_id_41, t0.shipping_address_id AS shipping_address_id_42, t0.billing_address_id AS billing_address_id_43 FROM sylius_order t0 WHERE t0.customer_id = ? AND t0.state = ? ORDER BY t0.id DESC
Parameters:
[
  23
  "cart"
]
0.19 ms
(2.71%)
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.18 ms
(2.61%)
1
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:
[
  "/ajax/update-cart/716"
  0
]
0.15 ms
(2.12%)
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.14 ms
(2.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.14 ms
(1.98%)
1
UPDATE sylius_order SET items_total = ?, total = ?, updated_at = ? WHERE id = ?
Parameters:
[
  8100
  8100
  "2024-12-18 09:38:47"
  411
]
0.14 ms
(1.95%)
1
SELECT t0.number AS number_1, t0.notes AS notes_2, t0.state AS state_3, t0.checkout_completed_at AS checkout_completed_at_4, t0.items_total AS items_total_5, t0.adjustments_total AS adjustments_total_6, t0.total AS total_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.currency_code AS currency_code_11, t0.locale_code AS locale_code_12, t0.checkout_state AS checkout_state_13, t0.payment_state AS payment_state_14, t0.shipping_state AS shipping_state_15, t0.created_by_guest AS created_by_guest_16, t0.token_value AS token_value_17, t0.customer_ip AS customer_ip_18, t0.old_site_id_order AS old_site_id_order_19, t0.order_divalto_invoice_number AS order_divalto_invoice_number_20, t0.order_pickup_so_colissimo AS order_pickup_so_colissimo_21, t0.order_pickup_shop AS order_pickup_shop_22, t0.order_pickup_name AS order_pickup_name_23, t0.order_generix_receipt_number AS order_generix_receipt_number_24, t0.order_generix_marketing_context_id AS order_generix_marketing_context_id_25, t0.order_panda_panier_id AS order_panda_panier_id_26, t0.gift_message AS gift_message_27, t0.gift_wrap_mode AS gift_wrap_mode_28, t0.origin AS origin_29, t0.can_loyalty AS can_loyalty_30, t0.has_loyalty AS has_loyalty_31, t0.total_loyalty AS total_loyalty_32, t0.libelle_loyalty AS libelle_loyalty_33, t0.code_promo AS code_promo_34, t0.code_promo_valid AS code_promo_valid_35, t0.apel AS apel_36, t0.selected_shipping_address_id AS selected_shipping_address_id_37, t0.selected_billing_address_id AS selected_billing_address_id_38, t0.channel_id AS channel_id_39, t0.promotion_coupon_id AS promotion_coupon_id_40, t0.customer_id AS customer_id_41, t0.shipping_address_id AS shipping_address_id_42, t0.billing_address_id AS billing_address_id_43 FROM sylius_order t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  411
]
0.13 ms
(1.85%)
1
SELECT s0_.quantity AS quantity_0, s0_.unit_price AS unit_price_1, s0_.original_unit_price AS original_unit_price_2, s0_.units_total AS units_total_3, s0_.adjustments_total AS adjustments_total_4, s0_.total AS total_5, s0_.is_immutable AS is_immutable_6, s0_.id AS id_7, s0_.product_name AS product_name_8, s0_.variant_name AS variant_name_9, s0_.version AS version_10, s0_.conditioning AS conditioning_11, s0_.conditioning_value AS conditioning_value_12, s0_.kdo_mail AS kdo_mail_13, s0_.kdo_lastname AS kdo_lastname_14, s0_.kdo_firstname AS kdo_firstname_15, s0_.kdo_message AS kdo_message_16, s0_.kdo_code AS kdo_code_17, s0_.kdo_passwd AS kdo_passwd_18, s0_.order_id AS order_id_19, s0_.variant_id AS variant_id_20 FROM sylius_order_item s0_ INNER JOIN sylius_order s1_ ON s0_.order_id = s1_.id WHERE s1_.state = ? AND s0_.id = ? AND s1_.id = ?
Parameters:
[
  "cart"
  "716"
  411
]
0.12 ms
(1.77%)
1
"COMMIT"
Parameters:
[]
0.11 ms
(1.52%)
1
SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.priority AS priority_4, t0.exclusive AS exclusive_5, t0.usage_limit AS usage_limit_6, t0.used AS used_7, t0.coupon_based AS coupon_based_8, t0.starts_at AS starts_at_9, t0.ends_at AS ends_at_10, t0.applies_to_discounted AS applies_to_discounted_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14 FROM sylius_promotion t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "FREE_DELIVERY"
]
0.10 ms
(1.41%)
1
SELECT t0.type AS type_1, t0.label AS label_2, t0.amount AS amount_3, t0.is_neutral AS is_neutral_4, t0.is_locked AS is_locked_5, t0.origin_code AS origin_code_6, t0.details AS details_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.order_id AS order_id_11, t0.order_item_id AS order_item_id_12, t0.order_item_unit_id AS order_item_unit_id_13, t0.shipment_id AS shipment_id_14 FROM sylius_adjustment t0 WHERE t0.order_item_unit_id = ?
Parameters:
[
  1341
]
0.09 ms
(1.34%)
1
SELECT t0.type AS type_1, t0.configuration AS configuration_2, t0.id AS id_3, t0.promotion_id AS promotion_id_4 FROM sylius_promotion_rule t0 WHERE t0.promotion_id = ?
Parameters:
[
  10
]
0.07 ms
(1.08%)
1
SELECT t0.adjustments_total AS adjustments_total_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.order_item_id AS order_item_id_5, t0.shipment_id AS shipment_id_6 FROM sylius_order_item_unit t0 WHERE t0.order_item_id = ?
Parameters:
[
  716
]
0.07 ms
(1.04%)
1
UPDATE sylius_order_item SET quantity = ?, units_total = ?, total = ?, conditioning_value = ?, version = version + 1 WHERE id = ? AND version = ?
Parameters:
[
  2
  7400
  7400
  2
  716
  5
]
0.06 ms
(0.84%)
1
SELECT version FROM sylius_order_item WHERE id = ?
Parameters:
[
  716
]
0.06 ms
(0.82%)
1
DELETE FROM sylius_order_item_unit WHERE id = ?
Parameters:
[
  1341
]
0.05 ms
(0.70%)
1
"START TRANSACTION"
Parameters:
[]

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\User\Model\User No errors.
Sylius\Component\Core\Model\AdminUser No errors.
Sylius\Component\Core\Model\ShopUser 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\User\Model\UserOAuth 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.
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.
Setono\SyliusRedirectPlugin\Model\Redirect No errors.
Sylius\Component\Customer\Model\CustomerGroup No errors.
App\Entity\SiteWishlistProductVariant No errors.
App\Entity\SiteNewsletterPreference No errors.
App\Entity\SiteShop No errors.
Sylius\Component\Addressing\Model\Address No errors.
Sylius\Component\Core\Model\Address No errors.
App\Entity\Addressing\Address No errors.
Sylius\Component\Promotion\Model\PromotionCoupon No errors.
Sylius\Component\Core\Model\PromotionCoupon No errors.
Sylius\Component\Payment\Model\Payment No errors.
Sylius\Component\Core\Model\Payment No errors.
Sylius\Component\Shipping\Model\Shipment No errors.
Sylius\Component\Core\Model\Shipment 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\Parameter\Parameter No errors.
Sylius\Component\Order\Model\OrderItemUnit No errors.
Sylius\Component\Core\Model\OrderItemUnit No errors.
Sylius\Component\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
App\Entity\Shipping\ShippingMethod No errors.
Sylius\Component\Shipping\Model\ShippingCategory No errors.
Sylius\Component\Taxation\Model\TaxCategory No errors.
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
App\Entity\Product\Product No errors.
Sylius\Component\Promotion\Model\PromotionRule No errors.
Sylius\Component\Promotion\Model\PromotionAction No errors.
App\Entity\Product\ProductVariantTaxon No errors.
App\Entity\Product\ProductVariantAttributeValue No errors.
Sylius\Component\Attribute\Model\Attribute No errors.
Sylius\Component\Product\Model\ProductAttribute No errors.
Sylius\Component\Product\Model\ProductVariantTranslation No errors.
App\Entity\Product\ProductVariantTranslation No errors.
Sylius\Component\Core\Model\ChannelPricing No errors.
Sylius\Component\Core\Model\ProductImage No errors.
Sylius\Component\Product\Model\ProductOptionValue No errors.
App\Entity\Product\ProductOptionValue 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\Attribute\Model\AttributeValue No errors.
Sylius\Component\Product\Model\ProductAttributeValue No errors.
Sylius\Component\Product\Model\ProductAssociation No errors.
Sylius\Component\Product\Model\ProductOption No errors.
Sylius\Component\Review\Model\Review No errors.
Sylius\Component\Core\Model\ProductReview No errors.
Sylius\Component\Currency\Model\ExchangeRate No errors.