Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.ean AS ean_3,
  p0_.description AS description_4,
  p0_.composition AS composition_5,
  p0_.status AS status_6,
  p0_.product_code AS product_code_7,
  p0_.flags AS flags_8,
  p0_.weight AS weight_9,
  p0_.average_rate_review AS average_rate_review_10,
  p0_.bought AS bought_11,
  p0_.availability_in_days AS availability_in_days_12,
  p0_.availability_mode AS availability_mode_13,
  p0_.available_from_date AS available_from_date_14,
  p0_.availability_delivery_weekdays_mask AS availability_delivery_weekdays_mask_15,
  p0_.can_send AS can_send_16,
  p0_.can_send_ue AS can_send_ue_17,
  p0_.can_send_outside_ue AS can_send_outside_ue_18,
  p0_.energy_kcal AS energy_kcal_19,
  p0_.fat AS fat_20,
  p0_.saturated_fat AS saturated_fat_21,
  p0_.carbohydrates AS carbohydrates_22,
  p0_.sugars AS sugars_23,
  p0_.protein AS protein_24,
  p0_.salt AS salt_25,
  p0_.origin_country_code AS origin_country_code_26,
  p0_.on_promotion AS on_promotion_27,
  p0_.banned AS banned_28,
  p0_.ban_reason AS ban_reason_29,
  p0_.accepted AS accepted_30,
  p0_.created_at AS created_at_31,
  p0_.updated_at AS updated_at_32,
  p0_.supplier_netto_amount AS supplier_netto_amount_33,
  p0_.supplier_netto_currency_code AS supplier_netto_currency_code_34,
  p0_.supplier_brutto_amount AS supplier_brutto_amount_35,
  p0_.supplier_brutto_currency_code AS supplier_brutto_currency_code_36,
  p0_.promo_brutto_amount AS promo_brutto_amount_37,
  p0_.promo_brutto_currency_code AS promo_brutto_currency_code_38,
  p0_.promo_netto_amount AS promo_netto_amount_39,
  p0_.promo_netto_currency_code AS promo_netto_currency_code_40,
  p0_.netto_price_amount AS netto_price_amount_41,
  p0_.netto_price_currency_code AS netto_price_currency_code_42,
  p0_.brutto_price_amount AS brutto_price_amount_43,
  p0_.brutto_price_currency_code AS brutto_price_currency_code_44,
  p0_.category_id AS category_id_45,
  p0_.supplier_id AS supplier_id_46,
  p0_.tax_id AS tax_id_47
FROM
  product p0_
WHERE
  p0_.status = ?
  AND p0_.on_promotion = ?
ORDER BY
  RAND() ASC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.ean AS ean_3, p0_.description AS description_4, p0_.composition AS composition_5, p0_.status AS status_6, p0_.product_code AS product_code_7, p0_.flags AS flags_8, p0_.weight AS weight_9, p0_.average_rate_review AS average_rate_review_10, p0_.bought AS bought_11, p0_.availability_in_days AS availability_in_days_12, p0_.availability_mode AS availability_mode_13, p0_.available_from_date AS available_from_date_14, p0_.availability_delivery_weekdays_mask AS availability_delivery_weekdays_mask_15, p0_.can_send AS can_send_16, p0_.can_send_ue AS can_send_ue_17, p0_.can_send_outside_ue AS can_send_outside_ue_18, p0_.energy_kcal AS energy_kcal_19, p0_.fat AS fat_20, p0_.saturated_fat AS saturated_fat_21, p0_.carbohydrates AS carbohydrates_22, p0_.sugars AS sugars_23, p0_.protein AS protein_24, p0_.salt AS salt_25, p0_.origin_country_code AS origin_country_code_26, p0_.on_promotion AS on_promotion_27, p0_.banned AS banned_28, p0_.ban_reason AS ban_reason_29, p0_.accepted AS accepted_30, p0_.created_at AS created_at_31, p0_.updated_at AS updated_at_32, p0_.supplier_netto_amount AS supplier_netto_amount_33, p0_.supplier_netto_currency_code AS supplier_netto_currency_code_34, p0_.supplier_brutto_amount AS supplier_brutto_amount_35, p0_.supplier_brutto_currency_code AS supplier_brutto_currency_code_36, p0_.promo_brutto_amount AS promo_brutto_amount_37, p0_.promo_brutto_currency_code AS promo_brutto_currency_code_38, p0_.promo_netto_amount AS promo_netto_amount_39, p0_.promo_netto_currency_code AS promo_netto_currency_code_40, p0_.netto_price_amount AS netto_price_amount_41, p0_.netto_price_currency_code AS netto_price_currency_code_42, p0_.brutto_price_amount AS brutto_price_amount_43, p0_.brutto_price_currency_code AS brutto_price_currency_code_44, p0_.category_id AS category_id_45, p0_.supplier_id AS supplier_id_46, p0_.tax_id AS tax_id_47 FROM product p0_ WHERE p0_.status = 'active' AND p0_.on_promotion = 1 ORDER BY RAND() ASC LIMIT 5;

SELECT
  c0_.id AS id_0,
  c0_.position AS position_1,
  c0_.name AS name_2,
  c0_.active AS active_3,
  c0_.slug AS slug_4,
  c0_.promoted AS promoted_5,
  c0_.image_path AS image_path_6,
  c0_.active_product_count AS active_product_count_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.parent_id AS parent_id_10
FROM
  category c0_
WHERE
  c0_.active = 1
ORDER BY
  c0_.promoted DESC,
  c0_.active_product_count DESC
LIMIT
  6

SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.name AS name_2, c0_.active AS active_3, c0_.slug AS slug_4, c0_.promoted AS promoted_5, c0_.image_path AS image_path_6, c0_.active_product_count AS active_product_count_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.parent_id AS parent_id_10 FROM category c0_ WHERE c0_.active = 1 ORDER BY c0_.promoted DESC, c0_.active_product_count DESC LIMIT 6;

SELECT
  c0_.id AS id_0,
  c0_.position AS position_1,
  c0_.name AS name_2,
  c0_.active AS active_3,
  c0_.slug AS slug_4,
  c0_.promoted AS promoted_5,
  c0_.image_path AS image_path_6,
  c0_.active_product_count AS active_product_count_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.parent_id AS parent_id_10
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
  AND c0_.active = 1
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.name AS name_2, c0_.active AS active_3, c0_.slug AS slug_4, c0_.promoted AS promoted_5, c0_.image_path AS image_path_6, c0_.active_product_count AS active_product_count_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.parent_id AS parent_id_10 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.active = 1 ORDER BY c0_.position ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.active AS active_3,
  s0_.terms_suspended AS terms_suspended_4,
  s0_.banned AS banned_5,
  s0_.ban_reason AS ban_reason_6,
  s0_.banned_at AS banned_at_7,
  s0_.average_rate_review AS average_rate_review_8,
  s0_.description AS description_9,
  s0_.storefront_headline AS storefront_headline_10,
  s0_.storefront_intro AS storefront_intro_11,
  s0_.storefront_accent_color AS storefront_accent_color_12,
  s0_.store_subdomain AS store_subdomain_13,
  s0_.store_subdomain_active AS store_subdomain_active_14,
  s0_.logo_name AS logo_name_15,
  s0_.logo_size AS logo_size_16,
  s0_.cover_name AS cover_name_17,
  s0_.cover_size AS cover_size_18,
  s0_.storefront_banner_name AS storefront_banner_name_19,
  s0_.storefront_banner_size AS storefront_banner_size_20,
  s0_.storefront_banner_title AS storefront_banner_title_21,
  s0_.storefront_banner_text AS storefront_banner_text_22,
  s0_.storefront_banner_link_label AS storefront_banner_link_label_23,
  s0_.storefront_banner_link_url AS storefront_banner_link_url_24,
  s0_.default_margin_percent AS default_margin_percent_25,
  s0_.storefront_show_featured_products AS storefront_show_featured_products_26,
  s0_.storefront_show_branches AS storefront_show_branches_27,
  s0_.storefront_show_reviews AS storefront_show_reviews_28,
  s0_.storefront_show_certificates AS storefront_show_certificates_29,
  s0_.storefront_show_blog AS storefront_show_blog_30,
  s0_.flat_rate_farmer AS flat_rate_farmer_31,
  s0_.vat_rr_account_number AS vat_rr_account_number_32,
  s0_.scheduled_default_margin_percent AS scheduled_default_margin_percent_33,
  s0_.scheduled_default_margin_effective_at AS scheduled_default_margin_effective_at_34,
  s0_.scheduled_default_margin_notification_sent_at AS scheduled_default_margin_notification_sent_at_35,
  s0_.created_at AS created_at_36,
  s0_.updated_at AS updated_at_37,
  s0_.profile_id AS profile_id_38,
  s0_.account_manager_id AS account_manager_id_39
FROM
  supplier s0_
WHERE
  s0_.active = 1
  AND s0_.terms_suspended = 0
ORDER BY
  RAND() ASC
LIMIT
  5

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.active AS active_3, s0_.terms_suspended AS terms_suspended_4, s0_.banned AS banned_5, s0_.ban_reason AS ban_reason_6, s0_.banned_at AS banned_at_7, s0_.average_rate_review AS average_rate_review_8, s0_.description AS description_9, s0_.storefront_headline AS storefront_headline_10, s0_.storefront_intro AS storefront_intro_11, s0_.storefront_accent_color AS storefront_accent_color_12, s0_.store_subdomain AS store_subdomain_13, s0_.store_subdomain_active AS store_subdomain_active_14, s0_.logo_name AS logo_name_15, s0_.logo_size AS logo_size_16, s0_.cover_name AS cover_name_17, s0_.cover_size AS cover_size_18, s0_.storefront_banner_name AS storefront_banner_name_19, s0_.storefront_banner_size AS storefront_banner_size_20, s0_.storefront_banner_title AS storefront_banner_title_21, s0_.storefront_banner_text AS storefront_banner_text_22, s0_.storefront_banner_link_label AS storefront_banner_link_label_23, s0_.storefront_banner_link_url AS storefront_banner_link_url_24, s0_.default_margin_percent AS default_margin_percent_25, s0_.storefront_show_featured_products AS storefront_show_featured_products_26, s0_.storefront_show_branches AS storefront_show_branches_27, s0_.storefront_show_reviews AS storefront_show_reviews_28, s0_.storefront_show_certificates AS storefront_show_certificates_29, s0_.storefront_show_blog AS storefront_show_blog_30, s0_.flat_rate_farmer AS flat_rate_farmer_31, s0_.vat_rr_account_number AS vat_rr_account_number_32, s0_.scheduled_default_margin_percent AS scheduled_default_margin_percent_33, s0_.scheduled_default_margin_effective_at AS scheduled_default_margin_effective_at_34, s0_.scheduled_default_margin_notification_sent_at AS scheduled_default_margin_notification_sent_at_35, s0_.created_at AS created_at_36, s0_.updated_at AS updated_at_37, s0_.profile_id AS profile_id_38, s0_.account_manager_id AS account_manager_id_39 FROM supplier s0_ WHERE s0_.active = 1 AND s0_.terms_suspended = 0 ORDER BY RAND() ASC LIMIT 5;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.content AS content_2,
  b0_.meta_keywords AS meta_keywords_3,
  b0_.meta_description AS meta_description_4,
  b0_.image_path AS image_path_5,
  b0_.slug AS slug_6,
  b0_.published AS published_7,
  b0_.published_at AS published_at_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.supplier_id AS supplier_id_11
FROM
  blog_post b0_
ORDER BY
  b0_.created_at DESC
LIMIT
  5

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.content AS content_2, b0_.meta_keywords AS meta_keywords_3, b0_.meta_description AS meta_description_4, b0_.image_path AS image_path_5, b0_.slug AS slug_6, b0_.published AS published_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.supplier_id AS supplier_id_11 FROM blog_post b0_ ORDER BY b0_.created_at DESC LIMIT 5;

SELECT
  b0_.id AS id_0,
  b0_.file_name AS file_name_1,
  b0_.file_size AS file_size_2,
  b0_.active AS active_3,
  b0_.name AS name_4,
  b0_.type AS type_5,
  b0_.sub_name AS sub_name_6,
  b0_.description AS description_7,
  b0_.button_label AS button_label_8,
  b0_.link_url AS link_url_9,
  b0_.image_url AS image_url_10,
  b0_.starts_at AS starts_at_11,
  b0_.expires_at AS expires_at_12,
  b0_.sort_order AS sort_order_13,
  b0_.created_at AS created_at_14,
  b0_.updated_at AS updated_at_15
FROM
  banner b0_
WHERE
  b0_.type = ?
  AND b0_.active = 1
  AND (
    (
      b0_.starts_at IS NULL
      OR b0_.starts_at <= ?
    )
  )
  AND (
    (
      b0_.expires_at IS NULL
      OR b0_.expires_at >= ?
    )
  )
ORDER BY
  b0_.sort_order ASC,
  b0_.created_at DESC

SELECT b0_.id AS id_0, b0_.file_name AS file_name_1, b0_.file_size AS file_size_2, b0_.active AS active_3, b0_.name AS name_4, b0_.type AS type_5, b0_.sub_name AS sub_name_6, b0_.description AS description_7, b0_.button_label AS button_label_8, b0_.link_url AS link_url_9, b0_.image_url AS image_url_10, b0_.starts_at AS starts_at_11, b0_.expires_at AS expires_at_12, b0_.sort_order AS sort_order_13, b0_.created_at AS created_at_14, b0_.updated_at AS updated_at_15 FROM banner b0_ WHERE b0_.type = 'main_page_top' AND b0_.active = 1 AND ((b0_.starts_at IS NULL OR b0_.starts_at <= '2026-10-19 14:34:40')) AND ((b0_.expires_at IS NULL OR b0_.expires_at >= '2026-10-19 14:34:40')) ORDER BY b0_.sort_order ASC, b0_.created_at DESC;

SELECT
  b0_.id AS id_0,
  b0_.file_name AS file_name_1,
  b0_.file_size AS file_size_2,
  b0_.active AS active_3,
  b0_.name AS name_4,
  b0_.type AS type_5,
  b0_.sub_name AS sub_name_6,
  b0_.description AS description_7,
  b0_.button_label AS button_label_8,
  b0_.link_url AS link_url_9,
  b0_.image_url AS image_url_10,
  b0_.starts_at AS starts_at_11,
  b0_.expires_at AS expires_at_12,
  b0_.sort_order AS sort_order_13,
  b0_.created_at AS created_at_14,
  b0_.updated_at AS updated_at_15
FROM
  banner b0_
WHERE
  b0_.type = ?
  AND b0_.active = 1
  AND (
    (
      b0_.starts_at IS NULL
      OR b0_.starts_at <= ?
    )
  )
  AND (
    (
      b0_.expires_at IS NULL
      OR b0_.expires_at >= ?
    )
  )
ORDER BY
  b0_.sort_order ASC,
  b0_.created_at DESC

SELECT b0_.id AS id_0, b0_.file_name AS file_name_1, b0_.file_size AS file_size_2, b0_.active AS active_3, b0_.name AS name_4, b0_.type AS type_5, b0_.sub_name AS sub_name_6, b0_.description AS description_7, b0_.button_label AS button_label_8, b0_.link_url AS link_url_9, b0_.image_url AS image_url_10, b0_.starts_at AS starts_at_11, b0_.expires_at AS expires_at_12, b0_.sort_order AS sort_order_13, b0_.created_at AS created_at_14, b0_.updated_at AS updated_at_15 FROM banner b0_ WHERE b0_.type = 'main_page_promo' AND b0_.active = 1 AND ((b0_.starts_at IS NULL OR b0_.starts_at <= '2026-10-19 14:34:40')) AND ((b0_.expires_at IS NULL OR b0_.expires_at >= '2026-10-19 14:34:40')) ORDER BY b0_.sort_order ASC, b0_.created_at DESC;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.target_url AS target_url_2,
  s0_.notes AS notes_3,
  s0_.status AS status_4,
  s0_.ordered_units AS ordered_units_5,
  s0_.starts_at AS starts_at_6,
  s0_.ends_at AS ends_at_7,
  s0_.impressions_limit AS impressions_limit_8,
  s0_.impressions_count AS impressions_count_9,
  s0_.clicks_count AS clicks_count_10,
  s0_.admin_notes AS admin_notes_11,
  s0_.created_at AS created_at_12,
  s0_.updated_at AS updated_at_13,
  s0_.quoted_price_amount AS quoted_price_amount_14,
  s0_.quoted_price_currency_code AS quoted_price_currency_code_15,
  s0_.agreed_unit_price_amount AS agreed_unit_price_amount_16,
  s0_.agreed_unit_price_currency_code AS agreed_unit_price_currency_code_17,
  s1_.id AS id_18,
  s1_.name AS name_19,
  s1_.slug AS slug_20,
  s1_.active AS active_21,
  s1_.terms_suspended AS terms_suspended_22,
  s1_.banned AS banned_23,
  s1_.ban_reason AS ban_reason_24,
  s1_.banned_at AS banned_at_25,
  s1_.average_rate_review AS average_rate_review_26,
  s1_.description AS description_27,
  s1_.storefront_headline AS storefront_headline_28,
  s1_.storefront_intro AS storefront_intro_29,
  s1_.storefront_accent_color AS storefront_accent_color_30,
  s1_.store_subdomain AS store_subdomain_31,
  s1_.store_subdomain_active AS store_subdomain_active_32,
  s1_.logo_name AS logo_name_33,
  s1_.logo_size AS logo_size_34,
  s1_.cover_name AS cover_name_35,
  s1_.cover_size AS cover_size_36,
  s1_.storefront_banner_name AS storefront_banner_name_37,
  s1_.storefront_banner_size AS storefront_banner_size_38,
  s1_.storefront_banner_title AS storefront_banner_title_39,
  s1_.storefront_banner_text AS storefront_banner_text_40,
  s1_.storefront_banner_link_label AS storefront_banner_link_label_41,
  s1_.storefront_banner_link_url AS storefront_banner_link_url_42,
  s1_.default_margin_percent AS default_margin_percent_43,
  s1_.storefront_show_featured_products AS storefront_show_featured_products_44,
  s1_.storefront_show_branches AS storefront_show_branches_45,
  s1_.storefront_show_reviews AS storefront_show_reviews_46,
  s1_.storefront_show_certificates AS storefront_show_certificates_47,
  s1_.storefront_show_blog AS storefront_show_blog_48,
  s1_.flat_rate_farmer AS flat_rate_farmer_49,
  s1_.vat_rr_account_number AS vat_rr_account_number_50,
  s1_.scheduled_default_margin_percent AS scheduled_default_margin_percent_51,
  s1_.scheduled_default_margin_effective_at AS scheduled_default_margin_effective_at_52,
  s1_.scheduled_default_margin_notification_sent_at AS scheduled_default_margin_notification_sent_at_53,
  s1_.created_at AS created_at_54,
  s1_.updated_at AS updated_at_55,
  a2_.id AS id_56,
  a2_.name AS name_57,
  a2_.code AS code_58,
  a2_.type AS type_59,
  a2_.billing_model AS billing_model_60,
  a2_.description AS description_61,
  a2_.asset_guidelines AS asset_guidelines_62,
  a2_.active AS active_63,
  a2_.sort_order AS sort_order_64,
  a2_.minimum_units AS minimum_units_65,
  a2_.default_units AS default_units_66,
  a2_.created_at AS created_at_67,
  a2_.updated_at AS updated_at_68,
  a2_.unit_price_amount AS unit_price_amount_69,
  a2_.unit_price_currency_code AS unit_price_currency_code_70,
  p3_.id AS id_71,
  p3_.name AS name_72,
  p3_.slug AS slug_73,
  p3_.ean AS ean_74,
  p3_.description AS description_75,
  p3_.composition AS composition_76,
  p3_.status AS status_77,
  p3_.product_code AS product_code_78,
  p3_.flags AS flags_79,
  p3_.weight AS weight_80,
  p3_.average_rate_review AS average_rate_review_81,
  p3_.bought AS bought_82,
  p3_.availability_in_days AS availability_in_days_83,
  p3_.availability_mode AS availability_mode_84,
  p3_.available_from_date AS available_from_date_85,
  p3_.availability_delivery_weekdays_mask AS availability_delivery_weekdays_mask_86,
  p3_.can_send AS can_send_87,
  p3_.can_send_ue AS can_send_ue_88,
  p3_.can_send_outside_ue AS can_send_outside_ue_89,
  p3_.energy_kcal AS energy_kcal_90,
  p3_.fat AS fat_91,
  p3_.saturated_fat AS saturated_fat_92,
  p3_.carbohydrates AS carbohydrates_93,
  p3_.sugars AS sugars_94,
  p3_.protein AS protein_95,
  p3_.salt AS salt_96,
  p3_.origin_country_code AS origin_country_code_97,
  p3_.on_promotion AS on_promotion_98,
  p3_.banned AS banned_99,
  p3_.ban_reason AS ban_reason_100,
  p3_.accepted AS accepted_101,
  p3_.created_at AS created_at_102,
  p3_.updated_at AS updated_at_103,
  p3_.supplier_netto_amount AS supplier_netto_amount_104,
  p3_.supplier_netto_currency_code AS supplier_netto_currency_code_105,
  p3_.supplier_brutto_amount AS supplier_brutto_amount_106,
  p3_.supplier_brutto_currency_code AS supplier_brutto_currency_code_107,
  p3_.promo_brutto_amount AS promo_brutto_amount_108,
  p3_.promo_brutto_currency_code AS promo_brutto_currency_code_109,
  p3_.promo_netto_amount AS promo_netto_amount_110,
  p3_.promo_netto_currency_code AS promo_netto_currency_code_111,
  p3_.netto_price_amount AS netto_price_amount_112,
  p3_.netto_price_currency_code AS netto_price_currency_code_113,
  p3_.brutto_price_amount AS brutto_price_amount_114,
  p3_.brutto_price_currency_code AS brutto_price_currency_code_115,
  c4_.id AS id_116,
  c4_.position AS position_117,
  c4_.name AS name_118,
  c4_.active AS active_119,
  c4_.slug AS slug_120,
  c4_.promoted AS promoted_121,
  c4_.image_path AS image_path_122,
  c4_.active_product_count AS active_product_count_123,
  c4_.created_at AS created_at_124,
  c4_.updated_at AS updated_at_125,
  s0_.supplier_id AS supplier_id_126,
  s0_.placement_id AS placement_id_127,
  s0_.requested_by_id AS requested_by_id_128,
  s0_.target_product_id AS target_product_id_129,
  s0_.target_category_id AS target_category_id_130,
  s1_.profile_id AS profile_id_131,
  s1_.account_manager_id AS account_manager_id_132,
  p3_.category_id AS category_id_133,
  p3_.supplier_id AS supplier_id_134,
  p3_.tax_id AS tax_id_135,
  c4_.parent_id AS parent_id_136
