GET https://forges-preprod.kwantic.dev/de_DE/products/list?page=2

Query Metrics

81 Database Queries
20 Different statements
127.60 ms Query time
0 Invalid entities
240 Managed entities

Queries

Group similar statements

# Time Info
1 2.35 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_address_in_checkout_required AS shipping_address_in_checkout_required_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, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 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 = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  "forges-preprod.kwantic.dev"
  1
]
2 1.10 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_address_in_checkout_required AS shipping_address_in_checkout_required_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, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 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.code = ? LIMIT 1
Parameters:
[
  "WEB-EU"
]
3 1.15 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
]
4 4.38 ms
SELECT s0_.id AS id_0 FROM sylius_product s0_ INNER JOIN sylius_product_channels s2_ ON s0_.id = s2_.product_id INNER JOIN sylius_channel s1_ ON s1_.id = s2_.channel_id WHERE s0_.enabled = 1 AND s1_.code = ? GROUP BY s0_.id ORDER BY s0_.created_at DESC
Parameters:
[
  "WEB-EU"
]
5 19.18 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_.is_new AS is_new_7, s0_.is_iconic AS is_iconic_8, s0_.is_featured AS is_featured_9, s0_.is_engravable AS is_engravable_10, s0_.code_douane AS code_douane_11, s1_.name AS name_12, s1_.slug AS slug_13, s1_.description AS description_14, s1_.meta_keywords AS meta_keywords_15, s1_.meta_description AS meta_description_16, s1_.id AS id_17, s1_.short_description AS short_description_18, s1_.metaTitle AS metaTitle_19, s1_.metaRobots AS metaRobots_20, s1_.ogTitle AS ogTitle_21, s1_.ogDescription AS ogDescription_22, s1_.ogImage AS ogImage_23, s1_.twitterTitle AS twitterTitle_24, s1_.twitterDescription AS twitterDescription_25, s1_.locale AS locale_26, s2_.type AS type_27, s2_.path AS path_28, s2_.id AS id_29, s2_.position AS position_30, s3_.position AS position_31, s3_.id AS id_32, s4_.code AS code_33, s4_.created_at AS created_at_34, s4_.updated_at AS updated_at_35, s4_.position AS position_36, s4_.enabled AS enabled_37, s4_.id AS id_38, s4_.version AS version_39, s4_.on_hold AS on_hold_40, s4_.on_hand AS on_hand_41, s4_.tracked AS tracked_42, s4_.width AS width_43, s4_.height AS height_44, s4_.depth AS depth_45, s4_.weight AS weight_46, s4_.shipping_required AS shipping_required_47, s4_.recurring AS recurring_48, s4_.recurring_times AS recurring_times_49, s4_.recurring_interval AS recurring_interval_50, s5_.price AS price_51, s5_.original_price AS original_price_52, s5_.minimum_price AS minimum_price_53, s5_.lowest_price_before_discount AS lowest_price_before_discount_54, s5_.channel_code AS channel_code_55, s5_.id AS id_56, s6_.code AS code_57, s6_.id AS id_58, s6_.color AS color_59, s6_.iconName AS iconName_60, s6_.updatedAt AS updatedAt_61, s0_.main_taxon_id AS main_taxon_id_62, s0_.product_type_id AS product_type_id_63, s1_.translatable_id AS translatable_id_64, s2_.owner_id AS owner_id_65, s3_.product_id AS product_id_66, s3_.taxon_id AS taxon_id_67, s4_.product_id AS product_id_68, s4_.tax_category_id AS tax_category_id_69, s4_.shipping_category_id AS shipping_category_id_70, s5_.product_variant_id AS product_variant_id_71, s6_.option_id AS option_id_72 FROM sylius_product s0_ LEFT JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_product_image s2_ ON s0_.id = s2_.owner_id LEFT JOIN sylius_product_taxon s3_ ON s0_.id = s3_.product_id LEFT JOIN sylius_product_variant s4_ ON s0_.id = s4_.product_id LEFT JOIN sylius_channel_pricing s5_ ON s4_.id = s5_.product_variant_id LEFT JOIN sylius_product_variant_option_value s7_ ON s4_.id = s7_.variant_id LEFT JOIN sylius_product_option_value s6_ ON s6_.id = s7_.option_value_id WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC, s3_.id ASC, s4_.position ASC, s4_.id ASC, s5_.id ASC, s6_.id ASC
Parameters:
[
  1332
  1331
  1330
  1327
  1324
  1322
  1321
  1318
  1315
]
6 1.53 ms
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.product_id AS product_id_10, t0.attribute_id AS attribute_id_11 FROM sylius_product_attribute_value t0 WHERE t0.product_id = ? ORDER BY t0.id ASC
Parameters:
[
  1332
]
7 0.98 ms
SELECT t0.code AS code_1, t0.type AS type_2, t0.storage_type AS storage_type_3, t0.configuration AS configuration_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.translatable AS translatable_8, t0.id AS id_9, t0.filterable AS filterable_10 FROM sylius_product_attribute t0 WHERE t0.id = ?
Parameters:
[
  21
]
8 0.77 ms
SELECT t0.code AS code_1, t0.type AS type_2, t0.storage_type AS storage_type_3, t0.configuration AS configuration_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.translatable AS translatable_8, t0.id AS id_9, t0.filterable AS filterable_10 FROM sylius_product_attribute t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.55 ms
SELECT t0.code AS code_1, t0.type AS type_2, t0.storage_type AS storage_type_3, t0.configuration AS configuration_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.translatable AS translatable_8, t0.id AS id_9, t0.filterable AS filterable_10 FROM sylius_product_attribute t0 WHERE t0.id = ?
Parameters:
[
  19
]
10 0.67 ms
SELECT t0.code AS code_1, t0.type AS type_2, t0.storage_type AS storage_type_3, t0.configuration AS configuration_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.translatable AS translatable_8, t0.id AS id_9, t0.filterable AS filterable_10 FROM sylius_product_attribute t0 WHERE t0.id = ?
Parameters:
[
  17
]
11 1.87 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_address_in_checkout_required AS shipping_address_in_checkout_required_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, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 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 INNER JOIN sylius_product_channels ON t0.id = sylius_product_channels.channel_id WHERE sylius_product_channels.product_id = ? ORDER BY t0.id ASC
Parameters:
[
  1332
]
12 0.69 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.id = ?
Parameters:
[
  38
]
13 0.96 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  38
]
14 1.03 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.owner_id AS owner_id_5 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 = ? ORDER BY t0.id ASC
Parameters:
[
  1515
]
15 0.83 ms
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.product_id AS product_id_10, t0.attribute_id AS attribute_id_11 FROM sylius_product_attribute_value t0 WHERE t0.product_id = ? ORDER BY t0.id ASC
Parameters:
[
  1331
]
16 1.59 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_address_in_checkout_required AS shipping_address_in_checkout_required_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, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 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 INNER JOIN sylius_product_channels ON t0.id = sylius_product_channels.channel_id WHERE sylius_product_channels.product_id = ? ORDER BY t0.id ASC
Parameters:
[
  1331
]
17 0.82 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.owner_id AS owner_id_5 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 = ? ORDER BY t0.id ASC
Parameters:
[
  1514
]
18 0.78 ms
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.product_id AS product_id_10, t0.attribute_id AS attribute_id_11 FROM sylius_product_attribute_value t0 WHERE t0.product_id = ? ORDER BY t0.id ASC
Parameters:
[
  1330
]
19 1.36 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_address_in_checkout_required AS shipping_address_in_checkout_required_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, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 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 INNER JOIN sylius_product_channels ON t0.id = sylius_product_channels.channel_id WHERE sylius_product_channels.product_id = ? ORDER BY t0.id ASC
Parameters:
[
  1330
]
20 0.75 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.owner_id AS owner_id_5 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 = ? ORDER BY t0.id ASC
Parameters:
[
  1513
]
21 0.86 ms
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.product_id AS product_id_10, t0.attribute_id AS attribute_id_11 FROM sylius_product_attribute_value t0 WHERE t0.product_id = ? ORDER BY t0.id ASC
Parameters:
[
  1321
]
22 1.43 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_address_in_checkout_required AS shipping_address_in_checkout_required_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, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 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 INNER JOIN sylius_product_channels ON t0.id = sylius_product_channels.channel_id WHERE sylius_product_channels.product_id = ? ORDER BY t0.id ASC
Parameters:
[
  1321
]
23 0.73 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.owner_id AS owner_id_5 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 = ? ORDER BY t0.id ASC
Parameters:
[
  1504
]
24 0.74 ms
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.product_id AS product_id_10, t0.attribute_id AS attribute_id_11 FROM sylius_product_attribute_value t0 WHERE t0.product_id = ? ORDER BY t0.id ASC
Parameters:
[
  1315
]
25 0.58 ms
SELECT t0.code AS code_1, t0.type AS type_2, t0.storage_type AS storage_type_3, t0.configuration AS configuration_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.translatable AS translatable_8, t0.id AS id_9, t0.filterable AS filterable_10 FROM sylius_product_attribute t0 WHERE t0.id = ?
Parameters:
[
  24
]
26 1.34 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_address_in_checkout_required AS shipping_address_in_checkout_required_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, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 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 INNER JOIN sylius_product_channels ON t0.id = sylius_product_channels.channel_id WHERE sylius_product_channels.product_id = ? ORDER BY t0.id ASC
Parameters:
[
  1315
]
27 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.id = ?
Parameters:
[
  9
]
28 0.70 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]
29 0.64 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.id = ?
Parameters:
[
  8
]
30 0.76 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
31 0.76 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.owner_id AS owner_id_5 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 = ? ORDER BY t0.id ASC
Parameters:
[
  1498
]
32 18.47 ms
SELECT s0_.code AS code_0, count(DISTINCT s1_.product_id) AS sclr_1 FROM sylius_product_taxon s1_ INNER JOIN sylius_taxon s0_ ON s1_.taxon_id = s0_.id WHERE s1_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY s0_.code
Parameters:
[
  1346
  1345
  1340
  1338
  1337
  1336
  1335
  1334
  1333
  1332
  1331
  1330
  1327
  1324
  1322
  1321
  1318
  1315
  1314
  1312
  1311
  1310
  1309
  1308
  1307
  1306
  1305
  1304
  1301
  1300
  1294
  1293
  1290
  1289
  1288
  1287
  1286
  1285
  1284
  1279
  1277
  1273
  1272
  1271
  1270
  1269
  1268
  1267
  1266
  1265
  1264
  1263
  1261
  1260
  1258
  1257
  1256
  1255
  1254
  1252
  1251
  1246
  1245
  1244
  1243
  1242
  1241
  1232
  1225
  1224
  1223
  1222
  1212
  1213
  1210
  1209
  1208
  1207
  1206
  1204
  1205
  1203
  1202
  1201
  1200
  1199
  1198
  1197
  1196
  1195
  1194
  1193
  1192
  1191
  1190
  1189
  1188
  1187
  1186
  1185
  1184
  1182
  1183
  1181
  1180
  1179
  1178
  1177
  1176
  1175
  1174
  1173
  1172
  1171
  1170
  1169
  1167
  1166
  1165
  1164
  1163
  1162
  1160
  1159
  1158
  1157
  1156
  1155
  1154
  1152
  1153
  1151
  1150
  1149
  1148
  1146
  1147
  1145
  1144
  1143
  1142
  1141
  1140
  1139
  1138
  1136
  1137
  1135
  1134
  1133
  1132
  1131
  1129
  1128
  1127
  1126
  1125
  1124
  1123
  1122
  1121
  1120
  1119
  1118
  1117
  1115
  1116
  1114
  1113
  1112
  1111
  1110
  1109
  1108
  1107
  1106
  1105
  1104
  1103
  1096
  1095
  1093
  1086
  1084
  1077
  1076
  1075
  1074
  1073
  1072
  1071
  1070
  1069
  1068
  1067
  1066
  1065
  1064
  1063
  1062
  1061
  1060
  1059
  1058
  1057
  1056
  1055
  1054
  1053
  1052
  1051
  1050
  1049
  1048
  1047
  1046
  1045
  1044
  1043
  1042
  1041
  1040
  1039
  1038
  1036
  1035
  1032
  1033
  1031
  1030
  1029
  1020
  1019
  1018
  1016
  1015
  1014
  1013
  1012
  1011
  1010
  1009
  1008
  1006
  1007
  1005
  1004
  1003
  1002
  1001
  1000
  999
  997
  998
  996
  995
  994
  993
  992
  991
  990
  989
  988
  987
  986
  981
  980
  979
  978
  977
  976
  975
  974
  973
  972
  971
  969
  970
  967
  968
  962
  963
  961
  960
  959
  958
  956
  957
  953
  954
  955
  951
  952
  949
  950
  947
  948
  944
  945
  946
  942
  943
  941
  940
  939
  938
  937
  936
  935
  934
  933
  932
  931
  930
  929
  928
  927
  926
  925
  924
  923
  922
  921
  920
  919
  918
  914
  912
  913
  910
  911
  908
  909
  906
  907
  905
  903
  894
  893
  892
  891
  890
  889
  886
  885
  884
  883
  881
  882
  880
  879
  878
  877
  876
  875
  874
  870
  855
  848
  847
  846
  845
  844
  843
  842
  841
  840
  839
  838
  837
  835
  834
  833
  832
  831
  830
  829
  828
  827
  826
  825
  824
  823
  822
  821
  820
  819
  818
  817
  816
  815
  814
  804
  803
  802
  801
  800
  799
  798
  797
  795
  792
  791
  790
  789
  788
  784
  776
  773
  771
  763
  762
  761
  760
  759
  758
  757
  756
  752
  751
  750
  749
  748
  746
  747
  745
  744
  743
  742
  741
  740
  739
  738
  737
  736
  735
  734
  733
  732
  730
  731
  729
  728
  726
  727
  724
  725
  722
  723
  721
  720
  719
  718
  717
  716
  715
  714
  713
  712
  711
  710
  709
  708
  707
  706
  705
  704
  703
  702
  701
  700
  699
  698
  697
  696
  692
  693
  691
  690
  689
  688
  681
  682
  680
  679
  678
  677
  676
  675
  674
  673
  672
  671
  670
  669
  666
  665
  664
  663
  662
  661
  660
  659
  658
  657
  656
  655
  653
  654
  652
  651
  650
  649
  648
  647
  646
  645
  644
  643
  642
  641
  640
  639
  638
  637
  635
  636
  634
  632
  633
  631
  630
  629
  628
  627
  626
  625
  624
  623
  622
  621
  613
  609
  608
  601
  599
]
33 4.15 ms
SELECT s0_.code AS code_0, s1_.code AS code_1, count(DISTINCT s2_.product_id) AS sclr_2 FROM sylius_product_variant s2_ INNER JOIN sylius_product_variant_option_value s3_ ON s2_.id = s3_.variant_id INNER JOIN sylius_product_option_value s1_ ON s1_.id = s3_.option_value_id INNER JOIN sylius_product_option s0_ ON s1_.option_id = s0_.id WHERE s0_.code IN (?, ?, ?) AND s2_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s2_.enabled = 1 GROUP BY s0_.code, s1_.code
Parameters:
[
  "taille"
  "matiere"
  "Nombre"
  1346
  1345
  1340
  1338
  1337
  1336
  1335
  1334
  1333
  1332
  1331
  1330
  1327
  1324
  1322
  1321
  1318
  1315
  1314
  1312
  1311
  1310
  1309
  1308
  1307
  1306
  1305
  1304
  1301
  1300
  1294
  1293
  1290
  1289
  1288
  1287
  1286
  1285
  1284
  1279
  1277
  1273
  1272
  1271
  1270
  1269
  1268
  1267
  1266
  1265
  1264
  1263
  1261
  1260
  1258
  1257
  1256
  1255
  1254
  1252
  1251
  1246
  1245
  1244
  1243
  1242
  1241
  1232
  1225
  1224
  1223
  1222
  1212
  1213
  1210
  1209
  1208
  1207
  1206
  1204
  1205
  1203
  1202
  1201
  1200
  1199
  1198
  1197
  1196
  1195
  1194
  1193
  1192
  1191
  1190
  1189
  1188
  1187
  1186
  1185
  1184
  1182
  1183
  1181
  1180
  1179
  1178
  1177
  1176
  1175
  1174
  1173
  1172
  1171
  1170
  1169
  1167
  1166
  1165
  1164
  1163
  1162
  1160
  1159
  1158
  1157
  1156
  1155
  1154
  1152
  1153
  1151
  1150
  1149
  1148
  1146
  1147
  1145
  1144
  1143
  1142
  1141
  1140
  1139
  1138
  1136
  1137
  1135
  1134
  1133
  1132
  1131
  1129
  1128
  1127
  1126
  1125
  1124
  1123
  1122
  1121
  1120
  1119
  1118
  1117
  1115
  1116
  1114
  1113
  1112
  1111
  1110
  1109
  1108
  1107
  1106
  1105
  1104
  1103
  1096
  1095
  1093
  1086
  1084
  1077
  1076
  1075
  1074
  1073
  1072
  1071
  1070
  1069
  1068
  1067
  1066
  1065
  1064
  1063
  1062
  1061
  1060
  1059
  1058
  1057
  1056
  1055
  1054
  1053
  1052
  1051
  1050
  1049
  1048
  1047
  1046
  1045
  1044
  1043
  1042
  1041
  1040
  1039
  1038
  1036
  1035
  1032
  1033
  1031
  1030
  1029
  1020
  1019
  1018
  1016
  1015
  1014
  1013
  1012
  1011
  1010
  1009
  1008
  1006
  1007
  1005
  1004
  1003
  1002
  1001
  1000
  999
  997
  998
  996
  995
  994
  993
  992
  991
  990
  989
  988
  987
  986
  981
  980
  979
  978
  977
  976
  975
  974
  973
  972
  971
  969
  970
  967
  968
  962
  963
  961
  960
  959
  958
  956
  957
  953
  954
  955
  951
  952
  949
  950
  947
  948
  944
  945
  946
  942
  943
  941
  940
  939
  938
  937
  936
  935
  934
  933
  932
  931
  930
  929
  928
  927
  926
  925
  924
  923
  922
  921
  920
  919
  918
  914
  912
  913
  910
  911
  908
  909
  906
  907
  905
  903
  894
  893
  892
  891
  890
  889
  886
  885
  884
  883
  881
  882
  880
  879
  878
  877
  876
  875
  874
  870
  855
  848
  847
  846
  845
  844
  843
  842
  841
  840
  839
  838
  837
  835
  834
  833
  832
  831
  830
  829
  828
  827
  826
  825
  824
  823
  822
  821
  820
  819
  818
  817
  816
  815
  814
  804
  803
  802
  801
  800
  799
  798
  797
  795
  792
  791
  790
  789
  788
  784
  776
  773
  771
  763
  762
  761
  760
  759
  758
  757
  756
  752
  751
  750
  749
  748
  746
  747
  745
  744
  743
  742
  741
  740
  739
  738
  737
  736
  735
  734
  733
  732
  730
  731
  729
  728
  726
  727
  724
  725
  722
  723
  721
  720
  719
  718
  717
  716
  715
  714
  713
  712
  711
  710
  709
  708
  707
  706
  705
  704
  703
  702
  701
  700
  699
  698
  697
  696
  692
  693
  691
  690
  689
  688
  681
  682
  680
  679
  678
  677
  676
  675
  674
  673
  672
  671
  670
  669
  666
  665
  664
  663
  662
  661
  660
  659
  658
  657
  656
  655
  653
  654
  652
  651
  650
  649
  648
  647
  646
  645
  644
  643
  642
  641
  640
  639
  638
  637
  635
  636
  634
  632
  633
  631
  630
  629
  628
  627
  626
  625
  624
  623
  622
  621
  613
  609
  608
  601
  599
]
34 1.22 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.color AS color_3, t0.iconName AS iconName_4, t0.updatedAt AS updatedAt_5, t0.option_id AS option_id_6 FROM sylius_product_option_value t0 WHERE t0.code IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  "acier"
  "cuivre"
  "2"
  "6"
  "taille-11-cm"
  "taille-12-cm"
]
35 1.11 ms
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_option_value_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  167
  "de_DE"
]
36 0.72 ms
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_option_value_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  166
  "de_DE"
]
37 0.57 ms
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_option_value_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  160
  "de_DE"
]
38 0.91 ms
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_option_value_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  160
  "fr_FR"
]
39 0.78 ms
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_option_value_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  161
  "de_DE"
]
40 0.50 ms
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_option_value_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  161
  "fr_FR"
]
41 0.55 ms
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_option_value_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  12
  "de_DE"
]
42 0.62 ms
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_option_value_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  7
  "de_DE"
]
43 1.07 ms
SELECT t0.code AS code_1, t0.type AS type_2, t0.storage_type AS storage_type_3, t0.configuration AS configuration_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.translatable AS translatable_8, t0.id AS id_9, t0.filterable AS filterable_10 FROM sylius_product_attribute t0 WHERE t0.code IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "finition"
  "taille"
  "motif"
  "forme_manche"
  "acier_lame"
  "materiau_lame"
  "materiau_manche"
  "materiau_mitres"
  "type"
  "gamme"
  "designer"
  "coffret"
  "composantes"
  "gravure"
  "resistance_eau"
  "brand"
  "nombre-de-mitres"
  "ressort"
  "lame"
  "nombre-de-pieces"
  "usage"
  "design"
  "matieres-des-mitres"
  "REF"
  "Use"
  "Coffrets"
]
44 20.24 ms
SELECT s0_.attribute_id AS sclr_0, s0_.text_value AS text_value_1, count(DISTINCT s0_.product_id) AS sclr_2 FROM sylius_product_attribute_value s0_ WHERE s0_.attribute_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY s0_.attribute_id, s0_.text_value
Parameters:
[
  2
  3
  4
  5
  6
  7
  8
  9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  1346
  1345
  1340
  1338
  1337
  1336
  1335
  1334
  1333
  1332
  1331
  1330
  1327
  1324
  1322
  1321
  1318
  1315
  1314
  1312
  1311
  1310
  1309
  1308
  1307
  1306
  1305
  1304
  1301
  1300
  1294
  1293
  1290
  1289
  1288
  1287
  1286
  1285
  1284
  1279
  1277
  1273
  1272
  1271
  1270
  1269
  1268
  1267
  1266
  1265
  1264
  1263
  1261
  1260
  1258
  1257
  1256
  1255
  1254
  1252
  1251
  1246
  1245
  1244
  1243
  1242
  1241
  1232
  1225
  1224
  1223
  1222
  1212
  1213
  1210
  1209
  1208
  1207
  1206
  1204
  1205
  1203
  1202
  1201
  1200
  1199
  1198
  1197
  1196
  1195
  1194
  1193
  1192
  1191
  1190
  1189
  1188
  1187
  1186
  1185
  1184
  1182
  1183
  1181
  1180
  1179
  1178
  1177
  1176
  1175
  1174
  1173
  1172
  1171
  1170
  1169
  1167
  1166
  1165
  1164
  1163
  1162
  1160
  1159
  1158
  1157
  1156
  1155
  1154
  1152
  1153
  1151
  1150
  1149
  1148
  1146
  1147
  1145
  1144
  1143
  1142
  1141
  1140
  1139
  1138
  1136
  1137
  1135
  1134
  1133
  1132
  1131
  1129
  1128
  1127
  1126
  1125
  1124
  1123
  1122
  1121
  1120
  1119
  1118
  1117
  1115
  1116
  1114
  1113
  1112
  1111
  1110
  1109
  1108
  1107
  1106
  1105
  1104
  1103
  1096
  1095
  1093
  1086
  1084
  1077
  1076
  1075
  1074
  1073
  1072
  1071
  1070
  1069
  1068
  1067
  1066
  1065
  1064
  1063
  1062
  1061
  1060
  1059
  1058
  1057
  1056
  1055
  1054
  1053
  1052
  1051
  1050
  1049
  1048
  1047
  1046
  1045
  1044
  1043
  1042
  1041
  1040
  1039
  1038
  1036
  1035
  1032
  1033
  1031
  1030
  1029
  1020
  1019
  1018
  1016
  1015
  1014
  1013
  1012
  1011
  1010
  1009
  1008
  1006
  1007
  1005
  1004
  1003
  1002
  1001
  1000
  999
  997
  998
  996
  995
  994
  993
  992
  991
  990
  989
  988
  987
  986
  981
  980
  979
  978
  977
  976
  975
  974
  973
  972
  971
  969
  970
  967
  968
  962
  963
  961
  960
  959
  958
  956
  957
  953
  954
  955
  951
  952
  949
  950
  947
  948
  944
  945
  946
  942
  943
  941
  940
  939
  938
  937
  936
  935
  934
  933
  932
  931
  930
  929
  928
  927
  926
  925
  924
  923
  922
  921
  920
  919
  918
  914
  912
  913
  910
  911
  908
  909
  906
  907
  905
  903
  894
  893
  892
  891
  890
  889
  886
  885
  884
  883
  881
  882
  880
  879
  878
  877
  876
  875
  874
  870
  855
  848
  847
  846
  845
  844
  843
  842
  841
  840
  839
  838
  837
  835
  834
  833
  832
  831
  830
  829
  828
  827
  826
  825
  824
  823
  822
  821
  820
  819
  818
  817
  816
  815
  814
  804
  803
  802
  801
  800
  799
  798
  797
  795
  792
  791
  790
  789
  788
  784
  776
  773
  771
  763
  762
  761
  760
  759
  758
  757
  756
  752
  751
  750
  749
  748
  746
  747
  745
  744
  743
  742
  741
  740
  739
  738
  737
  736
  735
  734
  733
  732
  730
  731
  729
  728
  726
  727
  724
  725
  722
  723
  721
  720
  719
  718
  717
  716
  715
  714
  713
  712
  711
  710
  709
  708
  707
  706
  705
  704
  703
  702
  701
  700
  699
  698
  697
  696
  692
  693
  691
  690
  689
  688
  681
  682
  680
  679
  678
  677
  676
  675
  674
  673
  672
  671
  670
  669
  666
  665
  664
  663
  662
  661
  660
  659
  658
  657
  656
  655
  653
  654
  652
  651
  650
  649
  648
  647
  646
  645
  644
  643
  642
  641
  640
  639
  638
  637
  635
  636
  634
  632
  633
  631
  630
  629
  628
  627
  626
  625
  624
  623
  622
  621
  613
  609
  608
  601
  599
]
45 1.14 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "tradition"
]
46 0.83 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  8
]
47 0.85 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  10
  "de_DE"
]
48 0.71 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  11
  "de_DE"
]
49 0.64 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  12
  "de_DE"
]
50 0.68 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  13
  "de_DE"
]
51 0.64 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  65
  "de_DE"
]
52 0.59 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  65
  "fr_FR"
]
53 0.71 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "edition"
]
54 0.68 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  14
  "de_DE"
]
55 0.56 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "collection"
]
56 0.59 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  21
  "de_DE"
]
57 0.79 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  21
]
58 0.72 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  22
  "de_DE"
]
59 0.67 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  23
  "de_DE"
]
60 0.72 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  24
  "de_DE"
]
61 0.61 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  25
  "de_DE"
]
62 0.56 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "signature"
]
63 0.69 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  28
  "de_DE"
]
64 0.82 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  28
]
65 0.70 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  29
  "de_DE"
]
66 0.72 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  30
  "de_DE"
]
67 0.72 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  31
  "de_DE"
]
68 0.63 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "coutellerie-d-art"
]
69 0.63 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  38
]
70 0.52 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "accessoires"
]
71 0.66 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  56
  "de_DE"
]
72 0.56 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  56
  "fr_FR"
]
73 0.68 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  56
]
74 0.80 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "tradition"
]
75 0.78 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  65
  "de_DE"
]
76 0.68 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "edition"
]
77 0.41 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "collection"
]
78 0.35 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "signature"
]
79 0.40 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "coutellerie-d-art"
]
80 0.39 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.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "accessoires"
]
81 0.38 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  56
  "de_DE"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Product\ProductImage 37
