Symfony Profiler

WITH
  RECURSIVE cte AS (
    SELECT
      niche.id,
      niche.parent_id,
      niche.id as totalParent
    FROM
      niche
    WHERE
      niche.active = 1
    UNION ALL
    SELECT
      pc.id,
      pc.parent_id,
      cte.totalParent
    FROM
      niche AS pc,
      cte
    WHERE
      pc.parent_id = cte.id
      AND pc.active = 1
      AND (
        pc.available_from_date <= :date
        OR pc.available_from_date IS NULL
      )
      AND (
        pc.available_to_date >= :date
        OR pc.available_to_date IS NULL
      )
  )
SELECT
  cte.totalParent as id,
  count(DISTINCT landing.id) as totalActiveLandings,
  count(DISTINCT lp.id) as activeLandings
FROM
  cte
  LEFT JOIN rel_landing_niche lnp ON lnp.niche_id = cte.totalParent
  LEFT JOIN landing lp ON lp.id = lnp.landing_id
  and lp.active = 1
  LEFT JOIN rel_landing_niche ON cte.id = rel_landing_niche.niche_id
  LEFT JOIN landing ON landing.id = rel_landing_niche.landing_id
  and landing.active = 1
GROUP BY
  cte.totalParent
HAVING
  totalActiveLandings > 0
  OR activeLandings > 0
ORDER BY
  NULL

WITH RECURSIVE cte AS (
            SELECT niche.id, niche.parent_id, niche.id as totalParent
            FROM niche 
             WHERE niche.active = 1 
            UNION ALL
            SELECT pc.id, pc.parent_id, cte.totalParent
            FROM niche AS pc, cte
            WHERE pc.parent_id = cte.id  AND pc.active = 1 AND (pc.available_from_date <= :date OR pc.available_from_date IS NULL) AND (pc.available_to_date >= :date OR pc.available_to_date IS NULL) 
        )
        SELECT 
            cte.totalParent as id, count(DISTINCT landing.id) as totalActiveLandings, count(DISTINCT lp.id) as activeLandings 
        FROM cte
        LEFT JOIN rel_landing_niche lnp ON lnp.niche_id = cte.totalParent
        LEFT JOIN landing lp ON lp.id = lnp.landing_id and lp.active = 1
        LEFT JOIN rel_landing_niche ON cte.id = rel_landing_niche.niche_id 
        LEFT JOIN landing ON landing.id = rel_landing_niche.landing_id and landing.active = 1
        GROUP BY cte.totalParent
         HAVING totalActiveLandings > 0 OR activeLandings > 0 
        ORDER BY NULL;

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.icon AS icon_2,
  n0_.active AS active_3,
  n0_.default_keyword AS default_keyword_4,
  n0_.available_from_date AS available_from_date_5,
  n0_.available_to_date AS available_to_date_6,
  n0_.id AS id_7,
  n0_.name AS name_8,
  n0_.icon AS icon_9,
  n0_.active AS active_10,
  n0_.default_keyword AS default_keyword_11,
  n0_.available_from_date AS available_from_date_12,
  n0_.available_to_date AS available_to_date_13,
  l1_.prelanding AS prelanding_14,
  l1_.required_link_parameters AS required_link_parameters_15,
  l1_.name AS name_16,
  l1_.id AS id_17,
  l1_.active AS active_18,
  l1_.deactivated_by AS deactivated_by_19,
  l1_.created_at AS created_at_20,
  l1_.updated_at AS updated_at_21,
  l1_.note AS note_22,
  l1_.preview AS preview_23,
  l1_.admin_cap_lifetime_budget_limit AS admin_cap_lifetime_budget_limit_24,
  l1_.admin_cap_lifetime_budget_status AS admin_cap_lifetime_budget_status_25,
  l1_.admin_cap_lifetime_lead_limit AS admin_cap_lifetime_lead_limit_26,
  l1_.admin_cap_lifetime_lead_status AS admin_cap_lifetime_lead_status_27,
  l1_.cap_lifetime_budget_limit AS cap_lifetime_budget_limit_28,
  l1_.cap_lifetime_budget_status AS cap_lifetime_budget_status_29,
  l1_.cap_lifetime_lead_limit AS cap_lifetime_lead_limit_30,
  l1_.cap_lifetime_lead_status AS cap_lifetime_lead_status_31,
  l1_.cap_monthly_budget_limit AS cap_monthly_budget_limit_32,
  l1_.cap_monthly_budget_status AS cap_monthly_budget_status_33,
  l1_.cap_monthly_lead_limit AS cap_monthly_lead_limit_34,
  l1_.cap_monthly_lead_status AS cap_monthly_lead_status_35,
  l1_.cap_weekly_budget_limit AS cap_weekly_budget_limit_36,
  l1_.cap_weekly_budget_status AS cap_weekly_budget_status_37,
  l1_.cap_weekly_lead_limit AS cap_weekly_lead_limit_38,
  l1_.cap_weekly_lead_status AS cap_weekly_lead_status_39,
  l1_.cap_daily_budget_limit AS cap_daily_budget_limit_40,
  l1_.cap_daily_budget_status AS cap_daily_budget_status_41,
  l1_.cap_daily_lead_limit AS cap_daily_lead_limit_42,
  l1_.cap_daily_lead_status AS cap_daily_lead_status_43,
  n0_.parent_id AS parent_id_44,
  l1_.advertiser_id AS advertiser_id_45,
  l1_.product_id AS product_id_46
