Query Metrics
41
Database Queries
27
Different statements
7.55 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.23 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.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"
]
|
2 | 0.18 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.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:
[] |
3 | 0.11 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.10 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.28 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 | 0.61 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.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:
[] |
7 | 0.19 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.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:
[] |
8 | 0.33 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_.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:
[ "/order/thank-you" 0 ] |
9 | 0.23 ms |
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_.state <> ? AND s0_.token_value = ?
Parameters:
[ "cart" "ODhaN_8kar" ] |
10 | 0.19 ms |
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" ] |
11 | 0.14 ms |
SELECT t0.id_order AS id_order_1, t0.comment AS comment_2, t0.id AS id_3 FROM site_comment_order t0 WHERE t0.id_order = ? LIMIT 1
Parameters:
[
430
]
|
12 | 0.16 ms |
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_id = ?
Parameters:
[
430
]
|
13 | 0.16 ms |
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:
[
430
]
|
14 | 0.12 ms |
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_id = ?
Parameters:
[
709
]
|
15 | 0.08 ms |
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:
[
709
]
|
16 | 0.09 ms |
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:
[
1330
]
|
17 | 0.09 ms |
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_id = ?
Parameters:
[
710
]
|
18 | 0.08 ms |
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:
[
710
]
|
19 | 0.09 ms |
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:
[
1331
]
|
20 | 0.09 ms |
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_id = ?
Parameters:
[
430
]
|
21 | 0.04 ms |
"START TRANSACTION"
Parameters:
[] |
22 | 0.14 ms |
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[ "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:18:\"sylius.command_bus\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:25:\"App\\Message\\ValidateOrder\":2:{s:34:\"\0App\\Message\\ValidateOrder\0orderId\";i:430;s:33:\"\0App\\Message\\ValidateOrder\0update\";b:0;}}" "[]" "default" "2024-11-22 20:38:24" "2024-11-22 20:38:24" ] |
23 | 0.15 ms |
"COMMIT"
Parameters:
[] |
24 | 0.03 ms |
"START TRANSACTION"
Parameters:
[] |
25 | 0.19 ms |
INSERT INTO sylius_order (number, notes, state, checkout_completed_at, items_total, adjustments_total, total, created_at, updated_at, currency_code, locale_code, checkout_state, payment_state, shipping_state, created_by_guest, token_value, customer_ip, channel_id, promotion_coupon_id, customer_id, old_site_id_order, order_divalto_invoice_number, order_pickup_so_colissimo, order_pickup_shop, order_pickup_name, order_generix_receipt_number, order_generix_marketing_context_id, order_panda_panier_id, gift_message, gift_wrap_mode, origin, can_loyalty, has_loyalty, total_loyalty, libelle_loyalty, code_promo, code_promo_valid, apel, selected_shipping_address_id, selected_billing_address_id, shipping_address_id, billing_address_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => null 2 => null 3 => "cart" 4 => null 5 => 0 6 => 0 7 => 0 8 => "2024-11-22 20:38:24" 9 => "2024-11-22 20:38:24" 10 => "EUR" 11 => "fr_FR" 12 => "cart" 13 => "cart" 14 => "cart" 15 => 1 16 => null 17 => null 18 => 1 19 => null 20 => null 21 => null 22 => null 23 => null 24 => null 25 => null 26 => null 27 => null 28 => null 29 => null 30 => "none" 31 => "Internet" 32 => null 33 => null 34 => null 35 => null 36 => null 37 => null 38 => null 39 => null 40 => null 41 => null 42 => null ] |
26 | 0.09 ms |
"COMMIT"
Parameters:
[] |
27 | 0.12 ms |
SELECT t0.currency_code AS currency_code_1, t0.amount AS amount_2, t0.state AS state_3, t0.details AS details_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.method_id AS method_id_8, t0.order_id AS order_id_9 FROM sylius_payment t0 WHERE t0.order_id = ?
Parameters:
[
430
]
|
28 | 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_.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:
[ "/_fragment" 0 ] |
29 | 0.16 ms |
SELECT b0_.code AS code_0, b0_.enabled AS enabled_1, b0_.id AS id_2, b0_.typeblock AS typeblock_3 FROM bitbag_cms_block b0_ LEFT JOIN bitbag_cms_block_channels b2_ ON b0_.id = b2_.block_id LEFT JOIN sylius_channel s1_ ON s1_.id = b2_.channel_id WHERE b0_.code = ? AND b0_.enabled = 1 AND s1_.code = ?
Parameters:
[ "preheader" "ppmc" ] |
30 | 0.23 ms |
SELECT t0.name AS name_1, t0.content AS content_2, t0.link AS link_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM bitbag_cms_block_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 47 "fr_FR" ] |
31 | 0.17 ms |
SELECT b0_.code AS code_0, b0_.enabled AS enabled_1, b0_.id AS id_2, b0_.typeblock AS typeblock_3 FROM bitbag_cms_block b0_ LEFT JOIN bitbag_cms_block_channels b2_ ON b0_.id = b2_.block_id LEFT JOIN sylius_channel s1_ ON s1_.id = b2_.channel_id WHERE b0_.code = ? AND b0_.enabled = 1 AND s1_.code = ?
Parameters:
[ "preheader" "ppmc" ] |
32 | 0.25 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_.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:
[ "/_fragment" 0 ] |
33 | 0.24 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_.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:
[ "/_fragment" 0 ] |
34 | 0.29 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_.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:
[ "/_partial/cart/summary" 0 ] |
35 | 0.37 ms |
SELECT t0.type AS type_1, t0.title AS title_2, t0.attr_title AS attr_title_3, t0.language AS language_4, t0.configuration AS configuration_5, t0.enabled AS enabled_6, t0.saumon AS saumon_7, t0.bold AS bold_8, t0.lft AS lft_9, t0.rgt AS rgt_10, t0.lvl AS lvl_11, t0.id AS id_12, t0.tree_root AS tree_root_13, t0.parent_id AS parent_id_14 FROM site_menu_header t0 WHERE t0.lvl = ? AND t0.enabled = ? AND t0.language = ? ORDER BY t0.lft ASC
Parameters:
[ 1 1 "fr_FR" ] |
36 | 0.29 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_.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:
[ "/_fragment" 0 ] |
37 | 0.24 ms |
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, s2_.code AS code_31, s2_.tree_left AS tree_left_32, s2_.tree_right AS tree_right_33, s2_.tree_level AS tree_level_34, s2_.position AS position_35, s2_.enabled AS enabled_36, s2_.id AS id_37, s2_.created_at AS created_at_38, s2_.updated_at AS updated_at_39, s2_.category_type AS category_type_40, s2_.referencement AS referencement_41, s2_.referencementen AS referencementen_42, s2_.seo_links AS seo_links_43, s2_.single_article_category_title AS single_article_category_title_44, s2_.single_article_category_title_en AS single_article_category_title_en_45, s2_.ctas AS ctas_46, s2_.ctasen AS ctasen_47, s2_.filters AS filters_48, s2_.automatic AS automatic_49, s0_.tree_root AS tree_root_50, s0_.parent_id AS parent_id_51, s0_.article_id AS article_id_52, s0_.article_category_id AS article_category_id_53, s1_.translatable_id AS translatable_id_54, s2_.tree_root AS tree_root_55, s2_.parent_id AS parent_id_56, s2_.article_id AS article_id_57, s2_.article_category_id AS article_category_id_58 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 s3_.code = ? ORDER BY s0_.position ASC, s2_.position ASC
Parameters:
[
"Menu-deploye"
]
|
38 | 0.24 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_.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:
[ "/_fragment" 0 ] |
39 | 0.11 ms |
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"
]
|
40 | 0.08 ms |
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
]
|
41 | 0.27 ms |
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, s1_.price AS price_26, s1_.original_price AS original_price_27, s1_.minimum_price AS minimum_price_28, s1_.channel_code AS channel_code_29, s1_.id AS id_30, s0_.product_id AS product_id_31, s0_.tax_category_id AS tax_category_id_32, s0_.shipping_category_id AS shipping_category_id_33, s1_.product_variant_id AS product_variant_id_34 FROM sylius_product_variant s0_ INNER JOIN sylius_product_variant_translation s2_ ON s0_.id = s2_.translatable_id AND (s2_.locale = ?) INNER JOIN sylius_channel_pricing s1_ ON s0_.id = s1_.product_variant_id AND (s1_.channel_code = ?) INNER JOIN sylius_product s3_ ON s0_.product_id = s3_.id INNER JOIN sylius_product_taxon s4_ ON s3_.id = s4_.product_id INNER JOIN sylius_taxon s5_ ON s4_.taxon_id = s5_.id WHERE s0_.enabled = 1 AND s5_.code = ? ORDER BY RAND() ASC LIMIT 7
Parameters:
[ "fr_FR" "ppmc" "HAIR_ACCESSORY" ] |
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. |
Sylius\Component\Payment\Model\PaymentMethod | No errors. |
Sylius\Component\Core\Model\PaymentMethod | No errors. |
App\Entity\Payment\PaymentMethod | 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\ProductVariant | No errors. |
Sylius\Component\Core\Model\ProductVariant | No errors. |
App\Entity\Product\ProductVariant |
|
BitBag\SyliusMailTemplatePlugin\Entity\EmailTemplateTranslation | No errors. |
Sylius\Component\Promotion\Model\PromotionCoupon | No errors. |
Sylius\Component\Core\Model\PromotionCoupon | No errors. |
Sylius\Component\Customer\Model\Customer | No errors. |
Sylius\Component\Core\Model\Customer | No errors. |
App\Entity\Customer\Customer |
|
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. |
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. |
App\Entity\SiteCommentOrder | No errors. |
Sylius\Component\Order\Model\OrderItemUnit | No errors. |
Sylius\Component\Core\Model\OrderItemUnit | No errors. |
Sylius\Component\Customer\Model\CustomerGroup | No errors. |
App\Entity\SiteShop | No errors. |
Sylius\Component\Addressing\Model\ZoneMember | No errors. |
Payum\Core\Model\GatewayConfig | No errors. |
Sylius\Bundle\PayumBundle\Model\GatewayConfig | No errors. |
App\Entity\Payment\PaymentMethodImage | No errors. |
Sylius\Component\Payment\Model\PaymentMethodTranslation | No errors. |
App\Entity\SitePageCMSImage | No errors. |
App\Entity\SitePageCMSTranslation | No errors. |
App\Entity\SiteArticleCategoryImage | No errors. |
App\Entity\SiteArticleCategoryTranslation | No errors. |
App\Entity\SiteSelectionCategoryImage | No errors. |
App\Entity\SiteSelectionCategoryTranslation | No errors. |
App\Entity\SiteCollectionImage | No errors. |
App\Entity\SiteCollectionTranslation | No errors. |
Sylius\Component\Product\Model\ProductOptionValue | No errors. |
App\Entity\Product\ProductOptionValue | No errors. |
App\Entity\Bitbag\BlockImage | No errors. |
BitBag\SyliusCmsPlugin\Entity\Section | No errors. |
Sylius\Component\Product\Model\Product | No errors. |
Sylius\Component\Core\Model\Product | No errors. |
App\Entity\Product\Product | No errors. |
BitBag\SyliusCmsPlugin\Entity\BlockTranslation | No errors. |
BitBag\SyliusCmsPlugin\Entity\MediaTranslation | No errors. |
BitBag\SyliusCmsPlugin\Entity\PageTranslation | No errors. |
Sylius\Component\Promotion\Model\PromotionRule | No errors. |
Sylius\Component\Promotion\Model\PromotionAction | No errors. |
App\Entity\SiteArticleImage | No errors. |
App\Entity\SiteArticleTranslation | No errors. |
App\Entity\SiteMenuFooterItem | No errors. |
App\Entity\SiteSelectionImage | No errors. |
App\Entity\SiteSelectionTranslation | No errors. |
App\Entity\SiteBlocInsuranceTranslation | No errors. |
App\Entity\SiteSearchSuggestTextTranslation | 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. |
Sylius\Component\Core\Model\ProductImage | No errors. |
App\Entity\SiteWishlistProductVariant | No errors. |
App\Entity\SiteNewsletterPreference | No errors. |
Sylius\Component\User\Model\User | No errors. |
Sylius\Component\Core\Model\ShopUser | No errors. |
Sylius\Component\Shipping\Model\ShippingMethod | No errors. |
Sylius\Component\Core\Model\ShippingMethod | No errors. |
App\Entity\Shipping\ShippingMethod | No errors. |
App\Entity\SiteShopImage | No errors. |
App\Entity\SiteShopTranslation | No errors. |
Sylius\Component\Product\Model\ProductOption | No errors. |
Sylius\Component\Product\Model\ProductOptionValueTranslation | No errors. |
BitBag\SyliusCmsPlugin\Entity\SectionTranslation | 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\Attribute\Model\Attribute | No errors. |
Sylius\Component\Product\Model\ProductAttribute | 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\Taxation\Model\TaxRate | No errors. |
Sylius\Component\Core\Model\TaxRate | No errors. |
Sylius\Component\Promotion\Model\CatalogPromotion | No errors. |
Sylius\Component\Core\Model\CatalogPromotion | No errors. |
Sylius\Component\User\Model\UserOAuth | No errors. |
App\Entity\Shipping\ShippingMethodImage | No errors. |
Sylius\Component\Shipping\Model\ShippingMethodRule | No errors. |
Sylius\Component\Shipping\Model\ShippingMethodTranslation | No errors. |
Sylius\Component\Product\Model\ProductOptionTranslation | No errors. |
Sylius\Component\Attribute\Model\AttributeTranslation | No errors. |
Sylius\Component\Product\Model\ProductAttributeTranslation | No errors. |
Sylius\Component\Product\Model\ProductAssociationType | No errors. |
Sylius\Component\Promotion\Model\CatalogPromotionTranslation | No errors. |
Sylius\Component\Promotion\Model\CatalogPromotionScope | No errors. |
Sylius\Component\Core\Model\CatalogPromotionScope | No errors. |
Sylius\Component\Promotion\Model\CatalogPromotionAction | No errors. |
Sylius\Component\Product\Model\ProductAssociationTypeTranslation | No errors. |
Sylius\Component\Currency\Model\ExchangeRate | No errors. |