Slow queries in SuSo

We are experiencing slow performance when SuSo executes some queries. Can you provide us any suggestion about how to improve SuSo performance (maybe by creating some index in the database)
Here some queries that are taking long time to be executed are:

SELECT
(COUNT(*)) AS col_0_0_
FROM
Assignments assignment0_,
users.users readonlyus2_,
QuestionnaireBrowseItems questionna3_
WHERE
assignment0_.ResponsibleId=readonlyus2_.“Id”
AND assignment0_.Questionnaire=questionna3_.Id
AND assignment0_.Archived=$1
AND (EXISTS (
SELECT
identifyin1_.QuestionId,
identifyin1_.RosterVector,
identifyin1_.Answer,
identifyin1_.AnswerAsString
FROM
AssignmentsIdentifyingAnswers identifyin1_
WHERE
assignment0_.Id=identifyin1_.AssignmentId
AND (LOWER(identifyin1_.AnswerAsString) LIKE ($3||$2||$4)))
OR LOWER(readonlyus2_.“UserName”) LIKE ($5||$2||$6)
OR LOWER(questionna3_.Title) LIKE ($7||$2||$8))


SELECT
assignment0_.Id AS col_0_0_
FROM
Assignments assignment0_,
users.users readonlyus2_,
QuestionnaireBrowseItems questionna3_
WHERE
assignment0_.ResponsibleId=readonlyus2_.“Id”
AND assignment0_.Questionnaire=questionna3_.Id
AND assignment0_.Archived=$1
AND (EXISTS (
SELECT
identifyin1_.QuestionId,
identifyin1_.RosterVector,
identifyin1_.Answer,
identifyin1_.AnswerAsString
FROM
AssignmentsIdentifyingAnswers identifyin1_
WHERE
assignment0_.Id=identifyin1_.AssignmentId
AND (LOWER(identifyin1_.AnswerAsString) LIKE ($5||$2||$6)))
OR LOWER(readonlyus2_.“UserName”) LIKE ($7||$2||$8)
OR LOWER(questionna3_.Title) LIKE ($9||$2||$10))
ORDER BY
assignment0_.UpdatedAtUtc DESC
LIMIT
$3
OFFSET
$4


SELECT
hquser0_.“Id” AS column1_32_,
hquser0_.“AccessFailedCount” AS column4_32_,
hquser0_.“Email” AS column5_32_,
hquser0_.“UserProfileId” AS column3_32_,
hquser0_.“FullName” AS column6_32_,
hquser0_.“IsArchived” AS column7_32_,
hquser0_.“IsLockedBySupervisor” AS column8_32_,
hquser0_.“IsLockedByHeadquaters” AS column9_32_,
hquser0_.“CreationDate” AS column10_32_,
hquser0_.“PasswordHashSha1” AS column11_32_,
hquser0_.“LastLoginDate” AS column12_32_,
hquser0_.“LockoutEndDateUtc” AS column13_32_,
hquser0_.password_change_required AS password14_32_,
hquser0_.“UserName” AS column2_32_,
hquser0_.“EmailConfirmed” AS column15_32_,
hquser0_.“PasswordHash” AS column16_32_,
hquser0_.“SecurityStamp” AS column17_32_,
hquser0_.“PhoneNumber” AS column18_32_,
hquser0_.“PhoneNumberConfirmed” AS column19_32_,
hquser0_.“TwoFactorEnabled” AS column20_32_,
hquser0_.“LockoutEnabled” AS column21_32_
FROM
users.users hquser0_
WHERE
UPPER(hquser0_.“UserName”)=$1

Thank you for your feedback. We’ll take a look at this issue.