Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.slug AS slug_5,
  t0.promoted AS promoted_6,
  t0.image_path AS image_path_7,
  t0.active_product_count AS active_product_count_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.parent_id AS parent_id_11
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.active AS active_4, t0.slug AS slug_5, t0.promoted AS promoted_6, t0.image_path AS image_path_7, t0.active_product_count AS active_product_count_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.slug = 'mieso' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.slug AS slug_5,
  t0.promoted AS promoted_6,
  t0.image_path AS image_path_7,
  t0.active_product_count AS active_product_count_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.parent_id AS parent_id_11
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.active AS active_4, t0.slug AS slug_5, t0.promoted AS promoted_6, t0.image_path AS image_path_7, t0.active_product_count AS active_product_count_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.parent_id = 'fcb1940c-593b-474a-9e01-10eaf26301bf' ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.slug AS slug_5,
  t0.promoted AS promoted_6,
  t0.image_path AS image_path_7,
  t0.active_product_count AS active_product_count_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.parent_id AS parent_id_11
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.active AS active_4, t0.slug AS slug_5, t0.promoted AS promoted_6, t0.image_path AS image_path_7, t0.active_product_count AS active_product_count_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.parent_id = '36a776b3-8bc1-41ee-b6e0-99cb876d8312' ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.slug AS slug_5,
  t0.promoted AS promoted_6,
  t0.image_path AS image_path_7,
  t0.active_product_count AS active_product_count_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.parent_id AS parent_id_11
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.active AS active_4, t0.slug AS slug_5, t0.promoted AS promoted_6, t0.image_path AS image_path_7, t0.active_product_count AS active_product_count_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.parent_id = '40f20237-a783-472b-b266-7eced6c4074c' ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.slug AS slug_5,
  t0.promoted AS promoted_6,
  t0.image_path AS image_path_7,
  t0.active_product_count AS active_product_count_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.parent_id AS parent_id_11
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.active AS active_4, t0.slug AS slug_5, t0.promoted AS promoted_6, t0.image_path AS image_path_7, t0.active_product_count AS active_product_count_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.parent_id = '4fb97197-7534-4269-8bc5-d5abd84aad26' ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.slug AS slug_5,
  t0.promoted AS promoted_6,
  t0.image_path AS image_path_7,
  t0.active_product_count AS active_product_count_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.parent_id AS parent_id_11
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.active AS active_4, t0.slug AS slug_5, t0.promoted AS promoted_6, t0.image_path AS image_path_7, t0.active_product_count AS active_product_count_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.parent_id = 'cc847fd1-0ea5-4d01-98a3-2a9b6bdbc5b7' ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.slug AS slug_5,
  t0.promoted AS promoted_6,
  t0.image_path AS image_path_7,
  t0.active_product_count AS active_product_count_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.parent_id AS parent_id_11
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.active AS active_4, t0.slug AS slug_5, t0.promoted AS promoted_6, t0.image_path AS image_path_7, t0.active_product_count AS active_product_count_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.parent_id = 'ff423c26-7d67-4ac9-bef0-6af9e3118b7c' ORDER BY t0.position ASC;

SELECT
  MIN(
    (
      CASE WHEN p0_.promo_brutto_amount > 0 THEN
        p0_.promo_brutto_amount
      ELSE
        p0_.brutto_price_amount
      END
    ) + 0
  ) AS sclr_0,
  MAX(
    (
      CASE WHEN p0_.promo_brutto_amount > 0 THEN
        p0_.promo_brutto_amount
      ELSE
        p0_.brutto_price_amount
      END
    ) + 0
  ) AS sclr_1,
  p0_.brutto_price_currency_code AS brutto_price_currency_code_2
FROM
  product p0_
  INNER JOIN supplier s1_ ON p0_.supplier_id = s1_.id
  INNER JOIN tax t2_ ON p0_.tax_id = t2_.id
WHERE
  p0_.status = ?
  AND s1_.active = 1
  AND s1_.terms_suspended = 0
  AND p0_.banned = 0
  AND p0_.accepted = 1
  AND p0_.category_id IN (?, ?, ?, ?, ?, ?)

SELECT MIN((CASE WHEN p0_.promo_brutto_amount > 0 THEN p0_.promo_brutto_amount ELSE p0_.brutto_price_amount END) + 0) AS sclr_0, MAX((CASE WHEN p0_.promo_brutto_amount > 0 THEN p0_.promo_brutto_amount ELSE p0_.brutto_price_amount END) + 0) AS sclr_1, p0_.brutto_price_currency_code AS brutto_price_currency_code_2 FROM product p0_ INNER JOIN supplier s1_ ON p0_.supplier_id = s1_.id INNER JOIN tax t2_ ON p0_.tax_id = t2_.id WHERE p0_.status = 'active' AND s1_.active = 1 AND s1_.terms_suspended = 0 AND p0_.banned = 0 AND p0_.accepted = 1 AND p0_.category_id IN ('fcb1940c-593b-474a-9e01-10eaf26301bf', '36a776b3-8bc1-41ee-b6e0-99cb876d8312', '40f20237-a783-472b-b266-7eced6c4074c', '4fb97197-7534-4269-8bc5-d5abd84aad26', 'cc847fd1-0ea5-4d01-98a3-2a9b6bdbc5b7', 'ff423c26-7d67-4ac9-bef0-6af9e3118b7c');

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  INNER JOIN supplier s1_ ON p0_.supplier_id = s1_.id
  INNER JOIN tax t2_ ON p0_.tax_id = t2_.id
