Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.level AS level_4,
  t0.db_name AS db_name_5,
  t0.vault_key_id AS vault_key_id_6,
  t0.default_locale AS default_locale_7,
  t0.available_locales AS available_locales_8,
  t0.plan AS plan_9,
  t0.max_families AS max_families_10,
  t0.monthly_sms_budget AS monthly_sms_budget_11,
  t0.payment_gateway AS payment_gateway_12,
  t0.logo_path AS logo_path_13,
  t0.community_photo_path AS community_photo_path_14,
  t0.slug AS slug_15,
  t0.primary_color AS primary_color_16,
  t0.president_name AS president_name_17,
  t0.subdomain_enabled AS subdomain_enabled_18,
  t0.custom_domain AS custom_domain_19,
  t0.street_number AS street_number_20,
  t0.address AS address_21,
  t0.city AS city_22,
  t0.zip AS zip_23,
  t0.country AS country_24,
  t0.timezone AS timezone_25,
  t0.latitude AS latitude_26,
  t0.longitude AS longitude_27,
  t0.reference_city AS reference_city_28,
  t0.phone AS phone_29,
  t0.email AS email_30,
  t0.website AS website_31,
  t0.siret AS siret_32,
  t0.stripe_customer_id AS stripe_customer_id_33,
  t0.stripe_subscription_id AS stripe_subscription_id_34,
  t0.is_active AS is_active_35,
  t0.has_cemetery_module AS has_cemetery_module_36,
  t0.has_wordpress_hosting AS has_wordpress_hosting_37,
  t0.consistoire_reverse_percent AS consistoire_reverse_percent_38,
  t0.consistoire_sharing_level AS consistoire_sharing_level_39,
  t0.fundraising_settings AS fundraising_settings_40,
  t0.pastoral_age_threshold AS pastoral_age_threshold_41,
  t0.created_at AS created_at_42,
  t0.trial_ends_at AS trial_ends_at_43,
  t0.parent_id AS parent_id_44
FROM
  organizations t0
WHERE
  t0.custom_domain = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.level AS level_4, t0.db_name AS db_name_5, t0.vault_key_id AS vault_key_id_6, t0.default_locale AS default_locale_7, t0.available_locales AS available_locales_8, t0.plan AS plan_9, t0.max_families AS max_families_10, t0.monthly_sms_budget AS monthly_sms_budget_11, t0.payment_gateway AS payment_gateway_12, t0.logo_path AS logo_path_13, t0.community_photo_path AS community_photo_path_14, t0.slug AS slug_15, t0.primary_color AS primary_color_16, t0.president_name AS president_name_17, t0.subdomain_enabled AS subdomain_enabled_18, t0.custom_domain AS custom_domain_19, t0.street_number AS street_number_20, t0.address AS address_21, t0.city AS city_22, t0.zip AS zip_23, t0.country AS country_24, t0.timezone AS timezone_25, t0.latitude AS latitude_26, t0.longitude AS longitude_27, t0.reference_city AS reference_city_28, t0.phone AS phone_29, t0.email AS email_30, t0.website AS website_31, t0.siret AS siret_32, t0.stripe_customer_id AS stripe_customer_id_33, t0.stripe_subscription_id AS stripe_subscription_id_34, t0.is_active AS is_active_35, t0.has_cemetery_module AS has_cemetery_module_36, t0.has_wordpress_hosting AS has_wordpress_hosting_37, t0.consistoire_reverse_percent AS consistoire_reverse_percent_38, t0.consistoire_sharing_level AS consistoire_sharing_level_39, t0.fundraising_settings AS fundraising_settings_40, t0.pastoral_age_threshold AS pastoral_age_threshold_41, t0.created_at AS created_at_42, t0.trial_ends_at AS trial_ends_at_43, t0.parent_id AS parent_id_44 FROM organizations t0 WHERE t0.custom_domain = 'managsyntest.avinconcept.fr' AND t0.is_active = 1 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.preferred_locale AS preferred_locale_7,
  t0.totp_secret AS totp_secret_8,
  t0.totp_enabled AS totp_enabled_9,
  t0.email_auth_code AS email_auth_code_10,
  t0.last_login_at AS last_login_at_11,
  t0.last_login_ip AS last_login_ip_12,
  t0.last_login_country AS last_login_country_13,
  t0.is_active AS is_active_14,
  t0.must_change_password AS must_change_password_15,
  t0.password_reset_token AS password_reset_token_16,
  t0.password_reset_expires AS password_reset_expires_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.organization_id AS organization_id_20,
  t0.user_profile_id AS user_profile_id_21
FROM
  users t0
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.preferred_locale AS preferred_locale_7, t0.totp_secret AS totp_secret_8, t0.totp_enabled AS totp_enabled_9, t0.email_auth_code AS email_auth_code_10, t0.last_login_at AS last_login_at_11, t0.last_login_ip AS last_login_ip_12, t0.last_login_country AS last_login_country_13, t0.is_active AS is_active_14, t0.must_change_password AS must_change_password_15, t0.password_reset_token AS password_reset_token_16, t0.password_reset_expires AS password_reset_expires_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.organization_id AS organization_id_20, t0.user_profile_id AS user_profile_id_21 FROM users t0 WHERE t0.email = 'userorganisation2@manager.com' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  users
SET
  last_login_at = ?,
  last_login_ip = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE users SET last_login_at = '2026-09-28 08:39:46', last_login_ip = '154.120.142.38', updated_at = '2026-09-28 08:39:46' WHERE id = 8;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO audit_logs (
  id, action, entity_type, entity_id,
  old_values, new_values, ip_address,
  user_agent, context, level, created_at,
  organization_id, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO audit_logs (id, action, entity_type, entity_id, old_values, new_values, ip_address, user_agent, context, level, created_at, organization_id, user_id) VALUES ('01a0e6bd-b0db-7c8b-9856-aede783a9998', 'update', 'User', '8', '{\"lastLoginAt\":\"2026-09-24 17:19:26\",\"lastLoginIp\":\"88.174.255.130\",\"updatedAt\":\"2026-09-24 17:19:26\"}', '{\"lastLoginAt\":\"2026-09-28 08:39:46\",\"lastLoginIp\":\"154.120.142.38\",\"updatedAt\":\"2026-09-28 08:39:46\"}', '154.120.142.38', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', NULL, 'info', '2026-09-28 08:39:46', 6, 8);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO audit_logs (
  id, action, entity_type, entity_id,
  old_values, new_values, ip_address,
  user_agent, context, level, created_at,
  organization_id, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO audit_logs (id, action, entity_type, entity_id, old_values, new_values, ip_address, user_agent, context, level, created_at, organization_id, user_id) VALUES ('01a0e6bd-b0f7-7099-8ddb-675db7c13584', 'login', 'User', '8', NULL, '{\"firewall\":\"main\"}', '154.120.142.38', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', NULL, 'info', '2026-09-28 08:39:46', 6, 8);

"COMMIT"

"COMMIT";