Query Metrics

4 Database Queries
4 Different statements
2.08 ms Query time
0 Invalid entities

Queries

Group similar statements

app connection

# Time Info
1 0.81 ms
SELECT t0.id AS id_1, t0.password AS password_2, t0.email_authentication_enabled AS email_authentication_enabled_3, t0.email_authentication_code AS email_authentication_code_4, t0.google_authenticator_enabled AS google_authenticator_enabled_5, t0.google_authenticator_secret AS google_authenticator_secret_6, t0.totp_authentication_enabled AS totp_authentication_enabled_7, t0.totp_secret AS totp_secret_8, t0.email AS email_9, t0.roles AS roles_10, t0.actif AS actif_11, t0.is_deleted AS is_deleted_12, t0.nom AS nom_13, t0.prenom AS prenom_14, t0.imageprofil AS imageprofil_15, t0.coordonnes_telfixe AS coordonnes_telfixe_16, t0.coordonnes_telportable AS coordonnes_telportable_17, t0.adresse_adresse AS adresse_adresse_18, t0.adresse_numero AS adresse_numero_19, t0.adresse_rue AS adresse_rue_20, t0.adresse_complement AS adresse_complement_21, t0.adresse_cp AS adresse_cp_22, t0.adresse_ville AS adresse_ville_23, t0.adresse_latitude AS adresse_latitude_24, t0.adresse_longitude AS adresse_longitude_25, t0.dateinscription AS dateinscription_26, t0.darkmode AS darkmode_27 FROM user t0 WHERE t0.id = ?
Parameters:
[
  31
]
2 0.46 ms
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.seotitre AS seotitre_2, p0_.seometa AS seometa_3, p0_.cover AS cover_4, p0_.url AS url_5, p0_.excerpt AS excerpt_6, p0_.datecreation AS datecreation_7, p0_.actif AS actif_8, p0_.activerhook AS activerhook_9, p0_.autorisermodifications AS autorisermodifications_10, p0_.nbrvues AS nbrvues_11, p0_.user_id AS user_id_12 FROM pages p0_ ORDER BY p0_.nbrvues DESC LIMIT 8
Parameters:
[]
3 0.47 ms
SELECT t0.id AS id_1, t0.password AS password_2, t0.email_authentication_enabled AS email_authentication_enabled_3, t0.email_authentication_code AS email_authentication_code_4, t0.google_authenticator_enabled AS google_authenticator_enabled_5, t0.google_authenticator_secret AS google_authenticator_secret_6, t0.totp_authentication_enabled AS totp_authentication_enabled_7, t0.totp_secret AS totp_secret_8, t0.email AS email_9, t0.roles AS roles_10, t0.actif AS actif_11, t0.is_deleted AS is_deleted_12, t0.nom AS nom_13, t0.prenom AS prenom_14, t0.imageprofil AS imageprofil_15, t0.coordonnes_telfixe AS coordonnes_telfixe_16, t0.coordonnes_telportable AS coordonnes_telportable_17, t0.adresse_adresse AS adresse_adresse_18, t0.adresse_numero AS adresse_numero_19, t0.adresse_rue AS adresse_rue_20, t0.adresse_complement AS adresse_complement_21, t0.adresse_cp AS adresse_cp_22, t0.adresse_ville AS adresse_ville_23, t0.adresse_latitude AS adresse_latitude_24, t0.adresse_longitude AS adresse_longitude_25, t0.dateinscription AS dateinscription_26, t0.darkmode AS darkmode_27 FROM user t0
Parameters:
[]
4 0.34 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.puce AS puce_3, t0.route AS route_4, t0.datecreation AS datecreation_5, t0.user_id AS user_id_6 FROM notifications t0 WHERE t0.user_id = ?
Parameters:
[
  31
]

Database Connections

Name Service
app doctrine.dbal.app_connection
old doctrine.dbal.old_connection
em2025 doctrine.dbal.em2025_connection

Entity Managers

Name Service
app doctrine.orm.app_entity_manager
old doctrine.orm.old_entity_manager
em2025 doctrine.orm.em2025_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

app entity manager

Class Mapping errors
App\Entity\User No errors.
App\Entity\UserAcl No errors.
App\Entity\Pages No errors.
App\Entity\PagesContent No errors.
App\Entity\PagesHooks No errors.
App\Entity\Notifications No errors.

old entity manager

No loaded entities.

em2025 entity manager

No loaded entities.