[ 'sql' => [ 1 => 'SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.title AS title_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.last_message_at AS last_message_at_5, c0_.is_active AS is_active_6, c0_.allow_replies AS allow_replies_7, c0_.context_type AS context_type_8, c0_.context_id AS context_id_9, c1_.id AS id_10, c1_.joined_at AS joined_at_11, c1_.last_read_at AS last_read_at_12, c1_.is_archived AS is_archived_13, c1_.is_muted AS is_muted_14, c2_.id AS id_15, c2_.body AS body_16, c2_.created_at AS created_at_17, c2_.updated_at AS updated_at_18, c2_.deleted_at AS deleted_at_19, c2_.message_type AS message_type_20, c2_.is_system AS is_system_21, c2_.importance AS importance_22, u3_.id AS id_23, u3_.username AS username_24, u3_.roles AS roles_25, u3_.password AS password_26, u3_.civility AS civility_27, u3_.first_name AS first_name_28, u3_.email AS email_29, u3_.description AS description_30, u3_.phone AS phone_31, u3_.second_phone AS second_phone_32, u3_.adress AS adress_33, u3_.country AS country_34, u3_.region AS region_35, u3_.city AS city_36, u3_.zip AS zip_37, u3_.type AS type_38, u3_.is_verified AS is_verified_39, u3_.created_at AS created_at_40, u3_.is_blocked AS is_blocked_41, u3_.blocked_at AS blocked_at_42, u3_.unblocked_at AS unblocked_at_43, u3_.block_reason AS block_reason_44, u3_.blocked_hours AS blocked_hours_45, u3_.client_type_locked AS client_type_locked_46, u3_.internal_messenger_sound_enabled AS internal_messenger_sound_enabled_47, u3_.internal_messenger_browser_notifications_enabled AS internal_messenger_browser_notifications_enabled_48, c4_.id AS id_49, c4_.joined_at AS joined_at_50, c4_.last_read_at AS last_read_at_51, c4_.is_archived AS is_archived_52, c4_.is_muted AS is_muted_53, u5_.id AS id_54, u5_.username AS username_55, u5_.roles AS roles_56, u5_.password AS password_57, u5_.civility AS civility_58, u5_.first_name AS first_name_59, u5_.email AS email_60, u5_.description AS description_61, u5_.phone AS phone_62, u5_.second_phone AS second_phone_63, u5_.adress AS adress_64, u5_.country AS country_65, u5_.region AS region_66, u5_.city AS city_67, u5_.zip AS zip_68, u5_.type AS type_69, u5_.is_verified AS is_verified_70, u5_.created_at AS created_at_71, u5_.is_blocked AS is_blocked_72, u5_.blocked_at AS blocked_at_73, u5_.unblocked_at AS unblocked_at_74, u5_.block_reason AS block_reason_75, u5_.blocked_hours AS blocked_hours_76, u5_.client_type_locked AS client_type_locked_77, u5_.internal_messenger_sound_enabled AS internal_messenger_sound_enabled_78, u5_.internal_messenger_browser_notifications_enabled AS internal_messenger_browser_notifications_enabled_79, c0_.created_by_id AS created_by_id_80, c0_.last_message_id AS last_message_id_81, c1_.conversation_id AS conversation_id_82, c1_.user_id AS user_id_83, c1_.last_read_message_id AS last_read_message_id_84, c2_.conversation_id AS conversation_id_85, c2_.sender_id AS sender_id_86, u3_.supplier_id AS supplier_id_87, u3_.promotion_id AS promotion_id_88, u3_.group_user_id AS group_user_id_89, u3_.user_post_id AS user_post_id_90, u3_.client_type_id AS client_type_id_91, c4_.conversation_id AS conversation_id_92, c4_.user_id AS user_id_93, c4_.last_read_message_id AS last_read_message_id_94, u5_.supplier_id AS supplier_id_95, u5_.promotion_id AS promotion_id_96, u5_.group_user_id AS group_user_id_97, u5_.user_post_id AS user_post_id_98, u5_.client_type_id AS client_type_id_99 FROM crm_conversation c0_ INNER JOIN crm_conversation_participant c1_ ON c0_.id = c1_.conversation_id AND (c1_.user_id = ?) LEFT JOIN crm_conversation_message c2_ ON c0_.last_message_id = c2_.id LEFT JOIN `users` u3_ ON c2_.sender_id = u3_.id LEFT JOIN crm_conversation_participant c4_ ON c0_.id = c4_.conversation_id LEFT JOIN `users` u5_ ON c4_.user_id = u5_.id WHERE c0_.is_active = ? AND c1_.is_archived = ? ORDER BY c0_.last_message_at DESC, c0_.updated_at DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'c' => 'App\\Entity\\CrmConversation', 'cp' => 'App\\Entity\\CrmConversationParticipant', 'lm' => 'App\\Entity\\CrmConversationMessage', 'lms' => 'App\\Entity\\User', 'allp' => 'App\\Entity\\CrmConversationParticipant', 'allpu' => 'App\\Entity\\User', ], ], 'relationMap' => [ 2 => [ 'cp' => 'participants', 'lm' => 'lastMessage', 'lms' => 'sender', 'allp' => 'participants', 'allpu' => 'user', ], ], 'parentAliasMap' => [ 2 => [ 'cp' => 'c', 'lm' => 'c', 'lms' => 'lm', 'allp' => 'c', 'allpu' => 'allp', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'type_1' => 'type', 'title_2' => 'title', 'created_at_3' => 'createdAt', 'updated_at_4' => 'updatedAt', 'last_message_at_5' => 'lastMessageAt', 'is_active_6' => 'isActive', 'allow_replies_7' => 'allowReplies', 'context_type_8' => 'contextType', 'context_id_9' => 'contextId', 'id_10' => 'id', 'joined_at_11' => 'joinedAt', 'last_read_at_12' => 'lastReadAt', 'is_archived_13' => 'isArchived', 'is_muted_14' => 'isMuted', 'id_15' => 'id', 'body_16' => 'body', 'created_at_17' => 'createdAt', 'updated_at_18' => 'updatedAt', 'deleted_at_19' => 'deletedAt', 'message_type_20' => 'messageType', 'is_system_21' => 'isSystem', 'importance_22' => 'importance', 'id_23' => 'id', 'username_24' => 'username', 'roles_25' => 'roles', 'password_26' => 'password', 'civility_27' => 'civility', 'first_name_28' => 'firstName', 'email_29' => 'email', 'description_30' => 'description', 'phone_31' => 'phone', 'second_phone_32' => 'second_phone', 'adress_33' => 'adress', 'country_34' => 'country', 'region_35' => 'region', 'city_36' => 'city', 'zip_37' => 'zip', 'type_38' => 'type', 'is_verified_39' => 'isVerified', 'created_at_40' => 'createdAt', 'is_blocked_41' => 'isBlocked', 'blocked_at_42' => 'blockedAt', 'unblocked_at_43' => 'unblockedAt', 'block_reason_44' => 'blockReason', 'blocked_hours_45' => 'blockedHours', 'client_type_locked_46' => 'clientTypeLocked', 'internal_messenger_sound_enabled_47' => 'internalMessengerSoundEnabled', 'internal_messenger_browser_notifications_enabled_48' => 'internalMessengerBrowserNotificationsEnabled', 'id_49' => 'id', 'joined_at_50' => 'joinedAt', 'last_read_at_51' => 'lastReadAt', 'is_archived_52' => 'isArchived', 'is_muted_53' => 'isMuted', 'id_54' => 'id', 'username_55' => 'username', 'roles_56' => 'roles', 'password_57' => 'password', 'civility_58' => 'civility', 'first_name_59' => 'firstName', 'email_60' => 'email', 'description_61' => 'description', 'phone_62' => 'phone', 'second_phone_63' => 'second_phone', 'adress_64' => 'adress', 'country_65' => 'country', 'region_66' => 'region', 'city_67' => 'city', 'zip_68' => 'zip', 'type_69' => 'type', 'is_verified_70' => 'isVerified', 'created_at_71' => 'createdAt', 'is_blocked_72' => 'isBlocked', 'blocked_at_73' => 'blockedAt', 'unblocked_at_74' => 'unblockedAt', 'block_reason_75' => 'blockReason', 'blocked_hours_76' => 'blockedHours', 'client_type_locked_77' => 'clientTypeLocked', 'internal_messenger_sound_enabled_78' => 'internalMessengerSoundEnabled', 'internal_messenger_browser_notifications_enabled_79' => 'internalMessengerBrowserNotificationsEnabled', ], ], 'typeMappings' => [ 2 => [ 'created_by_id_80' => 'integer', 'last_message_id_81' => 'integer', 'conversation_id_82' => 'integer', 'user_id_83' => 'integer', 'last_read_message_id_84' => 'integer', 'conversation_id_85' => 'integer', 'sender_id_86' => 'integer', 'supplier_id_87' => 'integer', 'promotion_id_88' => 'integer', 'group_user_id_89' => 'integer', 'user_post_id_90' => 'integer', 'client_type_id_91' => 'integer', 'conversation_id_92' => 'integer', 'user_id_93' => 'integer', 'last_read_message_id_94' => 'integer', 'supplier_id_95' => 'integer', 'promotion_id_96' => 'integer', 'group_user_id_97' => 'integer', 'user_post_id_98' => 'integer', 'client_type_id_99' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'c' => null, ], ], 'metaMappings' => [ 2 => [ 'created_by_id_80' => 'created_by_id', 'last_message_id_81' => 'last_message_id', 'conversation_id_82' => 'conversation_id', 'user_id_83' => 'user_id', 'last_read_message_id_84' => 'last_read_message_id', 'conversation_id_85' => 'conversation_id', 'sender_id_86' => 'sender_id', 'supplier_id_87' => 'supplier_id', 'promotion_id_88' => 'promotion_id', 'group_user_id_89' => 'group_user_id', 'user_post_id_90' => 'user_post_id', 'client_type_id_91' => 'client_type_id', 'conversation_id_92' => 'conversation_id', 'user_id_93' => 'user_id', 'last_read_message_id_94' => 'last_read_message_id', 'supplier_id_95' => 'supplier_id', 'promotion_id_96' => 'promotion_id', 'group_user_id_97' => 'group_user_id', 'user_post_id_98' => 'user_post_id', 'client_type_id_99' => 'client_type_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'c', 'type_1' => 'c', 'title_2' => 'c', 'created_at_3' => 'c', 'updated_at_4' => 'c', 'last_message_at_5' => 'c', 'is_active_6' => 'c', 'allow_replies_7' => 'c', 'context_type_8' => 'c', 'context_id_9' => 'c', 'id_10' => 'cp', 'joined_at_11' => 'cp', 'last_read_at_12' => 'cp', 'is_archived_13' => 'cp', 'is_muted_14' => 'cp', 'id_15' => 'lm', 'body_16' => 'lm', 'created_at_17' => 'lm', 'updated_at_18' => 'lm', 'deleted_at_19' => 'lm', 'message_type_20' => 'lm', 'is_system_21' => 'lm', 'importance_22' => 'lm', 'id_23' => 'lms', 'username_24' => 'lms', 'roles_25' => 'lms', 'password_26' => 'lms', 'civility_27' => 'lms', 'first_name_28' => 'lms', 'email_29' => 'lms', 'description_30' => 'lms', 'phone_31' => 'lms', 'second_phone_32' => 'lms', 'adress_33' => 'lms', 'country_34' => 'lms', 'region_35' => 'lms', 'city_36' => 'lms', 'zip_37' => 'lms', 'type_38' => 'lms', 'is_verified_39' => 'lms', 'created_at_40' => 'lms', 'is_blocked_41' => 'lms', 'blocked_at_42' => 'lms', 'unblocked_at_43' => 'lms', 'block_reason_44' => 'lms', 'blocked_hours_45' => 'lms', 'client_type_locked_46' => 'lms', 'internal_messenger_sound_enabled_47' => 'lms', 'internal_messenger_browser_notifications_enabled_48' => 'lms', 'id_49' => 'allp', 'joined_at_50' => 'allp', 'last_read_at_51' => 'allp', 'is_archived_52' => 'allp', 'is_muted_53' => 'allp', 'id_54' => 'allpu', 'username_55' => 'allpu', 'roles_56' => 'allpu', 'password_57' => 'allpu', 'civility_58' => 'allpu', 'first_name_59' => 'allpu', 'email_60' => 'allpu', 'description_61' => 'allpu', 'phone_62' => 'allpu', 'second_phone_63' => 'allpu', 'adress_64' => 'allpu', 'country_65' => 'allpu', 'region_66' => 'allpu', 'city_67' => 'allpu', 'zip_68' => 'allpu', 'type_69' => 'allpu', 'is_verified_70' => 'allpu', 'created_at_71' => 'allpu', 'is_blocked_72' => 'allpu', 'blocked_at_73' => 'allpu', 'unblocked_at_74' => 'allpu', 'block_reason_75' => 'allpu', 'blocked_hours_76' => 'allpu', 'client_type_locked_77' => 'allpu', 'internal_messenger_sound_enabled_78' => 'allpu', 'internal_messenger_browser_notifications_enabled_79' => 'allpu', 'created_by_id_80' => 'c', 'last_message_id_81' => 'c', 'conversation_id_82' => 'cp', 'user_id_83' => 'cp', 'last_read_message_id_84' => 'cp', 'conversation_id_85' => 'lm', 'sender_id_86' => 'lm', 'supplier_id_87' => 'lms', 'promotion_id_88' => 'lms', 'group_user_id_89' => 'lms', 'user_post_id_90' => 'lms', 'client_type_id_91' => 'lms', 'conversation_id_92' => 'allp', 'user_id_93' => 'allp', 'last_read_message_id_94' => 'allp', 'supplier_id_95' => 'allpu', 'promotion_id_96' => 'allpu', 'group_user_id_97' => 'allpu', 'user_post_id_98' => 'allpu', 'client_type_id_99' => 'allpu', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\CrmConversation', 'type_1' => 'App\\Entity\\CrmConversation', 'title_2' => 'App\\Entity\\CrmConversation', 'created_at_3' => 'App\\Entity\\CrmConversation', 'updated_at_4' => 'App\\Entity\\CrmConversation', 'last_message_at_5' => 'App\\Entity\\CrmConversation', 'is_active_6' => 'App\\Entity\\CrmConversation', 'allow_replies_7' => 'App\\Entity\\CrmConversation', 'context_type_8' => 'App\\Entity\\CrmConversation', 'context_id_9' => 'App\\Entity\\CrmConversation', 'id_10' => 'App\\Entity\\CrmConversationParticipant', 'joined_at_11' => 'App\\Entity\\CrmConversationParticipant', 'last_read_at_12' => 'App\\Entity\\CrmConversationParticipant', 'is_archived_13' => 'App\\Entity\\CrmConversationParticipant', 'is_muted_14' => 'App\\Entity\\CrmConversationParticipant', 'id_15' => 'App\\Entity\\CrmConversationMessage', 'body_16' => 'App\\Entity\\CrmConversationMessage', 'created_at_17' => 'App\\Entity\\CrmConversationMessage', 'updated_at_18' => 'App\\Entity\\CrmConversationMessage', 'deleted_at_19' => 'App\\Entity\\CrmConversationMessage', 'message_type_20' => 'App\\Entity\\CrmConversationMessage', 'is_system_21' => 'App\\Entity\\CrmConversationMessage', 'importance_22' => 'App\\Entity\\CrmConversationMessage', 'id_23' => 'App\\Entity\\User', 'username_24' => 'App\\Entity\\User', 'roles_25' => 'App\\Entity\\User', 'password_26' => 'App\\Entity\\User', 'civility_27' => 'App\\Entity\\User', 'first_name_28' => 'App\\Entity\\User', 'email_29' => 'App\\Entity\\User', 'description_30' => 'App\\Entity\\User', 'phone_31' => 'App\\Entity\\User', 'second_phone_32' => 'App\\Entity\\User', 'adress_33' => 'App\\Entity\\User', 'country_34' => 'App\\Entity\\User', 'region_35' => 'App\\Entity\\User', 'city_36' => 'App\\Entity\\User', 'zip_37' => 'App\\Entity\\User', 'type_38' => 'App\\Entity\\User', 'is_verified_39' => 'App\\Entity\\User', 'created_at_40' => 'App\\Entity\\User', 'is_blocked_41' => 'App\\Entity\\User', 'blocked_at_42' => 'App\\Entity\\User', 'unblocked_at_43' => 'App\\Entity\\User', 'block_reason_44' => 'App\\Entity\\User', 'blocked_hours_45' => 'App\\Entity\\User', 'client_type_locked_46' => 'App\\Entity\\User', 'internal_messenger_sound_enabled_47' => 'App\\Entity\\User', 'internal_messenger_browser_notifications_enabled_48' => 'App\\Entity\\User', 'id_49' => 'App\\Entity\\CrmConversationParticipant', 'joined_at_50' => 'App\\Entity\\CrmConversationParticipant', 'last_read_at_51' => 'App\\Entity\\CrmConversationParticipant', 'is_archived_52' => 'App\\Entity\\CrmConversationParticipant', 'is_muted_53' => 'App\\Entity\\CrmConversationParticipant', 'id_54' => 'App\\Entity\\User', 'username_55' => 'App\\Entity\\User', 'roles_56' => 'App\\Entity\\User', 'password_57' => 'App\\Entity\\User', 'civility_58' => 'App\\Entity\\User', 'first_name_59' => 'App\\Entity\\User', 'email_60' => 'App\\Entity\\User', 'description_61' => 'App\\Entity\\User', 'phone_62' => 'App\\Entity\\User', 'second_phone_63' => 'App\\Entity\\User', 'adress_64' => 'App\\Entity\\User', 'country_65' => 'App\\Entity\\User', 'region_66' => 'App\\Entity\\User', 'city_67' => 'App\\Entity\\User', 'zip_68' => 'App\\Entity\\User', 'type_69' => 'App\\Entity\\User', 'is_verified_70' => 'App\\Entity\\User', 'created_at_71' => 'App\\Entity\\User', 'is_blocked_72' => 'App\\Entity\\User', 'blocked_at_73' => 'App\\Entity\\User', 'unblocked_at_74' => 'App\\Entity\\User', 'block_reason_75' => 'App\\Entity\\User', 'blocked_hours_76' => 'App\\Entity\\User', 'client_type_locked_77' => 'App\\Entity\\User', 'internal_messenger_sound_enabled_78' => 'App\\Entity\\User', 'internal_messenger_browser_notifications_enabled_79' => 'App\\Entity\\User', ], ], ], ], $o[0], [ [ "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlExecutor' => null, "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlFinalizer' => $o[1], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'resultSetMapping' => $o[2], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'parameterMappings' => [ 'user' => [ 0, ], 'active' => [ 1, ], 'archived' => [ 2, ], ], ], ] ); }];