Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.title AS title_1,
          r0_.summary AS summary_2,
          r0_.export AS export_3,
          r0_.gallery_over_title AS gallery_over_title_4,
          r0_.gallery_title AS gallery_title_5,
          r0_.gallery_content AS gallery_content_6,
          r0_.picture_name AS picture_name_7,
          r0_.picture_size AS picture_size_8,
          r0_.picture_updated_at AS picture_updated_at_9,
          r0_.picture_alt AS picture_alt_10,
          r0_.published_at AS published_at_11,
          r0_.created_at AS created_at_12,
          r0_.meta_title AS meta_title_13,
          r0_.meta_description AS meta_description_14,
          r0_.slug AS slug_15,
          r0_.is_published AS is_published_16
        FROM
          reference r0_
        WHERE
          r0_.is_published = 1
          AND EXISTS (
            SELECT
              1
            FROM
              reference_category_link r1_
            WHERE
              r1_.reference_id = r0_.id
              AND r1_.reference_category_id IN (?)
          )
          AND r0_.sub_category_id = ?
        ORDER BY
          r0_.published_at DESC,
          r0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.summary AS summary_2, r0_.export AS export_3, r0_.gallery_over_title AS gallery_over_title_4, r0_.gallery_title AS gallery_title_5, r0_.gallery_content AS gallery_content_6, r0_.picture_name AS picture_name_7, r0_.picture_size AS picture_size_8, r0_.picture_updated_at AS picture_updated_at_9, r0_.picture_alt AS picture_alt_10, r0_.published_at AS published_at_11, r0_.created_at AS created_at_12, r0_.meta_title AS meta_title_13, r0_.meta_description AS meta_description_14, r0_.slug AS slug_15, r0_.is_published AS is_published_16 FROM reference r0_ WHERE r0_.is_published = 1 AND EXISTS (SELECT 1 FROM reference_category_link r1_ WHERE r1_.reference_id = r0_.id AND r1_.reference_category_id IN (3)) AND r0_.sub_category_id = 2 ORDER BY r0_.published_at DESC, r0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.position AS position_5,
  t0.slug AS slug_6
FROM
  reference_category t0
  INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_category_id
WHERE
  reference_category_link.reference_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.position AS position_5, t0.slug AS slug_6 FROM reference_category t0 INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_category_id WHERE reference_category_link.reference_id = 5 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.summary AS summary_3,
  t0.export AS export_4,
  t0.gallery_over_title AS gallery_over_title_5,
  t0.gallery_title AS gallery_title_6,
  t0.gallery_content AS gallery_content_7,
  t0.picture_name AS picture_name_8,
  t0.picture_size AS picture_size_9,
  t0.picture_updated_at AS picture_updated_at_10,
  t0.picture_alt AS picture_alt_11,
  t0.published_at AS published_at_12,
  t0.created_at AS created_at_13,
  t0.meta_title AS meta_title_14,
  t0.meta_description AS meta_description_15,
  t0.slug AS slug_16,
  t0.is_published AS is_published_17,
  t0.sub_category_id AS sub_category_id_18,
  t0.homepage_id AS homepage_id_19
FROM
  reference t0
  INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_id
WHERE
  reference_category_link.reference_category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.export AS export_4, t0.gallery_over_title AS gallery_over_title_5, t0.gallery_title AS gallery_title_6, t0.gallery_content AS gallery_content_7, t0.picture_name AS picture_name_8, t0.picture_size AS picture_size_9, t0.picture_updated_at AS picture_updated_at_10, t0.picture_alt AS picture_alt_11, t0.published_at AS published_at_12, t0.created_at AS created_at_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16, t0.is_published AS is_published_17, t0.sub_category_id AS sub_category_id_18, t0.homepage_id AS homepage_id_19 FROM reference t0 INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_id WHERE reference_category_link.reference_category_id = 3;

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.summary AS summary_2,
  r0_.export AS export_3,
  r0_.gallery_over_title AS gallery_over_title_4,
  r0_.gallery_title AS gallery_title_5,
  r0_.gallery_content AS gallery_content_6,
  r0_.picture_name AS picture_name_7,
  r0_.picture_size AS picture_size_8,
  r0_.picture_updated_at AS picture_updated_at_9,
  r0_.picture_alt AS picture_alt_10,
  r0_.published_at AS published_at_11,
  r0_.created_at AS created_at_12,
  r0_.meta_title AS meta_title_13,
  r0_.meta_description AS meta_description_14,
  r0_.slug AS slug_15,
  r0_.is_published AS is_published_16,
  r0_.sub_category_id AS sub_category_id_17,
  r0_.homepage_id AS homepage_id_18
FROM
  reference r0_
