Queries

SELECT SUM("total") AS "_sum$total", SUM("restNotPaid") AS "_sum$restNotPaid" FROM (SELECT "public"."Invoice"."total", "public"."Invoice"."restNotPaid" FROM "public"."Invoice" LEFT JOIN "public"."Order" AS "j0" ON ("j0"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."Session" AS "j1" ON ("j1"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("public"."Invoice"."id") WHERE (("j0"."patientProfileId" = $1 AND ("j0"."id" IS NOT NULL)) OR ("j1"."patientProfileId" = $2 AND "j1"."status" <> CAST($3::text AS "public"."SessionStatus") AND ("j1"."date" IS NULL OR "j1"."date" <= $4) AND ("j1"."id" IS NOT NULL)) OR ("j2"."patientProfileId" = $5 AND "j2"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND "j2"."startDate" <= $7 AND ("j2"."id" IS NOT NULL))) OFFSET $8) AS "sub"

SELECT SUM("restNotPaid") AS "_sum$restNotPaid" FROM (SELECT "public"."Invoice"."restNotPaid" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("public"."Invoice"."id") WHERE (("j0"."patientProfileId" = $1 AND "j0"."status" <> CAST($2::text AS "public"."SessionStatus") AND "j0"."date" > $3 AND ("j0"."id" IS NOT NULL)) OR ("j1"."patientProfileId" = $4 AND "j1"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND "j1"."startDate" > $6 AND ("j1"."id" IS NOT NULL))) OFFSET $7 /* traceparent='00-25df44523a40d65692b5acffb6122b1d-d197363a2cec165a-01' */) AS "sub" /* traceparent='00-25df44523a40d65692b5acffb6122b1d-d197363a2cec165a-01' */

SELECT "public"."VariablePropertyValue"."id", "public"."VariablePropertyValue"."value", "public"."VariablePropertyValue"."propertyId", "public"."VariablePropertyValue"."createdAt", "public"."VariablePropertyValue"."updatedAt", "public"."VariablePropertyValue"."patientProfileId" FROM "public"."VariablePropertyValue" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."VariablePropertyValue"."patientProfileId") WHERE ("public"."VariablePropertyValue"."propertyId" = $1 AND "public"."VariablePropertyValue"."patientProfileId" = $2 AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL))) ORDER BY "public"."VariablePropertyValue"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-7fafcd063fa02720819c518397e33453-98213181e81fa5fb-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."VariablePropertyValue"."id" FROM "public"."VariablePropertyValue" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."VariablePropertyValue"."patientProfileId") WHERE ("public"."VariablePropertyValue"."propertyId" = $1 AND "public"."VariablePropertyValue"."patientProfileId" = $2 AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL))) OFFSET $4 /* traceparent='00-7fafcd063fa02720819c518397e33453-bb5f45cffdf03ab2-01' */) AS "sub" /* traceparent='00-7fafcd063fa02720819c518397e33453-bb5f45cffdf03ab2-01' */

SELECT "public"."PrescriptionUnit"."id", "public"."PrescriptionUnit"."isTemplate", "public"."PrescriptionUnit"."medicineId", "public"."PrescriptionUnit"."repetitionId", "public"."PrescriptionUnit"."periodId", "public"."PrescriptionUnit"."noteId", "public"."PrescriptionUnit"."order", "public"."PrescriptionUnit"."clinicDomain", "public"."PrescriptionUnit"."createdAt", "public"."PrescriptionUnit"."updatedAt" FROM "public"."PrescriptionUnit" LEFT JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("public"."PrescriptionUnit"."medicineId") WHERE ("public"."PrescriptionUnit"."isTemplate" = $1 AND ("j0"."text" ILIKE $2 AND ("j0"."id" IS NOT NULL)) AND "public"."PrescriptionUnit"."clinicDomain" = $3) ORDER BY "public"."PrescriptionUnit"."isTemplate" DESC LIMIT $4 OFFSET $5 /* traceparent='00-da735cdab13464917af4d823721c5973-8302b70b35eb67ba-01' */

SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."referredById", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE (("public"."PatientProfile"."name" ILIKE $1 OR "public"."PatientProfile"."phone" ILIKE $2) AND "public"."PatientProfile"."clinicDomain" = $3) ORDER BY "public"."PatientProfile"."isActive" DESC, "public"."PatientProfile"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-63ecac01b7d31e7c728ae14ddddcbc31-48fb33d7e70dbbb5-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."TreasuryTransaction"."amount" FROM "public"."TreasuryTransaction" WHERE "public"."TreasuryTransaction"."treasuryId" = $1 OFFSET $2 /* traceparent='00-a2277d6805040827ea492e9a254d2d94-9e773afe3823604e-01' */) AS "sub" /* traceparent='00-a2277d6805040827ea492e9a254d2d94-9e773afe3823604e-01' */

SELECT "public"."Examination"."id", "public"."Examination"."name", "public"."Examination"."isActive", "public"."Examination"."price", "public"."Examination"."specialties"::text[], "public"."Examination"."defaultTime", "public"."Examination"."isDefault", "public"."Examination"."isMultiple", "public"."Examination"."isOperation", "public"."Examination"."clinicDomain", "public"."Examination"."order", "public"."Examination"."createdAt", "public"."Examination"."updatedAt", "public"."Examination"."doctorPercentage", "public"."Examination"."doctorFixedBonus", "public"."Examination"."managerPercentage", "public"."Examination"."managerFixedBonus", "public"."Examination"."category", "public"."Examination"."generalTags", "public"."Examination"."image", "public"."Examination"."color", "public"."Examination"."taxApplicable", "public"."Examination"."visitModes"::text[] FROM "public"."Examination" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ("j0"."from" >= $1 AND "j0"."from" <= $2 AND ("public"."Examination"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND (EXISTS(SELECT "t1"."B" FROM "public"."_BranchToExamination" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ("j1"."id" = $3 AND ("public"."Examination"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) OR NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToExamination" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ($8=$9 AND ("public"."Examination"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL))) AND "public"."Examination"."clinicDomain" = $4 AND (NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToExamination" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ($10=$11 AND ("public"."Examination"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) OR EXISTS(SELECT "t4"."B" FROM "public"."_BranchToExamination" AS "t4" INNER JOIN "public"."Branch" AS "j4" ON ("j4"."id") = ("t4"."A") WHERE ("j4"."id" IN ($5) AND ("public"."Examination"."id") = ("t4"."B") AND "t4"."B" IS NOT NULL)))) ORDER BY "public"."Examination"."id" ASC LIMIT $6 OFFSET $7

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Order" AS "j3" ON ("j3"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."branchId" IN ($7) AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND "j3"."createdAt" >= $9 AND "j3"."createdAt" <= $10 AND ("j3"."id" IS NOT NULL)) OR ("j5"."branchId" = $11 AND ("j6"."clinicDomain" = $12 AND ("j6"."id" IS NOT NULL)) AND "j5"."from" >= $13 AND "j5"."from" <= $14 AND "j5"."status" <> CAST($15::text AS "public"."SessionStatus") AND ("j5"."id" IS NOT NULL)) OR (("j8"."clinicDomain" = $16 AND ("j8"."id" IS NOT NULL)) AND "j7"."createdAt" >= $17 AND "j7"."createdAt" <= $18 AND ("j7"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($19::text AS "public"."InvoiceStatus")) OFFSET $20 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-fbfeb8d7a36fc034-01' */) AS "sub" /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-fbfeb8d7a36fc034-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j2" ON ("j2"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j4" ON ("j4"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."createdAt" >= $3 AND "j0"."createdAt" <= $4 AND "j0"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j2"."status" <> CAST($6::text AS "public"."SessionStatus") AND ("j3"."clinicDomain" = $7 AND ("j3"."id" IS NOT NULL)) AND "j2"."from" >= $8 AND "j2"."from" <= $9 AND ("j2"."id" IS NOT NULL)) OR ("j5"."clinicDomain" = $10 AND ("j5"."id" IS NOT NULL) AND ("j4"."id" IS NOT NULL)))) OFFSET $11 /* traceparent='00-dbbce86a5ffc516ddcd60cb1568e29ab-167054399d9c1653-01' */) AS "sub" /* traceparent='00-dbbce86a5ffc516ddcd60cb1568e29ab-167054399d9c1653-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Logs"."id" FROM "public"."Logs" WHERE "public"."Logs"."clinicDomain" = $1 OFFSET $2 /* traceparent='00-91e66b1e55f4fe20236093ceedae3136-771958c27346f4d6-01' */) AS "sub" /* traceparent='00-91e66b1e55f4fe20236093ceedae3136-771958c27346f4d6-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Order" AS "j4" ON ("j4"."id") = ("j0"."orderId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Session" AS "j6" ON ("j6"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j8" ON ("j8"."id") = ("j0"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToPackageSubscription" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ((NOT "j2"."id" = $2) AND ("j1"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL)) AND ("j3"."clinicDomain" = $3 AND ("j3"."id" IS NOT NULL)) AND "j1"."createdAt" >= $4 AND "j1"."createdAt" <= $5 AND "j1"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR ("j4"."branchId" IN ($7) AND ("j5"."clinicDomain" = $8 AND ("j5"."id" IS NOT NULL)) AND "j4"."createdAt" >= $9 AND "j4"."createdAt" <= $10 AND ("j4"."id" IS NOT NULL)) OR ("j6"."branchId" = $11 AND ("j7"."clinicDomain" = $12 AND ("j7"."id" IS NOT NULL)) AND "j6"."from" >= $13 AND "j6"."from" <= $14 AND "j6"."status" <> CAST($15::text AS "public"."SessionStatus") AND ("j6"."id" IS NOT NULL)) OR (("j9"."clinicDomain" = $16 AND ("j9"."id" IS NOT NULL)) AND "j8"."createdAt" >= $17 AND "j8"."createdAt" <= $18 AND ("j8"."id" IS NOT NULL))) AND "j0"."status" = CAST($19::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $20 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-7e1b65d35b6c74a3-01' */) AS "sub" /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-7e1b65d35b6c74a3-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."Expense"."amount" FROM "public"."Expense" WHERE ("public"."Expense"."clinicDomain" = $1 AND "public"."Expense"."date" >= $2 AND "public"."Expense"."date" <= $3 AND "public"."Expense"."branchId" IN ($4)) OFFSET $5 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-23323a0845f984c4-01' */) AS "sub" /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-23323a0845f984c4-01' */

