Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.civility AS civility_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.email AS email_8,
  t0.uuid AS uuid_9,
  t0.last_login AS last_login_10,
  t0.is_active AS is_active_11,
  t0.admin_review AS admin_review_12,
  t0.is_disabled AS is_disabled_13,
  t0.zotero_user_id AS zotero_user_id_14,
  t0.zotero_api_key AS zotero_api_key_15,
  t0.semantic_scholar_api_key AS semantic_scholar_api_key_16,
  t0.two_factor_code AS two_factor_code_17,
  t0.two_factor_expires_at AS two_factor_expires_at_18,
  t0.is_two_factor_enabled AS is_two_factor_enabled_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.university_id AS university_id_22,
  t23.id AS id_24,
  t23.biography AS biography_25,
  t23.picture AS picture_26,
  t23.date_of_birth AS date_of_birth_27,
  t23.address AS address_28,
  t23.city AS city_29,
  t23.postal_code AS postal_code_30,
  t23.country AS country_31,
  t23.internal_biography AS internal_biography_32,
  t23.is_public AS is_public_33,
  t23.phone_number AS phone_number_34,
  t23.user_id AS user_id_35,
  t36.id AS id_37,
  t36.value AS value_38,
  t36.expiration_date AS expiration_date_39,
  t36.user_id AS user_id_40,
  t0.statut_id AS statut_id_41,
  t0.organization_id AS organization_id_42
FROM
  user t0
  LEFT JOIN user_profile t23 ON t23.user_id = t0.id
  LEFT JOIN reset_password_token t36 ON t36.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.civility AS civility_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.uuid AS uuid_9, t0.last_login AS last_login_10, t0.is_active AS is_active_11, t0.admin_review AS admin_review_12, t0.is_disabled AS is_disabled_13, t0.zotero_user_id AS zotero_user_id_14, t0.zotero_api_key AS zotero_api_key_15, t0.semantic_scholar_api_key AS semantic_scholar_api_key_16, t0.two_factor_code AS two_factor_code_17, t0.two_factor_expires_at AS two_factor_expires_at_18, t0.is_two_factor_enabled AS is_two_factor_enabled_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.university_id AS university_id_22, t23.id AS id_24, t23.biography AS biography_25, t23.picture AS picture_26, t23.date_of_birth AS date_of_birth_27, t23.address AS address_28, t23.city AS city_29, t23.postal_code AS postal_code_30, t23.country AS country_31, t23.internal_biography AS internal_biography_32, t23.is_public AS is_public_33, t23.phone_number AS phone_number_34, t23.user_id AS user_id_35, t36.id AS id_37, t36.value AS value_38, t36.expiration_date AS expiration_date_39, t36.user_id AS user_id_40, t0.statut_id AS statut_id_41, t0.organization_id AS organization_id_42 FROM user t0 LEFT JOIN user_profile t23 ON t23.user_id = t0.id LEFT JOIN reset_password_token t36 ON t36.user_id = t0.id WHERE t0.id = 23;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.civility AS civility_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.email AS email_8,
  t0.uuid AS uuid_9,
  t0.last_login AS last_login_10,
  t0.is_active AS is_active_11,
  t0.admin_review AS admin_review_12,
  t0.is_disabled AS is_disabled_13,
  t0.zotero_user_id AS zotero_user_id_14,
  t0.zotero_api_key AS zotero_api_key_15,
  t0.semantic_scholar_api_key AS semantic_scholar_api_key_16,
  t0.two_factor_code AS two_factor_code_17,
  t0.two_factor_expires_at AS two_factor_expires_at_18,
  t0.is_two_factor_enabled AS is_two_factor_enabled_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.university_id AS university_id_22,
  t23.id AS id_24,
  t23.biography AS biography_25,
  t23.picture AS picture_26,
  t23.date_of_birth AS date_of_birth_27,
  t23.address AS address_28,
  t23.city AS city_29,
  t23.postal_code AS postal_code_30,
  t23.country AS country_31,
  t23.internal_biography AS internal_biography_32,
  t23.is_public AS is_public_33,
  t23.phone_number AS phone_number_34,
  t23.user_id AS user_id_35,
  t36.id AS id_37,
  t36.value AS value_38,
  t36.expiration_date AS expiration_date_39,
  t36.user_id AS user_id_40,
  t0.statut_id AS statut_id_41,
  t0.organization_id AS organization_id_42
