| 1 |
3.71 ms |
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.email = ? LIMIT 1
Parameters: [
"super_admin@37deux.com"
]
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.email = ?
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.email = 'super_admin@37deux.com' LIMIT 1;
|
| 2 |
3.45 ms |
SELECT s0_.id AS id_0, s0_.total AS total_1, s0_.shipping_method AS shipping_method_2, s0_.status AS status_3, s0_.waiting_status AS waiting_status_4, s0_.cancel_motif AS cancel_motif_5, s0_.shipping_price AS shipping_price_6, s0_.internal_reference AS internal_reference_7, s0_.comment AS comment_8, s0_.is_managed_by_customer AS is_managed_by_customer_9, s0_.fees_order AS fees_order_10, s0_.extra_cb_payment AS extra_cb_payment_11, s0_.total_bonus_used AS total_bonus_used_12, s0_.not_billable AS not_billable_13, s0_.otherinformations AS otherinformations_14, s0_.old_id AS old_id_15, s0_.category_values AS category_values_16, s0_.fees_category_values AS fees_category_values_17, s0_.custom_question AS custom_question_18, s0_.order_rate AS order_rate_19, s0_.is_trip AS is_trip_20, s0_.order_extra_data AS order_extra_data_21, s0_.is_express_delivery AS is_express_delivery_22, s0_.created_at AS created_at_23, s0_.updated_at AS updated_at_24, s0_.bank_return_id AS bank_return_id_25, s0_.user_id AS user_id_26, s0_.saleorder_grouped_id AS saleorder_grouped_id_27, s0_.shipping_address_id AS shipping_address_id_28, s0_.billing_address_id AS billing_address_id_29, s0_.cart_id AS cart_id_30, s0_.invoice_id AS invoice_id_31 FROM sale_order s0_ INNER JOIN user u1_ ON s0_.user_id = u1_.id INNER JOIN sale_order_item s2_ ON s0_.id = s2_.order_id INNER JOIN sale_order_address s3_ ON s0_.shipping_address_id = s3_.id WHERE s0_.updated_at BETWEEN ? AND ? ORDER BY s0_.updated_at DESC
Parameters: [
"2026-03-21 00:00:00"
"2026-03-22 01:00:08"
]
SELECT s0_.id AS id_0, s0_.total AS total_1, s0_.shipping_method AS shipping_method_2, s0_.status AS status_3, s0_.waiting_status AS waiting_status_4, s0_.cancel_motif AS cancel_motif_5, s0_.shipping_price AS shipping_price_6, s0_.internal_reference AS internal_reference_7, s0_.comment AS comment_8, s0_.is_managed_by_customer AS is_managed_by_customer_9, s0_.fees_order AS fees_order_10, s0_.extra_cb_payment AS extra_cb_payment_11, s0_.total_bonus_used AS total_bonus_used_12, s0_.not_billable AS not_billable_13, s0_.otherinformations AS otherinformations_14, s0_.old_id AS old_id_15, s0_.category_values AS category_values_16, s0_.fees_category_values AS fees_category_values_17, s0_.custom_question AS custom_question_18, s0_.order_rate AS order_rate_19, s0_.is_trip AS is_trip_20, s0_.order_extra_data AS order_extra_data_21, s0_.is_express_delivery AS is_express_delivery_22, s0_.created_at AS created_at_23, s0_.updated_at AS updated_at_24, s0_.bank_return_id AS bank_return_id_25, s0_.user_id AS user_id_26, s0_.saleorder_grouped_id AS saleorder_grouped_id_27, s0_.shipping_address_id AS shipping_address_id_28, s0_.billing_address_id AS billing_address_id_29, s0_.cart_id AS cart_id_30, s0_.invoice_id AS invoice_id_31 FROM sale_order s0_ INNER JOIN user u1_ ON s0_.user_id = u1_.id INNER JOIN sale_order_item s2_ ON s0_.id = s2_.order_id INNER JOIN sale_order_address s3_ ON s0_.shipping_address_id = s3_.id WHERE s0_.updated_at BETWEEN '2026-03-21 00:00:00' AND '2026-03-22 01:00:08' ORDER BY s0_.updated_at DESC;
|
| 3 |
2.60 ms |
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;
|
| 4 |
4.42 ms |
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;
|