Symfony Profiler

SELECT 
  e0_.id AS id_0, 
  e0_.action AS action_1, 
  e0_.logged_at AS logged_at_2, 
  e0_.object_id AS object_id_3, 
  e0_.object_class AS object_class_4, 
  e0_.version AS version_5, 
  e0_.data AS data_6, 
  e0_.username AS username_7, 
  e0_.object_parent AS object_parent_8, 
  e0_.current AS current_9, 
  e0_.pending AS pending_10, 
  e0_.user_id AS user_id_11 
FROM 
  entity_changelog e0_ 
WHERE 
  e0_.object_class = ? 
  AND e0_.object_id = ? 
  AND e0_.current = 1 
LIMIT 
  1

SELECT e0_.id AS id_0, e0_.action AS action_1, e0_.logged_at AS logged_at_2, e0_.object_id AS object_id_3, e0_.object_class AS object_class_4, e0_.version AS version_5, e0_.data AS data_6, e0_.username AS username_7, e0_.object_parent AS object_parent_8, e0_.current AS current_9, e0_.pending AS pending_10, e0_.user_id AS user_id_11 FROM entity_changelog e0_ WHERE e0_.object_class = 'Hitso\\Bundle\\FileManagerBundle\\Entity\\File' AND e0_.object_id = 'b063795c-993d-11eb-b51e-02000025f0dd' AND e0_.current = 1 LIMIT 1;

SELECT 
  DISTINCT c0_.id AS id_0, 
  c0_.published_at AS published_at_1 
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 c0_.id <> ? 
      AND (
        c1_.id = 3 
        OR c0_.category_id = 3
      )
    ) 
    AND (c0_.site_id = 'pl')
  ) 
  AND c0_.dtype IN ('article') 
ORDER BY 
  c0_.published_at DESC 
LIMIT 
  4

SELECT DISTINCT c0_.id AS id_0, c0_.published_at AS published_at_1 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-07-12 12:23:42' AND c0_.id <> 500 AND (c1_.id = 3 OR c0_.category_id = 3)) AND (c0_.site_id = 'pl')) AND c0_.dtype IN ('article') ORDER BY c0_.published_at DESC LIMIT 4;

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_.interested AS interested_27, 
  c0_.main_page AS main_page_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, 
  c0_.user_id AS user_id_41, 
  c0_.photo_file_id AS photo_file_id_42, 
  c0_.deletable_by_id AS deletable_by_id_43, 
  c0_.editable_by AS editable_by_44, 
  c0_.route_id AS route_id_45, 
  c0_.category_id AS category_id_46 
FROM 
  contents c0_ 
WHERE 
  (
    (c0_.id = ?) 
    AND (c0_.site_id = 'pl')
  ) 
  AND c0_.dtype IN ('article') 
LIMIT 
  1

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_.interested AS interested_27, c0_.main_page AS main_page_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, c0_.user_id AS user_id_41, c0_.photo_file_id AS photo_file_id_42, c0_.deletable_by_id AS deletable_by_id_43, c0_.editable_by AS editable_by_44, c0_.route_id AS route_id_45, c0_.category_id AS category_id_46 FROM contents c0_ WHERE ((c0_.id = 500) AND (c0_.site_id = 'pl')) AND c0_.dtype IN ('article') LIMIT 1;

SELECT 
  COUNT(*) 
FROM 
  content_authors t0 
WHERE 
  t0.content_id = ?

SELECT COUNT(*) FROM content_authors t0 WHERE t0.content_id = 500;

SELECT 
  COUNT(*) 
FROM 
  content_elements t0 
WHERE 
  (
    t0.deleted = ? 
    AND t0.content_id = ?
  ) 
  AND t0.dtype IN (
    'element', 'video', 'product', 'embed', 
    'advert', 'gallery', 'paragraph', 
    'attachments', 'section', 'textwrap', 
    'table', 'image', 'link', 'newsletter', 
    'featured', 'cta', 'catalogcategory', 
    'header', 'probe'
  ) 
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT COUNT(*) FROM content_elements t0 WHERE (t0.deleted = 0 AND t0.content_id = 500) AND t0.dtype IN ('element', 'video', 'product', 'embed', 'advert', 'gallery', 'paragraph', 'attachments', 'section', 'textwrap', 'table', 'image', 'link', 'newsletter', 'featured', 'cta', 'catalogcategory', 'header', 'probe') AND ((t0.deleted_at IS NULL));