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

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.featured AS featured_3,
  a0_.position AS position_4,
  a0_.createdAt AS createdAt_5,
  a0_.updatedAt AS updatedAt_6
FROM
  app_brands a0_
  INNER JOIN app_products_finished a1_ ON (a0_.id = a1_.brand_id)
WHERE
  a0_.featured IS NOT NULL
  AND a0_.featured = 1
ORDER BY
  a0_.position ASC,
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.featured AS featured_3, a0_.position AS position_4, a0_.createdAt AS createdAt_5, a0_.updatedAt AS updatedAt_6 FROM app_brands a0_ INNER JOIN app_products_finished a1_ ON (a0_.id = a1_.brand_id) WHERE a0_.featured IS NOT NULL AND a0_.featured = 1 ORDER BY a0_.position ASC, a0_.id ASC;

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 = ?
ORDER BY
  t0.publishedAt DESC
LIMIT
  4

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 ORDER BY t0.publishedAt DESC LIMIT 4;

SELECT
  d0_.id AS id_0,
  d0_.enabled AS enabled_1,
  d0_.publishedAt AS publishedAt_2,
  d0_.category_id AS category_id_3
FROM
  dimpulse_blog_post d0_
  LEFT JOIN dimpulse_blog_post_category d1_ ON d0_.category_id = d1_.id
  INNER JOIN dimpulse_blog_post_category_translation d2_ ON d1_.id = d2_.translatable_id
  INNER JOIN post_channel p4_ ON d0_.id = p4_.post_id
  INNER JOIN sylius_channel s3_ ON s3_.id = p4_.channel_id
  AND (s3_.id = 6)
WHERE
  d0_.enabled = ?
  AND d0_.publishedAt <= ?
  AND d2_.slug = ?
ORDER BY
  d0_.publishedAt DESC,
  d0_.id ASC

SELECT d0_.id AS id_0, d0_.enabled AS enabled_1, d0_.publishedAt AS publishedAt_2, d0_.category_id AS category_id_3 FROM dimpulse_blog_post d0_ LEFT JOIN dimpulse_blog_post_category d1_ ON d0_.category_id = d1_.id INNER JOIN dimpulse_blog_post_category_translation d2_ ON d1_.id = d2_.translatable_id INNER JOIN post_channel p4_ ON d0_.id = p4_.post_id INNER JOIN sylius_channel s3_ ON s3_.id = p4_.channel_id AND (s3_.id = 6) WHERE d0_.enabled = 1 AND d0_.publishedAt <= '2025-12-19 12:04:02' AND d2_.slug = 'guides' ORDER BY d0_.publishedAt DESC, d0_.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.enabled = ?

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

SELECT
  a0_.id AS id_0,
  a0_.createdAt AS createdAt_1,
  a0_.updatedAt AS updatedAt_2
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_.createdAt AS createdAt_1, a0_.updatedAt AS updatedAt_2 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
  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_.createdAt AS createdAt_1,
  a0_.updatedAt AS updatedAt_2,
  a1_.id AS id_3,
  a1_.createdAt AS createdAt_4,
  a1_.updatedAt AS updatedAt_5,
  a2_.id AS id_6,
  a2_.description AS description_7,
  a2_.fileName AS fileName_8,
  a2_.fileSize AS fileSize_9,
  a2_.isWeb AS isWeb_10,
  a2_.isPro AS isPro_11,
  a2_.isAgora AS isAgora_12,
  a2_.createdAt AS createdAt_13,
  a2_.updatedAt AS updatedAt_14,
  a2_.locale AS locale_15,
  a3_.id AS id_16,
  a3_.createdAt AS createdAt_17,
  a3_.updatedAt AS updatedAt_18,
  a4_.id AS id_19,
  a4_.shortDescription AS shortDescription_20,
  a4_.name AS name_21,
  a4_.slug AS slug_22,
  a4_.createdAt AS createdAt_23,
  a4_.updatedAt AS updatedAt_24,
  a4_.locale AS locale_25,
  a5_.id AS id_26,
  a5_.name AS name_27,
  a5_.slug AS slug_28,
  a5_.title AS title_29,
  a5_.description AS description_30,
  a5_.shortDescription AS shortDescription_31,
  a5_.createdAt AS createdAt_32,
  a5_.updatedAt AS updatedAt_33,
  a5_.metadata_title AS metadata_title_34,
  a5_.metadata_description AS metadata_description_35,
  a5_.locale AS locale_36,
  a2_.subType_id AS subType_id_37,
  a2_.mediaType_id AS mediaType_id_38,
  a2_.translatable_id AS translatable_id_39,
  a4_.translatable_id AS translatable_id_40,
  a5_.translatable_id AS translatable_id_41
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_.createdAt AS createdAt_1, a0_.updatedAt AS updatedAt_2, a1_.id AS id_3, a1_.createdAt AS createdAt_4, a1_.updatedAt AS updatedAt_5, a2_.id AS id_6, a2_.description AS description_7, a2_.fileName AS fileName_8, a2_.fileSize AS fileSize_9, a2_.isWeb AS isWeb_10, a2_.isPro AS isPro_11, a2_.isAgora AS isAgora_12, a2_.createdAt AS createdAt_13, a2_.updatedAt AS updatedAt_14, a2_.locale AS locale_15, a3_.id AS id_16, a3_.createdAt AS createdAt_17, a3_.updatedAt AS updatedAt_18, a4_.id AS id_19, a4_.shortDescription AS shortDescription_20, a4_.name AS name_21, a4_.slug AS slug_22, a4_.createdAt AS createdAt_23, a4_.updatedAt AS updatedAt_24, a4_.locale AS locale_25, a5_.id AS id_26, a5_.name AS name_27, a5_.slug AS slug_28, a5_.title AS title_29, a5_.description AS description_30, a5_.shortDescription AS shortDescription_31, a5_.createdAt AS createdAt_32, a5_.updatedAt AS updatedAt_33, a5_.metadata_title AS metadata_title_34, a5_.metadata_description AS metadata_description_35, a5_.locale AS locale_36, a2_.subType_id AS subType_id_37, a2_.mediaType_id AS mediaType_id_38, a2_.translatable_id AS translatable_id_39, a4_.translatable_id AS translatable_id_40, a5_.translatable_id AS translatable_id_41 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_.createdAt AS createdAt_1,
  a0_.updatedAt AS updatedAt_2
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_.createdAt AS createdAt_1, a0_.updatedAt AS updatedAt_2 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
  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_.name AS name_0,
  a1_.name AS name_1,
  a2_.reference AS reference_2
FROM
  app_products_finished a2_
  INNER JOIN app_brands a0_ ON a2_.brand_id = a0_.id
  INNER JOIN app_categories a3_ ON a2_.category_id = a3_.id
  INNER JOIN app_categories_translation a1_ ON a3_.id = a1_.translatable_id
  AND (a1_.locale = ?)
ORDER BY
  a0_.name ASC,
  a2_.id ASC

SELECT a0_.name AS name_0, a1_.name AS name_1, a2_.reference AS reference_2 FROM app_products_finished a2_ INNER JOIN app_brands a0_ ON a2_.brand_id = a0_.id INNER JOIN app_categories a3_ ON a2_.category_id = a3_.id INNER JOIN app_categories_translation a1_ ON a3_.id = a1_.translatable_id AND (a1_.locale = 'fr_FR') ORDER BY a0_.name ASC, a2_.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 s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC;