Symfony Profiler

SELECT 
  COUNT(*) AS dctrn_count 
FROM 
  (
    SELECT 
      DISTINCT id_0 
    FROM 
      (
        SELECT 
          c0_.id AS id_0, 
          c0_.site_id AS site_id_1, 
          c0_.created_at AS created_at_2, 
          c0_.updated_at AS updated_at_3, 
          c0_.created_by AS created_by_4, 
          c0_.updated_by AS updated_by_5, 
          c0_.published_at AS published_at_6, 
          c0_.published AS published_7, 
          c0_.draft AS draft_8, 
          c0_.comment_allowed AS comment_allowed_9, 
          c0_.rated AS rated_10, 
          c0_.promoted AS promoted_11, 
          c0_.popular AS popular_12, 
          c0_.title AS title_13, 
          c0_.video AS video_14, 
          c0_.slug AS slug_15, 
          c0_.version AS version_16, 
          c0_.type AS type_17, 
          c0_.popularity AS popularity_18, 
          c0_.deletable AS deletable_19, 
          c0_.deletable_at AS deletable_at_20, 
          c0_.editable AS editable_21, 
          c0_.editable_at AS editable_at_22, 
          c0_.parent_id AS parent_id_23, 
          c0_.enabled AS enabled_24, 
          c0_.pending_logs AS pending_logs_25, 
          c0_.pending AS pending_26, 
          c0_.label AS label_27, 
          c0_.shops AS shops_28, 
          c0_.article_lead AS article_lead_29, 
          c0_.photo_caption AS photo_caption_30, 
          c0_.photo_alt AS photo_alt_31, 
          c0_.meta_original_url AS meta_original_url_32, 
          c0_.meta_meta_description AS meta_meta_description_33, 
          c0_.meta_meta_keywords AS meta_meta_keywords_34, 
          c0_.meta_title AS meta_title_35, 
          c0_.meta_extra_properties AS meta_extra_properties_36, 
          c0_.meta_extra_names AS meta_extra_names_37, 
          c0_.meta_extra_http AS meta_extra_http_38, 
          c0_.meta_og_image AS meta_og_image_39, 
          c0_.dtype AS dtype_40 
        FROM 
          contents c0_ 
        WHERE 
          (
            (
              c0_.published = 1 
              AND c0_.slug IS NOT NULL 
              AND c0_.slug <> '' 
              AND c0_.published_at <= ?
            ) 
            AND (c0_.site_id = 'pl')
          ) 
          AND c0_.dtype IN ('article') 
        ORDER BY 
          c0_.published_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.site_id AS site_id_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.created_by AS created_by_4, c0_.updated_by AS updated_by_5, c0_.published_at AS published_at_6, c0_.published AS published_7, c0_.draft AS draft_8, c0_.comment_allowed AS comment_allowed_9, c0_.rated AS rated_10, c0_.promoted AS promoted_11, c0_.popular AS popular_12, c0_.title AS title_13, c0_.video AS video_14, c0_.slug AS slug_15, c0_.version AS version_16, c0_.type AS type_17, c0_.popularity AS popularity_18, c0_.deletable AS deletable_19, c0_.deletable_at AS deletable_at_20, c0_.editable AS editable_21, c0_.editable_at AS editable_at_22, c0_.parent_id AS parent_id_23, c0_.enabled AS enabled_24, c0_.pending_logs AS pending_logs_25, c0_.pending AS pending_26, c0_.label AS label_27, c0_.shops AS shops_28, c0_.article_lead AS article_lead_29, c0_.photo_caption AS photo_caption_30, c0_.photo_alt AS photo_alt_31, c0_.meta_original_url AS meta_original_url_32, c0_.meta_meta_description AS meta_meta_description_33, c0_.meta_meta_keywords AS meta_meta_keywords_34, c0_.meta_title AS meta_title_35, c0_.meta_extra_properties AS meta_extra_properties_36, c0_.meta_extra_names AS meta_extra_names_37, c0_.meta_extra_http AS meta_extra_http_38, c0_.meta_og_image AS meta_og_image_39, c0_.dtype AS dtype_40 FROM contents c0_ WHERE ((c0_.published = 1 AND c0_.slug IS NOT NULL AND c0_.slug <> '' AND c0_.published_at <= '2025-09-06 09:32:25') AND (c0_.site_id = 'pl')) AND c0_.dtype IN ('article') ORDER BY c0_.published_at DESC) dctrn_result) dctrn_table;

SELECT 
  count(DISTINCT c0_.id) AS sclr_0 
FROM 
  contents c0_ 
  LEFT JOIN articles_categories a2_ ON c0_.id = a2_.article_id 
  LEFT JOIN contents_categories c1_ ON c1_.id = a2_.category_id 
  AND c1_.type IN ('articlecategory') 
  AND (c1_.site_id = 'pl') 
WHERE 
  (
    (
      c0_.published = 1 
      AND c0_.slug IS NOT NULL 
      AND c0_.slug <> '' 
      AND c0_.published_at <= ? 
      AND (
        c1_.id = 38 
        OR c0_.category_id = 38
      )
    ) 
    AND (c0_.site_id = 'pl')
  ) 
  AND c0_.dtype IN ('article')

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM contents c0_ LEFT JOIN articles_categories a2_ ON c0_.id = a2_.article_id LEFT JOIN contents_categories c1_ ON c1_.id = a2_.category_id AND c1_.type IN ('articlecategory') AND (c1_.site_id = 'pl') WHERE ((c0_.published = 1 AND c0_.slug IS NOT NULL AND c0_.slug <> '' AND c0_.published_at <= '2025-09-06 09:32:25' AND (c1_.id = 38 OR c0_.category_id = 38)) AND (c0_.site_id = 'pl')) AND c0_.dtype IN ('article');