Symfony Profiler

INSERT INTO mve_users_user (
  unique_id, username, roles, first_name,
  last_name, email, birth_date, gender,
  phone, password, password_hash, is_active,
  type_social, id_social, is_blocked,
  cv, bio, picture, qr_path, is_default,
  created_at, updated_at, organization_id,
  country_id, functions_id, speciality_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO mve_users_user (unique_id, username, roles, first_name, last_name, email, birth_date, gender, phone, password, password_hash, is_active, type_social, id_social, is_blocked, cv, bio, picture, qr_path, is_default, created_at, updated_at, organization_id, country_id, functions_id, speciality_id) VALUES ('b1088faf-dffd-44c2-a37d-da5aae33089b', 'chaima.souissi2', '[\"ROLE_VIOOER\"]', 'Chaima', 'SOUISSI', 'kifax82935@ebflyai.com', '2000-08-18', 'female', '+21692519670', '$2y$13$uS.so7055bHD9IZl5NHOPuzhZsW.9y6TQRtL0r6hM2Q2z/dHh4VBu', 'b5KA/0sywv9wTBU6fDBHsmxLcFZJelpjcXBNeklnZ2o5MkZQUGc9PQ==', 0, NULL, NULL, 0, NULL, NULL, 'blank.png', '20fc92118cb83c5c62a14fe9a33ecf52.png', '[]', '2026-08-25 13:10:52', '2026-08-25 13:10:52', NULL, 227, 15, 140);

INSERT INTO mve_users_custom_field_data (
  unique_id, field_value, created_at,
  updated_at, user_id, custom_field_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO mve_users_custom_field_data (unique_id, field_value, created_at, updated_at, user_id, custom_field_id) VALUES ('a4241193-e3cb-4cf6-9991-d20368b945c7', '0', '2026-08-25 13:10:52', '2026-08-25 13:10:52', 701, 22);

INSERT INTO mve_communities_community_user (
  unique_id, grade, status, payment_link_token,
  payment_link_expires_at, validated_at,
  created_at, updated_at, validated_by,
  created_by_id, blocked_by_id, community_id,
  user_id, role_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO mve_communities_community_user (unique_id, grade, status, payment_link_token, payment_link_expires_at, validated_at, created_at, updated_at, validated_by, created_by_id, blocked_by_id, community_id, user_id, role_id) VALUES ('ce8892e6-dc6f-4dae-85aa-7bf65ef4b07e', 'Affiliate', 'Validated', NULL, NULL, NULL, '2026-08-25 13:10:52', '2026-08-25 13:10:52', NULL, NULL, NULL, 3, 701, 10);

INSERT INTO mve_payments_invoice (
  unique_id, issue_date, due_date, is_global_purchase_event_invoice,
  invoice_number, total_amount, status,
  created_at, updated_at, tax_rate_id,
  payment_id, purchase_event_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO mve_payments_invoice (unique_id, issue_date, due_date, is_global_purchase_event_invoice, invoice_number, total_amount, status, created_at, updated_at, tax_rate_id, payment_id, purchase_event_id) VALUES ('ce1fb116-242a-4cb9-ad2d-efd73ba8f642', '2026-08-25 13:10:52', '2026-09-24 13:10:52', 0, 'C4EUMV36', 37.5, 'Waiting', '2026-08-25 13:10:52', '2026-08-25 13:10:52', 3, 190, NULL);

INSERT INTO mve_payments_payment (
  unique_id, amount, transaction, receipt_number,
  status, payment_date, created_at,
  updated_at, purchase_id, purchase_membre_id,
  purchase_event_id, purchase_prestation
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO mve_payments_payment (unique_id, amount, transaction, receipt_number, status, payment_date, created_at, updated_at, purchase_id, purchase_membre_id, purchase_event_id, purchase_prestation) VALUES ('acb15575-9108-4af2-83a6-e94c32c097d8', 37.5, NULL, NULL, 'pending', '2026-08-25 13:10:52', '2026-08-25 13:10:52', '2026-08-25 13:10:52', NULL, 155, NULL, NULL);

INSERT INTO mve_payments_purchase_member (
  unique_id, amount_paid, payment_status,
  upgraded_from, purchase_date, created_at,
  updated_at, community_user_id, payment_org_method_id,
  community_cost_id, cost_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO mve_payments_purchase_member (unique_id, amount_paid, payment_status, upgraded_from, purchase_date, created_at, updated_at, community_user_id, payment_org_method_id, community_cost_id, cost_id) VALUES ('da21b4c0-7f57-465f-8579-2e8faf83c105', 37.5, 'Ordered', NULL, '2026-08-25 13:10:52', '2026-08-25 13:10:52', '2026-08-25 13:10:52', 171, 23, NULL, NULL);

INSERT INTO mve_users_activation_token (
  token, expires_at, is_used, created_at,
  used_at, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO mve_users_activation_token (token, expires_at, is_used, created_at, used_at, user_id) VALUES ('9effd1ca2914ca5832669bd9b90890b86cfb5101e7d6575e2be5b98832d44e53', '2026-08-26 13:10:52', 0, '2026-08-25 13:10:52', NULL, 701);

INSERT INTO mve_users_user_interest (user_id, interest_id, created_at)
VALUES
  (
    ?,
    ?,
    NOW()
  )

INSERT INTO mve_users_user_interest (user_id, interest_id, created_at) VALUES (701, '7', NOW());

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.email AS email_7,
  t0.birth_date AS birth_date_8,
  t0.gender AS gender_9,
  t0.phone AS phone_10,
  t0.password AS password_11,
  t0.password_hash AS password_hash_12,
  t0.is_active AS is_active_13,
  t0.type_social AS type_social_14,
  t0.id_social AS id_social_15,
  t0.is_blocked AS is_blocked_16,
  t0.cv AS cv_17,
  t0.bio AS bio_18,
  t0.picture AS picture_19,
  t0.qr_path AS qr_path_20,
  t0.is_default AS is_default_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.organization_id AS organization_id_24,
  t0.country_id AS country_id_25,
  t0.functions_id AS functions_id_26,
  t0.speciality_id AS speciality_id_27,
  t28.id AS id_29,
  t28.qr_code_content AS qr_code_content_30,
  t28.qr_code_image AS qr_code_image_31,
  t28.center_element_type AS center_element_type_32,
  t28.custom_icon_image AS custom_icon_image_33,
  t28.theme_color AS theme_color_34,
  t28.custom_color AS custom_color_35,
  t28.layout AS layout_36,
  t28.template_id AS template_id_37,
  t28.photo_position AS photo_position_38,
  t28.center_element_size AS center_element_size_39,
  t28.center_element_position AS center_element_position_40,
  t28.background_type AS background_type_41,
  t28.background_value AS background_value_42,
  t28.font_family AS font_family_43,
  t28.show_email AS show_email_44,
  t28.show_phone AS show_phone_45,
  t28.show_speciality AS show_speciality_46,
  t28.show_function AS show_function_47,
  t28.show_organization AS show_organization_48,
  t28.show_community_logo AS show_community_logo_49,
  t28.is_active AS is_active_50,
  t28.version AS version_51,
  t28.created_at AS created_at_52,
  t28.updated_at AS updated_at_53,
  t28.user_id AS user_id_54
FROM
  mve_users_user t0
  LEFT JOIN mve_user_badge t28 ON t28.user_id = t0.id
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.username AS username_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.birth_date AS birth_date_8, t0.gender AS gender_9, t0.phone AS phone_10, t0.password AS password_11, t0.password_hash AS password_hash_12, t0.is_active AS is_active_13, t0.type_social AS type_social_14, t0.id_social AS id_social_15, t0.is_blocked AS is_blocked_16, t0.cv AS cv_17, t0.bio AS bio_18, t0.picture AS picture_19, t0.qr_path AS qr_path_20, t0.is_default AS is_default_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.organization_id AS organization_id_24, t0.country_id AS country_id_25, t0.functions_id AS functions_id_26, t0.speciality_id AS speciality_id_27, t28.id AS id_29, t28.qr_code_content AS qr_code_content_30, t28.qr_code_image AS qr_code_image_31, t28.center_element_type AS center_element_type_32, t28.custom_icon_image AS custom_icon_image_33, t28.theme_color AS theme_color_34, t28.custom_color AS custom_color_35, t28.layout AS layout_36, t28.template_id AS template_id_37, t28.photo_position AS photo_position_38, t28.center_element_size AS center_element_size_39, t28.center_element_position AS center_element_position_40, t28.background_type AS background_type_41, t28.background_value AS background_value_42, t28.font_family AS font_family_43, t28.show_email AS show_email_44, t28.show_phone AS show_phone_45, t28.show_speciality AS show_speciality_46, t28.show_function AS show_function_47, t28.show_organization AS show_organization_48, t28.show_community_logo AS show_community_logo_49, t28.is_active AS is_active_50, t28.version AS version_51, t28.created_at AS created_at_52, t28.updated_at AS updated_at_53, t28.user_id AS user_id_54 FROM mve_users_user t0 LEFT JOIN mve_user_badge t28 ON t28.user_id = t0.id WHERE t0.username = 'chaima.souissi' LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.type AS type_1,
  m0_.days_before AS days_before_2,
  m0_.email AS email_3,
  m0_.subject AS subject_4,
  m0_.body AS body_5,
  m0_.created_at AS created_at_6,
  m0_.updated_at AS updated_at_7,
  m0_.community_id AS community_id_8,
  m0_.event_id AS event_id_9
FROM
  mve_notifications_template m0_
WHERE
  m0_.type = ?
  AND m0_.community_id = ?
  AND m0_.event_id IS NULL
LIMIT
  1

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.days_before AS days_before_2, m0_.email AS email_3, m0_.subject AS subject_4, m0_.body AS body_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.community_id AS community_id_8, m0_.event_id AS event_id_9 FROM mve_notifications_template m0_ WHERE m0_.type = 'activation' AND m0_.community_id = 3 AND m0_.event_id IS NULL LIMIT 1;

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

SELECT
  m0_.id AS id_0,
  m0_.type AS type_1,
  m0_.days_before AS days_before_2,
  m0_.email AS email_3,
  m0_.subject AS subject_4,
  m0_.body AS body_5,
  m0_.created_at AS created_at_6,
  m0_.updated_at AS updated_at_7
FROM
  mve_notifications_default_template m0_
WHERE
  m0_.type = ?
ORDER BY
  m0_.id DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.days_before AS days_before_2, m0_.email AS email_3, m0_.subject AS subject_4, m0_.body AS body_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7 FROM mve_notifications_default_template m0_ WHERE m0_.type = 'activation' ORDER BY m0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.issue_date AS issue_date_3,
  t0.due_date AS due_date_4,
  t0.is_global_purchase_event_invoice AS is_global_purchase_event_invoice_5,
  t0.invoice_number AS invoice_number_6,
  t0.total_amount AS total_amount_7,
  t0.status AS status_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.tax_rate_id AS tax_rate_id_11,
  t0.payment_id AS payment_id_12,
  t0.purchase_event_id AS purchase_event_id_13
FROM
  mve_payments_invoice t0
WHERE
  t0.invoice_number = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.issue_date AS issue_date_3, t0.due_date AS due_date_4, t0.is_global_purchase_event_invoice AS is_global_purchase_event_invoice_5, t0.invoice_number AS invoice_number_6, t0.total_amount AS total_amount_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.tax_rate_id AS tax_rate_id_11, t0.payment_id AS payment_id_12, t0.purchase_event_id AS purchase_event_id_13 FROM mve_payments_invoice t0 WHERE t0.invoice_number = 'C4EUMV36' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.expires_at AS expires_at_3,
  t0.is_active AS is_active_4,
  t0.max_uses AS max_uses_5,
  t0.current_uses AS current_uses_6,
  t0.last_used_at AS last_used_at_7,
  t0.allowed_domain AS allowed_domain_8,
  t0.is_default AS is_default_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.community_id AS community_id_12,
  t0.event_id AS event_id_13,
  t0.invited_by_id AS invited_by_id_14
FROM
  mve_invitations_invitation_token t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.expires_at AS expires_at_3, t0.is_active AS is_active_4, t0.max_uses AS max_uses_5, t0.current_uses AS current_uses_6, t0.last_used_at AS last_used_at_7, t0.allowed_domain AS allowed_domain_8, t0.is_default AS is_default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.community_id AS community_id_12, t0.event_id AS event_id_13, t0.invited_by_id AS invited_by_id_14 FROM mve_invitations_invitation_token t0 WHERE t0.token = 'c1f2c6e3249df2b5a17ba8d01aba7ed71b4931f6bc135f106fe6fc0716858498' LIMIT 1;

INSERT INTO mve_communities_tag_has_community_user (
  created_at, updated_at, community_user_id,
  tag_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO mve_communities_tag_has_community_user (created_at, updated_at, community_user_id, tag_id) VALUES ('2026-08-25 13:10:52', '2026-08-25 13:10:52', 171, 12);

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

"COMMIT"

"COMMIT";

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.created_at AS created_at_2,
  m0_.updated_at AS updated_at_3
FROM
  mve_users_function m0_
WHERE
  LOWER(m0_.name) = LOWER(?)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.created_at AS created_at_2, m0_.updated_at AS updated_at_3 FROM mve_users_function m0_ WHERE LOWER(m0_.name) = LOWER('.');

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.name AS name_3,
  t0.fr_name AS fr_name_4,
  t0.qr_path AS qr_path_5,
  t0.slug AS slug_6,
  t0.status AS status_7,
  t0.pricing_plan AS pricing_plan_8,
  t0.require_validation_before_payment AS require_validation_before_payment_9,
  t0.community_url AS community_url_10,
  t0.registration_background_url AS registration_background_url_11,
  t0.signin_brand_config AS signin_brand_config_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.organization_id AS organization_id_15,
  t0.speciality_id AS speciality_id_16
FROM
  mve_communities_community t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.name AS name_3, t0.fr_name AS fr_name_4, t0.qr_path AS qr_path_5, t0.slug AS slug_6, t0.status AS status_7, t0.pricing_plan AS pricing_plan_8, t0.require_validation_before_payment AS require_validation_before_payment_9, t0.community_url AS community_url_10, t0.registration_background_url AS registration_background_url_11, t0.signin_brand_config AS signin_brand_config_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.organization_id AS organization_id_15, t0.speciality_id AS speciality_id_16 FROM mve_communities_community t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.fr_name AS fr_name_3,
  t0.description AS description_4,
  t0.icon AS icon_5,
  t0.is_active AS is_active_6,
  t0.sort_order AS sort_order_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  mve_users_interest t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.fr_name AS fr_name_3, t0.description AS description_4, t0.icon AS icon_5, t0.is_active AS is_active_6, t0.sort_order AS sort_order_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM mve_users_interest t0 WHERE t0.id = '7';

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.matricule_fiscal AS matricule_fiscal_3,
  t0.name AS name_4,
  t0.address AS address_5,
  t0.city AS city_6,
  t0.postal_code AS postal_code_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.web_site AS web_site_10,
  t0.creation_date AS creation_date_11,
  t0.description AS description_12,
  t0.logo_url AS logo_url_13,
  t0.fav_icon_url AS fav_icon_url_14,
  t0.status AS status_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.sector_id AS sector_id_18,
  t0.country_id AS country_id_19,
  t0.tax_id AS tax_id_20
FROM
  mve_organizations_organization t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.matricule_fiscal AS matricule_fiscal_3, t0.name AS name_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.phone AS phone_8, t0.email AS email_9, t0.web_site AS web_site_10, t0.creation_date AS creation_date_11, t0.description AS description_12, t0.logo_url AS logo_url_13, t0.fav_icon_url AS fav_icon_url_14, t0.status AS status_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.sector_id AS sector_id_18, t0.country_id AS country_id_19, t0.tax_id AS tax_id_20 FROM mve_organizations_organization t0 WHERE t0.id = 3;