Symfony Profiler

SELECT
  h0_.id AS id_0,
  h0_.ip AS ip_1,
  h0_.datetime AS datetime_2,
  h0_.route AS route_3
FROM
  historique_route h0_
WHERE
  h0_.ip = ?
  AND h0_.route = ?
  AND h0_.datetime >= ?

SELECT h0_.id AS id_0, h0_.ip AS ip_1, h0_.datetime AS datetime_2, h0_.route AS route_3 FROM historique_route h0_ WHERE h0_.ip = '216.73.216.147' AND h0_.route = 'accueil' AND h0_.datetime >= '2026-01-27 14:31:59';

SELECT
  t0.id AS id_1,
  t0.genre AS genre_2,
  t0.nom AS nom_3,
  t0.nom_jeune_fille AS nom_jeune_fille_4,
  t0.prenom AS prenom_5,
  t0.date_naissance AS date_naissance_6,
  t0.date_deces AS date_deces_7,
  t0.lieu_naissance AS lieu_naissance_8,
  t0.lieu_deces AS lieu_deces_9,
  t0.commune_residence AS commune_residence_10,
  t0.commune_codepostal AS commune_codepostal_11
FROM
  defunt t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.genre AS genre_2, t0.nom AS nom_3, t0.nom_jeune_fille AS nom_jeune_fille_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.date_deces AS date_deces_7, t0.lieu_naissance AS lieu_naissance_8, t0.lieu_deces AS lieu_deces_9, t0.commune_residence AS commune_residence_10, t0.commune_codepostal AS commune_codepostal_11 FROM defunt t0 WHERE t0.id = 3054;

"COMMIT"

"COMMIT";

SELECT
  a0_.id AS id_0,
  a0_.date_creation AS date_creation_1,
  a0_.date_obseques AS date_obseques_2,
  a0_.lieu_obseques AS lieu_obseques_3,
  a0_.code_famille AS code_famille_4,
  a0_.date_publication AS date_publication_5,
  a0_.creneau_visite AS creneau_visite_6,
  a0_.avis_depose AS avis_depose_7,
  a0_.actif AS actif_8,
  a0_.cloture_espace_condoleance AS cloture_espace_condoleance_9,
  a0_.nb_visite AS nb_visite_10,
  a0_.alerte_auto_famille AS alerte_auto_famille_11,
  a0_.email_famille AS email_famille_12,
  a0_.couple AS couple_13,
  a0_.masquer_age AS masquer_age_14,
  a0_.defunt_id AS defunt_id_15,
  a0_.utilisateur_id AS utilisateur_id_16
FROM
  avis_deces a0_
  INNER JOIN defunt d1_ ON a0_.defunt_id = d1_.id
WHERE
  DAY(d1_.date_deces) = ?
  AND MONTH(d1_.date_deces) = ?
  AND a0_.cloture_espace_condoleance = 1
  AND a0_.actif = 1
ORDER BY
  d1_.nom ASC

SELECT a0_.id AS id_0, a0_.date_creation AS date_creation_1, a0_.date_obseques AS date_obseques_2, a0_.lieu_obseques AS lieu_obseques_3, a0_.code_famille AS code_famille_4, a0_.date_publication AS date_publication_5, a0_.creneau_visite AS creneau_visite_6, a0_.avis_depose AS avis_depose_7, a0_.actif AS actif_8, a0_.cloture_espace_condoleance AS cloture_espace_condoleance_9, a0_.nb_visite AS nb_visite_10, a0_.alerte_auto_famille AS alerte_auto_famille_11, a0_.email_famille AS email_famille_12, a0_.couple AS couple_13, a0_.masquer_age AS masquer_age_14, a0_.defunt_id AS defunt_id_15, a0_.utilisateur_id AS utilisateur_id_16 FROM avis_deces a0_ INNER JOIN defunt d1_ ON a0_.defunt_id = d1_.id WHERE DAY(d1_.date_deces) = '27' AND MONTH(d1_.date_deces) = '01' AND a0_.cloture_espace_condoleance = 1 AND a0_.actif = 1 ORDER BY d1_.nom ASC;

