Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

45 Database Queries

8 Different statements

8.86 ms Query time

0 Invalid entities

Queries

Group similar statements


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 COUNT(DISTINCT c0_.id) AS sclr_0 FROM chat_notification c0_ WHERE c0_.user_id = ? AND c0_.created_at < ?
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 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 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_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_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 = ?
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_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 = ?
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 = ?
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 = ?
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_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_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_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 = ?
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_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 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 = ? AND a0_.hash_tag = ? LIMIT 1
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 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 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 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 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 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 = ? AND a0_.hash_tag = ? LIMIT 1
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 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 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 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 = ? AND a0_.hash_tag = ? LIMIT 1
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 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 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 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 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 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 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 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 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

#▲	Time	Info
1	0.30 ms	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 = ? Parameters: [`"1efd70bc-0195-661a-9f5b-5bd4f8d72253"`] View formatted query View runnable query Explain query 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';
2	0.54 ms	SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM chat_notification c0_ WHERE c0_.user_id = ? AND c0_.created_at < ? Parameters: [`"1efd70bc-0195-661a-9f5b-5bd4f8d72253" "2026-08-26 10:53:38"`] View formatted query View runnable query Explain query 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';
3	0.56 ms	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 Parameters: [`"1efd70bc-0195-661a-9f5b-5bd4f8d72253" "2026-08-26 10:53:38"`] View formatted query View runnable query Explain query 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;
4	0.87 ms	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 Parameters: [`"1efd70bc-0195-661a-9f5b-5bd4f8d72253" "2026-08-26 10:53:38" 39832 38935 38905 38661 38660 32949 32819 32624 32423 32416`] View formatted query View runnable query Explain query 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;
5	0.20 ms	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 = ? Parameters: [`40685`] View formatted query View runnable query Explain query 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;
6	0.21 ms	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 = ? Parameters: [`109251`] View formatted query View runnable query Explain query 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;
7	0.21 ms	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 = ? Parameters: [`"f7d16c38-0167-11eb-a31a-0242ac1c0004"`] View formatted query View runnable query Explain query 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 = 'f7d16c38-0167-11eb-a31a-0242ac1c0004';
8	0.21 ms	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 = ? Parameters: [`"14a6dedb-dc10-11ec-ac59-0242ac140003"`] View formatted query View runnable query Explain query 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 = '14a6dedb-dc10-11ec-ac59-0242ac140003';
9	0.20 ms	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 = ? Parameters: [`"1ee1fef6-d0ab-6628-838d-7189814a3160"`] View formatted query View runnable query Explain query 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 = '1ee1fef6-d0ab-6628-838d-7189814a3160';
10	0.17 ms	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 = ? Parameters: [`39278`] View formatted query View runnable query Explain query 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 = 39278;
11	0.16 ms	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 = ? Parameters: [`39217`] View formatted query View runnable query Explain query 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 = 39217;
12	0.15 ms	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 = ? Parameters: [`38803`] View formatted query View runnable query Explain query 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 = 38803;
13	0.16 ms	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 = ? Parameters: [`38791`] View formatted query View runnable query Explain query 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 = 38791;
14	0.15 ms	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 = ? Parameters: [`38801`] View formatted query View runnable query Explain query 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 = 38801;
15	0.15 ms	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 = ? Parameters: [`37785`] View formatted query View runnable query Explain query 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 = 37785;
16	0.13 ms	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 = ? Parameters: [`"1ee4b034-a6b7-6cb2-a50c-c5f5d89fc432"`] View formatted query View runnable query Explain query 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 = '1ee4b034-a6b7-6cb2-a50c-c5f5d89fc432';
17	0.14 ms	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 = ? Parameters: [`37532`] View formatted query View runnable query Explain query 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 = 37532;
18	0.14 ms	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 = ? Parameters: [`"1ee4d720-1ef9-622c-b572-f34aad2709da"`] View formatted query View runnable query Explain query 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 = '1ee4d720-1ef9-622c-b572-f34aad2709da';
19	0.14 ms	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 = ? Parameters: [`37281`] View formatted query View runnable query Explain query 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 = 37281;
20	0.12 ms	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 = ? Parameters: [`37167`] View formatted query View runnable query Explain query 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 = 37167;
21	0.14 ms	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 = ? Parameters: [`37153`] View formatted query View runnable query Explain query 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 = 37153;
22	0.12 ms	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 = ? Parameters: [`"3486763a-89b4-11ec-aa25-0242ac140004"`] View formatted query View runnable query Explain query 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 = '3486763a-89b4-11ec-aa25-0242ac140004';
23	0.18 ms	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 Parameters: [`109251 "Laurine_Deker"`] View formatted query View runnable query Explain query 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;
24	0.15 ms	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 Parameters: [`109251 "Beatrice_Fournier"`] View formatted query View runnable query Explain query 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 = 'Beatrice_Fournier' LIMIT 1;
25	0.14 ms	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 Parameters: [`40685`] View formatted query View runnable query Explain query 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;
26	0.16 ms	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 Parameters: [`109251 "Laurine_Deker"`] View formatted query View runnable query Explain query 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;
27	0.13 ms	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 Parameters: [`39278`] View formatted query View runnable query Explain query 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 = 39278 AND c0_.content IS NOT NULL;
28	0.15 ms	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 Parameters: [`109251 "Laurine_Deker"`] View formatted query View runnable query Explain query 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;
29	0.13 ms	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 Parameters: [`39217`] View formatted query View runnable query Explain query 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 = 39217 AND c0_.content IS NOT NULL;
30	0.20 ms	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 Parameters: [`109251 "Laurine_Deker"`] View formatted query View runnable query Explain query 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;
31	0.16 ms	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 Parameters: [`109251 "Michael_Mestivier"`] View formatted query View runnable query Explain query 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 = 'Michael_Mestivier' LIMIT 1;
32	0.17 ms	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 Parameters: [`38803`] View formatted query View runnable query Explain query 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 = 38803 AND c0_.content IS NOT NULL;
33	0.17 ms	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 Parameters: [`109251 "Laurine_Deker"`] View formatted query View runnable query Explain query 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;
34	0.15 ms	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 Parameters: [`38801`] View formatted query View runnable query Explain query 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 = 38801 AND c0_.content IS NOT NULL;
35	0.19 ms	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 Parameters: [`109251 "Terry_Arroues"`] View formatted query View runnable query Explain query 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 = 'Terry_Arroues' LIMIT 1;
36	0.17 ms	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 Parameters: [`109251 "Laurine_Deker"`] View formatted query View runnable query Explain query 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;
37	0.15 ms	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 Parameters: [`37785`] View formatted query View runnable query Explain query 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 = 37785 AND c0_.content IS NOT NULL;
38	0.17 ms	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 Parameters: [`109251 "Laurine_Deker"`] View formatted query View runnable query Explain query 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;
39	0.15 ms	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 Parameters: [`37532`] View formatted query View runnable query Explain query 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 = 37532 AND c0_.content IS NOT NULL;
40	0.18 ms	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 Parameters: [`109251 "Laurine_Deker"`] View formatted query View runnable query Explain query 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;
41	0.15 ms	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 Parameters: [`37281`] View formatted query View runnable query Explain query 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 = 37281 AND c0_.content IS NOT NULL;
42	0.18 ms	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 Parameters: [`109251 "Laurine_Deker"`] View formatted query View runnable query Explain query 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;
43	0.15 ms	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 Parameters: [`37167`] View formatted query View runnable query Explain query 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 = 37167 AND c0_.content IS NOT NULL;
44	0.17 ms	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 Parameters: [`109251 "Laurine_Deker"`] View formatted query View runnable query Explain query 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;
45	0.15 ms	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 Parameters: [`37153`] View formatted query View runnable query Explain query 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 = 37153 AND c0_.content IS NOT NULL;

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.

Entities Mapping

Class	Mapping errors
Nellapp\Bundle\SDKBundle\Auth\Entity\Token	No errors.
App\Entity\Account\User	No errors.
App\Entity\Channel\Channel	No errors.
App\Entity\Channel\Service	No errors.
App\Entity\Chat\ConversationUser	No errors.
App\Entity\Channel\Group	No errors.
App\Entity\ChannelUserData\ChannelUserData	No errors.
App\Entity\Chat\ChatNotification	No errors.
App\Entity\Chat\Message	No errors.
App\Entity\Chat\FileMessage	No errors.
App\Entity\Chat\Conversation	No errors.
App\Entity\Chat\ServiceConversation	No errors.
App\Entity\Chat\Canal	No errors.
App\Entity\Chat\TemporaryCanal	No errors.
App\Entity\Chat\Resource	No errors.
App\Entity\Chat\MessageUser	No errors.

Symfony Profiler

http://nim.staging.nellapp-01.drosalys.net/core/chat_notifications/1efd70bc-0195-661a-9f5b-5bd4f8d72253?date=2026-08-26%2010%3A53%3A38&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping