0.98 ms (32.85%)
|
1 |
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.username AS username_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.birth_date AS birth_date_8, t0.gender AS gender_9, t0.phone AS phone_10, t0.password AS password_11, t0.password_hash AS password_hash_12, t0.is_active AS is_active_13, t0.type_social AS type_social_14, t0.id_social AS id_social_15, t0.is_blocked AS is_blocked_16, t0.cv AS cv_17, t0.bio AS bio_18, t0.picture AS picture_19, t0.qr_path AS qr_path_20, t0.is_default AS is_default_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.organization_id AS organization_id_24, t0.country_id AS country_id_25, t0.functions_id AS functions_id_26, t0.speciality_id AS speciality_id_27, t28.id AS id_29, t28.qr_code_content AS qr_code_content_30, t28.qr_code_image AS qr_code_image_31, t28.center_element_type AS center_element_type_32, t28.custom_icon_image AS custom_icon_image_33, t28.theme_color AS theme_color_34, t28.custom_color AS custom_color_35, t28.layout AS layout_36, t28.template_id AS template_id_37, t28.photo_position AS photo_position_38, t28.center_element_size AS center_element_size_39, t28.center_element_position AS center_element_position_40, t28.background_type AS background_type_41, t28.background_value AS background_value_42, t28.font_family AS font_family_43, t28.show_email AS show_email_44, t28.show_phone AS show_phone_45, t28.show_speciality AS show_speciality_46, t28.show_function AS show_function_47, t28.show_organization AS show_organization_48, t28.show_community_logo AS show_community_logo_49, t28.is_active AS is_active_50, t28.version AS version_51, t28.created_at AS created_at_52, t28.updated_at AS updated_at_53, t28.user_id AS user_id_54 FROM mve_users_user t0 LEFT JOIN mve_user_badge t28 ON t28.user_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.unique_id AS unique_id_2,
t0.username AS username_3,
t0.roles AS roles_4,
t0.first_name AS first_name_5,
t0.last_name AS last_name_6,
t0.email AS email_7,
t0.birth_date AS birth_date_8,
t0.gender AS gender_9,
t0.phone AS phone_10,
t0.password AS password_11,
t0.password_hash AS password_hash_12,
t0.is_active AS is_active_13,
t0.type_social AS type_social_14,
t0.id_social AS id_social_15,
t0.is_blocked AS is_blocked_16,
t0.cv AS cv_17,
t0.bio AS bio_18,
t0.picture AS picture_19,
t0.qr_path AS qr_path_20,
t0.is_default AS is_default_21,
t0.created_at AS created_at_22,
t0.updated_at AS updated_at_23,
t0.organization_id AS organization_id_24,
t0.country_id AS country_id_25,
t0.functions_id AS functions_id_26,
t0.speciality_id AS speciality_id_27,
t28.id AS id_29,
t28.qr_code_content AS qr_code_content_30,
t28.qr_code_image AS qr_code_image_31,
t28.center_element_type AS center_element_type_32,
t28.custom_icon_image AS custom_icon_image_33,
t28.theme_color AS theme_color_34,
t28.custom_color AS custom_color_35,
t28.layout AS layout_36,
t28.template_id AS template_id_37,
t28.photo_position AS photo_position_38,
t28.center_element_size AS center_element_size_39,
t28.center_element_position AS center_element_position_40,
t28.background_type AS background_type_41,
t28.background_value AS background_value_42,
t28.font_family AS font_family_43,
t28.show_email AS show_email_44,
t28.show_phone AS show_phone_45,
t28.show_speciality AS show_speciality_46,
t28.show_function AS show_function_47,
t28.show_organization AS show_organization_48,
t28.show_community_logo AS show_community_logo_49,
t28.is_active AS is_active_50,
t28.version AS version_51,
t28.created_at AS created_at_52,
t28.updated_at AS updated_at_53,
t28.user_id AS user_id_54
FROM
mve_users_user t0
LEFT JOIN mve_user_badge t28 ON t28.user_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.username AS username_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.birth_date AS birth_date_8, t0.gender AS gender_9, t0.phone AS phone_10, t0.password AS password_11, t0.password_hash AS password_hash_12, t0.is_active AS is_active_13, t0.type_social AS type_social_14, t0.id_social AS id_social_15, t0.is_blocked AS is_blocked_16, t0.cv AS cv_17, t0.bio AS bio_18, t0.picture AS picture_19, t0.qr_path AS qr_path_20, t0.is_default AS is_default_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.organization_id AS organization_id_24, t0.country_id AS country_id_25, t0.functions_id AS functions_id_26, t0.speciality_id AS speciality_id_27, t28.id AS id_29, t28.qr_code_content AS qr_code_content_30, t28.qr_code_image AS qr_code_image_31, t28.center_element_type AS center_element_type_32, t28.custom_icon_image AS custom_icon_image_33, t28.theme_color AS theme_color_34, t28.custom_color AS custom_color_35, t28.layout AS layout_36, t28.template_id AS template_id_37, t28.photo_position AS photo_position_38, t28.center_element_size AS center_element_size_39, t28.center_element_position AS center_element_position_40, t28.background_type AS background_type_41, t28.background_value AS background_value_42, t28.font_family AS font_family_43, t28.show_email AS show_email_44, t28.show_phone AS show_phone_45, t28.show_speciality AS show_speciality_46, t28.show_function AS show_function_47, t28.show_organization AS show_organization_48, t28.show_community_logo AS show_community_logo_49, t28.is_active AS is_active_50, t28.version AS version_51, t28.created_at AS created_at_52, t28.updated_at AS updated_at_53, t28.user_id AS user_id_54 FROM mve_users_user t0 LEFT JOIN mve_user_badge t28 ON t28.user_id = t0.id WHERE t0.id = 23;
|