Symfony Profiler

INSERT INTO audit_user (
  type, object_id, discriminator, transaction_hash,
  diffs, blame_id, blame_user, blame_user_fqdn,
  blame_user_firewall, ip, created_at
)
VALUES
  (
    :type, :object_id, :discriminator,
    :transaction_hash, :diffs, :blame_id,
    :blame_user, :blame_user_fqdn, :blame_user_firewall,
    :ip, :created_at
  )

INSERT INTO audit_user (type, object_id, discriminator, transaction_hash, diffs, blame_id, blame_user, blame_user_fqdn, blame_user_firewall, ip, created_at) VALUES ('update', '621', NULL, '637023decebb8cab138efa9436ae80c392cbc05a', '{\"failedAttempts\":{\"new\":49,\"old\":48},\"lastFailedAttempt\":{\"new\":\"2026-06-27 06:39:16\",\"old\":\"2026-06-24 07:25:02\"}}', NULL, NULL, NULL, 'app', '140.238.254.59', '2026-06-27 06:39:18.824696');

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.country AS country_13,
  t0.job AS job_14,
  t0.company AS company_15,
  t0.company_siret AS company_siret_16,
  t0.company_legal_status AS company_legal_status_17,
  t0.user_token AS user_token_18,
  t0.user_token_validity AS user_token_validity_19,
  t0.user_token_attempts AS user_token_attempts_20,
  t0.civility AS civility_21,
  t0.address1 AS address1_22,
  t0.address2 AS address2_23,
  t0.postcode AS postcode_24,
  t0.city AS city_25,
  t0.can_order AS can_order_26,
  t0.deleted_at AS deleted_at_27,
  t0.birth_date AS birth_date_28,
  t0.birth_place AS birth_place_29,
  t0.social_security_number AS social_security_number_30,
  t0.internal_code AS internal_code_31,
  t0.cgu_at AS cgu_at_32,
  t0.imported_at AS imported_at_33,
  t0.can_be_contacted AS can_be_contacted_34,
  t0.capacity AS capacity_35,
  t0.address3 AS address3_36,
  t0.optin_mail AS optin_mail_37,
  t0.optin_sms AS optin_sms_38,
  t0.optin_postal AS optin_postal_39,
  t0.optin_postal_address AS optin_postal_address_40,
  t0.source AS source_41,
  t0.level AS level_42,
  t0.level0_updated_at AS level0_updated_at_43,
  t0.level1_updated_at AS level1_updated_at_44,
  t0.level2_updated_at AS level2_updated_at_45,
  t0.level3_updated_at AS level3_updated_at_46,
  t0.level_update_seen_at AS level_update_seen_at_47,
  t0.is_email_ok AS is_email_ok_48,
  t0.last_email_check AS last_email_check_49,
  t0.api_token AS api_token_50,
  t0.sap_account AS sap_account_51,
  t0.sap_distributor AS sap_distributor_52,
  t0.distributor AS distributor_53,
  t0.distributor2 AS distributor2_54,
  t0.aggreement AS aggreement_55,
  t0.unsubscribed_at AS unsubscribed_at_56,
  t0.chauffage AS chauffage_57,
  t0.username AS username_58,
  t0.username_canonical AS username_canonical_59,
  t0.email_canonical AS email_canonical_60,
  t0.salt AS salt_61,
  t0.last_login AS last_login_62,
  t0.confirmation_token AS confirmation_token_63,
  t0.password_requested_at AS password_requested_at_64,
  t0.credential_expired AS credential_expired_65,
  t0.credential_expired_at AS credential_expired_at_66,
  t0.donnees_personnelles AS donnees_personnelles_67,
  t0.archived_at AS archived_at_68,
  t0.newsletter AS newsletter_69,
  t0.extension1 AS extension1_70,
  t0.extension2 AS extension2_71,
  t0.wdg AS wdg_72,
  t0.glady_uuid AS glady_uuid_73,
  t0.transactional_email AS transactional_email_74,
  t0.status AS status_75,
  t0.calculated_points AS calculated_points_76,
  t0.avatar AS avatar_77,
  t0.logo AS logo_78,
  t0.fonction AS fonction_79,
  t0.registration_document AS registration_document_80,
  t0.old_status AS old_status_81,
  t0.disabled_at AS disabled_at_82,
  t0.archive_reason AS archive_reason_83,
  t0.unsubscribe_reason AS unsubscribe_reason_84,
  t0.failed_attempts AS failed_attempts_85,
  t0.last_failed_attempt AS last_failed_attempt_86,
  t0.password_updated_at AS password_updated_at_87,
  t0.last_activity AS last_activity_88,
  t0.created_at AS created_at_89,
  t0.updated_at AS updated_at_90,
  t0.main_account_user_id AS main_account_user_id_91,
  t0.regate_id AS regate_id_92,
  t0.commercial_id AS commercial_id_93,
  t0.heating_commercial_id AS heating_commercial_id_94,
  t0.agency_id AS agency_id_95,
  t96.id AS id_97,
  t96.code AS code_98,
  t96.name AS name_99,
  t96.region AS region_100,
  t96.manager_last_name AS manager_last_name_101,
  t96.manager_first_name AS manager_first_name_102,
  t96.address1 AS address1_103,
  t96.address2 AS address2_104,
  t96.post_code AS post_code_105,
  t96.city AS city_106,
  t96.phone AS phone_107,
  t0.programme_id AS programme_id_108,
  t0.sale_order_validation_id AS sale_order_validation_id_109,
  t0.billing_point_id AS billing_point_id_110,
  t0.request_registration_id AS request_registration_id_111,
  t0.subscription_id AS subscription_id_112,
  t0.point_of_sale_id AS point_of_sale_id_113,
  t114.id AS id_115,
  t114.code AS code_116,
  t114.name AS name_117,
  t114.city AS city_118,
  t114.enabled AS enabled_119,
  t114.created_by_id AS created_by_id_120,
  t114.address_id AS address_id_121,
  t0.point_conversion_rate_id AS point_conversion_rate_id_122,
  t0.responsable_regate_id AS responsable_regate_id_123,
  t124.id AS id_125,
  t124.user_id AS user_id_126
