Symfony Profiler

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  blog_article b0_
  INNER JOIN blog_article_blog_categorie b2_ ON b0_.id = b2_.blog_article_id
  INNER JOIN blog_categorie b1_ ON b1_.id = b2_.blog_categorie_id
  INNER JOIN blog_article_translation b3_ ON b0_.id = b3_.translatable_id
  AND (b3_.locale LIKE ?)
WHERE
  b1_.id = ?
  AND b1_.is_active = 1
  AND b3_.slug IS NOT NULL

SELECT COUNT(b0_.id) AS sclr_0 FROM blog_article b0_ INNER JOIN blog_article_blog_categorie b2_ ON b0_.id = b2_.blog_article_id INNER JOIN blog_categorie b1_ ON b1_.id = b2_.blog_categorie_id INNER JOIN blog_article_translation b3_ ON b0_.id = b3_.translatable_id AND (b3_.locale LIKE 'fr') WHERE b1_.id = 40 AND b1_.is_active = 1 AND b3_.slug IS NOT NULL;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  blog_categorie_translation t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM blog_categorie_translation t0 WHERE t0.slug = 'Medecine-sportive' LIMIT 1;