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

Query Metrics

3 Database Queries
3 Different statements
0.92 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.38 ms
(41.56%)
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.id = ?
Parameters:
[
  23
]
0.28 ms
(30.69%)
1
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.project_id = ? AND t0.user_id = ?
Parameters:
[
  189
  23
]
0.26 ms
(27.76%)
1
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.