Query Metrics
186
Database Queries
15
Different statements
44.27 ms
Query time
9
Invalid entities
203
Managed entities
Queries
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 |
|
| AppBundle\Entity\UserGroup |
|
| AppBundle\Entity\Department |
|
| AppBundle\Entity\Customer |
|
| AppBundle\Entity\RoleDomainUser | No errors. |
| AppBundle\Entity\Permission | No errors. |
| AppBundle\Entity\PermissionEntity | No errors. |
| AppBundle\Entity\Contract | No errors. |
| CustomBundle\Entity\Setting | No errors. |
| AppBundle\Entity\CustomerDomainData | No errors. |
| AppBundle\Entity\Domain |
|
| AppBundle\Entity\CustomerDomainDataDescription |
|
| AppBundle\Entity\CmsSystem | No errors. |
| AppBundle\Entity\ComposerVersion | No errors. |
| AppBundle\Entity\Role | No errors. |
| AppBundle\Entity\Document | No errors. |
| AppBundle\Entity\AccountType | No errors. |
| AppBundle\Entity\Account |
|
| AppBundle\Entity\GoogleMerchantCenter |
|
| AppBundle\Entity\AI\Chat |
|
| 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.