Symfony Profiler

SELECT
  s0_.deleted_at AS deleted_at_0,
  s0_.hidden AS hidden_1,
  s0_.position AS position_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4,
  s0_.id AS id_5,
  s0_.name AS name_6,
  s0_.domain AS domain_7,
  s0_.recaptcha_public_key AS recaptcha_public_key_8,
  s0_.recaptcha_secret_key AS recaptcha_secret_key_9,
  s0_.owner AS owner_10,
  s0_.siret AS siret_11,
  s0_.intracommunity_vat AS intracommunity_vat_12,
  s0_.rcs AS rcs_13,
  s0_.capital AS capital_14,
  s0_.registered_office AS registered_office_15,
  s0_.cmp AS cmp_16,
  s0_.map_embed AS map_embed_17,
  s0_.meta_title AS meta_title_18,
  s0_.meta_description AS meta_description_19,
  s0_.theme_slug AS theme_slug_20,
  s0_.custom_css AS custom_css_21,
  s0_.enabled AS enabled_22,
  s0_.created_by_id AS created_by_id_23,
  s0_.updated_by_id AS updated_by_id_24,
  s0_.default_language_id AS default_language_id_25,
  s0_.license_id AS license_id_26
FROM
  site s0_
WHERE
  (s0_.domain = ?)
  AND (s0_.deleted_at IS NULL)

SELECT s0_.deleted_at AS deleted_at_0, s0_.hidden AS hidden_1, s0_.position AS position_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.id AS id_5, s0_.name AS name_6, s0_.domain AS domain_7, s0_.recaptcha_public_key AS recaptcha_public_key_8, s0_.recaptcha_secret_key AS recaptcha_secret_key_9, s0_.owner AS owner_10, s0_.siret AS siret_11, s0_.intracommunity_vat AS intracommunity_vat_12, s0_.rcs AS rcs_13, s0_.capital AS capital_14, s0_.registered_office AS registered_office_15, s0_.cmp AS cmp_16, s0_.map_embed AS map_embed_17, s0_.meta_title AS meta_title_18, s0_.meta_description AS meta_description_19, s0_.theme_slug AS theme_slug_20, s0_.custom_css AS custom_css_21, s0_.enabled AS enabled_22, s0_.created_by_id AS created_by_id_23, s0_.updated_by_id AS updated_by_id_24, s0_.default_language_id AS default_language_id_25, s0_.license_id AS license_id_26 FROM site s0_ WHERE (s0_.domain = 'preprod.apop-france.com') AND (s0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.position AS position_5,
  t0.hidden AS hidden_6,
  t0.enabled AS enabled_7,
  t0.site_id AS site_id_8
FROM
  menu t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.site_id AS site_id_8 FROM menu t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  DISTINCT id_0,
  MIN(sclr_10) AS dctrn_minrownum
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.created_at AS created_at_1,
      p0_.updated_at AS updated_at_2,
      p0_.deleted_at AS deleted_at_3,
      p0_.position AS position_4,
      p0_.hidden AS hidden_5,
      p0_.enabled AS enabled_6,
      p0_.tree_left AS tree_left_7,
      p0_.tree_right AS tree_right_8,
      p0_.tree_level AS tree_level_9,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.id DESC
      ) AS sclr_10
    FROM
      page p0_
      INNER JOIN page_module p2_ ON p0_.id = p2_.page_id
      INNER JOIN module m1_ ON m1_.id = p2_.module_id
      AND (m1_.deleted_at IS NULL)
    WHERE
      (m1_.id = ?)
      AND (p0_.deleted_at IS NULL)
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  3

SELECT DISTINCT id_0, MIN(sclr_10) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.deleted_at AS deleted_at_3, p0_.position AS position_4, p0_.hidden AS hidden_5, p0_.enabled AS enabled_6, p0_.tree_left AS tree_left_7, p0_.tree_right AS tree_right_8, p0_.tree_level AS tree_level_9, ROW_NUMBER() OVER(ORDER BY p0_.id DESC) AS sclr_10 FROM page p0_ INNER JOIN page_module p2_ ON p0_.id = p2_.page_id INNER JOIN module m1_ ON m1_.id = p2_.module_id AND (m1_.deleted_at IS NULL) WHERE (m1_.id = 1) AND (p0_.deleted_at IS NULL)) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.id AS id_2
FROM
  document_site_extension t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id AS id_2 FROM document_site_extension t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  zone t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM zone t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.position AS position_5,
  t0.hidden AS hidden_6,
  t0.enabled AS enabled_7,
  t0.title AS title_8,
  t0.menu_id AS menu_id_9,
  t0.zone_id AS zone_id_10
