Symfony Profiler

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

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 = 'sogedisv2.preprod.d-impulse.com' AND t0.enabled = 1 ORDER BY t0.id ASC LIMIT 1;

SELECT
  COUNT(*)
FROM
  sylius_channel t0

SELECT COUNT(*) FROM sylius_channel t0;

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
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.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 LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4
FROM
  sylius_locale t0
  INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id
WHERE
  sylius_channel_locales.channel_id = ?

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 = 1;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.title AS title_3,
  t0.slug AS slug_4,
  t0.template AS template_5
FROM
  app_custom_page t0
WHERE
  t0.path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.slug AS slug_4, t0.template AS template_5 FROM app_custom_page t0 WHERE t0.path = '/cave-a-vin' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.featured AS featured_4,
  t0.position AS position_5,
  t0.createdAt AS createdAt_6,
  t0.updatedAt AS updatedAt_7
FROM
  app_brands t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.featured AS featured_4, t0.position AS position_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7 FROM app_brands t0 WHERE t0.slug = 'cave-a-vin' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.createdAt AS createdAt_1,
  a0_.updatedAt AS updatedAt_2
FROM
  app_categories a0_
  INNER JOIN app_categories_translation a1_ ON a0_.id = a1_.translatable_id
  AND (a1_.locale = ?)
WHERE
  a1_.slug = ?
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.createdAt AS createdAt_1, a0_.updatedAt AS updatedAt_2 FROM app_categories a0_ INNER JOIN app_categories_translation a1_ ON a0_.id = a1_.translatable_id AND (a1_.locale = 'fr_FR') WHERE a1_.slug = 'cave-a-vin' ORDER BY a0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.color AS color_2,
  t0.enabled AS enabled_3,
  t0.code AS code_4
FROM
  dimpulse_blog_post_category t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.color AS color_2, t0.enabled AS enabled_3, t0.code AS code_4 FROM dimpulse_blog_post_category t0 WHERE t0.code = 'diagnostics' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.publishedAt AS publishedAt_3,
  t0.category_id AS category_id_4
FROM
  dimpulse_blog_post t0
WHERE
  t0.enabled = ?
  AND t0.category_id IS NULL
ORDER BY
  t0.publishedAt DESC
LIMIT
  2

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.publishedAt AS publishedAt_3, t0.category_id AS category_id_4 FROM dimpulse_blog_post t0 WHERE t0.enabled = 1 AND t0.category_id IS NULL ORDER BY t0.publishedAt DESC LIMIT 2;

SELECT
  a0_.createdAt AS createdAt_0,
  a0_.updatedAt AS updatedAt_1,
  a0_.id AS id_2,
  a0_.reference AS reference_3,
  a0_.slug AS slug_4,
  a0_.codeSAP AS codeSAP_5,
  a0_.isWebPublished AS isWebPublished_6,
  a0_.factorySpecification AS factorySpecification_7,
  a0_.remarks AS remarks_8,
  a0_.agora AS agora_9,
  a1_.id AS id_10,
  a1_.name AS name_11,
  a1_.slug AS slug_12,
  a1_.featured AS featured_13,
  a1_.position AS position_14,
  a1_.createdAt AS createdAt_15,
  a1_.updatedAt AS updatedAt_16,
  a2_.id AS id_17,
  a2_.metaTitle AS metaTitle_18,
  a2_.metadataDescription AS metadataDescription_19,
  a2_.createdAt AS createdAt_20,
  a2_.updatedAt AS updatedAt_21,
  a2_.locale AS locale_22,
  a0_.brand_id AS brand_id_23,
  a0_.category_id AS category_id_24,
  a0_.factory_id AS factory_id_25,
  a0_.warrantyStatus_id AS warrantyStatus_id_26,
  a2_.translatable_id AS translatable_id_27
FROM
  app_products_finished a0_
  LEFT JOIN app_products_finished_translation a3_ ON a0_.id = a3_.translatable_id
  AND (a3_.locale = ?)
  LEFT JOIN app_brands a1_ ON a0_.brand_id = a1_.id
  LEFT JOIN app_brands_translation a2_ ON a1_.id = a2_.translatable_id
  AND (a2_.locale = ?)
  LEFT JOIN app_categories a4_ ON a0_.category_id = a4_.id
WHERE
  a4_.id = ?
ORDER BY
  a0_.id ASC

