Symfony Profiler

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
  INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id
WHERE
  a0_.published = ?
  AND w1_.slug = ?
  AND EXISTS (
    SELECT
      1
    FROM
      category_article c2_
    WHERE
      c2_.article_id = a0_.id
      AND c2_.category_id IN (?)
  )

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM article a0_ INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id WHERE a0_.published = 1 AND w1_.slug = 'en' AND EXISTS (SELECT 1 FROM category_article c2_ WHERE c2_.article_id = a0_.id AND c2_.category_id IN (4));

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.original AS original_4,
  t0.unit AS unit_5,
  t0.image AS image_6,
  t0.website_language_id AS website_language_id_7
FROM
  category t0
WHERE
  t0.unit = ?
  AND t0.website_language_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.original AS original_4, t0.unit AS unit_5, t0.image AS image_6, t0.website_language_id AS website_language_id_7 FROM category t0 WHERE t0.unit = 4 AND t0.website_language_id = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.original AS original_4,
  t0.unit AS unit_5,
  t0.image AS image_6,
  t0.website_language_id AS website_language_id_7
FROM
  category t0
  INNER JOIN category_article ON t0.id = category_article.category_id
WHERE
  category_article.article_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.original AS original_4, t0.unit AS unit_5, t0.image AS image_6, t0.website_language_id AS website_language_id_7 FROM category t0 INNER JOIN category_article ON t0.id = category_article.category_id WHERE category_article.article_id = 281;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.description AS description_2,
  a0_.created_date AS created_date_3,
  a0_.slug AS slug_4,
  a0_.cover AS cover_5,
  a0_.views AS views_6,
  a0_.published AS published_7,
  a0_.status AS status_8,
  a0_.featured AS featured_9,
  a0_.featured_at AS featured_at_10,
  a0_.original AS original_11,
  a0_.unit AS unit_12,
  a0_.alt_cover AS alt_cover_13,
  a0_.title_seo AS title_seo_14,
  a0_.description_seo AS description_seo_15,
  a0_.published_at AS published_at_16,
  a0_.author_id AS author_id_17,
  a0_.reviewer_id AS reviewer_id_18,
  a0_.website_language_id AS website_language_id_19
FROM
  article a0_
  INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id
WHERE
  a0_.published = ?
  AND w1_.slug = ?
  AND EXISTS (
    SELECT
      1
    FROM
      category_article c2_
    WHERE
      c2_.article_id = a0_.id
      AND c2_.category_id IN (?)
  )
  AND a0_.id IN (?)
ORDER BY
  a0_.created_date DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.created_date AS created_date_3, a0_.slug AS slug_4, a0_.cover AS cover_5, a0_.views AS views_6, a0_.published AS published_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.featured_at AS featured_at_10, a0_.original AS original_11, a0_.unit AS unit_12, a0_.alt_cover AS alt_cover_13, a0_.title_seo AS title_seo_14, a0_.description_seo AS description_seo_15, a0_.published_at AS published_at_16, a0_.author_id AS author_id_17, a0_.reviewer_id AS reviewer_id_18, a0_.website_language_id AS website_language_id_19 FROM article a0_ INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id WHERE a0_.published = 1 AND w1_.slug = 'en' AND EXISTS (SELECT 1 FROM category_article c2_ WHERE c2_.article_id = a0_.id AND c2_.category_id IN (4)) AND a0_.id IN (281) ORDER BY a0_.created_date DESC;

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.created_date AS created_date_1
FROM
  article a0_
  INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id
WHERE
  a0_.published = ?
  AND w1_.slug = ?
  AND EXISTS (
    SELECT
      1
    FROM
      category_article c2_
    WHERE
      c2_.article_id = a0_.id
      AND c2_.category_id IN (?)
  )
ORDER BY
  a0_.created_date DESC
LIMIT
  16

SELECT DISTINCT a0_.id AS id_0, a0_.created_date AS created_date_1 FROM article a0_ INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id WHERE a0_.published = 1 AND w1_.slug = 'en' AND EXISTS (SELECT 1 FROM category_article c2_ WHERE c2_.article_id = a0_.id AND c2_.category_id IN (4)) ORDER BY a0_.created_date DESC LIMIT 16;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  website_language t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM website_language t0 WHERE t0.slug = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.original AS original_4,
  t0.unit AS unit_5,
  t0.image AS image_6,
  t0.website_language_id AS website_language_id_7
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.original AS original_4, t0.unit AS unit_5, t0.image AS image_6, t0.website_language_id AS website_language_id_7 FROM category t0 WHERE t0.slug = 'actualite' LIMIT 1;