Query Metrics
4
Database Queries
4
Different statements
2.08 ms
Query time
0
Invalid entities
Queries
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.