GET https://marchetti2.olihost.com/

Response
200 OK
IP
193.19.82.13
Profiled on
Token
5efaef

Query Metrics

31 Database Queries
7 Different statements
29.73 ms Query time
0 Invalid entities
56 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
21.94 ms
(73.80%) 		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: 
[
  "193.19.82.13"
  "accueil"
  "2026-01-27 21:20:01"
]
View formatted query    View runnable query    Explain query
5.04 ms
(16.95%) 		25 
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: 
[
  3054
]
View formatted query    View runnable query    Explain query
0.72 ms
(2.42%) 		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_ INNER JOIN defunt d1_ ON a0_.defunt_id = d1_.id WHERE DAY(d1_.date_deces) = ? AND MONTH(d1_.date_deces) = ? AND a0_.cloture_espace_condoleance = 1 AND a0_.actif = 1 ORDER BY d1_.nom ASC
Parameters: 
[
  "27"
  "01"
]
View formatted query    View runnable query    Explain query
0.58 ms
(1.95%) 		1 
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.message AS message_3, t0.date AS date_4 FROM actu t0 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.55 ms
(1.86%) 		1 
SELECT a0_.id AS id_0, COUNT(c1_.id) AS sclr_1 FROM condoleance c1_, avis_deces a0_ WHERE c1_.avis_deces_id = a0_.id AND c1_.validite = ? AND c1_.avis_deces_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY a0_.id
Parameters: 
[
  1
  3050
  3046
  3045
  3044
  3029
  3026
  3019
  3018
  3017
  3016
  3015
  3013
  3012
  3008
  3003
  2999
  3014
  3011
  3010
  2975
  2974
  2970
  2967
  2968
  2966
]
View formatted query    View runnable query    Explain query
0.55 ms
(1.86%) 		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_.actif = 1 AND a0_.date_publication <= ? ORDER BY a0_.date_publication DESC, a0_.id DESC LIMIT 100
Parameters: 
[
  "2026-01-27 21:30:01"
]
View formatted query    View runnable query    Explain query
0.34 ms
(1.16%) 		1 
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.message AS message_3, t0.date AS date_4 FROM actu t0 LIMIT 18446744073709551615 OFFSET 1
Parameters: 
[]
View formatted query    View runnable query    Explain query

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 25
App\Entity\Defunt 25
App\Entity\Utilisateur 3
App\Entity\HistoriqueRoute 2
App\Entity\Actu 1

Entities Mapping

Class Mapping errors
App\Entity\HistoriqueRoute No errors.
App\Entity\Actu 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.