Query Metrics

128 Database Queries
22 Different statements
29.61 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.65 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.default_locale_id AS default_locale_id_17, t18.code AS code_19, t18.created_at AS created_at_20, t18.updated_at AS updated_at_21, t18.id AS id_22, t0.base_currency_id AS base_currency_id_23, t24.code AS code_25, t24.created_at AS created_at_26, t24.updated_at AS updated_at_27, t24.id AS id_28, t0.default_tax_zone_id AS default_tax_zone_id_29, t0.menu_taxon_id AS menu_taxon_id_30, t0.shop_billing_data_id AS shop_billing_data_id_31 FROM sylius_channel t0 INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id WHERE t0.hostname = ? LIMIT 1
Parameters:
[
  "trains-expo.caramia.fr"
]
2 0.23 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.default_locale_id AS default_locale_id_17, t18.code AS code_19, t18.created_at AS created_at_20, t18.updated_at AS updated_at_21, t18.id AS id_22, t0.base_currency_id AS base_currency_id_23, t24.code AS code_25, t24.created_at AS created_at_26, t24.updated_at AS updated_at_27, t24.id AS id_28, t0.default_tax_zone_id AS default_tax_zone_id_29, t0.menu_taxon_id AS menu_taxon_id_30, t0.shop_billing_data_id AS shop_billing_data_id_31 FROM sylius_channel t0 INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id
Parameters:
[]
3 0.34 ms
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = ?
Parameters:
[
  1
]
4 0.21 ms
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?
Parameters:
[
  1
]
5 0.18 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
  1
]
6 0.37 ms
SELECT COUNT(m0_.id) AS sclr_0 FROM monsieurbiz_cms_page m0_ INNER JOIN monsieurbiz_cms_page_translation m1_ ON m0_.id = m1_.translatable_id AND (m1_.locale = ?) WHERE m1_.slug = ? AND EXISTS (SELECT 1 FROM monsieurbiz_cms_page_channels m2_ WHERE m2_.page_id = m0_.id AND m2_.channel_id IN (?)) AND m0_.enabled = 1
Parameters:
[
  "fr_FR"
  "taxons/hygiene-securite"
  1
]
7 0.37 ms
SELECT COUNT(m0_.id) AS sclr_0 FROM monsieurbiz_cms_page m0_ INNER JOIN monsieurbiz_cms_page_translation m1_ ON m0_.id = m1_.translatable_id AND (m1_.locale = ?) WHERE m1_.slug = ? AND EXISTS (SELECT 1 FROM monsieurbiz_cms_page_channels m2_ WHERE m2_.page_id = m0_.id AND m2_.channel_id IN (?)) AND m0_.enabled = 1
Parameters:
[
  "fr_FR"
  "taxons/hygiene-securite"
  1
]
8 0.33 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, s1_.name AS name_9, s1_.slug AS slug_10, s1_.description AS description_11, s1_.id AS id_12, s1_.locale AS locale_13, s0_.tree_root AS tree_root_14, s0_.parent_id AS parent_id_15, s1_.translatable_id AS translatable_id_16 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.enabled = ? AND s1_.slug = ? AND s1_.locale = ?
Parameters:
[
  1
  "hygiene-securite"
  "fr_FR"
]
9 2.47 ms
SELECT DISTINCT id_4 FROM (SELECT DISTINCT id_4, name_7 FROM (SELECT DISTINCT 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, s1_.name AS name_7, s1_.slug AS slug_8, s1_.description AS description_9, s1_.meta_keywords AS meta_keywords_10, s1_.meta_description AS meta_description_11, s1_.id AS id_12, s1_.short_description AS short_description_13, s1_.locale AS locale_14, s2_.position AS position_15, s2_.id AS id_16, s3_.tree_left AS tree_left_17, s3_.tree_right AS tree_right_18 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) INNER JOIN sylius_product_taxon s2_ ON s0_.id = s2_.product_id INNER JOIN sylius_taxon s3_ ON s2_.taxon_id = s3_.id WHERE s3_.tree_left >= ? AND s3_.tree_right <= ? AND s3_.tree_root = ? AND EXISTS (SELECT 1 FROM sylius_product_channels s4_ WHERE s4_.product_id = s0_.id AND s4_.channel_id IN (?)) AND s0_.enabled = ?) dctrn_result_inner ORDER BY name_7 DESC) dctrn_result LIMIT 9
Parameters:
[
  "fr_FR"
  1
  10
  9
  1
  1
]
10 1.35 ms
SELECT DISTINCT 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, s1_.name AS name_7, s1_.slug AS slug_8, s1_.description AS description_9, s1_.meta_keywords AS meta_keywords_10, s1_.meta_description AS meta_description_11, s1_.id AS id_12, s1_.short_description AS short_description_13, s1_.locale AS locale_14, s2_.position AS position_15, s2_.id AS id_16, s0_.main_taxon_id AS main_taxon_id_17, s0_.vendor_id AS vendor_id_18, s1_.translatable_id AS translatable_id_19, s2_.product_id AS product_id_20, s2_.taxon_id AS taxon_id_21 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) INNER JOIN sylius_product_taxon s2_ ON s0_.id = s2_.product_id INNER JOIN sylius_taxon s3_ ON s2_.taxon_id = s3_.id WHERE s3_.tree_left >= ? AND s3_.tree_right <= ? AND s3_.tree_root = ? AND EXISTS (SELECT 1 FROM sylius_product_channels s4_ WHERE s4_.product_id = s0_.id AND s4_.channel_id IN (?)) AND s0_.enabled = ? AND s0_.id IN (?) ORDER BY s1_.name DESC
Parameters:
[
  "fr_FR"
  1
  10
  9
  1
  1
  [
    20
    22
    21
    27
    25
    31
    29
    18
    34
  ]
]
11 0.17 ms
SELECT t0.is_packed_product AS is_packed_product_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.product_id AS product_id_5 FROM bitbag_product_bundle t0 WHERE t0.product_id = ?
Parameters:
[
  20
]
12 0.25 ms
SELECT t0.is_packed_product AS is_packed_product_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.product_id AS product_id_5 FROM bitbag_product_bundle t0 WHERE t0.product_id = ?
Parameters:
[
  22
]
13 0.17 ms
SELECT t0.is_packed_product AS is_packed_product_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.product_id AS product_id_5 FROM bitbag_product_bundle t0 WHERE t0.product_id = ?
Parameters:
[
  21
]
14 0.16 ms
SELECT t0.is_packed_product AS is_packed_product_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.product_id AS product_id_5 FROM bitbag_product_bundle t0 WHERE t0.product_id = ?
Parameters:
[
  27
]
15 0.17 ms
SELECT t0.is_packed_product AS is_packed_product_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.product_id AS product_id_5 FROM bitbag_product_bundle t0 WHERE t0.product_id = ?
Parameters:
[
  25
]
16 0.14 ms
SELECT t0.is_packed_product AS is_packed_product_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.product_id AS product_id_5 FROM bitbag_product_bundle t0 WHERE t0.product_id = ?
Parameters:
[
  31
]
17 0.13 ms
SELECT t0.is_packed_product AS is_packed_product_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.product_id AS product_id_5 FROM bitbag_product_bundle t0 WHERE t0.product_id = ?
Parameters:
[
  29
]
18 0.13 ms
SELECT t0.is_packed_product AS is_packed_product_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.product_id AS product_id_5 FROM bitbag_product_bundle t0 WHERE t0.product_id = ?
Parameters:
[
  18
]
19 0.13 ms
SELECT t0.is_packed_product AS is_packed_product_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.product_id AS product_id_5 FROM bitbag_product_bundle t0 WHERE t0.product_id = ?
Parameters:
[
  34
]
20 0.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.default_locale_id AS default_locale_id_17, t18.code AS code_19, t18.created_at AS created_at_20, t18.updated_at AS updated_at_21, t18.id AS id_22, t0.base_currency_id AS base_currency_id_23, t24.code AS code_25, t24.created_at AS created_at_26, t24.updated_at AS updated_at_27, t24.id AS id_28, t0.default_tax_zone_id AS default_tax_zone_id_29, t0.menu_taxon_id AS menu_taxon_id_30, t0.shop_billing_data_id AS shop_billing_data_id_31 FROM sylius_channel t0 INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id
Parameters:
[]
21 0.26 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
Parameters:
[]
22 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.category = ?
Parameters:
[
  1
]
23 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
24 0.15 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  5
]
25 0.19 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5
  "fr_FR"
]
26 0.18 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  7
]
27 0.20 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  7
  "fr_FR"
]
28 0.17 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  33
]
29 0.20 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  33
  "fr_FR"
]
30 0.16 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  34
]
31 0.18 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  34
  "fr_FR"
]
32 0.14 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  35
]
33 0.17 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  35
  "fr_FR"
]
34 0.14 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  41
]
35 0.17 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  41
  "fr_FR"
]
36 0.14 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  37
]
37 0.17 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  37
  "fr_FR"
]
38 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  5
]
39 0.16 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  11
]
40 0.17 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  11
  "fr_FR"
]
41 0.14 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  12
]
42 0.21 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  12
  "fr_FR"
]
43 0.13 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  38
]
44 0.17 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  38
  "fr_FR"
]
45 0.14 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  14
]
46 0.17 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  14
  "fr_FR"
]
47 0.16 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  15
]
48 0.17 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  15
  "fr_FR"
]
49 0.12 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  16
]
50 0.16 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  16
  "fr_FR"
]
51 0.14 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  17
]
52 0.17 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  17
  "fr_FR"
]
53 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.category = ?
Parameters:
[
  2
]
54 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  12
]
55 0.14 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  39
]
56 0.13 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  39
  "fr_FR"
]
57 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  24
]
58 0.09 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  31
]
59 0.17 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  31
  "fr_FR"
]
60 0.14 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  28
]
61 0.20 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  28
  "fr_FR"
]
62 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  25
]
63 0.15 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  40
]
64 0.19 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  40
  "fr_FR"
]
65 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  26
]
66 0.14 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_cms_page t0 WHERE t0.id = ?
Parameters:
[
  29
]
67 0.18 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.metaTitle AS metaTitle_4, t0.metaKeywords AS metaKeywords_5, t0.metaDescription AS metaDescription_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  29
  "fr_FR"
]
68 0.16 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5
  "fr_FR"
]
69 0.19 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
Parameters:
[
  5
]
70 0.18 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  6
  "fr_FR"
]
71 0.20 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  7
  "fr_FR"
]
72 0.18 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  8
  "fr_FR"
]
73 0.20 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
Parameters:
[
  9
]
74 0.16 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  10
  "fr_FR"
]
75 0.16 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  11
  "fr_FR"
]
76 0.15 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  17
  "fr_FR"
]
77 0.14 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  18
  "fr_FR"
]
78 0.13 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  12
  "fr_FR"
]
79 0.16 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
Parameters:
[
  12
]
80 0.12 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  13
  "fr_FR"
]
81 0.11 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  14
  "fr_FR"
]
82 0.10 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  15
  "fr_FR"
]
83 0.10 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  16
  "fr_FR"
]
84 0.27 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
Parameters:
[]
85 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.category = ?
Parameters:
[
  1
]
86 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.category = ?
Parameters:
[
  2
]
87 0.24 ms
SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s1_.name AS name_9, s1_.slug AS slug_10, s1_.description AS description_11, s1_.id AS id_12, s1_.locale AS locale_13, s0_.tree_root AS tree_root_14, s0_.parent_id AS parent_id_15, s1_.translatable_id AS translatable_id_16 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.enabled = ? AND s1_.slug = ? AND s1_.locale = ?
Parameters:
[
  1
  "hygiene-securite"
  "fr_FR"
]
88 0.25 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, s1_.name AS name_9, s1_.slug AS slug_10, s1_.description AS description_11, s1_.id AS id_12, s1_.locale AS locale_13, s0_.tree_root AS tree_root_14, s0_.parent_id AS parent_id_15, s1_.translatable_id AS translatable_id_16 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.enabled = ? AND s1_.slug = ? AND s1_.locale = ?
Parameters:
[
  1
  "hygiene-securite"
  "fr_FR"
]
89 0.17 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
Parameters:
[]
90 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.category = ?
Parameters:
[
  1
]
91 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.isParent AS isParent_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7 FROM menu t0 WHERE t0.category = ?
Parameters:
[
  2
]
92 2.41 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (SELECT DISTINCT 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, s1_.name AS name_7, s1_.slug AS slug_8, s1_.description AS description_9, s1_.meta_keywords AS meta_keywords_10, s1_.meta_description AS meta_description_11, s1_.id AS id_12, s1_.short_description AS short_description_13, s1_.locale AS locale_14, s2_.position AS position_15, s2_.id AS id_16 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) INNER JOIN sylius_product_taxon s2_ ON s0_.id = s2_.product_id INNER JOIN sylius_taxon s3_ ON s2_.taxon_id = s3_.id WHERE s3_.tree_left >= ? AND s3_.tree_right <= ? AND s3_.tree_root = ? AND EXISTS (SELECT 1 FROM sylius_product_channels s4_ WHERE s4_.product_id = s0_.id AND s4_.channel_id IN (?)) AND s0_.enabled = ? ORDER BY s1_.name DESC) dctrn_result) dctrn_table
Parameters:
[
  "fr_FR"
  1
  10
  9
  1
  1
]
93 0.16 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ?
Parameters:
[
  20
]
94 0.21 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
  20
]
95 0.19 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.channel_code AS channel_code_3, t0.id AS id_4, t0.product_variant_id AS product_variant_id_5 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ?
Parameters:
[
  21
]
96 0.25 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 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
Parameters:
[
  20
]
97 0.27 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ?
Parameters:
[
  22
]
98 0.25 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
  22
]
99 0.18 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.channel_code AS channel_code_3, t0.id AS id_4, t0.product_variant_id AS product_variant_id_5 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ?
Parameters:
[
  23
]
100 0.20 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 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
Parameters:
[
  22
]
101 0.28 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ?
Parameters:
[
  21
]
102 0.22 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
  21
]
103 0.16 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.channel_code AS channel_code_3, t0.id AS id_4, t0.product_variant_id AS product_variant_id_5 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ?
Parameters:
[
  22
]
104 0.22 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 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
Parameters:
[
  21
]
105 0.18 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ?
Parameters:
[
  27
]
106 0.24 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
  27
]
107 0.16 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.channel_code AS channel_code_3, t0.id AS id_4, t0.product_variant_id AS product_variant_id_5 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ?
Parameters:
[
  28
]
108 0.21 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 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
Parameters:
[
  27
]
109 0.19 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ?
Parameters:
[
  25
]
110 0.20 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
  25
]
111 0.15 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.channel_code AS channel_code_3, t0.id AS id_4, t0.product_variant_id AS product_variant_id_5 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ?
Parameters:
[
  26
]
112 0.18 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 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
Parameters:
[
  25
]
113 0.16 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ?
Parameters:
[
  31
]
114 0.22 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
  31
]
115 0.15 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.channel_code AS channel_code_3, t0.id AS id_4, t0.product_variant_id AS product_variant_id_5 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ?
Parameters:
[
  32
]
116 0.19 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 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
Parameters:
[
  31
]
117 0.17 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ?
Parameters:
[
  29
]
118 0.24 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
  29
]
119 0.18 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.channel_code AS channel_code_3, t0.id AS id_4, t0.product_variant_id AS product_variant_id_5 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ?
Parameters:
[
  30
]
120 0.21 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 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
Parameters:
[
  29
]
121 0.19 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ?
Parameters:
[
  18
]
122 0.20 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
  18
]
123 0.15 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.channel_code AS channel_code_3, t0.id AS id_4, t0.product_variant_id AS product_variant_id_5 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ?
Parameters:
[
  19
]
124 0.19 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 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
Parameters:
[
  18
]
125 0.16 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ?
Parameters:
[
  34
]
126 0.20 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
  34
]
127 0.18 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.channel_code AS channel_code_3, t0.id AS id_4, t0.product_variant_id AS product_variant_id_5 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ?
Parameters:
[
  35
]
128 0.21 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 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
Parameters:
[
  34
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
MonsieurBiz\SyliusCmsPagePlugin\Entity\Page No errors.
Sylius\Component\Order\Model\Order No errors.
Sylius\Component\Core\Model\Order No errors.
App\Entity\Order\Order No errors.
Sylius\Component\Channel\Model\Channel No errors.
Sylius\Component\Core\Model\Channel No errors.
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.
Odiseo\SyliusVendorPlugin\Entity\Vendor No errors.
App\Entity\Vendor\Vendor No errors.
Sylius\Component\Addressing\Model\Country No errors.
App\Entity\Addressing\Country No errors.
MonsieurBiz\SyliusCmsPagePlugin\Entity\PageTranslation No errors.
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
App\Entity\Product\Product No errors.
Sylius\Component\Taxonomy\Model\TaxonTranslation No errors.
App\Entity\Taxonomy\TaxonTranslation No errors.
Sylius\Component\Core\Model\Image No errors.
Sylius\Component\Core\Model\TaxonImage No errors.
App\Entity\Taxonomy\TaxonImage No errors.
Sylius\Component\Product\Model\ProductTranslation No errors.
Sylius\Component\Core\Model\ProductTranslation No errors.
App\Entity\Product\ProductTranslation No errors.
Sylius\Component\Core\Model\ProductTaxon No errors.
App\Entity\Product\ProductTaxon No errors.
BitBag\SyliusProductBundlePlugin\Entity\ProductBundle No errors.
Sylius\Component\Core\Model\ProductImage No errors.
App\Entity\Product\ProductImage No errors.
Sylius\Component\Attribute\Model\AttributeValue No errors.
Sylius\Component\Product\Model\ProductAttributeValue No errors.
App\Entity\Product\ProductAttributeValue No errors.
Sylius\Component\Attribute\Model\Attribute No errors.
Sylius\Component\Product\Model\ProductAttribute No errors.
App\Entity\Product\ProductAttribute No errors.
Sylius\Component\Product\Model\ProductVariant No errors.
Sylius\Component\Core\Model\ProductVariant No errors.
App\Entity\Product\ProductVariant No errors.
Sylius\Component\Product\Model\ProductAssociation No errors.
App\Entity\Product\ProductAssociation No errors.
Sylius\Component\Product\Model\ProductOption No errors.
App\Entity\Product\ProductOption No errors.
Sylius\Component\Review\Model\Review No errors.
Sylius\Component\Core\Model\ProductReview No errors.
App\Entity\Product\ProductReview No errors.
Sylius\Component\Customer\Model\Customer No errors.
Sylius\Component\Core\Model\Customer No errors.
App\Entity\Customer\Customer No errors.
BitBag\SyliusProductBundlePlugin\Entity\ProductBundleOrderItem No errors.
Sylius\Component\Currency\Model\ExchangeRate No errors.
App\Entity\Currency\ExchangeRate No errors.
Sylius\Component\Promotion\Model\PromotionCoupon No errors.
Sylius\Component\Core\Model\PromotionCoupon No errors.
App\Entity\Promotion\PromotionCoupon No errors.
App\Entity\Invoice No errors.
Sylius\Component\Addressing\Model\Address No errors.
Sylius\Component\Core\Model\Address No errors.
App\Entity\Addressing\Address No errors.
Sylius\Component\Payment\Model\Payment No errors.
Sylius\Component\Core\Model\Payment No errors.
App\Entity\Payment\Payment No errors.
Sylius\Component\Shipping\Model\Shipment No errors.
Sylius\Component\Core\Model\Shipment No errors.
App\Entity\Shipping\Shipment No errors.
Sylius\Component\Promotion\Model\Promotion No errors.
Sylius\Component\Core\Model\Promotion No errors.
App\Entity\Promotion\Promotion No errors.
Sylius\Component\Order\Model\OrderItem No errors.
Sylius\Component\Core\Model\OrderItem No errors.
App\Entity\Order\OrderItem No errors.
Sylius\Component\Order\Model\Adjustment No errors.
Sylius\Component\Core\Model\Adjustment No errors.
App\Entity\Order\Adjustment No errors.
Sylius\Component\Addressing\Model\ZoneMember No errors.
App\Entity\Addressing\ZoneMember No errors.
Sylius\Component\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
App\Entity\Shipping\ShippingMethod No errors.
Odiseo\SyliusVendorPlugin\Entity\VendorTranslation No errors.
Odiseo\SyliusVendorPlugin\Entity\VendorEmail No errors.
Sylius\Component\Addressing\Model\Province No errors.
App\Entity\Addressing\Province No errors.
BitBag\SyliusProductBundlePlugin\Entity\ProductBundleItem No errors.
Sylius\Component\Attribute\Model\AttributeTranslation No errors.
Sylius\Component\Product\Model\ProductAttributeTranslation No errors.
App\Entity\Product\ProductAttributeTranslation 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.
Sylius\Component\Product\Model\ProductVariantTranslation No errors.
App\Entity\Product\ProductVariantTranslation 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\Component\Product\Model\ProductAssociationType No errors.
App\Entity\Product\ProductAssociationType No errors.
Sylius\Component\Product\Model\ProductOptionTranslation No errors.
App\Entity\Product\ProductOptionTranslation No errors.
Sylius\Component\Customer\Model\CustomerGroup No errors.
App\Entity\Customer\CustomerGroup No errors.
Sylius\Component\User\Model\User No errors.
Sylius\Component\Core\Model\ShopUser No errors.
App\Entity\User\ShopUser No errors.
Payum\Core\Model\Token No errors.
Payum\Core\Model\Payment No errors.
Payum\Core\Model\Payout No errors.
Payum\Core\Model\GatewayConfig No errors.
Payum\Core\Model\ArrayObject No errors.
Vich\UploaderBundle\Entity\File No errors.
Sylius\Component\Taxation\Model\TaxRate No errors.
Sylius\Component\Core\Model\TaxRate No errors.
App\Entity\Taxation\TaxRate No errors.
App\Entity\ContactRequest No errors.
Sylius\Component\Promotion\Model\PromotionRule No errors.
App\Entity\Promotion\PromotionRule No errors.
Sylius\Component\Promotion\Model\PromotionAction No errors.
App\Entity\Promotion\PromotionAction No errors.
Sylius\Component\Product\Model\ProductOptionValueTranslation No errors.
App\Entity\Product\ProductOptionValueTranslation No errors.
Sylius\Component\Product\Model\ProductAssociationTypeTranslation No errors.
App\Entity\Product\ProductAssociationTypeTranslation No errors.
Sylius\Component\Core\Model\AdminUser No errors.
App\Entity\User\AdminUser No errors.
Sylius\Component\Order\Model\OrderSequence No errors.
Sylius\Component\Core\Model\OrderSequence No errors.
App\Entity\Order\OrderSequence No errors.
Sylius\Component\Order\Model\OrderItemUnit No errors.
Sylius\Component\Core\Model\OrderItemUnit No errors.
App\Entity\Order\OrderItemUnit No errors.
App\Entity\Menu No errors.
App\Entity\Slide No errors.
Sylius\Bundle\PayumBundle\Model\PaymentSecurityToken No errors.
App\Entity\Payment\PaymentSecurityToken No errors.
Sylius\Bundle\PayumBundle\Model\GatewayConfig No errors.
App\Entity\Payment\GatewayConfig No errors.
Sylius\Component\Payment\Model\PaymentMethod No errors.
Sylius\Component\Core\Model\PaymentMethod No errors.
App\Entity\Payment\PaymentMethod No errors.
Sylius\Component\Payment\Model\PaymentMethodTranslation No errors.
App\Entity\Payment\PaymentMethodTranslation No errors.
Sylius\Component\Shipping\Model\ShippingMethodTranslation No errors.
App\Entity\Shipping\ShippingMethodTranslation No errors.
App\Entity\SlideImage No errors.
App\Entity\Media No errors.
Sylius\Component\Shipping\Model\ShipmentUnit No errors.
Sylius\Component\Shipping\Model\ShippingMethodRule No errors.
Sylius\Component\Addressing\Model\AddressLogEntry No errors.
Sylius\Component\Inventory\Model\InventoryUnit No errors.
Sylius\Component\User\Model\UserOAuth No errors.
Sylius\Component\Review\Model\Reviewer No errors.
Sylius\Component\Core\Model\AvatarImage No errors.