Symfony Profiler

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_.date_publication_remerciement AS date_publication_remerciement_15,
  a0_.defunt_id AS defunt_id_16,
  a0_.utilisateur_id AS utilisateur_id_17
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_.date_publication_remerciement AS date_publication_remerciement_15, a0_.defunt_id AS defunt_id_16, a0_.utilisateur_id AS utilisateur_id_17 FROM avis_deces a0_ INNER JOIN defunt d1_ ON a0_.defunt_id = d1_.id WHERE DAY(d1_.date_deces) = '10' AND MONTH(d1_.date_deces) = '05' AND a0_.cloture_espace_condoleance = 1 AND a0_.actif = 1 ORDER BY d1_.nom ASC;

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 >= ?
LIMIT
  1

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.149' AND h0_.route = 'accueil' AND h0_.datetime >= '2026-05-10 21:57:38' LIMIT 1;

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, 3030, 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;

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

INSERT INTO historique_route (ip, datetime, route) VALUES ('216.73.216.149', '2026-05-10 22:07:38', 'accueil');

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_.date_publication_remerciement AS date_publication_remerciement_15,
  a0_.defunt_id AS defunt_id_16,
  a0_.utilisateur_id AS utilisateur_id_17
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_.date_publication_remerciement AS date_publication_remerciement_15, a0_.defunt_id AS defunt_id_16, a0_.utilisateur_id AS utilisateur_id_17 FROM avis_deces a0_ WHERE a0_.actif = 1 AND a0_.date_publication <= '2026-05-10 22:07:38' ORDER BY a0_.date_publication DESC, a0_.id DESC LIMIT 100;

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";