Query Metrics
150
Database Queries
4
Different statements
31.26 ms
Query time
4
Invalid entities
557
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
28.73 ms (91.93%) |
144 |
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.property AS property_3, t0.permission_entity_id AS permission_entity_id_4 FROM permission_entity t0 WHERE t0.id = ?
Parameters:
[
10
]
|
|
1.64 ms (5.26%) |
4 |
SELECT t0.id AS id_1, t0.can_create AS can_create_2, t0.can_edit AS can_edit_3, t0.can_show AS can_show_4, t0.can_delete AS can_delete_5, t0.can_export AS can_export_6, t0.can_log AS can_log_7, t0.can_run AS can_run_8, t0.can_undo AS can_undo_9, t0.can_data AS can_data_10, t0.can_see_all_entries AS can_see_all_entries_11, t0.permission_entity_id AS permission_entity_id_12, t0.user_id AS user_id_13, t0.user_group_id AS user_group_id_14 FROM permission t0 WHERE t0.user_group_id = ?
Parameters:
[
1
]
|
|
0.49 ms (1.58%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.email_canonical AS email_canonical_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.roles AS roles_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.firstname AS firstname_15, t0.lastname AS lastname_16, t0.name AS name_17, t0.jira_account_id AS jira_account_id_18, t0.pv_id AS pv_id_19, t0.pv_active AS pv_active_20, t0.confirmation_first_login_token AS confirmation_first_login_token_21, t0.user_type AS user_type_22, t0.assigned_customer_user_id AS assigned_customer_user_id_23, t24.id AS id_25, t24.image_path AS image_path_26, t24.thumbnail_path AS thumbnail_path_27, t24.created_at AS created_at_28, t24.updated_at AS updated_at_29, t24.user_id AS user_id_30, t0.job_title_id AS job_title_id_31 FROM fos_user_user t0 LEFT JOIN user_profile_image t24 ON t24.user_id = t0.id WHERE t0.id = ?
Parameters:
[
9
]
|
|
0.38 ms (1.23%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.intern_name AS intern_name_4 FROM fos_user_group t0 INNER JOIN fos_user_user_group ON t0.id = fos_user_user_group.group_id WHERE fos_user_user_group.user_id = ?
Parameters:
[
9
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| api_data | doctrine.dbal.api_data_connection |
| pv | doctrine.dbal.pv_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| api_data | doctrine.orm.api_data_entity_manager |
| pv | doctrine.orm.pv_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| AppBundle\Entity\Permission | 407 |
| AppBundle\Entity\PermissionEntity | 144 |
| AppBundle\Entity\UserGroup | 4 |
| AppBundle\Entity\User | 1 |
| AppBundle\Entity\UserProfileImage | 1 |
api_data entity manager
| Class | Amount of managed objects |
|---|
pv entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| AppBundle\Entity\User |
|
| AppBundle\Entity\UserProfileImage | No errors. |
| AppBundle\Entity\JobTitle | No errors. |
| AppBundle\Entity\UserGroup |
|
| AppBundle\Entity\Department |
|
| AppBundle\Entity\Customer |
|
| AppBundle\Entity\RoleDomainUser | No errors. |
| AppBundle\Entity\Permission | No errors. |
| AppBundle\Entity\PermissionEntity | No errors. |
api_data entity manager
No loaded entities.
pv entity manager
No loaded entities.