Query Metrics
3
Database Queries
3
Different statements
3.06 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.54 ms |
SELECT t0.id AS id_1, t0.ecoclient_user_id AS ecoclient_user_id_2, t0.username AS username_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.salutation AS salutation_6, t0.email AS email_7, t0.password AS password_8, t0.user_title AS user_title_9, t0.user_mobile AS user_mobile_10, t0.user_landline AS user_landline_11, t0.enable_ldap_authentication AS enable_ldap_authentication_12, t0.image AS image_13, t0.marker_image AS marker_image_14, t0.small_square_image AS small_square_image_15, t0.image_mime_type AS image_mime_type_16, t0.is_non_human AS is_non_human_17, t0.signature AS signature_18, t0.odoo_employee_id AS odoo_employee_id_19, t0.odoo_user_id AS odoo_user_id_20, t0.disabled_at AS disabled_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.deleted_at AS deleted_at_24 FROM user t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
"reuter"
]
|
| 2 | 0.81 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?
Parameters:
[
7
]
|
| 3 | 0.70 ms |
SELECT d0_.id AS id_0, d0_.defect_title AS defect_title_1, d0_.defect_text AS defect_text_2, d0_.defect_rules AS defect_rules_3, d0_.is_deactivated AS is_deactivated_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6, d0_.deleted_at AS deleted_at_7 FROM defect d0_ WHERE (d0_.id = ?) AND (d0_.deleted_at IS NULL)
Parameters:
[
430
]
|
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\Role | 3 |
| App\Entity\User | 1 |
| App\Entity\Defect | 1 |