1.03 ms
(0.00%)
|
1 |
SELECT t0.disabled AS disabled_1, t0.config_theme AS config_theme_2, t0.pw_reset_token AS pw_reset_token_3, t0.config_instock_comment_a AS config_instock_comment_a_4, t0.config_instock_comment_w AS config_instock_comment_w_5, t0.trusted_device_cookie_version AS trusted_device_cookie_version_6, t0.backup_codes AS backup_codes_7, t0.id AS id_8, t0.google_authenticator_secret AS google_authenticator_secret_9, t0.config_timezone AS config_timezone_10, t0.config_language AS config_language_11, t0.email AS email_12, t0.department AS department_13, t0.last_name AS last_name_14, t0.first_name AS first_name_15, t0.need_pw_change AS need_pw_change_16, t0.password AS password_17, t0.name AS name_18, t0.settings AS settings_19, t0.backup_codes_generation_date AS backup_codes_generation_date_20, t0.pw_reset_expires AS pw_reset_expires_21, t0.last_modified AS last_modified_22, t0.datetime_added AS datetime_added_23, t0.perms_system AS perms_system_24, t0.perms_groups AS perms_groups_25, t0.perms_users AS perms_users_26, t0.perms_self AS perms_self_27, t0.perms_system_config AS perms_system_config_28, t0.perms_system_database AS perms_system_database_29, t0.perms_parts AS perms_parts_30, t0.perms_parts_name AS perms_parts_name_31, t0.perms_parts_category AS perms_parts_category_32, t0.perms_parts_description AS perms_parts_description_33, t0.perms_parts_minamount AS perms_parts_minamount_34, t0.perms_parts_footprint AS perms_parts_footprint_35, t0.perms_parts_lots AS perms_parts_lots_36, t0.perms_parts_tags AS perms_parts_tags_37, t0.perms_parts_unit AS perms_parts_unit_38, t0.perms_parts_mass AS perms_parts_mass_39, t0.perms_parts_manufacturer AS perms_parts_manufacturer_40, t0.perms_parts_status AS perms_parts_status_41, t0.perms_parts_mpn AS perms_parts_mpn_42, t0.perms_parts_comment AS perms_parts_comment_43, t0.perms_parts_order AS perms_parts_order_44, t0.perms_parts_orderdetails AS perms_parts_orderdetails_45, t0.perms_parts_prices AS perms_parts_prices_46, t0.perms_parts_parameters AS perms_parts_parameters_47, t0.perms_parts_attachements AS perms_parts_attachements_48, t0.perms_devices AS perms_devices_49, t0.perms_devices_parts AS perms_devices_parts_50, t0.perms_storelocations AS perms_storelocations_51, t0.perms_footprints AS perms_footprints_52, t0.perms_categories AS perms_categories_53, t0.perms_suppliers AS perms_suppliers_54, t0.perms_manufacturers AS perms_manufacturers_55, t0.perms_attachement_types AS perms_attachement_types_56, t0.perms_currencies AS perms_currencies_57, t0.perms_measurement_units AS perms_measurement_units_58, t0.perms_tools AS perms_tools_59, t0.perms_labels AS perms_labels_60, t0.group_id AS group_id_61, t62.enforce_2fa AS enforce_2fa_63, t62.comment AS comment_64, t62.not_selectable AS not_selectable_65, t62.name AS name_66, t62.id AS id_67, t62.last_modified AS last_modified_68, t62.datetime_added AS datetime_added_69, t62.perms_system AS perms_system_70, t62.perms_groups AS perms_groups_71, t62.perms_users AS perms_users_72, t62.perms_self AS perms_self_73, t62.perms_system_config AS perms_system_config_74, t62.perms_system_database AS perms_system_database_75, t62.perms_parts AS perms_parts_76, t62.perms_parts_name AS perms_parts_name_77, t62.perms_parts_category AS perms_parts_category_78, t62.perms_parts_description AS perms_parts_description_79, t62.perms_parts_minamount AS perms_parts_minamount_80, t62.perms_parts_footprint AS perms_parts_footprint_81, t62.perms_parts_lots AS perms_parts_lots_82, t62.perms_parts_tags AS perms_parts_tags_83, t62.perms_parts_unit AS perms_parts_unit_84, t62.perms_parts_mass AS perms_parts_mass_85, t62.perms_parts_manufacturer AS perms_parts_manufacturer_86, t62.perms_parts_status AS perms_parts_status_87, t62.perms_parts_mpn AS perms_parts_mpn_88, t62.perms_parts_comment AS perms_parts_comment_89, t62.perms_parts_order AS perms_parts_order_90, t62.perms_parts_orderdetails AS perms_parts_orderdetails_91, t62.perms_parts_prices AS perms_parts_prices_92, t62.perms_parts_parameters AS perms_parts_parameters_93, t62.perms_parts_attachements AS perms_parts_attachements_94, t62.perms_devices AS perms_devices_95, t62.perms_devices_parts AS perms_devices_parts_96, t62.perms_storelocations AS perms_storelocations_97, t62.perms_footprints AS perms_footprints_98, t62.perms_categories AS perms_categories_99, t62.perms_suppliers AS perms_suppliers_100, t62.perms_manufacturers AS perms_manufacturers_101, t62.perms_attachement_types AS perms_attachement_types_102, t62.perms_currencies AS perms_currencies_103, t62.perms_measurement_units AS perms_measurement_units_104, t62.perms_tools AS perms_tools_105, t62.perms_labels AS perms_labels_106, t62.parent_id AS parent_id_107, t62.id_preview_attachement AS id_preview_attachement_108, t0.currency_id AS currency_id_109, t0.id_preview_attachement AS id_preview_attachement_110 FROM "users" t0 LEFT JOIN "groups" t62 ON t0.group_id = t62.id WHERE t0.id = ? LIMIT 1
SELECT
t0.disabled AS disabled_1,
t0.config_theme AS config_theme_2,
t0.pw_reset_token AS pw_reset_token_3,
t0.config_instock_comment_a AS config_instock_comment_a_4,
t0.config_instock_comment_w AS config_instock_comment_w_5,
t0.trusted_device_cookie_version AS trusted_device_cookie_version_6,
t0.backup_codes AS backup_codes_7,
t0.id AS id_8,
t0.google_authenticator_secret AS google_authenticator_secret_9,
t0.config_timezone AS config_timezone_10,
t0.config_language AS config_language_11,
t0.email AS email_12,
t0.department AS department_13,
t0.last_name AS last_name_14,
t0.first_name AS first_name_15,
t0.need_pw_change AS need_pw_change_16,
t0.password AS password_17,
t0.name AS name_18,
t0.settings AS settings_19,
t0.backup_codes_generation_date AS backup_codes_generation_date_20,
t0.pw_reset_expires AS pw_reset_expires_21,
t0.last_modified AS last_modified_22,
t0.datetime_added AS datetime_added_23,
t0.perms_system AS perms_system_24,
t0.perms_groups AS perms_groups_25,
t0.perms_users AS perms_users_26,
t0.perms_self AS perms_self_27,
t0.perms_system_config AS perms_system_config_28,
t0.perms_system_database AS perms_system_database_29,
t0.perms_parts AS perms_parts_30,
t0.perms_parts_name AS perms_parts_name_31,
t0.perms_parts_category AS perms_parts_category_32,
t0.perms_parts_description AS perms_parts_description_33,
t0.perms_parts_minamount AS perms_parts_minamount_34,
t0.perms_parts_footprint AS perms_parts_footprint_35,
t0.perms_parts_lots AS perms_parts_lots_36,
t0.perms_parts_tags AS perms_parts_tags_37,
t0.perms_parts_unit AS perms_parts_unit_38,
t0.perms_parts_mass AS perms_parts_mass_39,
t0.perms_parts_manufacturer AS perms_parts_manufacturer_40,
t0.perms_parts_status AS perms_parts_status_41,
t0.perms_parts_mpn AS perms_parts_mpn_42,
t0.perms_parts_comment AS perms_parts_comment_43,
t0.perms_parts_order AS perms_parts_order_44,
t0.perms_parts_orderdetails AS perms_parts_orderdetails_45,
t0.perms_parts_prices AS perms_parts_prices_46,
t0.perms_parts_parameters AS perms_parts_parameters_47,
t0.perms_parts_attachements AS perms_parts_attachements_48,
t0.perms_devices AS perms_devices_49,
t0.perms_devices_parts AS perms_devices_parts_50,
t0.perms_storelocations AS perms_storelocations_51,
t0.perms_footprints AS perms_footprints_52,
t0.perms_categories AS perms_categories_53,
t0.perms_suppliers AS perms_suppliers_54,
t0.perms_manufacturers AS perms_manufacturers_55,
t0.perms_attachement_types AS perms_attachement_types_56,
t0.perms_currencies AS perms_currencies_57,
t0.perms_measurement_units AS perms_measurement_units_58,
t0.perms_tools AS perms_tools_59,
t0.perms_labels AS perms_labels_60,
t0.group_id AS group_id_61,
t62.enforce_2fa AS enforce_2fa_63,
t62.comment AS comment_64,
t62.not_selectable AS not_selectable_65,
t62.name AS name_66,
t62.id AS id_67,
t62.last_modified AS last_modified_68,
t62.datetime_added AS datetime_added_69,
t62.perms_system AS perms_system_70,
t62.perms_groups AS perms_groups_71,
t62.perms_users AS perms_users_72,
t62.perms_self AS perms_self_73,
t62.perms_system_config AS perms_system_config_74,
t62.perms_system_database AS perms_system_database_75,
t62.perms_parts AS perms_parts_76,
t62.perms_parts_name AS perms_parts_name_77,
t62.perms_parts_category AS perms_parts_category_78,
t62.perms_parts_description AS perms_parts_description_79,
t62.perms_parts_minamount AS perms_parts_minamount_80,
t62.perms_parts_footprint AS perms_parts_footprint_81,
t62.perms_parts_lots AS perms_parts_lots_82,
t62.perms_parts_tags AS perms_parts_tags_83,
t62.perms_parts_unit AS perms_parts_unit_84,
t62.perms_parts_mass AS perms_parts_mass_85,
t62.perms_parts_manufacturer AS perms_parts_manufacturer_86,
t62.perms_parts_status AS perms_parts_status_87,
t62.perms_parts_mpn AS perms_parts_mpn_88,
t62.perms_parts_comment AS perms_parts_comment_89,
t62.perms_parts_order AS perms_parts_order_90,
t62.perms_parts_orderdetails AS perms_parts_orderdetails_91,
t62.perms_parts_prices AS perms_parts_prices_92,
t62.perms_parts_parameters AS perms_parts_parameters_93,
t62.perms_parts_attachements AS perms_parts_attachements_94,
t62.perms_devices AS perms_devices_95,
t62.perms_devices_parts AS perms_devices_parts_96,
t62.perms_storelocations AS perms_storelocations_97,
t62.perms_footprints AS perms_footprints_98,
t62.perms_categories AS perms_categories_99,
t62.perms_suppliers AS perms_suppliers_100,
t62.perms_manufacturers AS perms_manufacturers_101,
t62.perms_attachement_types AS perms_attachement_types_102,
t62.perms_currencies AS perms_currencies_103,
t62.perms_measurement_units AS perms_measurement_units_104,
t62.perms_tools AS perms_tools_105,
t62.perms_labels AS perms_labels_106,
t62.parent_id AS parent_id_107,
t62.id_preview_attachement AS id_preview_attachement_108,
t0.currency_id AS currency_id_109,
t0.id_preview_attachement AS id_preview_attachement_110
FROM
"users" t0
LEFT JOIN "groups" t62 ON t0.group_id = t62.id
WHERE
t0.id = ?
LIMIT
1
SELECT t0.disabled AS disabled_1, t0.config_theme AS config_theme_2, t0.pw_reset_token AS pw_reset_token_3, t0.config_instock_comment_a AS config_instock_comment_a_4, t0.config_instock_comment_w AS config_instock_comment_w_5, t0.trusted_device_cookie_version AS trusted_device_cookie_version_6, t0.backup_codes AS backup_codes_7, t0.id AS id_8, t0.google_authenticator_secret AS google_authenticator_secret_9, t0.config_timezone AS config_timezone_10, t0.config_language AS config_language_11, t0.email AS email_12, t0.department AS department_13, t0.last_name AS last_name_14, t0.first_name AS first_name_15, t0.need_pw_change AS need_pw_change_16, t0.password AS password_17, t0.name AS name_18, t0.settings AS settings_19, t0.backup_codes_generation_date AS backup_codes_generation_date_20, t0.pw_reset_expires AS pw_reset_expires_21, t0.last_modified AS last_modified_22, t0.datetime_added AS datetime_added_23, t0.perms_system AS perms_system_24, t0.perms_groups AS perms_groups_25, t0.perms_users AS perms_users_26, t0.perms_self AS perms_self_27, t0.perms_system_config AS perms_system_config_28, t0.perms_system_database AS perms_system_database_29, t0.perms_parts AS perms_parts_30, t0.perms_parts_name AS perms_parts_name_31, t0.perms_parts_category AS perms_parts_category_32, t0.perms_parts_description AS perms_parts_description_33, t0.perms_parts_minamount AS perms_parts_minamount_34, t0.perms_parts_footprint AS perms_parts_footprint_35, t0.perms_parts_lots AS perms_parts_lots_36, t0.perms_parts_tags AS perms_parts_tags_37, t0.perms_parts_unit AS perms_parts_unit_38, t0.perms_parts_mass AS perms_parts_mass_39, t0.perms_parts_manufacturer AS perms_parts_manufacturer_40, t0.perms_parts_status AS perms_parts_status_41, t0.perms_parts_mpn AS perms_parts_mpn_42, t0.perms_parts_comment AS perms_parts_comment_43, t0.perms_parts_order AS perms_parts_order_44, t0.perms_parts_orderdetails AS perms_parts_orderdetails_45, t0.perms_parts_prices AS perms_parts_prices_46, t0.perms_parts_parameters AS perms_parts_parameters_47, t0.perms_parts_attachements AS perms_parts_attachements_48, t0.perms_devices AS perms_devices_49, t0.perms_devices_parts AS perms_devices_parts_50, t0.perms_storelocations AS perms_storelocations_51, t0.perms_footprints AS perms_footprints_52, t0.perms_categories AS perms_categories_53, t0.perms_suppliers AS perms_suppliers_54, t0.perms_manufacturers AS perms_manufacturers_55, t0.perms_attachement_types AS perms_attachement_types_56, t0.perms_currencies AS perms_currencies_57, t0.perms_measurement_units AS perms_measurement_units_58, t0.perms_tools AS perms_tools_59, t0.perms_labels AS perms_labels_60, t0.group_id AS group_id_61, t62.enforce_2fa AS enforce_2fa_63, t62.comment AS comment_64, t62.not_selectable AS not_selectable_65, t62.name AS name_66, t62.id AS id_67, t62.last_modified AS last_modified_68, t62.datetime_added AS datetime_added_69, t62.perms_system AS perms_system_70, t62.perms_groups AS perms_groups_71, t62.perms_users AS perms_users_72, t62.perms_self AS perms_self_73, t62.perms_system_config AS perms_system_config_74, t62.perms_system_database AS perms_system_database_75, t62.perms_parts AS perms_parts_76, t62.perms_parts_name AS perms_parts_name_77, t62.perms_parts_category AS perms_parts_category_78, t62.perms_parts_description AS perms_parts_description_79, t62.perms_parts_minamount AS perms_parts_minamount_80, t62.perms_parts_footprint AS perms_parts_footprint_81, t62.perms_parts_lots AS perms_parts_lots_82, t62.perms_parts_tags AS perms_parts_tags_83, t62.perms_parts_unit AS perms_parts_unit_84, t62.perms_parts_mass AS perms_parts_mass_85, t62.perms_parts_manufacturer AS perms_parts_manufacturer_86, t62.perms_parts_status AS perms_parts_status_87, t62.perms_parts_mpn AS perms_parts_mpn_88, t62.perms_parts_comment AS perms_parts_comment_89, t62.perms_parts_order AS perms_parts_order_90, t62.perms_parts_orderdetails AS perms_parts_orderdetails_91, t62.perms_parts_prices AS perms_parts_prices_92, t62.perms_parts_parameters AS perms_parts_parameters_93, t62.perms_parts_attachements AS perms_parts_attachements_94, t62.perms_devices AS perms_devices_95, t62.perms_devices_parts AS perms_devices_parts_96, t62.perms_storelocations AS perms_storelocations_97, t62.perms_footprints AS perms_footprints_98, t62.perms_categories AS perms_categories_99, t62.perms_suppliers AS perms_suppliers_100, t62.perms_manufacturers AS perms_manufacturers_101, t62.perms_attachement_types AS perms_attachement_types_102, t62.perms_currencies AS perms_currencies_103, t62.perms_measurement_units AS perms_measurement_units_104, t62.perms_tools AS perms_tools_105, t62.perms_labels AS perms_labels_106, t62.parent_id AS parent_id_107, t62.id_preview_attachement AS id_preview_attachement_108, t0.currency_id AS currency_id_109, t0.id_preview_attachement AS id_preview_attachement_110 FROM "users" t0 LEFT JOIN "groups" t62 ON t0.group_id = t62.id WHERE t0.id = 1 LIMIT 1;
|