Symfony Profiler

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,
  t0.meta_title_en AS meta_title_en_8,
  t0.meta_description_en AS meta_description_en_9,
  t0.h1_en AS h1_en_10
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, t0.meta_title_en AS meta_title_en_8, t0.meta_description_en AS meta_description_en_9, t0.h1_en AS h1_en_10 FROM seopage t0 WHERE t0.route = 'app_post_list' LIMIT 1;

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
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 FROM site_settings t0;

SELECT
  t0.id AS id_1,
  t0.banner_name AS banner_name_2,
  t0.banner_size AS banner_size_3,
  t0.banner_updated_at AS banner_updated_at_4,
  t0.h1 AS h1_5,
  t0.h1_en AS h1_en_6,
  t0.meta_title_en AS meta_title_en_7,
  t0.meta_description_en AS meta_description_en_8,
  t0.meta_title AS meta_title_9,
  t0.meta_description AS meta_description_10
FROM
  post_page t0

SELECT t0.id AS id_1, t0.banner_name AS banner_name_2, t0.banner_size AS banner_size_3, t0.banner_updated_at AS banner_updated_at_4, t0.h1 AS h1_5, t0.h1_en AS h1_en_6, t0.meta_title_en AS meta_title_en_7, t0.meta_description_en AS meta_description_en_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10 FROM post_page t0;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.published AS published_1,
          p0_.recruitment AS recruitment_2,
          p0_.date AS date_3,
          p0_.title_fr AS title_fr_4,
          p0_.title_en AS title_en_5,
          p0_.image_name AS image_name_6,
          p0_.image_size AS image_size_7,
          p0_.image_updated_at AS image_updated_at_8,
          p0_.image_alt_fr AS image_alt_fr_9,
          p0_.image_alt_en AS image_alt_en_10,
          p0_.intro_fr AS intro_fr_11,
          p0_.intro_en AS intro_en_12,
          p0_.slug_en AS slug_en_13,
          p0_.h1 AS h1_14,
          p0_.h1_en AS h1_en_15,
          p0_.meta_title_en AS meta_title_en_16,
          p0_.meta_description_en AS meta_description_en_17,
          p0_.meta_title AS meta_title_18,
          p0_.meta_description AS meta_description_19,
          p0_.slug AS slug_20
        FROM
          post p0_
        WHERE
          p0_.published = 1
        ORDER BY
          p0_.date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.published AS published_1, p0_.recruitment AS recruitment_2, p0_.date AS date_3, p0_.title_fr AS title_fr_4, p0_.title_en AS title_en_5, p0_.image_name AS image_name_6, p0_.image_size AS image_size_7, p0_.image_updated_at AS image_updated_at_8, p0_.image_alt_fr AS image_alt_fr_9, p0_.image_alt_en AS image_alt_en_10, p0_.intro_fr AS intro_fr_11, p0_.intro_en AS intro_en_12, p0_.slug_en AS slug_en_13, p0_.h1 AS h1_14, p0_.h1_en AS h1_en_15, p0_.meta_title_en AS meta_title_en_16, p0_.meta_description_en AS meta_description_en_17, p0_.meta_title AS meta_title_18, p0_.meta_description AS meta_description_19, p0_.slug AS slug_20 FROM post p0_ WHERE p0_.published = 1 ORDER BY p0_.date DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_en AS title_en_3,
  t0.image_name AS image_name_4,
  t0.image_size AS image_size_5,
  t0.image_updated_at AS image_updated_at_6,
  t0.image_alt_fr AS image_alt_fr_7,
  t0.image_alt_en AS image_alt_en_8,
  t0.logo_name AS logo_name_9,
  t0.logo_size AS logo_size_10,
  t0.logo_updated_at AS logo_updated_at_11,
  t0.logo_alt_fr AS logo_alt_fr_12,
  t0.logo_alt_en AS logo_alt_en_13,
  t0.intro_fr AS intro_fr_14,
  t0.intro_en AS intro_en_15,
  t0.content_fr AS content_fr_16,
  t0.content_en AS content_en_17,
  t0.slug_en AS slug_en_18,
  t0.h1 AS h1_19,
  t0.h1_en AS h1_en_20,
  t0.meta_title_en AS meta_title_en_21,
  t0.meta_description_en AS meta_description_en_22,
  t0.meta_title AS meta_title_23,
  t0.meta_description AS meta_description_24,
  t0.slug AS slug_25,
  t0.position AS position_26
