Redirect 302 redirect from GET @ajouter_condoleance (9e0859)

GET https://marchetti.olihost.com/souvenir/2967

Query Metrics

14 Database Queries
13 Different statements
4.57 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 0.53 ms
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
Parameters:
[
  "216.73.216.149"
  "afficher_souvenir"
  "2026-05-11 00:28:32"
]
2 0.46 ms
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.date_publication_remerciement AS date_publication_remerciement_16, t0.defunt_id AS defunt_id_17, t0.utilisateur_id AS utilisateur_id_18 FROM avis_deces t0 WHERE t0.id = ?
Parameters:
[
  "2967"
]
3 0.40 ms
SELECT t0.id AS id_1, t0.message AS message_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.email AS email_5, t0.date_creation AS date_creation_6, t0.validite AS validite_7, t0.prive AS prive_8, t0.nom_fichier AS nom_fichier_9, t0.adresse AS adresse_10, t0.commune AS commune_11, t0.avis_deces_id AS avis_deces_id_12 FROM condoleance t0 WHERE t0.avis_deces_id = ? AND t0.validite = ? ORDER BY t0.date_creation DESC
Parameters:
[
  2967
  1
]
4 0.30 ms
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.message AS message_7, t0.nom_fichier AS nom_fichier_8, t0.avis_deces_id AS avis_deces_id_9 FROM bougie t0 WHERE t0.avis_deces_id = ? AND t0.validite = ? ORDER BY t0.date_creation DESC
Parameters:
[
  2967
  1
]
5 0.28 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.message AS message_5, t0.date_creation AS date_creation_6, t0.validite AS validite_7, t0.avis_deces_id AS avis_deces_id_8 FROM message t0 WHERE t0.avis_deces_id = ? AND t0.validite = ? ORDER BY t0.date_creation DESC
Parameters:
[
  2967
  1
]
6 0.33 ms
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 photo t0 WHERE t0.avis_deces_id = ? AND t0.validite = ? ORDER BY t0.date_creation DESC
Parameters:
[
  2967
  1
]
7 0.27 ms
SELECT t0.id AS id_1, t0.validite AS validite_2, t0.upload AS upload_3, t0.date_creation AS date_creation_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.email AS email_7, t0.legende AS legende_8, t0.nom_fichier AS nom_fichier_9, t0.lien_video AS lien_video_10, t0.avis_deces_id AS avis_deces_id_11 FROM video t0 WHERE t0.avis_deces_id = ? AND t0.validite = ? ORDER BY t0.date_creation DESC
Parameters:
[
  2967
  1
]
8 0.23 ms
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 = ?
Parameters:
[
  2970
]
9 0.34 ms
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 = ?
Parameters:
[
  2970
  2970
]
10 0.29 ms
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 = ?
Parameters:
[
  2969
]
11 0.28 ms
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.date_publication_remerciement AS date_publication_remerciement_16, t0.defunt_id AS defunt_id_17, t0.utilisateur_id AS utilisateur_id_18 FROM avis_deces t0 WHERE t0.defunt_id = ? LIMIT 1
Parameters:
[
  2969
]
12 0.27 ms
SELECT a0_.id AS id_0, a0_.contenu AS contenu_1, a0_.avis_deces_id AS avis_deces_id_2 FROM avis_deces_remerciement a0_ WHERE a0_.avis_deces_id = ? ORDER BY a0_.id ASC LIMIT 1
Parameters:
[
  2967
]
13 0.25 ms
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
Parameters:
[
  2967
  1
]
14 0.35 ms
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.text_color AS text_color_8, t0.avis_deces_id AS avis_deces_id_9 FROM theme t0 WHERE t0.avis_deces_id = ? AND t0.validite = ? LIMIT 1
Parameters:
[
  2967
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Condoleance 7
App\Entity\AvisDeces 2
App\Entity\Defunt 2
App\Entity\HistoriqueRoute 1
App\Entity\LienFamiliale 1
App\Entity\Utilisateur 1
App\Entity\Portrait 1

Entities Mapping