Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name_category AS name_category_2,
  t0.description AS description_3,
  t0.slug AS slug_4
FROM
  pbm_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_category AS name_category_2, t0.description AS description_3, t0.slug AS slug_4 FROM pbm_category t0 WHERE t0.slug = 'gagnez' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.image AS image_3,
  p0_.text AS text_4,
  p0_.extract AS extract_5,
  p0_.date AS date_6,
  p0_.updated_at AS updated_at_7,
  p0_.published AS published_8,
  p0_.in_one AS in_one_9,
  p1_.id AS id_10,
  p1_.name_category AS name_category_11,
  p1_.description AS description_12,
  p1_.slug AS slug_13
FROM
  pbm_article p0_
  INNER JOIN pbm_article_category p2_ ON p0_.id = p2_.article_id
  INNER JOIN pbm_category p1_ ON p1_.id = p2_.category_id
WHERE
  p0_.published = ?
  AND p1_.slug = 'gagnez'
ORDER BY
  p0_.date DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.image AS image_3, p0_.text AS text_4, p0_.extract AS extract_5, p0_.date AS date_6, p0_.updated_at AS updated_at_7, p0_.published AS published_8, p0_.in_one AS in_one_9, p1_.id AS id_10, p1_.name_category AS name_category_11, p1_.description AS description_12, p1_.slug AS slug_13 FROM pbm_article p0_ INNER JOIN pbm_article_category p2_ ON p0_.id = p2_.article_id INNER JOIN pbm_category p1_ ON p1_.id = p2_.category_id WHERE p0_.published = 1 AND p1_.slug = 'gagnez' ORDER BY p0_.date DESC LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.title AS title_1,
          p0_.slug AS slug_2,
          p0_.image AS image_3,
          p0_.text AS text_4,
          p0_.extract AS extract_5,
          p0_.date AS date_6,
          p0_.updated_at AS updated_at_7,
          p0_.published AS published_8,
          p0_.in_one AS in_one_9,
          p1_.id AS id_10,
          p1_.name_category AS name_category_11,
          p1_.description AS description_12,
          p1_.slug AS slug_13
        FROM
          pbm_article p0_
          INNER JOIN pbm_article_category p2_ ON p0_.id = p2_.article_id
          INNER JOIN pbm_category p1_ ON p1_.id = p2_.category_id
        WHERE
          p0_.published = ?
          AND p1_.slug = 'gagnez'
        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_.title AS title_1, p0_.slug AS slug_2, p0_.image AS image_3, p0_.text AS text_4, p0_.extract AS extract_5, p0_.date AS date_6, p0_.updated_at AS updated_at_7, p0_.published AS published_8, p0_.in_one AS in_one_9, p1_.id AS id_10, p1_.name_category AS name_category_11, p1_.description AS description_12, p1_.slug AS slug_13 FROM pbm_article p0_ INNER JOIN pbm_article_category p2_ ON p0_.id = p2_.article_id INNER JOIN pbm_category p1_ ON p1_.id = p2_.category_id WHERE p0_.published = 1 AND p1_.slug = 'gagnez' ORDER BY p0_.date DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.name_category AS name_category_2,
  t0.description AS description_3,
  t0.slug AS slug_4
FROM
  pbm_category t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.name_category AS name_category_2, t0.description AS description_3, t0.slug AS slug_4 FROM pbm_category t0 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.text AS text_5,
  t0.extract AS extract_6,
  t0.date AS date_7,
  t0.updated_at AS updated_at_8,
  t0.published AS published_9,
  t0.in_one AS in_one_10
FROM
  pbm_article t0
  INNER JOIN pbm_article_category ON t0.id = pbm_article_category.article_id
WHERE
  pbm_article_category.category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image AS image_4, t0.text AS text_5, t0.extract AS extract_6, t0.date AS date_7, t0.updated_at AS updated_at_8, t0.published AS published_9, t0.in_one AS in_one_10 FROM pbm_article t0 INNER JOIN pbm_article_category ON t0.id = pbm_article_category.article_id WHERE pbm_article_category.category_id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.text AS text_5,
  t0.extract AS extract_6,
  t0.date AS date_7,
  t0.updated_at AS updated_at_8,
  t0.published AS published_9,
  t0.in_one AS in_one_10
FROM
  pbm_article t0
  INNER JOIN pbm_article_category ON t0.id = pbm_article_category.article_id
WHERE
  pbm_article_category.category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image AS image_4, t0.text AS text_5, t0.extract AS extract_6, t0.date AS date_7, t0.updated_at AS updated_at_8, t0.published AS published_9, t0.in_one AS in_one_10 FROM pbm_article t0 INNER JOIN pbm_article_category ON t0.id = pbm_article_category.article_id WHERE pbm_article_category.category_id = 2;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.text AS text_5,
  t0.extract AS extract_6,
  t0.date AS date_7,
  t0.updated_at AS updated_at_8,
  t0.published AS published_9,
  t0.in_one AS in_one_10
FROM
  pbm_article t0
  INNER JOIN pbm_article_category ON t0.id = pbm_article_category.article_id
WHERE
  pbm_article_category.category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image AS image_4, t0.text AS text_5, t0.extract AS extract_6, t0.date AS date_7, t0.updated_at AS updated_at_8, t0.published AS published_9, t0.in_one AS in_one_10 FROM pbm_article t0 INNER JOIN pbm_article_category ON t0.id = pbm_article_category.article_id WHERE pbm_article_category.category_id = 3;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.text AS text_5,
  t0.extract AS extract_6,
  t0.date AS date_7,
  t0.updated_at AS updated_at_8,
  t0.published AS published_9,
  t0.in_one AS in_one_10
FROM
  pbm_article t0
  INNER JOIN pbm_article_category ON t0.id = pbm_article_category.article_id
WHERE
  pbm_article_category.category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image AS image_4, t0.text AS text_5, t0.extract AS extract_6, t0.date AS date_7, t0.updated_at AS updated_at_8, t0.published AS published_9, t0.in_one AS in_one_10 FROM pbm_article t0 INNER JOIN pbm_article_category ON t0.id = pbm_article_category.article_id WHERE pbm_article_category.category_id = 4;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.text AS text_5,
  t0.extract AS extract_6,
  t0.date AS date_7,
  t0.updated_at AS updated_at_8,
  t0.published AS published_9,
  t0.in_one AS in_one_10
FROM
  pbm_article t0
  INNER JOIN pbm_article_category ON t0.id = pbm_article_category.article_id
WHERE
  pbm_article_category.category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image AS image_4, t0.text AS text_5, t0.extract AS extract_6, t0.date AS date_7, t0.updated_at AS updated_at_8, t0.published AS published_9, t0.in_one AS in_one_10 FROM pbm_article t0 INNER JOIN pbm_article_category ON t0.id = pbm_article_category.article_id WHERE pbm_article_category.category_id = 5;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.text AS text_5,
  t0.extract AS extract_6,
  t0.date AS date_7,
  t0.updated_at AS updated_at_8,
  t0.published AS published_9,
  t0.in_one AS in_one_10
FROM
  pbm_article t0
  INNER JOIN pbm_article_category ON t0.id = pbm_article_category.article_id
WHERE
  pbm_article_category.category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image AS image_4, t0.text AS text_5, t0.extract AS extract_6, t0.date AS date_7, t0.updated_at AS updated_at_8, t0.published AS published_9, t0.in_one AS in_one_10 FROM pbm_article t0 INNER JOIN pbm_article_category ON t0.id = pbm_article_category.article_id WHERE pbm_article_category.category_id = 6;