FROM
  supplier_advertising_campaign s0_
  LEFT JOIN supplier s1_ ON s0_.supplier_id = s1_.id
  LEFT JOIN advertising_placement a2_ ON s0_.placement_id = a2_.id
  LEFT JOIN product p3_ ON s0_.target_product_id = p3_.id
  LEFT JOIN category c4_ ON s0_.target_category_id = c4_.id
WHERE
  s0_.status = ?
  AND (
    (
      s0_.starts_at IS NULL
      OR s0_.starts_at <= ?
    )
  )
  AND (
    (
      s0_.ends_at IS NULL
      OR s0_.ends_at >= ?
    )
  )
  AND a2_.type = ?
ORDER BY
  s0_.created_at DESC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.target_url AS target_url_2, s0_.notes AS notes_3, s0_.status AS status_4, s0_.ordered_units AS ordered_units_5, s0_.starts_at AS starts_at_6, s0_.ends_at AS ends_at_7, s0_.impressions_limit AS impressions_limit_8, s0_.impressions_count AS impressions_count_9, s0_.clicks_count AS clicks_count_10, s0_.admin_notes AS admin_notes_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13, s0_.quoted_price_amount AS quoted_price_amount_14, s0_.quoted_price_currency_code AS quoted_price_currency_code_15, s0_.agreed_unit_price_amount AS agreed_unit_price_amount_16, s0_.agreed_unit_price_currency_code AS agreed_unit_price_currency_code_17, s1_.id AS id_18, s1_.name AS name_19, s1_.slug AS slug_20, s1_.active AS active_21, s1_.terms_suspended AS terms_suspended_22, s1_.banned AS banned_23, s1_.ban_reason AS ban_reason_24, s1_.banned_at AS banned_at_25, s1_.average_rate_review AS average_rate_review_26, s1_.description AS description_27, s1_.storefront_headline AS storefront_headline_28, s1_.storefront_intro AS storefront_intro_29, s1_.storefront_accent_color AS storefront_accent_color_30, s1_.store_subdomain AS store_subdomain_31, s1_.store_subdomain_active AS store_subdomain_active_32, s1_.logo_name AS logo_name_33, s1_.logo_size AS logo_size_34, s1_.cover_name AS cover_name_35, s1_.cover_size AS cover_size_36, s1_.storefront_banner_name AS storefront_banner_name_37, s1_.storefront_banner_size AS storefront_banner_size_38, s1_.storefront_banner_title AS storefront_banner_title_39, s1_.storefront_banner_text AS storefront_banner_text_40, s1_.storefront_banner_link_label AS storefront_banner_link_label_41, s1_.storefront_banner_link_url AS storefront_banner_link_url_42, s1_.default_margin_percent AS default_margin_percent_43, s1_.storefront_show_featured_products AS storefront_show_featured_products_44, s1_.storefront_show_branches AS storefront_show_branches_45, s1_.storefront_show_reviews AS storefront_show_reviews_46, s1_.storefront_show_certificates AS storefront_show_certificates_47, s1_.storefront_show_blog AS storefront_show_blog_48, s1_.flat_rate_farmer AS flat_rate_farmer_49, s1_.vat_rr_account_number AS vat_rr_account_number_50, s1_.scheduled_default_margin_percent AS scheduled_default_margin_percent_51, s1_.scheduled_default_margin_effective_at AS scheduled_default_margin_effective_at_52, s1_.scheduled_default_margin_notification_sent_at AS scheduled_default_margin_notification_sent_at_53, s1_.created_at AS created_at_54, s1_.updated_at AS updated_at_55, a2_.id AS id_56, a2_.name AS name_57, a2_.code AS code_58, a2_.type AS type_59, a2_.billing_model AS billing_model_60, a2_.description AS description_61, a2_.asset_guidelines AS asset_guidelines_62, a2_.active AS active_63, a2_.sort_order AS sort_order_64, a2_.minimum_units AS minimum_units_65, a2_.default_units AS default_units_66, a2_.created_at AS created_at_67, a2_.updated_at AS updated_at_68, a2_.unit_price_amount AS unit_price_amount_69, a2_.unit_price_currency_code AS unit_price_currency_code_70, p3_.id AS id_71, p3_.name AS name_72, p3_.slug AS slug_73, p3_.ean AS ean_74, p3_.description AS description_75, p3_.composition AS composition_76, p3_.status AS status_77, p3_.product_code AS product_code_78, p3_.flags AS flags_79, p3_.weight AS weight_80, p3_.average_rate_review AS average_rate_review_81, p3_.bought AS bought_82, p3_.availability_in_days AS availability_in_days_83, p3_.availability_mode AS availability_mode_84, p3_.available_from_date AS available_from_date_85, p3_.availability_delivery_weekdays_mask AS availability_delivery_weekdays_mask_86, p3_.can_send AS can_send_87, p3_.can_send_ue AS can_send_ue_88, p3_.can_send_outside_ue AS can_send_outside_ue_89, p3_.energy_kcal AS energy_kcal_90, p3_.fat AS fat_91, p3_.saturated_fat AS saturated_fat_92, p3_.carbohydrates AS carbohydrates_93, p3_.sugars AS sugars_94, p3_.protein AS protein_95, p3_.salt AS salt_96, p3_.origin_country_code AS origin_country_code_97, p3_.on_promotion AS on_promotion_98, p3_.banned AS banned_99, p3_.ban_reason AS ban_reason_100, p3_.accepted AS accepted_101, p3_.created_at AS created_at_102, p3_.updated_at AS updated_at_103, p3_.supplier_netto_amount AS supplier_netto_amount_104, p3_.supplier_netto_currency_code AS supplier_netto_currency_code_105, p3_.supplier_brutto_amount AS supplier_brutto_amount_106, p3_.supplier_brutto_currency_code AS supplier_brutto_currency_code_107, p3_.promo_brutto_amount AS promo_brutto_amount_108, p3_.promo_brutto_currency_code AS promo_brutto_currency_code_109, p3_.promo_netto_amount AS promo_netto_amount_110, p3_.promo_netto_currency_code AS promo_netto_currency_code_111, p3_.netto_price_amount AS netto_price_amount_112, p3_.netto_price_currency_code AS netto_price_currency_code_113, p3_.brutto_price_amount AS brutto_price_amount_114, p3_.brutto_price_currency_code AS brutto_price_currency_code_115, c4_.id AS id_116, c4_.position AS position_117, c4_.name AS name_118, c4_.active AS active_119, c4_.slug AS slug_120, c4_.promoted AS promoted_121, c4_.image_path AS image_path_122, c4_.active_product_count AS active_product_count_123, c4_.created_at AS created_at_124, c4_.updated_at AS updated_at_125, s0_.supplier_id AS supplier_id_126, s0_.placement_id AS placement_id_127, s0_.requested_by_id AS requested_by_id_128, s0_.target_product_id AS target_product_id_129, s0_.target_category_id AS target_category_id_130, s1_.profile_id AS profile_id_131, s1_.account_manager_id AS account_manager_id_132, p3_.category_id AS category_id_133, p3_.supplier_id AS supplier_id_134, p3_.tax_id AS tax_id_135, c4_.parent_id AS parent_id_136 FROM supplier_advertising_campaign s0_ LEFT JOIN supplier s1_ ON s0_.supplier_id = s1_.id LEFT JOIN advertising_placement a2_ ON s0_.placement_id = a2_.id LEFT JOIN product p3_ ON s0_.target_product_id = p3_.id LEFT JOIN category c4_ ON s0_.target_category_id = c4_.id WHERE s0_.status = 'active' AND ((s0_.starts_at IS NULL OR s0_.starts_at <= '2026-10-19 14:34:40')) AND ((s0_.ends_at IS NULL OR s0_.ends_at >= '2026-10-19 14:34:40')) AND a2_.type = 'homepage_hero_banner' ORDER BY s0_.created_at DESC;