Symfony Profiler

SELECT 
  t0.id AS id_7, 
  t0.path AS path_8, 
  t0.site_id AS site_id_9, 
  t0.type, 
  t1.foreign_id AS foreign_id_10, 
  t2.foreign_id AS foreign_id_11, 
  t3.foreign_id AS foreign_id_12, 
  t4.foreign_id AS foreign_id_13, 
  t5.foreign_id AS foreign_id_14, 
  t6.foreign_id AS foreign_id_15 
FROM 
  routes t0 
  LEFT JOIN routes_article t1 ON t0.id = t1.id 
  LEFT JOIN routes_article_category t2 ON t0.id = t2.id 
  LEFT JOIN routes_page t3 ON t0.id = t3.id 
  LEFT JOIN routes_group_section t4 ON t0.id = t4.id 
  LEFT JOIN routes_product t5 ON t0.id = t5.id 
  LEFT JOIN routes_category t6 ON t0.id = t6.id 
WHERE 
  t0.path = ? 
  AND t0.site_id = ? 
LIMIT 
  1

SELECT t0.id AS id_7, t0.path AS path_8, t0.site_id AS site_id_9, t0.type, t1.foreign_id AS foreign_id_10, t2.foreign_id AS foreign_id_11, t3.foreign_id AS foreign_id_12, t4.foreign_id AS foreign_id_13, t5.foreign_id AS foreign_id_14, t6.foreign_id AS foreign_id_15 FROM routes t0 LEFT JOIN routes_article t1 ON t0.id = t1.id LEFT JOIN routes_article_category t2 ON t0.id = t2.id LEFT JOIN routes_page t3 ON t0.id = t3.id LEFT JOIN routes_group_section t4 ON t0.id = t4.id LEFT JOIN routes_product t5 ON t0.id = t5.id LEFT JOIN routes_category t6 ON t0.id = t6.id WHERE t0.path = 'testowa' AND t0.site_id = 'pl' LIMIT 1;

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