GET http://server17.clicks.de/admin/app/user/list

Query Metrics

186 Database Queries
15 Different statements
44.27 ms Query time
9 Invalid entities
203 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:
[]
60 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.department_id AS department_id_3 FROM account_type t0
Parameters:
[]
61 0.30 ms
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3, t0.area AS area_4, t0.customer_id AS customer_id_5 FROM custom_setting t0 WHERE t0.setting = ? AND t0.customer_id IS NULL LIMIT 1
Parameters:
[
  "customTool"
]
62 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:
[
  61
]
63 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_group_department ON t0.id = fos_user_group_department.department_id WHERE fos_user_group_department.group_id = ?
Parameters:
[
  1
]
64 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.department_id AS department_id_3 FROM account_type t0
Parameters:
[]
65 0.35 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\Customer"
]
66 0.32 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\Customer"
]
67 0.35 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\Domain"
]
68 0.32 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\Domain"
]
69 0.27 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\Contact"
]
70 0.27 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\Contact"
]
71 0.26 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\JiraProject"
]
72 0.25 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\JiraProject"
]
73 0.26 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\JiraIssue"
]
74 0.25 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\JiraIssue"
]
75 0.26 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\ConfluenceSpace"
]
76 0.25 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\ConfluenceSpace"
]
77 0.27 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\Ticket"
]
78 0.27 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\Ticket"
]
79 0.25 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\Offer"
]
80 0.26 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\Offer"
]
81 0.26 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\Contract"
]
82 0.25 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\Contract"
]
83 0.27 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\TimeTracking"
]
84 0.26 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\TimeTracking"
]
85 0.26 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\MetricDashboard"
]
86 0.21 ms
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.entity = ? LIMIT 1
Parameters:
[
  "AppBundle\Entity\MetricDashboard"
]
87 0.34 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\Account"
]
88 0.32 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\Account"
]
89 0.26 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\GoogleMerchantCenter"
]
90 0.26 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\GoogleMerchantCenter"
]
91 0.25 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\ScriptApproval"
]
92 0.25 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\ScriptApproval"
]
93 0.28 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\Account"
]
94 0.31 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\Account"
]
95 0.25 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\GoogleSearchConsoleAccount"
]
96 0.25 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\GoogleSearchConsoleAccount"
]
97 0.26 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\Process"
]
98 0.27 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\Process"
]
99 0.26 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\WebsiteAnalyse"
]
100 0.25 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\WebsiteAnalyse"
]
101 0.25 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\KeywordGenerator"
]
102 0.27 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\KeywordGenerator"
]
103 0.22 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
  "\Entity\"
]
104 0.19 ms
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.entity = ? LIMIT 1
Parameters:
[
  "\Entity\"
]
105 0.18 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 WHERE t0.intern_name = ? LIMIT 1
Parameters:
[
  "AI"
]
106 0.27 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\AI\Chat"
]
107 0.28 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\AI\Chat"
]
108 0.18 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 WHERE t0.intern_name = ? LIMIT 1
Parameters:
[
  "AI"
]
109 0.27 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\AI\Prompt"
]
110 0.27 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\AI\Prompt"
]
111 0.18 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 WHERE t0.intern_name = ? LIMIT 1
Parameters:
[
  "AI"
]
112 0.25 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\AI\Model"
]
113 0.25 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\AI\Model"
]
114 0.18 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 WHERE t0.intern_name = ? LIMIT 1
Parameters:
[
  "AI"
]
115 0.25 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\AI\Tag"
]
116 0.25 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\AI\Tag"
]
117 0.27 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"
]
118 0.31 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"
]
119 0.25 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\UserGroup"
]
120 0.25 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\UserGroup"
]
121 0.25 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\Department"
]
122 0.25 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\Department"
]
123 0.25 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\Role"
]
124 0.25 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\Role"
]
125 0.27 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\Script"
]
126 0.27 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\Script"
]
127 0.25 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\ScriptParameter"
]
128 0.25 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\ScriptParameter"
]
129 0.27 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\ScriptModule"
]
130 0.27 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\ScriptModule"
]
131 0.26 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\Report"
]
132 0.25 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\Report"
]
133 0.27 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\Log"
]
134 0.26 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\Log"
]
135 0.25 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\CoreConfig"
]
136 0.24 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\CoreConfig"
]
137 0.25 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\AccountType"
]
138 0.25 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\AccountType"
]
139 0.26 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\DocumentType"
]
140 0.25 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\DocumentType"
]
141 0.25 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\ContentSection"
]
142 0.25 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\ContentSection"
]
143 0.26 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\PageType"
]
144 0.24 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\PageType"
]
145 0.22 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\DomainType"
]
146 0.18 ms
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.entity = ? LIMIT 1
Parameters:
[
  "AppBundle\Entity\DomainType"
]
147 0.25 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\Objective"
]
148 0.25 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\Objective"
]
149 0.25 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\ApiEndpoint"
]
150 0.26 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\ApiEndpoint"
]
151 0.22 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\Cron"
]
152 0.18 ms
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.entity = ? LIMIT 1
Parameters:
[
  "AppBundle\Entity\Cron"
]
153 0.24 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\ComposerVersion"
]
154 0.26 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\ComposerVersion"
]
155 0.25 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\Proxy"
]
156 0.26 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\Proxy"
]
157 0.25 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\CacheUrl"
]
158 0.25 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\CacheUrl"
]
159 0.22 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
  "CustomBundle\Entity\CustomBundle\Admin\User"
]
160 0.18 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\User"
]
161 0.22 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
  "CustomBundle\Entity\CustomBundle\Admin\Location"
]
162 0.18 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\Location"
]
163 0.21 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
  "CustomBundle\Entity\CustomBundle\Admin\Template"
]
164 0.18 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\Template"
]
165 0.23 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
  "CustomBundle\Entity\CustomBundle\Admin\LandingPage"
]
166 0.18 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\LandingPage"
]
167 0.21 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
  "CustomBundle\Entity\CustomBundle\Admin\Order"
]
168 0.19 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\Order"
]
169 0.21 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
  "CustomBundle\Entity\CustomBundle\Admin\Channel"
]
170 0.18 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\Channel"
]
171 0.22 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
  "CustomBundle\Entity\CustomBundle\Admin\Package"
]
172 0.18 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\Package"
]
173 0.21 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
  "CustomBundle\Entity\CustomBundle\Admin\CallbackForm"
]
174 0.18 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\CallbackForm"
]
175 0.21 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
  "\Entity\"
]
176 0.17 ms
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.entity = ? LIMIT 1
Parameters:
[
  "\Entity\"
]
177 0.22 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
  "CustomBundle\Entity\CustomBundle\Admin\User"
]
178 0.19 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\User"
]
179 0.21 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
  "CustomBundle\Entity\CustomBundle\Admin\Location"
]
180 0.17 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\Location"
]
181 0.21 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
  "CustomBundle\Entity\CustomBundle\Admin\Template"
]
182 0.17 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\Template"
]
183 0.21 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
  "CustomBundle\Entity\CustomBundle\Admin\LandingPage"
]
184 0.18 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\LandingPage"
]
185 0.21 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
  "CustomBundle\Entity\CustomBundle\Admin\Order"
]
186 0.17 ms
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.entity = ? LIMIT 1
Parameters:
[
  "CustomBundle\Entity\CustomBundle\Admin\Order"
]

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\Permission 40
AppBundle\Entity\PermissionEntity 40
AppBundle\Entity\User 26
AppBundle\Entity\UserGroup 21
AppBundle\Entity\Department 8
AppBundle\Entity\AccountType 4
CustomBundle\Entity\Setting 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.
AppBundle\Entity\Role No errors.
AppBundle\Entity\Document No errors.
AppBundle\Entity\AccountType No errors.
AppBundle\Entity\Account
  • The mappings AppBundle\Entity\Account#metricTriggers and AppBundle\Entity\MetricTrigger\CsaTrigger#account are inconsistent with each other.
  • The association AppBundle\Entity\Account#user refers to the inverse side field AppBundle\Entity\User#account which does not exist.
  • The field AppBundle\Entity\Account#accountObjective is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AccountObjective#account does not contain the required 'inversedBy="accountObjective"' attribute.
  • The field AppBundle\Entity\Account#accountCampaignObjective is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AccountCampaignObjective#account does not contain the required 'inversedBy="accountCampaignObjective"' attribute.
  • The field AppBundle\Entity\Account#accountConversionAction is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AccountConversionAction#account does not contain the required 'inversedBy="accountConversionAction"' attribute.
  • The association AppBundle\Entity\Account#jiraTicketUser refers to the inverse side field AppBundle\Entity\User#account which does not exist.
