Query Metrics
3
Database Queries
3
Different statements
2.32 ms
Query time
0
Invalid entities
6
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.23 ms (52.92%) |
1 |
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"
]
|
|
0.61 ms (26.33%) |
1 |
SELECT s0_.id AS id_0, s0_.solution_title AS solution_title_1, s0_.solution_text AS solution_text_2, s0_.is_deactivated AS is_deactivated_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.deleted_at AS deleted_at_6, d1_.id AS id_7, s0_.defect_id AS defect_id_8 FROM solution s0_ INNER JOIN defect d1_ ON s0_.defect_id = d1_.id AND (d1_.deleted_at IS NULL) WHERE (s0_.defect_id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.solution_title ASC
Parameters:
[
"430"
]
|
|
0.48 ms (20.74%) |
1 |
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
]
|
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\Solution | 1 |
| App\Entity\Defect | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\ProjectImage | No errors. |
| App\Entity\InspectionAudio | No errors. |
| App\Entity\ProjectDocument | No errors. |
| App\Entity\Protocol | No errors. |
| App\Entity\Area | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\Permission | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\UserNotification | No errors. |
| App\Entity\ActivityResource | No errors. |
| App\Entity\Staffing | No errors. |
| App\Entity\Vacation | No errors. |
| App\Entity\Solution | No errors. |
| App\Entity\Defect | No errors. |
| App\Entity\DefectCategory | No errors. |