FROM
  application t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5, t0.image_updated_at AS image_updated_at_6, t0.image_alt_fr AS image_alt_fr_7, t0.image_alt_en AS image_alt_en_8, t0.logo_name AS logo_name_9, t0.logo_size AS logo_size_10, t0.logo_updated_at AS logo_updated_at_11, t0.logo_alt_fr AS logo_alt_fr_12, t0.logo_alt_en AS logo_alt_en_13, t0.intro_fr AS intro_fr_14, t0.intro_en AS intro_en_15, t0.content_fr AS content_fr_16, t0.content_en AS content_en_17, t0.slug_en AS slug_en_18, t0.h1 AS h1_19, t0.h1_en AS h1_en_20, t0.meta_title_en AS meta_title_en_21, t0.meta_description_en AS meta_description_en_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25, t0.position AS position_26 FROM application t0 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.image_updated_at AS image_updated_at_4,
  t0.image_alt_fr AS image_alt_fr_5,
  t0.image_alt_en AS image_alt_en_6,
  t0.title_fr AS title_fr_7,
  t0.title_en AS title_en_8,
  t0.intro_fr AS intro_fr_9,
  t0.intro_en AS intro_en_10,
  t0.content_fr AS content_fr_11,
  t0.content_en AS content_en_12,
  t0.documentation_intro_fr AS documentation_intro_fr_13,
  t0.documentation_intro_en AS documentation_intro_en_14,
  t0.slug_en AS slug_en_15,
  t0.h1 AS h1_16,
  t0.h1_en AS h1_en_17,
  t0.meta_title_en AS meta_title_en_18,
  t0.meta_description_en AS meta_description_en_19,
  t0.meta_title AS meta_title_20,
  t0.meta_description AS meta_description_21,
  t0.slug AS slug_22,
  t0.position AS position_23
FROM
  product t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt_fr AS image_alt_fr_5, t0.image_alt_en AS image_alt_en_6, t0.title_fr AS title_fr_7, t0.title_en AS title_en_8, t0.intro_fr AS intro_fr_9, t0.intro_en AS intro_en_10, t0.content_fr AS content_fr_11, t0.content_en AS content_en_12, t0.documentation_intro_fr AS documentation_intro_fr_13, t0.documentation_intro_en AS documentation_intro_en_14, t0.slug_en AS slug_en_15, t0.h1 AS h1_16, t0.h1_en AS h1_en_17, t0.meta_title_en AS meta_title_en_18, t0.meta_description_en AS meta_description_en_19, t0.meta_title AS meta_title_20, t0.meta_description AS meta_description_21, t0.slug AS slug_22, t0.position AS position_23 FROM product t0 ORDER BY t0.position ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      date_3
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.published AS published_1,
          p0_.recruitment AS recruitment_2,
          p0_.date AS date_3,
          p0_.title_fr AS title_fr_4,
          p0_.title_en AS title_en_5,
          p0_.image_name AS image_name_6,
          p0_.image_size AS image_size_7,
          p0_.image_updated_at AS image_updated_at_8,
          p0_.image_alt_fr AS image_alt_fr_9,
          p0_.image_alt_en AS image_alt_en_10,
          p0_.intro_fr AS intro_fr_11,
          p0_.intro_en AS intro_en_12,
          p0_.slug_en AS slug_en_13,
          p0_.h1 AS h1_14,
          p0_.h1_en AS h1_en_15,
          p0_.meta_title_en AS meta_title_en_16,
          p0_.meta_description_en AS meta_description_en_17,
          p0_.meta_title AS meta_title_18,
          p0_.meta_description AS meta_description_19,
          p0_.slug AS slug_20
        FROM
          post p0_
        WHERE
          p0_.published = 1
      ) dctrn_result_inner
    ORDER BY
      date_3 DESC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_3 FROM (SELECT p0_.id AS id_0, p0_.published AS published_1, p0_.recruitment AS recruitment_2, p0_.date AS date_3, p0_.title_fr AS title_fr_4, p0_.title_en AS title_en_5, p0_.image_name AS image_name_6, p0_.image_size AS image_size_7, p0_.image_updated_at AS image_updated_at_8, p0_.image_alt_fr AS image_alt_fr_9, p0_.image_alt_en AS image_alt_en_10, p0_.intro_fr AS intro_fr_11, p0_.intro_en AS intro_en_12, p0_.slug_en AS slug_en_13, p0_.h1 AS h1_14, p0_.h1_en AS h1_en_15, p0_.meta_title_en AS meta_title_en_16, p0_.meta_description_en AS meta_description_en_17, p0_.meta_title AS meta_title_18, p0_.meta_description AS meta_description_19, p0_.slug AS slug_20 FROM post p0_ WHERE p0_.published = 1) dctrn_result_inner ORDER BY date_3 DESC) dctrn_result LIMIT 12;

SELECT
  p0_.id AS id_0,
  p0_.published AS published_1,
  p0_.recruitment AS recruitment_2,
  p0_.date AS date_3,
  p0_.title_fr AS title_fr_4,
  p0_.title_en AS title_en_5,
  p0_.image_name AS image_name_6,
  p0_.image_size AS image_size_7,
  p0_.image_updated_at AS image_updated_at_8,
  p0_.image_alt_fr AS image_alt_fr_9,
  p0_.image_alt_en AS image_alt_en_10,
  p0_.intro_fr AS intro_fr_11,
  p0_.intro_en AS intro_en_12,
  p0_.slug_en AS slug_en_13,
  p0_.h1 AS h1_14,
  p0_.h1_en AS h1_en_15,
  p0_.meta_title_en AS meta_title_en_16,
  p0_.meta_description_en AS meta_description_en_17,
  p0_.meta_title AS meta_title_18,
  p0_.meta_description AS meta_description_19,
  p0_.slug AS slug_20
