https://b.whileresume.app/api/conversations/total-unread

Query Metrics

3Database Queries
3Different statements
2.43 msQuery time
0Invalid entities

Queries

Group similar statements

#TimeInfo
10.95 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.url AS url_6, t0.visibility AS visibility_7, t0.type AS type_8 FROM seo_redirection t0 WHERE t0.slug = ? AND t0.visibility = ? LIMIT 1
Parameters:
[
  "api/conversations/total-unread"
  1
]
20.78 ms
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.last_login AS last_login_4, t0.email AS email_5, t0.name AS name_6, t0.lastname AS lastname_7, t0.roles AS roles_8, t0.password AS password_9, t0.username AS username_10, t0.first AS first_11, t0.enabled AS enabled_12, t0.verification AS verification_13, t0.premium AS premium_14, t0.password_forgotten AS password_forgotten_15, t0.password_forgotten_last_date AS password_forgotten_last_date_16, t0.partenariat AS partenariat_17, t0.description AS description_18, t0.notifications_messages AS notifications_messages_19, t0.notifications_suivis AS notifications_suivis_20, t0.user_commission_unit AS user_commission_unit_21, t0.user_commission_pourcent AS user_commission_pourcent_22, t0.type_account AS type_account_23, t0.subscription_customer_stripe AS subscription_customer_stripe_24, t0.verification_token AS verification_token_25, t0.token_expiration AS token_expiration_26, t0.language AS language_27, t0.motif_verification AS motif_verification_28, t0.image_name AS image_name_29, t0.image_original_name AS image_original_name_30, t0.image_mime_type AS image_mime_type_31, t0.image_size AS image_size_32, t0.image_dimensions AS image_dimensions_33, t0.current_agency_id AS current_agency_id_34, t0.candidate_id AS candidate_id_35 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "contact@mirtillo.fr"
]
30.70 ms
SELECT COUNT(m0_.id) AS sclr_0 FROM messenger_messages m0_ INNER JOIN messenger_groups m1_ ON m0_.group_id = m1_.id WHERE ((m1_.user_one_id = ? OR m1_.user_two_id = ?)) AND m0_.user_id <> ? AND m0_.read_at IS NULL
Parameters:
[
  1
  1
  1
]

Database Connections

NameService
defaultdoctrine.dbal.default_connection

Entity Managers

NameService
defaultdoctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.