WHERE
  p0_.status = ?
  AND s1_.active = 1
  AND s1_.terms_suspended = 0
  AND p0_.banned = 0
  AND p0_.accepted = 1
  AND p0_.category_id IN (?, ?, ?, ?, ?, ?)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN supplier s1_ ON p0_.supplier_id = s1_.id INNER JOIN tax t2_ ON p0_.tax_id = t2_.id WHERE p0_.status = 'active' AND s1_.active = 1 AND s1_.terms_suspended = 0 AND p0_.banned = 0 AND p0_.accepted = 1 AND p0_.category_id IN ('fcb1940c-593b-474a-9e01-10eaf26301bf', '36a776b3-8bc1-41ee-b6e0-99cb876d8312', '40f20237-a783-472b-b266-7eced6c4074c', '4fb97197-7534-4269-8bc5-d5abd84aad26', 'cc847fd1-0ea5-4d01-98a3-2a9b6bdbc5b7', 'ff423c26-7d67-4ac9-bef0-6af9e3118b7c');

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.name AS name_1
FROM
  product p0_
  INNER JOIN supplier s1_ ON p0_.supplier_id = s1_.id
  INNER JOIN tax t2_ ON p0_.tax_id = t2_.id
WHERE
  p0_.status = ?
  AND s1_.active = 1
  AND s1_.terms_suspended = 0
  AND p0_.banned = 0
  AND p0_.accepted = 1
  AND p0_.category_id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.name ASC
LIMIT
  12

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1 FROM product p0_ INNER JOIN supplier s1_ ON p0_.supplier_id = s1_.id INNER JOIN tax t2_ ON p0_.tax_id = t2_.id WHERE p0_.status = 'active' AND s1_.active = 1 AND s1_.terms_suspended = 0 AND p0_.banned = 0 AND p0_.accepted = 1 AND p0_.category_id IN ('fcb1940c-593b-474a-9e01-10eaf26301bf', '36a776b3-8bc1-41ee-b6e0-99cb876d8312', '40f20237-a783-472b-b266-7eced6c4074c', '4fb97197-7534-4269-8bc5-d5abd84aad26', 'cc847fd1-0ea5-4d01-98a3-2a9b6bdbc5b7', 'ff423c26-7d67-4ac9-bef0-6af9e3118b7c') ORDER BY p0_.name ASC LIMIT 12;

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_
  INNER JOIN product p1_ ON s0_.id = p1_.supplier_id
WHERE
  p1_.supplier_id = s0_.id
  AND s0_.active = 1
  AND s0_.terms_suspended = 0
  AND p1_.category_id IN (?, ?, ?, ?, ?, ?)
  AND p1_.status = ?
ORDER BY
  s0_.name 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_ INNER JOIN product p1_ ON s0_.id = p1_.supplier_id WHERE p1_.supplier_id = s0_.id AND s0_.active = 1 AND s0_.terms_suspended = 0 AND p1_.category_id IN ('fcb1940c-593b-474a-9e01-10eaf26301bf', '36a776b3-8bc1-41ee-b6e0-99cb876d8312', '40f20237-a783-472b-b266-7eced6c4074c', '4fb97197-7534-4269-8bc5-d5abd84aad26', 'cc847fd1-0ea5-4d01-98a3-2a9b6bdbc5b7', 'ff423c26-7d67-4ac9-bef0-6af9e3118b7c') AND p1_.status = 'active' ORDER BY s0_.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.icon AS icon_1,
  p0_.background_color AS background_color_2,
  p0_.tag AS tag_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  COUNT(p0_.id) AS sclr_6
FROM
  product_tag p0_
  INNER JOIN product_product_tag p2_ ON p0_.id = p2_.product_tag_id
  INNER JOIN product p1_ ON p1_.id = p2_.product_id
WHERE
  p1_.category_id IN (?, ?, ?, ?, ?, ?)
GROUP BY
  p0_.id,
  p0_.icon,
  p0_.background_color,
  p0_.tag,
  p0_.created_at,
  p0_.updated_at
ORDER BY
  sclr_6 DESC
LIMIT
  14

SELECT p0_.id AS id_0, p0_.icon AS icon_1, p0_.background_color AS background_color_2, p0_.tag AS tag_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, COUNT(p0_.id) AS sclr_6 FROM product_tag p0_ INNER JOIN product_product_tag p2_ ON p0_.id = p2_.product_tag_id INNER JOIN product p1_ ON p1_.id = p2_.product_id WHERE p1_.category_id IN ('fcb1940c-593b-474a-9e01-10eaf26301bf', '36a776b3-8bc1-41ee-b6e0-99cb876d8312', '40f20237-a783-472b-b266-7eced6c4074c', '4fb97197-7534-4269-8bc5-d5abd84aad26', 'cc847fd1-0ea5-4d01-98a3-2a9b6bdbc5b7', 'ff423c26-7d67-4ac9-bef0-6af9e3118b7c') GROUP BY p0_.id, p0_.icon, p0_.background_color, p0_.tag, p0_.created_at, p0_.updated_at ORDER BY sclr_6 DESC LIMIT 14;

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 13:53:01')) AND ((s0_.ends_at IS NULL OR s0_.ends_at >= '2026-10-19 13:53:01')) AND a2_.type = 'category_top_banner' ORDER BY s0_.created_at DESC;