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-08-03 08:30:57') AND (c0_.site_id = 'pl')) AND c0_.dtype IN ('article') ORDER BY c0_.published_at DESC) dctrn_result) dctrn_table;

SELECT 
  t0.id AS id_1, 
  t0.site_id AS site_id_2, 
  t0.created_at AS created_at_3, 
  t0.updated_at AS updated_at_4, 
  t0.published AS published_5, 
  t0.published_at AS published_at_6, 
  t0.name AS name_7, 
  t0.description AS description_8, 
  t0.slug AS slug_9, 
  t0.node_level AS node_level_10, 
  t0.left_node AS left_node_11, 
  t0.right_node AS right_node_12, 
  t0.removable AS removable_13, 
  t0.parent_id AS parent_id_14, 
  t0.type, 
  t0.meta_original_url AS meta_original_url_15, 
  t0.meta_meta_description AS meta_meta_description_16, 
  t0.meta_meta_keywords AS meta_meta_keywords_17, 
  t0.meta_title AS meta_title_18, 
  t0.meta_extra_properties AS meta_extra_properties_19, 
  t0.meta_extra_names AS meta_extra_names_20, 
  t0.meta_extra_http AS meta_extra_http_21, 
  t0.meta_og_image AS meta_og_image_22, 
  t0.route_id AS route_id_23 
FROM 
  contents_categories t0 
WHERE 
  t0.type IN ('category', 'articlecategory') 
  AND (
    (t0.site_id = 'pl')
  )

SELECT t0.id AS id_1, t0.site_id AS site_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.published AS published_5, t0.published_at AS published_at_6, t0.name AS name_7, t0.description AS description_8, t0.slug AS slug_9, t0.node_level AS node_level_10, t0.left_node AS left_node_11, t0.right_node AS right_node_12, t0.removable AS removable_13, t0.parent_id AS parent_id_14, t0.type, t0.meta_original_url AS meta_original_url_15, t0.meta_meta_description AS meta_meta_description_16, t0.meta_meta_keywords AS meta_meta_keywords_17, t0.meta_title AS meta_title_18, t0.meta_extra_properties AS meta_extra_properties_19, t0.meta_extra_names AS meta_extra_names_20, t0.meta_extra_http AS meta_extra_http_21, t0.meta_og_image AS meta_og_image_22, t0.route_id AS route_id_23 FROM contents_categories t0 WHERE t0.type IN ('category', 'articlecategory') AND ((t0.site_id = 'pl'));

SELECT 
  t1.id AS id_2, 
  t1.path AS path_3, 
  t1.site_id AS site_id_4, 
  t0.foreign_id AS foreign_id_5, 
  t1.type 
FROM 
  routes_article_category t0 
  INNER JOIN routes t1 ON t0.id = t1.id 
WHERE 
  t1.id = ?

SELECT t1.id AS id_2, t1.path AS path_3, t1.site_id AS site_id_4, t0.foreign_id AS foreign_id_5, t1.type FROM routes_article_category t0 INNER JOIN routes t1 ON t0.id = t1.id WHERE t1.id = 1202;

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-08-03 08:30:57' AND (c1_.id = 38 OR c0_.category_id = 38)) AND (c0_.site_id = 'pl')) AND c0_.dtype IN ('article');