SELECT a0_.createdAt AS createdAt_0, a0_.updatedAt AS updatedAt_1, a0_.id AS id_2, a0_.reference AS reference_3, a0_.slug AS slug_4, a0_.codeSAP AS codeSAP_5, a0_.isWebPublished AS isWebPublished_6, a0_.factorySpecification AS factorySpecification_7, a0_.remarks AS remarks_8, a0_.agora AS agora_9, a1_.id AS id_10, a1_.name AS name_11, a1_.slug AS slug_12, a1_.featured AS featured_13, a1_.position AS position_14, a1_.createdAt AS createdAt_15, a1_.updatedAt AS updatedAt_16, a2_.id AS id_17, a2_.metaTitle AS metaTitle_18, a2_.metadataDescription AS metadataDescription_19, a2_.createdAt AS createdAt_20, a2_.updatedAt AS updatedAt_21, a2_.locale AS locale_22, a0_.brand_id AS brand_id_23, a0_.category_id AS category_id_24, a0_.factory_id AS factory_id_25, a0_.warrantyStatus_id AS warrantyStatus_id_26, a2_.translatable_id AS translatable_id_27 FROM app_products_finished a0_ LEFT JOIN app_products_finished_translation a3_ ON a0_.id = a3_.translatable_id AND (a3_.locale = 'fr_FR') LEFT JOIN app_brands a1_ ON a0_.brand_id = a1_.id LEFT JOIN app_brands_translation a2_ ON a1_.id = a2_.translatable_id AND (a2_.locale = 'fr_FR') LEFT JOIN app_categories a4_ ON a0_.category_id = a4_.id WHERE a4_.id = 12 ORDER BY a0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.shortDescription AS shortDescription_6,
  t0.createdAt AS createdAt_7,
  t0.updatedAt AS updatedAt_8,
  t0.metadata_title AS metadata_title_9,
  t0.metadata_description AS metadata_description_10,
  t0.locale AS locale_11,
  t0.translatable_id AS translatable_id_12
FROM
  app_categories_translation t0
WHERE
  t0.translatable_id = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.description AS description_5, t0.shortDescription AS shortDescription_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.metadata_title AS metadata_title_9, t0.metadata_description AS metadata_description_10, t0.locale AS locale_11, t0.translatable_id AS translatable_id_12 FROM app_categories_translation t0 WHERE t0.translatable_id = 12 AND t0.locale = 'fr_FR' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.createdAt AS createdAt_2,
  t0.updatedAt AS updatedAt_3
FROM
  app_media t0
  INNER JOIN categories_media ON t0.id = categories_media.media_id
WHERE
  categories_media.categories_id = ?

SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3 FROM app_media t0 INNER JOIN categories_media ON t0.id = categories_media.media_id WHERE categories_media.categories_id = 12;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.title AS title_3,
  t0.slug AS slug_4,
  t0.template AS template_5
FROM
  app_custom_page t0

SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.slug AS slug_4, t0.template AS template_5 FROM app_custom_page t0;

SELECT
  a0_.id AS id_0,
  a0_.sortOrder AS sortOrder_1,
  a0_.createdAt AS createdAt_2,
  a0_.updatedAt AS updatedAt_3,
  a1_.id AS id_4,
  a1_.createdAt AS createdAt_5,
  a1_.updatedAt AS updatedAt_6,
  a2_.id AS id_7,
  a2_.description AS description_8,
  a2_.fileName AS fileName_9,
  a2_.fileSize AS fileSize_10,
  a2_.isWeb AS isWeb_11,
  a2_.isPro AS isPro_12,
  a2_.isAgora AS isAgora_13,
  a2_.createdAt AS createdAt_14,
  a2_.updatedAt AS updatedAt_15,
  a2_.locale AS locale_16,
  a3_.id AS id_17,
  a3_.createdAt AS createdAt_18,
  a3_.updatedAt AS updatedAt_19,
  a4_.id AS id_20,
  a4_.shortDescription AS shortDescription_21,
  a4_.name AS name_22,
  a4_.slug AS slug_23,
  a4_.createdAt AS createdAt_24,
  a4_.updatedAt AS updatedAt_25,
  a4_.locale AS locale_26,
  a5_.id AS id_27,
  a5_.name AS name_28,
  a5_.slug AS slug_29,
  a5_.title AS title_30,
  a5_.description AS description_31,
  a5_.shortDescription AS shortDescription_32,
  a5_.createdAt AS createdAt_33,
  a5_.updatedAt AS updatedAt_34,
  a5_.metadata_title AS metadata_title_35,
  a5_.metadata_description AS metadata_description_36,
  a5_.locale AS locale_37,
  a2_.subType_id AS subType_id_38,
  a2_.mediaType_id AS mediaType_id_39,
  a2_.translatable_id AS translatable_id_40,
  a4_.translatable_id AS translatable_id_41,
  a5_.translatable_id AS translatable_id_42
