4.87 ms
(55.72%)
|
2 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.phone AS phone_8, t0.welcome_email AS welcome_email_9, t0.available_point AS available_point_10, t0.potential_point AS potential_point_11, t0.locale AS locale_12, t0.job AS job_13, t0.company AS company_14, t0.company_siret AS company_siret_15, t0.company_legal_status AS company_legal_status_16, t0.user_token AS user_token_17, t0.user_token_validity AS user_token_validity_18, t0.user_token_attempts AS user_token_attempts_19, t0.civility AS civility_20, t0.address1 AS address1_21, t0.address2 AS address2_22, t0.postcode AS postcode_23, t0.city AS city_24, t0.can_order AS can_order_25, t0.deleted_at AS deleted_at_26, t0.birth_date AS birth_date_27, t0.birth_place AS birth_place_28, t0.internal_code AS internal_code_29, t0.cgu_at AS cgu_at_30, t0.register_at AS register_at_31, t0.imported_at AS imported_at_32, t0.can_be_contacted AS can_be_contacted_33, t0.capacity AS capacity_34, t0.address3 AS address3_35, t0.optin_mail AS optin_mail_36, t0.optin_sms AS optin_sms_37, t0.optin_postal AS optin_postal_38, t0.optin_postal_address AS optin_postal_address_39, t0.source AS source_40, t0.level AS level_41, t0.level0_updated_at AS level0_updated_at_42, t0.level1_updated_at AS level1_updated_at_43, t0.level2_updated_at AS level2_updated_at_44, t0.level3_updated_at AS level3_updated_at_45, t0.level_update_seen_at AS level_update_seen_at_46, t0.is_email_ok AS is_email_ok_47, t0.last_email_check AS last_email_check_48, t0.api_token AS api_token_49, t0.sap_account AS sap_account_50, t0.sap_distributor AS sap_distributor_51, t0.distributor AS distributor_52, t0.distributor2 AS distributor2_53, t0.aggreement AS aggreement_54, t0.unsubscribed_at AS unsubscribed_at_55, t0.chauffage AS chauffage_56, t0.username AS username_57, t0.username_canonical AS username_canonical_58, t0.email_canonical AS email_canonical_59, t0.salt AS salt_60, t0.last_login AS last_login_61, t0.confirmation_token AS confirmation_token_62, t0.password_requested_at AS password_requested_at_63, t0.credential_expired AS credential_expired_64, t0.credential_expired_at AS credential_expired_at_65, t0.donnees_personnelles AS donnees_personnelles_66, t0.archived_at AS archived_at_67, t0.newsletter AS newsletter_68, t0.extension1 AS extension1_69, t0.extension2 AS extension2_70, t0.wdg AS wdg_71, t0.glady_uuid AS glady_uuid_72, t0.transactional_email AS transactional_email_73, t0.status AS status_74, t0.calculated_points AS calculated_points_75, t0.avatar AS avatar_76, t0.logo AS logo_77, t0.fonction AS fonction_78, t0.registration_document AS registration_document_79, t0.old_status AS old_status_80, t0.disabled_at AS disabled_at_81, t0.archive_reason AS archive_reason_82, t0.unsubscribe_reason AS unsubscribe_reason_83, t0.failed_attempts AS failed_attempts_84, t0.last_failed_attempt AS last_failed_attempt_85, t0.password_updated_at AS password_updated_at_86, t0.last_activity AS last_activity_87, t0.account_id AS account_id_88, t0.unique_slug_constraint AS unique_slug_constraint_89, t0.azure_id AS azure_id_90, t0.email_unsubscribe_reason AS email_unsubscribe_reason_91, t0.email_unsubscribed_at AS email_unsubscribed_at_92, t0.created_at AS created_at_93, t0.updated_at AS updated_at_94, t0.country_id AS country_id_95, t0.main_account_user_id AS main_account_user_id_96, t0.godfather_id AS godfather_id_97, t0.regate_id AS regate_id_98, t0.commercial_id AS commercial_id_99, t0.heating_commercial_id AS heating_commercial_id_100, t0.agency_id AS agency_id_101, t102.id AS id_103, t102.code AS code_104, t102.name AS name_105, t102.region AS region_106, t102.manager_last_name AS manager_last_name_107, t102.manager_first_name AS manager_first_name_108, t102.address1 AS address1_109, t102.address2 AS address2_110, t102.post_code AS post_code_111, t102.city AS city_112, t102.phone AS phone_113, t0.programme_id AS programme_id_114, t0.sale_order_validation_id AS sale_order_validation_id_115, t0.billing_point_id AS billing_point_id_116, t0.request_registration_id AS request_registration_id_117, t0.subscription_id AS subscription_id_118, t0.point_of_sale_id AS point_of_sale_id_119, t120.id AS id_121, t120.code AS code_122, t120.name AS name_123, t120.city AS city_124, t120.enabled AS enabled_125, t120.logo AS logo_126, t120.mail_header AS mail_header_127, t120.created_by_id AS created_by_id_128, t120.address_id AS address_id_129, t0.point_conversion_rate_id AS point_conversion_rate_id_130, t0.responsable_regate_id AS responsable_regate_id_131, t0.coverage_area_id AS coverage_area_id_132, t0.activated_by_id AS activated_by_id_133 FROM user t0 LEFT JOIN agence t102 ON t0.agency_id = t102.id LEFT JOIN point_of_sale t120 ON t0.point_of_sale_id = t120.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.email AS email_2,
t0.roles AS roles_3,
t0.password AS password_4,
t0.first_name AS first_name_5,
t0.last_name AS last_name_6,
t0.mobile AS mobile_7,
t0.phone AS phone_8,
t0.welcome_email AS welcome_email_9,
t0.available_point AS available_point_10,
t0.potential_point AS potential_point_11,
t0.locale AS locale_12,
t0.job AS job_13,
t0.company AS company_14,
t0.company_siret AS company_siret_15,
t0.company_legal_status AS company_legal_status_16,
t0.user_token AS user_token_17,
t0.user_token_validity AS user_token_validity_18,
t0.user_token_attempts AS user_token_attempts_19,
t0.civility AS civility_20,
t0.address1 AS address1_21,
t0.address2 AS address2_22,
t0.postcode AS postcode_23,
t0.city AS city_24,
t0.can_order AS can_order_25,
t0.deleted_at AS deleted_at_26,
t0.birth_date AS birth_date_27,
t0.birth_place AS birth_place_28,
t0.internal_code AS internal_code_29,
t0.cgu_at AS cgu_at_30,
t0.register_at AS register_at_31,
t0.imported_at AS imported_at_32,
t0.can_be_contacted AS can_be_contacted_33,
t0.capacity AS capacity_34,
t0.address3 AS address3_35,
t0.optin_mail AS optin_mail_36,
t0.optin_sms AS optin_sms_37,
t0.optin_postal AS optin_postal_38,
t0.optin_postal_address AS optin_postal_address_39,
t0.source AS source_40,
t0.level AS level_41,
t0.level0_updated_at AS level0_updated_at_42,
t0.level1_updated_at AS level1_updated_at_43,
t0.level2_updated_at AS level2_updated_at_44,
t0.level3_updated_at AS level3_updated_at_45,
t0.level_update_seen_at AS level_update_seen_at_46,
t0.is_email_ok AS is_email_ok_47,
t0.last_email_check AS last_email_check_48,
t0.api_token AS api_token_49,
t0.sap_account AS sap_account_50,
t0.sap_distributor AS sap_distributor_51,
t0.distributor AS distributor_52,
t0.distributor2 AS distributor2_53,
t0.aggreement AS aggreement_54,
t0.unsubscribed_at AS unsubscribed_at_55,
t0.chauffage AS chauffage_56,
t0.username AS username_57,
t0.username_canonical AS username_canonical_58,
t0.email_canonical AS email_canonical_59,
t0.salt AS salt_60,
t0.last_login AS last_login_61,
t0.confirmation_token AS confirmation_token_62,
t0.password_requested_at AS password_requested_at_63,
t0.credential_expired AS credential_expired_64,
t0.credential_expired_at AS credential_expired_at_65,
t0.donnees_personnelles AS donnees_personnelles_66,
t0.archived_at AS archived_at_67,
t0.newsletter AS newsletter_68,
t0.extension1 AS extension1_69,
t0.extension2 AS extension2_70,
t0.wdg AS wdg_71,
t0.glady_uuid AS glady_uuid_72,
t0.transactional_email AS transactional_email_73,
t0.status AS status_74,
t0.calculated_points AS calculated_points_75,
t0.avatar AS avatar_76,
t0.logo AS logo_77,
t0.fonction AS fonction_78,
t0.registration_document AS registration_document_79,
t0.old_status AS old_status_80,
t0.disabled_at AS disabled_at_81,
t0.archive_reason AS archive_reason_82,
t0.unsubscribe_reason AS unsubscribe_reason_83,
t0.failed_attempts AS failed_attempts_84,
t0.last_failed_attempt AS last_failed_attempt_85,
t0.password_updated_at AS password_updated_at_86,
t0.last_activity AS last_activity_87,
t0.account_id AS account_id_88,
t0.unique_slug_constraint AS unique_slug_constraint_89,
t0.azure_id AS azure_id_90,
t0.email_unsubscribe_reason AS email_unsubscribe_reason_91,
t0.email_unsubscribed_at AS email_unsubscribed_at_92,
t0.created_at AS created_at_93,
t0.updated_at AS updated_at_94,
t0.country_id AS country_id_95,
t0.main_account_user_id AS main_account_user_id_96,
t0.godfather_id AS godfather_id_97,
t0.regate_id AS regate_id_98,
t0.commercial_id AS commercial_id_99,
t0.heating_commercial_id AS heating_commercial_id_100,
t0.agency_id AS agency_id_101,
t102.id AS id_103,
t102.code AS code_104,
t102.name AS name_105,
t102.region AS region_106,
t102.manager_last_name AS manager_last_name_107,
t102.manager_first_name AS manager_first_name_108,
t102.address1 AS address1_109,
t102.address2 AS address2_110,
t102.post_code AS post_code_111,
t102.city AS city_112,
t102.phone AS phone_113,
t0.programme_id AS programme_id_114,
t0.sale_order_validation_id AS sale_order_validation_id_115,
t0.billing_point_id AS billing_point_id_116,
t0.request_registration_id AS request_registration_id_117,
t0.subscription_id AS subscription_id_118,
t0.point_of_sale_id AS point_of_sale_id_119,
t120.id AS id_121,
t120.code AS code_122,
t120.name AS name_123,
t120.city AS city_124,
t120.enabled AS enabled_125,
t120.logo AS logo_126,
t120.mail_header AS mail_header_127,
t120.created_by_id AS created_by_id_128,
t120.address_id AS address_id_129,
t0.point_conversion_rate_id AS point_conversion_rate_id_130,
t0.responsable_regate_id AS responsable_regate_id_131,
t0.coverage_area_id AS coverage_area_id_132,
t0.activated_by_id AS activated_by_id_133
FROM
user t0
LEFT JOIN agence t102 ON t0.agency_id = t102.id
LEFT JOIN point_of_sale t120 ON t0.point_of_sale_id = t120.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.phone AS phone_8, t0.welcome_email AS welcome_email_9, t0.available_point AS available_point_10, t0.potential_point AS potential_point_11, t0.locale AS locale_12, t0.job AS job_13, t0.company AS company_14, t0.company_siret AS company_siret_15, t0.company_legal_status AS company_legal_status_16, t0.user_token AS user_token_17, t0.user_token_validity AS user_token_validity_18, t0.user_token_attempts AS user_token_attempts_19, t0.civility AS civility_20, t0.address1 AS address1_21, t0.address2 AS address2_22, t0.postcode AS postcode_23, t0.city AS city_24, t0.can_order AS can_order_25, t0.deleted_at AS deleted_at_26, t0.birth_date AS birth_date_27, t0.birth_place AS birth_place_28, t0.internal_code AS internal_code_29, t0.cgu_at AS cgu_at_30, t0.register_at AS register_at_31, t0.imported_at AS imported_at_32, t0.can_be_contacted AS can_be_contacted_33, t0.capacity AS capacity_34, t0.address3 AS address3_35, t0.optin_mail AS optin_mail_36, t0.optin_sms AS optin_sms_37, t0.optin_postal AS optin_postal_38, t0.optin_postal_address AS optin_postal_address_39, t0.source AS source_40, t0.level AS level_41, t0.level0_updated_at AS level0_updated_at_42, t0.level1_updated_at AS level1_updated_at_43, t0.level2_updated_at AS level2_updated_at_44, t0.level3_updated_at AS level3_updated_at_45, t0.level_update_seen_at AS level_update_seen_at_46, t0.is_email_ok AS is_email_ok_47, t0.last_email_check AS last_email_check_48, t0.api_token AS api_token_49, t0.sap_account AS sap_account_50, t0.sap_distributor AS sap_distributor_51, t0.distributor AS distributor_52, t0.distributor2 AS distributor2_53, t0.aggreement AS aggreement_54, t0.unsubscribed_at AS unsubscribed_at_55, t0.chauffage AS chauffage_56, t0.username AS username_57, t0.username_canonical AS username_canonical_58, t0.email_canonical AS email_canonical_59, t0.salt AS salt_60, t0.last_login AS last_login_61, t0.confirmation_token AS confirmation_token_62, t0.password_requested_at AS password_requested_at_63, t0.credential_expired AS credential_expired_64, t0.credential_expired_at AS credential_expired_at_65, t0.donnees_personnelles AS donnees_personnelles_66, t0.archived_at AS archived_at_67, t0.newsletter AS newsletter_68, t0.extension1 AS extension1_69, t0.extension2 AS extension2_70, t0.wdg AS wdg_71, t0.glady_uuid AS glady_uuid_72, t0.transactional_email AS transactional_email_73, t0.status AS status_74, t0.calculated_points AS calculated_points_75, t0.avatar AS avatar_76, t0.logo AS logo_77, t0.fonction AS fonction_78, t0.registration_document AS registration_document_79, t0.old_status AS old_status_80, t0.disabled_at AS disabled_at_81, t0.archive_reason AS archive_reason_82, t0.unsubscribe_reason AS unsubscribe_reason_83, t0.failed_attempts AS failed_attempts_84, t0.last_failed_attempt AS last_failed_attempt_85, t0.password_updated_at AS password_updated_at_86, t0.last_activity AS last_activity_87, t0.account_id AS account_id_88, t0.unique_slug_constraint AS unique_slug_constraint_89, t0.azure_id AS azure_id_90, t0.email_unsubscribe_reason AS email_unsubscribe_reason_91, t0.email_unsubscribed_at AS email_unsubscribed_at_92, t0.created_at AS created_at_93, t0.updated_at AS updated_at_94, t0.country_id AS country_id_95, t0.main_account_user_id AS main_account_user_id_96, t0.godfather_id AS godfather_id_97, t0.regate_id AS regate_id_98, t0.commercial_id AS commercial_id_99, t0.heating_commercial_id AS heating_commercial_id_100, t0.agency_id AS agency_id_101, t102.id AS id_103, t102.code AS code_104, t102.name AS name_105, t102.region AS region_106, t102.manager_last_name AS manager_last_name_107, t102.manager_first_name AS manager_first_name_108, t102.address1 AS address1_109, t102.address2 AS address2_110, t102.post_code AS post_code_111, t102.city AS city_112, t102.phone AS phone_113, t0.programme_id AS programme_id_114, t0.sale_order_validation_id AS sale_order_validation_id_115, t0.billing_point_id AS billing_point_id_116, t0.request_registration_id AS request_registration_id_117, t0.subscription_id AS subscription_id_118, t0.point_of_sale_id AS point_of_sale_id_119, t120.id AS id_121, t120.code AS code_122, t120.name AS name_123, t120.city AS city_124, t120.enabled AS enabled_125, t120.logo AS logo_126, t120.mail_header AS mail_header_127, t120.created_by_id AS created_by_id_128, t120.address_id AS address_id_129, t0.point_conversion_rate_id AS point_conversion_rate_id_130, t0.responsable_regate_id AS responsable_regate_id_131, t0.coverage_area_id AS coverage_area_id_132, t0.activated_by_id AS activated_by_id_133 FROM user t0 LEFT JOIN agence t102 ON t0.agency_id = t102.id LEFT JOIN point_of_sale t120 ON t0.point_of_sale_id = t120.id WHERE t0.id = 1;
|
3.87 ms
(44.28%)
|
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.phone AS phone_8, t0.welcome_email AS welcome_email_9, t0.available_point AS available_point_10, t0.potential_point AS potential_point_11, t0.locale AS locale_12, t0.job AS job_13, t0.company AS company_14, t0.company_siret AS company_siret_15, t0.company_legal_status AS company_legal_status_16, t0.user_token AS user_token_17, t0.user_token_validity AS user_token_validity_18, t0.user_token_attempts AS user_token_attempts_19, t0.civility AS civility_20, t0.address1 AS address1_21, t0.address2 AS address2_22, t0.postcode AS postcode_23, t0.city AS city_24, t0.can_order AS can_order_25, t0.deleted_at AS deleted_at_26, t0.birth_date AS birth_date_27, t0.birth_place AS birth_place_28, t0.internal_code AS internal_code_29, t0.cgu_at AS cgu_at_30, t0.register_at AS register_at_31, t0.imported_at AS imported_at_32, t0.can_be_contacted AS can_be_contacted_33, t0.capacity AS capacity_34, t0.address3 AS address3_35, t0.optin_mail AS optin_mail_36, t0.optin_sms AS optin_sms_37, t0.optin_postal AS optin_postal_38, t0.optin_postal_address AS optin_postal_address_39, t0.source AS source_40, t0.level AS level_41, t0.level0_updated_at AS level0_updated_at_42, t0.level1_updated_at AS level1_updated_at_43, t0.level2_updated_at AS level2_updated_at_44, t0.level3_updated_at AS level3_updated_at_45, t0.level_update_seen_at AS level_update_seen_at_46, t0.is_email_ok AS is_email_ok_47, t0.last_email_check AS last_email_check_48, t0.api_token AS api_token_49, t0.sap_account AS sap_account_50, t0.sap_distributor AS sap_distributor_51, t0.distributor AS distributor_52, t0.distributor2 AS distributor2_53, t0.aggreement AS aggreement_54, t0.unsubscribed_at AS unsubscribed_at_55, t0.chauffage AS chauffage_56, t0.username AS username_57, t0.username_canonical AS username_canonical_58, t0.email_canonical AS email_canonical_59, t0.salt AS salt_60, t0.last_login AS last_login_61, t0.confirmation_token AS confirmation_token_62, t0.password_requested_at AS password_requested_at_63, t0.credential_expired AS credential_expired_64, t0.credential_expired_at AS credential_expired_at_65, t0.donnees_personnelles AS donnees_personnelles_66, t0.archived_at AS archived_at_67, t0.newsletter AS newsletter_68, t0.extension1 AS extension1_69, t0.extension2 AS extension2_70, t0.wdg AS wdg_71, t0.glady_uuid AS glady_uuid_72, t0.transactional_email AS transactional_email_73, t0.status AS status_74, t0.calculated_points AS calculated_points_75, t0.avatar AS avatar_76, t0.logo AS logo_77, t0.fonction AS fonction_78, t0.registration_document AS registration_document_79, t0.old_status AS old_status_80, t0.disabled_at AS disabled_at_81, t0.archive_reason AS archive_reason_82, t0.unsubscribe_reason AS unsubscribe_reason_83, t0.failed_attempts AS failed_attempts_84, t0.last_failed_attempt AS last_failed_attempt_85, t0.password_updated_at AS password_updated_at_86, t0.last_activity AS last_activity_87, t0.account_id AS account_id_88, t0.unique_slug_constraint AS unique_slug_constraint_89, t0.azure_id AS azure_id_90, t0.email_unsubscribe_reason AS email_unsubscribe_reason_91, t0.email_unsubscribed_at AS email_unsubscribed_at_92, t0.created_at AS created_at_93, t0.updated_at AS updated_at_94, t0.country_id AS country_id_95, t0.main_account_user_id AS main_account_user_id_96, t0.godfather_id AS godfather_id_97, t0.regate_id AS regate_id_98, t0.commercial_id AS commercial_id_99, t0.heating_commercial_id AS heating_commercial_id_100, t0.agency_id AS agency_id_101, t102.id AS id_103, t102.code AS code_104, t102.name AS name_105, t102.region AS region_106, t102.manager_last_name AS manager_last_name_107, t102.manager_first_name AS manager_first_name_108, t102.address1 AS address1_109, t102.address2 AS address2_110, t102.post_code AS post_code_111, t102.city AS city_112, t102.phone AS phone_113, t0.programme_id AS programme_id_114, t0.sale_order_validation_id AS sale_order_validation_id_115, t0.billing_point_id AS billing_point_id_116, t0.request_registration_id AS request_registration_id_117, t0.subscription_id AS subscription_id_118, t0.point_of_sale_id AS point_of_sale_id_119, t120.id AS id_121, t120.code AS code_122, t120.name AS name_123, t120.city AS city_124, t120.enabled AS enabled_125, t120.logo AS logo_126, t120.mail_header AS mail_header_127, t120.created_by_id AS created_by_id_128, t120.address_id AS address_id_129, t0.point_conversion_rate_id AS point_conversion_rate_id_130, t0.responsable_regate_id AS responsable_regate_id_131, t0.coverage_area_id AS coverage_area_id_132, t0.activated_by_id AS activated_by_id_133 FROM user t0 LEFT JOIN agence t102 ON t0.agency_id = t102.id LEFT JOIN point_of_sale t120 ON t0.point_of_sale_id = t120.id WHERE t0.id = ? LIMIT 1
SELECT
t0.id AS id_1,
t0.email AS email_2,
t0.roles AS roles_3,
t0.password AS password_4,
t0.first_name AS first_name_5,
t0.last_name AS last_name_6,
t0.mobile AS mobile_7,
t0.phone AS phone_8,
t0.welcome_email AS welcome_email_9,
t0.available_point AS available_point_10,
t0.potential_point AS potential_point_11,
t0.locale AS locale_12,
t0.job AS job_13,
t0.company AS company_14,
t0.company_siret AS company_siret_15,
t0.company_legal_status AS company_legal_status_16,
t0.user_token AS user_token_17,
t0.user_token_validity AS user_token_validity_18,
t0.user_token_attempts AS user_token_attempts_19,
t0.civility AS civility_20,
t0.address1 AS address1_21,
t0.address2 AS address2_22,
t0.postcode AS postcode_23,
t0.city AS city_24,
t0.can_order AS can_order_25,
t0.deleted_at AS deleted_at_26,
t0.birth_date AS birth_date_27,
t0.birth_place AS birth_place_28,
t0.internal_code AS internal_code_29,
t0.cgu_at AS cgu_at_30,
t0.register_at AS register_at_31,
t0.imported_at AS imported_at_32,
t0.can_be_contacted AS can_be_contacted_33,
t0.capacity AS capacity_34,
t0.address3 AS address3_35,
t0.optin_mail AS optin_mail_36,
t0.optin_sms AS optin_sms_37,
t0.optin_postal AS optin_postal_38,
t0.optin_postal_address AS optin_postal_address_39,
t0.source AS source_40,
t0.level AS level_41,
t0.level0_updated_at AS level0_updated_at_42,
t0.level1_updated_at AS level1_updated_at_43,
t0.level2_updated_at AS level2_updated_at_44,
t0.level3_updated_at AS level3_updated_at_45,
t0.level_update_seen_at AS level_update_seen_at_46,
t0.is_email_ok AS is_email_ok_47,
t0.last_email_check AS last_email_check_48,
t0.api_token AS api_token_49,
t0.sap_account AS sap_account_50,
t0.sap_distributor AS sap_distributor_51,
t0.distributor AS distributor_52,
t0.distributor2 AS distributor2_53,
t0.aggreement AS aggreement_54,
t0.unsubscribed_at AS unsubscribed_at_55,
t0.chauffage AS chauffage_56,
t0.username AS username_57,
t0.username_canonical AS username_canonical_58,
t0.email_canonical AS email_canonical_59,
t0.salt AS salt_60,
t0.last_login AS last_login_61,
t0.confirmation_token AS confirmation_token_62,
t0.password_requested_at AS password_requested_at_63,
t0.credential_expired AS credential_expired_64,
t0.credential_expired_at AS credential_expired_at_65,
t0.donnees_personnelles AS donnees_personnelles_66,
t0.archived_at AS archived_at_67,
t0.newsletter AS newsletter_68,
t0.extension1 AS extension1_69,
t0.extension2 AS extension2_70,
t0.wdg AS wdg_71,
t0.glady_uuid AS glady_uuid_72,
t0.transactional_email AS transactional_email_73,
t0.status AS status_74,
t0.calculated_points AS calculated_points_75,
t0.avatar AS avatar_76,
t0.logo AS logo_77,
t0.fonction AS fonction_78,
t0.registration_document AS registration_document_79,
t0.old_status AS old_status_80,
t0.disabled_at AS disabled_at_81,
t0.archive_reason AS archive_reason_82,
t0.unsubscribe_reason AS unsubscribe_reason_83,
t0.failed_attempts AS failed_attempts_84,
t0.last_failed_attempt AS last_failed_attempt_85,
t0.password_updated_at AS password_updated_at_86,
t0.last_activity AS last_activity_87,
t0.account_id AS account_id_88,
t0.unique_slug_constraint AS unique_slug_constraint_89,
t0.azure_id AS azure_id_90,
t0.email_unsubscribe_reason AS email_unsubscribe_reason_91,
t0.email_unsubscribed_at AS email_unsubscribed_at_92,
t0.created_at AS created_at_93,
t0.updated_at AS updated_at_94,
t0.country_id AS country_id_95,
t0.main_account_user_id AS main_account_user_id_96,
t0.godfather_id AS godfather_id_97,
t0.regate_id AS regate_id_98,
t0.commercial_id AS commercial_id_99,
t0.heating_commercial_id AS heating_commercial_id_100,
t0.agency_id AS agency_id_101,
t102.id AS id_103,
t102.code AS code_104,
t102.name AS name_105,
t102.region AS region_106,
t102.manager_last_name AS manager_last_name_107,
t102.manager_first_name AS manager_first_name_108,
t102.address1 AS address1_109,
t102.address2 AS address2_110,
t102.post_code AS post_code_111,
t102.city AS city_112,
t102.phone AS phone_113,
t0.programme_id AS programme_id_114,
t0.sale_order_validation_id AS sale_order_validation_id_115,
t0.billing_point_id AS billing_point_id_116,
t0.request_registration_id AS request_registration_id_117,
t0.subscription_id AS subscription_id_118,
t0.point_of_sale_id AS point_of_sale_id_119,
t120.id AS id_121,
t120.code AS code_122,
t120.name AS name_123,
t120.city AS city_124,
t120.enabled AS enabled_125,
t120.logo AS logo_126,
t120.mail_header AS mail_header_127,
t120.created_by_id AS created_by_id_128,
t120.address_id AS address_id_129,
t0.point_conversion_rate_id AS point_conversion_rate_id_130,
t0.responsable_regate_id AS responsable_regate_id_131,
t0.coverage_area_id AS coverage_area_id_132,
t0.activated_by_id AS activated_by_id_133
FROM
user t0
LEFT JOIN agence t102 ON t0.agency_id = t102.id
LEFT JOIN point_of_sale t120 ON t0.point_of_sale_id = t120.id
WHERE
t0.id = ?
LIMIT
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.phone AS phone_8, t0.welcome_email AS welcome_email_9, t0.available_point AS available_point_10, t0.potential_point AS potential_point_11, t0.locale AS locale_12, t0.job AS job_13, t0.company AS company_14, t0.company_siret AS company_siret_15, t0.company_legal_status AS company_legal_status_16, t0.user_token AS user_token_17, t0.user_token_validity AS user_token_validity_18, t0.user_token_attempts AS user_token_attempts_19, t0.civility AS civility_20, t0.address1 AS address1_21, t0.address2 AS address2_22, t0.postcode AS postcode_23, t0.city AS city_24, t0.can_order AS can_order_25, t0.deleted_at AS deleted_at_26, t0.birth_date AS birth_date_27, t0.birth_place AS birth_place_28, t0.internal_code AS internal_code_29, t0.cgu_at AS cgu_at_30, t0.register_at AS register_at_31, t0.imported_at AS imported_at_32, t0.can_be_contacted AS can_be_contacted_33, t0.capacity AS capacity_34, t0.address3 AS address3_35, t0.optin_mail AS optin_mail_36, t0.optin_sms AS optin_sms_37, t0.optin_postal AS optin_postal_38, t0.optin_postal_address AS optin_postal_address_39, t0.source AS source_40, t0.level AS level_41, t0.level0_updated_at AS level0_updated_at_42, t0.level1_updated_at AS level1_updated_at_43, t0.level2_updated_at AS level2_updated_at_44, t0.level3_updated_at AS level3_updated_at_45, t0.level_update_seen_at AS level_update_seen_at_46, t0.is_email_ok AS is_email_ok_47, t0.last_email_check AS last_email_check_48, t0.api_token AS api_token_49, t0.sap_account AS sap_account_50, t0.sap_distributor AS sap_distributor_51, t0.distributor AS distributor_52, t0.distributor2 AS distributor2_53, t0.aggreement AS aggreement_54, t0.unsubscribed_at AS unsubscribed_at_55, t0.chauffage AS chauffage_56, t0.username AS username_57, t0.username_canonical AS username_canonical_58, t0.email_canonical AS email_canonical_59, t0.salt AS salt_60, t0.last_login AS last_login_61, t0.confirmation_token AS confirmation_token_62, t0.password_requested_at AS password_requested_at_63, t0.credential_expired AS credential_expired_64, t0.credential_expired_at AS credential_expired_at_65, t0.donnees_personnelles AS donnees_personnelles_66, t0.archived_at AS archived_at_67, t0.newsletter AS newsletter_68, t0.extension1 AS extension1_69, t0.extension2 AS extension2_70, t0.wdg AS wdg_71, t0.glady_uuid AS glady_uuid_72, t0.transactional_email AS transactional_email_73, t0.status AS status_74, t0.calculated_points AS calculated_points_75, t0.avatar AS avatar_76, t0.logo AS logo_77, t0.fonction AS fonction_78, t0.registration_document AS registration_document_79, t0.old_status AS old_status_80, t0.disabled_at AS disabled_at_81, t0.archive_reason AS archive_reason_82, t0.unsubscribe_reason AS unsubscribe_reason_83, t0.failed_attempts AS failed_attempts_84, t0.last_failed_attempt AS last_failed_attempt_85, t0.password_updated_at AS password_updated_at_86, t0.last_activity AS last_activity_87, t0.account_id AS account_id_88, t0.unique_slug_constraint AS unique_slug_constraint_89, t0.azure_id AS azure_id_90, t0.email_unsubscribe_reason AS email_unsubscribe_reason_91, t0.email_unsubscribed_at AS email_unsubscribed_at_92, t0.created_at AS created_at_93, t0.updated_at AS updated_at_94, t0.country_id AS country_id_95, t0.main_account_user_id AS main_account_user_id_96, t0.godfather_id AS godfather_id_97, t0.regate_id AS regate_id_98, t0.commercial_id AS commercial_id_99, t0.heating_commercial_id AS heating_commercial_id_100, t0.agency_id AS agency_id_101, t102.id AS id_103, t102.code AS code_104, t102.name AS name_105, t102.region AS region_106, t102.manager_last_name AS manager_last_name_107, t102.manager_first_name AS manager_first_name_108, t102.address1 AS address1_109, t102.address2 AS address2_110, t102.post_code AS post_code_111, t102.city AS city_112, t102.phone AS phone_113, t0.programme_id AS programme_id_114, t0.sale_order_validation_id AS sale_order_validation_id_115, t0.billing_point_id AS billing_point_id_116, t0.request_registration_id AS request_registration_id_117, t0.subscription_id AS subscription_id_118, t0.point_of_sale_id AS point_of_sale_id_119, t120.id AS id_121, t120.code AS code_122, t120.name AS name_123, t120.city AS city_124, t120.enabled AS enabled_125, t120.logo AS logo_126, t120.mail_header AS mail_header_127, t120.created_by_id AS created_by_id_128, t120.address_id AS address_id_129, t0.point_conversion_rate_id AS point_conversion_rate_id_130, t0.responsable_regate_id AS responsable_regate_id_131, t0.coverage_area_id AS coverage_area_id_132, t0.activated_by_id AS activated_by_id_133 FROM user t0 LEFT JOIN agence t102 ON t0.agency_id = t102.id LEFT JOIN point_of_sale t120 ON t0.point_of_sale_id = t120.id WHERE t0.id = 1 LIMIT 1;
|