FROM
  post p0_
WHERE
  p0_.published = 1
  AND p0_.id IN (?, ?)
ORDER BY
  p0_.date DESC

SELECT p0_.id AS id_0, p0_.published AS published_1, p0_.recruitment AS recruitment_2, p0_.date AS date_3, p0_.title_fr AS title_fr_4, p0_.title_en AS title_en_5, p0_.image_name AS image_name_6, p0_.image_size AS image_size_7, p0_.image_updated_at AS image_updated_at_8, p0_.image_alt_fr AS image_alt_fr_9, p0_.image_alt_en AS image_alt_en_10, p0_.intro_fr AS intro_fr_11, p0_.intro_en AS intro_en_12, p0_.slug_en AS slug_en_13, p0_.h1 AS h1_14, p0_.h1_en AS h1_en_15, p0_.meta_title_en AS meta_title_en_16, p0_.meta_description_en AS meta_description_en_17, p0_.meta_title AS meta_title_18, p0_.meta_description AS meta_description_19, p0_.slug AS slug_20 FROM post p0_ WHERE p0_.published = 1 AND p0_.id IN (3, 2) ORDER BY p0_.date DESC;

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_en AS title_en_3,
  t0.image_name AS image_name_4,
  t0.image_size AS image_size_5,
  t0.image_updated_at AS image_updated_at_6,
  t0.image_alt_fr AS image_alt_fr_7,
  t0.image_alt_en AS image_alt_en_8,
  t0.logo_name AS logo_name_9,
  t0.logo_size AS logo_size_10,
  t0.logo_updated_at AS logo_updated_at_11,
  t0.logo_alt_fr AS logo_alt_fr_12,
  t0.logo_alt_en AS logo_alt_en_13,
  t0.intro_fr AS intro_fr_14,
  t0.intro_en AS intro_en_15,
  t0.content_fr AS content_fr_16,
  t0.content_en AS content_en_17,
  t0.slug_en AS slug_en_18,
  t0.h1 AS h1_19,
  t0.h1_en AS h1_en_20,
  t0.meta_title_en AS meta_title_en_21,
  t0.meta_description_en AS meta_description_en_22,
  t0.meta_title AS meta_title_23,
  t0.meta_description AS meta_description_24,
  t0.slug AS slug_25,
  t0.position AS position_26
FROM
  application t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5, t0.image_updated_at AS image_updated_at_6, t0.image_alt_fr AS image_alt_fr_7, t0.image_alt_en AS image_alt_en_8, t0.logo_name AS logo_name_9, t0.logo_size AS logo_size_10, t0.logo_updated_at AS logo_updated_at_11, t0.logo_alt_fr AS logo_alt_fr_12, t0.logo_alt_en AS logo_alt_en_13, t0.intro_fr AS intro_fr_14, t0.intro_en AS intro_en_15, t0.content_fr AS content_fr_16, t0.content_en AS content_en_17, t0.slug_en AS slug_en_18, t0.h1 AS h1_19, t0.h1_en AS h1_en_20, t0.meta_title_en AS meta_title_en_21, t0.meta_description_en AS meta_description_en_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25, t0.position AS position_26 FROM application t0 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.image_updated_at AS image_updated_at_4,
  t0.image_alt_fr AS image_alt_fr_5,
  t0.image_alt_en AS image_alt_en_6,
  t0.title_fr AS title_fr_7,
  t0.title_en AS title_en_8,
  t0.intro_fr AS intro_fr_9,
  t0.intro_en AS intro_en_10,
  t0.content_fr AS content_fr_11,
  t0.content_en AS content_en_12,
  t0.documentation_intro_fr AS documentation_intro_fr_13,
  t0.documentation_intro_en AS documentation_intro_en_14,
  t0.slug_en AS slug_en_15,
  t0.h1 AS h1_16,
  t0.h1_en AS h1_en_17,
  t0.meta_title_en AS meta_title_en_18,
  t0.meta_description_en AS meta_description_en_19,
  t0.meta_title AS meta_title_20,
  t0.meta_description AS meta_description_21,
  t0.slug AS slug_22,
  t0.position AS position_23
FROM
  product t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt_fr AS image_alt_fr_5, t0.image_alt_en AS image_alt_en_6, t0.title_fr AS title_fr_7, t0.title_en AS title_en_8, t0.intro_fr AS intro_fr_9, t0.intro_en AS intro_en_10, t0.content_fr AS content_fr_11, t0.content_en AS content_en_12, t0.documentation_intro_fr AS documentation_intro_fr_13, t0.documentation_intro_en AS documentation_intro_en_14, t0.slug_en AS slug_en_15, t0.h1 AS h1_16, t0.h1_en AS h1_en_17, t0.meta_title_en AS meta_title_en_18, t0.meta_description_en AS meta_description_en_19, t0.meta_title AS meta_title_20, t0.meta_description AS meta_description_21, t0.slug AS slug_22, t0.position AS position_23 FROM product t0 ORDER BY t0.position ASC;