POST http://crm.studio128k.com/login

Query Metrics

57 Database Queries
10 Different statements
10.72 ms Query time
2 Invalid entities
137 Managed entities

Queries

Group similar statements

# Time Info
1 0.31 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.surnames AS surnames_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.last_login AS last_login_9, t0.status AS status_10, t0.dark_mode AS dark_mode_11, t0.menu_expanded AS menu_expanded_12, t0.locale AS locale_13, t0.address AS address_14, t0.bio AS bio_15, t0.img_profile_id AS img_profile_id_16 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "info@studio128k.com"
]
2 0.44 ms
SELECT t0.user_id AS user_id_1, t0.role_id AS role_id_2 FROM user_has_role t0 WHERE t0.user_id = ?
Parameters:
[
  "019df6eb-150c-7d11-94b5-0b82926a9bd1"
]
3 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.admin AS admin_4, t0.description AS description_5, t0.company_id AS company_id_6 FROM role t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.31 ms
SELECT t0.user_id AS user_id_1, t0.permission_id AS permission_id_2 FROM user_has_permission t0 WHERE t0.user_id = ?
Parameters:
[
  "019df6eb-150c-7d11-94b5-0b82926a9bd1"
]
5 0.21 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM permission_group t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.16 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 0.16 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  3
]
9 0.15 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  4
]
10 0.18 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  5
]
11 0.17 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  6
]
12 0.14 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  7
]
13 0.17 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  8
]
14 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  9
]
15 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM permission_group t0 WHERE t0.id = ?
Parameters:
[
  2
]
16 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  10
]
17 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  11
]
18 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  12
]
19 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  13
]
20 0.14 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  14
]
21 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM permission_group t0 WHERE t0.id = ?
Parameters:
[
  3
]
22 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  15
]
23 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  16
]
24 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  17
]
25 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  18
]
26 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  19
]
27 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM permission_group t0 WHERE t0.id = ?
Parameters:
[
  4
]
28 0.14 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  20
]
29 0.14 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  21
]
30 0.14 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  22
]
31 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  23
]
32 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  24
]
33 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  25
]
34 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM permission_group t0 WHERE t0.id = ?
Parameters:
[
  5
]
35 0.17 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  26
]
36 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  27
]
37 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  28
]
38 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  29
]
39 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  30
]
40 0.24 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  31
]
41 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM permission_group t0 WHERE t0.id = ?
Parameters:
[
  6
]
42 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  32
]
43 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  33
]
44 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  34
]
45 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  35
]
46 0.16 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  36
]
47 0.14 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  37
]
48 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM permission_group t0 WHERE t0.id = ?
Parameters:
[
  7
]
49 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  38
]
50 0.14 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  39
]
51 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  40
]
52 0.14 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  41
]
53 0.18 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.action AS action_3, t0.description AS description_4, t0.admin_managed AS admin_managed_5, t0.module_dependant AS module_dependant_6, t0.group_id AS group_id_7 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  42
]
54 0.18 ms
SELECT t0.role_id AS role_id_1, t0.permission_id AS permission_id_2 FROM role_has_permission t0 WHERE t0.role_id = ?
Parameters:
[
  1
]
55 0.15 ms
"START TRANSACTION"
Parameters:
[]
56 0.31 ms
UPDATE user SET last_login = ? WHERE id = ?
Parameters:
[
  "2026-05-18 13:47:14"
  "019df6eb-150c-7d11-94b5-0b82926a9bd1"
]
57 1.77 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User\UserHasPermission 42
App\Entity\Permission\Permission 42
App\Entity\Role\RoleHasPermission 42
App\Entity\Permission\PermissionGroup 7
App\Entity\User\User 1
App\Entity\Document\Document 1
App\Entity\User\UserHasRole 1
App\Entity\Role\Role 1

Entities Mapping

Class Mapping errors
App\Entity\User\User
  • The field App\Entity\User\User#tasks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Task\Task#assignedUsers does not contain the required 'inversedBy: "tasks"' attribute.
App\Entity\Document\Document
  • The field App\Entity\Document\Document#projectHasDocuments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Project\ProjectHasDocument#document does not contain the required 'inversedBy: "projectHasDocuments"' attribute.
App\Entity\User\UserHasDocument No errors.
App\Entity\User\UserHasRole No errors.
App\Entity\User\UserHasPermission No errors.
App\Entity\Company\Company No errors.
App\Entity\Task\Task No errors.
App\Entity\Role\Role No errors.
App\Entity\Role\RoleHasPermission No errors.
App\Entity\Permission\Permission No errors.
App\Entity\Permission\PermissionGroup No errors.