FROM
  app_families a0_
  LEFT JOIN families_media f6_ ON a0_.id = f6_.families_id
  LEFT JOIN app_media a1_ ON a1_.id = f6_.media_id
  LEFT JOIN app_media_translation a2_ ON a1_.id = a2_.translatable_id
  AND (a2_.locale = ?)
  LEFT JOIN categories_families c7_ ON a0_.id = c7_.families_id
  LEFT JOIN app_categories a3_ ON a3_.id = c7_.categories_id
  LEFT JOIN app_families_translation a4_ ON a0_.id = a4_.translatable_id
  AND (a4_.locale = ?)
  LEFT JOIN app_categories_translation a5_ ON a3_.id = a5_.translatable_id
  AND (a5_.locale = ?)
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.sortOrder AS sortOrder_1, a0_.createdAt AS createdAt_2, a0_.updatedAt AS updatedAt_3, a1_.id AS id_4, a1_.createdAt AS createdAt_5, a1_.updatedAt AS updatedAt_6, a2_.id AS id_7, a2_.description AS description_8, a2_.fileName AS fileName_9, a2_.fileSize AS fileSize_10, a2_.isWeb AS isWeb_11, a2_.isPro AS isPro_12, a2_.isAgora AS isAgora_13, a2_.createdAt AS createdAt_14, a2_.updatedAt AS updatedAt_15, a2_.locale AS locale_16, a3_.id AS id_17, a3_.createdAt AS createdAt_18, a3_.updatedAt AS updatedAt_19, a4_.id AS id_20, a4_.shortDescription AS shortDescription_21, a4_.name AS name_22, a4_.slug AS slug_23, a4_.createdAt AS createdAt_24, a4_.updatedAt AS updatedAt_25, a4_.locale AS locale_26, a5_.id AS id_27, a5_.name AS name_28, a5_.slug AS slug_29, a5_.title AS title_30, a5_.description AS description_31, a5_.shortDescription AS shortDescription_32, a5_.createdAt AS createdAt_33, a5_.updatedAt AS updatedAt_34, a5_.metadata_title AS metadata_title_35, a5_.metadata_description AS metadata_description_36, a5_.locale AS locale_37, a2_.subType_id AS subType_id_38, a2_.mediaType_id AS mediaType_id_39, a2_.translatable_id AS translatable_id_40, a4_.translatable_id AS translatable_id_41, a5_.translatable_id AS translatable_id_42 FROM app_families a0_ LEFT JOIN families_media f6_ ON a0_.id = f6_.families_id LEFT JOIN app_media a1_ ON a1_.id = f6_.media_id LEFT JOIN app_media_translation a2_ ON a1_.id = a2_.translatable_id AND (a2_.locale = 'fr_FR') LEFT JOIN categories_families c7_ ON a0_.id = c7_.families_id LEFT JOIN app_categories a3_ ON a3_.id = c7_.categories_id LEFT JOIN app_families_translation a4_ ON a0_.id = a4_.translatable_id AND (a4_.locale = 'fr_FR') LEFT JOIN app_categories_translation a5_ ON a3_.id = a5_.translatable_id AND (a5_.locale = 'fr_FR') ORDER BY a0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.featured AS featured_4,
  t0.position AS position_5,
  t0.createdAt AS createdAt_6,
  t0.updatedAt AS updatedAt_7
FROM
  app_brands t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.featured AS featured_4, t0.position AS position_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7 FROM app_brands t0 ORDER BY t0.name ASC;

SELECT
  s0_.code AS code_0,
  s0_.name AS name_1,
  s0_.hostname AS hostname_2
FROM
  sylius_channel s0_
ORDER BY
  s0_.id ASC

SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC;

SELECT
  a0_.id AS id_0,
  a0_.sortOrder AS sortOrder_1,
  a0_.createdAt AS createdAt_2,
  a0_.updatedAt AS updatedAt_3
FROM
  app_families a0_
  INNER JOIN categories_families c2_ ON a0_.id = c2_.families_id
  INNER JOIN app_categories a1_ ON a1_.id = c2_.categories_id
  LEFT JOIN app_families_translation a3_ ON a0_.id = a3_.translatable_id
WHERE
  a3_.name <> ''
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.sortOrder AS sortOrder_1, a0_.createdAt AS createdAt_2, a0_.updatedAt AS updatedAt_3 FROM app_families a0_ INNER JOIN categories_families c2_ ON a0_.id = c2_.families_id INNER JOIN app_categories a1_ ON a1_.id = c2_.categories_id LEFT JOIN app_families_translation a3_ ON a0_.id = a3_.translatable_id WHERE a3_.name <> '' ORDER BY a0_.id ASC;