1
0.58 ms
SELECT DISTINCT u0_ . id AS id_0 , u0_ . id AS id_1 , u0_ . created_at AS created_at_2 FROM `user` u0_ ORDER BY u0_ . id ASC , u0_ . created_at DESC LIMIT 20 OFFSET 160
SELECT DISTINCT u0_ . id AS id_0 , u0_ . id AS id_1 , u0_ . created_at AS created_at_2 FROM `user` u0_ ORDER BY u0_ . id ASC , u0_ . created_at DESC LIMIT 20 OFFSET 160 ;
Copy
2
0.55 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_ . id ASC , u0_ . created_at DESC
Parameters :
[
"ec72a87a-ce0e-5643-a5ae-02d80a14d02f "
"f06cc095-175a-5a33-9611-3139f2248a3a "
"f0fbcf6e-e221-54f9-8251-6281b06741a2 "
"f2aa10a1-52a4-5da8-a8ac-61f2719e6768 "
"f47694e9-b8ec-11f0-a10c-a0ad9f24310d "
"f477845e-b8ec-11f0-a10c-a0ad9f24310d "
"f48394b3-9996-53db-85e6-5f1b9605e6c8 "
"f9b44db3-14c3-50a9-9195-0d171c6d2d9a "
"fb517d24-b1e8-597a-a951-577cc83eb600 "
"fd4035ff-a857-5041-a857-bd5a10527559 "
"fe696fe7-f5d5-5939-a1ff-5e3065181a29 "
"fec312ac-6e9e-5aac-a338-830a78e46ec7 "
]
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 ('ec72a87a-ce0e-5643-a5ae-02d80a14d02f' , 'f06cc095-175a-5a33-9611-3139f2248a3a' , 'f0fbcf6e-e221-54f9-8251-6281b06741a2' , 'f2aa10a1-52a4-5da8-a8ac-61f2719e6768' , 'f47694e9-b8ec-11f0-a10c-a0ad9f24310d' , 'f477845e-b8ec-11f0-a10c-a0ad9f24310d' , 'f48394b3-9996-53db-85e6-5f1b9605e6c8' , 'f9b44db3-14c3-50a9-9195-0d171c6d2d9a' , 'fb517d24-b1e8-597a-a951-577cc83eb600' , 'fd4035ff-a857-5041-a857-bd5a10527559' , 'fe696fe7-f5d5-5939-a1ff-5e3065181a29' , 'fec312ac-6e9e-5aac-a338-830a78e46ec7' ) ORDER BY u0_ . id ASC , u0_ . created_at DESC ;
Copy
3
0.29 ms
SELECT count (* ) AS sclr_0 FROM `user` u0_
SELECT count (* ) AS sclr_0 FROM `user` u0_ ;
Copy
4
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 :
[
"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
5
0.39 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 :
[
"f06cc095-175a-5a33-9611-3139f2248a3a "
]
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 = 'f06cc095-175a-5a33-9611-3139f2248a3a' ;
Copy
6
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 :
[
"f0fbcf6e-e221-54f9-8251-6281b06741a2 "
]
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 = 'f0fbcf6e-e221-54f9-8251-6281b06741a2' ;
Copy
7
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 :
[
"f2aa10a1-52a4-5da8-a8ac-61f2719e6768 "
]
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 = 'f2aa10a1-52a4-5da8-a8ac-61f2719e6768' ;
Copy
8
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 :
[
"f47694e9-b8ec-11f0-a10c-a0ad9f24310d "
]
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 = 'f47694e9-b8ec-11f0-a10c-a0ad9f24310d' ;
Copy
9
0.26 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 :
[
"f477845e-b8ec-11f0-a10c-a0ad9f24310d "
]
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 = 'f477845e-b8ec-11f0-a10c-a0ad9f24310d' ;
Copy
10
0.27 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 :
[
"f48394b3-9996-53db-85e6-5f1b9605e6c8 "
]
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 = 'f48394b3-9996-53db-85e6-5f1b9605e6c8' ;
Copy
11
0.27 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 :
[
"f9b44db3-14c3-50a9-9195-0d171c6d2d9a "
]
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 = 'f9b44db3-14c3-50a9-9195-0d171c6d2d9a' ;
Copy
12
0.25 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 :
[
"fb517d24-b1e8-597a-a951-577cc83eb600 "
]
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 = 'fb517d24-b1e8-597a-a951-577cc83eb600' ;
Copy
13
0.27 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 :
[
"fd4035ff-a857-5041-a857-bd5a10527559 "
]
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 = 'fd4035ff-a857-5041-a857-bd5a10527559' ;
Copy
14
0.26 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 :
[
"fe696fe7-f5d5-5939-a1ff-5e3065181a29 "
]
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 = 'fe696fe7-f5d5-5939-a1ff-5e3065181a29' ;
Copy
15
0.25 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 :
[
"fec312ac-6e9e-5aac-a338-830a78e46ec7 "
]
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 = 'fec312ac-6e9e-5aac-a338-830a78e46ec7' ;
Copy