WHERE
  r0_.is_published = 1
  AND EXISTS (
    SELECT
      1
    FROM
      reference_category_link r1_
    WHERE
      r1_.reference_id = r0_.id
      AND r1_.reference_category_id IN (?)
  )
  AND r0_.sub_category_id = ?
  AND r0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  r0_.published_at DESC,
  r0_.created_at DESC

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.summary AS summary_2, r0_.export AS export_3, r0_.gallery_over_title AS gallery_over_title_4, r0_.gallery_title AS gallery_title_5, r0_.gallery_content AS gallery_content_6, r0_.picture_name AS picture_name_7, r0_.picture_size AS picture_size_8, r0_.picture_updated_at AS picture_updated_at_9, r0_.picture_alt AS picture_alt_10, r0_.published_at AS published_at_11, r0_.created_at AS created_at_12, r0_.meta_title AS meta_title_13, r0_.meta_description AS meta_description_14, r0_.slug AS slug_15, r0_.is_published AS is_published_16, r0_.sub_category_id AS sub_category_id_17, r0_.homepage_id AS homepage_id_18 FROM reference r0_ WHERE r0_.is_published = 1 AND EXISTS (SELECT 1 FROM reference_category_link r1_ WHERE r1_.reference_id = r0_.id AND r1_.reference_category_id IN (3)) AND r0_.sub_category_id = 2 AND r0_.id IN (5, 7, 12, 3, 1) ORDER BY r0_.published_at DESC, r0_.created_at DESC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      published_at_11,
      created_at_12
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.title AS title_1,
          r0_.summary AS summary_2,
          r0_.export AS export_3,
          r0_.gallery_over_title AS gallery_over_title_4,
          r0_.gallery_title AS gallery_title_5,
          r0_.gallery_content AS gallery_content_6,
          r0_.picture_name AS picture_name_7,
          r0_.picture_size AS picture_size_8,
          r0_.picture_updated_at AS picture_updated_at_9,
          r0_.picture_alt AS picture_alt_10,
          r0_.published_at AS published_at_11,
          r0_.created_at AS created_at_12,
          r0_.meta_title AS meta_title_13,
          r0_.meta_description AS meta_description_14,
          r0_.slug AS slug_15,
          r0_.is_published AS is_published_16
        FROM
          reference r0_
        WHERE
          r0_.is_published = 1
          AND EXISTS (
            SELECT
              1
            FROM
              reference_category_link r1_
            WHERE
              r1_.reference_id = r0_.id
              AND r1_.reference_category_id IN (?)
          )
          AND r0_.sub_category_id = ?
      ) dctrn_result_inner
    ORDER BY
      published_at_11 DESC,
      created_at_12 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_11, created_at_12 FROM (SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.summary AS summary_2, r0_.export AS export_3, r0_.gallery_over_title AS gallery_over_title_4, r0_.gallery_title AS gallery_title_5, r0_.gallery_content AS gallery_content_6, r0_.picture_name AS picture_name_7, r0_.picture_size AS picture_size_8, r0_.picture_updated_at AS picture_updated_at_9, r0_.picture_alt AS picture_alt_10, r0_.published_at AS published_at_11, r0_.created_at AS created_at_12, r0_.meta_title AS meta_title_13, r0_.meta_description AS meta_description_14, r0_.slug AS slug_15, r0_.is_published AS is_published_16 FROM reference r0_ WHERE r0_.is_published = 1 AND EXISTS (SELECT 1 FROM reference_category_link r1_ WHERE r1_.reference_id = r0_.id AND r1_.reference_category_id IN (3)) AND r0_.sub_category_id = 2) dctrn_result_inner ORDER BY published_at_11 DESC, created_at_12 DESC) dctrn_result LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.page_name AS page_name_2,
  t0.route AS route_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.h1_enabled AS h1_enabled_6,
  t0.h1 AS h1_7
FROM
  seopage t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7 FROM seopage t0 WHERE t0.route = 'app_reference_list_category_sub' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.position AS position_5,
  t0.slug AS slug_6
FROM
  reference_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.position AS position_5, t0.slug AS slug_6 FROM reference_category t0 WHERE t0.slug = 'batiments-tertiaires-menuiseries-aluminium' LIMIT 1;

SELECT
  t0.position AS position_1,
  t0.id AS id_2,
  t0.over_title AS over_title_3,
  t0.title AS title_4,
  t0.summary AS summary_5,
  t0.picture_name AS picture_name_6,
  t0.picture_size AS picture_size_7,
  t0.picture_updated_at AS picture_updated_at_8,
  t0.picture_alt AS picture_alt_9,
  t0.card_section_title AS card_section_title_10,
  t0.regulations_title AS regulations_title_11,
  t0.refs_title AS refs_title_12,
  t0.last_block_title AS last_block_title_13,
  t0.last_block_summary AS last_block_summary_14,
  t0.last_block_link_title AS last_block_link_title_15,
  t0.last_block_link_target AS last_block_link_target_16,
  t0.meta_title AS meta_title_17,
  t0.meta_description AS meta_description_18,
  t0.slug AS slug_19,
  t0.category_id AS category_id_20