FROM
  `user` t0
  LEFT JOIN agence t96 ON t0.agency_id = t96.id
  LEFT JOIN point_of_sale t114 ON t0.point_of_sale_id = t114.id
  LEFT JOIN coverage_area t124 ON t124.user_id = t0.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.country AS country_13, t0.job AS job_14, t0.company AS company_15, t0.company_siret AS company_siret_16, t0.company_legal_status AS company_legal_status_17, t0.user_token AS user_token_18, t0.user_token_validity AS user_token_validity_19, t0.user_token_attempts AS user_token_attempts_20, t0.civility AS civility_21, t0.address1 AS address1_22, t0.address2 AS address2_23, t0.postcode AS postcode_24, t0.city AS city_25, t0.can_order AS can_order_26, t0.deleted_at AS deleted_at_27, t0.birth_date AS birth_date_28, t0.birth_place AS birth_place_29, t0.social_security_number AS social_security_number_30, t0.internal_code AS internal_code_31, t0.cgu_at AS cgu_at_32, t0.imported_at AS imported_at_33, t0.can_be_contacted AS can_be_contacted_34, t0.capacity AS capacity_35, t0.address3 AS address3_36, t0.optin_mail AS optin_mail_37, t0.optin_sms AS optin_sms_38, t0.optin_postal AS optin_postal_39, t0.optin_postal_address AS optin_postal_address_40, t0.source AS source_41, t0.level AS level_42, t0.level0_updated_at AS level0_updated_at_43, t0.level1_updated_at AS level1_updated_at_44, t0.level2_updated_at AS level2_updated_at_45, t0.level3_updated_at AS level3_updated_at_46, t0.level_update_seen_at AS level_update_seen_at_47, t0.is_email_ok AS is_email_ok_48, t0.last_email_check AS last_email_check_49, t0.api_token AS api_token_50, t0.sap_account AS sap_account_51, t0.sap_distributor AS sap_distributor_52, t0.distributor AS distributor_53, t0.distributor2 AS distributor2_54, t0.aggreement AS aggreement_55, t0.unsubscribed_at AS unsubscribed_at_56, t0.chauffage AS chauffage_57, t0.username AS username_58, t0.username_canonical AS username_canonical_59, t0.email_canonical AS email_canonical_60, t0.salt AS salt_61, t0.last_login AS last_login_62, t0.confirmation_token AS confirmation_token_63, t0.password_requested_at AS password_requested_at_64, t0.credential_expired AS credential_expired_65, t0.credential_expired_at AS credential_expired_at_66, t0.donnees_personnelles AS donnees_personnelles_67, t0.archived_at AS archived_at_68, t0.newsletter AS newsletter_69, t0.extension1 AS extension1_70, t0.extension2 AS extension2_71, t0.wdg AS wdg_72, t0.glady_uuid AS glady_uuid_73, t0.transactional_email AS transactional_email_74, t0.status AS status_75, t0.calculated_points AS calculated_points_76, t0.avatar AS avatar_77, t0.logo AS logo_78, t0.fonction AS fonction_79, t0.registration_document AS registration_document_80, t0.old_status AS old_status_81, t0.disabled_at AS disabled_at_82, t0.archive_reason AS archive_reason_83, t0.unsubscribe_reason AS unsubscribe_reason_84, t0.failed_attempts AS failed_attempts_85, t0.last_failed_attempt AS last_failed_attempt_86, t0.password_updated_at AS password_updated_at_87, t0.last_activity AS last_activity_88, t0.created_at AS created_at_89, t0.updated_at AS updated_at_90, t0.main_account_user_id AS main_account_user_id_91, t0.regate_id AS regate_id_92, t0.commercial_id AS commercial_id_93, t0.heating_commercial_id AS heating_commercial_id_94, t0.agency_id AS agency_id_95, t96.id AS id_97, t96.code AS code_98, t96.name AS name_99, t96.region AS region_100, t96.manager_last_name AS manager_last_name_101, t96.manager_first_name AS manager_first_name_102, t96.address1 AS address1_103, t96.address2 AS address2_104, t96.post_code AS post_code_105, t96.city AS city_106, t96.phone AS phone_107, t0.programme_id AS programme_id_108, t0.sale_order_validation_id AS sale_order_validation_id_109, t0.billing_point_id AS billing_point_id_110, t0.request_registration_id AS request_registration_id_111, t0.subscription_id AS subscription_id_112, t0.point_of_sale_id AS point_of_sale_id_113, t114.id AS id_115, t114.code AS code_116, t114.name AS name_117, t114.city AS city_118, t114.enabled AS enabled_119, t114.created_by_id AS created_by_id_120, t114.address_id AS address_id_121, t0.point_conversion_rate_id AS point_conversion_rate_id_122, t0.responsable_regate_id AS responsable_regate_id_123, t124.id AS id_125, t124.user_id AS user_id_126 FROM `user` t0 LEFT JOIN agence t96 ON t0.agency_id = t96.id LEFT JOIN point_of_sale t114 ON t0.point_of_sale_id = t114.id LEFT JOIN coverage_area t124 ON t124.user_id = t0.id WHERE t0.email = '' LIMIT 1;

UPDATE
  `user`
SET
  failed_attempts = ?,
  last_failed_attempt = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE `user` SET failed_attempts = 49, last_failed_attempt = '2026-06-27 06:39:16', updated_at = '2026-06-27 06:39:18' WHERE id = 621;

SELECT
  t0.id AS id_1,
  t0.required_points AS required_points_2,
  t0.rank AS rank_3,
  t0.percentage AS percentage_4,
  t0.level AS level_5,
  t0.bonus_when_achieved AS bonus_when_achieved_6
FROM
  point_transaction_multiplier t0
WHERE
  t0.level = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.required_points AS required_points_2, t0.rank AS rank_3, t0.percentage AS percentage_4, t0.level AS level_5, t0.bonus_when_achieved AS bonus_when_achieved_6 FROM point_transaction_multiplier t0 WHERE t0.level = 0 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";