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 = '/klarstein/cave-a-vin/10041899' 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 = 'klarstein' LIMIT 1;

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_.createdAt AS createdAt_11,
  a1_.updatedAt AS updatedAt_12,
  a2_.id AS id_13,
  a2_.name AS name_14,
  a2_.slug AS slug_15,
  a2_.title AS title_16,
  a2_.description AS description_17,
  a2_.shortDescription AS shortDescription_18,
  a2_.createdAt AS createdAt_19,
  a2_.updatedAt AS updatedAt_20,
  a2_.metadata_title AS metadata_title_21,
  a2_.metadata_description AS metadata_description_22,
  a2_.locale AS locale_23,
  a0_.brand_id AS brand_id_24,
  a0_.category_id AS category_id_25,
  a0_.factory_id AS factory_id_26,
  a0_.warrantyStatus_id AS warrantyStatus_id_27,
  a2_.translatable_id AS translatable_id_28
FROM
  app_products_finished a0_
  LEFT JOIN app_products_finished_translation a3_ ON a0_.id = a3_.translatable_id
  AND (a3_.locale = ?)
  LEFT JOIN app_categories a1_ ON a0_.category_id = a1_.id
  LEFT JOIN app_categories_translation a2_ ON a1_.id = a2_.translatable_id
  AND (a2_.locale = ?)
  LEFT JOIN app_brands a4_ ON a0_.brand_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_.createdAt AS createdAt_11, a1_.updatedAt AS updatedAt_12, a2_.id AS id_13, a2_.name AS name_14, a2_.slug AS slug_15, a2_.title AS title_16, a2_.description AS description_17, a2_.shortDescription AS shortDescription_18, a2_.createdAt AS createdAt_19, a2_.updatedAt AS updatedAt_20, a2_.metadata_title AS metadata_title_21, a2_.metadata_description AS metadata_description_22, a2_.locale AS locale_23, a0_.brand_id AS brand_id_24, a0_.category_id AS category_id_25, a0_.factory_id AS factory_id_26, a0_.warrantyStatus_id AS warrantyStatus_id_27, a2_.translatable_id AS translatable_id_28 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_categories a1_ ON a0_.category_id = a1_.id LEFT JOIN app_categories_translation a2_ ON a1_.id = a2_.translatable_id AND (a2_.locale = 'fr_FR') LEFT JOIN app_brands a4_ ON a0_.brand_id = a4_.id WHERE a4_.id = 659 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
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.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 = '10041899' 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 = '10041899' 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_.createdAt AS createdAt_11,
  a1_.updatedAt AS updatedAt_12,
  a2_.id AS id_13,
  a2_.description AS description_14,
  a2_.fileName AS fileName_15,
  a2_.fileSize AS fileSize_16,
  a2_.isWeb AS isWeb_17,
  a2_.isPro AS isPro_18,
  a2_.isAgora AS isAgora_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_.subType_id AS subType_id_27,
  a2_.mediaType_id AS mediaType_id_28,
  a2_.translatable_id AS translatable_id_29
FROM
  app_products_finished a0_
  LEFT JOIN productfinished_media p3_ ON a0_.id = p3_.productfinished_id
  LEFT JOIN app_media a1_ ON a1_.id = p3_.media_id
  LEFT JOIN app_media_translation a2_ ON a1_.id = a2_.translatable_id
  AND (a2_.locale = ?)
WHERE
  a0_.slug = ?
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_.createdAt AS createdAt_11, a1_.updatedAt AS updatedAt_12, a2_.id AS id_13, a2_.description AS description_14, a2_.fileName AS fileName_15, a2_.fileSize AS fileSize_16, a2_.isWeb AS isWeb_17, a2_.isPro AS isPro_18, a2_.isAgora AS isAgora_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_.subType_id AS subType_id_27, a2_.mediaType_id AS mediaType_id_28, a2_.translatable_id AS translatable_id_29 FROM app_products_finished a0_ LEFT JOIN productfinished_media p3_ ON a0_.id = p3_.productfinished_id LEFT JOIN app_media a1_ ON a1_.id = p3_.media_id LEFT JOIN app_media_translation a2_ ON a1_.id = a2_.translatable_id AND (a2_.locale = 'fr_FR') WHERE a0_.slug = '10041899' 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;