Symfony Profiler

SELECT
  k0_.locale AS locale_0,
  k0_.domain AS domain_1
FROM
  kuma_translation k0_
GROUP BY
  k0_.locale,
  k0_.domain

SELECT k0_.locale AS locale_0, k0_.domain AS domain_1 FROM kuma_translation k0_ GROUP BY k0_.locale, k0_.domain;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  k0_.lft AS lft_0,
  k0_.lvl AS lvl_1,
  k0_.rgt AS rgt_2,
  k0_.deleted AS deleted_3,
  k0_.hidden_from_nav AS hidden_from_nav_4,
  k0_.ref_entity_name AS ref_entity_name_5,
  k0_.internal_name AS internal_name_6,
  k0_.id AS id_7,
  k1_.lang AS lang_8,
  k1_.online AS online_9,
  k1_.title AS title_10,
  k1_.slug AS slug_11,
  k1_.url AS url_12,
  k1_.weight AS weight_13,
  k1_.created AS created_14,
  k1_.updated AS updated_15,
  k1_.id AS id_16,
  k2_.type AS type_17,
  k2_.owner AS owner_18,
  k2_.created AS created_19,
  k2_.updated AS updated_20,
  k2_.ref_id AS ref_id_21,
  k2_.ref_entity_name AS ref_entity_name_22,
  k2_.id AS id_23,
  k0_.parent_id AS parent_id_24,
  k1_.node_id AS node_id_25,
  k1_.public_node_version_id AS public_node_version_id_26,
  k2_.node_translation_id AS node_translation_id_27,
  k2_.origin_id AS origin_id_28
FROM
  kuma_nodes k0_
  LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id
  AND (k1_.lang = ?)
  LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id
  AND (
    k1_.public_node_version_id = k2_.id
  )
WHERE
  k0_.deleted = ?
  AND (
    (
      k0_.hidden_from_nav <> 1
      OR k0_.internal_name IS NOT NULL
    )
  )
ORDER BY
  k1_.weight ASC,
  k1_.title ASC

SELECT k0_.lft AS lft_0, k0_.lvl AS lvl_1, k0_.rgt AS rgt_2, k0_.deleted AS deleted_3, k0_.hidden_from_nav AS hidden_from_nav_4, k0_.ref_entity_name AS ref_entity_name_5, k0_.internal_name AS internal_name_6, k0_.id AS id_7, k1_.lang AS lang_8, k1_.online AS online_9, k1_.title AS title_10, k1_.slug AS slug_11, k1_.url AS url_12, k1_.weight AS weight_13, k1_.created AS created_14, k1_.updated AS updated_15, k1_.id AS id_16, k2_.type AS type_17, k2_.owner AS owner_18, k2_.created AS created_19, k2_.updated AS updated_20, k2_.ref_id AS ref_id_21, k2_.ref_entity_name AS ref_entity_name_22, k2_.id AS id_23, k0_.parent_id AS parent_id_24, k1_.node_id AS node_id_25, k1_.public_node_version_id AS public_node_version_id_26, k2_.node_translation_id AS node_translation_id_27, k2_.origin_id AS origin_id_28 FROM kuma_nodes k0_ LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id AND (k1_.lang = 'fr') LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id AND (k1_.public_node_version_id = k2_.id) WHERE k0_.deleted = 0 AND ((k0_.hidden_from_nav <> 1 OR k0_.internal_name IS NOT NULL)) ORDER BY k1_.weight ASC, k1_.title ASC;

SELECT
  a0_.image_alt_text AS image_alt_text_0,
  a0_.date AS date_1,
  a0_.summary AS summary_2,
  a0_.title AS title_3,
  a0_.page_title AS page_title_4,
  a0_.id AS id_5,
  a0_.image_id AS image_id_6
FROM
  app_news_pages a0_
  INNER JOIN kuma_node_versions k1_ ON (a0_.id = k1_.ref_id)
  INNER JOIN kuma_node_translations k2_ ON (
    k2_.public_node_version_id = k1_.id
  )
  INNER JOIN kuma_nodes k3_ ON (k2_.node_id = k3_.id)
  INNER JOIN app_news_tag_page_tags a5_ ON a0_.id = a5_.news_page_id
  INNER JOIN app_itempage_tags a4_ ON a4_.id = a5_.news_tag_id
WHERE
  k2_.online = 1
  AND k3_.deleted = 0
  AND k1_.ref_entity_name = ?
  AND a4_.name = ?
ORDER BY
  a0_.date DESC
LIMIT
  5

SELECT a0_.image_alt_text AS image_alt_text_0, a0_.date AS date_1, a0_.summary AS summary_2, a0_.title AS title_3, a0_.page_title AS page_title_4, a0_.id AS id_5, a0_.image_id AS image_id_6 FROM app_news_pages a0_ INNER JOIN kuma_node_versions k1_ ON (a0_.id = k1_.ref_id) INNER JOIN kuma_node_translations k2_ ON (k2_.public_node_version_id = k1_.id) INNER JOIN kuma_nodes k3_ ON (k2_.node_id = k3_.id) INNER JOIN app_news_tag_page_tags a5_ ON a0_.id = a5_.news_page_id INNER JOIN app_itempage_tags a4_ ON a4_.id = a5_.news_tag_id WHERE k2_.online = 1 AND k3_.deleted = 0 AND k1_.ref_entity_name = 'App\\Entity\\Pages\\NewsPage' AND a4_.name = 'alumni' ORDER BY a0_.date DESC LIMIT 5;