1
20.33 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . surname AS surname_3 , t0 . email AS email_4 , t0 . dni AS dni_5 , t0 . document_type AS document_type_6 , t0 . mobile_phone AS mobile_phone_7 , t0 . office_phone AS office_phone_8 , t0 . position AS position_9 , t0 . address AS address_10 , t0 . city AS city_11 , t0 . state AS state_12 , t0 . zip_code AS zip_code_13 , t0 . country AS country_14 , t0 . locale AS locale_15 , t0 . reset_password_token AS reset_password_token_16 , t0 . password AS password_17 , t0 . mailbox AS mailbox_18 , t0 . roles AS roles_19 , t0 . mobile_phone_available_time AS mobile_phone_available_time_20 , t0 . office_phone_available_time AS office_phone_available_time_21 , t0 . is_favorite AS is_favorite_22 , t0 . privacy_policy_accepted_at AS privacy_policy_accepted_at_23 , t0 . password_changed_at AS password_changed_at_24 , t0 . disabled_at AS disabled_at_25 , t0 . previous_login_ip AS previous_login_ip_26 , t0 . previous_login_at AS previous_login_at_27 , t0 . last_login_ip AS last_login_ip_28 , t0 . last_login_at AS last_login_at_29 , t0 . tos_accepted_at AS tos_accepted_at_30 , t0 . auth_code AS auth_code_31 , t0 . double_factor_method AS double_factor_method_32 , t0 . expires_at AS expires_at_33 , t0 . failed_password_attempts AS failed_password_attempts_34 , t0 . failed_password_locked_at AS failed_password_locked_at_35 , t0 . created_at AS created_at_36 , t0 . updated_at AS updated_at_37 , t0 . default_customer_id AS default_customer_id_38 , t0 . default_provider_id AS default_provider_id_39 , t0 . backoffice_profile_id AS backoffice_profile_id_40 FROM users t0 WHERE t0 . email = ? ORDER BY (SELECT 0 ) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters :
[
"fernandodbeaulieu@gmail.com "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . surname AS surname_3 , t0 . email AS email_4 , t0 . dni AS dni_5 , t0 . document_type AS document_type_6 , t0 . mobile_phone AS mobile_phone_7 , t0 . office_phone AS office_phone_8 , t0 . position AS position_9 , t0 . address AS address_10 , t0 . city AS city_11 , t0 . state AS state_12 , t0 . zip_code AS zip_code_13 , t0 . country AS country_14 , t0 . locale AS locale_15 , t0 . reset_password_token AS reset_password_token_16 , t0 . password AS password_17 , t0 . mailbox AS mailbox_18 , t0 . roles AS roles_19 , t0 . mobile_phone_available_time AS mobile_phone_available_time_20 , t0 . office_phone_available_time AS office_phone_available_time_21 , t0 . is_favorite AS is_favorite_22 , t0 . privacy_policy_accepted_at AS privacy_policy_accepted_at_23 , t0 . password_changed_at AS password_changed_at_24 , t0 . disabled_at AS disabled_at_25 , t0 . previous_login_ip AS previous_login_ip_26 , t0 . previous_login_at AS previous_login_at_27 , t0 . last_login_ip AS last_login_ip_28 , t0 . last_login_at AS last_login_at_29 , t0 . tos_accepted_at AS tos_accepted_at_30 , t0 . auth_code AS auth_code_31 , t0 . double_factor_method AS double_factor_method_32 , t0 . expires_at AS expires_at_33 , t0 . failed_password_attempts AS failed_password_attempts_34 , t0 . failed_password_locked_at AS failed_password_locked_at_35 , t0 . created_at AS created_at_36 , t0 . updated_at AS updated_at_37 , t0 . default_customer_id AS default_customer_id_38 , t0 . default_provider_id AS default_provider_id_39 , t0 . backoffice_profile_id AS backoffice_profile_id_40 FROM users t0 WHERE t0 . email = 'fernandodbeaulieu@gmail.com' ORDER BY (SELECT 0 ) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY ;
Copy
2
20.43 ms
SELECT b0_ . access_key AS access_key_0 FROM backoffice_permission b0_
SELECT b0_ . access_key AS access_key_0 FROM backoffice_permission b0_ ;
Copy
3
19.91 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 FROM backoffice_profile t0 WHERE t0 . id = ?
Parameters :
[
"e2a6cbbb-ea32-11ef-a96c-000c291403de "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 FROM backoffice_profile t0 WHERE t0 . id = 'e2a6cbbb-ea32-11ef-a96c-000c291403de' ;
Copy
4
20.75 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . description AS description_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . backoffice_permission_type_id AS backoffice_permission_type_id_7 FROM backoffice_permission t0 INNER JOIN backoffice_profile_backoffice_permission ON t0 . id = backoffice_profile_backoffice_permission . backoffice_permission_id WHERE backoffice_profile_backoffice_permission . backoffice_profile_id = ?
Parameters :
[
"e2a6cbbb-ea32-11ef-a96c-000c291403de "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . description AS description_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . backoffice_permission_type_id AS backoffice_permission_type_id_7 FROM backoffice_permission t0 INNER JOIN backoffice_profile_backoffice_permission ON t0 . id = backoffice_profile_backoffice_permission . backoffice_permission_id WHERE backoffice_profile_backoffice_permission . backoffice_profile_id = 'e2a6cbbb-ea32-11ef-a96c-000c291403de' ;
Copy
5
20.07 ms
SELECT t0 . id AS id_1 , t0 . external_id AS external_id_2 , t0 . code AS code_3 , t0 . name AS name_4 , t0 . tin AS tin_5 , t0 . status AS status_6 , t0 . type AS type_7 , t0 . company_type AS company_type_8 , t0 . partner_type AS partner_type_9 , t0 . address AS address_10 , t0 . city AS city_11 , t0 . state AS state_12 , t0 . zip_code AS zip_code_13 , t0 . country AS country_14 , t0 . language AS language_15 , t0 . notification_phone AS notification_phone_16 , t0 . notification_email AS notification_email_17 , t0 . technical_phone AS technical_phone_18 , t0 . technical_email AS technical_email_19 , t0 . observation AS observation_20 , t0 . disabled_at AS disabled_at_21 , t0 . can_be_hired AS can_be_hired_22 , t0 . id_customer_sst AS id_customer_sst_23 , t0 . block_level AS block_level_24 , t0 . ticket_notification_emails AS ticket_notification_emails_25 , t0 . customer_type AS customer_type_26 , t0 . created_at AS created_at_27 , t0 . updated_at AS updated_at_28 , t0 . main_user_id AS main_user_id_29 FROM customer t0 WHERE t0 . id = ?
Parameters :
[
"238576dc-ea5e-41fb-b50e-9dffd5f9612f "
]
SELECT t0 . id AS id_1 , t0 . external_id AS external_id_2 , t0 . code AS code_3 , t0 . name AS name_4 , t0 . tin AS tin_5 , t0 . status AS status_6 , t0 . type AS type_7 , t0 . company_type AS company_type_8 , t0 . partner_type AS partner_type_9 , t0 . address AS address_10 , t0 . city AS city_11 , t0 . state AS state_12 , t0 . zip_code AS zip_code_13 , t0 . country AS country_14 , t0 . language AS language_15 , t0 . notification_phone AS notification_phone_16 , t0 . notification_email AS notification_email_17 , t0 . technical_phone AS technical_phone_18 , t0 . technical_email AS technical_email_19 , t0 . observation AS observation_20 , t0 . disabled_at AS disabled_at_21 , t0 . can_be_hired AS can_be_hired_22 , t0 . id_customer_sst AS id_customer_sst_23 , t0 . block_level AS block_level_24 , t0 . ticket_notification_emails AS ticket_notification_emails_25 , t0 . customer_type AS customer_type_26 , t0 . created_at AS created_at_27 , t0 . updated_at AS updated_at_28 , t0 . main_user_id AS main_user_id_29 FROM customer t0 WHERE t0 . id = '238576dc-ea5e-41fb-b50e-9dffd5f9612f' ;
Copy
6
19.91 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . cpd_id AS cpd_id_4 , t0 . backoffice_user_id AS backoffice_user_id_5 FROM backoffice_user_cpd t0 WHERE t0 . backoffice_user_id = ?
Parameters :
[
"79721683-1d2d-456b-8dfd-9e87cff26796 "
]
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . cpd_id AS cpd_id_4 , t0 . backoffice_user_id AS backoffice_user_id_5 FROM backoffice_user_cpd t0 WHERE t0 . backoffice_user_id = '79721683-1d2d-456b-8dfd-9e87cff26796' ;
Copy
7
28.47 ms
SELECT DISTINCT id_0 , MIN (sclr_65 ) AS dctrn_minrownum FROM (SELECT u0_ . id AS id_0 , u0_ . name AS name_1 , u0_ . surname AS surname_2 , u0_ . email AS email_3 , u0_ . dni AS dni_4 , u0_ . document_type AS document_type_5 , u0_ . mobile_phone AS mobile_phone_6 , u0_ . office_phone AS office_phone_7 , u0_ . position AS position_8 , u0_ . address AS address_9 , u0_ . city AS city_10 , u0_ . state AS state_11 , u0_ . zip_code AS zip_code_12 , u0_ . country AS country_13 , u0_ . locale AS locale_14 , u0_ . reset_password_token AS reset_password_token_15 , u0_ . password AS password_16 , u0_ . mailbox AS mailbox_17 , u0_ . roles AS roles_18 , u0_ . mobile_phone_available_time AS mobile_phone_available_time_19 , u0_ . office_phone_available_time AS office_phone_available_time_20 , u0_ . is_favorite AS is_favorite_21 , u0_ . privacy_policy_accepted_at AS privacy_policy_accepted_at_22 , u0_ . password_changed_at AS password_changed_at_23 , u0_ . disabled_at AS disabled_at_24 , u0_ . previous_login_ip AS previous_login_ip_25 , u0_ . previous_login_at AS previous_login_at_26 , u0_ . last_login_ip AS last_login_ip_27 , u0_ . last_login_at AS last_login_at_28 , u0_ . tos_accepted_at AS tos_accepted_at_29 , u0_ . auth_code AS auth_code_30 , u0_ . double_factor_method AS double_factor_method_31 , u0_ . expires_at AS expires_at_32 , u0_ . failed_password_attempts AS failed_password_attempts_33 , u0_ . failed_password_locked_at AS failed_password_locked_at_34 , u0_ . created_at AS created_at_35 , u0_ . updated_at AS updated_at_36 , c1_ . id AS id_37 , c1_ . external_id AS external_id_38 , c1_ . code AS code_39 , c1_ . name AS name_40 , c1_ . tin AS tin_41 , c1_ . status AS status_42 , c1_ . type AS type_43 , c1_ . company_type AS company_type_44 , c1_ . partner_type AS partner_type_45 , c1_ . address AS address_46 , c1_ . city AS city_47 , c1_ . state AS state_48 , c1_ . zip_code AS zip_code_49 , c1_ . country AS country_50 , c1_ . language AS language_51 , c1_ . notification_phone AS notification_phone_52 , c1_ . notification_email AS notification_email_53 , c1_ . technical_phone AS technical_phone_54 , c1_ . technical_email AS technical_email_55 , c1_ . observation AS observation_56 , c1_ . disabled_at AS disabled_at_57 , c1_ . can_be_hired AS can_be_hired_58 , c1_ . id_customer_sst AS id_customer_sst_59 , c1_ . block_level AS block_level_60 , c1_ . ticket_notification_emails AS ticket_notification_emails_61 , c1_ . customer_type AS customer_type_62 , c1_ . created_at AS created_at_63 , c1_ . updated_at AS updated_at_64 , ROW_NUMBER () OVER (ORDER BY u0_ . name ASC ) AS sclr_65 FROM users u0_ INNER JOIN user_customer u2_ ON u0_ . id = u2_ . user_id INNER JOIN customer c1_ ON c1_ . id = u2_ . customer_id WHERE c1_ . id = ? AND u0_ . disabled_at IS NULL ) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC OFFSET 0 ROWS FETCH NEXT 100000 ROWS ONLY
Parameters :
[
"238576dc-ea5e-41fb-b50e-9dffd5f9612f "
]
SELECT
DISTINCT id_0 ,
MIN (sclr_65 ) AS dctrn_minrownum
FROM
(
SELECT
u0_ . id AS id_0 ,
u0_ . name AS name_1 ,
u0_ . surname AS surname_2 ,
u0_ . email AS email_3 ,
u0_ . dni AS dni_4 ,
u0_ . document_type AS document_type_5 ,
u0_ . mobile_phone AS mobile_phone_6 ,
u0_ . office_phone AS office_phone_7 ,
u0_ . position AS position_8 ,
u0_ . address AS address_9 ,
u0_ . city AS city_10 ,
u0_ . state AS state_11 ,
u0_ . zip_code AS zip_code_12 ,
u0_ . country AS country_13 ,
u0_ . locale AS locale_14 ,
u0_ . reset_password_token AS reset_password_token_15 ,
u0_ . password AS password_16 ,
u0_ . mailbox AS mailbox_17 ,
u0_ . roles AS roles_18 ,
u0_ . mobile_phone_available_time AS mobile_phone_available_time_19 ,
u0_ . office_phone_available_time AS office_phone_available_time_20 ,
u0_ . is_favorite AS is_favorite_21 ,
u0_ . privacy_policy_accepted_at AS privacy_policy_accepted_at_22 ,
u0_ . password_changed_at AS password_changed_at_23 ,
u0_ . disabled_at AS disabled_at_24 ,
u0_ . previous_login_ip AS previous_login_ip_25 ,
u0_ . previous_login_at AS previous_login_at_26 ,
u0_ . last_login_ip AS last_login_ip_27 ,
u0_ . last_login_at AS last_login_at_28 ,
u0_ . tos_accepted_at AS tos_accepted_at_29 ,
u0_ . auth_code AS auth_code_30 ,
u0_ . double_factor_method AS double_factor_method_31 ,
u0_ . expires_at AS expires_at_32 ,
u0_ . failed_password_attempts AS failed_password_attempts_33 ,
u0_ . failed_password_locked_at AS failed_password_locked_at_34 ,
u0_ . created_at AS created_at_35 ,
u0_ . updated_at AS updated_at_36 ,
c1_ . id AS id_37 ,
c1_ . external_id AS external_id_38 ,
c1_ . code AS code_39 ,
c1_ . name AS name_40 ,
c1_ . tin AS tin_41 ,
c1_ . status AS status_42 ,
c1_ . type AS type_43 ,
c1_ . company_type AS company_type_44 ,
c1_ . partner_type AS partner_type_45 ,
c1_ . address AS address_46 ,
c1_ . city AS city_47 ,
c1_ . state AS state_48 ,
c1_ . zip_code AS zip_code_49 ,
c1_ . country AS country_50 ,
c1_ . language AS language_51 ,
c1_ . notification_phone AS notification_phone_52 ,
c1_ . notification_email AS notification_email_53 ,
c1_ . technical_phone AS technical_phone_54 ,
c1_ . technical_email AS technical_email_55 ,
c1_ . observation AS observation_56 ,
c1_ . disabled_at AS disabled_at_57 ,
c1_ . can_be_hired AS can_be_hired_58 ,
c1_ . id_customer_sst AS id_customer_sst_59 ,
c1_ . block_level AS block_level_60 ,
c1_ . ticket_notification_emails AS ticket_notification_emails_61 ,
c1_ . customer_type AS customer_type_62 ,
c1_ . created_at AS created_at_63 ,
c1_ . updated_at AS updated_at_64 ,
ROW_NUMBER () OVER (
ORDER BY
u0_ . name ASC
) AS sclr_65
FROM
users u0_
INNER JOIN user_customer u2_ ON u0_ . id = u2_ . user_id
INNER JOIN customer c1_ ON c1_ . id = u2_ . customer_id
WHERE
c1_ . id = ?
AND u0_ . disabled_at IS NULL
) dctrn_result
GROUP BY
id_0
ORDER BY
dctrn_minrownum ASC
OFFSET
0
ROWS
FETCH
NEXT 100000
ROWS
ONLY
Copy
SELECT DISTINCT id_0 , MIN (sclr_65 ) AS dctrn_minrownum FROM (SELECT u0_ . id AS id_0 , u0_ . name AS name_1 , u0_ . surname AS surname_2 , u0_ . email AS email_3 , u0_ . dni AS dni_4 , u0_ . document_type AS document_type_5 , u0_ . mobile_phone AS mobile_phone_6 , u0_ . office_phone AS office_phone_7 , u0_ . position AS position_8 , u0_ . address AS address_9 , u0_ . city AS city_10 , u0_ . state AS state_11 , u0_ . zip_code AS zip_code_12 , u0_ . country AS country_13 , u0_ . locale AS locale_14 , u0_ . reset_password_token AS reset_password_token_15 , u0_ . password AS password_16 , u0_ . mailbox AS mailbox_17 , u0_ . roles AS roles_18 , u0_ . mobile_phone_available_time AS mobile_phone_available_time_19 , u0_ . office_phone_available_time AS office_phone_available_time_20 , u0_ . is_favorite AS is_favorite_21 , u0_ . privacy_policy_accepted_at AS privacy_policy_accepted_at_22 , u0_ . password_changed_at AS password_changed_at_23 , u0_ . disabled_at AS disabled_at_24 , u0_ . previous_login_ip AS previous_login_ip_25 , u0_ . previous_login_at AS previous_login_at_26 , u0_ . last_login_ip AS last_login_ip_27 , u0_ . last_login_at AS last_login_at_28 , u0_ . tos_accepted_at AS tos_accepted_at_29 , u0_ . auth_code AS auth_code_30 , u0_ . double_factor_method AS double_factor_method_31 , u0_ . expires_at AS expires_at_32 , u0_ . failed_password_attempts AS failed_password_attempts_33 , u0_ . failed_password_locked_at AS failed_password_locked_at_34 , u0_ . created_at AS created_at_35 , u0_ . updated_at AS updated_at_36 , c1_ . id AS id_37 , c1_ . external_id AS external_id_38 , c1_ . code AS code_39 , c1_ . name AS name_40 , c1_ . tin AS tin_41 , c1_ . status AS status_42 , c1_ . type AS type_43 , c1_ . company_type AS company_type_44 , c1_ . partner_type AS partner_type_45 , c1_ . address AS address_46 , c1_ . city AS city_47 , c1_ . state AS state_48 , c1_ . zip_code AS zip_code_49 , c1_ . country AS country_50 , c1_ . language AS language_51 , c1_ . notification_phone AS notification_phone_52 , c1_ . notification_email AS notification_email_53 , c1_ . technical_phone AS technical_phone_54 , c1_ . technical_email AS technical_email_55 , c1_ . observation AS observation_56 , c1_ . disabled_at AS disabled_at_57 , c1_ . can_be_hired AS can_be_hired_58 , c1_ . id_customer_sst AS id_customer_sst_59 , c1_ . block_level AS block_level_60 , c1_ . ticket_notification_emails AS ticket_notification_emails_61 , c1_ . customer_type AS customer_type_62 , c1_ . created_at AS created_at_63 , c1_ . updated_at AS updated_at_64 , ROW_NUMBER () OVER (ORDER BY u0_ . name ASC ) AS sclr_65 FROM users u0_ INNER JOIN user_customer u2_ ON u0_ . id = u2_ . user_id INNER JOIN customer c1_ ON c1_ . id = u2_ . customer_id WHERE c1_ . id = '238576dc-ea5e-41fb-b50e-9dffd5f9612f' AND u0_ . disabled_at IS NULL ) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC OFFSET 0 ROWS FETCH NEXT 100000 ROWS ONLY ;
Copy
8
20.55 ms
SELECT u0_ . id AS id_0 , u0_ . name AS name_1 , u0_ . surname AS surname_2 , u0_ . email AS email_3 , u0_ . dni AS dni_4 , u0_ . document_type AS document_type_5 , u0_ . mobile_phone AS mobile_phone_6 , u0_ . office_phone AS office_phone_7 , u0_ . position AS position_8 , u0_ . address AS address_9 , u0_ . city AS city_10 , u0_ . state AS state_11 , u0_ . zip_code AS zip_code_12 , u0_ . country AS country_13 , u0_ . locale AS locale_14 , u0_ . reset_password_token AS reset_password_token_15 , u0_ . password AS password_16 , u0_ . mailbox AS mailbox_17 , u0_ . roles AS roles_18 , u0_ . mobile_phone_available_time AS mobile_phone_available_time_19 , u0_ . office_phone_available_time AS office_phone_available_time_20 , u0_ . is_favorite AS is_favorite_21 , u0_ . privacy_policy_accepted_at AS privacy_policy_accepted_at_22 , u0_ . password_changed_at AS password_changed_at_23 , u0_ . disabled_at AS disabled_at_24 , u0_ . previous_login_ip AS previous_login_ip_25 , u0_ . previous_login_at AS previous_login_at_26 , u0_ . last_login_ip AS last_login_ip_27 , u0_ . last_login_at AS last_login_at_28 , u0_ . tos_accepted_at AS tos_accepted_at_29 , u0_ . auth_code AS auth_code_30 , u0_ . double_factor_method AS double_factor_method_31 , u0_ . expires_at AS expires_at_32 , u0_ . failed_password_attempts AS failed_password_attempts_33 , u0_ . failed_password_locked_at AS failed_password_locked_at_34 , u0_ . created_at AS created_at_35 , u0_ . updated_at AS updated_at_36 , c1_ . id AS id_37 , c1_ . external_id AS external_id_38 , c1_ . code AS code_39 , c1_ . name AS name_40 , c1_ . tin AS tin_41 , c1_ . status AS status_42 , c1_ . type AS type_43 , c1_ . company_type AS company_type_44 , c1_ . partner_type AS partner_type_45 , c1_ . address AS address_46 , c1_ . city AS city_47 , c1_ . state AS state_48 , c1_ . zip_code AS zip_code_49 , c1_ . country AS country_50 , c1_ . language AS language_51 , c1_ . notification_phone AS notification_phone_52 , c1_ . notification_email AS notification_email_53 , c1_ . technical_phone AS technical_phone_54 , c1_ . technical_email AS technical_email_55 , c1_ . observation AS observation_56 , c1_ . disabled_at AS disabled_at_57 , c1_ . can_be_hired AS can_be_hired_58 , c1_ . id_customer_sst AS id_customer_sst_59 , c1_ . block_level AS block_level_60 , c1_ . ticket_notification_emails AS ticket_notification_emails_61 , c1_ . customer_type AS customer_type_62 , c1_ . created_at AS created_at_63 , c1_ . updated_at AS updated_at_64 , u0_ . default_customer_id AS default_customer_id_65 , u0_ . default_provider_id AS default_provider_id_66 , u0_ . backoffice_profile_id AS backoffice_profile_id_67 , c1_ . main_user_id AS main_user_id_68 FROM users u0_ INNER JOIN user_customer u2_ ON u0_ . id = u2_ . user_id INNER JOIN customer c1_ ON c1_ . id = u2_ . customer_id WHERE c1_ . id = ? AND u0_ . disabled_at IS NULL AND u0_ . id IN (? , ? , ? , ? , ? ) ORDER BY u0_ . name ASC
Parameters :
[
"238576dc-ea5e-41fb-b50e-9dffd5f9612f "
"e3c7669a-bfb9-418e-b2d9-d14faef9b200 "
"79721683-1d2d-456b-8dfd-9e87cff26796 "
"4bcf2c0a-6b0b-4e85-87d5-6b5ecfc33e4b "
"4a6a5c5c-f4a8-4486-b4ac-748ae2cb5760 "
"86b92ab8-cbb1-4bde-b628-12971a2b109b "
]
SELECT
u0_ . id AS id_0 ,
u0_ . name AS name_1 ,
u0_ . surname AS surname_2 ,
u0_ . email AS email_3 ,
u0_ . dni AS dni_4 ,
u0_ . document_type AS document_type_5 ,
u0_ . mobile_phone AS mobile_phone_6 ,
u0_ . office_phone AS office_phone_7 ,
u0_ . position AS position_8 ,
u0_ . address AS address_9 ,
u0_ . city AS city_10 ,
u0_ . state AS state_11 ,
u0_ . zip_code AS zip_code_12 ,
u0_ . country AS country_13 ,
u0_ . locale AS locale_14 ,
u0_ . reset_password_token AS reset_password_token_15 ,
u0_ . password AS password_16 ,
u0_ . mailbox AS mailbox_17 ,
u0_ . roles AS roles_18 ,
u0_ . mobile_phone_available_time AS mobile_phone_available_time_19 ,
u0_ . office_phone_available_time AS office_phone_available_time_20 ,
u0_ . is_favorite AS is_favorite_21 ,
u0_ . privacy_policy_accepted_at AS privacy_policy_accepted_at_22 ,
u0_ . password_changed_at AS password_changed_at_23 ,
u0_ . disabled_at AS disabled_at_24 ,
u0_ . previous_login_ip AS previous_login_ip_25 ,
u0_ . previous_login_at AS previous_login_at_26 ,
u0_ . last_login_ip AS last_login_ip_27 ,
u0_ . last_login_at AS last_login_at_28 ,
u0_ . tos_accepted_at AS tos_accepted_at_29 ,
u0_ . auth_code AS auth_code_30 ,
u0_ . double_factor_method AS double_factor_method_31 ,
u0_ . expires_at AS expires_at_32 ,
u0_ . failed_password_attempts AS failed_password_attempts_33 ,
u0_ . failed_password_locked_at AS failed_password_locked_at_34 ,
u0_ . created_at AS created_at_35 ,
u0_ . updated_at AS updated_at_36 ,
c1_ . id AS id_37 ,
c1_ . external_id AS external_id_38 ,
c1_ . code AS code_39 ,
c1_ . name AS name_40 ,
c1_ . tin AS tin_41 ,
c1_ . status AS status_42 ,
c1_ . type AS type_43 ,
c1_ . company_type AS company_type_44 ,
c1_ . partner_type AS partner_type_45 ,
c1_ . address AS address_46 ,
c1_ . city AS city_47 ,
c1_ . state AS state_48 ,
c1_ . zip_code AS zip_code_49 ,
c1_ . country AS country_50 ,
c1_ . language AS language_51 ,
c1_ . notification_phone AS notification_phone_52 ,
c1_ . notification_email AS notification_email_53 ,
c1_ . technical_phone AS technical_phone_54 ,
c1_ . technical_email AS technical_email_55 ,
c1_ . observation AS observation_56 ,
c1_ . disabled_at AS disabled_at_57 ,
c1_ . can_be_hired AS can_be_hired_58 ,
c1_ . id_customer_sst AS id_customer_sst_59 ,
c1_ . block_level AS block_level_60 ,
c1_ . ticket_notification_emails AS ticket_notification_emails_61 ,
c1_ . customer_type AS customer_type_62 ,
c1_ . created_at AS created_at_63 ,
c1_ . updated_at AS updated_at_64 ,
u0_ . default_customer_id AS default_customer_id_65 ,
u0_ . default_provider_id AS default_provider_id_66 ,
u0_ . backoffice_profile_id AS backoffice_profile_id_67 ,
c1_ . main_user_id AS main_user_id_68
FROM
users u0_
INNER JOIN user_customer u2_ ON u0_ . id = u2_ . user_id
INNER JOIN customer c1_ ON c1_ . id = u2_ . customer_id
WHERE
c1_ . id = ?
AND u0_ . disabled_at IS NULL
AND u0_ . id IN (? , ? , ? , ? , ? )
ORDER BY
u0_ . name ASC
Copy
SELECT u0_ . id AS id_0 , u0_ . name AS name_1 , u0_ . surname AS surname_2 , u0_ . email AS email_3 , u0_ . dni AS dni_4 , u0_ . document_type AS document_type_5 , u0_ . mobile_phone AS mobile_phone_6 , u0_ . office_phone AS office_phone_7 , u0_ . position AS position_8 , u0_ . address AS address_9 , u0_ . city AS city_10 , u0_ . state AS state_11 , u0_ . zip_code AS zip_code_12 , u0_ . country AS country_13 , u0_ . locale AS locale_14 , u0_ . reset_password_token AS reset_password_token_15 , u0_ . password AS password_16 , u0_ . mailbox AS mailbox_17 , u0_ . roles AS roles_18 , u0_ . mobile_phone_available_time AS mobile_phone_available_time_19 , u0_ . office_phone_available_time AS office_phone_available_time_20 , u0_ . is_favorite AS is_favorite_21 , u0_ . privacy_policy_accepted_at AS privacy_policy_accepted_at_22 , u0_ . password_changed_at AS password_changed_at_23 , u0_ . disabled_at AS disabled_at_24 , u0_ . previous_login_ip AS previous_login_ip_25 , u0_ . previous_login_at AS previous_login_at_26 , u0_ . last_login_ip AS last_login_ip_27 , u0_ . last_login_at AS last_login_at_28 , u0_ . tos_accepted_at AS tos_accepted_at_29 , u0_ . auth_code AS auth_code_30 , u0_ . double_factor_method AS double_factor_method_31 , u0_ . expires_at AS expires_at_32 , u0_ . failed_password_attempts AS failed_password_attempts_33 , u0_ . failed_password_locked_at AS failed_password_locked_at_34 , u0_ . created_at AS created_at_35 , u0_ . updated_at AS updated_at_36 , c1_ . id AS id_37 , c1_ . external_id AS external_id_38 , c1_ . code AS code_39 , c1_ . name AS name_40 , c1_ . tin AS tin_41 , c1_ . status AS status_42 , c1_ . type AS type_43 , c1_ . company_type AS company_type_44 , c1_ . partner_type AS partner_type_45 , c1_ . address AS address_46 , c1_ . city AS city_47 , c1_ . state AS state_48 , c1_ . zip_code AS zip_code_49 , c1_ . country AS country_50 , c1_ . language AS language_51 , c1_ . notification_phone AS notification_phone_52 , c1_ . notification_email AS notification_email_53 , c1_ . technical_phone AS technical_phone_54 , c1_ . technical_email AS technical_email_55 , c1_ . observation AS observation_56 , c1_ . disabled_at AS disabled_at_57 , c1_ . can_be_hired AS can_be_hired_58 , c1_ . id_customer_sst AS id_customer_sst_59 , c1_ . block_level AS block_level_60 , c1_ . ticket_notification_emails AS ticket_notification_emails_61 , c1_ . customer_type AS customer_type_62 , c1_ . created_at AS created_at_63 , c1_ . updated_at AS updated_at_64 , u0_ . default_customer_id AS default_customer_id_65 , u0_ . default_provider_id AS default_provider_id_66 , u0_ . backoffice_profile_id AS backoffice_profile_id_67 , c1_ . main_user_id AS main_user_id_68 FROM users u0_ INNER JOIN user_customer u2_ ON u0_ . id = u2_ . user_id INNER JOIN customer c1_ ON c1_ . id = u2_ . customer_id WHERE c1_ . id = '238576dc-ea5e-41fb-b50e-9dffd5f9612f' AND u0_ . disabled_at IS NULL AND u0_ . id IN ('e3c7669a-bfb9-418e-b2d9-d14faef9b200' , '79721683-1d2d-456b-8dfd-9e87cff26796' , '4bcf2c0a-6b0b-4e85-87d5-6b5ecfc33e4b' , '4a6a5c5c-f4a8-4486-b4ac-748ae2cb5760' , '86b92ab8-cbb1-4bde-b628-12971a2b109b' ) ORDER BY u0_ . name ASC ;
Copy
9
20.20 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . customer_permission_id AS customer_permission_id_4 , t0 . user_id AS user_id_5 , t0 . customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0 . user_id = ?
Parameters :
[
"e3c7669a-bfb9-418e-b2d9-d14faef9b200 "
]
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . customer_permission_id AS customer_permission_id_4 , t0 . user_id AS user_id_5 , t0 . customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0 . user_id = 'e3c7669a-bfb9-418e-b2d9-d14faef9b200' ;
Copy
10
19.89 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = ?
Parameters :
[
"BA1B9E54-C7B5-4671-893D-E7D294719EDE "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = 'BA1B9E54-C7B5-4671-893D-E7D294719EDE' ;
Copy
11
19.95 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = ?
Parameters :
[
"B5E7BE34-F052-4B35-98B2-1BF6AD3C14C1 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = 'B5E7BE34-F052-4B35-98B2-1BF6AD3C14C1' ;
Copy
12
19.81 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = ?
Parameters :
[
"833604E2-25ED-46C6-BFD2-89BFAEF79465 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = '833604E2-25ED-46C6-BFD2-89BFAEF79465' ;
Copy
13
20.04 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = ?
Parameters :
[
"6b142aee-8d16-11ee-9abc-e00af667d704 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = '6b142aee-8d16-11ee-9abc-e00af667d704' ;
Copy
14
19.67 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = ?
Parameters :
[
"44C4DD48-2086-4F87-8E70-8156A316C1D5 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = '44C4DD48-2086-4F87-8E70-8156A316C1D5' ;
Copy
15
20.27 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = ?
Parameters :
[
"1a654952-309b-11ee-8d09-e00af667d704 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = '1a654952-309b-11ee-8d09-e00af667d704' ;
Copy
16
20.38 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = ?
Parameters :
[
"42C4927F-60C7-43F7-BA70-DBE217927B02 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = '42C4927F-60C7-43F7-BA70-DBE217927B02' ;
Copy
17
19.75 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = ?
Parameters :
[
"344B8D51-361B-4A7B-8D98-C241CD11A3C1 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = '344B8D51-361B-4A7B-8D98-C241CD11A3C1' ;
Copy
18
19.60 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = ?
Parameters :
[
"ea12f7df-2adb-11ee-8d09-e00af667d704 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = 'ea12f7df-2adb-11ee-8d09-e00af667d704' ;
Copy
19
19.67 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = ?
Parameters :
[
"CA0A7F03-0A3A-461D-883C-89D4B50560E6 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = 'CA0A7F03-0A3A-461D-883C-89D4B50560E6' ;
Copy
20
19.90 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = ?
Parameters :
[
"66908D8A-C90B-4DD1-99F0-32D6B22199FD "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = '66908D8A-C90B-4DD1-99F0-32D6B22199FD' ;
Copy
21
19.62 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = ?
Parameters :
[
"FE1BD7F7-3B4B-4F08-AB44-400214384984 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . access_key AS access_key_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0 . id = 'FE1BD7F7-3B4B-4F08-AB44-400214384984' ;
Copy
22
19.88 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . user_id AS user_id_4 , t0 . customer_id AS customer_id_5 , t0 . notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0 . user_id = ?
Parameters :
[
"e3c7669a-bfb9-418e-b2d9-d14faef9b200 "
]
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . user_id AS user_id_4 , t0 . customer_id AS customer_id_5 , t0 . notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0 . user_id = 'e3c7669a-bfb9-418e-b2d9-d14faef9b200' ;
Copy
23
19.73 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 FROM customer_notification_type t0 WHERE t0 . id = ?
Parameters :
[
"604feff2-828a-4593-ad06-446f0496abba "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 FROM customer_notification_type t0 WHERE t0 . id = '604feff2-828a-4593-ad06-446f0496abba' ;
Copy
24
19.66 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 FROM customer_notification_type t0 WHERE t0 . id = ?
Parameters :
[
"e2df8676-6142-4a95-b679-71cfc79a94d6 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 FROM customer_notification_type t0 WHERE t0 . id = 'e2df8676-6142-4a95-b679-71cfc79a94d6' ;
Copy
25
20.22 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 FROM customer_notification_type t0 WHERE t0 . id = ?
Parameters :
[
"0a074caa-f55f-429e-9168-c18cb10d45d1 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 FROM customer_notification_type t0 WHERE t0 . id = '0a074caa-f55f-429e-9168-c18cb10d45d1' ;
Copy
26
20.01 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . customer_permission_id AS customer_permission_id_4 , t0 . user_id AS user_id_5 , t0 . customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0 . user_id = ?
Parameters :
[
"79721683-1d2d-456b-8dfd-9e87cff26796 "
]
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . customer_permission_id AS customer_permission_id_4 , t0 . user_id AS user_id_5 , t0 . customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0 . user_id = '79721683-1d2d-456b-8dfd-9e87cff26796' ;
Copy
27
19.66 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . user_id AS user_id_4 , t0 . customer_id AS customer_id_5 , t0 . notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0 . user_id = ?
Parameters :
[
"79721683-1d2d-456b-8dfd-9e87cff26796 "
]
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . user_id AS user_id_4 , t0 . customer_id AS customer_id_5 , t0 . notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0 . user_id = '79721683-1d2d-456b-8dfd-9e87cff26796' ;
Copy
28
19.81 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . customer_permission_id AS customer_permission_id_4 , t0 . user_id AS user_id_5 , t0 . customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0 . user_id = ?
Parameters :
[
"4bcf2c0a-6b0b-4e85-87d5-6b5ecfc33e4b "
]
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . customer_permission_id AS customer_permission_id_4 , t0 . user_id AS user_id_5 , t0 . customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0 . user_id = '4bcf2c0a-6b0b-4e85-87d5-6b5ecfc33e4b' ;
Copy
29
19.62 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . user_id AS user_id_4 , t0 . customer_id AS customer_id_5 , t0 . notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0 . user_id = ?
Parameters :
[
"4bcf2c0a-6b0b-4e85-87d5-6b5ecfc33e4b "
]
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . user_id AS user_id_4 , t0 . customer_id AS customer_id_5 , t0 . notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0 . user_id = '4bcf2c0a-6b0b-4e85-87d5-6b5ecfc33e4b' ;
Copy
30
19.77 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . customer_permission_id AS customer_permission_id_4 , t0 . user_id AS user_id_5 , t0 . customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0 . user_id = ?
Parameters :
[
"4a6a5c5c-f4a8-4486-b4ac-748ae2cb5760 "
]
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . customer_permission_id AS customer_permission_id_4 , t0 . user_id AS user_id_5 , t0 . customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0 . user_id = '4a6a5c5c-f4a8-4486-b4ac-748ae2cb5760' ;
Copy
31
19.76 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . user_id AS user_id_4 , t0 . customer_id AS customer_id_5 , t0 . notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0 . user_id = ?
Parameters :
[
"4a6a5c5c-f4a8-4486-b4ac-748ae2cb5760 "
]
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . user_id AS user_id_4 , t0 . customer_id AS customer_id_5 , t0 . notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0 . user_id = '4a6a5c5c-f4a8-4486-b4ac-748ae2cb5760' ;
Copy
32
19.78 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . customer_permission_id AS customer_permission_id_4 , t0 . user_id AS user_id_5 , t0 . customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0 . user_id = ?
Parameters :
[
"86b92ab8-cbb1-4bde-b628-12971a2b109b "
]
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . customer_permission_id AS customer_permission_id_4 , t0 . user_id AS user_id_5 , t0 . customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0 . user_id = '86b92ab8-cbb1-4bde-b628-12971a2b109b' ;
Copy
33
19.52 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . user_id AS user_id_4 , t0 . customer_id AS customer_id_5 , t0 . notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0 . user_id = ?
Parameters :
[
"86b92ab8-cbb1-4bde-b628-12971a2b109b "
]
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . user_id AS user_id_4 , t0 . customer_id AS customer_id_5 , t0 . notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0 . user_id = '86b92ab8-cbb1-4bde-b628-12971a2b109b' ;
Copy