AppBundle\Entity\GoogleMerchantCenter
  • The field AppBundle\Entity\GoogleMerchantCenter#googleMerchantCenterProductSettings is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\GoogleMerchantCenterProductSettings#googleMerchantCenter does not contain the required 'inversedBy="googleMerchantCenterProductSettings"' attribute.
AppBundle\Entity\AI\Chat
  • The field AppBundle\Entity\AI\Chat#chatResponse is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AI\ChatResponse#chat does not contain the required 'inversedBy="chatResponse"' attribute.
  • The field AppBundle\Entity\AI\Chat#chatUpload is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AI\ChatUpload#chat does not contain the required 'inversedBy="chatUpload"' attribute.
  • The field AppBundle\Entity\AI\Chat#chatPermissionUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AI\ChatPermission#chat does not contain the required 'inversedBy="chatPermissionUser"' attribute.
  • The field AppBundle\Entity\AI\Chat#chatPermissionDepartment is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\AI\ChatPermission#chat does not contain the required 'inversedBy="chatPermissionDepartment"' attribute.
AppBundle\Entity\CrawlerConfig No errors.
AppBundle\Entity\PagePurpose No errors.
AppBundle\Entity\DomainType No errors.

api_data entity manager

No loaded entities.

pv entity manager

No loaded entities.