| 1 |
1.14 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.date_created AS date_created_13, t0.first_name AS first_name_14, t0.display_name AS display_name_15, t0.last_name AS last_name_16, t0.phone AS phone_17, t0.lang AS lang_18, t0.settings_receive_message_notification AS settings_receive_message_notification_19, t0.facebook_id AS facebook_id_20, t0.google_id AS google_id_21, t0.linkedin_id AS linkedin_id_22, t0.terms_acceptance_date AS terms_acceptance_date_23, t0.terms_acceptance_ip AS terms_acceptance_ip_24, t0.stripe_account_id AS stripe_account_id_25, t0.is_beta_tester AS is_beta_tester_26, t0.payment_last4digits AS payment_last4digits_27, t0.is_arecruiter AS is_arecruiter_28, t0.is_hri AS is_hri_29, t0.is_allowed_to_make_groups AS is_allowed_to_make_groups_30, t0.make_group_name AS make_group_name_31, t0.is_allowed_to_make_company_for_association AS is_allowed_to_make_company_for_association_32, t0.has_reusable_box AS has_reusable_box_33, t0.reminder_coupon_sent AS reminder_coupon_sent_34, t0.next_user_survey_time AS next_user_survey_time_35, t0.dont_show_survey AS dont_show_survey_36, t0.user_subscription_maturin AS user_subscription_maturin_37, t0.date_log_subscription_maturin AS date_log_subscription_maturin_38, t0.subscription_stripe_id AS subscription_stripe_id_39, t0.profile_image_id AS profile_image_id_40, t0.referred_by_id AS referred_by_id_41, t0.make_company_for_association_id AS make_company_for_association_id_42, t43.id AS id_44, t43.diets AS diets_45, t43.allergy AS allergy_46, t43.nb_personnes AS nb_personnes_47, t43.grocery_budget AS grocery_budget_48, t43.handicap AS handicap_49, t43.age_category AS age_category_50, t43.user_id AS user_id_51 FROM app_users t0 LEFT JOIN user_survey t43 ON t43.user_id = t0.id WHERE t0.username_canonical = ? LIMIT 1
Parameters: [
"zmskyuza"
]
SELECT
t0.username AS username_1,
t0.username_canonical AS username_canonical_2,
t0.email AS email_3,
t0.email_canonical AS email_canonical_4,
t0.enabled AS enabled_5,
t0.salt AS salt_6,
t0.password AS password_7,
t0.last_login AS last_login_8,
t0.confirmation_token AS confirmation_token_9,
t0.password_requested_at AS password_requested_at_10,
t0.roles AS roles_11,
t0.id AS id_12,
t0.date_created AS date_created_13,
t0.first_name AS first_name_14,
t0.display_name AS display_name_15,
t0.last_name AS last_name_16,
t0.phone AS phone_17,
t0.lang AS lang_18,
t0.settings_receive_message_notification AS settings_receive_message_notification_19,
t0.facebook_id AS facebook_id_20,
t0.google_id AS google_id_21,
t0.linkedin_id AS linkedin_id_22,
t0.terms_acceptance_date AS terms_acceptance_date_23,
t0.terms_acceptance_ip AS terms_acceptance_ip_24,
t0.stripe_account_id AS stripe_account_id_25,
t0.is_beta_tester AS is_beta_tester_26,
t0.payment_last4digits AS payment_last4digits_27,
t0.is_arecruiter AS is_arecruiter_28,
t0.is_hri AS is_hri_29,
t0.is_allowed_to_make_groups AS is_allowed_to_make_groups_30,
t0.make_group_name AS make_group_name_31,
t0.is_allowed_to_make_company_for_association AS is_allowed_to_make_company_for_association_32,
t0.has_reusable_box AS has_reusable_box_33,
t0.reminder_coupon_sent AS reminder_coupon_sent_34,
t0.next_user_survey_time AS next_user_survey_time_35,
t0.dont_show_survey AS dont_show_survey_36,
t0.user_subscription_maturin AS user_subscription_maturin_37,
t0.date_log_subscription_maturin AS date_log_subscription_maturin_38,
t0.subscription_stripe_id AS subscription_stripe_id_39,
t0.profile_image_id AS profile_image_id_40,
t0.referred_by_id AS referred_by_id_41,
t0.make_company_for_association_id AS make_company_for_association_id_42,
t43.id AS id_44,
t43.diets AS diets_45,
t43.allergy AS allergy_46,
t43.nb_personnes AS nb_personnes_47,
t43.grocery_budget AS grocery_budget_48,
t43.handicap AS handicap_49,
t43.age_category AS age_category_50,
t43.user_id AS user_id_51
FROM
app_users t0
LEFT JOIN user_survey t43 ON t43.user_id = t0.id
WHERE
t0.username_canonical = ?
LIMIT
1
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.date_created AS date_created_13, t0.first_name AS first_name_14, t0.display_name AS display_name_15, t0.last_name AS last_name_16, t0.phone AS phone_17, t0.lang AS lang_18, t0.settings_receive_message_notification AS settings_receive_message_notification_19, t0.facebook_id AS facebook_id_20, t0.google_id AS google_id_21, t0.linkedin_id AS linkedin_id_22, t0.terms_acceptance_date AS terms_acceptance_date_23, t0.terms_acceptance_ip AS terms_acceptance_ip_24, t0.stripe_account_id AS stripe_account_id_25, t0.is_beta_tester AS is_beta_tester_26, t0.payment_last4digits AS payment_last4digits_27, t0.is_arecruiter AS is_arecruiter_28, t0.is_hri AS is_hri_29, t0.is_allowed_to_make_groups AS is_allowed_to_make_groups_30, t0.make_group_name AS make_group_name_31, t0.is_allowed_to_make_company_for_association AS is_allowed_to_make_company_for_association_32, t0.has_reusable_box AS has_reusable_box_33, t0.reminder_coupon_sent AS reminder_coupon_sent_34, t0.next_user_survey_time AS next_user_survey_time_35, t0.dont_show_survey AS dont_show_survey_36, t0.user_subscription_maturin AS user_subscription_maturin_37, t0.date_log_subscription_maturin AS date_log_subscription_maturin_38, t0.subscription_stripe_id AS subscription_stripe_id_39, t0.profile_image_id AS profile_image_id_40, t0.referred_by_id AS referred_by_id_41, t0.make_company_for_association_id AS make_company_for_association_id_42, t43.id AS id_44, t43.diets AS diets_45, t43.allergy AS allergy_46, t43.nb_personnes AS nb_personnes_47, t43.grocery_budget AS grocery_budget_48, t43.handicap AS handicap_49, t43.age_category AS age_category_50, t43.user_id AS user_id_51 FROM app_users t0 LEFT JOIN user_survey t43 ON t43.user_id = t0.id WHERE t0.username_canonical = 'zmskyuza' LIMIT 1;
|
| 2 |
68.10 ms |
SELECT a0_.username AS username_0, a0_.username_canonical AS username_canonical_1, a0_.email AS email_2, a0_.email_canonical AS email_canonical_3, a0_.enabled AS enabled_4, a0_.salt AS salt_5, a0_.password AS password_6, a0_.last_login AS last_login_7, a0_.confirmation_token AS confirmation_token_8, a0_.password_requested_at AS password_requested_at_9, a0_.roles AS roles_10, a0_.id AS id_11, a0_.date_created AS date_created_12, a0_.first_name AS first_name_13, a0_.display_name AS display_name_14, a0_.last_name AS last_name_15, a0_.phone AS phone_16, a0_.lang AS lang_17, a0_.settings_receive_message_notification AS settings_receive_message_notification_18, a0_.facebook_id AS facebook_id_19, a0_.google_id AS google_id_20, a0_.linkedin_id AS linkedin_id_21, a0_.terms_acceptance_date AS terms_acceptance_date_22, a0_.terms_acceptance_ip AS terms_acceptance_ip_23, a0_.stripe_account_id AS stripe_account_id_24, a0_.is_beta_tester AS is_beta_tester_25, a0_.payment_last4digits AS payment_last4digits_26, a0_.is_arecruiter AS is_arecruiter_27, a0_.is_hri AS is_hri_28, a0_.is_allowed_to_make_groups AS is_allowed_to_make_groups_29, a0_.make_group_name AS make_group_name_30, a0_.is_allowed_to_make_company_for_association AS is_allowed_to_make_company_for_association_31, a0_.has_reusable_box AS has_reusable_box_32, a0_.reminder_coupon_sent AS reminder_coupon_sent_33, a0_.next_user_survey_time AS next_user_survey_time_34, a0_.dont_show_survey AS dont_show_survey_35, a0_.user_subscription_maturin AS user_subscription_maturin_36, a0_.date_log_subscription_maturin AS date_log_subscription_maturin_37, a0_.subscription_stripe_id AS subscription_stripe_id_38, a0_.profile_image_id AS profile_image_id_39, a0_.referred_by_id AS referred_by_id_40, a0_.make_company_for_association_id AS make_company_for_association_id_41 FROM app_users a0_ WHERE a0_.email = ?
Parameters: [
"ZMskyuza"
]
SELECT
a0_.username AS username_0,
a0_.username_canonical AS username_canonical_1,
a0_.email AS email_2,
a0_.email_canonical AS email_canonical_3,
a0_.enabled AS enabled_4,
a0_.salt AS salt_5,
a0_.password AS password_6,
a0_.last_login AS last_login_7,
a0_.confirmation_token AS confirmation_token_8,
a0_.password_requested_at AS password_requested_at_9,
a0_.roles AS roles_10,
a0_.id AS id_11,
a0_.date_created AS date_created_12,
a0_.first_name AS first_name_13,
a0_.display_name AS display_name_14,
a0_.last_name AS last_name_15,
a0_.phone AS phone_16,
a0_.lang AS lang_17,
a0_.settings_receive_message_notification AS settings_receive_message_notification_18,
a0_.facebook_id AS facebook_id_19,
a0_.google_id AS google_id_20,
a0_.linkedin_id AS linkedin_id_21,
a0_.terms_acceptance_date AS terms_acceptance_date_22,
a0_.terms_acceptance_ip AS terms_acceptance_ip_23,
a0_.stripe_account_id AS stripe_account_id_24,
a0_.is_beta_tester AS is_beta_tester_25,
a0_.payment_last4digits AS payment_last4digits_26,
a0_.is_arecruiter AS is_arecruiter_27,
a0_.is_hri AS is_hri_28,
a0_.is_allowed_to_make_groups AS is_allowed_to_make_groups_29,
a0_.make_group_name AS make_group_name_30,
a0_.is_allowed_to_make_company_for_association AS is_allowed_to_make_company_for_association_31,
a0_.has_reusable_box AS has_reusable_box_32,
a0_.reminder_coupon_sent AS reminder_coupon_sent_33,
a0_.next_user_survey_time AS next_user_survey_time_34,
a0_.dont_show_survey AS dont_show_survey_35,
a0_.user_subscription_maturin AS user_subscription_maturin_36,
a0_.date_log_subscription_maturin AS date_log_subscription_maturin_37,
a0_.subscription_stripe_id AS subscription_stripe_id_38,
a0_.profile_image_id AS profile_image_id_39,
a0_.referred_by_id AS referred_by_id_40,
a0_.make_company_for_association_id AS make_company_for_association_id_41
FROM
app_users a0_
WHERE
a0_.email = ?
SELECT a0_.username AS username_0, a0_.username_canonical AS username_canonical_1, a0_.email AS email_2, a0_.email_canonical AS email_canonical_3, a0_.enabled AS enabled_4, a0_.salt AS salt_5, a0_.password AS password_6, a0_.last_login AS last_login_7, a0_.confirmation_token AS confirmation_token_8, a0_.password_requested_at AS password_requested_at_9, a0_.roles AS roles_10, a0_.id AS id_11, a0_.date_created AS date_created_12, a0_.first_name AS first_name_13, a0_.display_name AS display_name_14, a0_.last_name AS last_name_15, a0_.phone AS phone_16, a0_.lang AS lang_17, a0_.settings_receive_message_notification AS settings_receive_message_notification_18, a0_.facebook_id AS facebook_id_19, a0_.google_id AS google_id_20, a0_.linkedin_id AS linkedin_id_21, a0_.terms_acceptance_date AS terms_acceptance_date_22, a0_.terms_acceptance_ip AS terms_acceptance_ip_23, a0_.stripe_account_id AS stripe_account_id_24, a0_.is_beta_tester AS is_beta_tester_25, a0_.payment_last4digits AS payment_last4digits_26, a0_.is_arecruiter AS is_arecruiter_27, a0_.is_hri AS is_hri_28, a0_.is_allowed_to_make_groups AS is_allowed_to_make_groups_29, a0_.make_group_name AS make_group_name_30, a0_.is_allowed_to_make_company_for_association AS is_allowed_to_make_company_for_association_31, a0_.has_reusable_box AS has_reusable_box_32, a0_.reminder_coupon_sent AS reminder_coupon_sent_33, a0_.next_user_survey_time AS next_user_survey_time_34, a0_.dont_show_survey AS dont_show_survey_35, a0_.user_subscription_maturin AS user_subscription_maturin_36, a0_.date_log_subscription_maturin AS date_log_subscription_maturin_37, a0_.subscription_stripe_id AS subscription_stripe_id_38, a0_.profile_image_id AS profile_image_id_39, a0_.referred_by_id AS referred_by_id_40, a0_.make_company_for_association_id AS make_company_for_association_id_41 FROM app_users a0_ WHERE a0_.email = 'ZMskyuza';
|