Symfony Profiler

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

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;

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

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;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.created_at AS created_at_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
ORDER BY
  p0_.name ASC,
  p0_.created_at DESC
LIMIT
  12

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_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 ORDER BY p0_.name ASC, p0_.created_at DESC 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_.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_.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
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 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
  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 = ?
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;