1
1.18 ms
SELECT DISTINCT u0_ . id AS id_0 , u0_ . roles AS roles_1 , u0_ . created_at AS created_at_2 FROM `user` u0_ ORDER BY u0_ . roles ASC , u0_ . created_at DESC LIMIT 20 OFFSET 160
SELECT DISTINCT u0_ . id AS id_0 , u0_ . roles AS roles_1 , u0_ . created_at AS created_at_2 FROM `user` u0_ ORDER BY u0_ . roles ASC , u0_ . created_at DESC LIMIT 20 OFFSET 160 ;
Copy
2
0.67 ms
SELECT u0_ . id AS id_0 , u0_ . email AS email_1 , u0_ . roles AS roles_2 , u0_ . password AS password_3 , u0_ . first_name AS first_name_4 , u0_ . last_name AS last_name_5 , u0_ . is_active AS is_active_6 , u0_ . created_at AS created_at_7 , u0_ . type_person AS type_person_8 , u0_ . nif AS nif_9 , u0_ . company_name AS company_name_10 , u0_ . alias AS alias_11 , u0_ . logo AS logo_12 FROM `user` u0_ WHERE u0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY u0_ . roles ASC , u0_ . created_at DESC
Parameters :
[
"d71e4d9c-cd23-595a-945d-a4c4130fedf7 "
"e742b24f-c7d4-530e-b483-4721db22f54e "
"20bd20a1-61ed-5cf3-8d82-0d073709c0a5 "
"8fdd5a05-3d76-55ea-b2d4-8235a95c3398 "
"e06e98d8-42c1-5629-bfcf-8b7cb7355381 "
"ec72a87a-ce0e-5643-a5ae-02d80a14d02f "
"6eba9df8-f791-5143-a608-c5809d6275be "
"50044f83-9a21-5b9e-9d75-aab4ed7d0cb3 "
"afe081d9-7ce9-5127-bcbb-97a662e79a35 "
"bed6ed88-cf19-557b-aa1a-e9c54aa461f2 "
"b2c601a4-109f-59ab-977b-df01d09d6c9b "
"22ebb1b9-6ea1-52c2-b451-df93fecdc7b5 "
]
SELECT u0_ . id AS id_0 , u0_ . email AS email_1 , u0_ . roles AS roles_2 , u0_ . password AS password_3 , u0_ . first_name AS first_name_4 , u0_ . last_name AS last_name_5 , u0_ . is_active AS is_active_6 , u0_ . created_at AS created_at_7 , u0_ . type_person AS type_person_8 , u0_ . nif AS nif_9 , u0_ . company_name AS company_name_10 , u0_ . alias AS alias_11 , u0_ . logo AS logo_12 FROM `user` u0_ WHERE u0_ . id IN ('d71e4d9c-cd23-595a-945d-a4c4130fedf7' , 'e742b24f-c7d4-530e-b483-4721db22f54e' , '20bd20a1-61ed-5cf3-8d82-0d073709c0a5' , '8fdd5a05-3d76-55ea-b2d4-8235a95c3398' , 'e06e98d8-42c1-5629-bfcf-8b7cb7355381' , 'ec72a87a-ce0e-5643-a5ae-02d80a14d02f' , '6eba9df8-f791-5143-a608-c5809d6275be' , '50044f83-9a21-5b9e-9d75-aab4ed7d0cb3' , 'afe081d9-7ce9-5127-bcbb-97a662e79a35' , 'bed6ed88-cf19-557b-aa1a-e9c54aa461f2' , 'b2c601a4-109f-59ab-977b-df01d09d6c9b' , '22ebb1b9-6ea1-52c2-b451-df93fecdc7b5' ) ORDER BY u0_ . roles ASC , u0_ . created_at DESC ;
Copy
3
0.39 ms
SELECT count (* ) AS sclr_0 FROM `user` u0_
SELECT count (* ) AS sclr_0 FROM `user` u0_ ;
Copy
4
0.50 ms
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = ?
Parameters :
[
"d71e4d9c-cd23-595a-945d-a4c4130fedf7 "
]
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = 'd71e4d9c-cd23-595a-945d-a4c4130fedf7' ;
Copy
5
0.46 ms
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = ?
Parameters :
[
"e742b24f-c7d4-530e-b483-4721db22f54e "
]
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = 'e742b24f-c7d4-530e-b483-4721db22f54e' ;
Copy
6
0.33 ms
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = ?
Parameters :
[
"20bd20a1-61ed-5cf3-8d82-0d073709c0a5 "
]
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = '20bd20a1-61ed-5cf3-8d82-0d073709c0a5' ;
Copy
7
0.30 ms
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = ?
Parameters :
[
"8fdd5a05-3d76-55ea-b2d4-8235a95c3398 "
]
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = '8fdd5a05-3d76-55ea-b2d4-8235a95c3398' ;
Copy
8
0.31 ms
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = ?
Parameters :
[
"e06e98d8-42c1-5629-bfcf-8b7cb7355381 "
]
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = 'e06e98d8-42c1-5629-bfcf-8b7cb7355381' ;
Copy
9
0.30 ms
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = ?
Parameters :
[
"ec72a87a-ce0e-5643-a5ae-02d80a14d02f "
]
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = 'ec72a87a-ce0e-5643-a5ae-02d80a14d02f' ;
Copy
10
0.31 ms
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = ?
Parameters :
[
"6eba9df8-f791-5143-a608-c5809d6275be "
]
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = '6eba9df8-f791-5143-a608-c5809d6275be' ;
Copy
11
0.29 ms
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = ?
Parameters :
[
"50044f83-9a21-5b9e-9d75-aab4ed7d0cb3 "
]
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = '50044f83-9a21-5b9e-9d75-aab4ed7d0cb3' ;
Copy
12
0.29 ms
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = ?
Parameters :
[
"afe081d9-7ce9-5127-bcbb-97a662e79a35 "
]
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = 'afe081d9-7ce9-5127-bcbb-97a662e79a35' ;
Copy
13
0.28 ms
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = ?
Parameters :
[
"bed6ed88-cf19-557b-aa1a-e9c54aa461f2 "
]
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = 'bed6ed88-cf19-557b-aa1a-e9c54aa461f2' ;
Copy
14
0.31 ms
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = ?
Parameters :
[
"b2c601a4-109f-59ab-977b-df01d09d6c9b "
]
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = 'b2c601a4-109f-59ab-977b-df01d09d6c9b' ;
Copy
15
0.31 ms
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = ?
Parameters :
[
"22ebb1b9-6ea1-52c2-b451-df93fecdc7b5 "
]
SELECT t0 . id AS id_1 , t0 . identifier AS identifier_2 , t0 . secret AS secret_3 , t0 . name AS name_4 , t0 . redirect_uris AS redirect_uris_5 , t0 . grant_types AS grant_types_6 , t0 . scopes AS scopes_7 , t0 . is_confidential AS is_confidential_8 , t0 . logo_url AS logo_url_9 , t0 . help_text AS help_text_10 , t0 . terms_url AS terms_url_11 , t0 . privacy_policy_url AS privacy_policy_url_12 , t0 . created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0 . id = user_oauth_client_access . oauth_client_id WHERE user_oauth_client_access . user_id = '22ebb1b9-6ea1-52c2-b451-df93fecdc7b5' ;
Copy