Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.type AS type_1,
          p0_.caching_level AS caching_level_2,
          p0_.global_title AS global_title_3,
          p0_.global_description AS global_description_4,
          p0_.title AS title_5,
          p0_.description AS description_6,
          p0_.content_properties AS content_properties_7,
          p0_.locale AS locale_8,
          p0_.slices AS slices_9,
          p0_.breadcrumb AS breadcrumb_10,
          p0_.status AS status_11,
          p0_.update_comment AS update_comment_12,
          p0_.published AS published_13,
          p0_.expired AS expired_14,
          p0_.created AS created_15,
          p0_.updated AS updated_16,
          p0_.template AS template_17,
          p0_.visibility AS visibility_18,
          p0_.seo_title AS seo_title_19,
          p0_.seo_description AS seo_description_20,
          p0_.no_index AS no_index_21,
          p0_.no_follow AS no_follow_22,
          p0_.site_map AS site_map_23,
          p0_.og_title AS og_title_24,
          p0_.og_type AS og_type_25,
          p0_.og_description AS og_description_26,
          p0_.twitter_title AS twitter_title_27,
          p0_.twitter_description AS twitter_description_28,
          p0_.twitter_card AS twitter_card_29
        FROM
          page p0_
        WHERE
          p0_.type IN (?, ?, ?, ?, ?, ?)
          AND p0_.status = ?
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.caching_level AS caching_level_2, p0_.global_title AS global_title_3, p0_.global_description AS global_description_4, p0_.title AS title_5, p0_.description AS description_6, p0_.content_properties AS content_properties_7, p0_.locale AS locale_8, p0_.slices AS slices_9, p0_.breadcrumb AS breadcrumb_10, p0_.status AS status_11, p0_.update_comment AS update_comment_12, p0_.published AS published_13, p0_.expired AS expired_14, p0_.created AS created_15, p0_.updated AS updated_16, p0_.template AS template_17, p0_.visibility AS visibility_18, p0_.seo_title AS seo_title_19, p0_.seo_description AS seo_description_20, p0_.no_index AS no_index_21, p0_.no_follow AS no_follow_22, p0_.site_map AS site_map_23, p0_.og_title AS og_title_24, p0_.og_type AS og_type_25, p0_.og_description AS og_description_26, p0_.twitter_title AS twitter_title_27, p0_.twitter_description AS twitter_description_28, p0_.twitter_card AS twitter_card_29 FROM page p0_ WHERE p0_.type IN ('barometer-activity', 'activity-report', 'study', 'thematic-brochure', 'practical-guide', 'btob-news') AND p0_.status = 'published') dctrn_result) dctrn_table;

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.locale AS locale_2,
  p0_.path AS path_3,
  p0_.page_id AS page_id_4
FROM
  path p0_
WHERE
  p0_.path = ?
  AND p0_.locale = ?

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.locale AS locale_2, p0_.path AS path_3, p0_.page_id AS page_id_4 FROM path p0_ WHERE p0_.path = 'nos-publications' AND p0_.locale = 'fr';

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.caching_level AS caching_level_3,
  t0.global_title AS global_title_4,
  t0.global_description AS global_description_5,
  t0.title AS title_6,
  t0.description AS description_7,
  t0.content_properties AS content_properties_8,
  t0.locale AS locale_9,
  t0.slices AS slices_10,
  t0.breadcrumb AS breadcrumb_11,
  t0.status AS status_12,
  t0.update_comment AS update_comment_13,
  t0.published AS published_14,
  t0.expired AS expired_15,
  t0.created AS created_16,
  t0.updated AS updated_17,
  t0.template AS template_18,
  t0.visibility AS visibility_19,
  t0.seo_title AS seo_title_20,
  t0.seo_description AS seo_description_21,
  t0.no_index AS no_index_22,
  t0.no_follow AS no_follow_23,
  t0.site_map AS site_map_24,
  t0.og_title AS og_title_25,
  t0.og_type AS og_type_26,
  t0.og_description AS og_description_27,
  t0.twitter_title AS twitter_title_28,
  t0.twitter_description AS twitter_description_29,
  t0.twitter_card AS twitter_card_30,
  t0.master_id AS master_id_31,
  t0.lastPublisher_id AS lastPublisher_id_32,
  t0.author_id AS author_id_33,
  t0.lastUpdater_id AS lastUpdater_id_34,
  t0.ogImage_id AS ogImage_id_35,
  t0.twitterImage_id AS twitterImage_id_36
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.caching_level AS caching_level_3, t0.global_title AS global_title_4, t0.global_description AS global_description_5, t0.title AS title_6, t0.description AS description_7, t0.content_properties AS content_properties_8, t0.locale AS locale_9, t0.slices AS slices_10, t0.breadcrumb AS breadcrumb_11, t0.status AS status_12, t0.update_comment AS update_comment_13, t0.published AS published_14, t0.expired AS expired_15, t0.created AS created_16, t0.updated AS updated_17, t0.template AS template_18, t0.visibility AS visibility_19, t0.seo_title AS seo_title_20, t0.seo_description AS seo_description_21, t0.no_index AS no_index_22, t0.no_follow AS no_follow_23, t0.site_map AS site_map_24, t0.og_title AS og_title_25, t0.og_type AS og_type_26, t0.og_description AS og_description_27, t0.twitter_title AS twitter_title_28, t0.twitter_description AS twitter_description_29, t0.twitter_card AS twitter_card_30, t0.master_id AS master_id_31, t0.lastPublisher_id AS lastPublisher_id_32, t0.author_id AS author_id_33, t0.lastUpdater_id AS lastUpdater_id_34, t0.ogImage_id AS ogImage_id_35, t0.twitterImage_id AS twitterImage_id_36 FROM page t0 WHERE t0.id = 19;