POST http://staging.pilot.clicks.digital/api/verify-token

Query Metrics

150 Database Queries
4 Different statements
31.26 ms Query time
4 Invalid entities
557 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.49 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, t24.id AS id_25, t24.image_path AS image_path_26, t24.thumbnail_path AS thumbnail_path_27, t24.created_at AS created_at_28, t24.updated_at AS updated_at_29, t24.user_id AS user_id_30, t0.job_title_id AS job_title_id_31 FROM fos_user_user t0 LEFT JOIN user_profile_image t24 ON t24.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  9
]
2 0.38 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
]
3 0.55 ms
SELECT t0.id AS id_1, t0.can_create AS can_create_2, t0.can_edit AS can_edit_3, t0.can_show AS can_show_4, t0.can_delete AS can_delete_5, t0.can_export AS can_export_6, t0.can_log AS can_log_7, t0.can_run AS can_run_8, t0.can_undo AS can_undo_9, t0.can_data AS can_data_10, t0.can_see_all_entries AS can_see_all_entries_11, t0.permission_entity_id AS permission_entity_id_12, t0.user_id AS user_id_13, t0.user_group_id AS user_group_id_14 FROM permission t0 WHERE t0.user_group_id = ?
Parameters:
[
  1
]
4 0.32 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.id = ?
Parameters:
[
  10
]
5 0.26 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.id = ?
Parameters:
[
  16
]
6 0.22 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.id = ?
Parameters:
[
  20
]
7 0.23 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.id = ?
Parameters:
[
  40
]
8 0.20 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.id = ?
Parameters:
[
  60
]
9 0.20 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.id = ?
Parameters:
[
  71
]
10 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.id = ?
Parameters:
[
  74
]
11 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.id = ?
Parameters:
[
  79
]
12 0.25 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.id = ?
Parameters:
[
  84
]
13 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.id = ?
Parameters:
[
  119
]
14 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.id = ?
Parameters:
[
  128
]
15 0.27 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.id = ?
Parameters:
[
  137
]
16 0.20 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.id = ?
Parameters:
[
  145
]
17 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.id = ?
Parameters:
[
  151
]
18 0.20 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.id = ?
Parameters:
[
  158
]
19 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.id = ?
Parameters:
[
  166
]
20 0.23 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.id = ?
Parameters:
[
  178
]
21 0.20 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.id = ?
Parameters:
[
  189
]
22 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.id = ?
Parameters:
[
  198
]
23 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.id = ?
Parameters:
[
  221
]
24 0.20 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.id = ?
Parameters:
[
  239
]
25 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.id = ?
Parameters:
[
  258
]
26 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.id = ?
Parameters:
[
  269
]
27 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.id = ?
Parameters:
[
  281
]
28 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.id = ?
Parameters:
[
  288
]
29 0.23 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.id = ?
Parameters:
[
  297
]
30 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.id = ?
Parameters:
[
  299
]
31 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.id = ?
Parameters:
[
  307
]
32 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.id = ?
Parameters:
[
  313
]
33 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.id = ?
Parameters:
[
  320
]
34 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.id = ?
Parameters:
[
  325
]
35 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.id = ?
Parameters:
[
  333
]
36 0.20 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.id = ?
Parameters:
[
  340
]
37 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.id = ?
Parameters:
[
  345
]
38 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.id = ?
Parameters:
[
  352
]
39 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.id = ?
Parameters:
[
  373
]
40 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.id = ?
Parameters:
[
  382
]
41 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.id = ?
Parameters:
[
  389
]
42 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.id = ?
Parameters:
[
  393
]
43 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.id = ?
Parameters:
[
  399
]
44 0.24 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.id = ?
Parameters:
[
  409
]
45 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.id = ?
Parameters:
[
  427
]
46 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.id = ?
Parameters:
[
  431
]
47 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.id = ?
Parameters:
[
  462
]
48 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.id = ?
Parameters:
[
  507
]
49 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.id = ?
Parameters:
[
  510
]
50 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.id = ?
Parameters:
[
  519
]
51 0.22 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.id = ?
Parameters:
[
  527
]
52 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.id = ?
Parameters:
[
  531
]
53 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.id = ?
Parameters:
[
  539
]
54 0.20 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.id = ?
Parameters:
[
  548
]
55 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.id = ?
Parameters:
[
  553
]
56 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.id = ?
Parameters:
[
  566
]
57 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.id = ?
Parameters:
[
  571
]
58 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.id = ?
Parameters:
[
  574
]
59 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.id = ?
Parameters:
[
  595
]
60 0.23 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.id = ?
Parameters:
[
  599
]
61 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.id = ?
Parameters:
[
  603
]
62 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.id = ?
Parameters:
[
  613
]
63 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.id = ?
Parameters:
[
  620
]
64 0.20 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.id = ?
Parameters:
[
  636
]
65 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.id = ?
Parameters:
[
  637
]
66 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.id = ?
Parameters:
[
  638
]
67 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.id = ?
Parameters:
[
  639
]
68 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.id = ?
Parameters:
[
  652
]
69 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.id = ?
Parameters:
[
  665
]
70 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.id = ?
Parameters:
[
  670
]
71 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.id = ?
Parameters:
[
  681
]
72 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.id = ?
Parameters:
[
  693
]
73 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.id = ?
Parameters:
[
  707
]
74 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.id = ?
Parameters:
[
  727
]
75 0.24 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.id = ?
Parameters:
[
  737
]
76 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.id = ?
Parameters:
[
  748
]
77 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.id = ?
Parameters:
[
  753
]
78 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.id = ?
Parameters:
[
  772
]
79 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.id = ?
Parameters:
[
  784
]
80 0.20 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.id = ?
Parameters:
[
  791
]
81 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.id = ?
Parameters:
[
  795
]
82 0.22 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.id = ?
Parameters:
[
  797
]
83 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.id = ?
Parameters:
[
  806
]
84 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.id = ?
Parameters:
[
  1065
]
85 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.id = ?
Parameters:
[
  944
]
86 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.id = ?
Parameters:
[
  1000
]
87 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.id = ?
Parameters:
[
  1076
]
88 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.id = ?
Parameters:
[
  1022
]
89 0.20 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.id = ?
Parameters:
[
  948
]
90 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.id = ?
Parameters:
[
  843
]
91 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.id = ?
Parameters:
[
  1084
]
92 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.id = ?
Parameters:
[
  1104
]
93 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.id = ?
Parameters:
[
  1108
]
94 0.22 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.id = ?
Parameters:
[
  812
]
95 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.id = ?
Parameters:
[
  845
]
96 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.id = ?
Parameters:
[
  876
]
97 0.23 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.id = ?
Parameters:
[
  882
]
98 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.id = ?
Parameters:
[
  913
]
99 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.id = ?
Parameters:
[
  958
]
100 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.id = ?
Parameters:
[
  990
]
101 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.id = ?
Parameters:
[
  1038
]
102 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.id = ?
Parameters:
[
  1049
]
103 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.id = ?
Parameters:
[
  1056
]
104 0.23 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.id = ?
Parameters:
[
  1091
]
105 0.20 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.id = ?
Parameters:
[
  1097
]
106 0.20 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.id = ?
Parameters:
[
  1118
]
107 0.20 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.id = ?
Parameters:
[
  1129
]
108 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.id = ?
Parameters:
[
  1136
]
109 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.id = ?
Parameters:
[
  1141
]
110 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.id = ?
Parameters:
[
  1142
]
111 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.id = ?
Parameters:
[
  1143
]
112 0.23 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.id = ?
Parameters:
[
  1144
]
113 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.id = ?
Parameters:
[
  1145
]
114 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.id = ?
Parameters:
[
  1146
]
115 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.id = ?
Parameters:
[
  1147
]
116 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.id = ?
Parameters:
[
  1148
]
117 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.id = ?
Parameters:
[
  1149
]
118 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.id = ?
Parameters:
[
  1150
]
119 0.23 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.id = ?
Parameters:
[
  1151
]
120 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.id = ?
Parameters:
[
  1152
]
121 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.id = ?
Parameters:
[
  1155
]
122 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.id = ?
Parameters:
[
  1161
]
123 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.id = ?
Parameters:
[
  1172
]
124 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.id = ?
Parameters:
[
  1183
]
125 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.id = ?
Parameters:
[
  1184
]
126 0.23 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.id = ?
Parameters:
[
  1185
]
127 0.20 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.id = ?
Parameters:
[
  1186
]
128 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.id = ?
Parameters:
[
  1187
]
129 0.34 ms
SELECT t0.id AS id_1, t0.can_create AS can_create_2, t0.can_edit AS can_edit_3, t0.can_show AS can_show_4, t0.can_delete AS can_delete_5, t0.can_export AS can_export_6, t0.can_log AS can_log_7, t0.can_run AS can_run_8, t0.can_undo AS can_undo_9, t0.can_data AS can_data_10, t0.can_see_all_entries AS can_see_all_entries_11, t0.permission_entity_id AS permission_entity_id_12, t0.user_id AS user_id_13, t0.user_group_id AS user_group_id_14 FROM permission t0 WHERE t0.user_group_id = ?
Parameters:
[
  5
]
130 0.24 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.id = ?
Parameters:
[
  21
]
131 0.22 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.id = ?
Parameters:
[
  30
]
132 0.20 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.id = ?
Parameters:
[
  24
]
133 0.25 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.id = ?
Parameters:
[
  29
]
134 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.id = ?
Parameters:
[
  90
]
135 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.id = ?
Parameters:
[
  99
]
136 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.id = ?
Parameters:
[
  98
]
137 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.id = ?
Parameters:
[
  118
]
138 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.id = ?
Parameters:
[
  122
]
139 0.20 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.id = ?
Parameters:
[
  126
]
140 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.id = ?
Parameters:
[
  125
]
141 0.22 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.id = ?
Parameters:
[
  174
]
142 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.id = ?
Parameters:
[
  120
]
143 0.20 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.id = ?
Parameters:
[
  123
]
144 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.id = ?
Parameters:
[
  175
]
145 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.id = ?
Parameters:
[
  124
]
146 0.20 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.id = ?
Parameters:
[
  195
]
147 0.23 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.id = ?
Parameters:
[
  121
]
148 0.22 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.id = ?
Parameters:
[
  235
]
149 0.29 ms
SELECT t0.id AS id_1, t0.can_create AS can_create_2, t0.can_edit AS can_edit_3, t0.can_show AS can_show_4, t0.can_delete AS can_delete_5, t0.can_export AS can_export_6, t0.can_log AS can_log_7, t0.can_run AS can_run_8, t0.can_undo AS can_undo_9, t0.can_data AS can_data_10, t0.can_see_all_entries AS can_see_all_entries_11, t0.permission_entity_id AS permission_entity_id_12, t0.user_id AS user_id_13, t0.user_group_id AS user_group_id_14 FROM permission t0 WHERE t0.user_group_id = ?
Parameters:
[
  12
]
150 0.47 ms
SELECT t0.id AS id_1, t0.can_create AS can_create_2, t0.can_edit AS can_edit_3, t0.can_show AS can_show_4, t0.can_delete AS can_delete_5, t0.can_export AS can_export_6, t0.can_log AS can_log_7, t0.can_run AS can_run_8, t0.can_undo AS can_undo_9, t0.can_data AS can_data_10, t0.can_see_all_entries AS can_see_all_entries_11, t0.permission_entity_id AS permission_entity_id_12, t0.user_id AS user_id_13, t0.user_group_id AS user_group_id_14 FROM permission t0 WHERE t0.user_group_id = ?
Parameters:
[
  22
]