SELECT
  a0_.id AS id_0,
  COUNT(c1_.id) AS sclr_1
FROM
  condoleance c1_,
  avis_deces a0_
WHERE
  c1_.avis_deces_id = a0_.id
  AND c1_.validite = ?
  AND c1_.avis_deces_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
GROUP BY
  a0_.id

SELECT a0_.id AS id_0, COUNT(c1_.id) AS sclr_1 FROM condoleance c1_, avis_deces a0_ WHERE c1_.avis_deces_id = a0_.id AND c1_.validite = 1 AND c1_.avis_deces_id IN (3050, 3046, 3045, 3044, 3029, 3026, 3019, 3018, 3017, 3016, 3015, 3013, 3012, 3008, 3003, 2999, 3014, 3011, 3010, 2975, 2974, 2970, 2967, 2968, 2966) GROUP BY a0_.id;

SELECT
  a0_.id AS id_0,
  a0_.date_creation AS date_creation_1,
  a0_.date_obseques AS date_obseques_2,
  a0_.lieu_obseques AS lieu_obseques_3,
  a0_.code_famille AS code_famille_4,
  a0_.date_publication AS date_publication_5,
  a0_.creneau_visite AS creneau_visite_6,
  a0_.avis_depose AS avis_depose_7,
  a0_.actif AS actif_8,
  a0_.cloture_espace_condoleance AS cloture_espace_condoleance_9,
  a0_.nb_visite AS nb_visite_10,
  a0_.alerte_auto_famille AS alerte_auto_famille_11,
  a0_.email_famille AS email_famille_12,
  a0_.couple AS couple_13,
  a0_.masquer_age AS masquer_age_14,
  a0_.defunt_id AS defunt_id_15,
  a0_.utilisateur_id AS utilisateur_id_16
FROM
  avis_deces a0_
WHERE
  a0_.actif = 1
  AND a0_.date_publication <= ?
ORDER BY
  a0_.date_publication DESC,
  a0_.id DESC
LIMIT
  100

SELECT a0_.id AS id_0, a0_.date_creation AS date_creation_1, a0_.date_obseques AS date_obseques_2, a0_.lieu_obseques AS lieu_obseques_3, a0_.code_famille AS code_famille_4, a0_.date_publication AS date_publication_5, a0_.creneau_visite AS creneau_visite_6, a0_.avis_depose AS avis_depose_7, a0_.actif AS actif_8, a0_.cloture_espace_condoleance AS cloture_espace_condoleance_9, a0_.nb_visite AS nb_visite_10, a0_.alerte_auto_famille AS alerte_auto_famille_11, a0_.email_famille AS email_famille_12, a0_.couple AS couple_13, a0_.masquer_age AS masquer_age_14, a0_.defunt_id AS defunt_id_15, a0_.utilisateur_id AS utilisateur_id_16 FROM avis_deces a0_ WHERE a0_.actif = 1 AND a0_.date_publication <= '2026-01-27 14:41:59' ORDER BY a0_.date_publication DESC, a0_.id DESC LIMIT 100;

INSERT INTO historique_route (ip, datetime, route)
VALUES
  (?, ?, ?)

INSERT INTO historique_route (ip, datetime, route) VALUES ('216.73.216.147', '2026-01-27 14:41:59', 'accueil');

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.message AS message_3,
  t0.date AS date_4
FROM
  actu t0
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.message AS message_3, t0.date AS date_4 FROM actu t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.message AS message_3,
  t0.date AS date_4
FROM
  actu t0
LIMIT
  18446744073709551615
OFFSET
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.message AS message_3, t0.date AS date_4 FROM actu t0 LIMIT 18446744073709551615 OFFSET 1;

"START TRANSACTION"

"START TRANSACTION";