1
0.45 ms
SELECT DISTINCT u0_ . id AS id_0 , u0_ . nif AS nif_1 , u0_ . created_at AS created_at_2 FROM `user` u0_ ORDER BY u0_ . nif ASC , u0_ . created_at DESC LIMIT 20 OFFSET 200
SELECT DISTINCT u0_ . id AS id_0 , u0_ . nif AS nif_1 , u0_ . created_at AS created_at_2 FROM `user` u0_ ORDER BY u0_ . nif ASC , u0_ . created_at DESC LIMIT 20 OFFSET 200 ;
Copy
2
0.28 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 , u0_ . reset_token AS reset_token_13 , u0_ . reset_token_expires_at AS reset_token_expires_at_14 FROM `user` u0_ WHERE u0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY u0_ . nif ASC , u0_ . created_at DESC
Parameters :
[
"ee70e61e-1688-4284-bab7-f19170f255d1 "
"80433ef0-732a-485a-9844-de5a93ef6918 "
"993ec639-687b-5208-bec0-aad285d36624 "
"ed2e740a-c96a-4381-9665-b27cc47a6932 "
"b2c601a4-109f-59ab-977b-df01d09d6c9b "
"84689e00-cfa4-5f32-870e-cc7680e75617 "
"e742b24f-c7d4-530e-b483-4721db22f54e "
"9dd6abb9-aff5-4ebe-a124-699026311b68 "
"f88bfab3-e409-4a2c-ae52-6fccde25af41 "
"d040e35f-e0c9-4995-848d-532bf5ded458 "
]
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 , u0_ . reset_token AS reset_token_13 , u0_ . reset_token_expires_at AS reset_token_expires_at_14 FROM `user` u0_ WHERE u0_ . id IN ('ee70e61e-1688-4284-bab7-f19170f255d1' , '80433ef0-732a-485a-9844-de5a93ef6918' , '993ec639-687b-5208-bec0-aad285d36624' , 'ed2e740a-c96a-4381-9665-b27cc47a6932' , 'b2c601a4-109f-59ab-977b-df01d09d6c9b' , '84689e00-cfa4-5f32-870e-cc7680e75617' , 'e742b24f-c7d4-530e-b483-4721db22f54e' , '9dd6abb9-aff5-4ebe-a124-699026311b68' , 'f88bfab3-e409-4a2c-ae52-6fccde25af41' , 'd040e35f-e0c9-4995-848d-532bf5ded458' ) ORDER BY u0_ . nif ASC , u0_ . created_at DESC ;
Copy
3
0.12 ms
SELECT count (* ) AS sclr_0 FROM `user` u0_
SELECT count (* ) AS sclr_0 FROM `user` u0_ ;
Copy
4
0.21 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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 :
[
"ee70e61e-1688-4284-bab7-f19170f255d1 "
]
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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 = 'ee70e61e-1688-4284-bab7-f19170f255d1' ;
Copy
5
0.19 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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 :
[
"80433ef0-732a-485a-9844-de5a93ef6918 "
]
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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 = '80433ef0-732a-485a-9844-de5a93ef6918' ;
Copy
6
0.15 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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 :
[
"993ec639-687b-5208-bec0-aad285d36624 "
]
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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 = '993ec639-687b-5208-bec0-aad285d36624' ;
Copy
7
0.13 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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 :
[
"ed2e740a-c96a-4381-9665-b27cc47a6932 "
]
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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 = 'ed2e740a-c96a-4381-9665-b27cc47a6932' ;
Copy
8
0.14 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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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
9
0.14 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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 :
[
"84689e00-cfa4-5f32-870e-cc7680e75617 "
]
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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 = '84689e00-cfa4-5f32-870e-cc7680e75617' ;
Copy
10
0.14 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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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
11
0.76 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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 :
[
"9dd6abb9-aff5-4ebe-a124-699026311b68 "
]
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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 = '9dd6abb9-aff5-4ebe-a124-699026311b68' ;
Copy
12
0.14 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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 :
[
"f88bfab3-e409-4a2c-ae52-6fccde25af41 "
]
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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 = 'f88bfab3-e409-4a2c-ae52-6fccde25af41' ;
Copy
13
0.13 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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 :
[
"d040e35f-e0c9-4995-848d-532bf5ded458 "
]
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 . auto_register AS auto_register_9 , t0 . logo_url AS logo_url_10 , t0 . help_text AS help_text_11 , t0 . terms_url AS terms_url_12 , t0 . privacy_policy_url AS privacy_policy_url_13 , t0 . created_at AS created_at_14 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 = 'd040e35f-e0c9-4995-848d-532bf5ded458' ;
Copy