Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.name1 AS name1_2,
  p0_.name2 AS name2_3,
  p0_.title AS title_4,
  p0_.slug AS slug_5,
  p0_.content AS content_6,
  p0_.visibleonsite AS visibleonsite_7,
  p0_.archiver AS archiver_8,
  p0_.creat_at AS creat_at_9,
  p0_.update_at AS update_at_10,
  p0_.delete_at AS delete_at_11,
  c1_.id AS id_12,
  c1_.name AS name_13,
  c1_.slug AS slug_14,
  p0_.auteur_id AS auteur_id_15,
  p0_.category_id AS category_id_16
FROM
  post p0_
  INNER JOIN category c1_ ON p0_.category_id = c1_.id
WHERE
  p0_.visibleonsite = ?
  AND p0_.archiver = ?
  AND c1_.name = ?
ORDER BY
  p0_.id DESC
LIMIT
  18
OFFSET
  18

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name1 AS name1_2, p0_.name2 AS name2_3, p0_.title AS title_4, p0_.slug AS slug_5, p0_.content AS content_6, p0_.visibleonsite AS visibleonsite_7, p0_.archiver AS archiver_8, p0_.creat_at AS creat_at_9, p0_.update_at AS update_at_10, p0_.delete_at AS delete_at_11, c1_.id AS id_12, c1_.name AS name_13, c1_.slug AS slug_14, p0_.auteur_id AS auteur_id_15, p0_.category_id AS category_id_16 FROM post p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.visibleonsite = 1 AND p0_.archiver = 0 AND c1_.name = 'Informations' ORDER BY p0_.id DESC LIMIT 18 OFFSET 18;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.name AS name_1,
          p0_.name1 AS name1_2,
          p0_.name2 AS name2_3,
          p0_.title AS title_4,
          p0_.slug AS slug_5,
          p0_.content AS content_6,
          p0_.visibleonsite AS visibleonsite_7,
          p0_.archiver AS archiver_8,
          p0_.creat_at AS creat_at_9,
          p0_.update_at AS update_at_10,
          p0_.delete_at AS delete_at_11,
          c1_.id AS id_12,
          c1_.name AS name_13,
          c1_.slug AS slug_14
        FROM
          post p0_
          INNER JOIN category c1_ ON p0_.category_id = c1_.id
        WHERE
          p0_.visibleonsite = ?
          AND p0_.archiver = ?
          AND c1_.name = ?
        ORDER BY
          p0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name1 AS name1_2, p0_.name2 AS name2_3, p0_.title AS title_4, p0_.slug AS slug_5, p0_.content AS content_6, p0_.visibleonsite AS visibleonsite_7, p0_.archiver AS archiver_8, p0_.creat_at AS creat_at_9, p0_.update_at AS update_at_10, p0_.delete_at AS delete_at_11, c1_.id AS id_12, c1_.name AS name_13, c1_.slug AS slug_14 FROM post p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.visibleonsite = 1 AND p0_.archiver = 0 AND c1_.name = 'Informations' ORDER BY p0_.id DESC) dctrn_result) dctrn_table;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.name1 AS name1_2,
  p0_.name2 AS name2_3,
  p0_.title AS title_4,
  p0_.slug AS slug_5,
  p0_.content AS content_6,
  p0_.visibleonsite AS visibleonsite_7,
  p0_.archiver AS archiver_8,
  p0_.creat_at AS creat_at_9,
  p0_.update_at AS update_at_10,
  p0_.delete_at AS delete_at_11,
  p0_.auteur_id AS auteur_id_12,
  p0_.category_id AS category_id_13
FROM
  post p0_
ORDER BY
  p0_.id DESC
LIMIT
  2

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name1 AS name1_2, p0_.name2 AS name2_3, p0_.title AS title_4, p0_.slug AS slug_5, p0_.content AS content_6, p0_.visibleonsite AS visibleonsite_7, p0_.archiver AS archiver_8, p0_.creat_at AS creat_at_9, p0_.update_at AS update_at_10, p0_.delete_at AS delete_at_11, p0_.auteur_id AS auteur_id_12, p0_.category_id AS category_id_13 FROM post p0_ ORDER BY p0_.id DESC LIMIT 2;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.contact AS contact_4,
  t0.username AS username_5,
  t0.hash AS hash_6,
  t0.email AS email_7,
  t0.is_actived AS is_actived_8,
  t0.password_requested_at AS password_requested_at_9,
  t0.token AS token_10
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.contact AS contact_4, t0.username AS username_5, t0.hash AS hash_6, t0.email AS email_7, t0.is_actived AS is_actived_8, t0.password_requested_at AS password_requested_at_9, t0.token AS token_10 FROM user t0 WHERE t0.id = 11;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.contact AS contact_4,
  t0.username AS username_5,
  t0.hash AS hash_6,
  t0.email AS email_7,
  t0.is_actived AS is_actived_8,
  t0.password_requested_at AS password_requested_at_9,
  t0.token AS token_10
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.contact AS contact_4, t0.username AS username_5, t0.hash AS hash_6, t0.email AS email_7, t0.is_actived AS is_actived_8, t0.password_requested_at AS password_requested_at_9, t0.token AS token_10 FROM user t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.contact AS contact_4,
  t0.username AS username_5,
  t0.hash AS hash_6,
  t0.email AS email_7,
  t0.is_actived AS is_actived_8,
  t0.password_requested_at AS password_requested_at_9,
  t0.token AS token_10
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.contact AS contact_4, t0.username AS username_5, t0.hash AS hash_6, t0.email AS email_7, t0.is_actived AS is_actived_8, t0.password_requested_at AS password_requested_at_9, t0.token AS token_10 FROM user t0 WHERE t0.id = 4;