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
  redirect.id
FROM
  kuma_redirects redirect
WHERE
  (
    ? LIKE REPLACE(redirect.origin, '*', '%')
  )
  AND (
    (redirect.domain IS NULL)
    OR (redirect.domain = '')
    OR (redirect.domain = ?)
  )

SELECT redirect.id FROM kuma_redirects redirect WHERE ('/' LIKE REPLACE(redirect.origin, '*', '%')) AND ((redirect.domain IS NULL) OR (redirect.domain = '') OR (redirect.domain = 'www.stag.cciangazidja.com'));

SELECT
  k0_.lang AS lang_0,
  k0_.online AS online_1,
  k0_.title AS title_2,
  k0_.slug AS slug_3,
  k0_.url AS url_4,
  k0_.weight AS weight_5,
  k0_.created AS created_6,
  k0_.updated AS updated_7,
  k0_.id AS id_8,
  k1_.type AS type_9,
  k1_.owner AS owner_10,
  k1_.created AS created_11,
  k1_.updated AS updated_12,
  k1_.ref_id AS ref_id_13,
  k1_.ref_entity_name AS ref_entity_name_14,
  k1_.id AS id_15,
  k0_.node_id AS node_id_16,
  k0_.public_node_version_id AS public_node_version_id_17,
  k1_.node_translation_id AS node_translation_id_18,
  k1_.origin_id AS origin_id_19
FROM
  kuma_node_translations k0_
  INNER JOIN kuma_nodes k2_ ON k0_.node_id = k2_.id
  AND (k0_.node_id = k2_.id)
  LEFT JOIN kuma_node_versions k1_ ON k0_.public_node_version_id = k1_.id
  AND (
    k0_.public_node_version_id = k1_.id
  )
WHERE
  k2_.deleted = ?
  AND k0_.lang = ?
  AND k0_.url IS NULL
ORDER BY
  k0_.online DESC
LIMIT
  1

SELECT k0_.lang AS lang_0, k0_.online AS online_1, k0_.title AS title_2, k0_.slug AS slug_3, k0_.url AS url_4, k0_.weight AS weight_5, k0_.created AS created_6, k0_.updated AS updated_7, k0_.id AS id_8, k1_.type AS type_9, k1_.owner AS owner_10, k1_.created AS created_11, k1_.updated AS updated_12, k1_.ref_id AS ref_id_13, k1_.ref_entity_name AS ref_entity_name_14, k1_.id AS id_15, k0_.node_id AS node_id_16, k0_.public_node_version_id AS public_node_version_id_17, k1_.node_translation_id AS node_translation_id_18, k1_.origin_id AS origin_id_19 FROM kuma_node_translations k0_ INNER JOIN kuma_nodes k2_ ON k0_.node_id = k2_.id AND (k0_.node_id = k2_.id) LEFT JOIN kuma_node_versions k1_ ON k0_.public_node_version_id = k1_.id AND (k0_.public_node_version_id = k1_.id) WHERE k2_.deleted = 0 AND k0_.lang = 'fr' AND k0_.url IS NULL ORDER BY k0_.online DESC LIMIT 1;

SELECT
  t0.title AS title_1,
  t0.page_title AS page_title_2,
  t0.id AS id_3
FROM
  app_home_pages t0
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.page_title AS page_title_2, t0.id AS id_3 FROM app_home_pages t0 WHERE t0.id = '1';

SELECT
  a0_.date AS date_0,
  a0_.summary AS summary_1,
  a0_.title AS title_2,
  a0_.page_title AS page_title_3,
  a0_.id AS id_4,
  a0_.cover_image_id AS cover_image_id_5,
  a0_.actuality_author_id AS actuality_author_id_6
FROM
  app_actuality_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)
WHERE
  k2_.online = ?
  AND k3_.deleted = ?
  AND k1_.ref_entity_name = ?
  AND k2_.lang = ?
ORDER BY
  a0_.date DESC
LIMIT
  3

SELECT a0_.date AS date_0, a0_.summary AS summary_1, a0_.title AS title_2, a0_.page_title AS page_title_3, a0_.id AS id_4, a0_.cover_image_id AS cover_image_id_5, a0_.actuality_author_id AS actuality_author_id_6 FROM app_actuality_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) WHERE k2_.online = 1 AND k3_.deleted = 0 AND k1_.ref_entity_name = 'App\\Entity\\Pages\\ActualityPage' AND k2_.lang = 'fr' ORDER BY a0_.date DESC LIMIT 3;

SELECT
  a0_.date AS date_0,
  a0_.summary AS summary_1,
  a0_.title AS title_2,
  a0_.page_title AS page_title_3,
  a0_.id AS id_4,
  a0_.cover_image_id AS cover_image_id_5,
  a0_.actuality_author_id AS actuality_author_id_6
