Symfony Profiler

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  blog_article b0_
  INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id
  AND (b1_.locale LIKE ?)
WHERE
  b0_.is_active = 1
  AND b1_.slug IS NOT NULL
ORDER BY
  b0_.date_publication DESC

SELECT COUNT(b0_.id) AS sclr_0 FROM blog_article b0_ INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id AND (b1_.locale LIKE 'de') WHERE b0_.is_active = 1 AND b1_.slug IS NOT NULL ORDER BY b0_.date_publication DESC;

SELECT
  b0_.id AS id_0,
  b0_.meta_titre AS meta_titre_1,
  b0_.meta_desc AS meta_desc_2,
  b0_.image AS image_3,
  b0_.is_active AS is_active_4,
  b0_.date_publication AS date_publication_5,
  b0_.auteur_id AS auteur_id_6
FROM
  blog_article b0_
  INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id
  AND (b1_.locale LIKE ?)
WHERE
  b0_.is_active = 1
  AND b1_.slug IS NOT NULL
ORDER BY
  b0_.date_publication DESC
LIMIT
  8

SELECT b0_.id AS id_0, b0_.meta_titre AS meta_titre_1, b0_.meta_desc AS meta_desc_2, b0_.image AS image_3, b0_.is_active AS is_active_4, b0_.date_publication AS date_publication_5, b0_.auteur_id AS auteur_id_6 FROM blog_article b0_ INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id AND (b1_.locale LIKE 'de') WHERE b0_.is_active = 1 AND b1_.slug IS NOT NULL ORDER BY b0_.date_publication DESC LIMIT 8;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.contenu AS contenu_3,
  t0.slug AS slug_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  blog_article_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM blog_article_translation t0 WHERE t0.translatable_id = 38;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.category_parent_id AS category_parent_id_3
FROM
  blog_categorie t0
  INNER JOIN blog_article_blog_categorie ON t0.id = blog_article_blog_categorie.blog_categorie_id
WHERE
  blog_article_blog_categorie.blog_article_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 INNER JOIN blog_article_blog_categorie ON t0.id = blog_article_blog_categorie.blog_categorie_id WHERE blog_article_blog_categorie.blog_article_id = 38;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.contenu AS contenu_3,
  t0.slug AS slug_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  blog_article_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM blog_article_translation t0 WHERE t0.translatable_id = 18;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.category_parent_id AS category_parent_id_3
FROM
  blog_categorie t0
  INNER JOIN blog_article_blog_categorie ON t0.id = blog_article_blog_categorie.blog_categorie_id
WHERE
  blog_article_blog_categorie.blog_article_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 INNER JOIN blog_article_blog_categorie ON t0.id = blog_article_blog_categorie.blog_categorie_id WHERE blog_article_blog_categorie.blog_article_id = 18;

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.translatable_id = ?

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.translatable_id = 29;

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.translatable_id = ?

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.translatable_id = 31;

SELECT
  b0_.id AS id_0,
  b0_.meta_titre AS meta_titre_1,
  b0_.meta_desc AS meta_desc_2,
  b0_.image AS image_3,
  b0_.is_active AS is_active_4,
  b0_.date_publication AS date_publication_5,
  b0_.auteur_id AS auteur_id_6
FROM
  blog_article b0_
  INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id
  AND (
    b1_.locale = ?
    AND b1_.slug IS NOT NULL
  )
ORDER BY
  b0_.date_publication DESC
LIMIT
  5

SELECT b0_.id AS id_0, b0_.meta_titre AS meta_titre_1, b0_.meta_desc AS meta_desc_2, b0_.image AS image_3, b0_.is_active AS is_active_4, b0_.date_publication AS date_publication_5, b0_.auteur_id AS auteur_id_6 FROM blog_article b0_ INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id AND (b1_.locale = 'de' AND b1_.slug IS NOT NULL) ORDER BY b0_.date_publication DESC LIMIT 5;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'c1dr'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  b0_.id AS id_0,
  b0_.nom AS nom_1,
  b0_.slug AS slug_2,
  b0_.locale AS locale_3,
  b0_.translatable_id AS translatable_id_4
FROM
  blog_categorie_translation b0_
  LEFT JOIN blog_categorie b1_ ON b0_.translatable_id = b1_.id
WHERE
  b0_.locale LIKE ?
  AND b1_.category_parent_id IS NULL
ORDER BY
  b0_.nom ASC

SELECT b0_.id AS id_0, b0_.nom AS nom_1, b0_.slug AS slug_2, b0_.locale AS locale_3, b0_.translatable_id AS translatable_id_4 FROM blog_categorie_translation b0_ LEFT JOIN blog_categorie b1_ ON b0_.translatable_id = b1_.id WHERE b0_.locale LIKE 'de' AND b1_.category_parent_id IS NULL ORDER BY b0_.nom ASC;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.category_parent_id AS category_parent_id_3
FROM
  blog_categorie t0
WHERE
  t0.category_parent_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 WHERE t0.category_parent_id = 29;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.category_parent_id AS category_parent_id_3
FROM
  blog_categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.category_parent_id AS category_parent_id_3
FROM
  blog_categorie t0
WHERE
  t0.category_parent_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 WHERE t0.category_parent_id = 10;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.category_parent_id AS category_parent_id_3
FROM
  blog_categorie t0
WHERE
  t0.category_parent_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 WHERE t0.category_parent_id = 31;

SELECT
  b0_.id AS id_0,
  b0_.meta_titre AS meta_titre_1,
  b0_.meta_desc AS meta_desc_2,
  b0_.image AS image_3,
  b0_.is_active AS is_active_4,
  b0_.date_publication AS date_publication_5,
  b0_.auteur_id AS auteur_id_6
FROM
  blog_article b0_
ORDER BY
  b0_.date_publication DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.meta_titre AS meta_titre_1, b0_.meta_desc AS meta_desc_2, b0_.image AS image_3, b0_.is_active AS is_active_4, b0_.date_publication AS date_publication_5, b0_.auteur_id AS auteur_id_6 FROM blog_article b0_ ORDER BY b0_.date_publication DESC LIMIT 3;