FROM
  menu_zone t0
WHERE
  t0.zone_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.title AS title_8, t0.menu_id AS menu_id_9, t0.zone_id AS zone_id_10 FROM menu_zone t0 WHERE t0.zone_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.id AS id_2
FROM
  gallery_site_extension t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id AS id_2 FROM gallery_site_extension t0 WHERE t0.id = 5;

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.hidden AS hidden_2,
  t0.position AS position_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.address AS address_6,
  t0.address2 AS address2_7,
  t0.city AS city_8,
  t0.fax AS fax_9,
  t0.id AS id_10,
  t0.name AS name_11,
  t0.phone AS phone_12,
  t0.portable AS portable_13,
  t0.type AS type_14,
  t0.zipcode AS zipcode_15,
  t0.country AS country_16,
  t0.company AS company_17,
  t0.contact_mail AS contact_mail_18,
  t0.mail_tester AS mail_tester_19,
  t0.schedules AS schedules_20,
  t0.created_by_id AS created_by_id_21,
  t0.updated_by_id AS updated_by_id_22,
  t0.site_id AS site_id_23
FROM
  site_address t0
WHERE
  t0.site_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.address AS address_6, t0.address2 AS address2_7, t0.city AS city_8, t0.fax AS fax_9, t0.id AS id_10, t0.name AS name_11, t0.phone AS phone_12, t0.portable AS portable_13, t0.type AS type_14, t0.zipcode AS zipcode_15, t0.country AS country_16, t0.company AS company_17, t0.contact_mail AS contact_mail_18, t0.mail_tester AS mail_tester_19, t0.schedules AS schedules_20, t0.created_by_id AS created_by_id_21, t0.updated_by_id AS updated_by_id_22, t0.site_id AS site_id_23 FROM site_address t0 WHERE t0.site_id = 5 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.position AS position_5,
  t0.hidden AS hidden_6,
  t0.enabled AS enabled_7,
  t0.upload_path AS upload_path_8,
  t0.code AS code_9
FROM
  module t0
WHERE
  t0.code = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.position AS position_5, t0.hidden AS hidden_6, t0.enabled AS enabled_7, t0.upload_path AS upload_path_8, t0.code AS code_9 FROM module t0 WHERE t0.code = 'news' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id AS id_2
FROM
  team_site_extension t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id AS id_2 FROM team_site_extension t0 WHERE t0.id = 5;

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.hidden AS hidden_2,
  t0.position AS position_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.url AS url_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.site_id AS site_id_10,
  t0.social_media_id AS social_media_id_11
FROM
  site_social_media t0
WHERE
  t0.site_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.url AS url_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.site_id AS site_id_10, t0.social_media_id AS social_media_id_11 FROM site_social_media t0 WHERE t0.site_id = 5 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.id AS id_2
FROM
  faq_site_extension t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id AS id_2 FROM faq_site_extension t0 WHERE t0.id = 5;

SELECT
  p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  p0_.updated_at AS updated_at_2,
  p0_.deleted_at AS deleted_at_3,
  p0_.position AS position_4,
  p0_.hidden AS hidden_5,
  p0_.enabled AS enabled_6,
  p0_.tree_left AS tree_left_7,
  p0_.tree_right AS tree_right_8,
  p0_.tree_level AS tree_level_9,
  p0_.parent_id AS parent_id_10,
  p0_.site_id AS site_id_11,
  p0_.root_id AS root_id_12
FROM
  page p0_
  INNER JOIN page_module p2_ ON p0_.id = p2_.page_id
  INNER JOIN module m1_ ON m1_.id = p2_.module_id
  AND (m1_.deleted_at IS NULL)
WHERE
  (
    m1_.id = ?
    AND p0_.id IN (?)
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.deleted_at AS deleted_at_3, p0_.position AS position_4, p0_.hidden AS hidden_5, p0_.enabled AS enabled_6, p0_.tree_left AS tree_left_7, p0_.tree_right AS tree_right_8, p0_.tree_level AS tree_level_9, p0_.parent_id AS parent_id_10, p0_.site_id AS site_id_11, p0_.root_id AS root_id_12 FROM page p0_ INNER JOIN page_module p2_ ON p0_.id = p2_.page_id INNER JOIN module m1_ ON m1_.id = p2_.module_id AND (m1_.deleted_at IS NULL) WHERE (m1_.id = 1 AND p0_.id IN (9)) AND (p0_.deleted_at IS NULL) ORDER BY p0_.id DESC;