Query Metrics
141
Database Queries
47
Different statements
98.26 ms
Query time
0
Invalid entities
134
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.27 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.password_reset_token AS password_reset_token_6, t0.password_requested_at AS password_requested_at_7, t0.email_verification_token AS email_verification_token_8, t0.verified_at AS verified_at_9, t0.roles AS roles_10, t0.email AS email_11, t0.email_canonical AS email_canonical_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.id AS id_15, t0.first_name AS first_name_16, t0.last_name AS last_name_17, t0.locale_code AS locale_code_18, t0.mollie_onboarding_completed AS mollie_onboarding_completed_19, t20.type AS type_21, t20.path AS path_22, t20.id AS id_23, t20.owner_id AS owner_id_24 FROM sylius_admin_user t0 LEFT JOIN sylius_avatar_image t20 ON t20.owner_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 1.48 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 ] |
| 3 | 0.91 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"
]
|
| 4 | 1.36 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enabled AS enabled_4, t0.id AS id_5, t0.variant_selection_method AS variant_selection_method_6, t0.average_rating AS average_rating_7, t0.is_new AS is_new_8, t0.is_iconic AS is_iconic_9, t0.is_featured AS is_featured_10, t0.is_engravable AS is_engravable_11, t0.code_douane AS code_douane_12, t0.main_taxon_id AS main_taxon_id_13, t0.product_type_id AS product_type_id_14 FROM sylius_product t0 WHERE t0.id = ?
Parameters:
[
659
]
|
| 5 | 0.89 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
Parameters:
[] |
| 6 | 0.93 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
Parameters:
[] |
| 7 | 0.73 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_product_association_type t0
Parameters:
[] |
| 8 | 1.02 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_association_type_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 1 "fr_FR" ] |
| 9 | 1.63 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
Parameters:
[] |
| 10 | 1.10 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.recurring AS recurring_16, t0.recurring_times AS recurring_times_17, t0.recurring_interval AS recurring_interval_18, t0.product_id AS product_id_19, t0.tax_category_id AS tax_category_id_20, t0.shipping_category_id AS shipping_category_id_21 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
Parameters:
[ 659 1 ] |
| 11 | 0.92 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.recurring AS recurring_16, t0.recurring_times AS recurring_times_17, t0.recurring_interval AS recurring_interval_18, t0.product_id AS product_id_19, t0.tax_category_id AS tax_category_id_20, t0.shipping_category_id AS shipping_category_id_21 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
659
]
|
| 12 | 1.17 ms |
SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.filterable AS filterable_6 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
659
]
|
| 13 | 0.51 ms |
SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6 FROM sylius_tax_category t0
Parameters:
[] |
| 14 | 0.47 ms |
SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6 FROM sylius_shipping_category t0
Parameters:
[] |
| 15 | 0.61 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:
[
659
]
|
| 16 | 1.42 ms |
SELECT COUNT(*) FROM sylius_product_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 659 "fr_FR" ] |
| 17 | 0.55 ms |
SELECT COUNT(*) FROM sylius_product_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 659 "fr_FR" ] |
| 18 | 0.67 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 659 "fr_FR" ] |
| 19 | 0.63 ms |
SELECT COUNT(*) FROM sylius_product_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 659 "en_US" ] |
| 20 | 0.49 ms |
SELECT COUNT(*) FROM sylius_product_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 659 "en_US" ] |
| 21 | 0.72 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 659 "en_US" ] |
| 22 | 0.64 ms |
SELECT COUNT(*) FROM sylius_product_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 659 "de_DE" ] |
| 23 | 0.49 ms |
SELECT COUNT(*) FROM sylius_product_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 659 "de_DE" ] |
| 24 | 0.66 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 659 "de_DE" ] |
| 25 | 0.57 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
Parameters:
[] |
| 26 | 0.85 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 21 "fr_FR" ] |
| 27 | 0.55 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
Parameters:
[] |
| 28 | 0.62 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 24 "fr_FR" ] |
| 29 | 0.54 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
Parameters:
[] |
| 30 | 0.70 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 2 "fr_FR" ] |
| 31 | 0.66 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
Parameters:
[] |
| 32 | 0.80 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 17 "fr_FR" ] |
| 33 | 0.57 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
Parameters:
[] |
| 34 | 0.53 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
Parameters:
[] |
| 35 | 0.53 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
Parameters:
[] |
| 36 | 0.52 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
Parameters:
[] |
| 37 | 0.60 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
Parameters:
[] |
| 38 | 0.56 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
Parameters:
[] |
| 39 | 0.63 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
Parameters:
[] |
| 40 | 0.58 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
Parameters:
[] |
| 41 | 0.93 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.association_type_id AS association_type_id_4, t0.product_id AS product_id_5 FROM sylius_product_association t0 WHERE t0.product_id = ? ORDER BY t0.id ASC
Parameters:
[
659
]
|
| 42 | 2.13 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:
[
659
]
|
| 43 | 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:
[
9
]
|
| 44 | 0.66 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_.tree_root AS tree_root_9, s0_.parent_id AS parent_id_10 FROM sylius_taxon s0_ ORDER BY s0_.id ASC
Parameters:
[] |
| 45 | 0.79 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 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
659
]
|
| 46 | 0.91 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.recurring AS recurring_16, t0.recurring_times AS recurring_times_17, t0.recurring_interval AS recurring_interval_18, t0.product_id AS product_id_19, t0.tax_category_id AS tax_category_id_20, t0.shipping_category_id AS shipping_category_id_21 FROM sylius_product_variant t0 INNER JOIN sylius_product_image_product_variants ON t0.id = sylius_product_image_product_variants.variant_id WHERE sylius_product_image_product_variants.image_id = ? ORDER BY t0.id ASC
Parameters:
[
8533
]
|
| 47 | 0.70 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.recurring AS recurring_16, t0.recurring_times AS recurring_times_17, t0.recurring_interval AS recurring_interval_18, t0.product_id AS product_id_19, t0.tax_category_id AS tax_category_id_20, t0.shipping_category_id AS shipping_category_id_21 FROM sylius_product_variant t0 INNER JOIN sylius_product_image_product_variants ON t0.id = sylius_product_image_product_variants.variant_id WHERE sylius_product_image_product_variants.image_id = ? ORDER BY t0.id ASC
Parameters:
[
8534
]
|
| 48 | 0.66 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.recurring AS recurring_16, t0.recurring_times AS recurring_times_17, t0.recurring_interval AS recurring_interval_18, t0.product_id AS product_id_19, t0.tax_category_id AS tax_category_id_20, t0.shipping_category_id AS shipping_category_id_21 FROM sylius_product_variant t0 INNER JOIN sylius_product_image_product_variants ON t0.id = sylius_product_image_product_variants.variant_id WHERE sylius_product_image_product_variants.image_id = ? ORDER BY t0.id ASC
Parameters:
[
5831
]
|
| 49 | 0.65 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.recurring AS recurring_16, t0.recurring_times AS recurring_times_17, t0.recurring_interval AS recurring_interval_18, t0.product_id AS product_id_19, t0.tax_category_id AS tax_category_id_20, t0.shipping_category_id AS shipping_category_id_21 FROM sylius_product_variant t0 INNER JOIN sylius_product_image_product_variants ON t0.id = sylius_product_image_product_variants.variant_id WHERE sylius_product_image_product_variants.image_id = ? ORDER BY t0.id ASC
Parameters:
[
5830
]
|
| 50 | 0.61 ms |
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.title_fr AS title_fr_4, t0.title_en AS title_en_5, t0.title_de AS title_de_6, t0.updatedAt AS updatedAt_7, t0.product_id AS product_id_8 FROM app_product_immersion_image t0 WHERE t0.product_id = ?
Parameters:
[
659
]
|
| 51 | 0.81 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
Parameters:
[] |
| 52 | 0.55 ms |
SELECT COUNT(*) FROM sylius_product_variant_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 835 "fr_FR" ] |
| 53 | 0.43 ms |
SELECT COUNT(*) FROM sylius_product_variant_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 835 "fr_FR" ] |
| 54 | 0.47 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_variant_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 835 "fr_FR" ] |
| 55 | 0.43 ms |
SELECT COUNT(*) FROM sylius_product_variant_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 835 "en_US" ] |
| 56 | 0.39 ms |
SELECT COUNT(*) FROM sylius_product_variant_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 835 "en_US" ] |
| 57 | 0.37 ms |
SELECT COUNT(*) FROM sylius_product_variant_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 835 "de_DE" ] |
| 58 | 0.38 ms |
SELECT COUNT(*) FROM sylius_product_variant_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 835 "de_DE" ] |
| 59 | 0.66 ms |
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC
Parameters:
[
835
]
|
| 60 | 1.27 ms |
SELECT t0.position AS position_1, t0.id AS id_2, t0.product_id AS product_id_3, t0.taxon_id AS taxon_id_4 FROM sylius_product_taxon t0 WHERE t0.product_id = ? ORDER BY t0.id ASC
Parameters:
[
659
]
|
| 61 | 0.66 ms |
SELECT COUNT(*) FROM sylius_product_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 659 "fr_FR" ] |
| 62 | 0.44 ms |
SELECT COUNT(*) FROM sylius_product_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 659 "fr_FR" ] |
| 63 | 0.60 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 659 "fr_FR" ] |
| 64 | 0.41 ms |
SELECT COUNT(*) FROM sylius_product_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 659 "en_US" ] |
| 65 | 0.41 ms |
SELECT COUNT(*) FROM sylius_product_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 659 "en_US" ] |
| 66 | 0.51 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 659 "en_US" ] |
| 67 | 0.96 ms |
SELECT COUNT(*) FROM sylius_product_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 659 "de_DE" ] |
| 68 | 0.54 ms |
SELECT COUNT(*) FROM sylius_product_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 659 "de_DE" ] |
| 69 | 0.74 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 659 "de_DE" ] |
| 70 | 0.78 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
659
]
|
| 71 | 0.64 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 = ? LIMIT 1
Parameters:
[
"nombre-de-pieces"
]
|
| 72 | 0.48 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 = ? LIMIT 1
Parameters:
[
"matieres-des-mitres"
]
|
| 73 | 0.46 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 = ? LIMIT 1
Parameters:
[
"finition"
]
|
| 74 | 0.63 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 = ? LIMIT 1
Parameters:
[
"brand"
]
|
| 75 | 0.52 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 = ? LIMIT 1
Parameters:
[
"nombre-de-pieces"
]
|
| 76 | 0.59 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 = ? LIMIT 1
Parameters:
[
"nombre-de-pieces"
]
|
| 77 | 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.code = ? LIMIT 1
Parameters:
[
"matieres-des-mitres"
]
|
| 78 | 0.49 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 = ? LIMIT 1
Parameters:
[
"matieres-des-mitres"
]
|
| 79 | 0.61 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 = ? LIMIT 1
Parameters:
[
"finition"
]
|
| 80 | 0.63 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 = ? LIMIT 1
Parameters:
[
"finition"
]
|
| 81 | 0.65 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 = ? LIMIT 1
Parameters:
[
"brand"
]
|
| 82 | 0.64 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 = ? LIMIT 1
Parameters:
[
"brand"
]
|
| 83 | 0.67 ms |
SELECT COUNT(*) FROM sylius_product_variant_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 835 "fr_FR" ] |
| 84 | 0.53 ms |
SELECT COUNT(*) FROM sylius_product_variant_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 835 "fr_FR" ] |
| 85 | 0.48 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_variant_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 835 "fr_FR" ] |
| 86 | 0.48 ms |
SELECT COUNT(*) FROM sylius_product_variant_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 835 "en_US" ] |
| 87 | 0.50 ms |
SELECT COUNT(*) FROM sylius_product_variant_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 835 "en_US" ] |
| 88 | 0.48 ms |
SELECT COUNT(*) FROM sylius_product_variant_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 835 "de_DE" ] |
| 89 | 0.45 ms |
SELECT COUNT(*) FROM sylius_product_variant_translation t0 WHERE (t0.translatable_id = ? AND t0.locale = ?)
Parameters:
[ 835 "de_DE" ] |
| 90 | 0.60 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_variant_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
835
]
|
| 91 | 0.58 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_couteaux_pliants"
]
|
| 92 | 0.49 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"
]
|
| 93 | 0.45 ms |
SELECT t0.position AS position_1, t0.id AS id_2, t0.product_id AS product_id_3, t0.taxon_id AS taxon_id_4 FROM sylius_product_taxon t0 WHERE t0.taxon_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ 9 659 ] |
| 94 | 0.44 ms |
SELECT t0.position AS position_1, t0.id AS id_2, t0.product_id AS product_id_3, t0.taxon_id AS taxon_id_4 FROM sylius_product_taxon t0 WHERE t0.taxon_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ 8 659 ] |
| 95 | 0.56 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 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
659
]
|
| 96 | 0.49 ms |
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.title_fr AS title_fr_4, t0.title_en AS title_en_5, t0.title_de AS title_de_6, t0.updatedAt AS updatedAt_7, t0.product_id AS product_id_8 FROM app_product_immersion_image t0 WHERE t0.product_id = ?
Parameters:
[
659
]
|
| 97 | 1.30 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.recurring AS recurring_16, t0.recurring_times AS recurring_times_17, t0.recurring_interval AS recurring_interval_18, t0.product_id AS product_id_19, t0.tax_category_id AS tax_category_id_20, t0.shipping_category_id AS shipping_category_id_21 FROM sylius_product_variant t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"1211 BC - 3648"
]
|
| 98 | 0.55 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enabled AS enabled_4, t0.id AS id_5, t0.variant_selection_method AS variant_selection_method_6, t0.average_rating AS average_rating_7, t0.is_new AS is_new_8, t0.is_iconic AS is_iconic_9, t0.is_featured AS is_featured_10, t0.is_engravable AS is_engravable_11, t0.code_douane AS code_douane_12, t0.main_taxon_id AS main_taxon_id_13, t0.product_type_id AS product_type_id_14 FROM sylius_product t0 WHERE t0.code = ? LIMIT 2
Parameters:
[
"1211 BC - 3648"
]
|
| 99 | 0.52 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
Parameters:
[] |
| 100 | 0.54 ms |
SELECT t0.position AS position_1, t0.id AS id_2, t0.product_id AS product_id_3, t0.taxon_id AS taxon_id_4 FROM sylius_product_taxon t0 WHERE t0.product_id = ? AND t0.taxon_id = ? LIMIT 2
Parameters:
[ 659 9 ] |
| 101 | 0.50 ms |
SELECT t0.position AS position_1, t0.id AS id_2, t0.product_id AS product_id_3, t0.taxon_id AS taxon_id_4 FROM sylius_product_taxon t0 WHERE t0.product_id = ? AND t0.taxon_id = ? LIMIT 2
Parameters:
[ 659 8 ] |
| 102 | 0.81 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.locale = ? AND t0.slug = ? LIMIT 2
Parameters:
[ "de_DE" "taschenmesser-11-cm-griff-aus-hellem-horn-und-mitres-aus-messing-1211-bc-3648" ] |
| 103 | 0.60 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.locale = ? AND t0.translatable_id = ? LIMIT 2
Parameters:
[ "de_DE" 659 ] |
| 104 | 0.62 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.locale = ? AND t0.slug = ? LIMIT 2
Parameters:
[ "en_US" "folding-knife-11-cm-light-horn-handle-and-high-polished-finish-with-brass-bolsters-1211-bc-3648" ] |
| 105 | 0.53 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.locale = ? AND t0.translatable_id = ? LIMIT 2
Parameters:
[ "en_US" 659 ] |
| 106 | 0.58 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.locale = ? AND t0.slug = ? LIMIT 2
Parameters:
[ "fr_FR" "couteau-pliant-laguiole-11-cm-corne-claire-laiton" ] |
| 107 | 0.50 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.metaTitle AS metaTitle_8, t0.metaRobots AS metaRobots_9, t0.ogTitle AS ogTitle_10, t0.ogDescription AS ogDescription_11, t0.ogImage AS ogImage_12, t0.twitterTitle AS twitterTitle_13, t0.twitterDescription AS twitterDescription_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM sylius_product_translation t0 WHERE t0.locale = ? AND t0.translatable_id = ? LIMIT 2
Parameters:
[ "fr_FR" 659 ] |
| 108 | 1.02 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 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC
Parameters:
[
835
]
|
| 109 | 0.62 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.recurring AS recurring_16, t0.recurring_times AS recurring_times_17, t0.recurring_interval AS recurring_interval_18, t0.product_id AS product_id_19, t0.tax_category_id AS tax_category_id_20, t0.shipping_category_id AS shipping_category_id_21 FROM sylius_product_variant t0 WHERE t0.code = ? LIMIT 2
Parameters:
[
"1211 BC - 3648"
]
|
| 110 | 0.58 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
Parameters:
[] |
| 111 | 0.68 ms |
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.channel_code = ? AND t0.product_variant_id = ? LIMIT 2
Parameters:
[ "WEB-EU" 835 ] |
| 112 | 1.00 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 = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
"WEB-EU"
]
|
| 113 | 0.60 ms |
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.channel_code = ? AND t0.product_variant_id = ? LIMIT 2
Parameters:
[ "WEB-HORS-EU" 835 ] |
| 114 | 0.83 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 = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
"WEB-HORS-EU"
]
|
| 115 | 0.64 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_variant_translation t0 WHERE t0.locale = ? AND t0.translatable_id = ? LIMIT 2
Parameters:
[ "fr_FR" 835 ] |
| 116 | 0.67 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 3 "fr_FR" ] |
| 117 | 0.74 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 4 "fr_FR" ] |
| 118 | 0.84 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 5 "fr_FR" ] |
| 119 | 0.73 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 6 "fr_FR" ] |
| 120 | 0.71 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 7 "fr_FR" ] |
| 121 | 0.55 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 8 "fr_FR" ] |
| 122 | 0.60 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 9 "fr_FR" ] |
| 123 | 0.58 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 10 "fr_FR" ] |
| 124 | 0.69 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 11 "fr_FR" ] |
| 125 | 0.67 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 12 "fr_FR" ] |
| 126 | 0.64 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 13 "fr_FR" ] |
| 127 | 0.50 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 14 "fr_FR" ] |
| 128 | 0.53 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 15 "fr_FR" ] |
| 129 | 0.50 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 16 "fr_FR" ] |
| 130 | 0.53 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 18 "fr_FR" ] |
| 131 | 0.47 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 19 "fr_FR" ] |
| 132 | 0.45 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 20 "fr_FR" ] |
| 133 | 0.46 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 22 "fr_FR" ] |
| 134 | 0.51 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 23 "fr_FR" ] |
| 135 | 0.47 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 25 "fr_FR" ] |
| 136 | 0.52 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 26 "fr_FR" ] |
| 137 | 0.57 ms |
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_attribute_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 27 "fr_FR" ] |
| 138 | 1.16 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:
[ 8 "fr_FR" ] |
| 139 | 0.65 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:
[ 9 "fr_FR" ] |
| 140 | 0.83 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_.recurring AS recurring_15, s0_.recurring_times AS recurring_times_16, s0_.recurring_interval AS recurring_interval_17, s0_.product_id AS product_id_18, s0_.tax_category_id AS tax_category_id_19, s0_.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant s0_ WHERE s0_.product_id = ? ORDER BY s0_.id ASC
Parameters:
[
659
]
|
| 141 | 2.81 ms |
SELECT taxon.id as id, taxon.tree_root as tree_root, taxon.parent_id as parent_id, taxon.code as code, taxon.tree_left as tree_left, taxon.tree_right as tree_right, taxon.tree_level as tree_level, taxon.position as position, COALESCE(current_translation.name, fallback_translation.name) as name FROM sylius_taxon taxon LEFT JOIN sylius_taxon_translation current_translation ON (current_translation.translatable_id = taxon.id) AND (current_translation.locale = ?) LEFT JOIN sylius_taxon_translation fallback_translation ON (fallback_translation.translatable_id = taxon.id) AND (fallback_translation.locale = ?) ORDER BY taxon.tree_level DESC, taxon.position ASC
Parameters:
[ "fr_FR" "fr_FR" ] |
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\Taxonomy\Taxon | 45 |
| App\Entity\Product\ProductAttribute | 26 |
| App\Entity\Product\ProductAttributeTranslation | 26 |
| App\Entity\Product\ProductAttributeValue | 4 |
| App\Entity\Product\ProductImage | 4 |
| App\Entity\Locale\Locale | 3 |
| App\Entity\Product\ProductTranslation | 3 |
| App\Entity\Channel\Channel | 2 |
| App\Entity\Addressing\Zone | 2 |
| App\Entity\Channel\ShopBillingData | 2 |
| App\Entity\Channel\ChannelPriceHistoryConfig | 2 |
| App\Entity\Taxation\TaxCategory | 2 |
| App\Entity\Channel\ChannelPricing | 2 |
| App\Entity\Product\ProductTaxon | 2 |
| App\Entity\Taxonomy\TaxonTranslation | 2 |
| App\Entity\User\AdminUser | 1 |
| App\Entity\Currency\Currency | 1 |
| App\Entity\Product\Product | 1 |
| App\Entity\Product\ProductAssociationType | 1 |
| App\Entity\Product\ProductAssociationTypeTranslation | 1 |
| App\Entity\Product\ProductVariant | 1 |
| App\Entity\Product\ProductVariantTranslation | 1 |