SELECT "public"."Invoice"."id" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j2" ON ("j2"."sessionId") = ("j0"."id") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ("j0"."branchId" = $2 AND ("j1"."clinicDomain" = $3 AND ("j1"."id" IS NOT NULL)) AND ("j0"."doctorId" IN ($4) OR (EXISTS(SELECT "t3"."invoiceId" FROM "public"."InvoiceUnit" AS "t3" WHERE ("t3"."doctorId" IN ($5) AND ("j2"."id") = ("t3"."invoiceId") AND "t3"."invoiceId" IS NOT NULL)) AND ("j2"."id" IS NOT NULL))) AND ("j0"."id" IS NOT NULL))) OFFSET $6 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-dc219f9a1cc8822f-01' */

SELECT SUM("points") AS "_sum$points" FROM (SELECT "public"."LoyaltyTransaction"."points" FROM "public"."LoyaltyTransaction" LEFT JOIN "public"."PatientLoyalty" AS "j0" ON ("j0"."id") = ("public"."LoyaltyTransaction"."patientLoyaltyId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientId") WHERE (("j1"."clinicDomain" = $1 AND ("j1"."id" IS NOT NULL) AND ("j0"."id" IS NOT NULL)) AND "public"."LoyaltyTransaction"."type" = CAST($2::text AS "public"."TransactionType") AND "public"."LoyaltyTransaction"."status" = CAST($3::text AS "public"."TransactionStatus")) OFFSET $4 /* traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-9980011d929fbaab-01' */) AS "sub" /* traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-9980011d929fbaab-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Order" AS "j8" ON ("j8"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND ((("j3"."clinicDomain" = $7 AND ("j3"."id" IS NOT NULL) AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($8::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $9 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $10 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $11 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-a87033e8e510a46a-01' */) AS "sub" /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-a87033e8e510a46a-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor" FROM (SELECT "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Order" AS "j8" ON ("j8"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND (((("j3"."clinicDomain" = $4 AND ("j3"."id" IS NOT NULL)) AND "j2"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($6::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $7 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $8 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $9 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $10 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-b2002805228e42a9-01' */) AS "sub" /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-b2002805228e42a9-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Order" AS "j8" ON ("j8"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND ((("j3"."clinicDomain" = $5 AND ("j3"."id" IS NOT NULL) AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($6::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $7 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $8 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $9 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $10 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-0b3bba00e198e4eb-01' */) AS "sub" /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-0b3bba00e198e4eb-01' */

SELECT "public"."UniqueText"."id", "public"."UniqueText"."type"::text, "public"."UniqueText"."text", "public"."UniqueText"."clinicDomain", "public"."UniqueText"."createdAt", "public"."UniqueText"."updatedAt" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."text" ILIKE $2 AND "public"."UniqueText"."clinicDomain" = $3) ORDER BY "public"."UniqueText"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-6c4bdca56735adce43740490154ac862-8b9cd449eb341d02-01' */

Covered by index on (clinicDomain, type, createdAt)
Rows: 175221
Row progression: 175221, 730, 6

Row estimates
- clinicDomain (=): 730
- type (=): 1436
- text (~~*): 17522
- createdAt (sort): 1

Existing indexes
- id PRIMARY
- clinicDomain, type, createdAt
- text, clinicDomain, type UNIQUE

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $9 AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $11 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j9"."branchId" IN ($12) AND ("j10"."clinicDomain" = $13 AND ("j10"."id" IS NOT NULL)) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $14 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-851de1567ad45bd5-01' */) AS "sub" /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-851de1567ad45bd5-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor" FROM (SELECT "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $4) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $5 AND ("j4"."id" IS NOT NULL)) AND "j2"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $7 AND ("j6"."clinicDomain" = $8 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $9 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j9"."branchId" IN ($10) AND ("j10"."clinicDomain" = $11 AND ("j10"."id" IS NOT NULL)) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-f85324ca7bf8097e-01' */) AS "sub" /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-f85324ca7bf8097e-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."UniqueText"."id" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."text" ILIKE $2 AND "public"."UniqueText"."clinicDomain" = $3) OFFSET $4 /* traceparent='00-6c4bdca56735adce43740490154ac862-a7cd4fd78f2ce40e-01' */) AS "sub" /* traceparent='00-6c4bdca56735adce43740490154ac862-a7cd4fd78f2ce40e-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $5) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $7 AND ("j6"."clinicDomain" = $8 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $9 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j9"."branchId" IN ($10) AND ("j10"."clinicDomain" = $11 AND ("j10"."id" IS NOT NULL)) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-e8e0c53073251e0e-01' */) AS "sub" /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-e8e0c53073251e0e-01' */

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Order" AS "j2" ON ("j2"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."createdAt" >= $3 AND "j0"."createdAt" <= $4 AND "j0"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR (("j3"."clinicDomain" = $6 AND ("j3"."id" IS NOT NULL)) AND "j2"."createdAt" >= $7 AND "j2"."createdAt" <= $8 AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" <> CAST($9::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $10 AND ("j5"."id" IS NOT NULL)) AND "j4"."from" >= $11 AND "j4"."from" <= $12 AND ("j4"."id" IS NOT NULL)) OR (("j7"."clinicDomain" = $13 AND ("j7"."id" IS NOT NULL)) AND "j6"."createdAt" >= $14 AND "j6"."createdAt" <= $15 AND ("j6"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($16::text AS "public"."InvoiceStatus")) OFFSET $17 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-521c636397f243eb-01' */) AS "sub" /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-521c636397f243eb-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."branchId" = $7 AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $9 AND "j3"."from" <= $10 AND "j3"."status" <> CAST($11::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $12 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL)))) OFFSET $13 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-3fb9172d4ecccb4e-01' */) AS "sub" /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-3fb9172d4ecccb4e-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Order" AS "j3" ON ("j3"."id") = ("j0"."orderId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j0"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((("j2"."clinicDomain" = $2 AND ("j2"."id" IS NOT NULL)) AND "j1"."createdAt" >= $3 AND "j1"."createdAt" <= $4 AND "j1"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR (("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND "j3"."createdAt" >= $7 AND "j3"."createdAt" <= $8 AND ("j3"."id" IS NOT NULL)) OR ("j5"."status" <> CAST($9::text AS "public"."SessionStatus") AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND "j5"."from" >= $11 AND "j5"."from" <= $12 AND ("j5"."id" IS NOT NULL)) OR (("j8"."clinicDomain" = $13 AND ("j8"."id" IS NOT NULL)) AND "j7"."createdAt" >= $14 AND "j7"."createdAt" <= $15 AND ("j7"."id" IS NOT NULL))) AND "j0"."status" = CAST($16::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $17 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-3afd65acc32893e2-01' */) AS "sub" /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-3afd65acc32893e2-01' */

SELECT MAX("serialNumber") AS "_max$serialNumber" FROM (SELECT "public"."Invoice"."serialNumber" FROM "public"."Invoice" WHERE "public"."Invoice"."clinicDomain" = $1 OFFSET $2 /* traceparent='00-25df44523a40d65692b5acffb6122b1d-81a046ffce8112d5-01' */) AS "sub" /* traceparent='00-25df44523a40d65692b5acffb6122b1d-81a046ffce8112d5-01' */

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") WHERE (("j0"."status" <> CAST($1::text AS "public"."SessionStatus") AND ("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."from" >= $3 AND "j0"."from" <= $4 AND ("j0"."id" IS NOT NULL)) AND "public"."Invoice"."clinicDomain" = $5) OFFSET $6 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-4b17cf53e60984af-01' */) AS "sub" /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-4b17cf53e60984af-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."LoyaltyTransaction"."id" FROM "public"."LoyaltyTransaction" LEFT JOIN "public"."PatientLoyalty" AS "j0" ON ("j0"."id") = ("public"."LoyaltyTransaction"."patientLoyaltyId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientId") WHERE (("j1"."clinicDomain" = $1 AND ("j1"."id" IS NOT NULL) AND ("j0"."id" IS NOT NULL)) AND "public"."LoyaltyTransaction"."createdAt" >= $2) OFFSET $3 /* traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-0f272d851e7e31fa-01' */) AS "sub" /* traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-0f272d851e7e31fa-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $8 AND ("j4"."clinicDomain" = $9 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $10 AND "j5"."branchId" = $11 AND ("j6"."clinicDomain" = $12 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $13 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $14 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-284739d5af463b3b-01' */) AS "sub" /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-284739d5af463b3b-01' */

