1.24 ms (35.63%)
1
SELECT t0 . user_mob_device_id AS user_mob_device_id_1 , t0 . user_mob_device_uuid AS user_mob_device_uuid_2 , t0 . user_mob_device_push_notif_id AS user_mob_device_push_notif_id_3 , t0 . user_mob_device_created_at AS user_mob_device_created_at_4 , t0 . user_mob_device_refreshed_at AS user_mob_device_refreshed_at_5 , t0 . user_mob_device_default_lang AS user_mob_device_default_lang_6 , t0 . user_mob_device_sec_token AS user_mob_device_sec_token_7 , t0 . user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_8 , t0 . user_mob_device_app_version AS user_mob_device_app_version_9 , t0 . user_mob_device_model AS user_mob_device_model_10 , t0 . user_mob_device_os AS user_mob_device_os_11 , t0 . user_mob_device_user_id AS user_mob_device_user_id_12 FROM user_mob_device t0 WHERE t0 . user_mob_device_uuid = ? AND t0 . user_mob_device_sec_token = ? LIMIT 1
Parameters :
[
"05e2eef111bbd54b "
"134b6c81-6a84-49ac-886f-7f9f283fa3ae-be773fde4e34f0d74604d451440f770b457f9983-5a2aee42-cdd2-4913-a6fb-a7aebfced6e3 "
]
SELECT t0 . user_mob_device_id AS user_mob_device_id_1 , t0 . user_mob_device_uuid AS user_mob_device_uuid_2 , t0 . user_mob_device_push_notif_id AS user_mob_device_push_notif_id_3 , t0 . user_mob_device_created_at AS user_mob_device_created_at_4 , t0 . user_mob_device_refreshed_at AS user_mob_device_refreshed_at_5 , t0 . user_mob_device_default_lang AS user_mob_device_default_lang_6 , t0 . user_mob_device_sec_token AS user_mob_device_sec_token_7 , t0 . user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_8 , t0 . user_mob_device_app_version AS user_mob_device_app_version_9 , t0 . user_mob_device_model AS user_mob_device_model_10 , t0 . user_mob_device_os AS user_mob_device_os_11 , t0 . user_mob_device_user_id AS user_mob_device_user_id_12 FROM user_mob_device t0 WHERE t0 . user_mob_device_uuid = '05e2eef111bbd54b' AND t0 . user_mob_device_sec_token = '134b6c81-6a84-49ac-886f-7f9f283fa3ae-be773fde4e34f0d74604d451440f770b457f9983-5a2aee42-cdd2-4913-a6fb-a7aebfced6e3' LIMIT 1 ;
Copy
1.07 ms (30.66%)
1
SELECT t0 . user_id AS user_id_1 , t0 . user_outside_id AS user_outside_id_2 , t0 . user_type AS user_type_3 , t0 . user_api_type AS user_api_type_4 , t0 . user_login AS user_login_5 , t0 . user_password AS user_password_6 , t0 . user_checksum AS user_checksum_7 , t0 . user_status AS user_status_8 , t0 . user_token AS user_token_9 , t0 . user_token_exp AS user_token_exp_10 , t0 . user_last_login AS user_last_login_11 , t0 . user_created_at AS user_created_at_12 , t0 . user_updated_at AS user_updated_at_13 , t0 . user_deleted_at AS user_deleted_at_14 , t0 . user_public_approved AS user_public_approved_15 , t0 . user_public_blocked AS user_public_blocked_16 , t0 . user_public_app_code AS user_public_app_code_17 , t0 . user_public_app_code_sended_at AS user_public_app_code_sended_at_18 , t0 . user_public_app_code_registered_at AS user_public_app_code_registered_at_19 , t0 . user_option AS user_option_20 , t0 . user_public_app_code_hash AS user_public_app_code_hash_21 , t0 . user_api_setting_sms AS user_api_setting_sms_22 , t0 . user_api_setting_email AS user_api_setting_email_23 , t0 . user_api_setting_mobile AS user_api_setting_mobile_24 , t0 . user_special AS user_special_25 , t0 . google_authenticator_secret AS google_authenticator_secret_26 , t27 . user_detail_id AS user_detail_id_28 , t27 . user_detail_name AS user_detail_name_29 , t27 . user_detail_surname AS user_detail_surname_30 , t27 . user_detail_sex AS user_detail_sex_31 , t27 . user_detail_personal_id_type AS user_detail_personal_id_type_32 , t27 . user_detail_personal_id AS user_detail_personal_id_33 , t27 . user_detail_birthday AS user_detail_birthday_34 , t27 . user_detail_email AS user_detail_email_35 , t27 . user_detail_phone AS user_detail_phone_36 , t27 . user_detail_street AS user_detail_street_37 , t27 . user_detail_street_no AS user_detail_street_no_38 , t27 . user_detail_post_code AS user_detail_post_code_39 , t27 . user_detail_state AS user_detail_state_40 , t27 . user_detail_province AS user_detail_province_41 , t27 . user_detail_comunity AS user_detail_comunity_42 , t27 . user_detail_city AS user_detail_city_43 , t27 . user_detail_personal_id_hash AS user_detail_personal_id_hash_44 , t27 . user_detail_surname_hash AS user_detail_surname_hash_45 , t27 . user_id AS user_id_46 FROM user t0 LEFT JOIN user_detail t27 ON t27 . user_id = t0 . user_id WHERE t0 . user_login = ? LIMIT 1
Parameters :
[
"contento "
]
SELECT
t0 . user_id AS user_id_1 ,
t0 . user_outside_id AS user_outside_id_2 ,
t0 . user_type AS user_type_3 ,
t0 . user_api_type AS user_api_type_4 ,
t0 . user_login AS user_login_5 ,
t0 . user_password AS user_password_6 ,
t0 . user_checksum AS user_checksum_7 ,
t0 . user_status AS user_status_8 ,
t0 . user_token AS user_token_9 ,
t0 . user_token_exp AS user_token_exp_10 ,
t0 . user_last_login AS user_last_login_11 ,
t0 . user_created_at AS user_created_at_12 ,
t0 . user_updated_at AS user_updated_at_13 ,
t0 . user_deleted_at AS user_deleted_at_14 ,
t0 . user_public_approved AS user_public_approved_15 ,
t0 . user_public_blocked AS user_public_blocked_16 ,
t0 . user_public_app_code AS user_public_app_code_17 ,
t0 . user_public_app_code_sended_at AS user_public_app_code_sended_at_18 ,
t0 . user_public_app_code_registered_at AS user_public_app_code_registered_at_19 ,
t0 . user_option AS user_option_20 ,
t0 . user_public_app_code_hash AS user_public_app_code_hash_21 ,
t0 . user_api_setting_sms AS user_api_setting_sms_22 ,
t0 . user_api_setting_email AS user_api_setting_email_23 ,
t0 . user_api_setting_mobile AS user_api_setting_mobile_24 ,
t0 . user_special AS user_special_25 ,
t0 . google_authenticator_secret AS google_authenticator_secret_26 ,
t27 . user_detail_id AS user_detail_id_28 ,
t27 . user_detail_name AS user_detail_name_29 ,
t27 . user_detail_surname AS user_detail_surname_30 ,
t27 . user_detail_sex AS user_detail_sex_31 ,
t27 . user_detail_personal_id_type AS user_detail_personal_id_type_32 ,
t27 . user_detail_personal_id AS user_detail_personal_id_33 ,
t27 . user_detail_birthday AS user_detail_birthday_34 ,
t27 . user_detail_email AS user_detail_email_35 ,
t27 . user_detail_phone AS user_detail_phone_36 ,
t27 . user_detail_street AS user_detail_street_37 ,
t27 . user_detail_street_no AS user_detail_street_no_38 ,
t27 . user_detail_post_code AS user_detail_post_code_39 ,
t27 . user_detail_state AS user_detail_state_40 ,
t27 . user_detail_province AS user_detail_province_41 ,
t27 . user_detail_comunity AS user_detail_comunity_42 ,
t27 . user_detail_city AS user_detail_city_43 ,
t27 . user_detail_personal_id_hash AS user_detail_personal_id_hash_44 ,
t27 . user_detail_surname_hash AS user_detail_surname_hash_45 ,
t27 . user_id AS user_id_46
FROM
user t0
LEFT JOIN user_detail t27 ON t27 . user_id = t0 . user_id
WHERE
t0 . user_login = ?
LIMIT
1
Copy
SELECT t0 . user_id AS user_id_1 , t0 . user_outside_id AS user_outside_id_2 , t0 . user_type AS user_type_3 , t0 . user_api_type AS user_api_type_4 , t0 . user_login AS user_login_5 , t0 . user_password AS user_password_6 , t0 . user_checksum AS user_checksum_7 , t0 . user_status AS user_status_8 , t0 . user_token AS user_token_9 , t0 . user_token_exp AS user_token_exp_10 , t0 . user_last_login AS user_last_login_11 , t0 . user_created_at AS user_created_at_12 , t0 . user_updated_at AS user_updated_at_13 , t0 . user_deleted_at AS user_deleted_at_14 , t0 . user_public_approved AS user_public_approved_15 , t0 . user_public_blocked AS user_public_blocked_16 , t0 . user_public_app_code AS user_public_app_code_17 , t0 . user_public_app_code_sended_at AS user_public_app_code_sended_at_18 , t0 . user_public_app_code_registered_at AS user_public_app_code_registered_at_19 , t0 . user_option AS user_option_20 , t0 . user_public_app_code_hash AS user_public_app_code_hash_21 , t0 . user_api_setting_sms AS user_api_setting_sms_22 , t0 . user_api_setting_email AS user_api_setting_email_23 , t0 . user_api_setting_mobile AS user_api_setting_mobile_24 , t0 . user_special AS user_special_25 , t0 . google_authenticator_secret AS google_authenticator_secret_26 , t27 . user_detail_id AS user_detail_id_28 , t27 . user_detail_name AS user_detail_name_29 , t27 . user_detail_surname AS user_detail_surname_30 , t27 . user_detail_sex AS user_detail_sex_31 , t27 . user_detail_personal_id_type AS user_detail_personal_id_type_32 , t27 . user_detail_personal_id AS user_detail_personal_id_33 , t27 . user_detail_birthday AS user_detail_birthday_34 , t27 . user_detail_email AS user_detail_email_35 , t27 . user_detail_phone AS user_detail_phone_36 , t27 . user_detail_street AS user_detail_street_37 , t27 . user_detail_street_no AS user_detail_street_no_38 , t27 . user_detail_post_code AS user_detail_post_code_39 , t27 . user_detail_state AS user_detail_state_40 , t27 . user_detail_province AS user_detail_province_41 , t27 . user_detail_comunity AS user_detail_comunity_42 , t27 . user_detail_city AS user_detail_city_43 , t27 . user_detail_personal_id_hash AS user_detail_personal_id_hash_44 , t27 . user_detail_surname_hash AS user_detail_surname_hash_45 , t27 . user_id AS user_id_46 FROM user t0 LEFT JOIN user_detail t27 ON t27 . user_id = t0 . user_id WHERE t0 . user_login = 'contento' LIMIT 1 ;
Copy