Query Metrics
316
Database Queries
2
Different statements
120.64 ms
Query time
5
Invalid entities
631
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.10 ms (98.73%) |
315 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenoms AS prenoms_6, t0.contact AS contact_7, t0.profile_picture AS profile_picture_8, t9.id AS id_10, t9.identifiant AS identifiant_11, t9.civilite AS civilite_12, t9.nif AS nif_13, t9.rcs AS rcs_14, t9.stat AS stat_15, t9.date_inscription AS date_inscription_16, t9.code_parrain AS code_parrain_17, t9.points AS points_18, t9.status AS status_19, t9.user_id AS user_id_20, t9.type_client_id AS type_client_id_21, t22.id AS id_23, t22.adresssmallparcel AS adresssmallparcel_24, t22.adressregularparcel AS adressregularparcel_25, t22.nom_societe AS nom_societe_26, t22.connexion AS connexion_27, t22.id_user_id AS id_user_id_28, t22.localisation_id AS localisation_id_29, t22.type_id AS type_id_30 FROM user t0 LEFT JOIN client t9 ON t9.user_id = t0.id LEFT JOIN agent_chine t22 ON t22.id_user_id = t0.id WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.27%) |
1 |
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.civilite AS civilite_3, t0.nif AS nif_4, t0.rcs AS rcs_5, t0.stat AS stat_6, t0.date_inscription AS date_inscription_7, t0.code_parrain AS code_parrain_8, t0.points AS points_9, t0.status AS status_10, t0.user_id AS user_id_11, t0.type_client_id AS type_client_id_12 FROM client t0 WHERE t0.type_client_id = ?
Parameters:
[
2
]
|
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\Client | 315 |
| App\Entity\User | 315 |
| App\Entity\TypeClient | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Client |
|
| App\Entity\User |
|
| App\Entity\TypeClient | No errors. |
| App\Entity\ExpeditionClient |
|
| App\Entity\AgentChine | No errors. |
| App\Entity\Localisation | No errors. |
| App\Entity\TypeAgent |
|
| App\Entity\Booking |
|
| App\Entity\Transport | No errors. |
| App\Entity\NotificationUser | No errors. |