Symfony Profiler

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;

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;

"START TRANSACTION"

"START TRANSACTION";

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
  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.souissi1' 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 = ?
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.souissi2' LIMIT 1;

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('.');

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

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);

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

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';

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.name AS name_2,
  t0.priority AS priority_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.community_id AS community_id_6
FROM
  mve_costs_level t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.community_id AS community_id_6 FROM mve_costs_level t0 WHERE t0.id = '7';

SELECT
  t0.id AS id_1,
  t0.role_name AS role_name_2,
  t0.description AS description_3,
  t0.is_default AS is_default_4,
  t0.priority AS priority_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  mve_communities_role t0
WHERE
  t0.role_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.role_name AS role_name_2, t0.description AS description_3, t0.is_default AS is_default_4, t0.priority AS priority_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM mve_communities_role t0 WHERE t0.role_name = 'ROLE_MEMBER' LIMIT 1;

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

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);

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;