FROM
  app_actuality_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)
WHERE
  k2_.online = ?
  AND k3_.deleted = ?
  AND k1_.ref_entity_name = ?
  AND k2_.lang = ?
ORDER BY
  a0_.date DESC
LIMIT
  5

SELECT a0_.date AS date_0, a0_.summary AS summary_1, a0_.title AS title_2, a0_.page_title AS page_title_3, a0_.id AS id_4, a0_.cover_image_id AS cover_image_id_5, a0_.actuality_author_id AS actuality_author_id_6 FROM app_actuality_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) WHERE k2_.online = 1 AND k3_.deleted = 0 AND k1_.ref_entity_name = 'App\\Entity\\Pages\\ActualityPage' AND k2_.lang = 'fr' ORDER BY a0_.date DESC LIMIT 5;

SELECT
  a0_.category_label AS category_label_0,
  a0_.location AS location_1,
  a0_.registration_url AS registration_url_2,
  a0_.date AS date_3,
  a0_.summary AS summary_4,
  a0_.title AS title_5,
  a0_.page_title AS page_title_6,
  a0_.id AS id_7,
  a0_.cover_image_id AS cover_image_id_8
FROM
  app_event_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)
WHERE
  k2_.online = ?
  AND k3_.deleted = ?
  AND k1_.ref_entity_name = ?
  AND k2_.lang = ?
ORDER BY
  a0_.date DESC
LIMIT
  3

SELECT a0_.category_label AS category_label_0, a0_.location AS location_1, a0_.registration_url AS registration_url_2, a0_.date AS date_3, a0_.summary AS summary_4, a0_.title AS title_5, a0_.page_title AS page_title_6, a0_.id AS id_7, a0_.cover_image_id AS cover_image_id_8 FROM app_event_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) WHERE k2_.online = 1 AND k3_.deleted = 0 AND k1_.ref_entity_name = 'App\\Entity\\Pages\\EventPage' AND k2_.lang = 'fr' ORDER BY a0_.date DESC LIMIT 3;

SELECT
  a0_.category_label AS category_label_0,
  a0_.status_label AS status_label_1,
  a0_.reference_code AS reference_code_2,
  a0_.location AS location_3,
  a0_.deadline_at AS deadline_at_4,
  a0_.date AS date_5,
  a0_.summary AS summary_6,
  a0_.title AS title_7,
  a0_.page_title AS page_title_8,
  a0_.id AS id_9,
  a0_.attachment_one_id AS attachment_one_id_10,
  a0_.attachment_two_id AS attachment_two_id_11,
  a0_.attachment_three_id AS attachment_three_id_12
FROM
  app_opportunity_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)
WHERE
  k2_.online = ?
  AND k3_.deleted = ?
  AND k1_.ref_entity_name = ?
  AND k2_.lang = ?
ORDER BY
  a0_.date DESC
LIMIT
  3

SELECT a0_.category_label AS category_label_0, a0_.status_label AS status_label_1, a0_.reference_code AS reference_code_2, a0_.location AS location_3, a0_.deadline_at AS deadline_at_4, a0_.date AS date_5, a0_.summary AS summary_6, a0_.title AS title_7, a0_.page_title AS page_title_8, a0_.id AS id_9, a0_.attachment_one_id AS attachment_one_id_10, a0_.attachment_two_id AS attachment_two_id_11, a0_.attachment_three_id AS attachment_three_id_12 FROM app_opportunity_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) WHERE k2_.online = 1 AND k3_.deleted = 0 AND k1_.ref_entity_name = 'App\\Entity\\Pages\\OpportunityPage' AND k2_.lang = 'fr' ORDER BY a0_.date DESC LIMIT 3;

SELECT
  a0_.date AS date_0,
  a0_.summary AS summary_1,
  a0_.title AS title_2,
  a0_.page_title AS page_title_3,
  a0_.id AS id_4,
  a0_.cover_image_id AS cover_image_id_5
FROM
  app_service_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)
WHERE
  k2_.online = ?
  AND k3_.deleted = ?
  AND k1_.ref_entity_name = ?
  AND k2_.lang = ?
ORDER BY
  a0_.date DESC
LIMIT
  3

SELECT a0_.date AS date_0, a0_.summary AS summary_1, a0_.title AS title_2, a0_.page_title AS page_title_3, a0_.id AS id_4, a0_.cover_image_id AS cover_image_id_5 FROM app_service_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) WHERE k2_.online = 1 AND k3_.deleted = 0 AND k1_.ref_entity_name = 'App\\Entity\\Pages\\ServicePage' AND k2_.lang = 'fr' ORDER BY a0_.date DESC LIMIT 3;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.lft AS lft_1,
  t0.lvl AS lvl_2,
  t0.rgt AS rgt_3,
  t0.deleted AS deleted_4,
  t0.hidden_from_nav AS hidden_from_nav_5,
  t0.ref_entity_name AS ref_entity_name_6,
  t0.internal_name AS internal_name_7,
  t0.id AS id_8,
  t0.parent_id AS parent_id_9
