Query Metrics
40
Database Queries
10
Different statements
10.06 ms
Query time
6
Invalid entities
118
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.30 ms |
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 FROM fos_user_user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
61
]
|
| 2 | 0.37 ms |
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:
[
61
]
|
| 3 | 0.49 ms |
SELECT p0_.id AS id_0, p0_.can_create AS can_create_1, p0_.can_edit AS can_edit_2, p0_.can_show AS can_show_3, p0_.can_delete AS can_delete_4, p0_.can_export AS can_export_5, p0_.can_log AS can_log_6, p0_.can_run AS can_run_7, p0_.can_undo AS can_undo_8, p0_.can_data AS can_data_9, p0_.can_see_all_entries AS can_see_all_entries_10, p0_.permission_entity_id AS permission_entity_id_11, p0_.user_id AS user_id_12, p0_.user_group_id AS user_group_id_13 FROM permission p0_ INNER JOIN permission_entity p1_ ON (p1_.id = p0_.permission_entity_id) WHERE p0_.user_group_id = ? AND p1_.entity = ? AND p1_.permission_entity_id IS NULL
Parameters:
[ 1 "AppBundle\Entity\User" ] |
| 4 | 0.44 ms |
SELECT p0_.id AS id_0, p0_.can_create AS can_create_1, p0_.can_edit AS can_edit_2, p0_.can_show AS can_show_3, p0_.can_delete AS can_delete_4, p0_.can_export AS can_export_5, p0_.can_log AS can_log_6, p0_.can_run AS can_run_7, p0_.can_undo AS can_undo_8, p0_.can_data AS can_data_9, p0_.can_see_all_entries AS can_see_all_entries_10, p0_.permission_entity_id AS permission_entity_id_11, p0_.user_id AS user_id_12, p0_.user_group_id AS user_group_id_13 FROM permission p0_ INNER JOIN permission_entity p1_ ON (p1_.id = p0_.permission_entity_id) WHERE p0_.user_group_id = ? AND p1_.entity = ? AND p1_.permission_entity_id IS NOT NULL
Parameters:
[ 1 "AppBundle\Entity\User" ] |
| 5 | 0.33 ms |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.roles AS roles_2, f0_.intern_name AS intern_name_3 FROM fos_user_group f0_
Parameters:
[] |
| 6 | 0.26 ms |
SELECT count(f0_.id) AS sclr_0 FROM fos_user_user f0_
Parameters:
[] |
| 7 | 0.34 ms |
SELECT f0_.id AS id_0, f0_.username AS username_1, f0_.username_canonical AS username_canonical_2, f0_.email AS email_3, f0_.enabled AS enabled_4, f0_.salt AS salt_5, f0_.email_canonical AS email_canonical_6, f0_.password AS password_7, f0_.last_login AS last_login_8, f0_.confirmation_token AS confirmation_token_9, f0_.password_requested_at AS password_requested_at_10, f0_.roles AS roles_11, f0_.created_at AS created_at_12, f0_.updated_at AS updated_at_13, f0_.firstname AS firstname_14, f0_.lastname AS lastname_15, f0_.name AS name_16, f0_.jira_account_id AS jira_account_id_17, f0_.pv_id AS pv_id_18, f0_.pv_active AS pv_active_19, f0_.confirmation_first_login_token AS confirmation_first_login_token_20, f0_.user_type AS user_type_21, f0_.assigned_customer_user_id AS assigned_customer_user_id_22 FROM fos_user_user f0_ ORDER BY f0_.id ASC LIMIT 25 OFFSET 50
Parameters:
[] |
| 8 | 0.34 ms |
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:
[
51
]
|
| 9 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
51
]
|
| 10 | 0.24 ms |
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:
[
52
]
|
| 11 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
52
]
|
| 12 | 0.22 ms |
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:
[
53
]
|
| 13 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
53
]
|
| 14 | 0.24 ms |
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:
[
54
]
|
| 15 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
54
]
|
| 16 | 0.20 ms |
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:
[
55
]
|
| 17 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
55
]
|
| 18 | 0.22 ms |
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:
[
56
]
|
| 19 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
56
]
|
| 20 | 0.21 ms |
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:
[
57
]
|
| 21 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
57
]
|
| 22 | 0.21 ms |
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:
[
58
]
|
| 23 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
58
]
|
| 24 | 0.21 ms |
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:
[
59
]
|
| 25 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
59
]
|
| 26 | 0.21 ms |
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:
[
60
]
|
| 27 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
60
]
|
| 28 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
61
]
|
| 29 | 0.22 ms |
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:
[
62
]
|
| 30 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
62
]
|
| 31 | 0.20 ms |
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:
[
63
]
|
| 32 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
63
]
|
| 33 | 0.22 ms |
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:
[
64
]
|
| 34 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
64
]
|
| 35 | 0.20 ms |
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:
[
65
]
|
| 36 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
65
]
|
| 37 | 0.20 ms |
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:
[
66
]
|
| 38 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = ?
Parameters:
[
66
]
|
| 39 | 0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.jira_project_key AS jira_project_key_5, t0.confluence_space_key AS confluence_space_key_6, t7.id AS id_8, t7.setting AS setting_9, t7.value AS value_10, t7.area AS area_11, t7.customer_id AS customer_id_12, t13.id AS id_14, t13.target_audience AS target_audience_15, t13.type AS type_16, t13.backend_url AS backend_url_17, t13.username AS username_18, t13.password AS password_19, t13.created AS created_20, t13.updated AS updated_21, t13.customer AS customer_22, t13.domain AS domain_23, t13.description_id AS description_id_24, t13.offer_description_id AS offer_description_id_25, t13.long_term_goals_id AS long_term_goals_id_26, t13.target_audience_description_id AS target_audience_description_id_27, t13.cms_system_id AS cms_system_id_28 FROM customer t0 LEFT JOIN custom_setting t7 ON t7.customer_id = t0.id LEFT JOIN customer_domain_data t13 ON t13.customer = t0.id INNER JOIN fos_user_user_customer ON t0.id = fos_user_user_customer.customer_id WHERE fos_user_user_customer.user_id = ?
Parameters:
[
61
]
|
| 40 | 0.29 ms |
SELECT c0_.id AS id_0, c0_.module AS module_1, c0_.description AS description_2, c0_.current_version AS current_version_3, c0_.new_version AS new_version_4 FROM composer_version c0_ WHERE c0_.new_version <> c0_.current_version
Parameters:
[] |
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\ComposerVersion | 63 |
| AppBundle\Entity\User | 21 |
| AppBundle\Entity\UserGroup | 21 |
| AppBundle\Entity\Department | 7 |
| AppBundle\Entity\AccountType | 4 |
| AppBundle\Entity\Permission | 1 |
| AppBundle\Entity\PermissionEntity | 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\UserGroup |
|
| AppBundle\Entity\Department |
|
| AppBundle\Entity\Customer |
|
| AppBundle\Entity\RoleDomainUser | No errors. |
| AppBundle\Entity\Permission | No errors. |
| AppBundle\Entity\PermissionEntity | No errors. |
| AppBundle\Entity\Contract | No errors. |
| CustomBundle\Entity\Setting | No errors. |
| AppBundle\Entity\CustomerDomainData | No errors. |
| AppBundle\Entity\Domain |
|
| AppBundle\Entity\CustomerDomainDataDescription |
|
| AppBundle\Entity\CmsSystem | No errors. |
| AppBundle\Entity\ComposerVersion | No errors. |
api_data entity manager
No loaded entities.
pv entity manager
No loaded entities.