GET https://software.dualmoto.it/utente/mansionario/

Query Metrics

34 Database Queries
9 Different statements
12.09 ms Query time
0 Invalid entities
74 Managed entities

Queries

Group similar statements

# Time Info
1 0.92 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.role AS role_6, t0.one_time_code AS one_time_code_7, t0.expiration_one_time_code AS expiration_one_time_code_8, t0.is_active AS is_active_9, t0.is_account_activation AS is_account_activation_10, t0.is_email_notification_active AS is_email_notification_active_11, t0.theme AS theme_12, t0.directory_path AS directory_path_13, t14.id AS id_15, t14.avatar AS avatar_16, t14.user_id AS user_id_17, t18.id AS id_19, t18.is_terms_accepted AS is_terms_accepted_20, t18.datetime_last_update AS datetime_last_update_21, t18.user_id AS user_id_22 FROM dm_user t0 LEFT JOIN dm_user_profile t14 ON t14.user_id = t0.id LEFT JOIN dm_user_privacy t18 ON t18.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  "3"
]
2 0.70 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3, t0.permission_id AS permission_id_4 FROM dm_join_table_user_permission t0 WHERE t0.user_id = ?
Parameters:
[
  "3"
]
3 0.53 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.52 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 0.33 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  3
]
6 0.33 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  4
]
7 0.33 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  5
]
8 0.27 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  6
]
9 0.30 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  7
]
10 0.27 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  8
]
11 0.27 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  9
]
12 0.27 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  10
]
13 0.30 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  11
]
14 0.28 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  12
]
15 0.26 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  13
]
16 0.27 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  14
]
17 0.26 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  15
]
18 0.25 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  16
]
19 0.28 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  17
]
20 0.27 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  18
]
21 0.27 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  19
]
22 0.28 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  21
]
23 0.26 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  22
]
24 0.30 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  23
]
25 0.26 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  24
]
26 0.26 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?
Parameters:
[
  25
]
27 0.35 ms
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dm_to_do_list d0_
Parameters:
[]
28 0.37 ms
SELECT DISTINCT d0_.id AS id_0, d0_.name AS name_1 FROM dm_to_do_list d0_ ORDER BY d0_.name ASC LIMIT 25
Parameters:
[]
29 0.39 ms
SELECT d0_.name AS name_0, d0_.cadence AS cadence_1, d0_.start_date AS start_date_2, d0_.end_date AS end_date_3, d0_.last_date_execution AS last_date_execution_4, d0_.id AS id_5, d0_.is_active AS is_active_6 FROM dm_to_do_list d0_ WHERE d0_.id IN (?, ?) ORDER BY d0_.name ASC
Parameters:
[
  2
  1
]
30 0.52 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.role AS role_6, t0.one_time_code AS one_time_code_7, t0.expiration_one_time_code AS expiration_one_time_code_8, t0.is_active AS is_active_9, t0.is_account_activation AS is_account_activation_10, t0.is_email_notification_active AS is_email_notification_active_11, t0.theme AS theme_12, t0.directory_path AS directory_path_13, t14.id AS id_15, t14.avatar AS avatar_16, t14.user_id AS user_id_17, t18.id AS id_19, t18.is_terms_accepted AS is_terms_accepted_20, t18.datetime_last_update AS datetime_last_update_21, t18.user_id AS user_id_22 FROM dm_user t0 LEFT JOIN dm_user_profile t14 ON t14.user_id = t0.id LEFT JOIN dm_user_privacy t18 ON t18.user_id = t0.id WHERE t0.role = ? ORDER BY t0.surname ASC
Parameters:
[
  "ROLE_USER"
]
31 0.45 ms
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.to_do_list_id AS to_do_list_id_3 FROM dm_join_table_user_to_do_list t0 WHERE t0.to_do_list_id = ?
Parameters:
[
  "2"
]
32 0.45 ms
SELECT t0.name AS name_1, t0.id AS id_2, t0.is_active AS is_active_3 FROM dm_item t0 INNER JOIN dm_to_do_list_item ON t0.id = dm_to_do_list_item.item_id WHERE dm_to_do_list_item.to_do_list_id = ? ORDER BY t0.name ASC
Parameters:
[
  "2"
]
33 0.32 ms
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.to_do_list_id AS to_do_list_id_3 FROM dm_join_table_user_to_do_list t0 WHERE t0.to_do_list_id = ?
Parameters:
[
  "1"
]
34 0.38 ms
SELECT t0.name AS name_1, t0.id AS id_2, t0.is_active AS is_active_3 FROM dm_item t0 INNER JOIN dm_to_do_list_item ON t0.id = dm_to_do_list_item.item_id WHERE dm_to_do_list_item.to_do_list_id = ? ORDER BY t0.name ASC
Parameters:
[
  "1"
]

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\JoinTableUserPermission 24
App\Entity\Permission 24
App\Entity\PermissionCategory 9
App\Entity\User 6
App\Entity\Item 4
App\Entity\JoinTableUserToDoList 3
App\Entity\UserProfile 2
App\Entity\ToDoList 2

Entities Mapping