Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.email AS email_1,
  a0_.roles AS roles_2,
  a0_.first_name AS first_name_3,
  a0_.last_name AS last_name_4,
  a0_.description AS description_5,
  a0_.avatar AS avatar_6,
  a0_.avatar_path AS avatar_path_7,
  a0_.signing_limit_date AS signing_limit_date_8,
  a0_.has_seen_intro AS has_seen_intro_9,
  a0_.hash_tag AS hash_tag_10,
  a0_.token_token AS token_token_11,
  a0_.token_expire_at AS token_expire_at_12,
  a0_.token_refresh_token AS token_refresh_token_13,
  a0_.last_selected_channel_id AS last_selected_channel_id_14
FROM
  account_users a0_
  INNER JOIN chat_conversation_users c1_ ON a0_.id = c1_.user_id
  INNER JOIN chat_conversations c2_ ON c1_.conversation_id = c2_.id
  LEFT JOIN chat_service_conversations c3_ ON c2_.id = c3_.id
  LEFT JOIN chat_canals c4_ ON c2_.id = c4_.id
  LEFT JOIN chat_temporary_canals c5_ ON c2_.id = c5_.id
WHERE
  c2_.id = ?
  AND a0_.hash_tag = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.roles AS roles_2, a0_.first_name AS first_name_3, a0_.last_name AS last_name_4, a0_.description AS description_5, a0_.avatar AS avatar_6, a0_.avatar_path AS avatar_path_7, a0_.signing_limit_date AS signing_limit_date_8, a0_.has_seen_intro AS has_seen_intro_9, a0_.hash_tag AS hash_tag_10, a0_.token_token AS token_token_11, a0_.token_expire_at AS token_expire_at_12, a0_.token_refresh_token AS token_refresh_token_13, a0_.last_selected_channel_id AS last_selected_channel_id_14 FROM account_users a0_ INNER JOIN chat_conversation_users c1_ ON a0_.id = c1_.user_id INNER JOIN chat_conversations c2_ ON c1_.conversation_id = c2_.id LEFT JOIN chat_service_conversations c3_ ON c2_.id = c3_.id LEFT JOIN chat_canals c4_ ON c2_.id = c4_.id LEFT JOIN chat_temporary_canals c5_ ON c2_.id = c5_.id WHERE c2_.id = 109251 AND a0_.hash_tag = 'Laurine_Deker' LIMIT 1;

SELECT
  t0.id AS id_2,
  t0.content AS content_3,
  t0.tags AS tags_4,
  t0.message_type AS message_type_5,
  t0.pending_post_id AS pending_post_id_6,
  t0.pinned AS pinned_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.conversation_id AS conversation_id_10,
  t0.message_parent_id AS message_parent_id_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13,
  t0.dtype,
  t1.file_message_type AS file_message_type_14
FROM
  chat_messages t0
  LEFT JOIN chat_file_messages t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.content AS content_3, t0.tags AS tags_4, t0.message_type AS message_type_5, t0.pending_post_id AS pending_post_id_6, t0.pinned AS pinned_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.conversation_id AS conversation_id_10, t0.message_parent_id AS message_parent_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.dtype, t1.file_message_type AS file_message_type_14 FROM chat_messages t0 LEFT JOIN chat_file_messages t1 ON t0.id = t1.id WHERE t0.id = 40685;

SELECT
  c0_.id AS id_0,
  c0_.content AS content_1,
  c0_.seen_at AS seen_at_2,
  c0_.message_id AS message_id_3,
  c0_.user_id AS user_id_4
FROM
  chat_message_users c0_
WHERE
  c0_.message_id = ?
  AND c0_.content IS NOT NULL

SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.seen_at AS seen_at_2, c0_.message_id AS message_id_3, c0_.user_id AS user_id_4 FROM chat_message_users c0_ WHERE c0_.message_id = 40685 AND c0_.content IS NOT NULL;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.description AS description_6,
  t0.avatar AS avatar_7,
  t0.avatar_path AS avatar_path_8,
  t0.signing_limit_date AS signing_limit_date_9,
  t0.has_seen_intro AS has_seen_intro_10,
  t0.hash_tag AS hash_tag_11,
  t0.token_token AS token_token_12,
  t0.token_expire_at AS token_expire_at_13,
  t0.token_refresh_token AS token_refresh_token_14,
  t0.last_selected_channel_id AS last_selected_channel_id_15
