Symfony Profiler

SELECT
  t0.rna AS rna_1,
  t0.id AS id_2,
  t0.phone AS phone_3,
  t0.email AS email_4,
  t0.address_street AS address_street_5,
  t0.zipcode AS zipcode_6,
  t0.city AS city_7,
  t0.legal_site_name AS legal_site_name_8,
  t0.legal_siret AS legal_siret_9,
  t0.legal_siren AS legal_siren_10,
  t0.legal_rcs AS legal_rcs_11,
  t0.legal_address AS legal_address_12,
  t0.legal_zipcode AS legal_zipcode_13,
  t0.legal_city AS legal_city_14,
  t0.legal_phone AS legal_phone_15,
  t0.legal_email AS legal_email_16,
  t0.legal_publication_owner AS legal_publication_owner_17,
  t0.legal_site_url AS legal_site_url_18,
  t0.default_title AS default_title_19,
  t0.default_meta_desc AS default_meta_desc_20
FROM
  site_settings t0

SELECT t0.rna AS rna_1, t0.id AS id_2, t0.phone AS phone_3, t0.email AS email_4, t0.address_street AS address_street_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.legal_site_name AS legal_site_name_8, t0.legal_siret AS legal_siret_9, t0.legal_siren AS legal_siren_10, t0.legal_rcs AS legal_rcs_11, t0.legal_address AS legal_address_12, t0.legal_zipcode AS legal_zipcode_13, t0.legal_city AS legal_city_14, t0.legal_phone AS legal_phone_15, t0.legal_email AS legal_email_16, t0.legal_publication_owner AS legal_publication_owner_17, t0.legal_site_url AS legal_site_url_18, t0.default_title AS default_title_19, t0.default_meta_desc AS default_meta_desc_20 FROM site_settings t0;

SELECT
  t0.route AS route_1,
  t0.id AS id_2,
  t0.page_name AS page_name_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.route AS route_1, t0.id AS id_2, t0.page_name AS page_name_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_actuality_list' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.title AS title_1,
          a0_.resume AS resume_2,
          a0_.illustration_name AS illustration_name_3,
          a0_.illustration_size AS illustration_size_4,
          a0_.illustration_updated_at AS illustration_updated_at_5,
          a0_.illustration_alt AS illustration_alt_6,
          a0_.activate AS activate_7,
          a0_.quote AS quote_8,
          a0_.created_at AS created_at_9,
          a0_.about_associate AS about_associate_10,
          a0_.composition_associate AS composition_associate_11,
          a0_.full_member_associate AS full_member_associate_12,
          a0_.departement_associate AS departement_associate_13,
          a0_.partner_associate AS partner_associate_14,
          a0_.publication_associate AS publication_associate_15,
          a0_.these_associate AS these_associate_16,
          a0_.actuality_associate AS actuality_associate_17,
          a0_.definition_associate AS definition_associate_18,
          a0_.manuel_associate AS manuel_associate_19,
          a0_.join_associate AS join_associate_20,
          a0_.old_id AS old_id_21,
          a0_.meta_title AS meta_title_22,
          a0_.meta_description AS meta_description_23,
          a0_.slug AS slug_24,
          a1_.id AS id_25,
          a1_.name AS name_26,
          a1_.old_id AS old_id_27,
          a1_.slug AS slug_28
        FROM
          actuality a0_
          LEFT JOIN actuality_category a1_ ON a0_.category_id = a1_.id
        WHERE
          a0_.activate = 1
          AND a1_.slug = ?
        ORDER BY
          a0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.resume AS resume_2, a0_.illustration_name AS illustration_name_3, a0_.illustration_size AS illustration_size_4, a0_.illustration_updated_at AS illustration_updated_at_5, a0_.illustration_alt AS illustration_alt_6, a0_.activate AS activate_7, a0_.quote AS quote_8, a0_.created_at AS created_at_9, a0_.about_associate AS about_associate_10, a0_.composition_associate AS composition_associate_11, a0_.full_member_associate AS full_member_associate_12, a0_.departement_associate AS departement_associate_13, a0_.partner_associate AS partner_associate_14, a0_.publication_associate AS publication_associate_15, a0_.these_associate AS these_associate_16, a0_.actuality_associate AS actuality_associate_17, a0_.definition_associate AS definition_associate_18, a0_.manuel_associate AS manuel_associate_19, a0_.join_associate AS join_associate_20, a0_.old_id AS old_id_21, a0_.meta_title AS meta_title_22, a0_.meta_description AS meta_description_23, a0_.slug AS slug_24, a1_.id AS id_25, a1_.name AS name_26, a1_.old_id AS old_id_27, a1_.slug AS slug_28 FROM actuality a0_ LEFT JOIN actuality_category a1_ ON a0_.category_id = a1_.id WHERE a0_.activate = 1 AND a1_.slug = 'obfsm:c2ZtZ0BzZm1nLm9yZw==' ORDER BY a0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.old_id AS old_id_3,
  t0.slug AS slug_4
FROM
  actuality_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.old_id AS old_id_3, t0.slug AS slug_4 FROM actuality_category t0 WHERE t0.slug = 'obfsm:c2ZtZ0BzZm1nLm9yZw==' LIMIT 1;

SELECT
  t0.route AS route_1,
  t0.id AS id_2,
  t0.page_name AS page_name_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 IS NULL
LIMIT
  1

SELECT t0.route AS route_1, t0.id AS id_2, t0.page_name AS page_name_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 IS NULL LIMIT 1;