Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.custom_id AS custom_id_1,
  a0_.title AS title_2,
  a0_.teaser AS teaser_3,
  a0_.slider_title AS slider_title_4,
  a0_.slug AS slug_5,
  a0_.slider_position AS slider_position_6,
  a0_.summary AS summary_7,
  a0_.body AS body_8,
  a0_.created_at AS created_at_9,
  a0_.event_date AS event_date_10,
  a0_.updated_at AS updated_at_11,
  a0_.published AS published_12,
  a0_.file_name AS file_name_13,
  a0_.author_id AS author_id_14,
  a0_.image_id AS image_id_15
FROM
  article a0_
  INNER JOIN articles_categories a2_ ON a0_.id = a2_.article_id
  INNER JOIN category c1_ ON c1_.id = a2_.category_id
WHERE
  c1_.slug IN (?)
ORDER BY
  a0_.created_at DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.custom_id AS custom_id_1, a0_.title AS title_2, a0_.teaser AS teaser_3, a0_.slider_title AS slider_title_4, a0_.slug AS slug_5, a0_.slider_position AS slider_position_6, a0_.summary AS summary_7, a0_.body AS body_8, a0_.created_at AS created_at_9, a0_.event_date AS event_date_10, a0_.updated_at AS updated_at_11, a0_.published AS published_12, a0_.file_name AS file_name_13, a0_.author_id AS author_id_14, a0_.image_id AS image_id_15 FROM article a0_ INNER JOIN articles_categories a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.slug IN ('excursion') ORDER BY a0_.created_at DESC LIMIT 1;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '2' AND e0_.locale = 'el' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  a0_.id AS id_0,
  a0_.custom_id AS custom_id_1,
  a0_.title AS title_2,
  a0_.teaser AS teaser_3,
  a0_.slider_title AS slider_title_4,
  a0_.slug AS slug_5,
  a0_.slider_position AS slider_position_6,
  a0_.summary AS summary_7,
  a0_.body AS body_8,
  a0_.created_at AS created_at_9,
  a0_.event_date AS event_date_10,
  a0_.updated_at AS updated_at_11,
  a0_.published AS published_12,
  a0_.file_name AS file_name_13,
  a0_.author_id AS author_id_14,
  a0_.image_id AS image_id_15
FROM
  article a0_
  INNER JOIN articles_categories a2_ ON a0_.id = a2_.article_id
  INNER JOIN category c1_ ON c1_.id = a2_.category_id
WHERE
  c1_.slug IN (?)
ORDER BY
  a0_.created_at DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.custom_id AS custom_id_1, a0_.title AS title_2, a0_.teaser AS teaser_3, a0_.slider_title AS slider_title_4, a0_.slug AS slug_5, a0_.slider_position AS slider_position_6, a0_.summary AS summary_7, a0_.body AS body_8, a0_.created_at AS created_at_9, a0_.event_date AS event_date_10, a0_.updated_at AS updated_at_11, a0_.published AS published_12, a0_.file_name AS file_name_13, a0_.author_id AS author_id_14, a0_.image_id AS image_id_15 FROM article a0_ INNER JOIN articles_categories a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.slug IN ('latest-news') ORDER BY a0_.created_at DESC LIMIT 3;

SELECT
  c0_.id AS id_0,
  c0_.migration_id AS migration_id_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.description AS description_4,
  c0_.view_type AS view_type_5,
  c0_.lft AS lft_6,
  c0_.lvl AS lvl_7,
  c0_.rgt AS rgt_8,
  c0_.published AS published_9,
  c0_.show_in_menu AS show_in_menu_10,
  c0_.sort_index AS sort_index_11,
  c0_.tree_root AS tree_root_12,
  c0_.parent_id AS parent_id_13,
  c0_.image_id AS image_id_14
FROM
  category c0_
WHERE
  c0_.published = ?
  AND c0_.show_in_menu = ?
ORDER BY
  c0_.tree_root ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.migration_id AS migration_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.view_type AS view_type_5, c0_.lft AS lft_6, c0_.lvl AS lvl_7, c0_.rgt AS rgt_8, c0_.published AS published_9, c0_.show_in_menu AS show_in_menu_10, c0_.sort_index AS sort_index_11, c0_.tree_root AS tree_root_12, c0_.parent_id AS parent_id_13, c0_.image_id AS image_id_14 FROM category c0_ WHERE c0_.published = 1 AND c0_.show_in_menu = 1 ORDER BY c0_.tree_root ASC, c0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.custom_id AS custom_id_2,
  t0.title AS title_3,
  t0.teaser AS teaser_4,
  t0.slider_title AS slider_title_5,
  t0.slug AS slug_6,
  t0.slider_position AS slider_position_7,
  t0.summary AS summary_8,
  t0.body AS body_9,
  t0.created_at AS created_at_10,
  t0.event_date AS event_date_11,
  t0.updated_at AS updated_at_12,
  t0.published AS published_13,
  t0.file_name AS file_name_14,
  t0.author_id AS author_id_15,
  t0.image_id AS image_id_16
FROM
  article t0
