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 = 'lister_souvenir' AND h0_.datetime >= '2026-01-27 18:01:48';

SELECT
  l0_.id AS id_0,
  l0_.premier_membre_id AS premier_membre_id_1,
  l0_.second_membre_id AS second_membre_id_2
FROM
  lien_familiale l0_
  INNER JOIN defunt d1_ ON l0_.premier_membre_id = d1_.id
  INNER JOIN defunt d2_ ON l0_.second_membre_id = d2_.id
WHERE
  d1_.id = ?
  OR d2_.id = ?

SELECT l0_.id AS id_0, l0_.premier_membre_id AS premier_membre_id_1, l0_.second_membre_id AS second_membre_id_2 FROM lien_familiale l0_ INNER JOIN defunt d1_ ON l0_.premier_membre_id = d1_.id INNER JOIN defunt d2_ ON l0_.second_membre_id = d2_.id WHERE d1_.id = 3049 OR d2_.id = 3049;

SELECT
  t0.id AS id_1,
  t0.validite AS validite_2,
  t0.date_creation AS date_creation_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.email AS email_6,
  t0.nom_fichier AS nom_fichier_7,
  t0.avis_deces_id AS avis_deces_id_8
FROM
  portrait t0
WHERE
  t0.avis_deces_id = ?
  AND t0.validite = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.validite AS validite_2, t0.date_creation AS date_creation_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.email AS email_6, t0.nom_fichier AS nom_fichier_7, t0.avis_deces_id AS avis_deces_id_8 FROM portrait t0 WHERE t0.avis_deces_id = 3046 AND t0.validite = 1 LIMIT 1;

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 = 3049;

SELECT
  *
FROM
  (
    (
      SELECT
        a.id as idn,
        UPPER(d.nom) as nom,
        d.prenom,
        d.genre,
        MAX(b.date_creation) as dte,
        'bougie' AS 'type',
        b.id
      FROM
        bougie b,
        avis_deces a,
        defunt d
      WHERE
        a.actif = 1
        AND a.defunt_id = d.id
        AND b.avis_deces_id = a.id
        AND b.validite = 1
      GROUP BY
        idn
      ORDER BY
        b.date_creation DESC
    )
    UNION
      (
        SELECT
          a.id as idn,
          UPPER(d.nom) as nom,
          d.prenom,
          d.genre,
          MAX(m.date_creation) as dte,
          'message' AS 'type',
          m.id
        FROM
          message m,
          avis_deces a,
          defunt d
        WHERE
          a.actif = 1
          AND a.defunt_id = d.id
          AND m.avis_deces_id = a.id
          AND m.validite = 1
        GROUP BY
          idn
        ORDER BY
          m.date_creation DESC
      )
    UNION
      (
        SELECT
          a.id as idn,
          UPPER(d.nom) as nom,
          d.prenom,
          d.genre,
          MAX(p.date_creation) as dte,
          'photo' AS 'type',
          p.id
        FROM
          photo p,
          avis_deces a,
          defunt d
        WHERE
          a.actif = 1
          AND a.defunt_id = d.id
          AND p.avis_deces_id = a.id
          AND p.validite = 1
        GROUP BY
          idn
        ORDER BY
          p.date_creation DESC
      )
    UNION
      (
        SELECT
          a.id as idn,
          UPPER(d.nom) as nom,
          d.prenom,
          d.genre,
          MAX(v.date_creation) as dte,
          'video' AS 'type',
          v.id
        FROM
          video v,
          avis_deces a,
          defunt d
        WHERE
          a.actif = 1
          AND a.defunt_id = d.id
          AND v.avis_deces_id = a.id
          AND v.validite = 1
        GROUP BY
          idn
        ORDER BY
          v.date_creation DESC
      )
    ORDER BY
      dte DESC
  ) as x
GROUP BY
  idn
ORDER BY
  dte DESC
LIMIT
  30

