POST https://crm.mytek-portage.fr/conversations/presence

Query Metrics

7 Database Queries
7 Different statements
4.75 ms Query time
0 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.00 ms
(20.98%)
1
UPDATE crm_user SET chat_last_seen_at = ? WHERE id = ?
Parameters:
[
  "2026-10-04 10:28:35"
  1
]
0.81 ms
(17.10%)
1
"COMMIT"
Parameters:
[]
0.63 ms
(13.21%)
1
"START TRANSACTION"
Parameters:
[]
0.61 ms
(12.81%)
1
SELECT COUNT(c0_.id) AS sclr_0 FROM conversation c0_ WHERE c0_.assignee_id = ? AND c0_.status = ? AND c0_.last_message_at IS NOT NULL AND (c0_.assignee_read_at IS NULL OR c0_.assignee_read_at < c0_.last_message_at)
Parameters:
[
  1
  "open"
]
0.59 ms
(12.51%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6, t0.status AS status_7, t0.phone AS phone_8, t0.job_title AS job_title_9, t0.agency AS agency_10, t0.hubspot_owner_id AS hubspot_owner_id_11, t0.google_refresh_token AS google_refresh_token_12, t0.google_connected_at AS google_connected_at_13, t0.gmail_synced_at AS gmail_synced_at_14, t0.avatar_color AS avatar_color_15, t0.photo AS photo_16, t0.photo_source AS photo_source_17, t0.preferences AS preferences_18, t0.signature AS signature_19, t0.meeting_url AS meeting_url_20, t0.chat_available AS chat_available_21, t0.chat_last_seen_at AS chat_last_seen_at_22, t0.extension_token AS extension_token_23, t0.extension_token_created_at AS extension_token_created_at_24, t0.extension_token_used_at AS extension_token_used_at_25, t0.last_visited_url AS last_visited_url_26, t0.last_login_at AS last_login_at_27, t0.created_at AS created_at_28 FROM crm_user t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.57 ms
(11.96%)
1
SELECT name, base_role FROM permission_profile WHERE is_default = 1 LIMIT 1
Parameters:
[]
0.54 ms
(11.43%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.shares_visibility AS shares_visibility_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.permission_profile_id AS permission_profile_id_7, t0.fallback_user_id AS fallback_user_id_8 FROM team t0 INNER JOIN crm_user_team ON t0.id = crm_user_team.team_id WHERE crm_user_team.user_id = ?
Parameters:
[
  1
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Team No errors.
App\Entity\PermissionProfile No errors.
App\Entity\Conversation No errors.