Query Metrics

59 Database Queries
10 Different statements
13.53 ms Query time
6 Invalid entities
124 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.31 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.28 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.40 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.37 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.29 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.21 ms
SELECT count(f0_.id) AS sclr_0 FROM fos_user_user f0_
Parameters:
[]
7 0.31 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
Parameters:
[]
8 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:
[
  1
]
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:
[
  1
]
10 0.25 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:
[
  2
]
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:
[
  2
]
12 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:
[
  3
]
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:
[
  3
]
14 0.23 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:
[
  4
]
15 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:
[
  4
]
16 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:
[
  5
]
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:
[
  5
]
18 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:
[
  6
]
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:
[
  6
]
20 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:
[
  7
]
21 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:
[
  7
]
22 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:
[
  8
]
23 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:
[
  8
]
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:
[
  9
]
25 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:
[
  9
]
26 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:
[
  10
]
27 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:
[
  10
]
28 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:
[
  11
]
29 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:
[
  11
]
30 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:
[
  12
]
31 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:
[
  12
]
32 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:
[
  13
]
33 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:
[
  13
]
34 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:
[
  14
]
35 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:
[
  14
]
36 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:
[
  15
]
37 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:
[
  15
]
38 0.23 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:
[
  16
]
39 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:
[
  16
]
40 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:
[
  17
]
41 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:
[
  17
]
42 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:
[
  18
]
43 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:
[
  18
]
44 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:
[
  19
]
45 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:
[
  19
]
46 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:
[
  20
]
47 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:
[
  20
]
48 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:
[
  21
]
49 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:
[
  21
]
50 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:
[
  22
]
51 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:
[
  22
]
52 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:
[
  23
]
53 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:
[
  23
]
54 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:
[
  24
]
55 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:
[
  24
]
56 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:
[
  25
]
57 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:
[
  25
]
58 0.36 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
]
59 0.28 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 26
AppBundle\Entity\UserGroup 21
AppBundle\Entity\Department 8
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
  • The mappings AppBundle\Entity\User#groups and AppBundle\Entity\UserGroup#user are inconsistent with each other.
  • The field AppBundle\Entity\User#roleDomainUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\RoleDomainUser#user does not contain the required 'inversedBy="roleDomainUser"' attribute.
AppBundle\Entity\UserGroup
  • The association AppBundle\Entity\UserGroup#user refers to the inverse side field AppBundle\Entity\User#userGroup which does not exist.
  • The field AppBundle\Entity\UserGroup#permission is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Permission#userGroup does not contain the required 'inversedBy="permission"' attribute.
AppBundle\Entity\Department
  • The field AppBundle\Entity\Department#contract is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Contract#department does not contain the required 'inversedBy="contract"' attribute.
AppBundle\Entity\Customer
  • The field AppBundle\Entity\Customer#domain is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Domain#customer does not contain the required 'inversedBy="domain"' attribute.
  • The field AppBundle\Entity\Customer#customSetting is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity CustomBundle\Entity\Setting#customer does not contain the required 'inversedBy="customSetting"' attribute.
  • The association AppBundle\Entity\Customer#pvDepartment refers to the inverse side field AppBundle\Entity\Department#customer which does not exist.
  • The field AppBundle\Entity\Customer#roleDomainUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\RoleDomainUser#customer does not contain the required 'inversedBy="roleDomainUser"' attribute.
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
  • The field AppBundle\Entity\Domain#roleDomainUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\RoleDomainUser#domain does not contain the required 'inversedBy="roleDomainUser"' attribute.
  • The field AppBundle\Entity\Domain#contract is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Contract#domain does not contain the required 'inversedBy="contract"' attribute.
  • The field AppBundle\Entity\Domain#aiChat is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AI\Chat#domain does not contain the required 'inversedBy="aiChat"' attribute.
  • The mappings AppBundle\Entity\Domain#crawlerConfigs and AppBundle\Entity\CrawlerConfig#domain are inconsistent with each other.
AppBundle\Entity\CustomerDomainDataDescription
  • The association AppBundle\Entity\CustomerDomainDataDescription#customer refers to the inverse side field AppBundle\Entity\Customer#domainDataDescriptions which does not exist.
  • The association AppBundle\Entity\CustomerDomainDataDescription#domain refers to the inverse side field AppBundle\Entity\Domain#domainDataDescriptions which does not exist.
  • The field AppBundle\Entity\CustomerDomainDataDescription#customerDomainDataDescription is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\CustomerDomainData#description does not contain the required 'inversedBy="customerDomainDataDescription"' attribute.
  • The field AppBundle\Entity\CustomerDomainDataDescription#customerDomainDataOfferDescription is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\CustomerDomainData#offerDescription does not contain the required 'inversedBy="customerDomainDataOfferDescription"' attribute.
  • The field AppBundle\Entity\CustomerDomainDataDescription#customerDomainDataLongTermGoals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\CustomerDomainData#longTermGoals does not contain the required 'inversedBy="customerDomainDataLongTermGoals"' attribute.
  • The field AppBundle\Entity\CustomerDomainDataDescription#customerDomainDataTargetAudienceDescription is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\CustomerDomainData#targetAudienceDescription does not contain the required 'inversedBy="customerDomainDataTargetAudienceDescription"' attribute.
AppBundle\Entity\CmsSystem No errors.
AppBundle\Entity\ComposerVersion No errors.

api_data entity manager

No loaded entities.

pv entity manager

No loaded entities.