SELECT * FROM (
                        (SELECT a.id as idn, UPPER(d.nom) as nom,d.prenom,d.genre, MAX(b.date_creation) as dte, 'bougie' AS 'type', b.id 
                            FROM bougie b, avis_deces a, defunt d WHERE a.actif=1 AND a.defunt_id = d.id AND b.avis_deces_id = a.id AND b.validite=1 GROUP BY idn ORDER BY b.date_creation DESC)
                        UNION
                        (SELECT a.id as idn, UPPER(d.nom) as nom,d.prenom,d.genre, MAX(m.date_creation) as dte, 'message' AS 'type', m.id  
                            FROM message m, avis_deces a, defunt d WHERE a.actif=1 AND a.defunt_id = d.id AND m.avis_deces_id = a.id AND m.validite=1 GROUP BY idn ORDER BY m.date_creation DESC)
                        UNION
                        (SELECT a.id as idn, UPPER(d.nom) as nom,d.prenom,d.genre, MAX(p.date_creation) as dte, 'photo' AS 'type', p.id  
                            FROM photo p, avis_deces a, defunt d WHERE a.actif=1 AND a.defunt_id = d.id AND p.avis_deces_id = a.id AND p.validite=1 GROUP BY idn ORDER BY p.date_creation DESC)
                        UNION
                        (SELECT a.id as idn, UPPER(d.nom) as nom,d.prenom,d.genre, MAX(v.date_creation) as dte, 'video' AS 'type', v.id  
                            FROM video v, avis_deces a, defunt d WHERE a.actif=1 AND a.defunt_id = d.id AND v.avis_deces_id = a.id AND v.validite=1 GROUP BY idn ORDER BY v.date_creation DESC)
                        ORDER BY dte DESC
                        ) as x
                    GROUP BY idn
                    ORDER BY dte DESC
                    LIMIT 30;

"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_naissance) = ?
  AND MONTH(d1_.date_naissance) = ?
  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_naissance) = '27' AND MONTH(d1_.date_naissance) = '01' 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
  a0_.actif = 1
  AND a0_.cloture_espace_condoleance = 1
  AND UPPER(d1_.nom) LIKE ?
  AND d1_.date_deces <= ?
  AND d1_.date_deces >= ?
ORDER BY
  a0_.date_publication DESC
LIMIT
  25

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 a0_.actif = 1 AND a0_.cloture_espace_condoleance = 1 AND UPPER(d1_.nom) LIKE '%%' AND d1_.date_deces <= '2026-01-27 18:11:48' AND d1_.date_deces >= '2000-01-01 00:00:00' ORDER BY a0_.date_publication DESC LIMIT 25;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  avis_deces a0_
  INNER JOIN defunt d1_ ON a0_.defunt_id = d1_.id
WHERE
  a0_.actif = 1
  AND a0_.cloture_espace_condoleance = 1
  AND UPPER(d1_.nom) LIKE ?
  AND d1_.date_deces <= ?
  AND d1_.date_deces >= ?

SELECT COUNT(a0_.id) AS sclr_0 FROM avis_deces a0_ INNER JOIN defunt d1_ ON a0_.defunt_id = d1_.id WHERE a0_.actif = 1 AND a0_.cloture_espace_condoleance = 1 AND UPPER(d1_.nom) LIKE '%%' AND d1_.date_deces <= '2026-01-27 18:11:48' AND d1_.date_deces >= '2000-01-01 00:00:00';

SELECT
  t0.id AS id_1,
  t0.date_creation AS date_creation_2,
  t0.date_obseques AS date_obseques_3,
  t0.lieu_obseques AS lieu_obseques_4,
  t0.code_famille AS code_famille_5,
  t0.date_publication AS date_publication_6,
  t0.creneau_visite AS creneau_visite_7,
  t0.avis_depose AS avis_depose_8,
  t0.actif AS actif_9,
  t0.cloture_espace_condoleance AS cloture_espace_condoleance_10,
  t0.nb_visite AS nb_visite_11,
  t0.alerte_auto_famille AS alerte_auto_famille_12,
  t0.email_famille AS email_famille_13,
  t0.couple AS couple_14,
  t0.masquer_age AS masquer_age_15,
  t0.defunt_id AS defunt_id_16,
  t0.utilisateur_id AS utilisateur_id_17
FROM
  avis_deces t0
WHERE
  t0.defunt_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_obseques AS date_obseques_3, t0.lieu_obseques AS lieu_obseques_4, t0.code_famille AS code_famille_5, t0.date_publication AS date_publication_6, t0.creneau_visite AS creneau_visite_7, t0.avis_depose AS avis_depose_8, t0.actif AS actif_9, t0.cloture_espace_condoleance AS cloture_espace_condoleance_10, t0.nb_visite AS nb_visite_11, t0.alerte_auto_famille AS alerte_auto_famille_12, t0.email_famille AS email_famille_13, t0.couple AS couple_14, t0.masquer_age AS masquer_age_15, t0.defunt_id AS defunt_id_16, t0.utilisateur_id AS utilisateur_id_17 FROM avis_deces t0 WHERE t0.defunt_id = 2969 LIMIT 1;

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

INSERT INTO historique_route (ip, datetime, route) VALUES ('216.73.216.147', '2026-01-27 18:11:48', 'lister_souvenir');

"START TRANSACTION"

"START TRANSACTION";