| 1 |
132.19 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.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters: [
"jason.kearns@housemaster.com"
]
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.firstname AS firstname_13,
t0.lastname AS lastname_14,
t0.address1 AS address1_15,
t0.city AS city_16,
t0.idToken AS idToken_17,
t0.accessToken AS accessToken_18,
t0.state AS state_19,
t0.country AS country_20,
t0.zip AS zip_21,
t0.phone AS phone_22,
t0.phone2 AS phone2_23,
t0.phone3 AS phone3_24,
t0.franchisee AS franchisee_25,
t0.franchisee_number AS franchisee_number_26,
t0.receivenewsletter AS receivenewsletter_27,
t0.receivesms AS receivesms_28,
t0.signedagreement AS signedagreement_29,
t0.address2 AS address2_30,
t0.facebook_id AS facebook_id_31,
t0.google_id AS google_id_32,
t0.twitter_id AS twitter_id_33,
t0.email2 AS email2_34,
t0.email3 AS email3_35,
t0.home_fax AS home_fax_36,
t0.work_fax AS work_fax_37,
t0.companyName AS companyName_38,
t0.website AS website_39,
t0.photo AS photo_40,
t0.updatedAt AS updatedAt_41,
t0.pathandnameofphoto AS pathandnameofphoto_42,
t0.timezone AS timezone_43,
t0.autoRealtorReports AS autoRealtorReports_44,
t0.buyerAgentViewReport AS buyerAgentViewReport_45,
t0.sellerAgentViewReports AS sellerAgentViewReports_46,
t0.otherAgentViewReport AS otherAgentViewReport_47,
t0.shareCloudTransfers AS shareCloudTransfers_48,
t0.doNotLockUnpaid AS doNotLockUnpaid_49,
t0.doNotLockUnsigned AS doNotLockUnsigned_50,
t0.createdAt AS createdAt_51,
t0.preinspection AS preinspection_52,
t0.agentDisableConcierge AS agentDisableConcierge_53,
t0.newAccountNotified AS newAccountNotified_54,
t0.needsPasswordReset AS needsPasswordReset_55,
t0.locked AS locked_56,
t57.id AS id_58,
t57.address AS address_59,
t57.city AS city_60,
t57.state AS state_61,
t57.zip AS zip_62,
t57.birthday AS birthday_63,
t57.hobby AS hobby_64,
t57.restaurant AS restaurant_65,
t57.user_id AS user_id_66,
t57.contact_id AS contact_id_67,
t0.isnCredentials_id AS isnCredentials_id_68,
t69.id AS id_70,
t69.browser AS browser_71,
t69.device AS device_72,
t69.accomplish AS accomplish_73,
t69.useful AS useful_74,
t69.confusing AS confusing_75,
t69.price AS price_76,
t69.stopUsing AS stopUsing_77,
t69.workAsExpected AS workAsExpected_78,
t69.friend AS friend_79,
t69.user_id AS user_id_80,
t81.id AS id_82,
t81.sent AS sent_83,
t81.opened AS opened_84,
t81.clicked AS clicked_85,
t81.bounced AS bounced_86,
t81.blocked AS blocked_87,
t81.notCustomerViewed AS notCustomerViewed_88,
t81.notAgentViewed AS notAgentViewed_89,
t81.user_id AS user_id_90,
t0.officeSettings_id AS officeSettings_id_91,
t92.id AS id_93,
t92.apiKey AS apiKey_94,
t92.apiSecretKey AS apiSecretKey_95,
t92.user_id AS user_id_96
FROM
User t0
LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id
LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id
LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id
LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id
WHERE
t0.username = ?
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.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = 'jason.kearns@housemaster.com' LIMIT 1;
|
| 2 |
68.86 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.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters: [
"jason.kearns@housemaster.com"
]
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.firstname AS firstname_13,
t0.lastname AS lastname_14,
t0.address1 AS address1_15,
t0.city AS city_16,
t0.idToken AS idToken_17,
t0.accessToken AS accessToken_18,
t0.state AS state_19,
t0.country AS country_20,
t0.zip AS zip_21,
t0.phone AS phone_22,
t0.phone2 AS phone2_23,
t0.phone3 AS phone3_24,
t0.franchisee AS franchisee_25,
t0.franchisee_number AS franchisee_number_26,
t0.receivenewsletter AS receivenewsletter_27,
t0.receivesms AS receivesms_28,
t0.signedagreement AS signedagreement_29,
t0.address2 AS address2_30,
t0.facebook_id AS facebook_id_31,
t0.google_id AS google_id_32,
t0.twitter_id AS twitter_id_33,
t0.email2 AS email2_34,
t0.email3 AS email3_35,
t0.home_fax AS home_fax_36,
t0.work_fax AS work_fax_37,
t0.companyName AS companyName_38,
t0.website AS website_39,
t0.photo AS photo_40,
t0.updatedAt AS updatedAt_41,
t0.pathandnameofphoto AS pathandnameofphoto_42,
t0.timezone AS timezone_43,
t0.autoRealtorReports AS autoRealtorReports_44,
t0.buyerAgentViewReport AS buyerAgentViewReport_45,
t0.sellerAgentViewReports AS sellerAgentViewReports_46,
t0.otherAgentViewReport AS otherAgentViewReport_47,
t0.shareCloudTransfers AS shareCloudTransfers_48,
t0.doNotLockUnpaid AS doNotLockUnpaid_49,
t0.doNotLockUnsigned AS doNotLockUnsigned_50,
t0.createdAt AS createdAt_51,
t0.preinspection AS preinspection_52,
t0.agentDisableConcierge AS agentDisableConcierge_53,
t0.newAccountNotified AS newAccountNotified_54,
t0.needsPasswordReset AS needsPasswordReset_55,
t0.locked AS locked_56,
t57.id AS id_58,
t57.address AS address_59,
t57.city AS city_60,
t57.state AS state_61,
t57.zip AS zip_62,
t57.birthday AS birthday_63,
t57.hobby AS hobby_64,
t57.restaurant AS restaurant_65,
t57.user_id AS user_id_66,
t57.contact_id AS contact_id_67,
t0.isnCredentials_id AS isnCredentials_id_68,
t69.id AS id_70,
t69.browser AS browser_71,
t69.device AS device_72,
t69.accomplish AS accomplish_73,
t69.useful AS useful_74,
t69.confusing AS confusing_75,
t69.price AS price_76,
t69.stopUsing AS stopUsing_77,
t69.workAsExpected AS workAsExpected_78,
t69.friend AS friend_79,
t69.user_id AS user_id_80,
t81.id AS id_82,
t81.sent AS sent_83,
t81.opened AS opened_84,
t81.clicked AS clicked_85,
t81.bounced AS bounced_86,
t81.blocked AS blocked_87,
t81.notCustomerViewed AS notCustomerViewed_88,
t81.notAgentViewed AS notAgentViewed_89,
t81.user_id AS user_id_90,
t0.officeSettings_id AS officeSettings_id_91,
t92.id AS id_93,
t92.apiKey AS apiKey_94,
t92.apiSecretKey AS apiSecretKey_95,
t92.user_id AS user_id_96
FROM
User t0
LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id
LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id
LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id
LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id
WHERE
t0.username = ?
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.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = 'jason.kearns@housemaster.com' LIMIT 1;
|
| 3 |
1.46 ms |
SELECT t0.id AS id_1, t0.companyKey AS companyKey_2, t0.accessKey AS accessKey_3, t0.secretAccessKey AS secretAccessKey_4, t5.username AS username_6, t5.username_canonical AS username_canonical_7, t5.email AS email_8, t5.email_canonical AS email_canonical_9, t5.enabled AS enabled_10, t5.salt AS salt_11, t5.password AS password_12, t5.last_login AS last_login_13, t5.confirmation_token AS confirmation_token_14, t5.password_requested_at AS password_requested_at_15, t5.roles AS roles_16, t5.id AS id_17, t5.firstname AS firstname_18, t5.lastname AS lastname_19, t5.address1 AS address1_20, t5.city AS city_21, t5.idToken AS idToken_22, t5.accessToken AS accessToken_23, t5.state AS state_24, t5.country AS country_25, t5.zip AS zip_26, t5.phone AS phone_27, t5.phone2 AS phone2_28, t5.phone3 AS phone3_29, t5.franchisee AS franchisee_30, t5.franchisee_number AS franchisee_number_31, t5.receivenewsletter AS receivenewsletter_32, t5.receivesms AS receivesms_33, t5.signedagreement AS signedagreement_34, t5.address2 AS address2_35, t5.facebook_id AS facebook_id_36, t5.google_id AS google_id_37, t5.twitter_id AS twitter_id_38, t5.email2 AS email2_39, t5.email3 AS email3_40, t5.home_fax AS home_fax_41, t5.work_fax AS work_fax_42, t5.companyName AS companyName_43, t5.website AS website_44, t5.photo AS photo_45, t5.updatedAt AS updatedAt_46, t5.pathandnameofphoto AS pathandnameofphoto_47, t5.timezone AS timezone_48, t5.autoRealtorReports AS autoRealtorReports_49, t5.buyerAgentViewReport AS buyerAgentViewReport_50, t5.sellerAgentViewReports AS sellerAgentViewReports_51, t5.otherAgentViewReport AS otherAgentViewReport_52, t5.shareCloudTransfers AS shareCloudTransfers_53, t5.doNotLockUnpaid AS doNotLockUnpaid_54, t5.doNotLockUnsigned AS doNotLockUnsigned_55, t5.createdAt AS createdAt_56, t5.preinspection AS preinspection_57, t5.agentDisableConcierge AS agentDisableConcierge_58, t5.newAccountNotified AS newAccountNotified_59, t5.needsPasswordReset AS needsPasswordReset_60, t5.locked AS locked_61, t5.isnCredentials_id AS isnCredentials_id_62, t5.officeSettings_id AS officeSettings_id_63 FROM IsnCredentials t0 LEFT JOIN User t5 ON t5.isnCredentials_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.companyKey AS companyKey_2,
t0.accessKey AS accessKey_3,
t0.secretAccessKey AS secretAccessKey_4,
t5.username AS username_6,
t5.username_canonical AS username_canonical_7,
t5.email AS email_8,
t5.email_canonical AS email_canonical_9,
t5.enabled AS enabled_10,
t5.salt AS salt_11,
t5.password AS password_12,
t5.last_login AS last_login_13,
t5.confirmation_token AS confirmation_token_14,
t5.password_requested_at AS password_requested_at_15,
t5.roles AS roles_16,
t5.id AS id_17,
t5.firstname AS firstname_18,
t5.lastname AS lastname_19,
t5.address1 AS address1_20,
t5.city AS city_21,
t5.idToken AS idToken_22,
t5.accessToken AS accessToken_23,
t5.state AS state_24,
t5.country AS country_25,
t5.zip AS zip_26,
t5.phone AS phone_27,
t5.phone2 AS phone2_28,
t5.phone3 AS phone3_29,
t5.franchisee AS franchisee_30,
t5.franchisee_number AS franchisee_number_31,
t5.receivenewsletter AS receivenewsletter_32,
t5.receivesms AS receivesms_33,
t5.signedagreement AS signedagreement_34,
t5.address2 AS address2_35,
t5.facebook_id AS facebook_id_36,
t5.google_id AS google_id_37,
t5.twitter_id AS twitter_id_38,
t5.email2 AS email2_39,
t5.email3 AS email3_40,
t5.home_fax AS home_fax_41,
t5.work_fax AS work_fax_42,
t5.companyName AS companyName_43,
t5.website AS website_44,
t5.photo AS photo_45,
t5.updatedAt AS updatedAt_46,
t5.pathandnameofphoto AS pathandnameofphoto_47,
t5.timezone AS timezone_48,
t5.autoRealtorReports AS autoRealtorReports_49,
t5.buyerAgentViewReport AS buyerAgentViewReport_50,
t5.sellerAgentViewReports AS sellerAgentViewReports_51,
t5.otherAgentViewReport AS otherAgentViewReport_52,
t5.shareCloudTransfers AS shareCloudTransfers_53,
t5.doNotLockUnpaid AS doNotLockUnpaid_54,
t5.doNotLockUnsigned AS doNotLockUnsigned_55,
t5.createdAt AS createdAt_56,
t5.preinspection AS preinspection_57,
t5.agentDisableConcierge AS agentDisableConcierge_58,
t5.newAccountNotified AS newAccountNotified_59,
t5.needsPasswordReset AS needsPasswordReset_60,
t5.locked AS locked_61,
t5.isnCredentials_id AS isnCredentials_id_62,
t5.officeSettings_id AS officeSettings_id_63
FROM
IsnCredentials t0
LEFT JOIN User t5 ON t5.isnCredentials_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.companyKey AS companyKey_2, t0.accessKey AS accessKey_3, t0.secretAccessKey AS secretAccessKey_4, t5.username AS username_6, t5.username_canonical AS username_canonical_7, t5.email AS email_8, t5.email_canonical AS email_canonical_9, t5.enabled AS enabled_10, t5.salt AS salt_11, t5.password AS password_12, t5.last_login AS last_login_13, t5.confirmation_token AS confirmation_token_14, t5.password_requested_at AS password_requested_at_15, t5.roles AS roles_16, t5.id AS id_17, t5.firstname AS firstname_18, t5.lastname AS lastname_19, t5.address1 AS address1_20, t5.city AS city_21, t5.idToken AS idToken_22, t5.accessToken AS accessToken_23, t5.state AS state_24, t5.country AS country_25, t5.zip AS zip_26, t5.phone AS phone_27, t5.phone2 AS phone2_28, t5.phone3 AS phone3_29, t5.franchisee AS franchisee_30, t5.franchisee_number AS franchisee_number_31, t5.receivenewsletter AS receivenewsletter_32, t5.receivesms AS receivesms_33, t5.signedagreement AS signedagreement_34, t5.address2 AS address2_35, t5.facebook_id AS facebook_id_36, t5.google_id AS google_id_37, t5.twitter_id AS twitter_id_38, t5.email2 AS email2_39, t5.email3 AS email3_40, t5.home_fax AS home_fax_41, t5.work_fax AS work_fax_42, t5.companyName AS companyName_43, t5.website AS website_44, t5.photo AS photo_45, t5.updatedAt AS updatedAt_46, t5.pathandnameofphoto AS pathandnameofphoto_47, t5.timezone AS timezone_48, t5.autoRealtorReports AS autoRealtorReports_49, t5.buyerAgentViewReport AS buyerAgentViewReport_50, t5.sellerAgentViewReports AS sellerAgentViewReports_51, t5.otherAgentViewReport AS otherAgentViewReport_52, t5.shareCloudTransfers AS shareCloudTransfers_53, t5.doNotLockUnpaid AS doNotLockUnpaid_54, t5.doNotLockUnsigned AS doNotLockUnsigned_55, t5.createdAt AS createdAt_56, t5.preinspection AS preinspection_57, t5.agentDisableConcierge AS agentDisableConcierge_58, t5.newAccountNotified AS newAccountNotified_59, t5.needsPasswordReset AS needsPasswordReset_60, t5.locked AS locked_61, t5.isnCredentials_id AS isnCredentials_id_62, t5.officeSettings_id AS officeSettings_id_63 FROM IsnCredentials t0 LEFT JOIN User t5 ON t5.isnCredentials_id = t0.id WHERE t0.id = 650;
|
| 4 |
72.43 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.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters: [
"jason.kearns@housemaster.com"
]
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.firstname AS firstname_13,
t0.lastname AS lastname_14,
t0.address1 AS address1_15,
t0.city AS city_16,
t0.idToken AS idToken_17,
t0.accessToken AS accessToken_18,
t0.state AS state_19,
t0.country AS country_20,
t0.zip AS zip_21,
t0.phone AS phone_22,
t0.phone2 AS phone2_23,
t0.phone3 AS phone3_24,
t0.franchisee AS franchisee_25,
t0.franchisee_number AS franchisee_number_26,
t0.receivenewsletter AS receivenewsletter_27,
t0.receivesms AS receivesms_28,
t0.signedagreement AS signedagreement_29,
t0.address2 AS address2_30,
t0.facebook_id AS facebook_id_31,
t0.google_id AS google_id_32,
t0.twitter_id AS twitter_id_33,
t0.email2 AS email2_34,
t0.email3 AS email3_35,
t0.home_fax AS home_fax_36,
t0.work_fax AS work_fax_37,
t0.companyName AS companyName_38,
t0.website AS website_39,
t0.photo AS photo_40,
t0.updatedAt AS updatedAt_41,
t0.pathandnameofphoto AS pathandnameofphoto_42,
t0.timezone AS timezone_43,
t0.autoRealtorReports AS autoRealtorReports_44,
t0.buyerAgentViewReport AS buyerAgentViewReport_45,
t0.sellerAgentViewReports AS sellerAgentViewReports_46,
t0.otherAgentViewReport AS otherAgentViewReport_47,
t0.shareCloudTransfers AS shareCloudTransfers_48,
t0.doNotLockUnpaid AS doNotLockUnpaid_49,
t0.doNotLockUnsigned AS doNotLockUnsigned_50,
t0.createdAt AS createdAt_51,
t0.preinspection AS preinspection_52,
t0.agentDisableConcierge AS agentDisableConcierge_53,
t0.newAccountNotified AS newAccountNotified_54,
t0.needsPasswordReset AS needsPasswordReset_55,
t0.locked AS locked_56,
t57.id AS id_58,
t57.address AS address_59,
t57.city AS city_60,
t57.state AS state_61,
t57.zip AS zip_62,
t57.birthday AS birthday_63,
t57.hobby AS hobby_64,
t57.restaurant AS restaurant_65,
t57.user_id AS user_id_66,
t57.contact_id AS contact_id_67,
t0.isnCredentials_id AS isnCredentials_id_68,
t69.id AS id_70,
t69.browser AS browser_71,
t69.device AS device_72,
t69.accomplish AS accomplish_73,
t69.useful AS useful_74,
t69.confusing AS confusing_75,
t69.price AS price_76,
t69.stopUsing AS stopUsing_77,
t69.workAsExpected AS workAsExpected_78,
t69.friend AS friend_79,
t69.user_id AS user_id_80,
t81.id AS id_82,
t81.sent AS sent_83,
t81.opened AS opened_84,
t81.clicked AS clicked_85,
t81.bounced AS bounced_86,
t81.blocked AS blocked_87,
t81.notCustomerViewed AS notCustomerViewed_88,
t81.notAgentViewed AS notAgentViewed_89,
t81.user_id AS user_id_90,
t0.officeSettings_id AS officeSettings_id_91,
t92.id AS id_93,
t92.apiKey AS apiKey_94,
t92.apiSecretKey AS apiSecretKey_95,
t92.user_id AS user_id_96
FROM
User t0
LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id
LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id
LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id
LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id
WHERE
t0.username = ?
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.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = 'jason.kearns@housemaster.com' LIMIT 1;
|
| 5 |
71.41 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.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters: [
"jason.kearns@housemaster.com"
]
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.firstname AS firstname_13,
t0.lastname AS lastname_14,
t0.address1 AS address1_15,
t0.city AS city_16,
t0.idToken AS idToken_17,
t0.accessToken AS accessToken_18,
t0.state AS state_19,
t0.country AS country_20,
t0.zip AS zip_21,
t0.phone AS phone_22,
t0.phone2 AS phone2_23,
t0.phone3 AS phone3_24,
t0.franchisee AS franchisee_25,
t0.franchisee_number AS franchisee_number_26,
t0.receivenewsletter AS receivenewsletter_27,
t0.receivesms AS receivesms_28,
t0.signedagreement AS signedagreement_29,
t0.address2 AS address2_30,
t0.facebook_id AS facebook_id_31,
t0.google_id AS google_id_32,
t0.twitter_id AS twitter_id_33,
t0.email2 AS email2_34,
t0.email3 AS email3_35,
t0.home_fax AS home_fax_36,
t0.work_fax AS work_fax_37,
t0.companyName AS companyName_38,
t0.website AS website_39,
t0.photo AS photo_40,
t0.updatedAt AS updatedAt_41,
t0.pathandnameofphoto AS pathandnameofphoto_42,
t0.timezone AS timezone_43,
t0.autoRealtorReports AS autoRealtorReports_44,
t0.buyerAgentViewReport AS buyerAgentViewReport_45,
t0.sellerAgentViewReports AS sellerAgentViewReports_46,
t0.otherAgentViewReport AS otherAgentViewReport_47,
t0.shareCloudTransfers AS shareCloudTransfers_48,
t0.doNotLockUnpaid AS doNotLockUnpaid_49,
t0.doNotLockUnsigned AS doNotLockUnsigned_50,
t0.createdAt AS createdAt_51,
t0.preinspection AS preinspection_52,
t0.agentDisableConcierge AS agentDisableConcierge_53,
t0.newAccountNotified AS newAccountNotified_54,
t0.needsPasswordReset AS needsPasswordReset_55,
t0.locked AS locked_56,
t57.id AS id_58,
t57.address AS address_59,
t57.city AS city_60,
t57.state AS state_61,
t57.zip AS zip_62,
t57.birthday AS birthday_63,
t57.hobby AS hobby_64,
t57.restaurant AS restaurant_65,
t57.user_id AS user_id_66,
t57.contact_id AS contact_id_67,
t0.isnCredentials_id AS isnCredentials_id_68,
t69.id AS id_70,
t69.browser AS browser_71,
t69.device AS device_72,
t69.accomplish AS accomplish_73,
t69.useful AS useful_74,
t69.confusing AS confusing_75,
t69.price AS price_76,
t69.stopUsing AS stopUsing_77,
t69.workAsExpected AS workAsExpected_78,
t69.friend AS friend_79,
t69.user_id AS user_id_80,
t81.id AS id_82,
t81.sent AS sent_83,
t81.opened AS opened_84,
t81.clicked AS clicked_85,
t81.bounced AS bounced_86,
t81.blocked AS blocked_87,
t81.notCustomerViewed AS notCustomerViewed_88,
t81.notAgentViewed AS notAgentViewed_89,
t81.user_id AS user_id_90,
t0.officeSettings_id AS officeSettings_id_91,
t92.id AS id_93,
t92.apiKey AS apiKey_94,
t92.apiSecretKey AS apiSecretKey_95,
t92.user_id AS user_id_96
FROM
User t0
LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id
LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id
LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id
LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id
WHERE
t0.username = ?
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.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = 'jason.kearns@housemaster.com' LIMIT 1;
|