FROM
  account_users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.description AS description_6, t0.avatar AS avatar_7, t0.avatar_path AS avatar_path_8, t0.signing_limit_date AS signing_limit_date_9, t0.has_seen_intro AS has_seen_intro_10, t0.hash_tag AS hash_tag_11, t0.token_token AS token_token_12, t0.token_expire_at AS token_expire_at_13, t0.token_refresh_token AS token_refresh_token_14, t0.last_selected_channel_id AS last_selected_channel_id_15 FROM account_users t0 WHERE t0.id = '1efd70bc-0195-661a-9f5b-5bd4f8d72253';

SELECT
  c0_.id AS id_0,
  c0_.type AS type_1,
  c0_.created_at AS created_at_2,
  c0_.link AS link_3,
  c0_.content AS content_4,
  c0_.has_been_seen AS has_been_seen_5,
  c0_.updated_at AS updated_at_6,
  c0_.user_id AS user_id_7,
  c0_.message_id AS message_id_8
FROM
  chat_notification c0_
WHERE
  c0_.user_id = ?
  AND c0_.created_at < ?
  AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  c0_.has_been_seen ASC,
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.created_at AS created_at_2, c0_.link AS link_3, c0_.content AS content_4, c0_.has_been_seen AS has_been_seen_5, c0_.updated_at AS updated_at_6, c0_.user_id AS user_id_7, c0_.message_id AS message_id_8 FROM chat_notification c0_ WHERE c0_.user_id = '1efd70bc-0195-661a-9f5b-5bd4f8d72253' AND c0_.created_at < '2026-08-26 10:53:38' AND c0_.id IN (39832, 38935, 38905, 38661, 38660, 32949, 32819, 32624, 32423, 32416) ORDER BY c0_.has_been_seen ASC, c0_.created_at DESC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.has_been_seen AS has_been_seen_1,
  c0_.created_at AS created_at_2
FROM
  chat_notification c0_
WHERE
  c0_.user_id = ?
  AND c0_.created_at < ?
ORDER BY
  c0_.has_been_seen ASC,
  c0_.created_at DESC
LIMIT
  10

SELECT DISTINCT c0_.id AS id_0, c0_.has_been_seen AS has_been_seen_1, c0_.created_at AS created_at_2 FROM chat_notification c0_ WHERE c0_.user_id = '1efd70bc-0195-661a-9f5b-5bd4f8d72253' AND c0_.created_at < '2026-08-26 10:53:38' ORDER BY c0_.has_been_seen ASC, c0_.created_at DESC LIMIT 10;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  chat_notification c0_
WHERE
  c0_.user_id = ?
  AND c0_.created_at < ?

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM chat_notification c0_ WHERE c0_.user_id = '1efd70bc-0195-661a-9f5b-5bd4f8d72253' AND c0_.created_at < '2026-08-26 10:53:38';

SELECT
  t0.id AS id_4,
  t0.type AS type_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.channel_id AS channel_id_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t0.dtype,
  t1.closed AS closed_11,
  t1.service_id AS service_id_12,
  t1.last_message_id AS last_message_id_13,
  t1.main_service_user_id AS main_service_user_id_14,
  t2.label AS label_15,
  t2.description AS description_16,
  t2.open_to AS open_to_17,
  t2.auto_creation AS auto_creation_18,
  t3.event_id AS event_id_19
FROM
  chat_conversations t0
  LEFT JOIN chat_service_conversations t1 ON t0.id = t1.id
  LEFT JOIN chat_canals t2 ON t0.id = t2.id
  LEFT JOIN chat_temporary_canals t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.channel_id AS channel_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.dtype, t1.closed AS closed_11, t1.service_id AS service_id_12, t1.last_message_id AS last_message_id_13, t1.main_service_user_id AS main_service_user_id_14, t2.label AS label_15, t2.description AS description_16, t2.open_to AS open_to_17, t2.auto_creation AS auto_creation_18, t3.event_id AS event_id_19 FROM chat_conversations t0 LEFT JOIN chat_service_conversations t1 ON t0.id = t1.id LEFT JOIN chat_canals t2 ON t0.id = t2.id LEFT JOIN chat_temporary_canals t3 ON t0.id = t3.id WHERE t0.id = 109251;