WHERE
  t0.custom_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.title AS title_3, t0.teaser AS teaser_4, t0.slider_title AS slider_title_5, t0.slug AS slug_6, t0.slider_position AS slider_position_7, t0.summary AS summary_8, t0.body AS body_9, t0.created_at AS created_at_10, t0.event_date AS event_date_11, t0.updated_at AS updated_at_12, t0.published AS published_13, t0.file_name AS file_name_14, t0.author_id AS author_id_15, t0.image_id AS image_id_16 FROM article t0 WHERE t0.custom_id = '1621880961' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.custom_id AS custom_id_1,
  a0_.title AS title_2,
  a0_.teaser AS teaser_3,
  a0_.slider_title AS slider_title_4,
  a0_.slug AS slug_5,
  a0_.slider_position AS slider_position_6,
  a0_.summary AS summary_7,
  a0_.body AS body_8,
  a0_.created_at AS created_at_9,
  a0_.event_date AS event_date_10,
  a0_.updated_at AS updated_at_11,
  a0_.published AS published_12,
  a0_.file_name AS file_name_13,
  a0_.author_id AS author_id_14,
  a0_.image_id AS image_id_15
FROM
  article a0_
WHERE
  NOT (a0_.slider_position = ?)
ORDER BY
  a0_.slider_position ASC

SELECT a0_.id AS id_0, a0_.custom_id AS custom_id_1, a0_.title AS title_2, a0_.teaser AS teaser_3, a0_.slider_title AS slider_title_4, a0_.slug AS slug_5, a0_.slider_position AS slider_position_6, a0_.summary AS summary_7, a0_.body AS body_8, a0_.created_at AS created_at_9, a0_.event_date AS event_date_10, a0_.updated_at AS updated_at_11, a0_.published AS published_12, a0_.file_name AS file_name_13, a0_.author_id AS author_id_14, a0_.image_id AS image_id_15 FROM article a0_ WHERE NOT (a0_.slider_position = 0) ORDER BY a0_.slider_position ASC;

SELECT
  t0.id AS id_1,
  t0.custom_id AS custom_id_2,
  t0.title AS title_3,
  t0.teaser AS teaser_4,
  t0.slider_title AS slider_title_5,
  t0.slug AS slug_6,
  t0.slider_position AS slider_position_7,
  t0.summary AS summary_8,
  t0.body AS body_9,
  t0.created_at AS created_at_10,
  t0.event_date AS event_date_11,
  t0.updated_at AS updated_at_12,
  t0.published AS published_13,
  t0.file_name AS file_name_14,
  t0.author_id AS author_id_15,
  t0.image_id AS image_id_16
FROM
  article t0
ORDER BY
  t0.created_at DESC
LIMIT
  10

SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.title AS title_3, t0.teaser AS teaser_4, t0.slider_title AS slider_title_5, t0.slug AS slug_6, t0.slider_position AS slider_position_7, t0.summary AS summary_8, t0.body AS body_9, t0.created_at AS created_at_10, t0.event_date AS event_date_11, t0.updated_at AS updated_at_12, t0.published AS published_13, t0.file_name AS file_name_14, t0.author_id AS author_id_15, t0.image_id AS image_id_16 FROM article t0 ORDER BY t0.created_at DESC LIMIT 10;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.created_at AS created_at_3,
  a0_.file_name AS file_name_4,
  a1_.path AS path_5,
  a2_.full_name AS full_name_6,
  a2_.slug AS slug_7,
  a2_.title AS title_8,
  c3_.slug AS slug_9,
  c3_.name AS name_10
FROM
  article a0_
  INNER JOIN author a2_ ON a0_.author_id = a2_.id
  INNER JOIN articles_categories a4_ ON a0_.id = a4_.article_id
  INNER JOIN category c3_ ON c3_.id = a4_.category_id
  LEFT JOIN app_file a1_ ON a0_.image_id = a1_.id
WHERE
  c3_.slug IN (?, ?, ?, ?)
  AND a0_.created_at IN (
    SELECT
      MAX(a5_.created_at) AS sclr_11
    FROM
      article a5_
      INNER JOIN articles_categories a7_ ON a5_.id = a7_.article_id
      INNER JOIN category c6_ ON c6_.id = a7_.category_id
    WHERE
      c6_.id = c3_.id
  )
LIMIT
  4

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.created_at AS created_at_3, a0_.file_name AS file_name_4, a1_.path AS path_5, a2_.full_name AS full_name_6, a2_.slug AS slug_7, a2_.title AS title_8, c3_.slug AS slug_9, c3_.name AS name_10 FROM article a0_ INNER JOIN author a2_ ON a0_.author_id = a2_.id INNER JOIN articles_categories a4_ ON a0_.id = a4_.article_id INNER JOIN category c3_ ON c3_.id = a4_.category_id LEFT JOIN app_file a1_ ON a0_.image_id = a1_.id WHERE c3_.slug IN ('rocktimegroups', 'tobearock', 'goldenyears', 'greekbands') AND a0_.created_at IN (SELECT MAX(a5_.created_at) AS sclr_11 FROM article a5_ INNER JOIN articles_categories a7_ ON a5_.id = a7_.article_id INNER JOIN category c6_ ON c6_.id = a7_.category_id WHERE c6_.id = c3_.id) LIMIT 4;