SELECT "public"."Invoice"."id", "public"."Invoice"."sessionId", "public"."Invoice"."orderId", "public"."Invoice"."accommodationId", "public"."Invoice"."note", "public"."Invoice"."status"::text, "public"."Invoice"."paymentStatus"::text, "public"."Invoice"."ownerId", "public"."Invoice"."total", "public"."Invoice"."totalTax", "public"."Invoice"."subTotal", "public"."Invoice"."discountValue", "public"."Invoice"."tierBenefitDiscount", "public"."Invoice"."rewardDiscount", "public"."Invoice"."appliedTierBenefit", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "public"."Invoice"."insuranceCoverageAmount", "public"."Invoice"."patientDeductibleAmount", "public"."Invoice"."insuranceDiscountAmount", "public"."Invoice"."forDoctor", "public"."Invoice"."forManagers", "public"."Invoice"."insurancePolicyClassId", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."paymentAttach", "public"."Invoice"."clinicDomain", "public"."Invoice"."createdAt", "public"."Invoice"."updatedAt", "public"."Invoice"."link", "public"."Invoice"."points", "public"."Invoice"."consumablesTotal", "public"."Invoice"."consumablesPayByPatient", "public"."Invoice"."closingShiftId", "public"."Invoice"."isLocked", "public"."Invoice"."serialNumber" FROM "public"."Invoice" WHERE ("public"."Invoice"."status" = CAST($1::text AS "public"."InvoiceStatus") AND "public"."Invoice"."restNotPaid" > $2 AND "public"."Invoice"."clinicDomain" = $3) ORDER BY "public"."Invoice"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-faea614d08285f62d27b044136be25d9-e18e04e9c0a9a5fa-01' */

CREATE INDEX CONCURRENTLY ON Invoice (clinicDomain, restNotPaid)

Rows: 606351
Row progression: 606351, 2972, 299

Row estimates
- clinicDomain (=): 2972
- restNotPaid (>): 60908
- status (=): 202117
- createdAt (sort): 1

Existing indexes
- id PRIMARY
- accommodationId UNIQUE
- clinicDomain, serialNumber UNIQUE
- closingShiftId
- orderId UNIQUE
- sessionId UNIQUE

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."doctorId" = $3 AND ("j2"."clinicDomain" = $4 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $5 AND "j0"."createdAt" <= $6 AND "j0"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $8 AND "j3"."branchId" = $9 AND ("j4"."clinicDomain" = $10 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $11 AND "j3"."from" <= $12 AND "j3"."status" <> CAST($13::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR (("j6"."clinicDomain" = $14 AND ("j6"."id" IS NOT NULL)) AND "j5"."createdAt" >= $15 AND "j5"."createdAt" <= $16 AND ("j5"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($17::text AS "public"."InvoiceStatus")) OFFSET $18 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-e77b7e2389911fd3-01' */) AS "sub" /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-e77b7e2389911fd3-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j0"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToPackageSubscription" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ((NOT "j2"."id" = $2) AND ("j1"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL)) AND "j1"."doctorId" = $3 AND ("j3"."clinicDomain" = $4 AND ("j3"."id" IS NOT NULL)) AND "j1"."createdAt" >= $5 AND "j1"."createdAt" <= $6 AND "j1"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR ("j4"."doctorId" = $8 AND "j4"."branchId" = $9 AND ("j5"."clinicDomain" = $10 AND ("j5"."id" IS NOT NULL)) AND "j4"."from" >= $11 AND "j4"."from" <= $12 AND "j4"."status" <> CAST($13::text AS "public"."SessionStatus") AND ("j4"."id" IS NOT NULL)) OR (("j7"."clinicDomain" = $14 AND ("j7"."id" IS NOT NULL)) AND "j6"."createdAt" >= $15 AND "j6"."createdAt" <= $16 AND ("j6"."id" IS NOT NULL))) AND "j0"."status" = CAST($17::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $18 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-bd4db2b7b2e3511a-01' */) AS "sub" /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-bd4db2b7b2e3511a-01' */

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") WHERE (("j0"."status" = CAST($1::text AS "public"."SessionStatus") AND ("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."from" >= $3 AND "j0"."from" <= $4 AND ("j0"."id" IS NOT NULL)) AND "public"."Invoice"."clinicDomain" = $5) OFFSET $6 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-3f3dd0e7f6273bc2-01' */) AS "sub" /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-3f3dd0e7f6273bc2-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $5) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $6 AND ("j4"."clinicDomain" = $7 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $8 AND "j5"."branchId" = $9 AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $11 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-a837b6c9b36cc238-01' */) AS "sub" /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-a837b6c9b36cc238-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."doctorId" = $3 AND ("j2"."clinicDomain" = $4 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $5 AND "j0"."createdAt" <= $6 AND "j0"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $8 AND "j3"."branchId" = $9 AND ("j4"."clinicDomain" = $10 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $11 AND "j3"."from" <= $12 AND "j3"."status" <> CAST($13::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $14 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL)))) OFFSET $15 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-e4d272fdb3d7a31d-01' */) AS "sub" /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-e4d272fdb3d7a31d-01' */

SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."referredById", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE ("public"."PatientProfile"."isActive" = $1 AND "public"."PatientProfile"."clinicDomain" = $2) ORDER BY "public"."PatientProfile"."id" ASC LIMIT $3 OFFSET $4 /* traceparent='00-a2623476b8d5528121a04a7655574d98-440c3b0e0b136b6c-01' */

Covered by index on (clinicDomain, patientIndex)
Rows: 248755
Row progression: 248755, 1051, 525

Row estimates
- clinicDomain (=): 1051
- isActive (=): 124378
- id (sort): 1

Existing indexes
- id PRIMARY
- clinicDomain, link UNIQUE
- clinicDomain, patientIndex UNIQUE
- referredById

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."PatientProfile"."id" FROM "public"."PatientProfile" WHERE "public"."PatientProfile"."clinicDomain" = $1 OFFSET $2 /* traceparent='00-2a8ebdf35bf07e52e3b3b525b59a341b-4f7c8e3818840e93-01' */) AS "sub" /* traceparent='00-2a8ebdf35bf07e52e3b3b525b59a341b-4f7c8e3818840e93-01' */

SELECT "public"."Logs"."id", "public"."Logs"."operationType"::text, "public"."Logs"."details", "public"."Logs"."description", "public"."Logs"."diff", "public"."Logs"."type"::text, "public"."Logs"."userId", "public"."Logs"."clinicDomain", "public"."Logs"."patientProfileId", "public"."Logs"."patientProfileSettingsId", "public"."Logs"."sessionId", "public"."Logs"."operationDetailsId", "public"."Logs"."sessionSettingsId", "public"."Logs"."medicalReportId", "public"."Logs"."examinationId", "public"."Logs"."createdAt", "public"."Logs"."accountantSettingsId", "public"."Logs"."clinicFeaturesId", "public"."Logs"."prescriptionId", "public"."Logs"."targetUserId", "public"."Logs"."packageId", "public"."Logs"."branchId", "public"."Logs"."clinicId", "public"."Logs"."formResponseId", "public"."Logs"."packageSubscriptionId", "public"."Logs"."paymentTransactionId", "public"."Logs"."updatedAt" FROM "public"."Logs" WHERE "public"."Logs"."clinicDomain" = $1 ORDER BY "public"."Logs"."createdAt" DESC LIMIT $2 OFFSET $3

CREATE INDEX CONCURRENTLY ON Logs (clinicDomain, createdAt)

Rows: 1420308
Row progression: 1420308, 6312, 0

Row estimates
- clinicDomain (=): 6312
- createdAt (sort): 1

Existing indexes
- id PRIMARY

SELECT "public"."Prescription"."id", "public"."Prescription"."name", "public"."Prescription"."noteId", "public"."Prescription"."previewUrl", "public"."Prescription"."isTemplate", "public"."Prescription"."sessionId", "public"."Prescription"."clinicDomain", "public"."Prescription"."order", "public"."Prescription"."link", "public"."Prescription"."createdAt", "public"."Prescription"."updatedAt", "public"."Prescription"."patientProfileId", "public"."Prescription"."nextAppointment", "public"."Prescription"."designTemplate" FROM "public"."Prescription" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Prescription"."sessionId") WHERE ((("j0"."patientProfileId" = $1 AND ("j0"."id" IS NOT NULL)) OR "public"."Prescription"."patientProfileId" = $2) AND "public"."Prescription"."clinicDomain" = $3) ORDER BY "public"."Prescription"."id" ASC LIMIT $4 OFFSET $5 /* traceparent='00-370597fc1a7fc67874646eb2b37aa7ba-8b58facde2449c7a-01' */

SELECT SUM("public"."LoyaltyTransaction"."points") AS "_sum$points", COUNT(*) AS "_count$_all", "public"."LoyaltyTransaction"."earnSource"::text FROM "public"."LoyaltyTransaction" LEFT JOIN "public"."PatientLoyalty" AS "j0" ON ("j0"."id") = ("public"."LoyaltyTransaction"."patientLoyaltyId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientId") WHERE (("j1"."clinicDomain" = $1 AND ("j1"."id" IS NOT NULL) AND ("j0"."id" IS NOT NULL)) AND "public"."LoyaltyTransaction"."type" = CAST($2::text AS "public"."TransactionType") AND "public"."LoyaltyTransaction"."status" = CAST($3::text AS "public"."TransactionStatus")) GROUP BY "public"."LoyaltyTransaction"."earnSource" OFFSET $4 /* traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-d4b06273ee4137bc-01' */

SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2) AND ($4=$5 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $3

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Order" AS "j3" ON ("j3"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."branchId" IN ($7) AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND "j3"."createdAt" >= $9 AND "j3"."createdAt" <= $10 AND ("j3"."id" IS NOT NULL)) OR ("j5"."shiftId" = $11 AND "j5"."branchId" = $12 AND ("j6"."clinicDomain" = $13 AND ("j6"."id" IS NOT NULL)) AND "j5"."from" >= $14 AND "j5"."from" <= $15 AND "j5"."status" <> CAST($16::text AS "public"."SessionStatus") AND ("j5"."id" IS NOT NULL)) OR (("j8"."clinicDomain" = $17 AND ("j8"."id" IS NOT NULL)) AND "j7"."createdAt" >= $18 AND "j7"."createdAt" <= $19 AND ("j7"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($20::text AS "public"."InvoiceStatus")) OFFSET $21 /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-3d533c5d70c59d74-01' */) AS "sub" /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-3d533c5d70c59d74-01' */

SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3) AND ($5=$6 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $4

SELECT "public"."Examination"."id", "public"."Examination"."name", "public"."Examination"."isActive", "public"."Examination"."price", "public"."Examination"."specialties"::text[], "public"."Examination"."defaultTime", "public"."Examination"."isDefault", "public"."Examination"."isMultiple", "public"."Examination"."isOperation", "public"."Examination"."clinicDomain", "public"."Examination"."order", "public"."Examination"."createdAt", "public"."Examination"."updatedAt", "public"."Examination"."doctorPercentage", "public"."Examination"."doctorFixedBonus", "public"."Examination"."managerPercentage", "public"."Examination"."managerFixedBonus", "public"."Examination"."category", "public"."Examination"."generalTags", "public"."Examination"."image", "public"."Examination"."color", "public"."Examination"."taxApplicable", "public"."Examination"."visitModes"::text[] FROM "public"."Examination" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ("j0"."from" >= $1 AND "j0"."from" <= $2 AND ("public"."Examination"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND (EXISTS(SELECT "t1"."B" FROM "public"."_BranchToExamination" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ("j1"."id" = $3 AND ("public"."Examination"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) OR NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToExamination" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ($7=$8 AND ("public"."Examination"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL))) AND "public"."Examination"."clinicDomain" = $4) ORDER BY "public"."Examination"."id" ASC LIMIT $5 OFFSET $6

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Prescription"."id" FROM "public"."Prescription" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Prescription"."sessionId") WHERE ((("j0"."patientProfileId" = $1 AND ("j0"."id" IS NOT NULL)) OR "public"."Prescription"."patientProfileId" = $2) AND "public"."Prescription"."clinicDomain" = $3) OFFSET $4 /* traceparent='00-370597fc1a7fc67874646eb2b37aa7ba-8ffdfc22a66db491-01' */) AS "sub" /* traceparent='00-370597fc1a7fc67874646eb2b37aa7ba-8ffdfc22a66db491-01' */

SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."aiSummary", "public"."PatientProfile"."aiSummaryGeneratedAt", "public"."PatientProfile"."aiSummaryData", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."referredById", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE (("public"."PatientProfile"."name" ILIKE $1 OR "public"."PatientProfile"."phone" ILIKE $2) AND "public"."PatientProfile"."clinicDomain" = $3) ORDER BY "public"."PatientProfile"."isActive" DESC, "public"."PatientProfile"."createdAt" DESC LIMIT $4 OFFSET $5

SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."referredById", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE ("public"."PatientProfile"."isActive" = $1 AND ("public"."PatientProfile"."name" ILIKE $2 OR "public"."PatientProfile"."phone" = $3) AND "public"."PatientProfile"."id" <> $4 AND "public"."PatientProfile"."clinicDomain" = $5) ORDER BY "public"."PatientProfile"."id" ASC LIMIT $6 OFFSET $7 /* traceparent='00-4694bf8a8ad6f060f468627052b06058-c77806b7905dd820-01' */

SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4) AND ($6=$7 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $5

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."PatientLoyalty"."id" FROM "public"."PatientLoyalty" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PatientLoyalty"."patientId") WHERE ("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) OFFSET $2 /* traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-af51ee73f52d3ae4-01' */) AS "sub" /* traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-af51ee73f52d3ae4-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Order" AS "j8" ON ("j8"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" = CAST($1::text AS "public"."PaymentMethod") AND ("j0"."clinicDomain" = $2 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $3 AND "public"."PaymentTransaction"."createdAt" <= $4 AND "public"."PaymentTransaction"."amount" >= $5 AND ((("j3"."clinicDomain" = $6 AND ("j3"."id" IS NOT NULL) AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($7::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $8 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $9 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $10 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $11 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-a6cb3602880f80fc-01' */) AS "sub" /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-a6cb3602880f80fc-01' */

SELECT "public"."Invoice"."id" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j2" ON ("j2"."sessionId") = ("j0"."id") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ("j0"."shiftId" = $2 AND "j0"."branchId" = $3 AND ("j1"."clinicDomain" = $4 AND ("j1"."id" IS NOT NULL)) AND ("j0"."doctorId" IN ($5) OR (EXISTS(SELECT "t3"."invoiceId" FROM "public"."InvoiceUnit" AS "t3" WHERE ("t3"."doctorId" IN ($6) AND ("j2"."id") = ("t3"."invoiceId") AND "t3"."invoiceId" IS NOT NULL)) AND ("j2"."id" IS NOT NULL))) AND ("j0"."id" IS NOT NULL))) OFFSET $7 /* traceparent='00-a3dffe95dece6f5e3610869643d9ff56-d4af5a0029364e3a-01' */

SELECT "public"."PatientLoyalty"."id", "public"."PatientLoyalty"."patientId", "public"."PatientLoyalty"."points", "public"."PatientLoyalty"."tier"::text, "public"."PatientLoyalty"."createdAt", "public"."PatientLoyalty"."updatedAt" FROM "public"."PatientLoyalty" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PatientLoyalty"."patientId") WHERE ("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) ORDER BY "public"."PatientLoyalty"."points" DESC LIMIT $2 OFFSET $3 /* traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-fc8f564b00d63818-01' */