FROM
  activity t0
ORDER BY
  t0.position ASC

SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.address_street AS address_street_4,
  t0.zipcode AS zipcode_5,
  t0.city AS city_6,
  t0.legal_site_name AS legal_site_name_7,
  t0.legal_siret AS legal_siret_8,
  t0.legal_siren AS legal_siren_9,
  t0.legal_rcs AS legal_rcs_10,
  t0.legal_address AS legal_address_11,
  t0.legal_zipcode AS legal_zipcode_12,
  t0.legal_city AS legal_city_13,
  t0.legal_phone AS legal_phone_14,
  t0.legal_email AS legal_email_15,
  t0.legal_publication_owner AS legal_publication_owner_16,
  t0.legal_site_url AS legal_site_url_17,
  t0.default_title AS default_title_18,
  t0.default_meta_desc AS default_meta_desc_19,
  t0.global_activity_description AS global_activity_description_20
FROM
  site_settings t0

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19, t0.global_activity_description AS global_activity_description_20 FROM site_settings t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.over_title AS over_title_3,
  t0.title AS title_4,
  t0.summary AS summary_5,
  t0.picture_name AS picture_name_6,
  t0.picture_size AS picture_size_7,
  t0.picture_updated_at AS picture_updated_at_8,
  t0.picture_alt AS picture_alt_9,
  t0.icon_name AS icon_name_10,
  t0.icon_size AS icon_size_11,
  t0.icon_updated_at AS icon_updated_at_12,
  t0.icon_alt AS icon_alt_13,
  t0.card_section_title AS card_section_title_14,
  t0.last_block_title AS last_block_title_15,
  t0.last_block_summary AS last_block_summary_16,
  t0.last_block_picture_name AS last_block_picture_name_17,
  t0.last_block_picture_size AS last_block_picture_size_18,
  t0.last_block_picture_updated_at AS last_block_picture_updated_at_19,
  t0.last_block_picture_alt AS last_block_picture_alt_20,
  t0.last_block_link_title AS last_block_link_title_21,
  t0.last_block_link_target AS last_block_link_target_22,
  t0.meta_title AS meta_title_23,
  t0.meta_description AS meta_description_24,
  t0.slug AS slug_25
FROM
  building_type t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.icon_name AS icon_name_10, t0.icon_size AS icon_size_11, t0.icon_updated_at AS icon_updated_at_12, t0.icon_alt AS icon_alt_13, t0.card_section_title AS card_section_title_14, t0.last_block_title AS last_block_title_15, t0.last_block_summary AS last_block_summary_16, t0.last_block_picture_name AS last_block_picture_name_17, t0.last_block_picture_size AS last_block_picture_size_18, t0.last_block_picture_updated_at AS last_block_picture_updated_at_19, t0.last_block_picture_alt AS last_block_picture_alt_20, t0.last_block_link_title AS last_block_link_title_21, t0.last_block_link_target AS last_block_link_target_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25 FROM building_type t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.position AS position_5,
  t0.slug AS slug_6
FROM
  reference_category t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.position AS position_5, t0.slug AS slug_6 FROM reference_category t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6
FROM
  reference_sub_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6 FROM reference_sub_category t0 WHERE t0.slug = 'menuiserie-aluminium-renovation' LIMIT 1;

SELECT
  t0.position AS position_1,
  t0.id AS id_2,
  t0.over_title AS over_title_3,
  t0.title AS title_4,
  t0.summary AS summary_5,
  t0.picture_name AS picture_name_6,
  t0.picture_size AS picture_size_7,
  t0.picture_updated_at AS picture_updated_at_8,
  t0.picture_alt AS picture_alt_9,
  t0.card_section_title AS card_section_title_10,
  t0.regulations_title AS regulations_title_11,
  t0.refs_title AS refs_title_12,
  t0.last_block_title AS last_block_title_13,
  t0.last_block_summary AS last_block_summary_14,
  t0.last_block_link_title AS last_block_link_title_15,
  t0.last_block_link_target AS last_block_link_target_16,
  t0.meta_title AS meta_title_17,
  t0.meta_description AS meta_description_18,
  t0.slug AS slug_19,
  t0.category_id AS category_id_20
FROM
  activity t0

SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6
FROM
  reference_sub_category t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6 FROM reference_sub_category t0;