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 = ?
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 = '3' ;
Copy
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 = ?
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 = '3' ;
Copy
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 = ?
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 = 1 ;
Copy
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 = ?
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 = 2 ;
Copy
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 = ?
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 = 3 ;
Copy
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 = ?
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 = 4 ;
Copy
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 = ?
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 = 5 ;
Copy
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 = ?
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 = 6 ;
Copy
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 = ?
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 = 7 ;
Copy
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 = ?
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 = 8 ;
Copy
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 = ?
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 = 9 ;
Copy
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 = ?
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 = 10 ;
Copy
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 = ?
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 = 11 ;
Copy
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 = ?
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 = 12 ;
Copy
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 = ?
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 = 13 ;
Copy
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 = ?
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 = 14 ;
Copy
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 = ?
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 = 15 ;
Copy
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 = ?
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 = 16 ;
Copy
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 = ?
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 = 17 ;
Copy
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 = ?
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 = 18 ;
Copy
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 = ?
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 = 19 ;
Copy
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 = ?
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 = 21 ;
Copy
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 = ?
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 = 22 ;
Copy
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 = ?
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 = 23 ;
Copy
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 = ?
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 = 24 ;
Copy
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 = ?
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 = 25 ;
Copy
27
0.35 ms
SELECT count (DISTINCT d0_ . id ) AS sclr_0 FROM dm_to_do_list d0_
SELECT count (DISTINCT d0_ . id ) AS sclr_0 FROM dm_to_do_list d0_ ;
Copy
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
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 ;
Copy
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
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 (2 , 1 ) ORDER BY d0_ . name ASC ;
Copy
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 "
]
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 = 'ROLE_USER' ORDER BY t0 . surname ASC ;
Copy
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 = ?
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 = '2' ;
Copy
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
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 = '2' ORDER BY t0 . name ASC ;
Copy
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 = ?
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 = '1' ;
Copy
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
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 = '1' ORDER BY t0 . name ASC ;
Copy