Query Metrics
17
Database Queries
13
Different statements
31.97 ms
Query time
0
Invalid entities
11
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
22.86 ms (71.49%) |
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_avis" "2026-01-27 18:00:28" ] |
|
3.93 ms (12.29%) |
2 |
"COMMIT"
Parameters:
[] |
|
0.81 ms (2.55%) |
3 |
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:
[
3048
]
|
|
0.53 ms (1.65%) |
1 |
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_ WHERE a0_.id > ? AND a0_.actif = ? ORDER BY a0_.id ASC LIMIT 1
Parameters:
[ "3045" 1 ] |
|
0.52 ms (1.62%) |
1 |
UPDATE avis_deces SET nb_visite = ? WHERE id = ?
Parameters:
[ 82 3045 ] |
|
0.50 ms (1.57%) |
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:
[
"3045"
]
|
|
0.47 ms (1.48%) |
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:
[ 3045 1 ] |
|
0.47 ms (1.47%) |
1 |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.essais AS essais_3, t0.date_essai AS date_essai_4, t0.avis_deces_id AS avis_deces_id_5 FROM bruteforce t0 WHERE t0.ip = ? AND t0.avis_deces_id = ? LIMIT 1
Parameters:
[ "216.73.216.147" 3045 ] |
|
0.39 ms (1.23%) |
1 |
INSERT INTO historique_route (ip, datetime, route) VALUES (?, ?, ?)
Parameters:
[ "216.73.216.147" "2026-01-27 18:10:28" "afficher_avis" ] |
|
0.38 ms (1.18%) |
1 |
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_ WHERE a0_.id < ? AND a0_.actif = ? ORDER BY a0_.id DESC LIMIT 1
Parameters:
[ "3045" 1 ] |
|
0.37 ms (1.16%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.37 ms (1.16%) |
1 |
SELECT t0.id AS id_1, t0.libelle_etape AS libelle_etape_2, t0.date_etape AS date_etape_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.rue AS rue_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.ordre AS ordre_9, t0.avis_deces_id AS avis_deces_id_10 FROM etape t0 WHERE t0.avis_deces_id = ?
Parameters:
[
3045
]
|
|
0.37 ms (1.15%) |
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:
[ 3045 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\AvisDeces | 3 |
| App\Entity\Defunt | 3 |
| App\Entity\Condoleance | 2 |
| App\Entity\HistoriqueRoute | 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\Bruteforce | No errors. |
| App\Entity\Condoleance | No errors. |
| App\Entity\Portrait | No errors. |