FROM
  user t0
  LEFT JOIN user_profile t23 ON t23.user_id = t0.id
  LEFT JOIN reset_password_token t36 ON t36.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.civility AS civility_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.uuid AS uuid_9, t0.last_login AS last_login_10, t0.is_active AS is_active_11, t0.admin_review AS admin_review_12, t0.is_disabled AS is_disabled_13, t0.zotero_user_id AS zotero_user_id_14, t0.zotero_api_key AS zotero_api_key_15, t0.semantic_scholar_api_key AS semantic_scholar_api_key_16, t0.two_factor_code AS two_factor_code_17, t0.two_factor_expires_at AS two_factor_expires_at_18, t0.is_two_factor_enabled AS is_two_factor_enabled_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.university_id AS university_id_22, t23.id AS id_24, t23.biography AS biography_25, t23.picture AS picture_26, t23.date_of_birth AS date_of_birth_27, t23.address AS address_28, t23.city AS city_29, t23.postal_code AS postal_code_30, t23.country AS country_31, t23.internal_biography AS internal_biography_32, t23.is_public AS is_public_33, t23.phone_number AS phone_number_34, t23.user_id AS user_id_35, t36.id AS id_37, t36.value AS value_38, t36.expiration_date AS expiration_date_39, t36.user_id AS user_id_40, t0.statut_id AS statut_id_41, t0.organization_id AS organization_id_42 FROM user t0 LEFT JOIN user_profile t23 ON t23.user_id = t0.id LEFT JOIN reset_password_token t36 ON t36.user_id = t0.id WHERE t0.id = '763';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.is_university_required AS is_university_required_4
FROM
  statut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_university_required AS is_university_required_4 FROM statut t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domain AS domain_3,
  t0.edugain AS edugain_4,
  t0.paid_access AS paid_access_5,
  t0.type AS type_6,
  t0.address AS address_7
FROM
  organization t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.edugain AS edugain_4, t0.paid_access AS paid_access_5, t0.type AS type_6, t0.address AS address_7 FROM organization t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.civility AS civility_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.email AS email_8,
  t0.uuid AS uuid_9,
  t0.last_login AS last_login_10,
  t0.is_active AS is_active_11,
  t0.admin_review AS admin_review_12,
  t0.is_disabled AS is_disabled_13,
  t0.zotero_user_id AS zotero_user_id_14,
  t0.zotero_api_key AS zotero_api_key_15,
  t0.semantic_scholar_api_key AS semantic_scholar_api_key_16,
  t0.two_factor_code AS two_factor_code_17,
  t0.two_factor_expires_at AS two_factor_expires_at_18,
  t0.is_two_factor_enabled AS is_two_factor_enabled_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.university_id AS university_id_22,
  t23.id AS id_24,
  t23.biography AS biography_25,
  t23.picture AS picture_26,
  t23.date_of_birth AS date_of_birth_27,
  t23.address AS address_28,
  t23.city AS city_29,
  t23.postal_code AS postal_code_30,
  t23.country AS country_31,
  t23.internal_biography AS internal_biography_32,
  t23.is_public AS is_public_33,
  t23.phone_number AS phone_number_34,
  t23.user_id AS user_id_35,
  t36.id AS id_37,
  t36.value AS value_38,
  t36.expiration_date AS expiration_date_39,
  t36.user_id AS user_id_40,
  t0.statut_id AS statut_id_41,
  t0.organization_id AS organization_id_42