FROM
  niche n0_
  LEFT JOIN rel_landing_niche r2_ ON n0_.id = r2_.niche_id
  LEFT JOIN landing l1_ ON l1_.id = r2_.landing_id
  AND (l1_.active = 1)
WHERE
  n0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.icon AS icon_2, n0_.active AS active_3, n0_.default_keyword AS default_keyword_4, n0_.available_from_date AS available_from_date_5, n0_.available_to_date AS available_to_date_6, n0_.id AS id_7, n0_.name AS name_8, n0_.icon AS icon_9, n0_.active AS active_10, n0_.default_keyword AS default_keyword_11, n0_.available_from_date AS available_from_date_12, n0_.available_to_date AS available_to_date_13, l1_.prelanding AS prelanding_14, l1_.required_link_parameters AS required_link_parameters_15, l1_.name AS name_16, l1_.id AS id_17, l1_.active AS active_18, l1_.deactivated_by AS deactivated_by_19, l1_.created_at AS created_at_20, l1_.updated_at AS updated_at_21, l1_.note AS note_22, l1_.preview AS preview_23, l1_.admin_cap_lifetime_budget_limit AS admin_cap_lifetime_budget_limit_24, l1_.admin_cap_lifetime_budget_status AS admin_cap_lifetime_budget_status_25, l1_.admin_cap_lifetime_lead_limit AS admin_cap_lifetime_lead_limit_26, l1_.admin_cap_lifetime_lead_status AS admin_cap_lifetime_lead_status_27, l1_.cap_lifetime_budget_limit AS cap_lifetime_budget_limit_28, l1_.cap_lifetime_budget_status AS cap_lifetime_budget_status_29, l1_.cap_lifetime_lead_limit AS cap_lifetime_lead_limit_30, l1_.cap_lifetime_lead_status AS cap_lifetime_lead_status_31, l1_.cap_monthly_budget_limit AS cap_monthly_budget_limit_32, l1_.cap_monthly_budget_status AS cap_monthly_budget_status_33, l1_.cap_monthly_lead_limit AS cap_monthly_lead_limit_34, l1_.cap_monthly_lead_status AS cap_monthly_lead_status_35, l1_.cap_weekly_budget_limit AS cap_weekly_budget_limit_36, l1_.cap_weekly_budget_status AS cap_weekly_budget_status_37, l1_.cap_weekly_lead_limit AS cap_weekly_lead_limit_38, l1_.cap_weekly_lead_status AS cap_weekly_lead_status_39, l1_.cap_daily_budget_limit AS cap_daily_budget_limit_40, l1_.cap_daily_budget_status AS cap_daily_budget_status_41, l1_.cap_daily_lead_limit AS cap_daily_lead_limit_42, l1_.cap_daily_lead_status AS cap_daily_lead_status_43, n0_.parent_id AS parent_id_44, l1_.advertiser_id AS advertiser_id_45, l1_.product_id AS product_id_46 FROM niche n0_ LEFT JOIN rel_landing_niche r2_ ON n0_.id = r2_.niche_id LEFT JOIN landing l1_ ON l1_.id = r2_.landing_id AND (l1_.active = 1) WHERE n0_.id IN (1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 17, 18, 19, 20, 22, 26, 27, 31, 32, 33, 34, 35, 37, 39, 41, 42, 43, 47, 48, 49, 50, 56, 57, 58, 59);

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2,
  p0_.fixed_internal_fee AS fixed_internal_fee_3,
  p0_.percentage_internal_fee AS percentage_internal_fee_4,
  p0_.external_fee AS external_fee_5,
  p0_.payout_minimum AS payout_minimum_6,
  p0_.net AS net_7,
  p0_.active AS active_8,
  p0_.public AS public_9,
  p0_.icon AS icon_10,
  p0_.slug AS slug_11,
  p0_.transfer_duration AS transfer_duration_12,
  p0_.rank AS rank_13,
  FIELD(p0_.id, 4, 3, 7, 8, 2, 11, 1, 5) AS sclr_14,
  p0_.payment_service_id AS payment_service_id_15
FROM
  payment_method p0_
WHERE
  p0_.active = ?
  AND p0_.public = ?
ORDER BY
  sclr_14 DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.fixed_internal_fee AS fixed_internal_fee_3, p0_.percentage_internal_fee AS percentage_internal_fee_4, p0_.external_fee AS external_fee_5, p0_.payout_minimum AS payout_minimum_6, p0_.net AS net_7, p0_.active AS active_8, p0_.public AS public_9, p0_.icon AS icon_10, p0_.slug AS slug_11, p0_.transfer_duration AS transfer_duration_12, p0_.rank AS rank_13, FIELD(p0_.id, 4, 3, 7, 8, 2, 11, 1, 5) AS sclr_14, p0_.payment_service_id AS payment_service_id_15 FROM payment_method p0_ WHERE p0_.active = 1 AND p0_.public = 1 ORDER BY sclr_14 DESC;

SELECT
  min(p0_.payout_minimum) AS sclr_0
FROM
  payment_method p0_
WHERE
  p0_.active = 1

SELECT min(p0_.payout_minimum) AS sclr_0 FROM payment_method p0_ WHERE p0_.active = 1;

SELECT
  count(l0_.id) AS sclr_0
FROM
  landing l0_
WHERE
  l0_.active = 1

SELECT count(l0_.id) AS sclr_0 FROM landing l0_ WHERE l0_.active = 1;