Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.titre_en AS titre_en_2,
  a0_.mot_cle AS mot_cle_3,
  a0_.mot_cle_en AS mot_cle_en_4,
  a0_.reference AS reference_5,
  a0_.image1 AS image1_6,
  a0_.image2 AS image2_7,
  a0_.legende AS legende_8,
  a0_.legende_en AS legende_en_9,
  a0_.created_at AS created_at_10,
  a0_.contenu AS contenu_11,
  a0_.contenu_en AS contenu_en_12,
  a0_.ala_une AS ala_une_13,
  a0_.redacteur_id AS redacteur_id_14,
  a0_.sous_thematique_id AS sous_thematique_id_15,
  a0_.dossier_redaction_id AS dossier_redaction_id_16
FROM
  actualite a0_
  INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id
  INNER JOIN thematique t2_ ON s1_.thematique_id = t2_.id
WHERE
  t2_.libelle LIKE ?
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.titre_en AS titre_en_2, a0_.mot_cle AS mot_cle_3, a0_.mot_cle_en AS mot_cle_en_4, a0_.reference AS reference_5, a0_.image1 AS image1_6, a0_.image2 AS image2_7, a0_.legende AS legende_8, a0_.legende_en AS legende_en_9, a0_.created_at AS created_at_10, a0_.contenu AS contenu_11, a0_.contenu_en AS contenu_en_12, a0_.ala_une AS ala_une_13, a0_.redacteur_id AS redacteur_id_14, a0_.sous_thematique_id AS sous_thematique_id_15, a0_.dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_.sous_thematique_id = s1_.id INNER JOIN thematique t2_ ON s1_.thematique_id = t2_.id WHERE t2_.libelle LIKE 'Aménagement%' ORDER BY a0_.created_at DESC;

SELECT
  s0_.id AS id_0,
  s0_.libelle AS libelle_1,
  s0_.created_at AS created_at_2,
  s0_.thematique_id AS thematique_id_3
FROM
  sous_thematique s0_
  INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id
WHERE
  t1_.libelle = ?
ORDER BY
  s0_.libelle ASC

SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = 'Urbanisme' ORDER BY s0_.libelle ASC;

SELECT
  s0_.id AS id_0,
  s0_.libelle AS libelle_1,
  s0_.created_at AS created_at_2,
  s0_.thematique_id AS thematique_id_3
FROM
  sous_thematique s0_
  INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id
WHERE
  t1_.libelle = ?
ORDER BY
  s0_.libelle ASC

SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = 'Aménagement' ORDER BY s0_.libelle ASC;

SELECT
  s0_.id AS id_0,
  s0_.libelle AS libelle_1,
  s0_.created_at AS created_at_2,
  s0_.thematique_id AS thematique_id_3
FROM
  sous_thematique s0_
  INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id
WHERE
  t1_.libelle = ?
ORDER BY
  s0_.libelle ASC

SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = 'Environnement' ORDER BY s0_.libelle ASC;

SELECT
  s0_.id AS id_0,
  s0_.libelle AS libelle_1,
  s0_.created_at AS created_at_2,
  s0_.thematique_id AS thematique_id_3
FROM
  sous_thematique s0_
  INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id
WHERE
  t1_.libelle = ?
ORDER BY
  s0_.libelle ASC

SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.created_at AS created_at_2, s0_.thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_.thematique_id = t1_.id WHERE t1_.libelle = 'Institution' ORDER BY s0_.libelle ASC;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.titre_en AS titre_en_3,
  t0.contenu AS contenu_4,
  t0.contenu_en AS contenu_en_5,
  t0.image AS image_6,
  t0.legende AS legende_7,
  t0.legende_en AS legende_en_8,
  t0.created_at AS created_at_9,
  t0.thematique_id AS thematique_id_10
FROM
  problemes t0
WHERE
  t0.thematique_id = ?
ORDER BY
  t0.created_at DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_en AS titre_en_3, t0.contenu AS contenu_4, t0.contenu_en AS contenu_en_5, t0.image AS image_6, t0.legende AS legende_7, t0.legende_en AS legende_en_8, t0.created_at AS created_at_9, t0.thematique_id AS thematique_id_10 FROM problemes t0 WHERE t0.thematique_id = 1 ORDER BY t0.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.titre_en AS titre_en_3,
  t0.contenu AS contenu_4,
  t0.contenu_en AS contenu_en_5,
  t0.image AS image_6,
  t0.legende AS legende_7,
  t0.legende_en AS legende_en_8,
  t0.created_at AS created_at_9,
  t0.thematique_id AS thematique_id_10
FROM
  problemes t0
WHERE
  t0.thematique_id = ?
ORDER BY
  t0.created_at DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_en AS titre_en_3, t0.contenu AS contenu_4, t0.contenu_en AS contenu_en_5, t0.image AS image_6, t0.legende AS legende_7, t0.legende_en AS legende_en_8, t0.created_at AS created_at_9, t0.thematique_id AS thematique_id_10 FROM problemes t0 WHERE t0.thematique_id = 2 ORDER BY t0.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.titre_en AS titre_en_3,
  t0.contenu AS contenu_4,
  t0.contenu_en AS contenu_en_5,
  t0.image AS image_6,
  t0.legende AS legende_7,
  t0.legende_en AS legende_en_8,
  t0.created_at AS created_at_9,
  t0.thematique_id AS thematique_id_10
FROM
  problemes t0
WHERE
  t0.thematique_id = ?
ORDER BY
  t0.created_at DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_en AS titre_en_3, t0.contenu AS contenu_4, t0.contenu_en AS contenu_en_5, t0.image AS image_6, t0.legende AS legende_7, t0.legende_en AS legende_en_8, t0.created_at AS created_at_9, t0.thematique_id AS thematique_id_10 FROM problemes t0 WHERE t0.thematique_id = 3 ORDER BY t0.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 65;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 41;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 11;

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  visiteur v0_
WHERE
  v0_.last_seen_at >= ?

SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.last_seen_at >= '2026-11-10 23:54:05';

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  visiteur v0_
WHERE
  v0_.first_seen_at >= ?

SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.first_seen_at >= '2026-11-10 00:00:00';

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  visiteur v0_
WHERE
  v0_.first_seen_at >= ?

SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.first_seen_at >= '2026-11-01 00:00:00';

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  visiteur v0_
WHERE
  v0_.first_seen_at >= ?

SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_ WHERE v0_.first_seen_at >= '2026-01-01 00:00:00';

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  visiteur v0_

SELECT COUNT(v0_.id) AS sclr_0 FROM visiteur v0_;