SELECT COUNT(*) AS "_count$_all", "public"."PatientLoyalty"."tier"::text FROM "public"."PatientLoyalty" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PatientLoyalty"."patientId") WHERE ("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) GROUP BY "public"."PatientLoyalty"."tier" OFFSET $2 /* traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-65998cf1e32f8761-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."TreasuryTransaction"."id" FROM "public"."TreasuryTransaction" LEFT JOIN "public"."Treasury" AS "j0" ON ("j0"."id") = ("public"."TreasuryTransaction"."treasuryId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."TreasuryTransaction"."createdAt" >= $2 AND "public"."TreasuryTransaction"."createdAt" <= $3) OFFSET $4 /* traceparent='00-a2277d6805040827ea492e9a254d2d94-f7b55cd7fc8aa196-01' */) AS "sub" /* traceparent='00-a2277d6805040827ea492e9a254d2d94-f7b55cd7fc8aa196-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."TreasuryTransaction"."amount" FROM "public"."TreasuryTransaction" LEFT JOIN "public"."Treasury" AS "j0" ON ("j0"."id") = ("public"."TreasuryTransaction"."treasuryId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."TreasuryTransaction"."createdAt" >= $2 AND "public"."TreasuryTransaction"."createdAt" <= $3 AND "public"."TreasuryTransaction"."amount" > $4) OFFSET $5 /* traceparent='00-a2277d6805040827ea492e9a254d2d94-e2c0e8654c0b6a34-01' */) AS "sub" /* traceparent='00-a2277d6805040827ea492e9a254d2d94-e2c0e8654c0b6a34-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."Expense"."amount" FROM "public"."Expense" WHERE ("public"."Expense"."clinicDomain" = $1 AND "public"."Expense"."date" >= $2 AND "public"."Expense"."date" <= $3) OFFSET $4 /* traceparent='00-6054470d14d5644eab09e9bfc21848fb-b4d870aece7110f4-01' */) AS "sub" /* traceparent='00-6054470d14d5644eab09e9bfc21848fb-b4d870aece7110f4-01' */