FROM
  user t0
  LEFT JOIN user_profile t23 ON t23.user_id = t0.id
  LEFT JOIN reset_password_token t36 ON t36.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  2

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.civility AS civility_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.uuid AS uuid_9, t0.last_login AS last_login_10, t0.is_active AS is_active_11, t0.admin_review AS admin_review_12, t0.is_disabled AS is_disabled_13, t0.zotero_user_id AS zotero_user_id_14, t0.zotero_api_key AS zotero_api_key_15, t0.semantic_scholar_api_key AS semantic_scholar_api_key_16, t0.two_factor_code AS two_factor_code_17, t0.two_factor_expires_at AS two_factor_expires_at_18, t0.is_two_factor_enabled AS is_two_factor_enabled_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.university_id AS university_id_22, t23.id AS id_24, t23.biography AS biography_25, t23.picture AS picture_26, t23.date_of_birth AS date_of_birth_27, t23.address AS address_28, t23.city AS city_29, t23.postal_code AS postal_code_30, t23.country AS country_31, t23.internal_biography AS internal_biography_32, t23.is_public AS is_public_33, t23.phone_number AS phone_number_34, t23.user_id AS user_id_35, t36.id AS id_37, t36.value AS value_38, t36.expiration_date AS expiration_date_39, t36.user_id AS user_id_40, t0.statut_id AS statut_id_41, t0.organization_id AS organization_id_42 FROM user t0 LEFT JOIN user_profile t23 ON t23.user_id = t0.id LEFT JOIN reset_password_token t36 ON t36.user_id = t0.id WHERE t0.email = 'marion.krafft@univ-amu.fr' LIMIT 2;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user
SET
  is_two_factor_enabled = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user SET is_two_factor_enabled = 1, updated_at = '2026-07-14 12:44:00' WHERE id = 763;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  theme t0
  INNER JOIN user_profile_theme ON t0.id = user_profile_theme.theme_id
WHERE
  user_profile_theme.user_profile_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM theme t0 INNER JOIN user_profile_theme ON t0.id = user_profile_theme.theme_id WHERE user_profile_theme.user_profile_id = 149;

SELECT
  t0.id AS id_1,
  t0.favorite AS favorite_2,
  t0.role AS role_3,
  t0.user_id AS user_id_4,
  t0.project_id AS project_id_5
FROM
  user_project t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.favorite AS favorite_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.project_id AS project_id_5 FROM user_project t0 WHERE t0.user_id = 763;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.state AS state_4,
  t0.type AS type_5,
  t0.admin_review AS admin_review_6,
  t0.scientific_interest AS scientific_interest_7,
  t0.application_conditions AS application_conditions_8,
  t0.ethic_box AS ethic_box_9,
  t0.labeled AS labeled_10,
  t0.request_labeled AS request_labeled_11,
  t0.request_publish AS request_publish_12,
  t0.publish_labo AS publish_labo_13,
  t0.publish_public AS publish_public_14,
  t0.publish_open_edition AS publish_open_edition_15,
  t0.is_indexable AS is_indexable_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.filename AS filename_19,
  t0.hash AS hash_20,
  t0.fileurl AS fileurl_21,
  t0.citation_format_id AS citation_format_id_22,
  t0.creator_id AS creator_id_23,
  t0.default_workroom_id AS default_workroom_id_24
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.state AS state_4, t0.type AS type_5, t0.admin_review AS admin_review_6, t0.scientific_interest AS scientific_interest_7, t0.application_conditions AS application_conditions_8, t0.ethic_box AS ethic_box_9, t0.labeled AS labeled_10, t0.request_labeled AS request_labeled_11, t0.request_publish AS request_publish_12, t0.publish_labo AS publish_labo_13, t0.publish_public AS publish_public_14, t0.publish_open_edition AS publish_open_edition_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.filename AS filename_19, t0.hash AS hash_20, t0.fileurl AS fileurl_21, t0.citation_format_id AS citation_format_id_22, t0.creator_id AS creator_id_23, t0.default_workroom_id AS default_workroom_id_24 FROM project t0 WHERE t0.id = 198;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  theme t0
  INNER JOIN project_theme ON t0.id = project_theme.theme_id
WHERE
  project_theme.project_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM theme t0 INNER JOIN project_theme ON t0.id = project_theme.theme_id WHERE project_theme.project_id = 198;