GET https://marchetti.olihost.com/registre/3019_DAVID_Michelle

Query Metrics

8 Database Queries
8 Different statements
5.03 ms Query time
0 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 0.61 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"
  "registre-PDF"
  "2026-05-11 01:40:39"
]
2 0.14 ms
"START TRANSACTION"
Parameters:
[]
3 0.33 ms
INSERT INTO historique_route (ip, datetime, route) VALUES (?, ?, ?)
Parameters:
[
  "216.73.216.149"
  "2026-05-11 01:50:39"
  "registre-PDF"
]
4 2.07 ms
"COMMIT"
Parameters:
[]
5 0.42 ms
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 a0_.id = ?
Parameters:
[
  "3019"
]
6 0.43 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 = ? AND t0.prive = ? ORDER BY t0.date_creation DESC
Parameters:
[
  3019
  1
  0
]
7 0.38 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:
[
  3019
  1
]
8 0.65 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:
[
  3022
]

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\HistoriqueRoute 1
App\Entity\AvisDeces 1
App\Entity\Defunt 1
App\Entity\Utilisateur 1
App\Entity\Condoleance 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\Portrait No errors.