SELECT "public"."Invoice"."id", "public"."Invoice"."sessionId", "public"."Invoice"."orderId", "public"."Invoice"."accommodationId", "public"."Invoice"."note", "public"."Invoice"."status"::text, "public"."Invoice"."paymentStatus"::text, "public"."Invoice"."ownerId", "public"."Invoice"."total", "public"."Invoice"."totalTax", "public"."Invoice"."subTotal", "public"."Invoice"."discountValue", "public"."Invoice"."tierBenefitDiscount", "public"."Invoice"."rewardDiscount", "public"."Invoice"."appliedTierBenefit", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "public"."Invoice"."insuranceCoverageAmount", "public"."Invoice"."patientDeductibleAmount", "public"."Invoice"."insuranceDiscountAmount", "public"."Invoice"."forDoctor", "public"."Invoice"."forManagers", "public"."Invoice"."insurancePolicyClassId", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."paymentAttach", "public"."Invoice"."clinicDomain", "public"."Invoice"."createdAt", "public"."Invoice"."updatedAt", "public"."Invoice"."link", "public"."Invoice"."points", "public"."Invoice"."consumablesTotal", "public"."Invoice"."consumablesPayByPatient", "public"."Invoice"."closingShiftId", "public"."Invoice"."isLocked", "public"."Invoice"."serialNumber" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."Order" AS "j2" ON ("j2"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") WHERE (((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $1) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."status" <> CAST($2::text AS "public"."PackageSubscriptionStatus") AND "j0"."startDate" >= $3 AND "j0"."startDate" <= $4 AND ("j0"."id" IS NOT NULL)) OR ("j2"."branchId" = $5 AND "j2"."createdAt" >= $6 AND "j2"."createdAt" <= $7 AND ("j2"."id" IS NOT NULL)) OR ("j3"."date" >= $8 AND "j3"."date" <= $9 AND "j3"."status" <> CAST($10::text AS "public"."SessionStatus") AND "j3"."branchId" = $11 AND ("j3"."id" IS NOT NULL))) AND "public"."Invoice"."clinicDomain" = $12) ORDER BY "public"."Invoice"."id" DESC LIMIT $13 OFFSET $14 /* traceparent='00-172ca8a0c250ad1e7c8e4b53a789a232-5c9d18ae321e8281-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" = CAST($1::text AS "public"."PaymentMethod") AND ("j0"."clinicDomain" = $2 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $3 AND "public"."PaymentTransaction"."createdAt" <= $4 AND "public"."PaymentTransaction"."amount" >= $5 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $6) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $7 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $8 AND ("j6"."clinicDomain" = $9 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $10 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j9"."branchId" IN ($11) AND ("j10"."clinicDomain" = $12 AND ("j10"."id" IS NOT NULL)) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $13 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-d5b8161d7dab7c01-01' */) AS "sub" /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-d5b8161d7dab7c01-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Order" AS "j4" ON ("j4"."id") = ("j0"."orderId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Session" AS "j6" ON ("j6"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j8" ON ("j8"."id") = ("j0"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToPackageSubscription" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ((NOT "j2"."id" = $2) AND ("j1"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL)) AND ("j3"."clinicDomain" = $3 AND ("j3"."id" IS NOT NULL)) AND "j1"."createdAt" >= $4 AND "j1"."createdAt" <= $5 AND "j1"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR ("j4"."branchId" IN ($7) AND ("j5"."clinicDomain" = $8 AND ("j5"."id" IS NOT NULL)) AND "j4"."createdAt" >= $9 AND "j4"."createdAt" <= $10 AND ("j4"."id" IS NOT NULL)) OR ("j6"."shiftId" = $11 AND "j6"."branchId" = $12 AND ("j7"."clinicDomain" = $13 AND ("j7"."id" IS NOT NULL)) AND "j6"."from" >= $14 AND "j6"."from" <= $15 AND "j6"."status" <> CAST($16::text AS "public"."SessionStatus") AND ("j6"."id" IS NOT NULL)) OR (("j9"."clinicDomain" = $17 AND ("j9"."id" IS NOT NULL)) AND "j8"."createdAt" >= $18 AND "j8"."createdAt" <= $19 AND ("j8"."id" IS NOT NULL))) AND "j0"."status" = CAST($20::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $21 /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-d6b8a3e1a7df81a1-01' */) AS "sub" /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-d6b8a3e1a7df81a1-01' */

UPDATE "public"."Invoice" SET "status" = CAST($1::text AS "public"."InvoiceStatus"), "updatedAt" = $2 WHERE ("public"."Invoice"."status" = CAST($3::text AS "public"."InvoiceStatus") AND EXISTS(SELECT "t0"."id" FROM "public"."Session" AS "t0" WHERE ("t0"."status" = CAST($4::text AS "public"."SessionStatus") AND ("public"."Invoice"."sessionId") = ("t0"."id") AND "t0"."id" IS NOT NULL))) /* traceparent='00-eaf9b18a3f9fb7a3771c3f444564ac1b-2b47d73a04d30b7c-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor" FROM (SELECT "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $4) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $5 AND ("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND "j2"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $8 AND "j5"."branchId" = $9 AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $11 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-37258bc12d410087-01' */) AS "sub" /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-37258bc12d410087-01' */

SELECT "public"."Logs"."id" FROM "public"."Logs" WHERE ("public"."Logs"."type" IN (CAST($1::text AS "public"."Models"),CAST($2::text AS "public"."Models")) AND "public"."Logs"."createdAt" < $3) ORDER BY "public"."Logs"."id" ASC LIMIT $4 OFFSET $5 /* traceparent='00-2214a6181e071e5702c9187d27e04276-39a99e3117ae26cc-01' */

CREATE INDEX CONCURRENTLY ON Logs (type, createdAt)

Rows: 1420308
Row progression: 1420308, 31562, 3156

Row estimates
- type (=): 31562
- createdAt (<): 142031
- id (sort): 1

Existing indexes
- id PRIMARY

SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5) AND ($7=$8 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $6

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."shiftId" = $9 AND "j5"."branchId" = $10 AND ("j6"."clinicDomain" = $11 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $12 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j9"."branchId" IN ($13) AND ("j10"."clinicDomain" = $14 AND ("j10"."id" IS NOT NULL)) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $15 /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-fada85767b73a637-01' */) AS "sub" /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-fada85767b73a637-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor" FROM (SELECT "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $4) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $5 AND ("j4"."id" IS NOT NULL)) AND "j2"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j5"."shiftId" = $7 AND "j5"."branchId" = $8 AND ("j6"."clinicDomain" = $9 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $10 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j9"."branchId" IN ($11) AND ("j10"."clinicDomain" = $12 AND ("j10"."id" IS NOT NULL)) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $13 /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-99f19590a600c2ce-01' */) AS "sub" /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-99f19590a600c2ce-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $5) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."shiftId" = $7 AND "j5"."branchId" = $8 AND ("j6"."clinicDomain" = $9 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $10 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j9"."branchId" IN ($11) AND ("j10"."clinicDomain" = $12 AND ("j10"."id" IS NOT NULL)) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $13 /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-c6228793fa6b209b-01' */) AS "sub" /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-c6228793fa6b209b-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $5) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $6 AND ("j4"."clinicDomain" = $7 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $8 AND "j5"."shiftId" = $9 AND "j5"."branchId" = $10 AND ("j6"."clinicDomain" = $11 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $12 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $13 /* traceparent='00-59d3e87a93529f638a6c4e815697689f-3815d31ee6ab8107-01' */) AS "sub" /* traceparent='00-59d3e87a93529f638a6c4e815697689f-3815d31ee6ab8107-01' */

SELECT SUM("tierBenefitDiscount") AS "_sum$tierBenefitDiscount" FROM (SELECT "public"."Invoice"."tierBenefitDiscount" FROM "public"."Invoice" WHERE ("public"."Invoice"."clinicDomain" = $1 AND "public"."Invoice"."tierBenefitDiscount" > $2) OFFSET $3 /* traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-3e7c79a983928b94-01' */) AS "sub" /* traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-3e7c79a983928b94-01' */

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."doctorId" = $3 AND ("j2"."clinicDomain" = $4 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $5 AND "j0"."createdAt" <= $6 AND "j0"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $8 AND "j3"."shiftId" = $9 AND "j3"."branchId" = $10 AND ("j4"."clinicDomain" = $11 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $12 AND "j3"."from" <= $13 AND "j3"."status" <> CAST($14::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR (("j6"."clinicDomain" = $15 AND ("j6"."id" IS NOT NULL)) AND "j5"."createdAt" >= $16 AND "j5"."createdAt" <= $17 AND ("j5"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($18::text AS "public"."InvoiceStatus")) OFFSET $19 /* traceparent='00-59d3e87a93529f638a6c4e815697689f-773b2ae537e51f28-01' */) AS "sub" /* traceparent='00-59d3e87a93529f638a6c4e815697689f-773b2ae537e51f28-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $8 AND ("j4"."clinicDomain" = $9 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $10 AND "j5"."shiftId" = $11 AND "j5"."branchId" = $12 AND ("j6"."clinicDomain" = $13 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $14 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $15 /* traceparent='00-59d3e87a93529f638a6c4e815697689f-66fbe83014c4f732-01' */) AS "sub" /* traceparent='00-59d3e87a93529f638a6c4e815697689f-66fbe83014c4f732-01' */

SELECT "public"."WeightTracking"."id", "public"."WeightTracking"."weightId", "public"."WeightTracking"."heightId", "public"."WeightTracking"."nutritionProfileId", "public"."WeightTracking"."dietId", "public"."WeightTracking"."dietInDetails", "public"."WeightTracking"."files", "public"."WeightTracking"."water", "public"."WeightTracking"."sleep", "public"."WeightTracking"."exercise", "public"."WeightTracking"."stress", "public"."WeightTracking"."muscles", "public"."WeightTracking"."fat", "public"."WeightTracking"."abdominalObesity", "public"."WeightTracking"."patientDietId", "public"."WeightTracking"."sessionId", "public"."WeightTracking"."createdAt", "public"."WeightTracking"."updatedAt" FROM "public"."WeightTracking" LEFT JOIN "public"."VariablePropertyValue" AS "orderby_1" ON ("orderby_1"."id") = ("public"."WeightTracking"."weightId") LEFT JOIN "public"."NutritionProfile" AS "j0" ON ("j0"."id") = ("public"."WeightTracking"."nutritionProfileId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") WHERE ("public"."WeightTracking"."nutritionProfileId" = $1 AND ("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL) AND ("j0"."id" IS NOT NULL))) ORDER BY "orderby_1"."createdAt" DESC LIMIT $3 OFFSET $4 /* traceparent='00-40bbf5e326456ec4c23d4332cf685456-9a7e9bc0ece7fdff-01' */

SELECT "public"."PrescriptionUnit"."id", "public"."PrescriptionUnit"."isTemplate", "public"."PrescriptionUnit"."medicineId", "public"."PrescriptionUnit"."repetitionId", "public"."PrescriptionUnit"."periodId", "public"."PrescriptionUnit"."noteId", "public"."PrescriptionUnit"."order", "public"."PrescriptionUnit"."clinicDomain", "public"."PrescriptionUnit"."createdAt", "public"."PrescriptionUnit"."updatedAt" FROM "public"."PrescriptionUnit" LEFT JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("public"."PrescriptionUnit"."medicineId") LEFT JOIN "public"."UniqueText" AS "j1" ON ("j1"."id") = ("public"."PrescriptionUnit"."repetitionId") LEFT JOIN "public"."UniqueText" AS "j2" ON ("j2"."id") = ("public"."PrescriptionUnit"."periodId") LEFT JOIN "public"."UniqueText" AS "j3" ON ("j3"."id") = ("public"."PrescriptionUnit"."noteId") WHERE ("public"."PrescriptionUnit"."clinicDomain" = $1 AND ("j0"."text" = $2 AND "j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND ("j1"."text" = $4 AND "j1"."clinicDomain" = $5 AND ("j1"."id" IS NOT NULL)) AND ("j2"."text" = $6 AND "j2"."clinicDomain" = $7 AND ("j2"."id" IS NOT NULL)) AND ("j3"."text" = $8 AND "j3"."clinicDomain" = $9 AND ("j3"."id" IS NOT NULL))) LIMIT $10 OFFSET $11 /* traceparent='00-19857c9c37b4f31591639b7e452dabc7-ff3dc7365a76cd34-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."shiftId" = $7 AND "j3"."branchId" = $8 AND ("j4"."clinicDomain" = $9 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $10 AND "j3"."from" <= $11 AND "j3"."status" <> CAST($12::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $13 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL)))) OFFSET $14) AS "sub"

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."doctorId" = $3 AND ("j2"."clinicDomain" = $4 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $5 AND "j0"."createdAt" <= $6 AND "j0"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $8 AND "j3"."shiftId" = $9 AND "j3"."branchId" = $10 AND ("j4"."clinicDomain" = $11 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $12 AND "j3"."from" <= $13 AND "j3"."status" <> CAST($14::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $15 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL)))) OFFSET $16 /* traceparent='00-9fc4009bff1c838b582ffa712f12fd10-5038af83cad26cc5-01' */) AS "sub" /* traceparent='00-9fc4009bff1c838b582ffa712f12fd10-5038af83cad26cc5-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j0"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToPackageSubscription" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ((NOT "j2"."id" = $2) AND ("j1"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL)) AND "j1"."doctorId" = $3 AND ("j3"."clinicDomain" = $4 AND ("j3"."id" IS NOT NULL)) AND "j1"."createdAt" >= $5 AND "j1"."createdAt" <= $6 AND "j1"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR ("j4"."doctorId" = $8 AND "j4"."shiftId" = $9 AND "j4"."branchId" = $10 AND ("j5"."clinicDomain" = $11 AND ("j5"."id" IS NOT NULL)) AND "j4"."from" >= $12 AND "j4"."from" <= $13 AND "j4"."status" <> CAST($14::text AS "public"."SessionStatus") AND ("j4"."id" IS NOT NULL)) OR (("j7"."clinicDomain" = $15 AND ("j7"."id" IS NOT NULL)) AND "j6"."createdAt" >= $16 AND "j6"."createdAt" <= $17 AND ("j6"."id" IS NOT NULL))) AND "j0"."status" = CAST($18::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $19 /* traceparent='00-59d3e87a93529f638a6c4e815697689f-87e5ab45e553db39-01' */) AS "sub" /* traceparent='00-59d3e87a93529f638a6c4e815697689f-87e5ab45e553db39-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."TreasuryTransaction"."amount" FROM "public"."TreasuryTransaction" LEFT JOIN "public"."Treasury" AS "j0" ON ("j0"."id") = ("public"."TreasuryTransaction"."treasuryId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."TreasuryTransaction"."createdAt" >= $2 AND "public"."TreasuryTransaction"."createdAt" <= $3 AND "public"."TreasuryTransaction"."amount" < $4) OFFSET $5 /* traceparent='00-a2277d6805040827ea492e9a254d2d94-0e41351de6d9c344-01' */) AS "sub" /* traceparent='00-a2277d6805040827ea492e9a254d2d94-0e41351de6d9c344-01' */

SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6) AND ($8=$9 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $7

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $5) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $7 AND "j5"."branchId" = $8 AND ("j6"."clinicDomain" = $9 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $10 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $11 /* traceparent='00-4f004af6c5aa0a422148c5578f4500d7-cbda212df649c00f-01' */) AS "sub" /* traceparent='00-4f004af6c5aa0a422148c5578f4500d7-cbda212df649c00f-01' */

SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6,$7,$8) AND ($10=$11 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $9

SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9) AND ($11=$12 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $10

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."PackageSubscription"."id" FROM "public"."PackageSubscription" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PackageSubscription"."patientProfileId") WHERE ("public"."PackageSubscription"."status" IN (CAST($1::text AS "public"."PackageSubscriptionStatus"),CAST($2::text AS "public"."PackageSubscriptionStatus"),CAST($3::text AS "public"."PackageSubscriptionStatus")) AND ("j0"."clinicDomain" = $4 AND ("j0"."id" IS NOT NULL))) OFFSET $5 /* traceparent='00-1631167fa67bf1f8217acf223182416d-183d5afb46715e10-01' */) AS "sub" /* traceparent='00-1631167fa67bf1f8217acf223182416d-183d5afb46715e10-01' */

SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10) AND ($12=$13 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $11

SELECT "public"."LaserSession"."id", "public"."LaserSession"."amount", "public"."LaserSession"."quantity", "public"."LaserSession"."examinationId", "public"."LaserSession"."overridePrice", "public"."LaserSession"."sessionId", "public"."LaserSession"."patientId", "public"."LaserSession"."area", "public"."LaserSession"."power", "public"."LaserSession"."duration", "public"."LaserSession"."remarks", "public"."LaserSession"."frequency", "public"."LaserSession"."doctorAssistant", "public"."LaserSession"."createdAt", "public"."LaserSession"."updatedAt" FROM "public"."LaserSession" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."LaserSession"."sessionId") LEFT JOIN "public"."Session" AS "j1" ON ("j1"."id") = ("public"."LaserSession"."sessionId") WHERE (("public"."LaserSession"."patientId" = $1 OR ("j0"."patientProfileId" = $2 AND ("j0"."id" IS NOT NULL))) AND ("j1"."clinicDomain" = $3 AND ("j1"."id" IS NOT NULL))) ORDER BY "public"."LaserSession"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-596158abcb37433111b3510724de5dfc-f9e216d541909c15-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $9 AND "j5"."branchId" = $10 AND ("j6"."clinicDomain" = $11 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $12 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $13 /* traceparent='00-4f004af6c5aa0a422148c5578f4500d7-6125bad3bca09766-01' */) AS "sub" /* traceparent='00-4f004af6c5aa0a422148c5578f4500d7-6125bad3bca09766-01' */

SELECT "public"."VariablePropertyValue"."id", "public"."VariablePropertyValue"."value", "public"."VariablePropertyValue"."propertyId", "public"."VariablePropertyValue"."createdAt", "public"."VariablePropertyValue"."updatedAt", "public"."VariablePropertyValue"."patientProfileId" FROM "public"."VariablePropertyValue" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."VariablePropertyValue"."patientProfileId") WHERE ("public"."VariablePropertyValue"."patientProfileId" = $1 AND ("j0"."clinicDomain" = $2 AND ("j0"."id" IS NOT NULL))) ORDER BY "public"."VariablePropertyValue"."createdAt" DESC LIMIT $3 OFFSET $4 /* traceparent='00-36ddb4ea77cbfb5b5705acc337b4adb0-f7c26cf2f2c53708-01' */

SELECT "public"."TreasuryTransaction"."id", "public"."TreasuryTransaction"."treasuryId", "public"."TreasuryTransaction"."amount", "public"."TreasuryTransaction"."description", "public"."TreasuryTransaction"."isInternal", "public"."TreasuryTransaction"."byId", "public"."TreasuryTransaction"."expenseId", "public"."TreasuryTransaction"."paymentTransactionId", "public"."TreasuryTransaction"."insuranceClaimId", "public"."TreasuryTransaction"."fromTreasuryId", "public"."TreasuryTransaction"."autoGenerated", "public"."TreasuryTransaction"."documents", "public"."TreasuryTransaction"."createdAt", "public"."TreasuryTransaction"."updatedAt" FROM "public"."TreasuryTransaction" WHERE "public"."TreasuryTransaction"."treasuryId" IN ($1) OFFSET $2

CREATE INDEX CONCURRENTLY ON TreasuryTransaction (treasuryId)

Rows: 67905
Row progression: 67905, 531

Row estimates
- treasuryId (=): 531

Existing indexes
- id PRIMARY
- expenseId UNIQUE
- insuranceClaimId UNIQUE
- paymentTransactionId UNIQUE

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Invoice"."id" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."Order" AS "j2" ON ("j2"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") WHERE (((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $1) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."status" <> CAST($2::text AS "public"."PackageSubscriptionStatus") AND "j0"."startDate" >= $3 AND "j0"."startDate" <= $4 AND ("j0"."id" IS NOT NULL)) OR ("j2"."branchId" = $5 AND "j2"."createdAt" >= $6 AND "j2"."createdAt" <= $7 AND ("j2"."id" IS NOT NULL)) OR ("j3"."date" >= $8 AND "j3"."date" <= $9 AND "j3"."status" <> CAST($10::text AS "public"."SessionStatus") AND "j3"."branchId" = $11 AND ("j3"."id" IS NOT NULL))) AND "public"."Invoice"."clinicDomain" = $12) OFFSET $13 /* traceparent='00-172ca8a0c250ad1e7c8e4b53a789a232-dc46ff9110bf704d-01' */) AS "sub" /* traceparent='00-172ca8a0c250ad1e7c8e4b53a789a232-dc46ff9110bf704d-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Invoice"."id" FROM "public"."Invoice" WHERE ("public"."Invoice"."status" = CAST($1::text AS "public"."InvoiceStatus") AND "public"."Invoice"."restNotPaid" > $2 AND "public"."Invoice"."clinicDomain" = $3) OFFSET $4 /* traceparent='00-faea614d08285f62d27b044136be25d9-bfcd4507ffe2140f-01' */) AS "sub" /* traceparent='00-faea614d08285f62d27b044136be25d9-bfcd4507ffe2140f-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE ("public"."Session"."doctorId" = $1 AND "public"."Session"."from" >= $2 AND "public"."Session"."from" <= $3 AND "public"."Session"."status" = CAST($4::text AS "public"."SessionStatus") AND "public"."Session"."branchId" = $5 AND EXISTS(SELECT "t0"."B" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Examination" AS "j0" ON ("j0"."id") = ("t0"."A") WHERE ("j0"."id" = $6 AND ("public"."Session"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL))) OFFSET $7 /* traceparent='00-aeb2d1e0f7ad461f85c5d7b9347dc48c-614845f434e6011c-01' */) AS "sub" /* traceparent='00-aeb2d1e0f7ad461f85c5d7b9347dc48c-614845f434e6011c-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."VariablePropertyValue"."id" FROM "public"."VariablePropertyValue" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."VariablePropertyValue"."patientProfileId") WHERE ("public"."VariablePropertyValue"."patientProfileId" = $1 AND ("j0"."clinicDomain" = $2 AND ("j0"."id" IS NOT NULL))) OFFSET $3 /* traceparent='00-36ddb4ea77cbfb5b5705acc337b4adb0-36f6ffdf1dc56ca5-01' */) AS "sub" /* traceparent='00-36ddb4ea77cbfb5b5705acc337b4adb0-36f6ffdf1dc56ca5-01' */

SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1) AND ($3=$4 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $2

SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) AND ($13=$14 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $12

SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6,$7) AND ($9=$10 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $8

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $7 AND "j3"."branchId" = $8 AND ("j4"."clinicDomain" = $9 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $10 AND "j3"."from" <= $11 AND "j3"."status" <> CAST($12::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR (("j6"."clinicDomain" = $13 AND ("j6"."id" IS NOT NULL)) AND "j5"."createdAt" >= $14 AND "j5"."createdAt" <= $15 AND ("j5"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($16::text AS "public"."InvoiceStatus")) OFFSET $17 /* traceparent='00-4f004af6c5aa0a422148c5578f4500d7-4e7c502d69707271-01' */) AS "sub" /* traceparent='00-4f004af6c5aa0a422148c5578f4500d7-4e7c502d69707271-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE ("public"."Session"."doctorId" = $1 AND "public"."Session"."from" >= $2 AND "public"."Session"."from" <= $3 AND "public"."Session"."status" NOT IN (CAST($4::text AS "public"."SessionStatus"),CAST($5::text AS "public"."SessionStatus")) AND "public"."Session"."branchId" = $6 AND EXISTS(SELECT "t0"."B" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Examination" AS "j0" ON ("j0"."id") = ("t0"."A") WHERE ("j0"."id" = $7 AND ("public"."Session"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL))) OFFSET $8 /* traceparent='00-aeb2d1e0f7ad461f85c5d7b9347dc48c-f02afd16908b2648-01' */) AS "sub" /* traceparent='00-aeb2d1e0f7ad461f85c5d7b9347dc48c-f02afd16908b2648-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."WeightTracking"."id" FROM "public"."WeightTracking" LEFT JOIN "public"."NutritionProfile" AS "j0" ON ("j0"."id") = ("public"."WeightTracking"."nutritionProfileId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") WHERE ("public"."WeightTracking"."nutritionProfileId" = $1 AND ("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL) AND ("j0"."id" IS NOT NULL))) OFFSET $3 /* traceparent='00-40bbf5e326456ec4c23d4332cf685456-3034c7c736acc6f4-01' */) AS "sub" /* traceparent='00-40bbf5e326456ec4c23d4332cf685456-3034c7c736acc6f4-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE ("public"."Session"."from" >= $1 AND "public"."Session"."from" <= $2 AND "public"."Session"."status" = CAST($3::text AS "public"."SessionStatus") AND EXISTS(SELECT "t0"."B" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Examination" AS "j0" ON ("j0"."id") = ("t0"."A") WHERE ("j0"."id" = $4 AND ("public"."Session"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL))) OFFSET $5 /* traceparent='00-2c1f0e355ca8eafa306ba681438d785e-d94288a09eed6e1d-01' */) AS "sub" /* traceparent='00-2c1f0e355ca8eafa306ba681438d785e-d94288a09eed6e1d-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE ("public"."Session"."from" >= $1 AND "public"."Session"."from" <= $2 AND "public"."Session"."status" NOT IN (CAST($3::text AS "public"."SessionStatus"),CAST($4::text AS "public"."SessionStatus")) AND EXISTS(SELECT "t0"."B" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Examination" AS "j0" ON ("j0"."id") = ("t0"."A") WHERE ("j0"."id" = $5 AND ("public"."Session"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL))) OFFSET $6 /* traceparent='00-2c1f0e355ca8eafa306ba681438d785e-cc30540a0c381e3e-01' */) AS "sub" /* traceparent='00-2c1f0e355ca8eafa306ba681438d785e-cc30540a0c381e3e-01' */

SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."referredById", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE (("public"."PatientProfile"."name" ILIKE $1 OR "public"."PatientProfile"."phone" ILIKE $2 OR "public"."PatientProfile"."phone" ILIKE $3 OR "public"."PatientProfile"."patientIndex" = $4) AND "public"."PatientProfile"."clinicDomain" = $5) ORDER BY "public"."PatientProfile"."isActive" DESC, "public"."PatientProfile"."createdAt" DESC LIMIT $6 OFFSET $7 /* traceparent='00-b4cb1a65e77ab70036fe14ca3a115dd7-2dd0e26c707582df-01' */