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

Query Metrics

13 Database Queries
12 Different statements
25.45 ms Query time
0 Invalid entities
15 Managed entities

Grouped Statements

Show all queries

Time Count Info
21.50 ms
(84.48%)
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 = ? AND h0_.route = ? AND h0_.datetime >= ?
Parameters:
[
  "216.73.216.147"
  "afficher_souvenir"
  "2026-01-27 19:41:41"
]
0.55 ms
(2.15%)
1
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
]
0.53 ms
(2.08%)
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.id = ?
Parameters:
[
  "2967"
]
0.46 ms
(1.80%)
2
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
]
0.38 ms
(1.48%)
1
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
]
0.37 ms
(1.45%)
1
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
]
0.35 ms
(1.39%)
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.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
]
0.28 ms
(1.08%)
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 photo t0 WHERE t0.avis_deces_id = ? AND t0.validite = ? ORDER BY t0.date_creation DESC
Parameters:
[
  2967
  1
]
0.27 ms
(1.06%)
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 = ? LIMIT 1
Parameters:
[
  2969
]
0.26 ms
(1.04%)
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 = ? AND t0.validite = ? LIMIT 1
Parameters:
[
  2967
  1
]
0.26 ms
(1.03%)
1
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
]
0.25 ms
(0.97%)
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.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

Class Mapping errors
App\Entity\HistoriqueRoute No errors.
App\Entity\AvisDeces No errors.
App\Entity\Defunt No errors.
App\Entity\Utilisateur No errors.
App\Entity\Etape No errors.
App\Entity\AvisDecesFichier No errors.
App\Entity\Condoleance No errors.
App\Entity\Bougie No errors.
App\Entity\Message No errors.
App\Entity\Photo No errors.
App\Entity\Video No errors.
App\Entity\LienFamiliale No errors.
App\Entity\Portrait No errors.
App\Entity\Theme No errors.