Database Connections

Name Service
default doctrine.dbal.default_connection
api_data doctrine.dbal.api_data_connection
pv doctrine.dbal.pv_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
api_data doctrine.orm.api_data_entity_manager
pv doctrine.orm.pv_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
AppBundle\Entity\Permission 407
AppBundle\Entity\PermissionEntity 144
AppBundle\Entity\UserGroup 4
AppBundle\Entity\User 1
AppBundle\Entity\UserProfileImage 1

api_data entity manager

Class Amount of managed objects

pv entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
AppBundle\Entity\User
  • The mappings AppBundle\Entity\User#groups and AppBundle\Entity\UserGroup#user are inconsistent with each other.
  • The field AppBundle\Entity\User#roleDomainUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\RoleDomainUser#user does not contain the required 'inversedBy="roleDomainUser"' attribute.
AppBundle\Entity\UserProfileImage No errors.
AppBundle\Entity\JobTitle No errors.
AppBundle\Entity\UserGroup
  • The association AppBundle\Entity\UserGroup#user refers to the inverse side field AppBundle\Entity\User#userGroup which does not exist.
  • The field AppBundle\Entity\UserGroup#permission is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Permission#userGroup does not contain the required 'inversedBy="permission"' attribute.
AppBundle\Entity\Department
  • The field AppBundle\Entity\Department#contract is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Contract#department does not contain the required 'inversedBy="contract"' attribute.
AppBundle\Entity\Customer
  • The field AppBundle\Entity\Customer#domain is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\Domain#customer does not contain the required 'inversedBy="domain"' attribute.
  • The field AppBundle\Entity\Customer#customSetting is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity CustomBundle\Entity\Setting#customer does not contain the required 'inversedBy="customSetting"' attribute.
  • The association AppBundle\Entity\Customer#pvDepartment refers to the inverse side field AppBundle\Entity\Department#customer which does not exist.
  • The field AppBundle\Entity\Customer#roleDomainUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AppBundle\Entity\RoleDomainUser#customer does not contain the required 'inversedBy="roleDomainUser"' attribute.
AppBundle\Entity\RoleDomainUser No errors.
AppBundle\Entity\Permission No errors.
AppBundle\Entity\PermissionEntity No errors.

api_data entity manager

No loaded entities.

pv entity manager

No loaded entities.