Query Metrics
5
Database Queries
5
Different statements
1.09 ms
Query time
0
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.24 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.last_login AS last_login_4, t0.roles AS roles_5, t0.password AS password_6, t0.access_rights AS access_rights_7, t0.organization_id AS organization_id_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
44
]
|
| 2 | 0.22 ms |
SELECT t0.address_type AS address_type_1, t0.address AS address_2, t0.zip AS zip_3, t0.city AS city_4, t0.email AS email_5, t0.phone_number AS phone_number_6, t0.fax_number AS fax_number_7, t0.website AS website_8, t0.id AS id_9, t0.name AS name_10, t0.code AS code_11, t0.trainee_registrable AS trainee_registrable_12, t0.institution_id AS institution_id_13, t0.type FROM organization t0 WHERE t0.id = ? AND t0.type IN ('abstractorganization', 'organization')
Parameters:
[
1
]
|
| 3 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.idp AS idp_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.address_type AS address_type_6, t0.address AS address_7, t0.zip AS zip_8, t0.city AS city_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.fax_number AS fax_number_12, t0.website AS website_13, t0.type FROM institution t0 WHERE t0.id = ? AND t0.type IN ('abstractinstitution', 'institution')
Parameters:
[
1
]
|
| 4 | 0.17 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.last_login AS last_login_4, t0.roles AS roles_5, t0.password AS password_6, t0.access_rights AS access_rights_7, t0.organization_id AS organization_id_8 FROM user t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
"jlidi.m@univ-amu.fr"
]
|
| 5 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.machine_name AS machine_name_4, t0.position AS position_5, t0.entity AS entity_6, t0.file_path AS file_path_7, t0.file_name AS file_name_8, t0.uploaded AS uploaded_9, t0.organization_id AS organization_id_10 FROM publipost_template t0 WHERE t0.organization_id = ?
Parameters:
[
1
]
|
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\Term\Publiposttemplate | 6 |
| App\Entity\Core\User | 1 |
| App\Entity\Core\AbstractOrganization | 1 |
| App\Entity\Core\AbstractInstitution | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Core\User | No errors. |
| App\Entity\Core\AbstractOrganization | No errors. |
| App\Entity\Core\AbstractInstitution | No errors. |
| App\Entity\Back\Organization | No errors. |
| App\Entity\Back\Institution | No errors. |
| App\Entity\Term\AbstractTerm | No errors. |
| App\Entity\Term\Domain | No errors. |
| App\Entity\Term\Actiontype | No errors. |
| App\Entity\Core\AbstractInscription | No errors. |
| App\Entity\Back\Inscription | No errors. |
| App\Entity\Core\AbstractTrainee | No errors. |
| App\Entity\Back\Trainee | No errors. |
| App\Entity\Core\AbstractTrainer | No errors. |
| App\Entity\Back\Trainer | No errors. |
| App\Entity\Core\AbstractSession | No errors. |
| App\Entity\Back\Session | No errors. |
| App\Entity\Core\AbstractTraining | No errors. |
| App\Entity\Core\AbstractParticipation | No errors. |
| App\Entity\Back\Participation | No errors. |
| App\Entity\Back\Internship | No errors. |
| App\Entity\Back\DateSession | No errors. |
| App\Entity\Back\Alert | No errors. |
| App\Entity\Back\Presence | No errors. |
| App\Entity\Term\Publiposttemplate | No errors. |