App\Entity\Taxonomy\Taxon 32
App\Entity\Product\ProductTranslation 27
App\Entity\Product\ProductAttribute 26
App\Entity\Taxonomy\TaxonTranslation 23
App\Entity\Product\ProductAttributeValue 20
App\Entity\Channel\ChannelPricing 18
App\Entity\Product\ProductTaxon 11
App\Entity\Product\Product 9
App\Entity\Product\ProductVariant 9
App\Entity\Product\ProductOptionValue 6
App\Entity\Product\ProductOptionValueTranslation 6
App\Entity\Locale\Locale 3
App\Entity\Product\ProductOption 3
App\Entity\Channel\Channel 2
App\Entity\Addressing\Zone 2
App\Entity\Channel\ShopBillingData 2
App\Entity\Channel\ChannelPriceHistoryConfig 2
App\Entity\Currency\Currency 1
App\Entity\Taxation\TaxCategory 1

Entities Mapping

Class Mapping errors
Sylius\Component\Payment\Model\PaymentMethod No errors.
Sylius\Component\Core\Model\PaymentMethod No errors.
App\Entity\Payment\PaymentMethod No errors.
Sylius\Component\Order\Model\Order No errors.
Sylius\Component\Core\Model\Order No errors.
App\Entity\Order\Order No errors.
Sylius\Component\Shipping\Model\Shipment No errors.
Sylius\Component\Core\Model\Shipment No errors.
App\Entity\Shipping\Shipment No errors.
Sylius\Component\Channel\Model\Channel No errors.
Sylius\Component\Core\Model\Channel No errors.
App\Entity\Channel\Channel No errors.
Sylius\Component\Locale\Model\Locale No errors.
App\Entity\Locale\Locale No errors.
Sylius\Component\Currency\Model\Currency No errors.
App\Entity\Currency\Currency No errors.
Sylius\Component\Addressing\Model\Zone No errors.
App\Entity\Addressing\Zone No errors.
Sylius\Component\Taxonomy\Model\Taxon No errors.
Sylius\Component\Core\Model\Taxon No errors.
App\Entity\Taxonomy\Taxon No errors.
Sylius\Component\Core\Model\ShopBillingData No errors.
App\Entity\Channel\ShopBillingData No errors.
Sylius\Component\Core\Model\ChannelPriceHistoryConfig No errors.
App\Entity\Channel\ChannelPriceHistoryConfig No errors.
Sylius\Component\Addressing\Model\Country No errors.
App\Entity\Addressing\Country 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\ProductOption No errors.
App\Entity\Product\ProductOption No errors.
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
App\Entity\Product\Product No errors.
Sylius\Component\Taxation\Model\TaxRate No errors.
Sylius\Component\Core\Model\TaxRate No errors.
App\Entity\Taxation\TaxRate No errors.
Sylius\Component\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
App\Entity\Shipping\ShippingMethod No errors.
Sylius\Component\Promotion\Model\Promotion No errors.
Sylius\Component\Core\Model\Promotion No errors.
App\Entity\Promotion\Promotion No errors.
Sylius\Component\Currency\Model\ExchangeRate No errors.
App\Entity\Currency\ExchangeRate 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\Image No errors.
Sylius\Component\Core\Model\ProductImage No errors.
App\Entity\Product\ProductImage No errors.
Sylius\Component\Core\Model\ProductTaxon No errors.
App\Entity\Product\ProductTaxon No errors.
Sylius\Component\Product\Model\ProductVariant No errors.
Sylius\Component\Core\Model\ProductVariant No errors.
App\Entity\Product\ProductVariant No errors.
Sylius\Component\Core\Model\ChannelPricing No errors.
App\Entity\Channel\ChannelPricing No errors.
Sylius\Component\Product\Model\ProductOptionValue No errors.
App\Entity\Product\ProductOptionValue No errors.
Sylius\MolliePlugin\Entity\ProductType No errors.
Sylius\Component\Taxation\Model\TaxCategory No errors.
App\Entity\Taxation\TaxCategory No errors.
Sylius\Component\Shipping\Model\ShippingCategory No errors.
App\Entity\Shipping\ShippingCategory No errors.
App\Entity\Product\ProductImmersionImage No errors.
Sylius\Component\Review\Model\Review No errors.
Sylius\Component\Core\Model\ProductReview No errors.
App\Entity\Product\ProductReview No errors.
Sylius\Component\Attribute\Model\AttributeValue No errors.
Sylius\Component\Product\Model\ProductAttributeValue No errors.
App\Entity\Product\ProductAttributeValue No errors.
Sylius\Component\Product\Model\ProductAssociation No errors.
App\Entity\Product\ProductAssociation No errors.
Sylius\Component\Product\Model\ProductVariantTranslation No errors.
App\Entity\Product\ProductVariantTranslation No errors.
Sylius\Component\Promotion\Model\CatalogPromotion No errors.
Sylius\Component\Core\Model\CatalogPromotion No errors.
App\Entity\Promotion\CatalogPromotion No errors.
Sylius\Component\Attribute\Model\AttributeTranslation No errors.
Sylius\Component\Product\Model\ProductAttributeTranslation No errors.
App\Entity\Product\ProductAttributeTranslation No errors.
Sylius\Component\Taxonomy\Model\TaxonTranslation No errors.
App\Entity\Taxonomy\TaxonTranslation No errors.
Sylius\Component\Core\Model\TaxonImage No errors.
App\Entity\Taxonomy\TaxonImage No errors.
Sylius\Component\Product\Model\ProductOptionValueTranslation No errors.
App\Entity\Product\ProductOptionValueTranslation No errors.
Sylius\MolliePlugin\Entity\MollieCustomer No errors.
Sylius\MolliePlugin\Entity\MollieGatewayConfig No errors.
Sylius\InvoicingPlugin\Entity\Invoice No errors.