Query Metrics
7
Database Queries
6
Different statements
4.32 ms
Query time
0
Invalid entities
Grouped Statements
app connection
Time▼ | Count | Info |
---|---|---|
1.42 ms (32.79%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"dgscreation_Symfony_Gross"
]
|
0.82 ms (19.01%) |
2 |
SELECT DATABASE()
Parameters:
[] |
0.81 ms (18.87%) |
1 |
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
]
|
0.47 ms (10.88%) |
1 |
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:
[] |
0.46 ms (10.63%) |
1 |
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:
[] |
0.34 ms (7.83%) |
1 |
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. |
App\Entity\AclFonctions | No errors. |
App\Entity\Hooks | No errors. |
old entity manager
No loaded entities.
em2025 entity manager
No loaded entities.