1
0.67 ms
SELECT DISTINCT u0_ . id AS id_0 , u0_ . created_at AS created_at_1 FROM `user` u0_ ORDER BY u0_ . created_at DESC LIMIT 20 OFFSET 160
SELECT DISTINCT u0_ . id AS id_0 , u0_ . created_at AS created_at_1 FROM `user` u0_ ORDER BY u0_ . created_at DESC LIMIT 20 OFFSET 160 ;
Copy
2
0.68 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_ . created_at DESC
Parameters :
[
"50044f83-9a21-5b9e-9d75-aab4ed7d0cb3 "
"6c8c459b-8607-5588-8950-0875da4cea6e "
"6d672b20-f982-59f7-8594-914a7cde0fe0 "
"7810f419-28d0-5ef5-8633-837d6f43bbff "
"76a66807-29d5-5453-8ab4-381e6ced0648 "
"762fa3ec-7873-56ac-b173-e3c56ad9fa79 "
"75443fed-8369-51f5-a054-f7d6d9833afa "
"73d1d021-8543-5816-8e4a-bd2a85e5bdfb "
"73881920-956a-5249-b8c7-99f7257c0c55 "
"6f2f543b-1ce2-571b-9143-499423387ec2 "
"6eba9df8-f791-5143-a608-c5809d6275be "
"a18c1f61-1254-555b-9c0a-6ed90412e687 "
]
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 ('50044f83-9a21-5b9e-9d75-aab4ed7d0cb3' , '6c8c459b-8607-5588-8950-0875da4cea6e' , '6d672b20-f982-59f7-8594-914a7cde0fe0' , '7810f419-28d0-5ef5-8633-837d6f43bbff' , '76a66807-29d5-5453-8ab4-381e6ced0648' , '762fa3ec-7873-56ac-b173-e3c56ad9fa79' , '75443fed-8369-51f5-a054-f7d6d9833afa' , '73d1d021-8543-5816-8e4a-bd2a85e5bdfb' , '73881920-956a-5249-b8c7-99f7257c0c55' , '6f2f543b-1ce2-571b-9143-499423387ec2' , '6eba9df8-f791-5143-a608-c5809d6275be' , 'a18c1f61-1254-555b-9c0a-6ed90412e687' ) ORDER BY u0_ . created_at DESC ;
Copy
3
0.45 ms
SELECT count (* ) AS sclr_0 FROM `user` u0_
SELECT count (* ) AS sclr_0 FROM `user` u0_ ;
Copy
4
0.63 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
5
0.51 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 :
[
"6c8c459b-8607-5588-8950-0875da4cea6e "
]
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 = '6c8c459b-8607-5588-8950-0875da4cea6e' ;
Copy
6
0.51 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 :
[
"6d672b20-f982-59f7-8594-914a7cde0fe0 "
]
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 = '6d672b20-f982-59f7-8594-914a7cde0fe0' ;
Copy
7
0.51 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
8
0.49 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 :
[
"6f2f543b-1ce2-571b-9143-499423387ec2 "
]
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 = '6f2f543b-1ce2-571b-9143-499423387ec2' ;
Copy
9
0.49 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 :
[
"73881920-956a-5249-b8c7-99f7257c0c55 "
]
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 = '73881920-956a-5249-b8c7-99f7257c0c55' ;
Copy
10
0.45 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 :
[
"73d1d021-8543-5816-8e4a-bd2a85e5bdfb "
]
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 = '73d1d021-8543-5816-8e4a-bd2a85e5bdfb' ;
Copy
11
0.37 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 :
[
"75443fed-8369-51f5-a054-f7d6d9833afa "
]
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 = '75443fed-8369-51f5-a054-f7d6d9833afa' ;
Copy
12
0.37 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 :
[
"762fa3ec-7873-56ac-b173-e3c56ad9fa79 "
]
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 = '762fa3ec-7873-56ac-b173-e3c56ad9fa79' ;
Copy
13
0.37 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 :
[
"76a66807-29d5-5453-8ab4-381e6ced0648 "
]
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 = '76a66807-29d5-5453-8ab4-381e6ced0648' ;
Copy
14
0.49 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 :
[
"7810f419-28d0-5ef5-8633-837d6f43bbff "
]
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 = '7810f419-28d0-5ef5-8633-837d6f43bbff' ;
Copy
15
0.48 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 :
[
"a18c1f61-1254-555b-9c0a-6ed90412e687 "
]
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 = 'a18c1f61-1254-555b-9c0a-6ed90412e687' ;
Copy