1
0.38 ms
SELECT DISTINCT u0_ . id AS id_0 , u0_ . created_at AS created_at_1 FROM `user` u0_ ORDER BY u0_ . created_at ASC LIMIT 20 OFFSET 200
SELECT DISTINCT u0_ . id AS id_0 , u0_ . created_at AS created_at_1 FROM `user` u0_ ORDER BY u0_ . created_at ASC LIMIT 20 OFFSET 200 ;
Copy
2
0.24 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_ . created_at ASC
Parameters :
[
"dac0517f-714b-4dba-986b-dc5ce189b02c "
"70d5ba54-49eb-4c74-b9dc-a8c6ff86e478 "
"f10a794e-7c70-4836-b817-3aabc1a35305 "
"911ae7da-6354-429b-b803-7fba990befd9 "
"098760db-261d-4a32-afb1-553016f0986d "
"f09025fd-b0eb-4f8e-8342-f465d0aee702 "
"1563d104-82ba-42ac-99a8-bd1dcd979569 "
"18ec988b-2ba0-4b06-9d8c-06bbd4962cc5 "
"33bb1148-9331-487b-bfac-e05a9acf4ff9 "
"25cb764c-04de-4c1e-b8af-fe6ad5f0cdc4 "
]
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 ('dac0517f-714b-4dba-986b-dc5ce189b02c' , '70d5ba54-49eb-4c74-b9dc-a8c6ff86e478' , 'f10a794e-7c70-4836-b817-3aabc1a35305' , '911ae7da-6354-429b-b803-7fba990befd9' , '098760db-261d-4a32-afb1-553016f0986d' , 'f09025fd-b0eb-4f8e-8342-f465d0aee702' , '1563d104-82ba-42ac-99a8-bd1dcd979569' , '18ec988b-2ba0-4b06-9d8c-06bbd4962cc5' , '33bb1148-9331-487b-bfac-e05a9acf4ff9' , '25cb764c-04de-4c1e-b8af-fe6ad5f0cdc4' ) ORDER BY u0_ . created_at ASC ;
Copy
3
0.16 ms
SELECT count (* ) AS sclr_0 FROM `user` u0_
SELECT count (* ) AS sclr_0 FROM `user` u0_ ;
Copy
4
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 . 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 :
[
"dac0517f-714b-4dba-986b-dc5ce189b02c "
]
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 = 'dac0517f-714b-4dba-986b-dc5ce189b02c' ;
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 :
[
"70d5ba54-49eb-4c74-b9dc-a8c6ff86e478 "
]
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 = '70d5ba54-49eb-4c74-b9dc-a8c6ff86e478' ;
Copy
6
0.18 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 :
[
"f10a794e-7c70-4836-b817-3aabc1a35305 "
]
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 = 'f10a794e-7c70-4836-b817-3aabc1a35305' ;
Copy
7
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 :
[
"911ae7da-6354-429b-b803-7fba990befd9 "
]
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 = '911ae7da-6354-429b-b803-7fba990befd9' ;
Copy
8
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 :
[
"098760db-261d-4a32-afb1-553016f0986d "
]
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 = '098760db-261d-4a32-afb1-553016f0986d' ;
Copy
9
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 :
[
"f09025fd-b0eb-4f8e-8342-f465d0aee702 "
]
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 = 'f09025fd-b0eb-4f8e-8342-f465d0aee702' ;
Copy
10
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 :
[
"1563d104-82ba-42ac-99a8-bd1dcd979569 "
]
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 = '1563d104-82ba-42ac-99a8-bd1dcd979569' ;
Copy
11
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 :
[
"18ec988b-2ba0-4b06-9d8c-06bbd4962cc5 "
]
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 = '18ec988b-2ba0-4b06-9d8c-06bbd4962cc5' ;
Copy
12
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 :
[
"33bb1148-9331-487b-bfac-e05a9acf4ff9 "
]
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 = '33bb1148-9331-487b-bfac-e05a9acf4ff9' ;
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 :
[
"25cb764c-04de-4c1e-b8af-fe6ad5f0cdc4 "
]
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 = '25cb764c-04de-4c1e-b8af-fe6ad5f0cdc4' ;
Copy