FROM
  kuma_nodes t0
WHERE
  t0.id = ?

SELECT t0.lft AS lft_1, t0.lvl AS lvl_2, t0.rgt AS rgt_3, t0.deleted AS deleted_4, t0.hidden_from_nav AS hidden_from_nav_5, t0.ref_entity_name AS ref_entity_name_6, t0.internal_name AS internal_name_7, t0.id AS id_8, t0.parent_id AS parent_id_9 FROM kuma_nodes t0 WHERE t0.id = '1';

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_
  INNER JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id
  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_.lft <= 1
    AND k0_.rgt >= 84
  )
ORDER BY
  k0_.lft 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_ INNER JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id 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_.lft <= 1 AND k0_.rgt >= 84) ORDER BY k0_.lft ASC;

SELECT
  t0.meta_title AS meta_title_1,
  t0.meta_description AS meta_description_2,
  t0.meta_author AS meta_author_3,
  t0.meta_robots AS meta_robots_4,
  t0.og_type AS og_type_5,
  t0.og_title AS og_title_6,
  t0.og_description AS og_description_7,
  t0.extra_metadata AS extra_metadata_8,
  t0.ref_id AS ref_id_9,
  t0.ref_entity_name AS ref_entity_name_10,
  t0.og_url AS og_url_11,
  t0.og_article_author AS og_article_author_12,
  t0.og_article_publisher AS og_article_publisher_13,
  t0.og_article_section AS og_article_section_14,
  t0.twitter_title AS twitter_title_15,
  t0.twitter_description AS twitter_description_16,
  t0.twitter_site AS twitter_site_17,
  t0.twitter_creator AS twitter_creator_18,
  t0.id AS id_19,
  t0.og_image_id AS og_image_id_20,
  t0.twitter_image_id AS twitter_image_id_21
FROM
  kuma_seo t0
WHERE
  t0.ref_id = ?
  AND t0.ref_entity_name = ?
LIMIT
  1

SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_author AS meta_author_3, t0.meta_robots AS meta_robots_4, t0.og_type AS og_type_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.extra_metadata AS extra_metadata_8, t0.ref_id AS ref_id_9, t0.ref_entity_name AS ref_entity_name_10, t0.og_url AS og_url_11, t0.og_article_author AS og_article_author_12, t0.og_article_publisher AS og_article_publisher_13, t0.og_article_section AS og_article_section_14, t0.twitter_title AS twitter_title_15, t0.twitter_description AS twitter_description_16, t0.twitter_site AS twitter_site_17, t0.twitter_creator AS twitter_creator_18, t0.id AS id_19, t0.og_image_id AS og_image_id_20, t0.twitter_image_id AS twitter_image_id_21 FROM kuma_seo t0 WHERE t0.ref_id = '1' AND t0.ref_entity_name = 'App\\Entity\\Pages\\HomePage' LIMIT 1;

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
  t0.page_id AS page_id_1,
  t0.page_entity_name AS page_entity_name_2,
  t0.page_template AS page_template_3,
  t0.id AS id_4
FROM
  kuma_page_template_configuration t0
WHERE
  t0.page_id = ?
  AND t0.page_entity_name = ?
LIMIT
  1

SELECT t0.page_id AS page_id_1, t0.page_entity_name AS page_entity_name_2, t0.page_template AS page_template_3, t0.id AS id_4 FROM kuma_page_template_configuration t0 WHERE t0.page_id = '1' AND t0.page_entity_name = 'App\\Entity\\Pages\\HomePage' LIMIT 1;

SELECT
  t0.uuid AS uuid_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.copyright AS copyright_4,
  t0.location AS location_5,
  t0.content_type AS content_type_6,
  t0.metadata AS metadata_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.filesize AS filesize_10,
  t0.url AS url_11,
  t0.original_filename AS original_filename_12,
  t0.deleted AS deleted_13,
  t0.removed_from_file_system AS removed_from_file_system_14,
  t0.id AS id_15,
  t0.folder_id AS folder_id_16
FROM
  kuma_media t0
WHERE
  t0.id = ?

SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.description AS description_3, t0.copyright AS copyright_4, t0.location AS location_5, t0.content_type AS content_type_6, t0.metadata AS metadata_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.filesize AS filesize_10, t0.url AS url_11, t0.original_filename AS original_filename_12, t0.deleted AS deleted_13, t0.removed_from_file_system AS removed_from_file_system_14, t0.id AS id_15, t0.folder_id AS folder_id_16 FROM kuma_media t0 WHERE t0.id = '13';