https://www.labomega.fr/workroom/6a156cae10610

Query Metrics

6 Database Queries
4 Different statements
1.17 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.52 ms
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.civility AS civility_4, u0_.first_name AS first_name_5, u0_.last_name AS last_name_6, u0_.email AS email_7, u0_.uuid AS uuid_8, u0_.last_login AS last_login_9, u0_.is_active AS is_active_10, u0_.admin_review AS admin_review_11, u0_.is_disabled AS is_disabled_12, u0_.zotero_user_id AS zotero_user_id_13, u0_.zotero_api_key AS zotero_api_key_14, u0_.semantic_scholar_api_key AS semantic_scholar_api_key_15, u0_.two_factor_code AS two_factor_code_16, u0_.two_factor_expires_at AS two_factor_expires_at_17, u0_.is_two_factor_enabled AS is_two_factor_enabled_18, u0_.created_at AS created_at_19, u0_.updated_at AS updated_at_20, u0_.university_id AS university_id_21, u0_.statut_id AS statut_id_22, u0_.organization_id AS organization_id_23 FROM user u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%ROLE_ADMIN%"
]
2 0.15 ms
SELECT t0.id AS id_1, t0.biography AS biography_2, t0.picture AS picture_3, t0.date_of_birth AS date_of_birth_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.internal_biography AS internal_biography_9, t0.is_public AS is_public_10, t0.phone_number AS phone_number_11, t0.user_id AS user_id_12 FROM user_profile t0 WHERE t0.user_id = ?
Parameters:
[
  23
]
3 0.11 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.expiration_date AS expiration_date_3, t0.user_id AS user_id_4 FROM reset_password_token t0 WHERE t0.user_id = ?
Parameters:
[
  23
]
4 0.12 ms
SELECT t0.id AS id_1, t0.biography AS biography_2, t0.picture AS picture_3, t0.date_of_birth AS date_of_birth_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.internal_biography AS internal_biography_9, t0.is_public AS is_public_10, t0.phone_number AS phone_number_11, t0.user_id AS user_id_12 FROM user_profile t0 WHERE t0.user_id = ?
Parameters:
[
  549
]
5 0.11 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.expiration_date AS expiration_date_3, t0.user_id AS user_id_4 FROM reset_password_token t0 WHERE t0.user_id = ?
Parameters:
[
  549
]
6 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.uuid AS uuid_3, t0.state AS state_4, t0.position AS position_5, t6.id AS id_7, t6.message AS message_8, t6.counter AS counter_9, t6.created_at AS created_at_10, t6.updated_at AS updated_at_11, t6.workroom_id AS workroom_id_12, t0.project_id AS project_id_13, t14.id AS id_15, t14.uuid AS uuid_16, t14.created_at AS created_at_17, t14.updated_at AS updated_at_18, t14.state AS state_19, t14.workroom_id AS workroom_id_20 FROM workroom t0 LEFT JOIN chat t6 ON t6.workroom_id = t0.id LEFT JOIN workroom_arena t14 ON t14.workroom_id = t0.id WHERE t0.uuid = ? LIMIT 1
Parameters:
[
  "6a156cae10610"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.